| commit | cf86ae5bbdb8082ce1f13e8134702046ae2ab4ff | [log] [tgz] |
|---|---|---|
| author | Xin Li <delphij@google.com> | Mon Mar 10 09:51:40 2025 -0700 |
| committer | Gerrit Code Review <noreply-gerritcodereview@google.com> | Mon Mar 10 09:51:40 2025 -0700 |
| tree | 571726fd5424e92926efc9b15db2316bc4573cbb | |
| parent | 9c99fd37dea61db7ba5d109b98c462ff4eff363f [diff] | |
| parent | da2e816143849a27045b952a035be35edcc76e32 [diff] |
Merge "Merge 25Q1 (ab/BP1A.250305.020) to AOSP main" into main
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