cityssm/lottery-licence-manager

View on GitHub
helpers/licencesDB/pokeEvent.ts

Summary

Maintainability
A
2 hrs
Test Coverage
import { runSQL_hasChanges } from "./_runSQL.js";

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


export const pokeEvent = (licenceID: number, eventDate: number, requestSession: expressSession.Session): boolean => {

  return runSQL_hasChanges("update LotteryEvents" +
    " set recordUpdate_userName = ?," +
    " recordUpdate_timeMillis = ?" +
    " where licenceID = ?" +
    " and eventDate = ?" +
    " and recordDelete_timeMillis is null", [
      requestSession.user.userName,
      Date.now(),
      licenceID,
      eventDate
    ]);
};


export default pokeEvent;