diff options
Diffstat (limited to 'src/db')
| -rw-r--r-- | src/db/mod.rs | 2 | ||||
| -rw-r--r-- | src/db/utils.rs | 12 |
2 files changed, 12 insertions, 2 deletions
diff --git a/src/db/mod.rs b/src/db/mod.rs index a0aa3dc..f5facd1 100644 --- a/src/db/mod.rs +++ b/src/db/mod.rs @@ -3,4 +3,4 @@ pub mod incomes; pub mod jobs; pub mod payments; pub mod users; -mod utils; +pub mod utils; 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 |