exemplar 0.37.0

A boilerplate eliminator for rusqlite.
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
46
47
48
49
50
51
52
53
54

use anyhow::Result;

use exemplar::sql_enum;
use exemplar::Model;

sql_enum!(
    Name => Gender,
    Male,
    Female,
);

#[derive(Model, Debug, PartialEq, Eq)]
#[table("people")]
pub struct Person {
    pub name: String,
    pub gender: Gender,
    pub age: u16,
}

#[test]
fn test_person() -> Result<()> {
    use rusqlite::Connection;

    let conn = Connection::open_in_memory()
        .unwrap();

    conn.execute_batch("
        CREATE TABLE people (name, gender, age);
    ")?;

    let alice = Person {
        name: "Alice".to_owned(),
        gender: Gender::Female,
        age: 21,
    };
    
    let bob = Person {
        name: "Bob".to_owned(),
        gender: Gender::Male,
        age: 90,
    };

    alice.insert(&conn)?;
    bob.insert(&conn)?;

    let mut stmt = conn.prepare("SELECT * FROM people ORDER BY name ASC")?;

    let mut iter = stmt.query_and_then([], Person::from_row)?;

    assert_eq!(alice, iter.next().unwrap()?);
    assert_eq!(bob, iter.next().unwrap()?);

    Ok(())
}