commit | 23293ed735319c89675ba3c0be2f424891ae01f8 | [log] [tgz] |
---|---|---|
author | Bill Yi <byi@google.com> | Tue Jun 27 06:41:40 2023 +0000 |
committer | Automerger Merge Worker <android-build-automerger-merge-worker@system.gserviceaccount.com> | Tue Jun 27 06:41:40 2023 +0000 |
tree | 6c8f6cf55023d4dd25c41343b9e850a8a7c8d437 | |
parent | 21dcaf75ea97c2b636abb906d1c4f7f203f7ca13 [diff] | |
parent | 581fd8bb6860356898ce79cd272c2df53f9b62c5 [diff] |
[automerger skipped] Import translations. DO NOT MERGE ANYWHERE am: 840c7c718b -s ours am: 79c02a051d -s ours am: b0e3822730 -s ours am: 581602abe9 -s ours am: 581fd8bb68 -s ours am skip reason: subject contains skip directive Original change: https://googleplex-android-review.googlesource.com/c/platform/packages/providers/ContactsProvider/+/23788614 Change-Id: Iefac7bf9570da92dd9f60fabd8b7cb2ac6b08e5f Signed-off-by: Automerger Merge Worker <android-build-automerger-merge-worker@system.gserviceaccount.com>
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