summaryrefslogtreecommitdiff
path: root/tools/unarchive.sh
diff options
context:
space:
mode:
Diffstat (limited to 'tools/unarchive.sh')
-rw-r--r--tools/unarchive.sh35
1 files changed, 0 insertions, 35 deletions
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