X-Git-Url: https://git.phdru.name/?a=blobdiff_plain;ds=sidebyside;f=xsetbg_db.py;h=dfa65fce7f307daaaac90c88daadb1143be63674;hb=1d0a0014b008e5428fb63ed21109f70d39682661;hp=53e0e3cae7773a2716dacc2ea4c270f57c4f6f0a;hpb=cdffc4b36468a4d72497c25ec4a3bf1f54fe1b3f;p=xsetbg.git diff --git a/xsetbg_db.py b/xsetbg_db.py index 53e0e3c..dfa65fc 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,13 +51,13 @@ 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 = [] try: xsetbg_db_path = xsetbg_conf.get('xsetbg', 'database') -except: +except Exception: xsetbg_db_path = None if not xsetbg_db_path: