From 5c7ece5dbb1867dafd067a6c933f9200fdfe2b04 Mon Sep 17 00:00:00 2001 From: Jérémy Zurcher Date: Sun, 13 Mar 2016 22:52:04 +0100 Subject: update tools to follow SQL changes --- tools/dump_payload | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'tools/dump_payload') diff --git a/tools/dump_payload b/tools/dump_payload index 27ae33cd..365de159 100755 --- a/tools/dump_payload +++ b/tools/dump_payload @@ -1,7 +1,7 @@ #! /bin/bash -sqlite3 android/assets/data/rustanddust.sqlite 'select payload from states where _g=(select _id from games order by ts desc limit 1)' > state.json +sqlite3 android/assets/data/rustanddust.sqlite 'select payload from games order by ts desc limit 1' > game.json sqlite3 android/assets/data/rustanddust.sqlite 'select payload from turns where _id=(select max(_id) from turns)' > turn.json echo "[" > turns.json -sqlite3 android/assets/data/rustanddust.sqlite 'select payload from turns where _g=(select _id from games order by ts desc limit 1) order by _id' | while read rec; do echo "$rec,"; done >> turns.json +sqlite3 android/assets/data/rustanddust.sqlite 'select payload from turns where game=(select _id from games order by ts desc limit 1) order by _id' | while read rec; do echo "$rec,"; done >> turns.json sed -i '$s/,$/]/' turns.json -- cgit v1.2.3