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()),
    }
}