cityssm/parking-ticket-system

import sqlite from 'better-sqlite3'

import { parkingDB as databasePath } from '../../data/databasePaths.js'

import type { AddUpdateParkingOffenceReturn } from './getParkingOffences.js'

export default function deleteParkingOffence(
  bylawNumber: string,
  locationKey: string
): AddUpdateParkingOffenceReturn {
  const database = sqlite(databasePath)

  // Do update
  const info = database
    .prepare(
      `update ParkingOffences
        set isActive = 0
        where bylawNumber = ?
        and locationKey = ?
        and isActive = 1`
    )
    .run(bylawNumber, locationKey)

  database.close()

  return {
    success: info.changes > 0
  }
}