import sqlite from 'better-sqlite3'; import { sunriseDB } from '../helpers/database.helpers.js'; export default function deleteWorkOrderContract(workOrderId, contractId, user) { const database = sqlite(sunriseDB); const result = database .prepare(`update WorkOrderContracts set recordDelete_userName = ?, recordDelete_timeMillis = ? where workOrderId = ? and contractId = ?`) .run(user.userName, Date.now(), workOrderId, contractId); database.close(); return result.changes > 0; }