public boolean insertBulkItems(ArrayList<FeedObject> feedList) {
long start = System.currentTimeMillis();
int time = (int) (start / 1000);
if (feedList == null || feedList.size() < 1) return false;
Logs.d(
TAG, "# Insert bulk : type=" + feedList.get(0).mType + ", item count = " + feedList.size());
InsertHelper iHelp = new InsertHelper(mDb, TABLE_NAME_FEED_ITEM);
int ktype = iHelp.getColumnIndex(KEY_FEED_TYPE);
int kstatus = iHelp.getColumnIndex(KEY_FEED_STATUS);
int kid = iHelp.getColumnIndex(KEY_FEED_IDSTRING);
int kname = iHelp.getColumnIndex(KEY_FEED_NAME);
int klink = iHelp.getColumnIndex(KEY_FEED_LINK);
int kkeyword = iHelp.getColumnIndex(KEY_FEED_KEYWORD);
int kcontent = iHelp.getColumnIndex(KEY_FEED_CONTENT);
int kthumbnail = iHelp.getColumnIndex(KEY_FEED_THUMBNAILURL);
int kdate = iHelp.getColumnIndex(KEY_FEED_DATE);
int krank = iHelp.getColumnIndex(KEY_FEED_RANK);
int kclick = iHelp.getColumnIndex(KEY_FEED_CLICK);
int kranktype = iHelp.getColumnIndex(KEY_FEED_ARG0);
int kversion = iHelp.getColumnIndex(KEY_FEED_ARG1);
int kfullimage = iHelp.getColumnIndex(KEY_FEED_ARG2);
synchronized (mDb) {
if (mDb == null) return false;
try {
mDb.beginTransaction();
// First one is recent one. So insert oldest first.
for (int i = feedList.size() - 1; -1 < i; i--) {
FeedObject feed = feedList.get(i);
// need to tell the helper you are inserting (rather than replacing)
iHelp.prepareForInsert();
// do the equivalent of ContentValues.put("field","value") here
iHelp.bind(ktype, feed.mType);
iHelp.bind(kstatus, feed.mDownloadStatus);
iHelp.bind(kid, feed.mId);
if (feed.mName != null) iHelp.bind(kname, feed.mName);
if (feed.mLink != null) iHelp.bind(klink, feed.mLink);
if (feed.mKeyword != null) iHelp.bind(kkeyword, feed.mKeyword);
if (feed.mContent != null) iHelp.bind(kcontent, feed.mContent);
if (feed.mThumbnailUrl != null) iHelp.bind(kthumbnail, feed.mThumbnailUrl);
if (feed.mDate != null) iHelp.bind(kdate, feed.mDate);
else iHelp.bind(kdate, time);
iHelp.bind(krank, feed.mRankUpAndDown);
iHelp.bind(kclick, feed.mCommentCount);
iHelp.bind(kranktype, feed.mRankType);
iHelp.bind(kversion, feed.mVersion);
if (feed.mFullSizeImageURL != null) iHelp.bind(kfullimage, feed.mFullSizeImageURL);
// the db.insert() equilvalent
iHelp.execute();
}
mDb.setTransactionSuccessful();
} catch (Exception e) {
} finally {
mDb.endTransaction();
}
}
return true;
}
