]> git.phdru.name Git - xsetbg.git/commitdiff
Feat(reload_db): Update existing row if the full name was changed
authorOleg Broytman <phd@phdru.name>
Sun, 5 Mar 2023 14:05:35 +0000 (17:05 +0300)
committerOleg Broytman <phd@phdru.name>
Sun, 5 Mar 2023 14:05:35 +0000 (17:05 +0300)
Count updated rows.

reload_db.py

index d60e3ec314207c0213e745bd35c8757352afa6f7..fe25e864781546343bd97233a1c87786913c161d 100755 (executable)
@@ -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