cityssm/lottery-licence-manager

import type * as expressSession from "express-session";
import type * as sqlite from "better-sqlite3";


export const deleteLicenceTicketTypeWithDB = (database: sqlite.Database,
  ticketTypeDefinition: {
    licenceID: number | string;
    ticketTypeIndex: number | string;
  },
  requestSession: expressSession.Session): sqlite.RunResult => {

  return database.prepare("update LotteryLicenceTicketTypes" +
    " set recordDelete_userName = ?," +
    " recordDelete_timeMillis = ?" +
    " where licenceID = ?" +
    " and ticketTypeIndex = ?")
    .run(
      requestSession.user.userName,
      Date.now(),
      ticketTypeDefinition.licenceID,
      ticketTypeDefinition.ticketTypeIndex
    );
};