cityssm/faster-web-helper

import sqlite from 'better-sqlite3';
import { databasePath } from './databaseHelpers.js';
export default function addWorkOrderNumberMapping(workOrderNumberMapping) {
    const database = sqlite(databasePath);
    const results = database
        .prepare(`insert into WorkOrderNumberMappings
        (documentNumber, workOrderNumber, exportDate, exportTime)
        values (?, ?, ?, ?)`)
        .run(workOrderNumberMapping.documentNumber, workOrderNumberMapping.workOrderNumber, workOrderNumberMapping.exportDate, workOrderNumberMapping.exportTime);
    database.close();
    return results.changes > 0;
}