agdb 0.12.10

Agnesoft Graph Database
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
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138

mod test_db;

use agdb::DbError;
use agdb::QueryBuilder;
use test_db::TestDb;

#[test]
fn insert_empty_index() {
    let mut db = TestDb::new();
    db.exec_mut(QueryBuilder::insert().index("username").query(), 0);
}

#[test]
fn insert_index_with_existing_data() {
    let mut db = TestDb::new();
    db.exec_mut(
        QueryBuilder::insert()
            .nodes()
            .values([
                vec![("username", "user1").into(), ("age", 20).into()],
                vec![("username", "user2").into()],
                vec![("username", "user3").into(), ("age", 33).into()],
            ])
            .query(),
        3,
    );
    db.exec_mut(
        QueryBuilder::insert()
            .edges()
            .from(1)
            .to(2)
            .values([[("username", "user4").into()]])
            .query(),
        1,
    );

    db.exec_mut(QueryBuilder::insert().index("username").query(), 4);
}

#[test]
fn insert_existing_index() {
    let mut db = TestDb::new();
    db.exec_mut(QueryBuilder::insert().index("username").query(), 0);
    db.exec_mut_error(
        QueryBuilder::insert().index("username").query(),
        "Index 'username' already exists",
    );
}

#[test]
fn insert_index_rollback() {
    let mut db = TestDb::new();
    db.transaction_mut_error(
        |t| {
            t.exec_mut(QueryBuilder::insert().index("username").query())?;
            t.exec_mut(
                QueryBuilder::insert()
                    .nodes()
                    .values([
                        [("username", "user1").into()],
                        [("username", "user2").into()],
                        [("username", "user3").into()],
                    ])
                    .query(),
            )?;
            t.exec_mut(QueryBuilder::insert().index("username").query())?;
            Ok(())
        },
        DbError::from("Index 'username' already exists"),
    );
    db.exec(QueryBuilder::select().indexes().query(), 0);
}

#[test]
fn insert_indexed_value() {
    let mut db = TestDb::new();
    db.exec_mut(QueryBuilder::insert().index("username").query(), 0);
    db.exec_mut(QueryBuilder::insert().nodes().count(1).query(), 1);
    db.exec_mut(
        QueryBuilder::insert()
            .values([[("username", "user1").into()]])
            .ids(1)
            .query(),
        1,
    );
}

#[test]
fn update_indexed_value() {
    let mut db = TestDb::new();
    db.exec_mut(QueryBuilder::insert().index("username").query(), 0);
    db.exec_mut(
        QueryBuilder::insert()
            .nodes()
            .values([[("username", "user1").into()]])
            .query(),
        1,
    );
    db.exec_mut(
        QueryBuilder::insert()
            .values([[("username", "user2").into()]])
            .ids(1)
            .query(),
        1,
    );
}

#[test]
fn update_indexed_value_rollback() {
    let mut db = TestDb::new();
    db.exec_mut(QueryBuilder::insert().index("username").query(), 0);
    db.exec_mut(
        QueryBuilder::insert()
            .nodes()
            .values([[("username", "user1").into()]])
            .query(),
        1,
    );
    db.transaction_mut_error(
        |t| -> Result<(), DbError> {
            t.exec_mut(
                QueryBuilder::insert()
                    .values([[("username", "user2").into()]])
                    .ids(1)
                    .query(),
            )?;
            Err(DbError::from("error"))
        },
        DbError::from("error"),
    );
    db.exec(
        QueryBuilder::search()
            .index("username")
            .value("user1")
            .query(),
        1,
    );
}