diff options
Diffstat (limited to 'src/models/user.rs')
| -rw-r--r-- | src/models/user.rs | 16 |
1 files changed, 8 insertions, 8 deletions
diff --git a/src/models/user.rs b/src/models/user.rs index fee6522..816db97 100644 --- a/src/models/user.rs +++ b/src/models/user.rs @@ -55,7 +55,7 @@ impl User { let crypted_password = sha256::digest(user.password); - let rec = sqlx::query_as!( + let rec = sqlx::query_as_unchecked!( UserList, r#" INSERT INTO users (email, username, password) @@ -78,7 +78,7 @@ impl User { let crypted_password = sha256::digest(user.password); - let rec = sqlx::query_as!( + let rec = sqlx::query_as_unchecked!( UserList, r#" SELECT id, email, username, is_staff, avatar FROM "users" @@ -97,7 +97,7 @@ impl User { pub async fn find_by_id(user_id: i32) -> Result<UserList, AppError> { let pool = unsafe { get_client() }; - let rec = sqlx::query_as!( + let rec = sqlx::query_as_unchecked!( UserList, r#" SELECT id, email, username, is_staff, avatar FROM "users" @@ -114,7 +114,7 @@ impl User { /// List all users pub async fn list(page: i64) -> Result<Vec<UserList>, AppError> { let pool = unsafe { get_client() }; - let rows = sqlx::query_as!( + let rows = sqlx::query_as_unchecked!( UserList, r#"SELECT id, email, username, is_staff, avatar FROM users LIMIT $1 OFFSET $2 @@ -131,7 +131,7 @@ impl User { /// Return the number of users. pub async fn count() -> Result<i64, AppError> { let pool = unsafe { get_client() }; - let row = sqlx::query!(r#"SELECT COUNT(id) as count FROM users"#) + let row = sqlx::query_unchecked!(r#"SELECT COUNT(id) as count FROM users"#) .fetch_one(pool) .await?; @@ -141,7 +141,7 @@ impl User { /// 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 row = sqlx::query!( + let row = sqlx::query_unchecked!( r#" SELECT COUNT(id) as count FROM users WHERE username = $1 "#, @@ -156,7 +156,7 @@ impl User { /// 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 row = sqlx::query!( + let row = sqlx::query_unchecked!( r#" SELECT COUNT(id) as count FROM users WHERE email = $1 "#, @@ -173,7 +173,7 @@ impl UserList { // Edit an user pub async fn edit_avatar(&mut self, avatar: Option<String>) -> Result<(), AppError> { let pool = unsafe { get_client() }; - sqlx::query!( + sqlx::query_unchecked!( r#" UPDATE users SET avatar = $1 WHERE id = $2 "#, |
