cityssm/lottery-licence-manager

/* eslint-disable unicorn/filename-case */

import sqlite from "better-sqlite3";

import { licencesDB as databasePath } from "../../data/databasePaths.js";

import debug from "debug";
const debugSQL = debug("lottery-licence-manager:licencesDB:runSQL");


export const runSQL = (sql: string, parameters = []): sqlite.RunResult => {

  const database = sqlite(databasePath);

  try {
    return database.prepare(sql).run(...parameters);
  } catch (error) {
    debugSQL(error);
  } finally {
    try {
      database.close();
    } catch {
      // ignore
    }
  }
};


export const runSQL_hasChanges = (sql: string, parameters = []): boolean => {

  const result = runSQL(sql, parameters);

  if (result) {
    return result.changes > 0;
  }

  return false;
};