X-Git-Url: https://git.phdru.name/?a=blobdiff_plain;f=reload_db.py;h=fe25e864781546343bd97233a1c87786913c161d;hb=0ece1df14f89c4bbc0af81b7683843af225181cb;hp=d60e3ec314207c0213e745bd35c8757352afa6f7;hpb=c35e3acf494456a9ab66a307aee8eae9f167d8ed;p=xsetbg.git diff --git a/reload_db.py b/reload_db.py index d60e3ec..fe25e86 100755 --- a/reload_db.py +++ b/reload_db.py @@ -19,10 +19,10 @@ def convert_str(s): return int(float(s)) -fs_encoding = xsetbg_conf.get("images", "fs_encoding") dump_file = open(sys.argv[1], 'r') xsetbg_db = recreate_db() -count_new = count_old = 0 +count_new = count_old = count_updated = 0 +fs_encoding = xsetbg_conf.get("images", "fs_encoding") with SQLiteMassInsert() as txn: for line in dump_file: @@ -47,9 +47,14 @@ with SQLiteMassInsert() as txn: assert id is None or row.id == id if row.last_shown is not None: assert row.last_shown == timestamp - count_old += 1 + if row.full_name == filename: + count_old += 1 + else: + row.full_name = filename + count_updated += 1 dump_file.close() print "New images:", count_new print "Existing images:", count_old +print "Updated images:", count_updated