use anyhow::Result;
use rusqlite::Connection;

pub fn get_default_color(conn: &Connection) -> Result<String> {
    let mut stmt = conn.prepare("SELECT * FROM event_color 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())
}