cityssm/contract-expiration-tracker

import sqlite from "better-sqlite3";
import { contractsDB as databasePath } from "../../data/databasePaths.js";
import { v4 as uuidv4 } from "uuid";
export const resetUserAccessGUIDs = (userName) => {
    const database = sqlite(databasePath);
    const guidA = uuidv4().toLowerCase();
    const guidB = uuidv4().toLowerCase();
    database.prepare("delete from UserAccessGUIDs" +
        " where userName = ?")
        .run(userName);
    database.prepare("insert into UserAccessGUIDs" +
        " (userName, guidA, guidB, recordCreate_timeMillis)" +
        " values (?, ?, ?, ?)")
        .run(userName, guidA, guidB, Date.now());
    database.close();
    return {
        guidA,
        guidB
    };
};
export default resetUserAccessGUIDs;