sqlorm 0.8.2

An ergonomic and type-safe ORM for database interactions
Documentation 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95

pub mod entities;

use sqlorm::Pool;
use sqlorm::sqlx::migrate::MigrateError;

#[cfg(feature = "postgres")]
use sqlorm::sqlx::Executor;
#[cfg(feature = "postgres")]
use uuid::Uuid;

#[cfg(feature = "postgres")]
pub async fn run_migrations(pool: &Pool) -> Result<(), MigrateError> {
    sqlorm::sqlx::migrate!("tests/common/migrations/postgres")
        .run(pool)
        .await
}

#[cfg(feature = "sqlite")]
pub async fn run_migrations(pool: &Pool) -> Result<(), MigrateError> {
    sqlorm::sqlx::migrate!("tests/common/migrations/sqlite")
        .run(pool)
        .await
}

#[cfg(feature = "postgres")]
pub async fn create_test_db() -> Pool {
    let base_url = "postgres://test:test@localhost:5432/".to_string();
    let admin_pool = Pool::connect(&base_url).await.unwrap();

    let db_name = format!("test_db_{}", Uuid::new_v4().to_string().replace("-", ""));
    admin_pool
        .execute(format!(r#"CREATE DATABASE "{}""#, db_name).as_str())
        .await
        .expect("Failed to create test database");

    let mut test_db_url = base_url.clone();
    if let Some(idx) = test_db_url.rfind('/') {
        test_db_url.replace_range(idx + 1.., &db_name);
    }

    Pool::connect(&test_db_url)
        .await
        .expect("Failed to connect to test database")
}

#[cfg(feature = "postgres")]
#[allow(dead_code)]
pub async fn setup_test_db() -> Pool {
    use std::env;
    
    let database_url = env::var("TEST_DATABASE_URL")
        .unwrap_or_else(|_| "postgres://test:test@localhost:5432/test".to_string());

    let pool = sqlorm::Pool::connect(&database_url)
        .await
        .expect("Failed to connect to PostgreSQL database");

    run_migrations(&pool)
        .await
        .expect("Failed to run migrations");

    pool
}

#[cfg(feature = "postgres")]
pub async fn create_clean_db() -> Pool {
    let pool = create_test_db().await;
    run_migrations(&pool)
        .await
        .expect("Failed to run migrations");
    pool
}

#[cfg(feature = "sqlite")]
pub async fn create_clean_db() -> Pool {
    create_memory_db().await
}

#[cfg(feature = "sqlite")]
pub async fn create_memory_db() -> Pool {
    let pool = sqlorm::Pool::connect("sqlite::memory:")
        .await
        .expect("Failed to create in-memory SQLite database");

    run_migrations(&pool)
        .await
        .expect("Failed to run migrations");

    sqlorm::sqlx::query("PRAGMA foreign_keys = ON")
        .execute(&pool)
        .await
        .expect("Failed to enable foreign keys");

    pool
}