diff options
| author | Jérémy Zurcher <jeremy@asynk.ch> | 2016-03-13 22:52:04 +0100 |
|---|---|---|
| committer | Jérémy Zurcher <jeremy@asynk.ch> | 2016-03-13 22:52:04 +0100 |
| commit | 5c7ece5dbb1867dafd067a6c933f9200fdfe2b04 (patch) | |
| tree | 1dbf8f709c35635a97e7568048e0eda7d93c5559 | |
| parent | 749e3221b45cd0696a5f48551be696e75b5b6e55 (diff) | |
| download | RustAndDust-5c7ece5dbb1867dafd067a6c933f9200fdfe2b04.zip RustAndDust-5c7ece5dbb1867dafd067a6c933f9200fdfe2b04.tar.gz | |
update tools to follow SQL changes
| -rwxr-xr-x | tools/dump_payload | 4 | ||||
| -rwxr-xr-x | tools/inspect-android | 4 |
2 files changed, 4 insertions, 4 deletions
diff --git a/tools/dump_payload b/tools/dump_payload index 27ae33c..365de15 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 diff --git a/tools/inspect-android b/tools/inspect-android index e44d9ed..760b0d8 100755 --- a/tools/inspect-android +++ b/tools/inspect-android @@ -25,6 +25,6 @@ echo echo " *** GAMES ***" sqlite3 db.sqlite 'select * from games;' echo -echo " *** STATES ***" -sqlite3 db.sqlite 'select * from states;' +echo " *** TURNS ***" +sqlite3 db.sqlite 'select * from turns;' echo |