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

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

use std::sync::Arc;
use switchy_database::{
    Database,
    rusqlite::RusqliteDatabase,
    schema::{Column, DataType},
};

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

#[tokio::test]
async fn schema_keys_are_identifiers_without_raw() {
    let db = RusqliteDatabase::new(vec![Arc::new(switchy_async::sync::Mutex::new(
        rusqlite::Connection::open_in_memory().unwrap(),
    ))]);
    db.create_table("parent")
        .column(column("id"))
        .primary_key("id")
        .execute(&db)
        .await
        .unwrap();
    db.create_table("child")
        .column(column("id"))
        .foreign_key(("id", "parent"))
        .execute(&db)
        .await
        .unwrap();
    let child = db.get_table_info("child").await.unwrap().unwrap();
    let reference = child.foreign_keys.values().next().unwrap();
    assert_eq!(reference.referenced_table, "parent");
    assert_eq!(reference.referenced_column, "id");
    db.insert("parent")
        .value("id", 1)
        .execute(&db)
        .await
        .unwrap();
    db.insert("child")
        .value("id", 1)
        .execute(&db)
        .await
        .unwrap();
    assert!(
        db.insert("parent")
            .value("id", 1)
            .execute(&db)
            .await
            .is_err()
    );

    #[cfg(not(feature = "raw-sql"))]
    {
        // These would form valid primary-key syntax if interpreted as SQL.
        for key in ["id DESC", "id, other", "id), UNIQUE (other"] {
            assert!(
                db.create_table("rejected")
                    .column(column("id"))
                    .column(column("other"))
                    .primary_key(key)
                    .execute(&db)
                    .await
                    .is_err()
            );
            assert!(!db.table_exists("rejected").await.unwrap());
        }
        db.create_table("parent(id)")
            .column(column("id"))
            .primary_key("id")
            .execute(&db)
            .await
            .unwrap();
        db.create_table("literal_target")
            .column(column("id"))
            .foreign_key(("id", "parent(id)"))
            .execute(&db)
            .await
            .unwrap();
        let target = db.get_table_info("literal_target").await.unwrap().unwrap();
        let reference = target.foreign_keys.values().next().unwrap();
        assert_eq!(reference.referenced_table, "parent(id)");
        assert_eq!(reference.column, "id");
    }
    db.close().await.unwrap();
}