commit | b1c7a4b98f0f6002e6865a82755eb9159c6ca7a4 | [log] [tgz] |
---|---|---|
author | Android Build Coastguard Worker <android-build-coastguard-worker@google.com> | Tue Mar 12 23:48:43 2024 +0000 |
committer | Gerrit Code Review <noreply-gerritcodereview@google.com> | Tue Mar 12 23:48:43 2024 +0000 |
tree | bf0292d772be4be60cb926c2ab2a3a11341a863e | |
parent | 1bc443857d48f8639edf37ac974f4b5126e0a5a2 [diff] | |
parent | 15270e81e7954034de37053d8673bae3f099fdde [diff] |
Merge "Snap for 11566117 from 5af4c203d3fef3fc6d49cbef6bc5308a87a2f223 to sdk-release" into sdk-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