Easy acces to Android emulator database

monitordb.sh

#!/bin/sh

while :
do

./querydb.sh
sleep 2

done

querydb.sh

#!/bin/sh
clear

# extrat db from emulator
/Users/user/android-sdks/platform-tools/adb pull /data/data/com.test.app/databases/database.db database.db

# config sql
echo ".mode column" >> commands.txt
echo ".headers on" >> commands.txt

# code
echo ".tables" >> commands.txt # show tables
echo "select * from table;" >> commands.txt

# exec sql
sqlite3 database.db < commands.txt

# remove
rm commands.txt
rm database.db

Combine with this and you have the information automatically updated.

!/bin/sh

while :
do

./querydb.sh
sleep 2

done