From 232f9d98dd8aaf0302c649066da0375546f8f53a Mon Sep 17 00:00:00 2001
From: Joris
Date: Thu, 6 Feb 2025 17:53:06 +0100
Subject: Support foreign keys at startup

---
 src/db/utils.rs | 12 +++++++++++-
 1 file changed, 11 insertions(+), 1 deletion(-)

(limited to 'src/db/utils.rs')

diff --git a/src/db/utils.rs b/src/db/utils.rs
index 2ff0f13..26435e0 100644
--- a/src/db/utils.rs
+++ b/src/db/utils.rs
@@ -1,5 +1,15 @@
 use crate::model::report::Report;
-use tokio_rusqlite::Row;
+use tokio_rusqlite::{Connection, Row};
+
+pub async fn support_foreign_keys(conn: &Connection) {
+    let query = r#"PRAGMA foreign_keys = ON"#;
+
+    let res = conn.call(move |conn| Ok(conn.execute(query, [])?)).await;
+
+    if let Err(err) = res {
+        log::error!("Error supporting foreign keys: {err:?}");
+    }
+}
 
 pub fn format_key_for_search(value: &str) -> String {
     // Lower doesn’t work on accentuated letters, hence the need to remove manually accents for
-- 
cgit v1.2.3