From d668eac4a63a9aa98c3efff395faa23cfcea1c1b Mon Sep 17 00:00:00 2001 From: Julien Dessaux Date: Thu, 21 Mar 2024 17:08:37 +0100 Subject: [node] begin the great typescript rewrite --- nodejs/database/contracts.js | 30 ------------------------------ 1 file changed, 30 deletions(-) delete mode 100644 nodejs/database/contracts.js (limited to 'nodejs/database/contracts.js') diff --git a/nodejs/database/contracts.js b/nodejs/database/contracts.js deleted file mode 100644 index d7f9aab..0000000 --- a/nodejs/database/contracts.js +++ /dev/null @@ -1,30 +0,0 @@ -import db from './db.js'; - -const addContractStatement = db.prepare(`INSERT INTO contracts(data) VALUES (json(?));`); -const getContractStatement = db.prepare(`SELECT data FROM contracts WHERE data->>'id' = ?;`); -const getContractsStatement = db.prepare(`SELECT data FROM contracts WHERE data->>'fulfilled' = false;`); -const updateContractStatement = db.prepare(`UPDATE contracts SET data = json(:data) WHERE data->>'id' = :id;`); - -export function getContract(id) { - const data = getContractStatement.get(id); - if (data === undefined) { - return null; - } - return JSON.parse(data.data); -} - -export function getContracts() { - const data = getContractsStatement.all(); - return data.map(contractData => JSON.parse(contractData.data)); -} - -export function setContract(data) { - if (getContract(data.id) === null) { - return addContractStatement.run(JSON.stringify(data)).lastInsertRowid; - } else { - return updateContractStatement.run({ - data: JSON.stringify(data), - id: data.id, - }).changes; - } -} -- cgit v1.2.3