sqlorm 0.8.2

An ergonomic and type-safe ORM for database interactions
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
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125

use chrono::{DateTime, Utc};
use serde::{Deserialize, Serialize};
use sqlorm::table;
use uuid::Uuid;

#[table]
#[derive(Debug, Clone, Serialize, Deserialize, Default)]
pub struct User {
    #[sql(pk)]
    #[sql(relation(has_many -> Jar, name = "jars", on = owner_id))]
    #[sql(relation(has_many -> Donation, name = "payed_donations", on = payer_id))]
    pub id: i64,
    #[sql(unique)]
    pub email: String,
    #[serde(skip)]
    #[allow(dead_code)]
    pub password: String,
    #[sql(unique)]
    pub username: String,
    pub first_name: String,
    pub last_name: String,
    pub wallpaper_url: Option<String>,
    #[sql(rename("avatar"))]
    pub avatar_url: Option<String>,
    pub bio: Option<String>,
    #[sql(timestamp(created_at, chrono::Utc::now()))]
    pub created_at: DateTime<Utc>,
    #[sql(timestamp(updated_at, chrono::Utc::now()))]
    pub updated_at: DateTime<Utc>,
    #[sql(timestamp(deleted_at, chrono::Utc::now()))]
    pub deleted_at: Option<DateTime<Utc>>,
}

#[table]
#[derive(Debug, Default, Clone, Serialize, Deserialize)]
pub struct Jar {
    #[sql(pk)]
    #[sql(relation(has_many -> Donation, name = "donations", on = jar_id))]
    pub id: i64,
    pub title: String,
    pub description: Option<String>,
    pub minimal_donation: f64,
    pub total_amount: f64,
    pub total_donations: i32,
    #[sql(unique)]
    pub alias: String,
    pub hide_earnings: bool,
    pub goal: Option<f64>,
    #[sql(relation(belongs_to -> User, name = "owner", on = id))]
    pub owner_id: i64,
    #[sql(timestamp(created_at, chrono::Utc::now()))]
    pub created_at: DateTime<Utc>,
    #[sql(timestamp(updated_at, chrono::Utc::now()))]
    pub updated_at: DateTime<Utc>,
}

#[table]
#[derive(Debug, Default, Clone, Serialize, Deserialize)]
pub struct Donation {
    #[sql(pk)]
    pub id: Uuid,
    pub amount: f64,
    pub tip: f64,
    #[sql(relation(belongs_to -> Jar, name = "jar", on = id))]
    pub jar_id: i64,
    #[sql(relation(belongs_to -> User, name = "payer", on = id))]
    pub payer_id: i64,
    pub is_payed: bool,
    pub transaction_id: Option<String>,
    pub note: Option<String>,
    pub is_refunded: bool,
    pub refunded_at: Option<DateTime<Utc>>,
    #[sql(timestamp(deleted_at, chrono::Utc::now()))]
    pub deleted_at: Option<DateTime<Utc>>,
    #[sql(timestamp(created_at, chrono::Utc::now()))]
    pub created_at: DateTime<Utc>,
    #[sql(timestamp(updated_at, chrono::Utc::now()))]
    pub updated_at: DateTime<Utc>,
    pub payed_at: Option<DateTime<Utc>>,
}

impl User {
    /// Creates a test user with default values
    #[allow(dead_code)]
    pub fn test_user(email: &str, username: &str) -> Self {
        Self {
            email: email.to_string(),
            username: username.to_string(),
            password: "secret".to_string(),
            first_name: "Test".to_string(),
            last_name: "User".to_string(),
            ..Default::default()
        }
    }
}

impl Jar {
    /// Creates a test jar with default values
    #[allow(dead_code)]
    pub fn test_jar(owner_id: i64, alias: &str) -> Self {
        Self {
            title: "Test Jar".to_string(),
            description: Some("A test jar".to_string()),
            minimal_donation: 1.0,
            alias: alias.to_string(),
            owner_id,
            ..Default::default()
        }
    }
}

impl Donation {
    /// Creates a test donation with default values
    #[allow(dead_code)]
    pub fn test_donation(jar_id: i64, payer_id: i64, amount: f64) -> Self {
        Self {
            amount,
            tip: amount * 0.1,
            jar_id,
            payer_id,
            is_payed: true,
            ..Default::default()
        }
    }
}