From c70e84a1b2aa307363b7b760f9f15b7438b0afba Mon Sep 17 00:00:00 2001
From: Joris
Date: Thu, 6 Feb 2025 18:47:40 +0100
Subject: Use pragma update to setup foreign keys

---
 src/db/utils.rs | 4 +---
 1 file changed, 1 insertion(+), 3 deletions(-)

diff --git a/src/db/utils.rs b/src/db/utils.rs
index 26435e0..30f25c9 100644
--- a/src/db/utils.rs
+++ b/src/db/utils.rs
@@ -2,9 +2,7 @@ use crate::model::report::Report;
 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;
+    let res = conn.call(move |conn| Ok(conn.pragma_update(None, "foreign_keys", "ON"))).await;
 
     if let Err(err) = res {
         log::error!("Error supporting foreign keys: {err:?}");
-- 
cgit v1.2.3