From c235a8239177d38117f3313d17b904b66a806378 Mon Sep 17 00:00:00 2001
From: Tor Andersson <tor@ccxvii.net>
Date: Wed, 14 Feb 2024 23:20:44 +0100
Subject: Add import-game and export-game scripts.

To bulk transfer all game state, replay, and snapshots into a new game.
---
 tools/export-game.sh |  8 ++++++++
 tools/import-game.js | 47 +++++++++++++++++++++++++++++++++++++++++++++++
 tools/patchgame.js   |  4 ++--
 3 files changed, 57 insertions(+), 2 deletions(-)
 create mode 100644 tools/export-game.sh
 create mode 100755 tools/import-game.js

(limited to 'tools')

diff --git a/tools/export-game.sh b/tools/export-game.sh
new file mode 100644
index 0000000..19cd4e7
--- /dev/null
+++ b/tools/export-game.sh
@@ -0,0 +1,8 @@
+#!/bin/bash
+if [ -n "$1" ]
+then
+	sqlite3 db "select export from game_export_view where game_id=$1"
+else
+	echo "usage: bash tools/export-game.sh GAME > game.json"
+fi
+
diff --git a/tools/import-game.js b/tools/import-game.js
new file mode 100755
index 0000000..e8553df
--- /dev/null
+++ b/tools/import-game.js
@@ -0,0 +1,47 @@
+#!/usr/bin/env -S node
+
+const fs = require("fs")
+const sqlite3 = require("better-sqlite3")
+
+if (process.argv.length !== 3) {
+	console.error("usage: node tools/import-game.js game.json")
+	process.exit(1)
+}
+
+var game = JSON.parse(fs.readFileSync(process.argv[2], "utf8"))
+
+game.setup.active = game.state.active
+game.setup.moves = game.snaps && game.snaps.length > 0 ? game.snaps.length - 1 : 0
+
+let db = new sqlite3("db")
+
+let insert_game = db.prepare("insert into games(status,title_id,scenario,options,player_count,active,moves,notice) values (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 (?,?,1)")
+let insert_state = db.prepare("insert into game_state(game_id,state) values (?,?)")
+
+db.exec("begin")
+
+game.setup.options = JSON.stringify(game.setup.options)
+
+let game_id = insert_game.get(game.setup)
+for (let p of game.players)
+	insert_player.run(game_id, p.role)
+insert_state.run(game_id, JSON.stringify(game.state))
+
+if (game.replay) {
+	let insert_replay = db.prepare("insert into game_replay(game_id,replay_id,role,action,arguments) values (?,?,?,?,?)")
+	game.replay.forEach(([role, action, args], i) => {
+		insert_replay.run(game_id, i+1, role, action, JSON.stringify(args))
+	})
+}
+
+if (game.snaps) {
+	let insert_snap = db.prepare("insert into game_snap(game_id,snap_id,replay_id,state) values (?,?,?,?)")
+	game.snaps.forEach(([replay_id, state], i) => {
+		insert_snap.run(game_id, i+1, replay_id, JSON.stringify(state))
+	})
+}
+
+console.log(game_id)
+
+db.exec("commit")
diff --git a/tools/patchgame.js b/tools/patchgame.js
index 3a21f67..e191df8 100755
--- a/tools/patchgame.js
+++ b/tools/patchgame.js
@@ -79,10 +79,10 @@ function is_valid_action(rules, state, role, action, arg) {
 	if (va) {
 		if (Array.isArray(arg))
 			arg = arg[0]
-		if (arg === undefined || arg === null)
-			return (va === 1 || va === true || typeof va === "string")
 		if (Array.isArray(va) && va.includes(arg))
 			return true
+		if (arg === undefined || arg === null || arg === 1)
+			return (va === 1 || va === true || typeof va === "string")
 	}
 	return false
 }
-- 
cgit v1.2.3