moodiary_dumpdb

#!/usr/bin/env bash
which adb || exit 

if [ -z "$1" ]
then
    echo "Usage: $(basename $0) com.app.package.name dbname" >&2
    exit 1
fi

pkg=$1
dbname=$2
out=/tmp/${pkg}.sqlite3 

echo "Broadening database file mask"
adb exec-out run-as $pkg chmod 666 databases/$dbname

echo "Dumping database"
adb exec-out run-as $pkg cat /data/data/${pkg}/databases/${dbname} > $out || exit 1

echo
echo $out
sqlitebrowser $out