fixed get_user_by_name

1 files changed, 5 insertions, 5 deletions

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<User> {
-        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::<i64, _>("id");
@@ -150,8 +150,8 @@ impl Database {
         None
     }
     pub fn get_user_by_name(&self, name: String) -> Option<User> {
-        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");