Debugging Tools
Enable all verbose logs
Running ./logging.sh
will enable all verbose logs for the queries in the provider.
More details in the script itself.
Querying the database
There are 2 different ways to easily query the database, qc
and contatcsproviderutils.sh
.
QC usage
qc
queries the deivce directly. For usage, append the query in single quotes after the command:
e.g.
qc/qc 'select * from raw_contacts'
or to get all the tables
qc/qc '.tables'
QC support SQLite language, but it might have some limitations working with complex nested queries.
contactsproviderutils.sh usage
This script downlaods the database locally and logins into a local version. It is also possible to push any change back to the device.
- Add tools to path
source contactsproviderutils.sh
- Pull
contacts2.db
and query:sqlite3-pull
This will open a sql terminal withrlwrap
which can be easily used for queries. - Pull
contacts2.db
and query with a graphical interface:sqlitebrowser-pull
- Push local updates to the device:
sqlite3-push