cityssm/parking-ticket-system

import sqlite from 'better-sqlite3'

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

// eslint-disable-next-line @typescript-eslint/naming-convention
export default function cleanupLicencePlateOwnersTable(
  recordDeleteTimeMillis: number
): boolean {
  const database = sqlite(databasePath)

  database
    .prepare(
      `delete from LicencePlateOwners
        where recordDelete_timeMillis is not null
        and recordDelete_timeMillis < ?`
    )
    .run(recordDeleteTimeMillis)

  database.close()

  return true
}