Пример #1
0
  @Override
  public Uri insert(Uri uri, ContentValues initialValues) {

    if (uriMatcher.match(uri) == UriMatcher.NO_MATCH) {
      throw new IllegalArgumentException("Unknown URI " + uri);
    }

    ContentValues values;
    if (initialValues != null) {
      values = new ContentValues(initialValues);
    } else {
      values = new ContentValues();
    }

    long rowId = 0;

    switch (uriMatcher.match(uri)) {
      case NOTE_ITEM:
        rowId =
            DatabaseHelper.getCurrentTimelineDatabase()
                .insertWithOnConflict(
                    SQLStatements.NOTE_DATABASE_TABLE_NAME,
                    NoteColumns.NOTE,
                    values,
                    SQLiteDatabase.CONFLICT_REPLACE);
        return notifyContentResolver(uri, rowId);

      case PICTURE_ITEM:
        rowId =
            DatabaseHelper.getCurrentTimelineDatabase()
                .insertWithOnConflict(
                    SQLStatements.PICTURE_DATABASE_TABLE_NAME,
                    "",
                    values,
                    SQLiteDatabase.CONFLICT_REPLACE);
        return notifyContentResolver(uri, rowId);

      case RECORDING_ITEM:
        rowId =
            DatabaseHelper.getCurrentTimelineDatabase()
                .insertWithOnConflict(
                    SQLStatements.RECORDINGS_DATABASE_TABLE_NAME,
                    "",
                    values,
                    SQLiteDatabase.CONFLICT_REPLACE);
        return notifyContentResolver(uri, rowId);
      case VIDEO_ITEM:
        rowId =
            DatabaseHelper.getCurrentTimelineDatabase()
                .insertWithOnConflict(
                    SQLStatements.VIDEO_DATABASE_TABLE_NAME,
                    "",
                    values,
                    SQLiteDatabase.CONFLICT_REPLACE);
        return notifyContentResolver(uri, rowId);

      default:
        throw new IllegalArgumentException("Unknown URI " + uri);
    }
  }
Пример #2
0
  @Override
  public int delete(Uri uri, String id, String[] whereArgs) {

    String itemID = "'" + id + "'";
    int count = 0;
    DatabaseHelper.getCurrentTimelineDatabase()
        .delete(
            SQLStatements.EVENT_TO_EVENT_ITEM_DATABASE_TABLE_NAME,
            EventItemsColumns.EVENT_ITEM_ID + "=" + itemID,
            whereArgs);

    switch (uriMatcher.match(uri)) {
      case NOTE_ITEM:
        count =
            DatabaseHelper.getCurrentTimelineDatabase()
                .delete(
                    SQLStatements.NOTE_DATABASE_TABLE_NAME,
                    BaseColumns._ID + "=" + itemID,
                    whereArgs);
        break;
      case PICTURE_ITEM:
        count =
            DatabaseHelper.getCurrentTimelineDatabase()
                .delete(
                    SQLStatements.PICTURE_DATABASE_TABLE_NAME,
                    BaseColumns._ID + "=" + itemID,
                    whereArgs);
        break;
      case RECORDING_ITEM:
        count =
            DatabaseHelper.getCurrentTimelineDatabase()
                .delete(
                    SQLStatements.RECORDINGS_DATABASE_TABLE_NAME,
                    BaseColumns._ID + "=" + itemID,
                    whereArgs);
        break;
      case VIDEO_ITEM:
        count =
            DatabaseHelper.getCurrentTimelineDatabase()
                .delete(
                    SQLStatements.VIDEO_DATABASE_TABLE_NAME,
                    BaseColumns._ID + "=" + itemID,
                    whereArgs);
        break;

      default:
        throw new IllegalArgumentException("Unknown URI " + uri);
    }
    return count;
  }
Пример #3
0
 public SQLiteDatabase getDatabase() {
   return DatabaseHelper.getCurrentTimelineDatabase();
 }