citadeldb 0.4.0

Citadel: encrypted-first embedded database engine that outperforms unencrypted SQLite
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
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123

use citadel::{Argon2Profile, DatabaseBuilder};

fn fast_builder(path: &std::path::Path) -> DatabaseBuilder {
    DatabaseBuilder::new(path)
        .passphrase(b"enum-test")
        .argon2_profile(Argon2Profile::Iot)
}

#[test]
fn list_tables_empty() {
    let dir = tempfile::tempdir().unwrap();
    let db = fast_builder(&dir.path().join("test.db")).create().unwrap();
    let tables = db.manager().list_tables().unwrap();
    assert!(tables.is_empty());
}

#[test]
fn list_tables_single() {
    let dir = tempfile::tempdir().unwrap();
    let db = fast_builder(&dir.path().join("test.db")).create().unwrap();

    let mut wtx = db.begin_write().unwrap();
    wtx.create_table(b"users").unwrap();
    wtx.table_insert(b"users", b"k1", b"v1").unwrap();
    wtx.commit().unwrap();

    let tables = db.manager().list_tables().unwrap();
    assert_eq!(tables.len(), 1);
    assert_eq!(tables[0].0, b"users");
    assert!(tables[0].1.root_page.is_valid());
}

#[test]
fn list_tables_multiple() {
    let dir = tempfile::tempdir().unwrap();
    let db = fast_builder(&dir.path().join("test.db")).create().unwrap();

    let mut wtx = db.begin_write().unwrap();
    wtx.create_table(b"alpha").unwrap();
    wtx.create_table(b"beta").unwrap();
    wtx.create_table(b"gamma").unwrap();
    wtx.table_insert(b"alpha", b"k", b"v").unwrap();
    wtx.table_insert(b"beta", b"k", b"v").unwrap();
    wtx.table_insert(b"gamma", b"k", b"v").unwrap();
    wtx.commit().unwrap();

    let mut tables = db.manager().list_tables().unwrap();
    assert_eq!(tables.len(), 3);
    tables.sort_by(|a, b| a.0.cmp(&b.0));
    assert_eq!(tables[0].0, b"alpha");
    assert_eq!(tables[1].0, b"beta");
    assert_eq!(tables[2].0, b"gamma");
}

#[test]
fn list_tables_after_drop() {
    let dir = tempfile::tempdir().unwrap();
    let db = fast_builder(&dir.path().join("test.db")).create().unwrap();

    let mut wtx = db.begin_write().unwrap();
    wtx.create_table(b"temp").unwrap();
    wtx.create_table(b"keep").unwrap();
    wtx.table_insert(b"temp", b"k", b"v").unwrap();
    wtx.table_insert(b"keep", b"k", b"v").unwrap();
    wtx.commit().unwrap();

    let mut wtx = db.begin_write().unwrap();
    wtx.drop_table(b"temp").unwrap();
    wtx.commit().unwrap();

    let tables = db.manager().list_tables().unwrap();
    assert_eq!(tables.len(), 1);
    assert_eq!(tables[0].0, b"keep");
}

#[test]
fn table_root_exists() {
    let dir = tempfile::tempdir().unwrap();
    let db = fast_builder(&dir.path().join("test.db")).create().unwrap();

    let mut wtx = db.begin_write().unwrap();
    wtx.create_table(b"data").unwrap();
    wtx.table_insert(b"data", b"k", b"v").unwrap();
    wtx.commit().unwrap();

    let root = db.manager().table_root(b"data").unwrap();
    assert!(root.is_some());
    assert!(root.unwrap().is_valid());
}

#[test]
fn table_root_not_found() {
    let dir = tempfile::tempdir().unwrap();
    let db = fast_builder(&dir.path().join("test.db")).create().unwrap();

    let root = db.manager().table_root(b"nonexistent").unwrap();
    assert!(root.is_none());
}

#[test]
fn table_root_persistence() {
    let dir = tempfile::tempdir().unwrap();
    let path = dir.path().join("test.db");

    {
        let db = fast_builder(&path).create().unwrap();
        let mut wtx = db.begin_write().unwrap();
        wtx.create_table(b"persist").unwrap();
        wtx.table_insert(b"persist", b"k", b"v").unwrap();
        wtx.commit().unwrap();
    }

    let db = DatabaseBuilder::new(&path)
        .passphrase(b"enum-test")
        .open()
        .unwrap();
    let tables = db.manager().list_tables().unwrap();
    assert_eq!(tables.len(), 1);
    assert_eq!(tables[0].0, b"persist");

    let root = db.manager().table_root(b"persist").unwrap();
    assert!(root.is_some());
}