Use anyhow Error

2 files changed, 21 insertions, 12 deletions

diff --git a/src/db/mod.rs b/src/db/mod.rs
index f5facd1..1282f0c 100644
--- a/src/db/mod.rs
+++ b/src/db/mod.rs
@@ -1,6 +1,25 @@
+use anyhow::{Error, Result};
+use tokio_rusqlite::Connection;
+
 pub mod categories;
 pub mod incomes;
 pub mod jobs;
 pub mod payments;
 pub mod users;
-pub mod utils;
+mod utils;
+
+pub async fn init(path: &str) -> Result<Connection> {
+    let connection = Connection::open(path).await.map_err(|err| {
+        Error::msg(format!("Error opening connection: {err}"))
+    })?;
+
+    support_foreign_keys(&connection).await?;
+
+    Ok(connection)
+}
+
+async fn support_foreign_keys(conn: &Connection) -> Result<()> {
+    Ok(conn
+        .call(move |conn| Ok(conn.pragma_update(None, "foreign_keys", "ON")))
+        .await??)
+}
diff --git a/src/db/utils.rs b/src/db/utils.rs
index bd4d867..2ff0f13 100644
--- a/src/db/utils.rs
+++ b/src/db/utils.rs
@@ -1,15 +1,5 @@
 use crate::model::report::Report;
-use tokio_rusqlite::{Connection, Row};
-
-pub async fn support_foreign_keys(conn: &Connection) {
-    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:?}");
-    }
-}
+use tokio_rusqlite::Row;
 
 pub fn format_key_for_search(value: &str) -> String {
     // Lower doesn’t work on accentuated letters, hence the need to remove manually accents for