cityssm/lottery-licence-manager

import sqlite from "better-sqlite3";

import { getMaxLicenceAmendmentIndexWithDB } from "./getMaxLicenceAmendmentIndex.js";

import * as dateTimeFns from "@cityssm/expressjs-server-js/dateTimeFns.js";

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


export const addLicenceAmendmentWithDB = (database: sqlite.Database,
  licenceID: number | string, amendmentType: string, amendment: string, isHidden: number,
  requestSession: expressSession.Session): number => {

  const newAmendmentIndex = getMaxLicenceAmendmentIndexWithDB(database, licenceID) + 1;

  const nowDate = new Date();

  const amendmentDate = dateTimeFns.dateToInteger(nowDate);
  const amendmentTime = dateTimeFns.dateToTimeInteger(nowDate);

  database.prepare("insert into LotteryLicenceAmendments" +
    " (licenceID, amendmentIndex, amendmentDate, amendmentTime, amendmentType, amendment, isHidden," +
    " recordCreate_userName, recordCreate_timeMillis, recordUpdate_userName, recordUpdate_timeMillis)" +
    " values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)")
    .run(
      licenceID,
      newAmendmentIndex,
      amendmentDate,
      amendmentTime,
      amendmentType,
      amendment,
      isHidden,
      requestSession.user.userName,
      nowDate.getTime(),
      requestSession.user.userName,
      nowDate.getTime()
    );

  return newAmendmentIndex;
};