cityssm/contract-expiration-tracker

import sqlite from "better-sqlite3";
import { contractsDB as databasePath } from "../../data/databasePaths.js";
export const getContractTitle = (contractId) => {
    const database = sqlite(databasePath, {
        readonly: true
    });
    const contractTitle = database.prepare("select contractTitle" +
        " from Contracts" +
        " where recordDelete_timeMillis is null" +
        " and contractId = ?")
        .get(contractId)
        .contractTitle;
    database.close();
    return contractTitle;
};
export default getContractTitle;