helpers/licencesDB/createEvent.js
import * as dateTimeFns from "@cityssm/expressjs-server-js/dateTimeFns.js";
export const createEventWithDB = (database, licenceID, eventDateString, requestSession) => {
const nowMillis = Date.now();
database.prepare("insert or ignore into LotteryEvents (" +
"licenceID, eventDate," +
" recordCreate_userName, recordCreate_timeMillis," +
" recordUpdate_userName, recordUpdate_timeMillis)" +
" values (?, ?, ?, ?, ?, ?)")
.run(licenceID, dateTimeFns.dateStringToInteger(eventDateString), requestSession.user.userName, nowMillis, requestSession.user.userName, nowMillis);
};