commit	ed11413d226c5606a0ff1cedd32817c204d276c1	[log] [tgz]
author	Android Build Coastguard Worker <android-build-coastguard-worker@google.com>	Thu Dec 05 00:18:38 2024 +0000
committer	Android Build Coastguard Worker <android-build-coastguard-worker@google.com>	Thu Dec 05 00:18:38 2024 +0000
tree	af576ba72daa3b4411d16d66392b6ea7fea3ef44
parent	43d4e811a36e6ab87c445cfdea0044f598e875a0 [diff]
parent	2483792d1d9c38b0f95073c20558cf79b06c71bb [diff]

tree: af576ba72daa3b4411d16d66392b6ea7fea3ef44

README.md

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.

There are 2 different ways to easily query the database, qc and contatcsproviderutils.sh.

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.

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 with rlwrap 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
```