diff options
Diffstat (limited to 'database/config.js')
-rw-r--r-- | database/config.js | 10 |
1 files changed, 5 insertions, 5 deletions
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); |