butane 0.8.1

An ORM with a focus on simplicity and on writing Rust, not 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
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70

use butane::db::ConnectionAsync;
use butane::{model, query};
use butane_test_helper::*;
use butane_test_macros::butane_test;

#[model]
#[derive(PartialEq, Eq, Debug)]
struct WithNullable {
    id: i64,
    foo: Option<i32>,
}
impl WithNullable {
    fn new(id: i64) -> Self {
        WithNullable { id, foo: None }
    }
}

#[butane_test]
async fn basic_optional(conn: ConnectionAsync) {
    let mut with_none = WithNullable::new(1);
    with_none.save(&conn).await.unwrap();

    let mut with_some = WithNullable::new(2);
    with_some.foo = Some(42);
    with_some.save(&conn).await.unwrap();

    let obj = WithNullable::get(&conn, 1).await.unwrap();
    assert_eq!(obj.foo, None);

    let obj = WithNullable::get(&conn, 2).await.unwrap();
    assert_eq!(obj.foo, Some(42));
}

#[butane_test]
async fn query_optional_with_some(conn: ConnectionAsync) {
    let mut obj = WithNullable::new(1);
    obj.save(&conn).await.unwrap();

    let mut obj = WithNullable::new(2);
    obj.foo = Some(42);
    obj.save(&conn).await.unwrap();

    let mut obj = WithNullable::new(3);
    obj.foo = Some(43);
    obj.save(&conn).await.unwrap();

    let mut obj = WithNullable::new(4);
    obj.foo = Some(44);
    obj.save(&conn).await.unwrap();

    let mut objs = query!(WithNullable, foo > 42).load(&conn).await.unwrap();
    objs.sort_by(|o1, o2| o1.foo.partial_cmp(&o2.foo).unwrap());
    assert_eq!(objs.len(), 2);
    assert_eq!(objs[0].foo, Some(43));
    assert_eq!(objs[1].foo, Some(44));
}

#[butane_test]
async fn query_optional_with_none(conn: ConnectionAsync) {
    let mut obj = WithNullable::new(1);
    obj.save(&conn).await.unwrap();

    let mut obj = WithNullable::new(2);
    obj.foo = Some(42);
    obj.save(&conn).await.unwrap();

    let objs = query!(WithNullable, foo == None).load(&conn).await.unwrap();
    assert_eq!(objs.len(), 1);
    assert_eq!(objs[0].id, 1);
}