rawsql 0.2.0

A rust library for reusing SQL
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

extern crate postgres;
extern crate rawsql;

use postgres::{Client, NoTls};
use rawsql::Loader;

struct Person {
    id: i32,
    name: String,
    data: Option<Vec<u8>>,
}

fn main() {
    let mut conn = Client::connect("postgres://postgres:local@localhost", NoTls).unwrap();

    let queries = Loader::get_queries_from("examples/postgre.sql").unwrap();

    // Drop table
    conn.execute(queries.get("drop-table-person").unwrap(), &[])
        .unwrap();

    // Create table
    conn.execute(queries.get("create-table-person").unwrap(), &[])
        .unwrap();

    let me = Person {
        id: 0,
        name: "Manuel".to_string(),
        data: None,
    };

    // Insert into table
    conn.execute(queries.get("insert-person").unwrap(), &[&me.name, &me.data])
        .unwrap();

    // Select
    for row in conn.query(queries.get("select-all").unwrap(), &[]).unwrap() {
        let person = Person {
            id: row.get(0),
            name: row.get(1),
            data: row.get(2),
        };
        println!("Found person id : {}, name: {}", person.id, person.name);
    }
}