rs-zero 0.2.21

Rust-first microservice framework inspired by go-zero engineering practices
Documentation
#![cfg(feature = "db-sqlite")]

use rs_zero::db::{DatabaseConfig, DatabaseError, connect_pool, health_check, run_transaction};

#[tokio::test]
async fn sqlite_pool_health_and_transaction_helper_work() {
    let pool = connect_pool(&DatabaseConfig::default())
        .await
        .expect("pool");
    health_check(&pool).await.expect("health");
    let value = run_transaction(&pool, |tx| {
        Box::pin(async move {
            sqlx::query("CREATE TABLE users (id INTEGER PRIMARY KEY)")
                .execute(&mut *tx)
                .await?;
            sqlx::query("INSERT INTO users (id) VALUES (1)")
                .execute(&mut *tx)
                .await?;
            let count: (i64,) = sqlx::query_as("SELECT COUNT(*) FROM users")
                .fetch_one(&mut *tx)
                .await?;
            Ok(count.0)
        })
    })
    .await
    .expect("transaction");
    assert_eq!(value, 1);
}

#[tokio::test]
async fn sqlite_run_transaction_rolls_back_on_error() {
    let pool = connect_pool(&DatabaseConfig::default())
        .await
        .expect("pool");
    sqlx::query("CREATE TABLE users (id INTEGER PRIMARY KEY)")
        .execute(&pool)
        .await
        .expect("create table");

    let error = run_transaction(&pool, |tx| {
        Box::pin(async move {
            sqlx::query("INSERT INTO users (id) VALUES (1)")
                .execute(&mut *tx)
                .await?;
            Err::<(), _>(DatabaseError::Unsupported("rollback".to_string()))
        })
    })
    .await
    .expect_err("transaction error");

    assert!(error.to_string().contains("rollback"));
    let count: (i64,) = sqlx::query_as("SELECT COUNT(*) FROM users")
        .fetch_one(&pool)
        .await
        .expect("count");
    assert_eq!(count.0, 0);
}