cityssm/parking-ticket-system

import sqlite from 'better-sqlite3'

import { parkingDB as databasePath } from '../../data/databasePaths.js'
import { clearCacheByTableName } from '../../helpers/functions.cache.js'
import type { ParkingBylaw } from '../../types/recordTypes.js'

import type { AddUpdateParkingBylawReturn } from './getParkingBylaws.js'

export default function addParkingBylaw(
  requestBody: ParkingBylaw
): AddUpdateParkingBylawReturn {
  const database = sqlite(databasePath)

  // Check if key is already used

  const bylawRecord = database
    .prepare(
      `select bylawDescription, isActive
        from ParkingBylaws
        where bylawNumber = ?`
    )
    .get(requestBody.bylawNumber) as ParkingBylaw | undefined

  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}".`
      }
    }

    // Do update

    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.`
    }
  }

  // Do insert

  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
  }
}