Use pragma update to setup foreign keys

1 files changed, 1 insertions, 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:?}");