From a0fcb7dd40fbd55b9f28aecf3f9f5ca12e91b672 Mon Sep 17 00:00:00 2001 From: Tor Andersson Date: Sun, 23 Feb 2025 11:24:45 +0100 Subject: Update player is_active when importing games by forcing trigger. --- tools/import-game.js | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) (limited to 'tools') diff --git a/tools/import-game.js b/tools/import-game.js index 59b26a7..42391e1 100755 --- a/tools/import-game.js +++ b/tools/import-game.js @@ -40,8 +40,9 @@ for (let file of input) { let db = new sqlite3("db") let insert_game = db.prepare("insert into games(status,owner_id,title_id,scenario,options,player_count,active,moves,notice) values (1,1,:title_id,:scenario,:options,:player_count,:active,:moves,:notice) returning game_id").pluck() - let insert_player = db.prepare("insert into players(game_id,role,user_id) values (?,?,?)") + let insert_player = db.prepare("insert into players(game_id,role,user_id,clock) values (?,?,?,21)") let insert_state = db.prepare("insert into game_state(game_id,state) values (?,?)") + let update_active_trigger = db.prepare("update games set active=active where game_id=?") let select_user = db.prepare("select user_id from users where name=?").pluck() @@ -57,6 +58,7 @@ for (let file of input) { for (let p of game.players) insert_player.run(game_id, p.role, find_user(p.name)) insert_state.run(game_id, JSON.stringify(game.state)) + update_active_trigger.run(game_id) if (game.replay) { let insert_replay = db.prepare("insert into game_replay(game_id,replay_id,role,action,arguments) values (?,?,?,?,?)") -- cgit v1.2.3