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

use deuterium::*;

#[test]
fn insert_default() {
    let jedi_table = TableDef::new("jedi");
    assert_sql!(jedi_table.insert_all(), "INSERT INTO jedi DEFAULT VALUES;")
}

#[test]
fn insert() {

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

    let mut query = jedi_table.insert_fields(&[&name, &side]);
    query.push_untyped(&["Luke".to_string().as_expr(), true.as_expr()]);
    assert_sql!(query, "INSERT INTO jedi (name, side) VALUES\n    ($1, $2);");

    let mut query = jedi_table.insert_1_for_test(&name);
    query.push((InsertValue::new("Luke".to_string().as_expr()), ));
    query.push((InsertValue::Default, ));

    assert_sql!(query, "INSERT INTO jedi (name) VALUES\n    ($1),\n    (DEFAULT);");
}

#[test]
fn insert_returning() {

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

    let mut query = jedi_table.insert_fields(&[&name, &side]).returning_1(&name.qual());
    query.push_untyped(&["Luke".to_string().as_expr(), true.as_expr()]);
    assert_sql!(query, "INSERT INTO jedi (name, side) VALUES\n    ($1, $2) RETURNING jedi.name;");
}