android.content.ContentValues Java Examples

The following examples show how to use android.content.ContentValues. You can vote up the ones you like or vote down the ones you don't like, and go to the original project or source file by following the links above each example. You may check out the related API usage on the sidebar.
Example #1
Source Project: android-apps   Author: iamsarker   File: CourseGateWay.java    License: MIT License 6 votes vote down vote up
public String updateCourse(Courses aCore) {
	open();
	String msg = "Sorry!! Error for Updating";
	try {
		ContentValues cv = new ContentValues();
		cv.put(DBOpenHelper.COURS_CODE, aCore.getcCode());
		cv.put(DBOpenHelper.COURS_NAME, aCore.getcName());
		cv.put(DBOpenHelper.COURS_DEPT, aCore.getdCode());

		sqLiteDB.update(DBOpenHelper.TABLE_COURS, cv, " "
				+ DBOpenHelper.COURS_CODE + "=" + "'" + aCore.getcCode()
				+ "'", null);

		msg = "Successfully Updated with: " + aCore.getcCode();
	} catch (Exception e) {
		msg = "Sorry!! Error for Updating with: " + aCore.getcCode();
	}
	close();
	return msg;
}
 
Example #2
Source Project: FlipGank   Author: yiyuanliu   File: DataManager.java    License: Apache License 2.0 6 votes vote down vote up
private void updateDataDb(List<GankItem> gankItemList, String day) {
    if (gankItemList == null || gankItemList.size() == 0) {
        Log.d(TAG, "updateDataDb return for no data");
        return;
    }

    for (GankItem gankItem: gankItemList) {
        ContentValues item = new ContentValues();
        item.put(GankDbHelper.Contract.COLUMN_ID, gankItem.id);
        item.put(GankDbHelper.Contract.COLUMN_CATEGORY, gankItem.type);
        item.put(GankDbHelper.Contract.COLUMN_DEST, gankItem.desc);
        item.put(GankDbHelper.Contract.COLUMN_DAY, day);
        item.put(GankDbHelper.Contract.COLUMN_URL, gankItem.url);
        item.put(GankDbHelper.Contract.COLUMN_WHO, gankItem.who);
        item.put(GankDbHelper.Contract.COLUMN_IMAGE, gankItem.getImage());
        item.put(GankDbHelper.Contract.COLUMN_LIKE, gankItem.like ? 1 : 0);
        sqLiteDatabase.insert(GankDbHelper.Contract.TABLE_DATA, null, item);
    }
}
 
Example #3
Source Project: medialibrary   Author: mayurkaul   File: LocalImage.java    License: Apache License 2.0 6 votes vote down vote up
@Override
public void rotate(int degrees) throws Exception {
    GalleryUtils.assertNotInRenderThread();
    Uri baseUri = Images.Media.EXTERNAL_CONTENT_URI;
    ContentValues values = new ContentValues();
    int rotation = (this.rotation + degrees) % 360;
    if (rotation < 0) rotation += 360;

    if (mimeType.equalsIgnoreCase("image/jpeg")) {
        ExifInterface exifInterface = new ExifInterface(filePath);
        exifInterface.setAttribute(ExifInterface.TAG_ORIENTATION,
                String.valueOf(rotation));
        exifInterface.saveAttributes();
        fileSize = new File(filePath).length();
        values.put(Images.Media.SIZE, fileSize);
    }

    values.put(Images.Media.ORIENTATION, rotation);
    mApplication.getContentResolver().update(baseUri, values, "_id=?",
            new String[]{String.valueOf(id)});
}
 
Example #4
Source Project: storio   Author: pushtorefresh   File: PutContentValuesStub.java    License: Apache License 2.0 6 votes vote down vote up
void verifyBehaviorForMultipleContentValues(@Nullable PutResults<ContentValues> putResults) {
    assertThat(putResults).isNotNull();

    // only one call to storIOSQLite.put() should occur
    verify(storIOSQLite).put();

    // number of calls to putResolver's performPut() should be equal to number of objects
    verify(putResolver, times(contentValues.size())).performPut(eq(storIOSQLite), any(ContentValues.class));

    // each item should be "put"
    for (final ContentValues cv : contentValues) {
        verify(putResolver).performPut(storIOSQLite, cv);
    }

    verifyNotificationsAndTransactionBehavior();
}
 
Example #5
Source Project: Instagram-Profile-Downloader   Author: beNitinhere   File: DatabaseHelper.java    License: MIT License 6 votes vote down vote up
public void insertIntoDb(String username, Bitmap image){
    SQLiteDatabase db = this.getWritableDatabase();

    if(hasObject(username, DB_TABLE))
        deleteRow(username, DB_TABLE);

    try {
        ContentValues contentValues = new ContentValues();
        contentValues.put(USERNAME, username);
        contentValues.put(IMAGE_THUMBNAIL, ZoomstaUtil.getBytes(image));
        db.insert(DB_TABLE, null, contentValues);
        db.close();

    } catch (SQLiteException e){
        e.printStackTrace();
    }

}
 
Example #6
Source Project: Zom-Android-XMPP   Author: zom   File: ChatSessionAdapter.java    License: GNU General Public License v3.0 6 votes vote down vote up
@Override
public void setGroupChatSubject(String subject) throws RemoteException {
    try {
        if (isGroupChatSession()) {
            ChatGroup group = (ChatGroup)mChatSession.getParticipant();
            getGroupManager().setGroupSubject(group, subject);

            //update the database
            ContentValues values1 = new ContentValues(1);
            values1.put(Imps.Contacts.NICKNAME,subject);
            ContentValues values = values1;

            Uri uriContact = ContentUris.withAppendedId(Imps.Contacts.CONTENT_URI, mContactId);
            mContentResolver.update(uriContact, values, null, null);

        }
    } catch (Exception e) {
        e.printStackTrace();
    }
}
 
Example #7
Source Project: codeexamples-android   Author: vogellacompany   File: TodoDetailActivity.java    License: Eclipse Public License 1.0 6 votes vote down vote up
private void saveState() {
	String category = (String) mCategory.getSelectedItem();
	String summary = mTitleText.getText().toString();
	String description = mBodyText.getText().toString();

	// Only save if either summary or description
	// is available

	if (description.length() == 0 && summary.length() == 0) {
		return;
	}

	ContentValues values = new ContentValues();
	values.put(TodoTable.COLUMN_CATEGORY, category);
	values.put(TodoTable.COLUMN_SUMMARY, summary);
	values.put(TodoTable.COLUMN_DESCRIPTION, description);

	if (todoUri == null) {
		// New todo
		todoUri = getContentResolver().insert(
				MyTodoContentProvider.CONTENT_URI, values);
	} else {
		// Update todo
		getContentResolver().update(todoUri, values, null, null);
	}
}
 
Example #8
Source Project: android_packages_apps_GmsCore   Author: microg   File: NodeDatabaseHelper.java    License: Apache License 2.0 6 votes vote down vote up
private static synchronized long getAppKey(SQLiteDatabase db, String packageName, String signatureDigest) {
    Cursor cursor = db.rawQuery("SELECT _id FROM appkeys WHERE packageName=? AND signatureDigest=?", new String[]{packageName, signatureDigest});
    if (cursor != null) {
        try {
            if (cursor.moveToNext()) {
                return cursor.getLong(0);
            }
        } finally {
            cursor.close();
        }
    }
    ContentValues appKey = new ContentValues();
    appKey.put("packageName", packageName);
    appKey.put("signatureDigest", signatureDigest);
    return db.insert("appkeys", null, appKey);
}
 
Example #9
Source Project: BackPackTrackII   Author: M66B   File: DatabaseHelper.java    License: GNU General Public License v3.0 6 votes vote down vote up
public DatabaseHelper updateSteps(long id, long time, int value) {
    synchronized (mContext.getApplicationContext()) {
        SQLiteDatabase db = this.getWritableDatabase();
        ContentValues cv = new ContentValues();
        cv.put("count", value);
        if (db.update("step", cv, "ID = ?", new String[]{Long.toString(id)}) != 1)
            Log.e(TAG, "Update step failed");
    }

    for (StepCountChangedListener listener : mStepCountChangedListeners)
        try {
            listener.onStepCountUpdated(time, value);
        } catch (Throwable ex) {
            Log.e(TAG, ex.toString() + "\n" + Log.getStackTraceString(ex));
        }

    return this;
}
 
Example #10
Source Project: mobilecloud-15   Author: juleswhite   File: HobbitProviderImpl.java    License: Apache License 2.0 6 votes vote down vote up
/**
 * Method that handles bulk insert requests.  This method plays
 * the role of the "template method" in the Template Method
 * pattern.
 */
public int bulkInsert(Uri uri,
                      ContentValues[] cvsArray) {
    // Try to match against the path in a url.  It returns the
    // code for the matched node (added using addURI), or -1 if
    // there is no matched node.  If there's a match insert new
    // rows.
    switch (sUriMatcher.match(uri)) {
    case CHARACTERS:
        int returnCount = bulkInsertCharacters(uri,
                                               cvsArray);

        if (returnCount > 0)
            // Notifies registered observers that row(s) were
            // inserted.
            mContext.getContentResolver().notifyChange(uri, 
                                                       null);
        return returnCount;
    default:
        throw new UnsupportedOperationException();
    }
}
 
Example #11
Source Project: Cirrus_depricated   Author: skymania   File: FileContentProvider.java    License: GNU General Public License v2.0 6 votes vote down vote up
private void updateFilesTableAccordingToShareInsertion(
        SQLiteDatabase db, ContentValues newShare
) {
    ContentValues fileValues = new ContentValues();
    int newShareType = newShare.getAsInteger(ProviderTableMeta.OCSHARES_SHARE_TYPE);
    if (newShareType == ShareType.PUBLIC_LINK.getValue()) {
        fileValues.put(ProviderTableMeta.FILE_SHARED_VIA_LINK, 1);
    } else if (
          newShareType == ShareType.USER.getValue() ||
          newShareType == ShareType.GROUP.getValue() ||
          newShareType == ShareType.FEDERATED.getValue() ) {
         fileValues.put(ProviderTableMeta.FILE_SHARED_WITH_SHAREE, 1);
    }

    String where = ProviderTableMeta.FILE_PATH + "=? AND " +
            ProviderTableMeta.FILE_ACCOUNT_OWNER + "=?";
    String[] whereArgs = new String[] {
            newShare.getAsString(ProviderTableMeta.OCSHARES_PATH),
            newShare.getAsString(ProviderTableMeta.OCSHARES_ACCOUNT_OWNER)
    };
    db.update(ProviderTableMeta.FILE_TABLE_NAME, fileValues, where, whereArgs);
}
 
Example #12
Source Project: android_packages_apps_GmsCore   Author: microg   File: DataItemRecord.java    License: Apache License 2.0 6 votes vote down vote up
public ContentValues toContentValues() {
    ContentValues contentValues = new ContentValues();
    contentValues.put("sourceNode", source);
    contentValues.put("seqId", seqId);
    contentValues.put("v1SourceNode", source);
    contentValues.put("v1SeqId", v1SeqId);
    contentValues.put("timestampMs", lastModified);
    if (deleted) {
        contentValues.put("deleted", 1);
        contentValues.putNull("data");
    } else {
        contentValues.put("deleted", 0);
        contentValues.put("data", dataItem.data);
    }
    contentValues.put("assetsPresent", assetsAreReady ? 1 : 0);
    return contentValues;
}
 
Example #13
Source Project: nRF-Logger-API   Author: NordicSemiconductor   File: LocalLogSession.java    License: BSD 3-Clause "New" or "Revised" License 6 votes vote down vote up
/**
 * Creates new logger session. Must be created before appending log entries.
 * If the nRF Logger application is not installed the method will return <code>null</code>.
 * 
 * @param context
 *            the context (activity, service or application)
 * @param authority
 *            the {@link LocalLogContentProvider} authority
 * @param key
 *            the session key, which is used to group sessions
 * @param name
 *            the human readable session name
 * @return the {@link LogContract} that can be used to append log entries or <code>null</code>
 * if MCP is not installed. The <code>null</code> value can be next passed to logging methods
 */
public static LocalLogSession newSession(@NonNull final Context context,
										 @NonNull final Uri authority,
										 @NonNull final String key, @NonNull final String name) {
	final Uri uri = authority.buildUpon()
			.appendEncodedPath(LogContract.Session.SESSION_CONTENT_DIRECTORY)
			.appendEncodedPath(LogContract.Session.KEY_CONTENT_DIRECTORY)
			.appendEncodedPath(key)
			.build();
	final ContentValues values = new ContentValues();
	values.put(LogContract.Session.NAME, name);

	try {
		final Uri sessionUri = context.getContentResolver().insert(uri, values);
		if (sessionUri != null)
			return new LocalLogSession(context, sessionUri);
		return null;
	} catch (final Exception e) {
		Log.e("LocalLogSession", "Error while creating a local log session.", e);
		return null;
	}
}
 
Example #14
Source Project: Android-Basics-Codes   Author: DuGuQiuBai   File: FinalDb.java    License: Artistic License 2.0 6 votes vote down vote up
/**
 * 保存数据到数据库<br />
 * <b>注意:</b><br />
 * 保存成功后,entity的主键将被赋值(或更新)为数据库的主键, 只针对自增长的id有效
 * 
 * @param entity
 *            要保存的数据
 * @return ture: 保存成功 false:保存失败
 */
public boolean saveBindId(Object entity) {
	checkTableExist(entity.getClass());
	List<KeyValue> entityKvList = SqlBuilder
			.getSaveKeyValueListByEntity(entity);
	if (entityKvList != null && entityKvList.size() > 0) {
		TableInfo tf = TableInfo.get(entity.getClass());
		ContentValues cv = new ContentValues();
		insertContentValues(entityKvList, cv);
		Long id = db.insert(tf.getTableName(), null, cv);
		if (id == -1)
			return false;
		tf.getId().setValue(entity, id);
		return true;
	}
	return false;
}
 
Example #15
Source Project: opentasks   Author: dmfs   File: CategoryHandler.java    License: Apache License 2.0 6 votes vote down vote up
/**
 * Check if a category with matching {@link ContentValues} exists and returns the existing category or creates a new category in the database.
 *
 * @param db
 *         The {@link SQLiteDatabase}.
 * @param values
 *         The {@link ContentValues} of the category.
 *
 * @return The {@link ContentValues} of the existing or new category.
 */
private ContentValues getOrInsertCategory(SQLiteDatabase db, ContentValues values)
{
    if (values.getAsBoolean(IS_NEW_CATEGORY))
    {
        // insert new category in category table
        ContentValues newCategoryValues = new ContentValues(4);
        newCategoryValues.put(Categories.ACCOUNT_NAME, values.getAsString(Categories.ACCOUNT_NAME));
        newCategoryValues.put(Categories.ACCOUNT_TYPE, values.getAsString(Categories.ACCOUNT_TYPE));
        newCategoryValues.put(Categories.NAME, values.getAsString(Category.CATEGORY_NAME));
        newCategoryValues.put(Categories.COLOR, values.getAsInteger(Category.CATEGORY_COLOR));

        long categoryID = db.insert(Tables.CATEGORIES, "", newCategoryValues);
        values.put(Category.CATEGORY_ID, categoryID);
    }

    // remove redundant values
    values.remove(IS_NEW_CATEGORY);
    values.remove(Categories.ACCOUNT_NAME);
    values.remove(Categories.ACCOUNT_TYPE);

    return values;
}
 
Example #16
Source Project: Woodmin   Author: BennSandoval   File: WoodminSyncAdapter.java    License: Apache License 2.0 6 votes vote down vote up
private void finalizeSyncProducts() {

        /*
        NotificationManager notificationManager = (NotificationManager) getContext().getSystemService(Context.NOTIFICATION_SERVICE);
        notificationManager.cancel(0);
        */

        ContentValues[] productsValuesArray = new ContentValues[productsValues.size()];
        productsValuesArray = productsValues.toArray(productsValuesArray);
        int ordersRowsUpdated = getContext().getContentResolver().bulkInsert(WoodminContract.ProductEntry.CONTENT_URI, productsValuesArray);
        Log.v(LOG_TAG, "Products " + ordersRowsUpdated + " updated");

        /*
        String query = WoodminContract.ProductEntry.COLUMN_ENABLE + " = ?" ;
        String[] parameters = new String[]{ String.valueOf("0") };
        int rowsDeleted = getContext().getContentResolver().delete(WoodminContract.ProductEntry.CONTENT_URI,
                query,
                parameters);
        Log.d(LOG_TAG, "Products: " + rowsDeleted + " old records deleted.");
        */

        getContext().getContentResolver().notifyChange(WoodminContract.ProductEntry.CONTENT_URI, null, false);
        pageProduct = 0;
    }
 
Example #17
Source Project: iBeebo   Author: andforce   File: GroupDBTask.java    License: GNU General Public License v3.0 5 votes vote down vote up
public static void update(GroupListBean bean, String accountId) {

        if (bean == null || bean.getLists().size() == 0) {
            return;
        }

        clearGroup(accountId);

        ContentValues cv = new ContentValues();
        cv.put(GroupTable.ACCOUNTID, accountId);
        cv.put(GroupTable.JSONDATA, new Gson().toJson(bean));
        getWsd().insert(GroupTable.TABLE_NAME, HomeTable.ID, cv);

    }
 
Example #18
Source Project: HeadFirstAndroid   Author: dogriffiths   File: StarbuzzDatabaseHelper.java    License: MIT License 5 votes vote down vote up
private static void insertDrink(SQLiteDatabase db, String name,
                                String description, int resourceId) {
    ContentValues drinkValues = new ContentValues();
    drinkValues.put("NAME", name);
    drinkValues.put("DESCRIPTION", description);
    drinkValues.put("IMAGE_RESOURCE_ID", resourceId);
    db.insert("DRINK", null, drinkValues);
}
 
Example #19
Source Project: fingen   Author: YoshiOne   File: DBHelper.java    License: Apache License 2.0 5 votes vote down vote up
public static ContentValues addSyncDataToCV(ContentValues values, BaseModel baseModel) {
    values.put(DBHelper.C_SYNC_FBID, baseModel.getFBID());
    values.put(DBHelper.C_SYNC_TS, baseModel.getTS());
    values.put(DBHelper.C_SYNC_DELETED, 0);
    values.put(DBHelper.C_SYNC_DIRTY, baseModel.isDirty() ? 1 : 0);
    values.put(DBHelper.C_SYNC_LASTEDITED, baseModel.getLastEdited());
    return values;
}
 
Example #20
Source Project: AndroidAnimationExercise   Author: REBOOTERS   File: SamsungHomeBadger.java    License: Apache License 2.0 5 votes vote down vote up
private ContentValues getContentValues(ComponentName componentName, int badgeCount, boolean isInsert) {
    ContentValues contentValues = new ContentValues();
    if (isInsert) {
        contentValues.put("package", componentName.getPackageName());
        contentValues.put("class", componentName.getClassName());
    }

    contentValues.put("badgecount", badgeCount);

    return contentValues;
}
 
Example #21
Source Project: mimi-reader   Author: MimiReader   File: Archive.java    License: Apache License 2.0 5 votes vote down vote up
@Override
public ContentValues toContentValues() {
    ContentValues values = new ContentValues();
    values.put(UID, this.uid);
    values.put(NAME, this.name);
    values.put(DOMAIN, this.domain);
    values.put(HTTPS, this.https);
    values.put(SOFTWARE, this.software);
    values.put(BOARD, this.board);
    values.put(REPORTS, this.reports);
    return values;
}
 
Example #22
Source Project: AndroidContacts   Author: blainepwnz   File: ContactsSaver.java    License: MIT License 5 votes vote down vote up
private ContentValues getOrganizationTypeCV(Organization organization, int id) {
    ContentValues contentValues = new ContentValues();
    contentValues.put(ContactsContract.Data.RAW_CONTACT_ID, id);
    contentValues.put(ContactsContract.Data.MIMETYPE, ContactsContract.CommonDataKinds.Organization.CONTENT_ITEM_TYPE);
    contentValues.put(ContactsContract.Data.DATA1, organization.getName());
    contentValues.put(ContactsContract.Data.DATA4, organization.getTitle());
    return contentValues;
}
 
Example #23
Source Project: sensordatacollector   Author: sztyler   File: GyroscopeSensorCollector.java    License: GNU General Public License v2.0 5 votes vote down vote up
public static void writeDBStorage(String deviceID, ContentValues newValues)
{
    String tableName = SQLTableName.PREFIX + deviceID + SQLTableName.GYROSCOPE;

    if(Settings.DATABASE_DIRECT_INSERT) {
        SQLDBController.getInstance().insert(tableName, null, newValues);
        return;
    }

    List<String[]> clone = DBUtils.manageCache(deviceID, cache, newValues, (Settings.DATABASE_CACHE_SIZE + type * 200));
    if(clone != null) {
        SQLDBController.getInstance().bulkInsert(tableName, clone);
    }
}
 
Example #24
Source Project: Hillffair17   Author: appteam-nith   File: DbHelper.java    License: GNU General Public License v3.0 5 votes vote down vote up
public boolean insert_2_homeposts(String id, String smallicon, String title, String body, String bigpicture, String largeicon, String launchurl) {
    SQLiteDatabase db = getWritableDatabase();
    ContentValues contentValues = new ContentValues();
    contentValues.put(NOTIFICATION_ID, id);
    contentValues.put(NOTIFICATION_small_icon, smallicon);
    contentValues.put(NOTIFICATION_TITLE, title);
    contentValues.put(NOTIFICATION_BODY, body);
    contentValues.put(NOTIFICATION_BIG_PICTURE, bigpicture);
    contentValues.put(NOTIFICATION_LARGE_ICON, largeicon);
    contentValues.put(NOTIFICATION_LAUNCH_URL, launchurl);
    db.insert(TABLE_HOMEPOST, null, contentValues);
    return true;
}
 
Example #25
Source Project: AOSP-Kayboard-7.1.2   Author: sergchil   File: DictionaryDownloadProgressBar.java    License: Apache License 2.0 5 votes vote down vote up
static private int getDownloadManagerPendingIdFromWordlistId(final Context context,
        final String clientId, final String wordlistId) {
    final SQLiteDatabase db = MetadataDbHelper.getDb(context, clientId);
    final ContentValues wordlistValues =
            MetadataDbHelper.getContentValuesOfLatestAvailableWordlistById(db, wordlistId);
    if (null == wordlistValues) {
        // We don't know anything about a word list with this id. Bug? This should never
        // happen, but still return to prevent a crash.
        Log.e(TAG, "Unexpected word list ID: " + wordlistId);
        return NOT_A_DOWNLOADMANAGER_PENDING_ID;
    }
    return wordlistValues.getAsInteger(MetadataDbHelper.PENDINGID_COLUMN);
}
 
Example #26
Source Project: iBeebo   Author: andforce   File: AccountDao.java    License: GNU General Public License v3.0 5 votes vote down vote up
public static OAuthActivity.DBResult updateAccountHackToken(AccountBean account, String toaken_hack, long token_hack_exp) {

        ContentValues cv = new ContentValues();
        cv.put(AccountTable.ACCESS_TOKEN_HACK, toaken_hack);
        // toaken_time 
        cv.put(AccountTable.ACCESS_TOKEN_HACK_EXPIRES_TIME, token_hack_exp);

        String[] args = {
                account.getUid()
        };
        getWsd().update(AccountTable.ACCOUNT_TABLE, cv, AccountTable.UID + "=?", args);
        return OAuthActivity.DBResult.update_successfully;
    }
 
Example #27
Source Project: Android-Keyboard   Author: NlptechProduct   File: DictionaryProvider.java    License: Apache License 2.0 5 votes vote down vote up
/**
 * Updating data is not supported, and will throw an exception.
 * @see ContentProvider#update(Uri, ContentValues, String, String[])
 * @see ContentProvider#insert(Uri, ContentValues)
 */
@Override
public int update(final Uri uri, final ContentValues values, final String selection,
        final String[] selectionArgs) throws UnsupportedOperationException {
    PrivateLog.log("Attempt to update : " + uri);
    throw new UnsupportedOperationException("Updating dictionary words is not supported");
}
 
Example #28
Source Project: arca-android   Author: cfmobile   File: SQLiteTable.java    License: BSD 3-Clause "New" or "Revised" License 5 votes vote down vote up
@Override
public int bulkInsert(final Uri uri, final ContentValues[] values) {
	final SQLiteDatabase database = getDatabase();
	if (database != null) {
		return insertWithTransaction(database, getName(), values);
	} else {
		throw new IllegalStateException("Database is null.");
	}
}
 
Example #29
Source Project: V.FlyoutTest   Author: benhysell   File: LoaderThrottleSupport.java    License: MIT License 5 votes vote down vote up
/**
 * Handle updating data.
 */
@Override
public int update(Uri uri, ContentValues values, String where, String[] whereArgs) {
    SQLiteDatabase db = mOpenHelper.getWritableDatabase();
    int count;
    String finalWhere;

    switch (mUriMatcher.match(uri)) {
        case MAIN:
            // If URI is main table, update uses incoming where clause and args.
            count = db.update(MainTable.TABLE_NAME, values, where, whereArgs);
            break;

        case MAIN_ID:
            // If URI is for a particular row ID, update is based on incoming
            // data but modified to restrict to the given ID.
            finalWhere = DatabaseUtilsCompat.concatenateWhere(
                    MainTable._ID + " = " + ContentUris.parseId(uri), where);
            count = db.update(MainTable.TABLE_NAME, values, finalWhere, whereArgs);
            break;

        default:
            throw new IllegalArgumentException("Unknown URI " + uri);
    }

    getContext().getContentResolver().notifyChange(uri, null);

    return count;
}
 
Example #30
Source Project: iBeebo   Author: andforce   File: HomeOtherGroupTimeLineDBTask.java    License: GNU General Public License v3.0 5 votes vote down vote up
static void updateCount(String msgId, int commentCount, int repostCount) {
    String sql = "select * from " + HomeOtherGroupTable.HomeOtherGroupDataTable.TABLE_NAME + " where "
            + HomeOtherGroupTable.HomeOtherGroupDataTable.MBLOGID + "  = " + msgId + " order by "
            + HomeOtherGroupTable.HomeOtherGroupDataTable.ID
            + " asc limit 50";
    Cursor c = getRsd().rawQuery(sql, null);
    Gson gson = new Gson();
    while (c.moveToNext()) {
        String id = c.getString(c.getColumnIndex(HomeOtherGroupTable.HomeOtherGroupDataTable.ID));
        String json = c.getString(c.getColumnIndex(HomeOtherGroupTable.HomeOtherGroupDataTable.JSONDATA));
        if (!TextUtils.isEmpty(json)) {
            try {
                MessageBean value = gson.fromJson(json, MessageBean.class);
                value.setComments_count(commentCount);
                value.setReposts_count(repostCount);
                String[] args = {
                        id
                };
                ContentValues cv = new ContentValues();
                cv.put(HomeOtherGroupTable.HomeOtherGroupDataTable.JSONDATA, gson.toJson(value));
                getWsd().update(HomeOtherGroupTable.HomeOtherGroupDataTable.TABLE_NAME, cv,
                        HomeOtherGroupTable.HomeOtherGroupDataTable.ID + "=?", args);
            } catch (JsonSyntaxException e) {

            }

        }
    }
}