qjBddlmZddlZddlmZd dZddd dZd dZy) ) annotationsN)Pathc8t|dk(rtjdd}nMt|j }|j j ddtj|d}tj|_|jd|S)N:memory:Fcheck_same_threadT)parentsexist_okPRAGMA foreign_keys = ON) strsqlite3connectr expanduserparentmkdirRow row_factoryexecute)db_pathconnpaths _/home/agent/.hermes/worktrees/FinanceManager-main-deploy/src/jarvis_finance/storage/database.pyrrsu 7|z!zUCG}'') $6tu={{DLL+, KT) immutablec t|jj}|rdnd}tjd|d|dd}tj |_|jd|jd |S) zNOpen an existing SQLite database without any possible persistence side effect.zmode=ro&immutable=1zmode=rozfile:?TF)urirr zPRAGMA query_only = ON)rrresolver rrrr)rrrqueryrs rconnect_read_onlyr ss = # # % - - /D%. !IE ??U4&%1tu UD{{DLL+,LL)* Krctjdd}tj|_|j d|S)NrFrr )r rrrr)rs rconnect_memoryr"s0 ??: ?D{{DLL+, Kr)r str | Pathreturnsqlite3.Connection)rr#rboolr$r%)r$r%) __future__rr pathlibrrr r"rrr*s$" AE r