cityssm/contract-expiration-tracker

import sqlite from "better-sqlite3";
import { contractsDB as databasePath } from "../../data/databasePaths.js";

import type * as expressSession from "express-session";


export const removeContract = (contractId: number | string, requestSession: expressSession.Session): boolean => {

  const rightNowMillis = Date.now();

  const database = sqlite(databasePath);

  database.prepare("update Contracts" +
    " set recordDelete_userName = ?," +
    " recordDelete_timeMillis = ?" +
    " where contractId = ?")
    .run(requestSession.user.userName,
      rightNowMillis,
      contractId);

  database.close();

  return true;
};