| commit | 87a8b02a574c807f95593e63e793a09bc0d5f616 | [log] [tgz] |
|---|---|---|
| author | Android Build Coastguard Worker <android-build-coastguard-worker@google.com> | Wed Dec 18 13:23:13 2024 -0800 |
| committer | Gerrit Code Review <noreply-gerritcodereview@google.com> | Wed Dec 18 13:23:13 2024 -0800 |
| tree | eb99997b7c7f48a89fe4463d115952a116e750bb | |
| parent | 5c6bb3322c2fc3f83dd5fd739c952a91ab81625c [diff] | |
| parent | a1bace0ba943098bd52f15f965a758e7638689e6 [diff] |
Merge "Snap for 12821328 from 870559c0fb6394d3fb10bce16b2db96a6b3bb8b1 to simpleperf-release" into simpleperf-release
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