| commit | 1f4dd961b1f7ea1297c4276aa8b41fd277d3decf | [log] [tgz] |
|---|---|---|
| author | Tyler Gunn <tgunn@google.com> | Mon Jul 31 00:52:38 2023 +0000 |
| committer | Automerger Merge Worker <android-build-automerger-merge-worker@system.gserviceaccount.com> | Mon Jul 31 00:52:38 2023 +0000 |
| tree | 6802c7a56cebb70c0f5f0c86d49b360225e284df | |
| parent | fb32ce27e759604e264aeb6d6c1e2319af2d7870 [diff] | |
| parent | 0b5da009662a4d068149720f00ee8cfe3b54935e [diff] |
Improve CallLogProvider logging to help in issue diagnosis. am: 1b5b039b46 am: 796877d338 am: 0b5da00966 Original change: https://googleplex-android-review.googlesource.com/c/platform/packages/providers/ContactsProvider/+/24248198 Change-Id: I568499fbb0bcd72132ab59693855fa81819088af 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