diff options
author | Julien Dessaux | 2023-09-13 23:38:24 +0200 |
---|---|---|
committer | Julien Dessaux | 2023-09-13 23:38:24 +0200 |
commit | 14f81bcc1b50116118bd421e2cdea7050fc1a890 (patch) | |
tree | 4132f05e3909572cf9ffc3d5639b13125321f801 /nodejs/database/systems.js | |
parent | [javascript] added database function to fetch all the ships present in a spec... (diff) | |
download | spacetraders-14f81bcc1b50116118bd421e2cdea7050fc1a890.tar.gz spacetraders-14f81bcc1b50116118bd421e2cdea7050fc1a890.tar.bz2 spacetraders-14f81bcc1b50116118bd421e2cdea7050fc1a890.zip |
[javascript] reworked basic exploration with systems fetch after registering
Diffstat (limited to 'nodejs/database/systems.js')
-rw-r--r-- | nodejs/database/systems.js | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/nodejs/database/systems.js b/nodejs/database/systems.js index 6cfc75a..dd70d33 100644 --- a/nodejs/database/systems.js +++ b/nodejs/database/systems.js @@ -3,6 +3,7 @@ import db from './db.js'; const addSystemStatement = db.prepare(`INSERT INTO systems(data) VALUES (json(?));`); const getSystemStatement = db.prepare(`SELECT data FROM systems WHERE data->>'symbol' = ?;`); const getSystemUpdatedStatement = db.prepare(`SELECT updated FROM systems WHERE data->>'symbol' = ?;`); +const getSystemsCountStatement = db.prepare(`SELECT COUNT(data) as data FROM systems;`); const setSystemWaypointsStatement = db.prepare(`UPDATE systems SET data = (SELECT json_set(data, '$.waypoints', json(:waypoints)) FROM systems WHERE data->>'symbol' = :symbol), updated = :date WHERE data->>'symbol' = :symbol;`); export function addSystem(data) { @@ -17,6 +18,14 @@ export function getSystem(symbol) { return JSON.parse(data.data); } +export function getSystemsCount() { + const data = getSystemsCountStatement.get(); + if (data === undefined) { + return null; + } + return data.data; +} + export function getSystemUpdated(symbol) { const updated = getSystemUpdatedStatement.get(symbol); if (updated === undefined) { |