cityssm/lottery-licence-manager

View on GitHub
helpers/licencesDB/restoreLocation.js

Summary

Maintainability
A
2 hrs
Test Coverage
F
20%
import { runSQL_hasChanges } from "./_runSQL.js";
export const restoreLocation = (locationID, requestSession) => {
    const nowMillis = Date.now();
    return runSQL_hasChanges("update Locations" +
        " set recordDelete_userName = null," +
        " recordDelete_timeMillis = null," +
        " recordUpdate_userName = ?," +
        " recordUpdate_timeMillis = ?" +
        " where recordDelete_timeMillis is not null" +
        " and locationID = ?", [
        requestSession.user.userName,
        nowMillis,
        locationID
    ]);
};