use anyhow::Result;
use rusqlite::Connection;
use rusqlite_migration::{Migrations, M};

pub mod cards;

pub fn init(database: String) -> Result<Connection> {
    let mut conn = Connection::open(database)?;
    let migrations = Migrations::new(vec![
        M::up(include_str!("sql/1-init.sql")),
        M::up(include_str!("sql/2-primary-key-question-responses.sql")),
        M::up(include_str!("sql/3-drop-deck-read.sql")),
    ]);
    migrations.to_latest(&mut conn)?;
    Ok(conn)
}