Testing Content Providers: Android Programming

Content Providers are a means of encapsulating and providing data to applications through a simple interface. Content Providers are therefore one of the main building blocks in android applications along with services and activities.

Now, you can quite easily embed raw sql queries and data access methods directly into your activity, but it is cleaner and better practice to have some separate interface that you can use isolate and test data access methods. The Content Provider is also required if you want to expose data in your application to third-party applications. Imagine you wanted to implemented a widget that uses the data from your application; it would require you to define a Content Provider to do so.

In order to define a Content Provider, you must implement the following methods;

  • onCreate() which is called to initialize the provider
  • query(Uri, String[], String, String[], String) which returns data to the caller
  • insert(Uri, ContentValues) which inserts new data into the content provider
  • update(Uri, ContentValues, String, String[]) which updates existing data in the content provider
  • delete(Uri, String, String[]) which deletes data from the content provider
  • getType(Uri) which returns the MIME type of data in the content provider

  • It is important to note, that the primary mechanism by which we are making queries is through the Uri. Every Content Provider defines an authority (usually the package name with that of Content Provider appended to it ie: com.example.myapp.MyContentProvider) which is declared in your applications manifest file, within the application tag, like thus;

    <manifest xmlns:android="http://schemas.android.com/apk/res/android"
        android:versionName="1.0" >

        android:targetSdkVersion=&quot;15&quot; /&gt;
    &lt;uses-permission android:name=&quot;android.permission.INTERNET&quot; /&gt;&lt;uses-permission android:name=&quot;android.permission.INTERNET&quot; /&gt;
        android:theme=&quot;@style/AppTheme&quot; &gt;
            android:label=&quot;@string/title_activity_workspace&quot; &gt;
                &lt;action android:name=&quot;android.intent.action.MAIN&quot; /&gt;
                &lt;category android:name=&quot;android.intent.category.LAUNCHER&quot; /&gt;
        &lt;provider     android:name=&quot;com.flashics.sutra.AsanaProvider&quot; 


    The next step in building a Content Provider is to identify what data needs to be queried. For the sake of brevity, we will implement a content provider that will can query the asana api to return a list of workspaces, and a list of projects in a particular workspace. This link contains the asana api documentation http://developer.asana.com/documentation/.

    From this documentation, we can see that the two http requests that need to be made are;



    https://app.asana.com/api/1.0/workspaces/x/projects where x is the id of the workspace

    For actually making the requests, I will use the aquery library for simplicity, which can be found here - http://code.google.com/p/android-query/ - though you should be able to follow along without knowledge of this library.

    Content Providers function by being passed a Uri which determines what data it should query. You then need to determine a sensible set of Uri’s for determining what data to fetch.

    Usually, the uri should be of the format ‘content:///tablename’ so in our example, we will define our two uri’s as



    content://com.example/myapp/projects/workspaces/x where x is the id of the workspace

    Note that I’ve rearranged the uri a little as compared with the http request. The URI object libraries in the android/java api have helper functions that make it easy to strip the last path segment.

    Now onto the actual content provider code!

    We first define a Uri matcher class within the ContentProvider Class ie;

    public class MyContentProvider extends ContentProvider {

    private static final String TAG = AsanaProvider.class.getName(); // Helpful for debugging
    private static final String AUTHORITY = &quot;com.example.myapp.MyContentProvider&quot;; //Our Authority
    private static final UriMatcher sURIMatcher = new UriMatcher(UriMatcher.NO_MATCH);
      static {          
        sURIMatcher.addURI(AUTHORITY, &quot;workspaces&quot;, 1); 
        sURIMatcher.addURI(AUTHORITY, &quot;workspaces/projects/#&quot;,2);


    The UriMatcher is a handy class for constructing switch statements, like we will do in the following code for query().

    Note the “YOUR API KEY KEY GOES HERE”; if you want to compile and test the code in the android app, you’ll need to make an account at Asana and then copy and paste your api key in.

        public Cursor query(Uri uri, String[] projection, String selection,
                String[] selectionArgs, String sortOrder) {

        int match = sURIMatcher.match(uri);
        String[] columns = {&quot;data&quot;};
        MatrixCursor cursor = new MatrixCursor(columns);
        String url = &quot;https://app.asana.com/api/1.0/workspaces&quot;;
        String encoding = Base64.encodeToString(&quot;YOUR_API_KEY_GOES_HERE:&quot;.getBytes(),2);
        StringBuilder baseurl= new StringBuilder(&quot;https://app.asana.com/api/1.0/&quot;);
        switch(match) {
        case    1:
        case    2:
        AjaxCallback&lt;String&gt; cb = new AjaxCallback&lt;String&gt;();
        cb.header(&quot;Authorization&quot;, &quot;Basic &quot; + encoding);
        AQuery aq = new AQuery(getContext());
        String jo = cb.getResult();
        AjaxStatus status = cb.getStatus();
        //Log.i(TAG, jo);
        try {
            JSONObject workspaceWrapper = (JSONObject) new JSONTokener(jo).nextValue();
            JSONArray  workspaces       = workspaceWrapper.getJSONArray(&quot;data&quot;);
            for (int i = 0; i &lt; workspaces.length(); i++) {
                String[] workspace = {workspaces.getJSONObject(i).toString()};
        catch (JSONException e) {
             Log.e(TAG, &quot;Failed to parse JSON.&quot;, e);
        return cursor;

    The switch statement will check what uri we have received, and then use it to build the corresponding uri request. The rest of the code is just making the http request and parsing the JSON response into a matrixcursor. Note that you must return a cursor; The easiest way to do this is by using MatrixCursor, which you construct by passing a String array which contains a list of column names to the constructor.

    That’s basically it.

    To access the data in your activity, service etc can be done in a few different manners

  • Use a loader - which will involved creating a CursorLoader which can query the Uri directly, load everything in another thread, and keep everything all nice and organised (this is probably the best way)
  • Calling getContentResolver() in your activity and using the ContentResolver to directly query the ContentProvider - note that if your content provider is synchronous it will block the main thread, so make sure the call is asynchronous if you are going to do this. In my example, I’ve made a synchronous call.
  • Android Design Patterns recommend using loaders.

    Now lets say we want to make some tests for content provider, to check that we’ve done everything properly. Androids test framework (based on junit) allows you to do this with the ProviderTestCase2 class, which will set up the MockContentResolver object that will allow us to test our Content Provider.

    Using ProviderTestCase2 we request a MockContentResolver object and use this to make queries to the content provider. The setup() and tearDown() methods execute before each test and are used to perform initialisation. You can then define as many test cases as you like and use assertions to check that you are retrieving the correct data from the Content Provider.

    The below is an example of how to set this class up;

    package com.example.myapp.test;

    import org.json.JSONException; import org.json.JSONObject;

    import android.content.ContentValues; import android.database.Cursor; import android.net.Uri; import android.test.ProviderTestCase2; import android.test.mock.MockContentResolver; import android.util.Log;

    import com.example.myapp.MyContentProvider.*;

    public class CPTester extends ProviderTestCase2<MyContentProvider> { // Extend your base class and replace the generic with your content provider

    private static final String TAG = CPTester.class.getName();
    private static MockContentResolver resolve; // in the test case scenario, we use the MockContentResolver to make queries
    public CPTester(Class&lt;AsanaProvider&gt; providerClass,String providerAuthority) {
        super(providerClass, providerAuthority);
        // TODO Auto-generated constructor stub
    public CPTester() {
    public void setUp() {
        try {
            Log.i(TAG, &quot;Entered Setup&quot;);
            resolve = this.getMockContentResolver();
        catch(Exception e) {
    public void tearDown() {
        catch(Exception e) {
    public void testCase() {
        Log.i(&quot;TAG&quot;,&quot;Basic Insert Test&quot;);
    public void testPreconditions() {
        // using this test to check data already inside my asana profile
        Log.i(&quot;TAG&quot;,&quot;Test Preconstructed Database&quot;);
        String[] projection = {&quot;workspace_id&quot;,&quot;name&quot;};
        String selection = null;
        String[] selectionArgs = null;
        String sortOrder = null;
        Cursor result = resolve.query(Uri.parse(&quot;content://com.example.myapp.MyContentProvider/workspace&quot;), projection, selection, selectionArgs, sortOrder);
        assertEquals(result.getCount(), 3); //check number of returned rows
        assertEquals(result.getColumnCount(), 2); //check number of returned columns
        for(int i = 0; i &lt; result.getCount(); i++) {
            String id = result.getString(0);
            String name = result.getString(1);
            Log.i(&quot;TAG&quot;,id + &quot; : &quot; + name);


    Hopefully, this gives you a basic introduction to Content Providers on Android and how to test them.