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
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
|
use crate::{
config::CONFIG,
db::get_client,
errors::AppError,
models::model::{Model, ModelUser},
};
use serde::{Deserialize, Serialize};
use serde_with::{serde_as, NoneAsEmptyString};
use sqlx::Row;
use validator::Validate;
/// User model
#[derive(Deserialize, Serialize, Validate)]
pub struct User {
id: i32,
name: String,
#[validate(length(min = 4, message = "Can not be empty"))]
email: String,
#[validate(length(min = 2, message = "Can not be empty"))]
username: String,
#[validate(length(min = 8, message = "Must be min 8 chars length"))]
password: String,
is_staff: Option<bool>,
avatar: Option<String>,
}
/// Response used to print a user (or a users list)
#[serde_as]
#[derive(Deserialize, Serialize, sqlx::FromRow)]
pub struct UserList {
pub id: i32,
name: String,
email: String,
username: String,
pub is_staff: Option<bool>,
#[serde_as(as = "NoneAsEmptyString")]
pub avatar: Option<String>,
}
impl User {
/// By default an user has id = 0. It is not created yet
pub fn new(name: String, email: String, username: String, password: String) -> Self {
Self {
id: 0,
name,
email,
username,
password,
is_staff: Some(false),
avatar: None,
}
}
/// Create a new user from the model using a SHA256 crypted password
pub async fn create(user: User) -> Result<UserList, AppError> {
let pool = unsafe { get_client() };
user.validate()
.map_err(|error| AppError::BadRequest(error.to_string()))?;
let crypted_password = sha256::digest(user.password);
let rec: UserList = sqlx::query_as(
r#"
INSERT INTO users (name, email, username, password)
VALUES ( $1, $2, $3, $4)
RETURNING id, email, username, is_staff, avatar
"#,
)
.bind(user.name)
.bind(user.email)
.bind(user.username)
.bind(crypted_password)
.fetch_one(pool)
.await?;
Ok(rec)
}
/// Find a user using the model. It used for login
pub async fn find(user: User) -> Result<UserList, AppError> {
let pool = unsafe { get_client() };
let crypted_password = sha256::digest(user.password);
let rec: UserList = sqlx::query_as(
r#"
SELECT id, name, email, username, is_staff, avatar FROM "users"
WHERE username = $1 AND password = $2
"#,
)
.bind(user.username)
.bind(crypted_password)
.fetch_one(pool)
.await?;
Ok(rec)
}
/// Returns the user with id = `user_id`
pub async fn find_by_id(user_id: i32) -> Result<UserList, AppError> {
let pool = unsafe { get_client() };
let rec: UserList = sqlx::query_as(
r#"
SELECT id, name, email, username, is_staff, avatar FROM "users"
WHERE id = $1
"#,
)
.bind(user_id)
.fetch_one(pool)
.await?;
Ok(rec)
}
/// List all users
pub async fn list(page: i64) -> Result<Vec<UserList>, AppError> {
let pool = unsafe { get_client() };
let rows: Vec<UserList> = sqlx::query_as(
r#"SELECT id, name, email, username, is_staff, avatar FROM users
LIMIT $1 OFFSET $2
"#,
)
.bind(CONFIG.page_limit)
.bind(CONFIG.page_limit * page)
.fetch_all(pool)
.await?;
Ok(rows)
}
/// Return the number of users.
pub async fn count() -> Result<i64, AppError> {
let pool = unsafe { get_client() };
let cursor = sqlx::query(r#"SELECT COUNT(id) as count FROM users"#)
.fetch_one(pool)
.await?;
let count: i64 = cursor.try_get(0).unwrap();
Ok(count)
}
/// Prevent the "uniquess" Postgres fields check. Check if username has been taken
pub async fn username_has_taken(username: &String) -> Result<bool, AppError> {
let pool = unsafe { get_client() };
let cursor = sqlx::query(
r#"
SELECT COUNT(id) as count FROM users WHERE username = $1
"#,
)
.bind(username)
.fetch_one(pool)
.await?;
let count: i64 = cursor.try_get(0).unwrap();
Ok(count > 0)
}
/// Prevent the "uniquess" Postgres fields check. Check if email has been taken
pub async fn email_has_taken(email: &String) -> Result<bool, AppError> {
let pool = unsafe { get_client() };
let cursor = sqlx::query(
r#"
SELECT COUNT(id) as count FROM users WHERE email = $1
"#,
)
.bind(email)
.fetch_one(pool)
.await?;
let count: i64 = cursor.try_get(0).unwrap();
Ok(count > 0)
}
}
impl UserList {
/// Edit an user
pub async fn edit_avatar(&mut self, avatar: Option<String>) -> Result<(), AppError> {
let pool = unsafe { get_client() };
sqlx::query(
r#"
UPDATE users SET avatar = $1 WHERE id = $2
"#,
)
.bind(&avatar)
.bind(self.id)
.execute(pool)
.await?;
self.avatar = avatar;
Ok(())
}
/// Get all models created by an user
pub async fn get_models(&self, page: i64) -> Result<Vec<ModelUser>, AppError> {
Model::list_from_author(page, self.id).await
}
/// Returns the number of models for an user
pub async fn count_models(&self) -> Result<i64, AppError> {
Model::count_filter_by_author(self.id).await
}
}
|
