diff options
Diffstat (limited to 'nodejs/database/markets.js')
-rw-r--r-- | nodejs/database/markets.js | 34 |
1 files changed, 0 insertions, 34 deletions
diff --git a/nodejs/database/markets.js b/nodejs/database/markets.js deleted file mode 100644 index 522f57f..0000000 --- a/nodejs/database/markets.js +++ /dev/null @@ -1,34 +0,0 @@ -import db from './db.js'; -import * as utils from '../lib/utils.js'; - -const addMarketStatement = db.prepare(`INSERT INTO markets(system, data) VALUES (?, json(?));`); -const getMarketAtWaypointStatement = db.prepare(`SELECT data FROM markets WHERE data->>'symbol' = ?;`); -const getMarketsInSystemStatement = db.prepare(`SELECT data FROM markets WHERE system = ?;`); -const updateMarketStatement = db.prepare(`UPDATE markets SET data = json(:data) WHERE data->>'symbol' = :symbol;`); - -export function getMarketAtWaypoint(symbol) { - const data = getMarketAtWaypointStatement.get(symbol); - if (data === undefined) { - return null; - } - return JSON.parse(data.data); -} - -export function getMarketsInSystem(symbol) { - const data = getMarketsInSystemStatement.get(symbol); - if (data === undefined) { - return null; - } - return JSON.parse(data.data); -} - -export function setMarket(data) { - if (getMarketAtWaypoint(data.symbol) === null) { - const system = utils.systemFromWaypoint(data.symbol); - return addMarketStatement.run(system, JSON.stringify(data)).lastInsertRowid; - } - return updateMarketStatement.run({ - data: JSON.stringify(data), - symbol: data.symbol, - }).changes; -} |