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
48
49
50
51
52
53
54
55
56
57
58

use ormlite::model::*;
use ormlite::{query, Connection};
use sql::{Dialect, ToSql};
use uuid::Uuid;

#[path = "../setup.rs"]
mod setup;

#[derive(Model)]
#[ormlite(table = "users")]
struct User {
    id: Uuid,
    name: String,
    #[ormlite(column = "org_id")]
    org: Join<Organization>,

    #[ormlite(column = "subscription_id")]
    subscription: Join<Option<Subscription>>,

    // #[ormlite(foreign_field = Photo::user_id, sort = "id")]
    #[ormlite(foreign_field = Photo::user_id)]
    photos: Join<Vec<Photo>>,
}

#[derive(Model)]
struct Organization {
    id: Uuid,
    name: String,
}

#[derive(Model)]
struct Subscription {
    id: Uuid,
    name: String,
}

#[derive(Model)]
struct Photo {
    id: Uuid,
    user_id: Uuid,
    name: String,
}

#[tokio::main]
async fn main() {
    env_logger::init();
    let url = std::env::var("DATABASE_URL").unwrap();
    let mut conn = ormlite::postgres::PgConnection::connect(&url).await.unwrap();
    query("drop table if exists users, organization, photo, subscription")
        .execute(&mut conn)
        .await
        .unwrap();
    let migration = setup::migrate_self(&[file!()]);
    for s in migration.statements {
        let sql = s.to_sql(Dialect::Postgres);
        query(&sql).execute(&mut conn).await.unwrap();
    }
}