commit | c59a6a0b9438418915020c3a566315bbe0164d4a | [log] [tgz] |
---|---|---|
author | Xin Li <delphij@google.com> | Mon Dec 11 22:57:52 2023 +0000 |
committer | Automerger Merge Worker <android-build-automerger-merge-worker@system.gserviceaccount.com> | Mon Dec 11 22:57:52 2023 +0000 |
tree | 8dc661e710c7d523e0d9f68e2566e4f53e97299e | |
parent | 9edc106bd5c04294610be172ddfc6653c703dd21 [diff] | |
parent | 97a057f604b0120260a7a8e53bd58516031ccdbb [diff] |
[automerger skipped] Merge Android 14 QPR1 am: cfd58453d6 -s ours am: 866fb8c043 -s ours am: 97a057f604 -s ours am skip reason: Merged-In I880a85493c46efc41a146c1a9721e4662397f2c7 with SHA-1 cff7500574 is already in history Original change: https://android-review.googlesource.com/c/platform/packages/providers/ContactsProvider/+/2865784 Change-Id: I6d0ffe0ba2b375b299a20f623bba8c78b80e0188 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