summaryrefslogtreecommitdiff
path: root/database/users.js
blob: cc50bdcbad9c1d65d4e6655147e49c65c9562748 (plain)
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
35
36
37
38
39
40
41
42
43
44
45
46
import bcrypt from 'bcrypt';

import db from './db.js';

const saltRounds = 10;

const createUserStatement = db.prepare('INSERT INTO users (username, hash, email) VALUES (?, ?, ?);');
const getUserByUsernameStatement = db.prepare('SELECT id, username, email from users WHERE username = ?;');
const loginStatement = db.prepare('SELECT id, username, 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 (err) {
		console.log(err);
		return null;
	}
}

export function getUserByUsername(username) {
	try {
		return getUserByUsernameStatement.get(username);
	} catch (err) {
		console.log(err);
		return null;
	}
}

export async function login(username, password) {
	try {
		var user = loginStatement.get(username);
	} catch (err) {
		console.log(err);
		return null;
	}
	const result = await bcrypt.compare(password, user.hash);
	if (result === true) {
		return {
			id: user.id,
			username: username,
			email: user.email,
		};
	}
	return null;
}