1 files changed, 12 insertions, 0 deletions
diff --git a/src/db/event_colors.rs b/src/db/event_colors.rs
new file mode 100644
index 0000000..bf7f541
--- /dev/null
+++ b/src/db/event_colors.rs
@@ -0,0 +1,12 @@
+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 mut iter = stmt.query_map([], |row| row.get(0))?;
+
+    match iter.next() {
+        Some(Ok(color)) => Ok(color),
+        _ => Ok("blue".to_string()),
+    }
+}