nodejs/database/markets.ts


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26

import { DbData, db } from './db.ts';
import { Market } from '../model/market.ts';
import { systemFromWaypoint } from '../lib/utils.ts';

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: string): Market|null {
    const data = getMarketAtWaypointStatement.get(symbol) as DbData|undefined;
	if (!data) return null;
    return JSON.parse(data.data);
}

export function setMarket(data: Market): void {
    if (getMarketAtWaypoint(data.symbol) === null) {
		const system = systemFromWaypoint(data.symbol);
		addMarketStatement.run(system, JSON.stringify(data));
    } else {
		updateMarketStatement.run({
			data: JSON.stringify(data),
			symbol: data.symbol,
		});
	}
}