use argon2::{password_hash::SaltString, Argon2, PasswordHash, PasswordHasher, PasswordVerifier};
use rand::rngs::OsRng;
use crate::connection::UserId;
pub async fn create_user_or_fetch_password_hash(
conn: &sqlx::Pool<sqlx::Any>,
username: &str,
password: &[u8],
) -> Result<(i64, String), sqlx::Error> {
let password_hash = Argon2::default()
.hash_password(password, &SaltString::generate(&mut OsRng))
.unwrap()
.to_string();
sqlx::query_as(
"INSERT INTO users (username, password)
VALUES (?, ?)
ON CONFLICT(username) DO UPDATE SET username = username
RETURNING id, password",
)
.bind(username)
.bind(password_hash)
.fetch_one(conn)
.await
}
pub async fn reserve_nick(
conn: &sqlx::Pool<sqlx::Any>,
nick: &str,
user_id: UserId,
) -> Result<bool, sqlx::Error> {
let (owning_user,): (i64,) = sqlx::query_as(
"INSERT INTO user_nicks (nick, user)
VALUES (?, ?)
ON CONFLICT(nick) DO UPDATE SET nick = nick
RETURNING user",
)
.bind(nick)
.bind(user_id.0)
.fetch_one(conn)
.await?;
Ok(owning_user == user_id.0)
}
pub fn verify_password(password: &[u8], hash: &PasswordHash<'_>) -> argon2::password_hash::Result<()> {
Argon2::default().verify_password(password, hash)
}