ormlitex 0.17.1

An ORM for people who love 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
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89

use ormlitex::Model;
use ormlitex::model::{Insertable, Join, JoinMeta};
use sqlmo::ToSql;

use ormlitex::Connection;
#[path = "../setup.rs"]
mod setup;

#[derive(Debug, Model, Clone)]
pub struct Organization {
    id: i32,
    name: String,
}

#[derive(Model)]
#[ormlitex(insertable = InsertUser)]
pub struct User {
    id: i32,
    name: String,
    #[ormlitex(default)]
    secret: Option<String>,
    #[ormlitex(default_value = "5")]
    number: i32,
    #[ormlitex(column = "type")]
    typ: i32,
    #[ormlitex(join_column = "org_id")]
    organization: Join<Organization>,
}

#[tokio::main]
async fn main() {
    let mut db = ormlitex::sqlite::SqliteConnection::connect(":memory:")
        .await
        .unwrap();
    let migration = setup::migrate_self(&[file!()]);
    for s in migration.statements {
        let sql = s.to_sql(sqlmo::Dialect::Sqlite);
        ormlitex::query(&sql)
            .execute(&mut db)
            .await
            .unwrap();
    }

    let org = Organization {
        id: 12321,
        name: "my org".to_string(),
    };

    let champ = InsertUser {
        name: "Champ".to_string(),
        organization: Join::new(org.clone()),
        typ: 12,
    }.insert(&mut db)
        .await
        .unwrap();

    assert_eq!(champ.id, 1);
    assert_eq!(champ.secret, None);
    assert_eq!(champ.number, 5);
    assert_eq!(champ.organization.id, 12321);
    assert_eq!(champ.organization.name, "my org");

    let millie = InsertUser {
        name: "Millie".to_string(),
        organization: Join::new(org),
        typ: 3,
    }.insert(&mut db)
        .await
        .unwrap();
    assert_eq!(millie.id, 2);
    assert_eq!(millie.secret, None);
    assert_eq!(millie.number, 5);
    assert_eq!(millie.organization.id, 12321);
    assert_eq!(millie.organization.name, "my org");

    let enoki = InsertUser {
        name: "Enoki".to_string(),
        organization: Join::new_with_id(12321),
        typ: 6,
    }.insert(&mut db)
        .await
        .unwrap();
    assert_eq!(enoki.id, 3);
    assert_eq!(enoki.secret, None);
    assert_eq!(enoki.number, 5);
    assert_eq!(enoki.organization.id, 12321);
    assert_eq!(enoki.organization.loaded(), false);

}