cityssm/parking-ticket-system

import sqlite from 'better-sqlite3';
import { parkingDB as databasePath } from '../../data/databasePaths.js';
import { clearCacheByTableName } from '../../helpers/functions.cache.js';
export default function addParkingBylaw(requestBody) {
    const database = sqlite(databasePath);
    const bylawRecord = database
        .prepare(`select bylawDescription, isActive
        from ParkingBylaws
        where bylawNumber = ?`)
        .get(requestBody.bylawNumber);
    if (bylawRecord !== undefined) {
        if (bylawRecord.isActive) {
            database.close();
            return {
                success: false,
                message: `By-law number "${requestBody.bylawNumber}" is already associated with the record "${bylawRecord.bylawDescription}".`
            };
        }
        const info = database
            .prepare(`update ParkingBylaws
          set isActive = 1
          where bylawNumber = ?`)
            .run(requestBody.bylawNumber);
        database.close();
        clearCacheByTableName('ParkingBylaws');
        return {
            success: info.changes > 0,
            message: `By-law number "${requestBody.bylawNumber}" is associated with a previously removed record.
          That record has been restored with the original description.`
        };
    }
    const info = database
        .prepare(`insert into ParkingBylaws (
        bylawNumber, bylawDescription,
        orderNumber, isActive)
        values (?, ?, 0, 1)`)
        .run(requestBody.bylawNumber, requestBody.bylawDescription);
    database.close();
    clearCacheByTableName('ParkingBylaws');
    return {
        success: info.changes > 0
    };
}