ormlite 0.24.3

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

use ormlite::Model;
use ormlite::TableMeta;
use sql::ToSql;

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

#[derive(Model)]
pub struct User {
    id: i32,
    #[ormlite(column = "type")]
    typ: String,
}

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

    User {
        id: 1,
        typ: "admin".to_string(),
    }.insert(&mut db)
        .await
        .unwrap();

    let users = User::select()
        .fetch_all(&mut db)
        .await
        .unwrap();

    assert_eq!(User::table_name(), "user");
    assert_eq!(User::table_columns(), &["id", "type"]);

    assert_eq!(users.len(), 1);
    assert_eq!(users[0].typ, "admin");
}