| commit | 6fa2480066ac7052c3c07937b208ca774f57ab96 | [log] [tgz] |
|---|---|---|
| author | Android Build Coastguard Worker <android-build-coastguard-worker@google.com> | Fri Jul 12 04:05:19 2024 +0000 |
| committer | Android Build Coastguard Worker <android-build-coastguard-worker@google.com> | Fri Jul 12 04:05:19 2024 +0000 |
| tree | 8f7c1227a41168b0aa8ef9bd9dd5a9df73ac25c9 | |
| parent | 7145dfc6096dbf025ad8703d8d1805c0016cd1f1 [diff] | |
| parent | fc00cced7d7646aef1a5c8f518a1c5d4ab8bd767 [diff] |
Merge cherrypicks of ['googleplex-android-review.googlesource.com/28239254'] into 24Q3-release. Change-Id: I7525123f75c82daae75d74b71d3b197ec5b43e7f
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.
source contactsproviderutils.sh
contacts2.db and query:sqlite3-pullThis will open a sql terminal with
rlwrap which can be easily used for queries.contacts2.db and query with a graphical interface:sqlitebrowser-pull
sqlite3-push