weird.rs

use sqlx::SqlitePool;

#[tokio::main]
async fn main() {
    let pool = SqlitePool::builder()
        .max_size(1)
        .build("sqlite3://todos.sqlite3")
        .await
        .expect("Failed to create DB pool");

    println!("{:#?}", &pool);

    let list = list_todos(&pool).await;

    println!("{:#?}", &list);
}

async fn list_todos(pool: &SqlitePool) -> anyhow::Result<()> {
    let recs = sqlx::query!(
        r#"
SELECT id, description, done
FROM todos
ORDER BY id
        "#
    )
    .fetch_all(pool)
    .await?;

    for rec in recs {
        println!(
            "- [{}] {}: {}",
            if rec.done { "x" } else { " " },
            rec.id,
            &rec.description,
        );
    }

    Ok(())
}