SeaORM Test

Cargo.toml

[package]
name = "sea-orm-test"
version = "0.1.0"
edition = "2021"

[dependencies]
sea-orm = { version = "0.4.2", features = [ "sqlx-sqlite", "runtime-tokio-native-tls", "macros" ], default-features = false }
tokio = { version = "1", features = ["full"] }

main.rs

use sea_orm::{ConnectOptions, ConnectionTrait, Database, DbErr, QueryResult, Statement};

#[tokio::main]
async fn main() {
    let opt = ConnectOptions::new("sqlite::memory:".to_string());
    let db = Database::connect(opt).await.unwrap();

    db.execute(Statement::from_string(
        db.get_database_backend(),
        "CREATE TABLE Persons (PersonID int);".to_owned(),
    ))
    .await
    .unwrap();

    // db.execute(Statement::from_string(
    //     db.get_database_backend(),
    //     "INSERT INTO Persons(PersonID) VALUES (5);".to_owned(),
    // ))
    // .await
    // .unwrap();

    let query: Option<QueryResult> = db
        .query_one(Statement::from_string(
            db.get_database_backend(),
            "SELECT 1 AS 'a' FROM 'Persons';".to_owned(),
        ))
        .await
        .unwrap();
    assert!(query.is_some()); // This should always be true but isn't

    let result: Result<u32, DbErr> = query.unwrap().try_get("", "a");
    assert!(result == Ok(1 as u32));
}