diff options
Diffstat (limited to 'src/bin/server/database.rs')
| -rw-r--r-- | src/bin/server/database.rs | 31 |
1 files changed, 0 insertions, 31 deletions
diff --git a/src/bin/server/database.rs b/src/bin/server/database.rs deleted file mode 100644 index 9c51997..0000000 --- a/src/bin/server/database.rs +++ /dev/null | |||
| @@ -1,31 +0,0 @@ | |||
| 1 | use rusqlite::Connection; | ||
| 2 | |||
| 3 | pub fn init_db() -> Connection { | ||
| 4 | let conn = Connection::open("server.db").unwrap(); | ||
| 5 | conn.execute( | ||
| 6 | "CREATE TABLE IF NOT EXISTS users ( | ||
| 7 | username TEXT PRIMARY KEY, | ||
| 8 | hashed_password TEXT NOT NULL | ||
| 9 | )", | ||
| 10 | [], | ||
| 11 | ).unwrap(); | ||
| 12 | conn | ||
| 13 | } | ||
| 14 | |||
| 15 | pub fn add_user(conn: &Connection, username: &str, hashed_password: &str) -> Result<(), Box<dyn std::error::Error>> { | ||
| 16 | conn.execute( | ||
| 17 | "INSERT INTO users (username, hashed_password) VALUES (?1, ?2)", | ||
| 18 | [username, hashed_password], | ||
| 19 | )?; | ||
| 20 | Ok(()) | ||
| 21 | } | ||
| 22 | |||
| 23 | pub fn get_hashed_password(conn: &Connection, username: &str) -> Option<String> { | ||
| 24 | let mut stmt = conn.prepare("SELECT hashed_password FROM users WHERE username = ?1").unwrap(); | ||
| 25 | let mut rows = stmt.query([username]).unwrap(); | ||
| 26 | if let Ok(Some(row)) = rows.next() { | ||
| 27 | row.get(0).ok() | ||
| 28 | } else { | ||
| 29 | None | ||
| 30 | } | ||
| 31 | } | ||
