commit | 9b815a8d8edeac84b1bac6c2a91cd5f2cc91e284 | [log] [tgz] |
---|---|---|
author | Xin Li <delphij@google.com> | Mon Jan 29 10:25:43 2024 -0800 |
committer | Xin Li <delphij@google.com> | Mon Jan 29 10:25:43 2024 -0800 |
tree | bf0292d772be4be60cb926c2ab2a3a11341a863e | |
parent | 367ef82aa780b8d31db739491134c6ec3e74071f [diff] | |
parent | 6e777225112eb31e0bd2b055eb545fbf7a5f14b9 [diff] |
Merge Android 24Q1 Release (ab/11220357) Bug: 319669529 Merged-In: Iac8d186f9d442f8bfccf834fb52d407653622f38 Change-Id: Ia3c08524a7476566e8f85a79c15af583fd65f16a
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