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 { + 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