summaryrefslogtreecommitdiff
path: root/nodejs/database/markets.js
diff options
context:
space:
mode:
Diffstat (limited to 'nodejs/database/markets.js')
-rw-r--r--nodejs/database/markets.js34
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;
-}