From 582c03eacbc73b851aa232c404be71b2cf77295a Mon Sep 17 00:00:00 2001
From: Joris
Date: Fri, 7 Feb 2025 10:35:20 +0100
Subject: Use strict mode for tables

---
 src/db/event_colors.rs | 14 ++++++++++++++
 1 file changed, 14 insertions(+)
 create mode 100644 src/db/event_colors.rs

(limited to 'src/db/event_colors.rs')

diff --git a/src/db/event_colors.rs b/src/db/event_colors.rs
new file mode 100644
index 0000000..62b6146
--- /dev/null
+++ b/src/db/event_colors.rs
@@ -0,0 +1,14 @@
+use anyhow::Result;
+use rusqlite::Connection;
+
+pub fn get_default_color(conn: &Connection) -> Result<String> {
+    let mut stmt = conn.prepare("SELECT * FROM event_colors LIMIT 1")?;
+
+    let iter = stmt.query_map([], |row| row.get(0))?;
+
+    let mut res = vec![];
+    for color in iter {
+        res.push(color?)
+    }
+    Ok(res.first().unwrap_or(&"blue".to_string()).clone())
+}
-- 
cgit v1.2.3