/** parse return string from request and insert into database* */
private void GetReviewsDataFromJson(String movieJsonStr, String movieId) throws JSONException {
// These are the names of the JSON objects that need to be extracted.
final String Array_RESULT = "results";
final String REVIEW_AUTHOR = "author";
final String REVIEW_CONTENT = "content";
JSONObject movieJson = new JSONObject(movieJsonStr);
JSONArray movieArray = movieJson.getJSONArray(Array_RESULT);
// Insert the new trailers information into the database
Vector<ContentValues> cVVector = new Vector<ContentValues>(movieArray.length());
for (int i = 0; i < movieArray.length(); i++) {
// Get the JSON object representing the time
JSONObject movieObject = movieArray.getJSONObject(i);
// get data from Object and append to content Values Vector
ContentValues moviesValues = new ContentValues();
moviesValues.put(MoviesContract.COLUMN_MOV_ID, movieId);
moviesValues.put(
MoviesContract.ReviewsEntry.COLUMN_REV_AUTHOR, movieObject.getString(REVIEW_AUTHOR));
moviesValues.put(
MoviesContract.ReviewsEntry.COLUMN_REV_CONTENT, movieObject.getString(REVIEW_CONTENT));
cVVector.add(moviesValues);
}
// build uri of Reviews and review with id
Uri reviewUri = MoviesContract.ReviewsEntry.CONTENT_URI;
Uri reviewWithIdUri =
MoviesContract.ReviewsEntry.buildReviewUriWithMovieId(Long.valueOf(movieId));
int deleted = 0;
// delete data from database
deleted = mContext.getContentResolver().delete(reviewWithIdUri, null, null);
Log.d("Reviews Row Deleted ", String.valueOf(deleted));
int inserted = 0;
// add to database
if (cVVector.size() > 0) {
ContentValues[] cvArray = new ContentValues[cVVector.size()];
cVVector.toArray(cvArray);
inserted = mContext.getContentResolver().bulkInsert(reviewUri, cvArray);
}
Log.d("Review Row Inserted ", String.valueOf(inserted));
}
