@Override public int update(Uri uri, ContentValues values, String selection, String[] selectionArgs) { Log.v(TAG, "update (uri= " + uri + ", values= " + values.toString()); final SQLiteDatabase db = mOpenHelper.getWritableDatabase(); final int match = sUriMatcher.match(uri); String selectionCriteria = selection; switch (match) { case ADS: // get all ads // do nothing, prevent update all records if not id provide break; case ADS_ID: String id = AdsContract.Ads.getAdId(uri); selectionCriteria = BaseColumns._ID + "=" + id + (!TextUtils.isEmpty(selection) ? " AND (" + selection + ") " : ""); break; default: throw new IllegalArgumentException("Unkown Uri"); } int updateCount = db.update(AdsDatabase.Tables.ADS, values, selectionCriteria, selectionArgs); return updateCount; }
@Override public int delete(Uri uri, String selection, String[] selectionArgs) { Log.v(TAG, "delete (uri= " + uri); if (uri.equals(AdsContract.BASE_CONTENT_URI)) { deleteDatabase(); return 0; } final SQLiteDatabase db = mOpenHelper.getWritableDatabase(); final int match = sUriMatcher.match(uri); switch (match) { case ADS: // get all ads // do nothing, prevent update all records if not id provide break; case ADS_ID: String id = AdsContract.Ads.getAdId(uri); String selectionCriteria = BaseColumns._ID + "=" + id + (!TextUtils.isEmpty(selection) ? " AND (" + selection + ") " : ""); return db.delete(AdsDatabase.Tables.ADS, selectionCriteria, selectionArgs); default: throw new IllegalArgumentException("Unkown Uri"); } return 0; }
/** * Implement this to handle requests to insert a new row. As a courtesy, call {@link * ContentResolver#notifyChange(Uri, ContentObserver) notifyChange()} after inserting. This method * can be called from multiple threads, as described in <a * href="{@docRoot}guide/topics/fundamentals/processes-and-threads.html#Threads">Processes and * Threads</a>. * * @param uri The content:// URI of the insertion request. This must not be {@code null}. * @param values A set of column_name/value pairs to add to the database. This must not be {@code * null}. * @return The URI for the newly inserted item. */ @Override public Uri insert(Uri uri, ContentValues values) { Log.v(TAG, "insert (uri= " + uri + ", values= " + values.toString()); final SQLiteDatabase db = mOpenHelper.getWritableDatabase(); final int match = sUriMatcher.match(uri); switch (match) { case ADS: // get all ads long recordId = db.insertOrThrow(AdsDatabase.Tables.ADS, null, values); return AdsContract.Ads.buildAdUri(String.valueOf(recordId)); default: throw new IllegalArgumentException("Unkown Uri"); } }