From 68c457964a02d290f3fe225b090c549d664bb836 Mon Sep 17 00:00:00 2001 From: Julien Dessaux Date: Thu, 1 Jun 2023 01:11:21 +0200 Subject: Another big refactoring --- database/config.js | 10 +++++----- 1 file changed, 5 insertions(+), 5 deletions(-) (limited to 'database/config.js') diff --git a/database/config.js b/database/config.js index 6db856e..4a86cb6 100644 --- a/database/config.js +++ b/database/config.js @@ -1,20 +1,20 @@ import db from './db.js'; -const getTokenStatement = db.prepare(`SELECT value from config where key = 'token';`); -const registerAgentStatement = db.prepare(`INSERT INTO config(key, value) VALUES ('symbol', ?), ('faction', ?), ('token', ?);`); +const getTokenStatement = db.prepare(`SELECT json_extract(value, '$.token') as token from config where key = 'register_data';`); +const registerAgentStatement = db.prepare(`INSERT INTO config(key, value) VALUES ('register_data', json(?));`); export function getToken() { try { - return getTokenStatement.get().value; + return getTokenStatement.get().token; } catch (err) { console.log(err); return null; } } -export function registerAgent(symbol, faction, token) { +export function registerAgent(data) { try { - registerAgentStatement.run(symbol, faction, token); + registerAgentStatement.run(JSON.stringify(data)); return true; } catch (err) { console.log(err); -- cgit v1.2.3