cityssm/parking-ticket-system

import sqlite from 'better-sqlite3';
import { parkingDB as databasePath } from '../../data/databasePaths.js';
export function isParkingTicketInConvictionBatchWithDB(database, ticketId) {
    const batchStatusCheck = database
        .prepare(`select statusField
        from ParkingTicketStatusLog
        where recordDelete_timeMillis is null
        and ticketId = ?
        and statusKey = 'convictionBatch'`)
        .get(ticketId);
    if (batchStatusCheck !== undefined) {
        return {
            inBatch: true,
            batchIdString: batchStatusCheck.statusField
        };
    }
    return {
        inBatch: false
    };
}
export default function isParkingTicketInConvictionBatch(ticketId) {
    const database = sqlite(databasePath, {
        readonly: true
    });
    const result = isParkingTicketInConvictionBatchWithDB(database, ticketId);
    database.close();
    return result;
}