how to test insert/query/delete/update of a custom ContentProvider ?

[Gal Ben-Haim]

I understand that for query I'm supposed to create a TestCursor with some mock data but how do I test the other methods ?

(for example, I want to test that insert returns the correct URL)

[Jan Berkel]

On Monday, August 20, 2012 9:08:36 AM UTC+2, Gal Ben-Haim wrote:

I understand that for query I'm supposed to create a TestCursor with some mock data but how do I test the other methods ?

(for example, I want to test that insert returns the correct URL)

here's how i integrate my contentprovider with the rest of the system. create a custom test runner and override beforeTest

@Override public void beforeTest(Method method) {
  ContentProvider provider = new MyCustomContentProvider();
  provider.onCreate();
  ShadowContentResolver.registerProvider(authority, provider);
}

you should be able to access your content provider via normal content resolver calls. if you use sqlite as backing store it should just work.
if not, you might want to mock out your storage layer.

   jan

[Gal Ben-Haim]

this is what I'm trying to do, for some reason the returned Cursor from the query operation is null.

what am I missing ?

private Activity mContext;

private CustomContentProvider mProvider;

private ContentResolver mResolver;

@Before

public void setUp() throws Exception {

mProvider = new CustomContentProvider();

mContext = new Activity();

mResolver = mContext.getContentResolver();

mProvider.onCreate();

ShadowContentResolver.registerProvider(ProviderMetaData.AUTHORITY, mProvider);

}

@Test

public void testInsertUsers() {

Uri uri = mResolver.insert(ProviderMetaData.USERS_URI, DatabaseTestObjects.getUserObject(1));

// check if the correct uri is returned

assertEquals(uri, Uri.withAppendedPath(ProviderMetaData.USERS_URI, Long.toString(1)));

// check if the data was inserted

Cursor c = mResolver.query(ProviderMetaData.USERS_URI, null, null, null, null);

assertNotNull(c);

assertEquals(1, c.getCount());

}

[Jan Berkel]

@Test

public void testInsertUsers() {

Uri uri = mResolver.insert(ProviderMetaData.USERS_URI, DatabaseTestObjects.getUserObject(1));

// check if the correct uri is returned

assertEquals(uri, Uri.withAppendedPath(ProviderMetaData.USERS_URI, Long.toString(1)));

// check if the data was inserted

Cursor c = mResolver.query(ProviderMetaData.USERS_URI, null, null, null, null);

this should probably be

Cursor c = mResolver.query(uri, null, null, null, null);

  jan

[Gal Ben-Haim]

why does query return a null Cursor and how do I fix it ?

[Jan Berkel]

On Monday, August 20, 2012 11:17:12 AM UTC+2, Gal Ben-Haim wrote:

why does query return a null Cursor and how do I fix it ?

are you sure your provider does the right thing? connect a debugger and check. don't think it's related to robolectric.


 

[Gal Ben-Haim]

this exact same test is passing with Android's testing framework so its not a problem with the provider.

what can be the problem ?

[MikeTheBiker]

I think you need something like:

@Before

public void setUp() {
...

mMockResolver = Robolectric.application.getContentResolver();

final ShadowContentResolver shadowContentResolver = shadowOf(mMockResolver);

cursor = new SimpleTestCursor();
shadowContentResolver.setCursor(YourContentProvider.URI, cursor);

...
}

Regards

[Lei Yu]

Hi, guys:

I just get started using Robolectric and writing some unit test on content provider. 

I follow the @Before setUp in this post, but it won't work.

An error will show up inside query function of content provider at line SQLiteDatabase db = myDB.getReadableDatabase();

However, it runs well on device. 

I know this post has been there for a while. Can anyone help me with this?

Many thanks.

Leo. 

[Budhdi Prakash Sharma]

Hey @Gal Ben-Haim   did you get the correct solution of this problem because i am also facing the same problem.

While returning the value from database Cursor giving null pointer exception.


@Test
    public void testQuery(){

        System.out.println(" Query URI :  " + CONTENT_URI);
        Cursor cursor = contentResolver.query(CONTENT_URI,null,null,null,null);
        //String[] Data=null;

        cursor.moveToFirst();

        if(cursor.getCount() != 0){
            do {
                for(int i=0;i<cursor.getCount();i++)
                {
                   Assert.assertNotEquals( projection[i],cursor.getString(i));
                }


            }while (cursor.moveToNext());