commit | 68da96039c887e1e9e5a9e755d0e6b65e44d7d99 | [log] [tgz] |
---|---|---|
author | Bill Yi <byi@google.com> | Wed Sep 11 11:51:24 2024 -0700 |
committer | Bill Yi <byi@google.com> | Wed Sep 11 11:51:24 2024 -0700 |
tree | 5db8661203e242b2c4f12b808a3965118b4763a0 | |
parent | a6d9a74768e77e80dc37bf4e61150dc69cc7539a [diff] |
Import translations. DO NOT MERGE ANYWHERE Auto-generated-cl: translation import Change-Id: I4facefbc9931e61cb93b8f32b783a0633086c76d
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