X-Git-Url: https://git.phdru.name/?a=blobdiff_plain;f=xsetbg_db.py;h=e5fe5d0310927a0d2c5704f41cdd44cfffeff47d;hb=e97d0a3ca1e3b4c5d8c386fd7939e9b23d7bbbd4;hp=eedb25ffa1c4ac533dad4f2100222cffc23a4c9f;hpb=1ecc06c8b06acdd4a7589709ab27a99434ba71f8;p=xsetbg.git diff --git a/xsetbg_db.py b/xsetbg_db.py index eedb25f..e5fe5d0 100755 --- a/xsetbg_db.py +++ b/xsetbg_db.py @@ -11,17 +11,10 @@ __all__ = ['xsetbg_db_path', 'xsetbg_db'] import os from sqlobject import SQLObject, connectionForURI, sqlhub, \ - StringCol, UnicodeCol, IntCol, BoolCol, DatabaseIndex, dberrors + UnicodeCol, IntCol, BoolCol, DatabaseIndex, dberrors from xsetbg_conf import xsetbg_conf -class SqliteSequence(SQLObject): - class sqlmeta: - idName = 'rowid' - name = StringCol(unique=True) - seq = IntCol() - - class XSetBg(SQLObject): full_name = UnicodeCol(alternateID=True) last_shown = IntCol(default=None) # timestamp @@ -31,6 +24,14 @@ class XSetBg(SQLObject): flag_idx = DatabaseIndex('flag') +def recreate_db(): + global xsetbg_db + if not xsetbg_db: + xsetbg_db = XSetBg + xsetbg_db.createTable() + return xsetbg_db + + db_dirs = [] try: xsetbg_db_path = xsetbg_conf.get('xsetbg', 'database')