cityssm/lottery-licence-manager

View on GitHub
helpers/licencesDB/getMaxOrganizationBankRecordIndex.js

Summary

Maintainability
A
1 hr
Test Coverage
F
18%
export const getMaxOrganizationBankRecordIndexWithDB = (database, organizationID) => {
    const result = database.prepare("select recordIndex" +
        " from OrganizationBankRecords" +
        " where organizationID = ?" +
        " order by recordIndex desc" +
        " limit 1")
        .get(organizationID);
    return (result
        ? result.recordIndex
        : -1);
};