deuterium 0.3.1

Deuterium is a fancy SQL builder for Rust. It's designed to provide a DSL to easily build SQL queries in safe and *typed* way.
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


use deuterium::*;

#[test]
fn select() {

    let jedi_table = TableDef::new("jedi");
    let name = NamedField::<String>::field_of("name", &jedi_table);
    let side = NamedField::<bool>::field_of("side", &jedi_table);
    
    // Type is here only for sure it is right, it can be ommited in real code
    let query: SelectQuery<(), LimitMany, ()> = jedi_table.select_all();
    assert_sql!(query, "SELECT * FROM jedi;");

    let query: SelectQuery<(String,), LimitMany, ()> = jedi_table.select_1(&name);
    assert_sql!(query, "SELECT name FROM jedi;");

    let query: SelectQuery<(String,), LimitMany, ()> = jedi_table.alias("j").select_1(&name);
    assert_sql!(query, "SELECT name FROM jedi AS j;");

    let query: SelectQuery<(String, bool), LimitMany, ()> = jedi_table.select_2(&name, &side);
    assert_sql!(query, "SELECT name, side FROM jedi;");
}

#[test]
fn select_from_select() {

    let jedi_table = TableDef::new("jedi");
    
    let query = jedi_table.select_all().from_as("j").select_all();
    assert_sql!(query, "SELECT * FROM (SELECT * FROM jedi) as j;");
}

#[test]
fn select_distinct() {

    let jedi_table = TableDef::new("jedi");
    let name = NamedField::<String>::field_of("name", &jedi_table);

    let query = jedi_table.select_all().distinct();
    assert_sql!(query, "SELECT DISTINCT * FROM jedi;");    

    let query = jedi_table.select_all().distinct_on(&[&name]);
    assert_sql!(query, "SELECT DISTINCT ON (name) * FROM jedi;");
}

#[test]
fn select_for() {

    let jedi_table = TableDef::new("jedi");
    
    let query = jedi_table.select_all().for_update();
    assert_sql!(query, "SELECT * FROM jedi FOR UPDATE;"); 

    let query = jedi_table.select_all().for_share();
    assert_sql!(query, "SELECT * FROM jedi FOR SHARE;");     

    let query = jedi_table.select_all().for_update_nowait();
    assert_sql!(query, "SELECT * FROM jedi FOR UPDATE NOWAIT;");      

    let query = jedi_table.select_all().for_share_nowait();
    assert_sql!(query, "SELECT * FROM jedi FOR SHARE NOWAIT;");    
}


#[test]
fn select_exists() {

    let jedi_table = TableDef::new("jedi");
    let name = NamedField::<String>::field_of("name", &jedi_table);
    
    let query = jedi_table.exists().where_(name.is("Luke".to_string()));
    assert_sql!(query, "SELECT 1 FROM jedi WHERE name = $1;");    
}