deuterium 0.2.0

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

use deuterium::*;

#[test]
fn order_asc() {

    let jedi_table = TableDef::new("jedi");
    let name = NamedField::<String>::field_of("name", &jedi_table);
    let force_level = NamedField::<i8>::field_of("force_level", &jedi_table);
    let side = NamedField::<bool>::field_of("side", &jedi_table);
    
    let query = jedi_table.select_all().order_by(&name);
    assert_sql!(query, "SELECT * FROM jedi ORDER BY name ASC;");

    let query = query.order_append(&force_level);
    assert_sql!(query, "SELECT * FROM jedi ORDER BY name ASC, force_level ASC;");    

    let query = query.order_prepend(&side);
    assert_sql!(query, "SELECT * FROM jedi ORDER BY side ASC, name ASC, force_level ASC;");

}

#[test]
fn order_desc() {

    let jedi_table = TableDef::new("jedi");
    let name = NamedField::<String>::field_of("name", &jedi_table);
    let force_level = NamedField::<i8>::field_of("force_level", &jedi_table);
    let side = NamedField::<bool>::field_of("side", &jedi_table);
    
    let query = jedi_table.select_all().reverse_by(&name);
    assert_sql!(query, "SELECT * FROM jedi ORDER BY name DESC;");

    let query = query.reverse_append(&force_level);
    assert_sql!(query, "SELECT * FROM jedi ORDER BY name DESC, force_level DESC;");    

    let query = query.reverse_prepend(&side);
    assert_sql!(query, "SELECT * FROM jedi ORDER BY side DESC, name DESC, force_level DESC;");

}