From 0f0b7f875cf88c85ee35caf24793ffbefe9f0906 Mon Sep 17 00:00:00 2001
From: Frederick Muriuki Muriithi
Date: Wed, 18 Jan 2023 11:47:04 +0300
Subject: 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.
---
 gn3/auth/db.py | 1 +
 1 file changed, 1 insertion(+)

(limited to 'gn3')

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:
-- 
cgit v1.2.3