WebService/repositories/userRepository.js

const database = require("../modules/database")

function register(firstName = null, lastName = null, username, hashedPassword) {
    const query = `
        INSERT INTO accounts (
            firstName,
            lastName,
            username,
            password
        )
            
        VALUES (
            ?,
            ?,
            ?,
            ?
        )
    `
    const statement = database.prepare(query)
    return statement.run(firstName, lastName, username, hashedPassword)
}

function remove(id) {
    const query = `
        DELETE FROM accounts
            WHERE id = ?
    `
    const statement = database.prepare(query)
    return statement.run(id)
}

function changePassword(id, hashedPassword) {
    const query = `
        UPDATE accounts
            SET password = ?
            WHERE id = ?
    `
    const statement = database.prepare(query)
    return statement.run(id, hashedPassword)
}

function findByUsername(identifier) {
    const query = `
        SELECT id, username, password
            FROM accounts
            WHERE username = ?
    `
    const statement = database.prepare(query)
    return statement.get(identifier)
}

function findById(identifier) {
    const query = `
        SELECT id, firstName, lastName, username, createdAt
            FROM accounts
            WHERE id = ?
    `
    const statement = database.prepare(query)
    return statement.get(identifier)
}

module.exports = {
    remove,
    register,
    findById,
    findByUsername,
    changePassword,
}