Content provider for contacts and call log data

Clone this repo:
  1. 5af4c20 Merge "Merge Android 14 QPR2 to AOSP main" into main by Xin Li · 12 days ago main master
  2. 83de92b Merge Android 14 QPR2 to AOSP main by Xin Li · 13 days ago
  3. 9b815a8 Merge Android 24Q1 Release (ab/11220357) by Xin Li · 7 weeks ago
  4. 367ef82 Merge "Make sure to close cursors" into main am: a3c215a1e5 by Treehugger Robot · 7 weeks ago
  5. a3c215a Merge "Make sure to close cursors" into main by Treehugger Robot · 7 weeks ago

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