ormer 0.2.7

A minimalist ORM framework that supports SQLite, PostgreSQL, MySQL, and SqlServer
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
96

#![cfg(any(feature = "duckdb", feature = "clickhouse"))]

#[cfg(any(feature = "duckdb", feature = "clickhouse"))]
use ormer::{DbType, IsolationLevel, OrmerError, TransactionOptions};

#[tokio::test]
#[cfg(feature = "duckdb")]
async fn duckdb_transaction_options_are_capability_gated() -> Result<(), Box<dyn std::error::Error>>
{
    let db = ormer::Database::connect(DbType::DuckDB, ":memory:").await?;

    for options in [
        TransactionOptions::new().isolation(IsolationLevel::Serializable),
        TransactionOptions::new().read_only(),
    ] {
        let error = db
            .transaction_opts(options, |_txn| Box::pin(async { Ok(()) }))
            .await
            .expect_err("DuckDB transaction options must be capability gated");
        assert!(matches!(
            error,
            OrmerError::UnsupportedFeature {
                backend: DbType::DuckDB,
                feature: "transaction options on DuckDB",
            }
        ));
    }

    db.transaction(|_txn| Box::pin(async { Ok(()) })).await?;
    Ok(())
}

#[tokio::test]
#[cfg(feature = "clickhouse")]
async fn clickhouse_transactions_are_capability_gated() -> Result<(), Box<dyn std::error::Error>> {
    let db = ormer::Database::connect(DbType::ClickHouse, "http://localhost:8123").await?;

    let error = db
        .transaction(|_txn| Box::pin(async { Ok(()) }))
        .await
        .expect_err("ClickHouse transactions must be capability gated");
    assert!(matches!(
        error,
        OrmerError::UnsupportedFeature {
            backend: DbType::ClickHouse,
            feature: "transactions on ClickHouse",
        }
    ));

    let error = db
        .transaction_opts(TransactionOptions::new().read_only(), |_txn| {
            Box::pin(async { Ok(()) })
        })
        .await
        .expect_err("ClickHouse transaction_opts must be capability gated");
    assert!(matches!(
        error,
        OrmerError::UnsupportedFeature {
            backend: DbType::ClickHouse,
            feature: "transactions on ClickHouse",
        }
    ));

    let pool = ormer::Database::create_pool(DbType::ClickHouse, "http://localhost:8123")
        .range(0..1)
        .build()
        .await?;
    let connection = pool.get().await?;
    let error = connection
        .transaction(|_txn| Box::pin(async { Ok(()) }))
        .await
        .expect_err("ClickHouse pooled transactions must be capability gated");
    assert!(matches!(
        error,
        OrmerError::UnsupportedFeature {
            backend: DbType::ClickHouse,
            feature: "transactions on ClickHouse",
        }
    ));

    let error = connection
        .transaction_opts(TransactionOptions::new().read_only(), |_txn| {
            Box::pin(async { Ok(()) })
        })
        .await
        .expect_err("ClickHouse pooled transaction_opts must be capability gated");
    assert!(matches!(
        error,
        OrmerError::UnsupportedFeature {
            backend: DbType::ClickHouse,
            feature: "transactions on ClickHouse",
        }
    ));

    Ok(())
}