deuterium 0.2.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

use deuterium::*;

#[test]
fn conditioned_join() {

    let jedi_table = TableDef::new("jedi");
    let jedi_j = jedi_table.alias("j");
    let name = NamedField::<String>::field_of("name", &jedi_table);
    let name_j = NamedField::<String>::field_of("name", &jedi_j);
    
    let query = jedi_table.select_all().inner_join(&jedi_j, name.is(name_j));
    assert_sql!(query, "SELECT * FROM jedi INNER JOIN jedi AS j ON name = j.name;");

}

#[test]
fn unconditioned_join() {

    let jedi_table = TableDef::new("jedi");
    let jedi_j = jedi_table.alias("j");
    
    let query = jedi_table.select_all().cross_join(&jedi_j);
    assert_sql!(query, "SELECT * FROM jedi CROSS JOIN jedi AS j;");

}