+if xsetbg_db:
+ try:
+ seq = SqliteSequence.byName(XSetBg.sqlmeta.table)
+ except SQLObjectNotFound:
+ SqliteSequence(name=XSetBg.sqlmeta.table, seq=0)
+ else:
+ seq.seq = 0 # Reset autoincrement counter
+ xsetbg_db.clearTable()
+else:
+ xsetbg_db = XSetBg
+ xsetbg_db.createTable()
+
+def convert_str(s):
+ if s == "None":
+ return None
+ else:
+ return int(float(s))
+
+connection = xsetbg_db._connection
+
+connection.query("PRAGMA synchronous=OFF")
+connection.query("PRAGMA count_changes=OFF")
+connection.query("PRAGMA journal_mode=MEMORY")
+connection.query("PRAGMA temp_store=MEMORY")
+
+txn = connection.transaction()
+sqlhub.processConnection = txn
+