From 0b55587443103b20491139d54670474a35286be8 Mon Sep 17 00:00:00 2001
From: mrw1593 <botahamec@outlook.com>
Date: Sat, 13 May 2023 12:22:11 -0400
Subject: Add a login endpoint that does nothing

---
 src/services/db.rs | 18 ++++++++++++++++++
 1 file changed, 18 insertions(+)

(limited to 'src/services')

diff --git a/src/services/db.rs b/src/services/db.rs
index 3eee9ba..80335c4 100644
--- a/src/services/db.rs
+++ b/src/services/db.rs
@@ -84,6 +84,24 @@ pub async fn get_user<'c>(
 	Ok(Some(record.try_into()?))
 }
 
+pub async fn get_user_by_username<'c>(
+	conn: impl Executor<'c, Database = MySql>,
+	username: &str,
+) -> Result<Option<User>, RawUnexpected> {
+	let record = query_as!(
+		UserRow,
+		r"SELECT user_id, username, password_hash, password_salt, password_version
+		  FROM users WHERE username = ?",
+		username
+	)
+	.fetch_optional(conn)
+	.await?;
+
+	let Some(record) = record else { return Ok(None) };
+
+	Ok(Some(record.try_into()?))
+}
+
 pub async fn get_username<'c>(
 	conn: impl Executor<'c, Database = MySql>,
 	user_id: Uuid,
-- 
cgit v1.2.3