switchy_database 0.5.0

Switchy database package
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
97
98
99

#![cfg(all(feature = "sqlite-rusqlite", feature = "schema"))]

use std::sync::Arc;
use switchy_database::{
    Database, DatabaseValue,
    query::select,
    rusqlite::{RusqliteDatabase, relax_integer_nullability_on_connection, select_on_connection},
    schema::{Column, DataType, create_index},
};

fn column(name: &str) -> Column {
    Column {
        name: name.into(),
        data_type: DataType::BigInt,
        nullable: false,
        auto_increment: false,
        default: None,
    }
}

#[tokio::test]
async fn indexed_column_failure_rolls_back_partial_ddl_without_committing_owner() {
    let connection = Arc::new(switchy_async::sync::Mutex::new(
        rusqlite::Connection::open_in_memory().unwrap(),
    ));
    let db = RusqliteDatabase::new(vec![Arc::clone(&connection)]);
    db.create_table("limits")
        .column(column("cap"))
        .execute(&db)
        .await
        .unwrap();
    create_index("cap_index")
        .table("limits")
        .column("cap")
        .execute(&db)
        .await
        .unwrap();
    db.insert("limits")
        .value("cap", 17_i64)
        .execute(&db)
        .await
        .unwrap();
    drop(db);
    let mut guard = connection.lock().await;
    let transaction = guard.transaction().unwrap();
    assert!(relax_integer_nullability_on_connection(&transaction, "limits", "cap").is_err());
    assert!(!transaction.is_autocommit());
    let rows = select_on_connection(&transaction, &select("limits")).unwrap();
    assert_eq!(rows[0].columns.len(), 1, "temporary column rolled back");
    assert_eq!(rows[0].get("cap"), Some(DatabaseValue::Int64(17)));
    transaction.commit().unwrap();
    drop(guard);
    let db = RusqliteDatabase::new(vec![connection]);
    assert!(!db.get_table_columns("limits").await.unwrap()[0].nullable);
    assert!(
        db.get_table_info("limits")
            .await
            .unwrap()
            .unwrap()
            .indexes
            .contains_key("cap_index")
    );
}

#[tokio::test]
async fn adversarial_identifiers_and_autocommit_fail_closed() {
    let connection = Arc::new(switchy_async::sync::Mutex::new(
        rusqlite::Connection::open_in_memory().unwrap(),
    ));
    let db = RusqliteDatabase::new(vec![Arc::clone(&connection)]);
    db.create_table("sentinel")
        .column(column("cap"))
        .execute(&db)
        .await
        .unwrap();
    db.insert("sentinel")
        .value("cap", i64::MAX)
        .execute(&db)
        .await
        .unwrap();
    drop(db);
    let mut guard = connection.lock().await;
    assert!(relax_integer_nullability_on_connection(&guard, "sentinel", "cap").is_err());
    let transaction = guard.transaction().unwrap();
    for (table, name) in [
        ("sentinel; DROP TABLE sentinel; --", "cap"),
        ("sentinel", "cap\"; DROP TABLE sentinel; --"),
        ("sentinel", "cap, other"),
    ] {
        assert!(relax_integer_nullability_on_connection(&transaction, table, name).is_err());
        assert!(!transaction.is_autocommit());
    }
    relax_integer_nullability_on_connection(&transaction, "sentinel", "cap").unwrap();
    assert_eq!(
        select_on_connection(&transaction, &select("sentinel")).unwrap()[0].get("cap"),
        Some(DatabaseValue::Int64(i64::MAX))
    );
    transaction.rollback().unwrap();
}