From fc3501382c2aa3ef5b692f4f55c2616f9cade3f5 Mon Sep 17 00:00:00 2001
From: Tor Andersson <tor@ccxvii.net>
Date: Fri, 25 Apr 2025 12:18:00 +0200
Subject: Move toolbox scripts to a "bin" directory.

Add a super "rtt" command to run the scripts.
---
 tools/unarchive.sh | 35 -----------------------------------
 1 file changed, 35 deletions(-)
 delete mode 100644 tools/unarchive.sh

(limited to 'tools/unarchive.sh')

diff --git a/tools/unarchive.sh b/tools/unarchive.sh
deleted file mode 100644
index 6adb300..0000000
--- a/tools/unarchive.sh
+++ /dev/null
@@ -1,35 +0,0 @@
-#!/bin/bash
-# Restore purged game state from archive.
-
-if [ -z "$1" ]
-then
-        echo 'usage: bash tools/unarchive.sh <gameid>'
-        exit 1
-fi
-
-sqlite3 db << EOF
-
-attach database 'archive.db' as archive;
-
-begin;
-
-select 'RESTORE ' || $1 || ' FROM ARCHIVE';
-
-.mode table
-select * from archive.games where game_id = $1;
-
-insert or replace into game_state (game_id, state)
-	select game_id, state
-	from archive.game_state where game_id = $1;
-
-insert or replace into game_replay (game_id, replay_id, role, action, arguments)
-	select game_id, replay_id, role, action, arguments
-	from archive.game_replay where game_id = $1;
-
-insert or replace into game_chat (game_id, chat_id, user_id, time, message)
-	select game_id, chat_id, user_id, time, message
-	from archive.game_chat where game_id = $1;
-
-commit;
-
-EOF
-- 
cgit v1.2.3