From a1d6b03ec98abbc073b5b73b631da6ea3eae4eb9 Mon Sep 17 00:00:00 2001
From: Julien Dessaux
Date: Wed, 27 Mar 2024 15:20:14 +0100
Subject: [node] finished the great typescript rewrite

---
 nodejs/database/markets.js | 34 ----------------------------------
 1 file changed, 34 deletions(-)
 delete mode 100644 nodejs/database/markets.js

(limited to 'nodejs/database/markets.js')

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;
-}
-- 
cgit v1.2.3