#![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);
}