| commit | 8ae2996fbd1981362db5a20abb392fcb7546c386 | [log] [tgz] |
|---|---|---|
| author | Ishneet Ahuja <ishneet@google.com> | Fri Jun 16 14:07:30 2023 +0000 |
| committer | Ishneet Ahuja <ishneet@google.com> | Thu Jun 22 17:32:14 2023 +0000 |
| tree | 6e48b3ebc0a2300ce6eb35f9fa307a15058d84bd | |
| parent | 8728a030f420b88e16a23b3645d67b989999913f [diff] |
Deprecate use of nickname database.Preventing aggregation of contacts based on nicknames is a separate change. Test: atest ContactsProviderTests CtsContactsProviderTestCases Bug: 284947805 Change-Id: Ife0fe4e705b248463962ffa35eb2c1e54fe2dd18
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