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 super::schema::{cart_items, customer, product, rating, transaction};
use chrono::naive::{NaiveDate, NaiveDateTime};
use diesel::{Insertable, Queryable};
use serde::{Deserialize, Serialize};
/* Member */
#[derive(Queryable, Serialize)]
pub struct Customer {
pub id: i32,
pub username: String,
pub password: String,
pub phone_number: String,
pub email_id: String,
pub address: Option<String>,
}
#[derive(Insertable, Deserialize)]
#[table_name = "customer"]
pub struct NewCustomer {
pub username: String,
pub password: String,
pub phone_number: String,
pub email_id: String,
#[serde(skip_serializing_if = "Option::is_none")]
pub address: Option<String>,
}
/* Product */
#[derive(Queryable, Serialize)]
pub struct Product {
pub id: i32,
pub name: String,
pub kind: Option<String>,
pub price: f32,
pub description: Option<String>,
pub src: Option<String>,
pub ios_src: Option<String>,
}
#[derive(Insertable, Deserialize)]
#[table_name = "product"]
pub struct NewProduct {
pub name: String,
#[serde(skip_serializing_if = "Option::is_none")]
pub kind: Option<String>,
pub price: f32,
#[serde(skip_serializing_if = "Option::is_none")]
pub description: Option<String>,
#[serde(skip_serializing_if = "Option::is_none")]
pub src: Option<String>,
#[serde(skip_serializing_if = "Option::is_none")]
pub ios_src: Option<String>,
}
#[derive(Deserialize)]
pub struct UpdateProduct {
pub name: String,
pub kind: Option<String>,
pub price: f32,
pub description: Option<String>,
}
/* Cart Items */
#[derive(Queryable, Serialize)]
pub struct CartItem {
pub cart_id: i32,
pub product_id: i32,
pub quantity: Option<i32>,
}
#[derive(Insertable, Deserialize)]
#[table_name = "cart_items"]
pub struct AddCartItem {
pub cart_id: i32,
pub product_id: i32,
pub quantity: Option<i32>,
}
/* Rating */
#[derive(Queryable, Serialize)]
pub struct Rating {
pub id: i32,
pub comment_text: Option<String>,
pub comment_date: Option<NaiveDate>,
pub product_id: Option<i32>,
pub customer_id: Option<i32>,
pub stars: Option<i32>,
}
#[derive(Insertable, Deserialize)]
#[table_name = "rating"]
pub struct AddRating {
#[serde(skip_serializing_if = "Option::is_none")]
pub comment_text: Option<String>,
#[serde(skip_serializing_if = "Option::is_none")]
pub stars: Option<i32>,
pub product_id: i32,
pub customer_id: i32,
}
/* Transaction */
#[derive(Queryable, Serialize)]
pub struct Transaction {
pub id: i32,
pub payment_type: String,
pub amount: f32,
pub customer_id: Option<i32>,
pub order_date: NaiveDate,
}
#[derive(Insertable, Deserialize)]
#[table_name = "transaction"]
pub struct AddTransaction {
pub payment_type: String,
pub amount: f32,
pub customer_id: Option<i32>,
}
|
