gluesql-csv-storage 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!
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

use {
    gluesql_core::prelude::{
        Glue,
        Value::{I64, Str},
    },
    gluesql_csv_storage::CsvStorage,
    test_suite::*,
};

#[test]
fn basic() {
    let path = "./tests/samples/";
    let storage = CsvStorage::new(path).unwrap();
    let mut glue = Glue::new(storage);

    let actual = glue
        .execute("SELECT * FROM Employee")
        .unwrap()
        .into_iter()
        .next()
        .unwrap();
    let expected = select! {
        Name                | Age            | Gender             | Occupation
        Str                 | Str            | Str                | Str;
        "John".to_owned()     "25".to_owned()  "Male".to_owned()    "Engineer".to_owned();
        "Sarah".to_owned()    "30".to_owned()  "Female".to_owned()  "Doctor".to_owned();
        "Michael".to_owned()  "40".to_owned()  "Male".to_owned()    "Lawyer".to_owned();
        "Emily".to_owned()    "28".to_owned()  "Female".to_owned()  "Teacher".to_owned();
        "David".to_owned()    "35".to_owned()  "Male".to_owned()    "Programmer".to_owned()
    };
    assert_eq!(actual, expected);

    let actual = glue
        .execute(
            "
            SELECT
                Name,
                CAST(Age AS INTEGER) AS Age
            FROM Employee
         ",
        )
        .unwrap()
        .into_iter()
        .next()
        .unwrap();
    let expected = select! {
        Name                | Age
        Str                 | I64;
        "John".to_owned()     25;
        "Sarah".to_owned()    30;
        "Michael".to_owned()  40;
        "Emily".to_owned()    28;
        "David".to_owned()    35
    };
    assert_eq!(actual, expected);
}