| commit | 0a21922adc44ac961a2cd9d103d4ba4341995654 | [log] [tgz] |
|---|---|---|
| author | Himanshu Gupta <himanshuz@google.com> | Mon Aug 18 12:22:24 2025 +0100 |
| committer | Himanshu Gupta <himanshuz@google.com> | Wed Sep 03 14:27:18 2025 +0100 |
| tree | 2413e802f7272f5de3ca5d1f34513b4546d4b552 | |
| parent | 10e32c15370f7ec2e47d561cc10f5af702333c88 [diff] |
Removing PII fields from data view in CP2 Bug: 437318646 Flag: com.android.providers.contacts.flags.restrict_pii_data_uri_columns Test: atest ContactsProviderTests Change-Id: I1f8f291fd714c2ea0e97781ea09c0cabe009b2f2
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