From b688a4be5f738bba2f7f02b9860030d480373398 Mon Sep 17 00:00:00 2001 From: curly Date: Tue, 7 Feb 2023 14:18:07 -0700 Subject: fixed get_user_by_name --- src/database.rs | 10 +++++----- 1 file changed, 5 insertions(+), 5 deletions(-) (limited to 'src/database.rs') diff --git a/src/database.rs b/src/database.rs index 5b41db7..8c26844 100644 --- a/src/database.rs +++ b/src/database.rs @@ -134,10 +134,10 @@ impl Database { } pub fn get_user(&self, id: usize) -> Option { - let query = format!("SELECT * FROM users WHERE id IS '{}'", id); - let statement = self.db.prepare(query).unwrap(); + let query = "SELECT * FROM users WHERE id IS :id"; + let statement = self.db.prepare(query).unwrap().into_iter().bind::<&[(_, sqlite::Value)]>(&[(":id", (id as i64).into())]).unwrap(); - for row in statement.into_iter().map(|row| row.unwrap()) { + for row in statement.map(|row| row.unwrap()) { let username = row.read::<&str, _>("username"); let id = row.read::("id"); @@ -150,8 +150,8 @@ impl Database { None } pub fn get_user_by_name(&self, name: String) -> Option { - let query = "SELECT * FROM users WHERE name IS :name"; - let statement = self.db.prepare(query).unwrap().into_iter().bind((":name", name.as_str())).unwrap(); + let query = "SELECT * FROM users WHERE username IS :name"; + let statement = self.db.prepare(query).unwrap().into_iter().bind::<&[(_, sqlite::Value)]>(&[(":name", name.into())]).unwrap(); for row in statement.map(|row| row.unwrap()) { let username = row.read::<&str, _>("username"); -- cgit v1.2.3