helpers/licencesDB/getLocation.js
import { canUpdateObject } from "../licencesDB.js";
import sqlite from "better-sqlite3";
import { licencesDB as databasePath } from "../../data/databasePaths.js";
export const getLocation = (locationID, requestSession) => {
const database = sqlite(databasePath, {
readonly: true
});
const locationObject = database.prepare("select * from Locations" +
" where locationID = ?")
.get(locationID);
if (locationObject) {
locationObject.recordType = "location";
locationObject.locationDisplayName =
locationObject.locationName === "" ? locationObject.locationAddress1 : locationObject.locationName;
locationObject.canUpdate = canUpdateObject(locationObject, requestSession);
}
database.close();
return locationObject;
};