Added register and login database functions, and use the last one in the login route

1 files changed, 34 insertions, 0 deletions

diff --git a/database/users.js b/database/users.js
new file mode 100644
index 0000000..4b534b8
--- /dev/null
+++ b/database/users.js
@@ -0,0 +1,34 @@
+import bcrypt from "bcrypt";
+
+import db from "./db.js";
+
+const saltRounds = 10;
+
+const createUserStatement = db.prepare("INSERT INTO users (username, hash, email) VALUES (?, ?, ?);");
+const loginStatement = db.prepare("SELECT id, hash, email FROM users WHERE username = ?;");
+
+export async function createUser(username, password, email) {
+	const hash = await bcrypt.hash(password, saltRounds);
+	try {
+		return createUserStatement.run(username, hash, email).lastInsertRowid;
+	} catch {
+		return null;
+	}
+}
+
+export async function login(username, password) {
+	try {
+		var user = loginStatement.get(username);
+	} catch {
+		return null;
+	}
+	const result = await bcrypt.compare(password, user.hash);
+	if (result === true) {
+		return {
+			id: user.id,
+			username: username,
+			email: user.email,
+		};
+	}
+	return null;
+}