X-Git-Url: https://git.phdru.name/?a=blobdiff_plain;f=xsetbg_db.py;h=406ca9609809caf9c77714a2b66e3091f0af7425;hb=bfa8949a6a7938586bdd4db9003d85ac0dea588a;hp=53e0e3cae7773a2716dacc2ea4c270f57c4f6f0a;hpb=cdffc4b36468a4d72497c25ec4a3bf1f54fe1b3f;p=xsetbg.git diff --git a/xsetbg_db.py b/xsetbg_db.py index 53e0e3c..406ca96 100755 --- a/xsetbg_db.py +++ b/xsetbg_db.py @@ -18,9 +18,11 @@ class XSetBg(SQLObject): full_name = UnicodeCol(alternateID=True) last_shown = IntCol(default=None) # timestamp flag = BoolCol(default=None) + is_image = BoolCol(default=None) last_shown_idx = DatabaseIndex('last_shown') flag_idx = DatabaseIndex('flag') + is_image_idx = DatabaseIndex('is_image') def recreate_db(): @@ -49,7 +51,7 @@ class SQLiteMassInsert(object): def __exit__(self, *args, **kw): sqlhub.processConnection.commit() connection = sqlhub.processConnection = self.connection - connection.query("VACUUM %s" % xsetbg_db.sqlmeta.table) + connection.query("VACUUM") db_dirs = []