1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
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;
}
|
