HE^jmTddlZddlmZddlmZdej fdZedZy)N)contextmanager)settingsreturnctjtj}tj|_|j d|j d|S)NzPRAGMA journal_mode=WALzPRAGMA foreign_keys=ON)sqlite3connectrDB_FILERow row_factoryexecuteconns (/home/container/backend/db/connection.pyget_db_connectionrsA ??8++ ,D{{DLL*+LL)* Kc#Kt} ||j |j y#t$r|jwxYw#|j wxYww)zMContext manager for sqlite3 connection with auto-commit/rollback and cleanup.N)rcommit Exceptionrollbackcloser s r db_connectionr sV  D     s% A'4A'AAA$$A')r contextlibrbackend.configr Connectionrrrrrs4%#7--  r