diff options
Diffstat (limited to 'src/database/users.rs')
-rw-r--r-- | src/database/users.rs | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/src/database/users.rs b/src/database/users.rs index 2618dce..56b8814 100644 --- a/src/database/users.rs +++ b/src/database/users.rs @@ -1,5 +1,6 @@ use std::time::{SystemTime, UNIX_EPOCH}; use rusqlite::{OptionalExtension, Row}; +use tracing::instrument; use crate::{database, types::user::User}; @@ -40,28 +41,36 @@ fn user_from_row(row: &Row, hide_password: bool) -> Result<User, rusqlite::Error Ok(User{user_id, firstname, lastname, email, password, gender,date, day, month, year}) } +#[instrument()] pub fn get_user_by_id(user_id: u64, hide_password: bool) -> Result<Option<User>, rusqlite::Error> { + tracing::trace!("Retrieving user by id"); let conn = database::connect()?; let mut stmt = conn.prepare("SELECT * FROM users WHERE user_id = ?")?; let row = stmt.query_row([user_id], |row| Ok(user_from_row(row, hide_password)?)).optional()?; Ok(row) } +#[instrument()] pub fn get_user_by_email(email: &str, hide_password: bool) -> Result<Option<User>, rusqlite::Error> { + tracing::trace!("Retrieving user by email"); let conn = database::connect()?; let mut stmt = conn.prepare("SELECT * FROM users WHERE email = ?")?; let row = stmt.query_row([email], |row| Ok(user_from_row(row, hide_password)?)).optional()?; Ok(row) } +#[instrument()] pub fn get_user_by_password(password: &str, hide_password: bool) -> Result<Option<User>, rusqlite::Error> { + tracing::trace!("Retrieving user by password"); let conn = database::connect()?; let mut stmt = conn.prepare("SELECT * FROM users WHERE password = ?")?; let row = stmt.query_row([password], |row| Ok(user_from_row(row, hide_password)?)).optional()?; Ok(row) } +#[instrument()] pub fn get_user_page(page: u64, hide_password: bool) -> Result<Vec<User>, rusqlite::Error> { + tracing::trace!("Retrieving user page"); let page_size = 5; let conn = database::connect()?; let mut stmt = conn.prepare("SELECT * FROM users ORDER BY user_id DESC LIMIT ? OFFSET ?")?; @@ -69,7 +78,9 @@ pub fn get_user_page(page: u64, hide_password: bool) -> Result<Vec<User>, rusqli Ok(row.into_iter().flatten().collect()) } +#[instrument()] pub fn add_user(firstname: &str, lastname: &str, email: &str, password: &str, gender: &str, day: u8, month: u8, year: u32) -> Result<User, rusqlite::Error> { + tracing::trace!("Adding new user"); let date = SystemTime::now().duration_since(UNIX_EPOCH).unwrap().as_millis() as u64; let conn = database::connect()?; |