use wyrd_sqlite::Connection;

fn main() -> anyhow::Result<()> {
    let conn = Connection::open("")?;

    conn.execute(
        "CREATE TABLE pairs (
            a INTEGER PRIMARY KEY,
            b INTEGER
        )",
        (),
    )?;

    let (mut insert, _) = conn.prepare("INSERT INTO pairs (a, b) VALUES (?, ?)")?;

    insert.execute((23, ()))?;
    insert.execute((3, 33))?;
    insert.execute(((), 5))?;

    let (mut stmt, _) = conn.prepare("SELECT * FROM pairs")?;
    let mut query = stmt.query(())?;

    while let Some(mut row) = query.try_next_row()? {
        let a: i32 = { row.get(0)? };
        let b: Option<i32> = { row.get(1)? };

        println!("{a}, {b:?}");
    }

    Ok(())
}