cityssm/parking-ticket-system

import sqlite from 'better-sqlite3';
import Debug from 'debug';
import { nhtsaDB as nhtsaDatabasePath } from '../../data/databasePaths.js';
const debug = Debug('parking-ticket-system:nhtsaDB:initializeDatabase');
export function initNHTSADB() {
    const nhtsaDB = sqlite(nhtsaDatabasePath);
    let doCreate = false;
    const row = nhtsaDB
        .prepare("select name from sqlite_master where type = 'table' and name = 'MakeModel'")
        .get();
    if (row === undefined) {
        debug(`Creating ${nhtsaDatabasePath}`);
        doCreate = true;
        nhtsaDB
            .prepare(`create table if not exists MakeModelSearchHistory (
          searchString varchar(50) primary key not null,
          resultCount integer not null,
          searchExpiryMillis integer not null) without rowid`)
            .run();
        nhtsaDB
            .prepare(`create table if not exists MakeModel (
          makeId integer,
          makeName varchar(50),
          modelId integer,
          modelName varchar(50),
          recordCreate_timeMillis integer not null,
          recordUpdate_timeMillis integer not null,
          recordDelete_timeMillis integer,
          primary key (makeName, modelName)) without rowid`)
            .run();
    }
    nhtsaDB.close();
    return doCreate;
}