sqlx sample code

sqlx-sample.rs

use std::result::Result;
use sqlx::{SqlitePool, FromRow};

#[derive(FromRow, Debug, PartialEq, Clone)]
struct LevelRange {
    level_num: i64,
    level_min: f64,
    level_max: f64,
}


#[tokio::main]
async fn main() {
    let db_url = String::from("sqlite:///Users/joafigu/data/ved/tile.db");

    let db = SqlitePool::connect(&db_url).await.unwrap();
    let sql = "select * from level_range;";
    let results: Result<Vec<LevelRange>, sqlx::Error> = sqlx::query_as(sql).fetch_all(&db).await;

    match results {
        Ok(rows) => {
            for row in rows {
                println!("{:?}", row);
            }
        }
        Err(_) => {
            println!("No rows found!")
        }
    }
}