| # Debugging Tools |
| ## Enable all verbose logs |
| Running `./logging.sh` will enable all verbose logs for the queries in the provider. |
| More details in the script itself. |
| |
| ## Querying the database |
| There are 2 different ways to easily query the database, `qc` and `contatcsproviderutils.sh`. |
| |
| ### QC usage |
| `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. |
| |
| ### contactsproviderutils.sh usage |
| |
| This script downlaods the database locally and logins into a local version. It is also possible to push any change back to the device. |
| |
| * Add tools to path |
| ``` |
| source contactsproviderutils.sh |
| ``` |
| * Pull `contacts2.db` and query: |
| ``` |
| sqlite3-pull |
| ``` |
| This will open a sql terminal with `rlwrap` which can be easily used for queries. |
| * Pull `contacts2.db` and query with a graphical interface: |
| ``` |
| sqlitebrowser-pull |
| ``` |
| * Push local updates to the device: |
| ``` |
| sqlite3-push |
| ``` |
| |
