gluesql 0.20.0

GlueSQL - Open source SQL database engine fully written in Rust with pure functional execution layer, easily swappable storage and web assembly support!
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

#[cfg(feature = "gluesql-redb-storage")]
mod hello_query_builder {
    use {
        gluesql::{
            core::query_builder::{self, Execute},
            gluesql_redb_storage::RedbStorage,
            prelude::{Glue, Payload, Value},
        },
        std::fs,
    };

    pub fn run() {
        /*
            Initiate a connection
        */
        /*
            Open a Redb database, this will create one if one does not yet exist
        */
        let redb_dir = "/tmp/gluesql";
        let redb_path = format!("{redb_dir}/hello_query_builder");
        fs::create_dir_all(redb_dir).unwrap();
        fs::remove_file(&redb_path).unwrap_or(());
        let storage = RedbStorage::new(redb_path).expect("Something went wrong!");
        /*
            Wrap the Redb database with Glue
        */
        let mut glue = Glue::new(storage);

        /*
            Create table
        */
        query_builder::table("greet")
            .create_table()
            .add_column("name TEXT")
            .execute(&mut glue)
            .expect("Execution failed");

        /*
            Insert a row
        */
        query_builder::table("greet")
            .insert()
            .values(vec!["'Query Builder'"])
            .execute(&mut glue)
            .expect("Execution failed");

        /*
            Select inserted row
        */
        let result = query_builder::table("greet")
            .select()
            .project("name")
            .execute(&mut glue)
            .expect("Failed to execute");

        /*
            Query results are wrapped into a payload enum, on the basis of the query type
        */
        let Payload::Select { labels: _, rows } = result else {
            panic!("Unexpected result: {result:?}")
        };

        let first_row = &rows[0];
        let first_value = first_row.iter().next().unwrap();

        /*
            Row values are wrapped into a value enum, on the basis of the result type
        */
        let to_greet = match first_value {
            Value::Str(to_greet) => to_greet,
            value => panic!("Unexpected type: {value:?}"),
        };

        println!("Hello {to_greet}!"); // Will always output "Hello Query Builder!"
    }
}

fn main() {
    #[cfg(feature = "gluesql-redb-storage")]
    hello_query_builder::run();
}