Support foreign keys at startup

1 files changed, 11 insertions, 1 deletions

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