splitterrust_db 0.1.0

The database implementation for splitterrust, a collections of utilities written in rust for the splittermond P&P.
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

/*
This is the Schools data, which represents the data in the schools table.
*/
use crate::schema::schools;
use diesel::pg::PgConnection;
use diesel::RunQueryDsl;
use serde::{
    Deserialize,
    Serialize,
};
use serde_json::json;

#[derive(Queryable, Debug, Clone, Serialize, Deserialize)]
pub struct Schools {
    pub id:            i32,
    pub fire:          Option<i32>,
    pub protection:    Option<i32>,
    pub light:         Option<i32>,
    pub detection:     Option<i32>,
    pub strengthening: Option<i32>,
    pub metamorphism:  Option<i32>,
    pub bann:          Option<i32>,
    pub illusion:      Option<i32>,
    pub movement:      Option<i32>,
    pub wind:          Option<i32>,
    pub heal:          Option<i32>,
    pub death:         Option<i32>,
    pub fate:          Option<i32>,
    pub nature:        Option<i32>,
    pub control:       Option<i32>,
    pub fight:         Option<i32>,
    pub water:         Option<i32>,
    pub shadow:        Option<i32>,
    pub earth:         Option<i32>,
}

impl Schools {
    pub fn to_string(self) -> String {
        let obj = json!(self);
        serde_json::to_string_pretty(&obj).unwrap()
    }
}

#[derive(Insertable, Debug)]
#[table_name = "schools"]
pub struct NewSchools<'a> {
    pub fire:          Option<&'a i32>,
    pub protection:    Option<&'a i32>,
    pub light:         Option<&'a i32>,
    pub detection:     Option<&'a i32>,
    pub strengthening: Option<&'a i32>,
    pub metamorphism:  Option<&'a i32>,
    pub bann:          Option<&'a i32>,
    pub illusion:      Option<&'a i32>,
    pub movement:      Option<&'a i32>,
    pub wind:          Option<&'a i32>,
    pub heal:          Option<&'a i32>,
    pub death:         Option<&'a i32>,
    pub fate:          Option<&'a i32>,
    pub nature:        Option<&'a i32>,
    pub control:       Option<&'a i32>,
    pub fight:         Option<&'a i32>,
    pub water:         Option<&'a i32>,
    pub shadow:        Option<&'a i32>,
    pub earth:         Option<&'a i32>,
}

pub fn write_new_schools<'a>(
    conn: &PgConnection,
    fire: Option<&'a i32>,
    protection: Option<&'a i32>,
    light: Option<&'a i32>,
    detection: Option<&'a i32>,
    strengthening: Option<&'a i32>,
    metamorphism: Option<&'a i32>,
    bann: Option<&'a i32>,
    illusion: Option<&'a i32>,
    movement: Option<&'a i32>,
    wind: Option<&'a i32>,
    heal: Option<&'a i32>,
    death: Option<&'a i32>,
    fate: Option<&'a i32>,
    nature: Option<&'a i32>,
    control: Option<&'a i32>,
    fight: Option<&'a i32>,
    water: Option<&'a i32>,
    shadow: Option<&'a i32>,
    earth: Option<&'a i32>,
) -> Schools {
    let new_schools = NewSchools {
        fire,
        protection,
        light,
        detection,
        strengthening,
        metamorphism,
        bann,
        illusion,
        movement,
        wind,
        heal,
        death,
        fate,
        nature,
        control,
        fight,
        water,
        shadow,
        earth,
    };

    diesel::insert_into(schools::table)
        .values(&new_schools)
        .get_result(conn)
        .expect("Error saving new schools")
}

pub fn write_schools(schools: &NewSchools, conn: &PgConnection) -> Schools {
    diesel::insert_into(schools::table)
        .values(schools)
        .get_result(conn)
        .expect("Error saving new schools")
}