Wh^<dZddlZddlZddlmZddlmZdZdZy)a db.py Purpose: Encapsulate SQLite connection lifecycle, providing `get_db()` for obtaining a request-scoped connection and `register_teardown(app)` to close it after the request. This mirrors Flask's application context pattern and keeps DB logic out of `app.py`. Exports: - get_db(): returns a sqlite3.Row-based connection stored on flask.g - register_teardown(app): registers a teardown handler to close the DB N)g)ROOT_DIRcttdd}|tjdxs$tjj t d}tj|}tj|_ |jd|jd|jd|t_ |S#t$rYwxYw)N _database DATABASE_PATHz theialogin.dbzPRAGMA journal_mode=WALzPRAGMA synchronous=NORMALzPRAGMA foreign_keys=ON)getattrrosgetenvpathjoinrsqlite3connectRow row_factoryexecute Exceptionr)dbdb_paths Ac:\Users\algun\Documents\ceba web\Ceba - Github\app_modules\db.pyget_dbrs K &B z))O,W X0W __W %   JJ0 1 JJ2 3 JJ/ 0 I   s:3B:: CCc(|jd}y)NcLttdd}||jyy)Nr)r rclose) exceptionrs rclose_connectionz+register_teardown..close_connection(s# Q T * > HHJ )teardown_appcontext)apprs rregister_teardownr 'sr) __doc__rr flaskrpathsrrr rrr%s"  $r