diff options
Diffstat (limited to 'tools/unarchive.sh')
-rw-r--r-- | tools/unarchive.sh | 35 |
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 |