commit | 2c3e0d556b7f0c09aeca23a34ace1802b4cfb35c | [log] [tgz] |
---|---|---|
author | Xin Li <delphij@google.com> | Tue Aug 29 20:38:28 2023 +0000 |
committer | Automerger Merge Worker <android-build-automerger-merge-worker@system.gserviceaccount.com> | Tue Aug 29 20:38:28 2023 +0000 |
tree | e6c81db0a7356df8927e203627517b8a7fe3d59d | |
parent | b350b5d83aebc7028c9b6cff513fb7a9c1b8fa47 [diff] | |
parent | 1ab4b31fdcd3fdc623cfb77ca6dcf99896adb7ef [diff] |
[automerger skipped] Merge Android U (ab/10368041) am: ea7903d4ca -s ours am: 66dd1b39ea -s ours am: 3a6565fd91 -s ours am: 1ab4b31fdc -s ours am skip reason: Merged-In I9065bd5c0923465efa9cb94fc33dafa8729b78d6 with SHA-1 ecd0d356c9 is already in history Original change: https://googleplex-android-review.googlesource.com/c/platform/packages/providers/ContactsProvider/+/24182869 Change-Id: I7b0699db40d54db01a833468e022151b3c860790 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