diff options
| author | Frederick Muriuki Muriithi | 2023-01-18 11:47:04 +0300 |
|---|---|---|
| committer | Frederick Muriuki Muriithi | 2023-01-18 11:52:35 +0300 |
| commit | 0f0b7f875cf88c85ee35caf24793ffbefe9f0906 (patch) | |
| tree | 02dfde0fc5f75312a23c1a9a3fada5202a9f3ef8 /gn3/auth/db.py | |
| parent | b6ff005d4040b1a70230df42a91a0cbee42c3031 (diff) | |
| download | genenetwork3-0f0b7f875cf88c85ee35caf24793ffbefe9f0906.tar.gz | |
auth: Enable FOREIGN KEY constraint for the connections
Enable the FOREIGN KEY constraints for the connections to the database to help
with queries that would otherwise lead to data corruption.
Diffstat (limited to 'gn3/auth/db.py')
| -rw-r--r-- | gn3/auth/db.py | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/gn3/auth/db.py b/gn3/auth/db.py index 256940d..b74f341 100644 --- a/gn3/auth/db.py +++ b/gn3/auth/db.py @@ -51,6 +51,7 @@ def connection(db_path: str, row_factory: Callable = sqlite3.Row) -> Iterator[Db """Create the connection to the auth database.""" conn = sqlite3.connect(db_path) conn.row_factory = row_factory + conn.execute("PRAGMA foreign_keys = ON") try: yield conn except sqlite3.Error as exc: |