anna/emmental
anna
/
emmental
1
0
Fork 0
Code Issues 13 Pull Requests Projects 1 Releases 12 Wiki Activity
emmental/db/sql.py

16 lines
419 B
Python
Raw Permalink Normal View History

db: Move SQLite Connection stuff into a new file I find this cleaner than importing from the toplevel module Signed-off-by: Anna Schumaker <Anna@NoWheyCreamery.com>
2021-10-07 13:58:09 -04:00
# Copyright 2021 (c) Anna Schumaker.
import lib
import sqlite3
File = lib.data.emmental_data / "emmental.sqlite"
db: Set check_same_thread=False Apparently, the about-to-finish signal is called in a different thread than the main thread. SQLite complains about the connection getting used from a different thread, so we need to set this check to False so the code skips it. Signed-off-by: Anna Schumaker <Anna@NoWheyCreamery.com>
2021-11-20 17:03:18 -05:00
Connection = sqlite3.connect(File, detect_types=sqlite3.PARSE_DECLTYPES, check_same_thread=False)
db: Move SQLite Connection stuff into a new file I find this cleaner than importing from the toplevel module Signed-off-by: Anna Schumaker <Anna@NoWheyCreamery.com>
2021-10-07 13:58:09 -04:00
Connection.row_factory = sqlite3.Row
commit = Connection.commit
execute = Connection.execute
db: Occasionally optimize the database I do this whenever we commit during scanning, and during application shutdown. Signed-off-by: Anna Schumaker <Anna@NoWheyCreamery.com>
2021-12-09 22:09:40 -05:00
def optimize():
Connection.execute("PRAGMA analysis_limit=1000")
Connection.execute("PRAGMA optimize")