コード例 #1
0
  @Override
  public Cursor query(
      Uri uri, String[] projection, String selection, String[] selectionArgs, String sortOrder) {
    // here's the switch statement that, given a URI, will determine what kind of request it is,
    // and query the database accordingly.
    Cursor retCursor;
    switch (sUriMatcher.match(uri)) {
        // "user/*/*"
      case USER_WITH_MOVIEID_AND_FAVORITE:
        {
          retCursor = getUserByMovieIDAndFavorite(uri, projection, sortOrder);
          break;
        }
        // "user/*"
      case USER_WITH_MOVIEID:
        {
          retCursor = getUserByMovieID(uri, projection, sortOrder);
          break;
        }
        // "user"
      case USER:
        retCursor =
            sSuperUserBuilder.query(
                mOpenHelper.getReadableDatabase(),
                projection,
                selection,
                selectionArgs,
                null,
                null,
                sortOrder);

        /*                retCursor = mOpenHelper.getReadableDatabase().query(
                //MovieContract.UserEntry.TABLE_NAME,
                projection,
                selection,
                selectionArgs,
                null,
                null,
                sortOrder
        );*/
        break;
      case MOVIEID:
        retCursor =
            mOpenHelper
                .getReadableDatabase()
                .query(
                    MovieContract.MovieEntry.TABLE_NAME,
                    projection,
                    selection,
                    selectionArgs,
                    null,
                    null,
                    sortOrder);
        break;
      default:
        throw new UnsupportedOperationException("Unknown uri: " + uri);
    }
    retCursor.setNotificationUri(getContext().getContentResolver(), uri);
    return retCursor;
  }
コード例 #2
0
 @Override
 public int bulkInsert(Uri uri, ContentValues[] values) {
   final SQLiteDatabase db = mOpenHelper.getWritableDatabase();
   final int match = sUriMatcher.match(uri);
   switch (match) {
     case USER:
       db.beginTransaction();
       int returnCount = 0;
       try {
         for (ContentValues value : values) {
           long _id = db.insert(MovieContract.UserEntry.TABLE_NAME, null, value);
           if (_id != -1) {
             returnCount++;
           }
         }
         db.setTransactionSuccessful();
       } finally {
         db.endTransaction();
       }
       getContext().getContentResolver().notifyChange(uri, null);
       return returnCount;
     default:
       return super.bulkInsert(uri, values);
   }
 }
コード例 #3
0
  /*
     Student: Add the ability to insert Locations to the implementation of this function.
  */
  @Override
  public Uri insert(Uri uri, ContentValues values) {
    final SQLiteDatabase db = mOpenHelper.getWritableDatabase();
    final int match = sUriMatcher.match(uri);
    Uri returnUri;

    switch (match) {
      case USER:
        {
          long _id = db.insert(MovieContract.UserEntry.TABLE_NAME, null, values);
          if (_id > 0) returnUri = MovieContract.UserEntry.buildUserUri(_id);
          else throw new android.database.SQLException("Failed to insert row into " + uri);
          break;
        }
      case MOVIEID:
        {
          long _id = db.insert(MovieContract.MovieEntry.TABLE_NAME, null, values);
          if (_id > 0) returnUri = MovieContract.MovieEntry.buildMovieUri(_id);
          else throw new android.database.SQLException("Failed to insert row into " + uri);
          break;
        }
      default:
        throw new UnsupportedOperationException("Unknown uri: " + uri);
    }
    getContext().getContentResolver().notifyChange(uri, null);
    return returnUri;
  }
コード例 #4
0
  private Cursor getUserByMovieIDAndFavorite(Uri uri, String[] projection, String sortOrder) {
    String movieID = MovieContract.UserEntry.getMovieIDFromUri(uri);
    boolean favorite = MovieContract.UserEntry.getFavoriteFromUri(uri);

    return sUserByMovieIDQueryBuilder.query(
        mOpenHelper.getReadableDatabase(),
        projection,
        sMovieIDWithFavoriteSelection,
        new String[] {movieID, Boolean.toString(favorite).toUpperCase()},
        null,
        null,
        sortOrder);
  }
コード例 #5
0
  @Override
  public int update(Uri uri, ContentValues values, String selection, String[] selectionArgs) {
    final SQLiteDatabase db = mOpenHelper.getWritableDatabase();
    final int match = sUriMatcher.match(uri);
    int rowsUpdated;

    switch (match) {
      case USER:
        rowsUpdated =
            db.update(MovieContract.UserEntry.TABLE_NAME, values, selection, selectionArgs);
        break;
      case MOVIEID:
        rowsUpdated =
            db.update(MovieContract.MovieEntry.TABLE_NAME, values, selection, selectionArgs);
        break;
      default:
        throw new UnsupportedOperationException("Unknown uri: " + uri);
    }
    if (rowsUpdated != 0) {
      getContext().getContentResolver().notifyChange(uri, null);
    }
    return rowsUpdated;
  }
コード例 #6
0
  @Override
  public int delete(Uri uri, String selection, String[] selectionArgs) {
    final SQLiteDatabase db = mOpenHelper.getWritableDatabase();
    final int match = sUriMatcher.match(uri);
    int rowsDeleted;
    // this makes delete all rows return the number of rows deleted
    if (null == selection) selection = "1";
    switch (match) {
      case USER:
        rowsDeleted = db.delete(MovieContract.UserEntry.TABLE_NAME, selection, selectionArgs);
        break;

      case MOVIEID:
        rowsDeleted = db.delete(MovieContract.MovieEntry.TABLE_NAME, selection, selectionArgs);
        break;
      default:
        throw new UnsupportedOperationException("Unknown uri: " + uri);
    }
    // Because a null deletes all rows
    if (rowsDeleted != 0) {
      getContext().getContentResolver().notifyChange(uri, null);
    }
    return rowsDeleted;
  }
コード例 #7
0
  private Cursor getUserByMovieID(Uri uri, String[] projection, String sortOrder) {
    String movieID = MovieContract.UserEntry.getMovieIDFromUri(uri);
    boolean favorite = MovieContract.UserEntry.getFavoriteFromUri(uri);

    String[] selectionArgs;
    String selection;

    if (favorite == false) {
      selection = sMovieIDSelection;
      selectionArgs = new String[] {movieID};
    } else {
      selectionArgs = new String[] {movieID, Boolean.toString(favorite).toUpperCase()};
      selection = sMovieIDWithFavoriteSelection;
    }

    return sUserByMovieIDQueryBuilder.query(
        mOpenHelper.getReadableDatabase(),
        projection,
        selection,
        selectionArgs,
        null,
        null,
        sortOrder);
  }
コード例 #8
0
 // You do not need to call this method. This is a method specifically to assist the testing
 // framework in running smoothly. You can read more at:
 // http://developer.android.com/reference/android/content/ContentProvider.html#shutdown()
 @Override
 @TargetApi(11)
 public void shutdown() {
   mOpenHelper.close();
   super.shutdown();
 }