Inserting an array using ContentProvider

Question

I have a web service which returns the profile of the user upon successful authentication. The profile is in JSON and looks like this:

{
  "first_name" : "John",
  "last_name" : "Doe",
  "interests: : ["Science","Sports"]
}

How can I persist this in the database using a ContentProvider?

ContentValues do not have any provision for handling multi-valued attribute. My current implementation looks like this:

@Override
public Uri insert(Uri uri, ContentValues values){
    switch(matcher.match(uri)){
        case NEW_PROFILE:
        break;
        default:
        return null;
    }
    ProfileDatabaseHelper helper = new ProfileDatabaseHelper();
    // delete the existing profile first
    helper.deleteUserProfile();
    // then add a new profile
    long id = helper.addUserProfile( values );
    if( id > -1 ){
        Uri insertedId = ContentUris.withAppendedId(CONTENT_URI,id);
        getContext().getContentResolver().notifyChange(insertedId,null);
        return insertedId;
    }else{
        return null;
    }
}

RocketRandom · Accepted Answer · 2015-12-03 05:36:52Z

1

Create a table to store interests with columns _id and interest Then create another table to store mapping of profile with interests with columns _id , profile_id and interest_id

Create ContentUri for each table and insert accordingly.

answered Dec 3, 2015 at 5:36

RocketRandom

1,1227 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

An SO User Over a year ago

I was reading a little more into how I could insert arrays with my content provider. I think applyBatch() is the way to go. However, would my ContentProvider need to override applyBatch() or would the default implementation do just fine ?

RocketRandom Over a year ago

the default implementation of applyBatch() should do fine. You just need to handle all the ContentUri correctly in the insert method

Collectives™ on Stack Overflow

Inserting an array using ContentProvider

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related