njord 0.5.0

A versatile, feature-rich Rust ORM.
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

mod delete_test;
mod insert_test;
mod open_test;
mod raw_test;
mod select_joins_test;
mod select_test;
mod update_test;

use njord::keys::{AutoIncrementPrimaryKey, PrimaryKey};
use njord::table::Table;
use njord_derive::Table;

#[derive(Table, Clone)]
#[table_name = "users"]
pub struct User {
    pub id: AutoIncrementPrimaryKey<usize>,
    pub username: String,
    pub email: String,
    pub address: String,
}

#[derive(Table, Clone)]
#[table_name = "users"]
pub struct UserWithSubQuery {
    pub id: AutoIncrementPrimaryKey<usize>,
    pub username: String,
    pub email: String,
    pub address: String,
    pub additional_address: String,
}

#[derive(Table)]
#[table_name = "categories"]
pub struct Category {
    pub id: PrimaryKey<usize>,
    pub name: String,
}

#[derive(Table)]
#[table_name = "products"]
pub struct Product {
    pub id: PrimaryKey<usize>,
    pub name: String,
    pub description: String,
    pub price: f64,
    pub stock_quantity: usize,
    pub category: Category, // one-to-one relationship
    pub discount: f64,
}

#[derive(Table)]
#[table_name = "users"]
pub struct UsersWithJoin {
    username: String,
    price: f64,
    name: String,
}