ormer 0.2.10

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

#![cfg(feature = "sqlite")]

pub mod _test_common;

#[derive(Debug, ormer::Model, Clone)]
#[table = "transaction_close_protocol_close"]
struct CloseUser {
    #[primary(auto)]
    id: Option<i64>,
    name: String,
}

#[derive(Debug, ormer::Model, Clone)]
#[table = "transaction_close_protocol_drop"]
struct DropUser {
    #[primary(auto)]
    id: Option<i64>,
    name: String,
}

#[tokio::test]
async fn explicit_close_rolls_back() -> Result<(), Box<dyn std::error::Error>> {
    let db = _test_common::create_db_connection(&_test_common::sqlite_config()).await?;
    _test_common::prepare_table::<CloseUser>(&db).await?;

    let mut txn = db.begin().await?;
    txn.insert(&CloseUser {
        id: None,
        name: "not persisted".to_string(),
    })
    .execute()
    .await?;
    txn.close().await?;

    let users: Vec<CloseUser> = db.select::<CloseUser>().collect::<Vec<CloseUser>>().await?;
    assert!(users.is_empty());

    _test_common::clean_table::<CloseUser>(&db).await?;
    Ok(())
}

#[tokio::test]
async fn drop_rolls_back_active_transaction() -> Result<(), Box<dyn std::error::Error>> {
    let db = _test_common::create_db_connection(&_test_common::sqlite_config()).await?;
    _test_common::prepare_table::<DropUser>(&db).await?;

    let mut txn = db.begin().await?;
    txn.insert(&DropUser {
        id: None,
        name: "not persisted".to_string(),
    })
    .execute()
    .await?;
    drop(txn);

    let users: Vec<DropUser> = db.select::<DropUser>().collect::<Vec<DropUser>>().await?;
    assert!(users.is_empty());

    _test_common::clean_table::<DropUser>(&db).await?;
    Ok(())
}