Esempio n. 1
0
 @Override
 public int delete(Uri uri, String selection, String[] selectionArgs) {
   final SQLiteDatabase db = dbHelper.getWritableDatabase();
   final int match = uriMatcher.match(uri);
   int rowsDeleted;
   switch (match) {
     case BOOK:
       rowsDeleted =
           db.delete(
               com.awesome.byunghwa.app.alexandria.data.AlexandriaContract.BookEntry.TABLE_NAME,
               selection,
               selectionArgs);
       break;
     case AUTHOR:
       rowsDeleted =
           db.delete(
               com.awesome.byunghwa.app.alexandria.data.AlexandriaContract.AuthorEntry.TABLE_NAME,
               selection,
               selectionArgs);
       break;
     case CATEGORY:
       rowsDeleted =
           db.delete(
               com.awesome.byunghwa.app.alexandria.data.AlexandriaContract.CategoryEntry
                   .TABLE_NAME,
               selection,
               selectionArgs);
       break;
     case BOOK_ID:
       rowsDeleted =
           db.delete(
               com.awesome.byunghwa.app.alexandria.data.AlexandriaContract.BookEntry.TABLE_NAME,
               com.awesome.byunghwa.app.alexandria.data.AlexandriaContract.BookEntry._ID
                   + " = '"
                   + ContentUris.parseId(uri)
                   + "'",
               selectionArgs);
       break;
     default:
       throw new UnsupportedOperationException("Unknown uri: " + uri);
   }
   // Because a null deletes all rows
   if (selection == null || rowsDeleted != 0) {
     getContext().getContentResolver().notifyChange(uri, null);
   }
   return rowsDeleted;
 }
Esempio n. 2
0
  @Override
  public int update(Uri uri, ContentValues values, String selection, String[] selectionArgs) {
    final SQLiteDatabase db = dbHelper.getWritableDatabase();
    final int match = uriMatcher.match(uri);
    int rowsUpdated;
    switch (match) {
      case BOOK:
        rowsUpdated =
            db.update(
                com.awesome.byunghwa.app.alexandria.data.AlexandriaContract.BookEntry.TABLE_NAME,
                values,
                selection,
                selectionArgs);
        break;
      case AUTHOR:
        rowsUpdated =
            db.update(
                com.awesome.byunghwa.app.alexandria.data.AlexandriaContract.AuthorEntry.TABLE_NAME,
                values,
                selection,
                selectionArgs);
        break;
      case CATEGORY:
        rowsUpdated =
            db.update(
                com.awesome.byunghwa.app.alexandria.data.AlexandriaContract.CategoryEntry
                    .TABLE_NAME,
                values,
                selection,
                selectionArgs);
        break;

      default:
        throw new UnsupportedOperationException("Unknown uri: " + uri);
    }
    if (rowsUpdated != 0) {
      getContext().getContentResolver().notifyChange(uri, null);
    }
    return rowsUpdated;
  }
Esempio n. 3
0
  @Override
  public Cursor query(
      Uri uri, String[] projection, String selection, String[] selectionArgs, String sortOrder) {
    Cursor retCursor;
    switch (uriMatcher.match(uri)) {
      case BOOK:
        retCursor =
            dbHelper
                .getReadableDatabase()
                .query(
                    com.awesome.byunghwa.app.alexandria.data.AlexandriaContract.BookEntry
                        .TABLE_NAME,
                    projection,
                    selection,
                    selection == null ? null : selectionArgs,
                    null,
                    null,
                    sortOrder);
        break;
      case AUTHOR:
        retCursor =
            dbHelper
                .getReadableDatabase()
                .query(
                    com.awesome.byunghwa.app.alexandria.data.AlexandriaContract.AuthorEntry
                        .TABLE_NAME,
                    projection,
                    selection,
                    selectionArgs,
                    null,
                    null,
                    sortOrder);
        break;
      case CATEGORY:
        retCursor =
            dbHelper
                .getReadableDatabase()
                .query(
                    com.awesome.byunghwa.app.alexandria.data.AlexandriaContract.CategoryEntry
                        .TABLE_NAME,
                    projection,
                    selection,
                    selectionArgs,
                    null,
                    null,
                    sortOrder);
        break;
      case BOOK_ID:
        retCursor =
            dbHelper
                .getReadableDatabase()
                .query(
                    com.awesome.byunghwa.app.alexandria.data.AlexandriaContract.BookEntry
                        .TABLE_NAME,
                    projection,
                    com.awesome.byunghwa.app.alexandria.data.AlexandriaContract.BookEntry._ID
                        + " = '"
                        + ContentUris.parseId(uri)
                        + "'",
                    selectionArgs,
                    null,
                    null,
                    sortOrder);
        break;
      case AUTHOR_ID:
        retCursor =
            dbHelper
                .getReadableDatabase()
                .query(
                    com.awesome.byunghwa.app.alexandria.data.AlexandriaContract.AuthorEntry
                        .TABLE_NAME,
                    projection,
                    com.awesome.byunghwa.app.alexandria.data.AlexandriaContract.AuthorEntry._ID
                        + " = '"
                        + ContentUris.parseId(uri)
                        + "'",
                    selectionArgs,
                    null,
                    null,
                    sortOrder);
        break;
      case CATEGORY_ID:
        retCursor =
            dbHelper
                .getReadableDatabase()
                .query(
                    com.awesome.byunghwa.app.alexandria.data.AlexandriaContract.CategoryEntry
                        .TABLE_NAME,
                    projection,
                    com.awesome.byunghwa.app.alexandria.data.AlexandriaContract.CategoryEntry._ID
                        + " = '"
                        + ContentUris.parseId(uri)
                        + "'",
                    selectionArgs,
                    null,
                    null,
                    sortOrder);
        break;
      case BOOK_FULLDETAIL:
        String[] bfd_projection = {
          com.awesome.byunghwa.app.alexandria.data.AlexandriaContract.BookEntry.TABLE_NAME
              + "."
              + AlexandriaContract.BookEntry._ID,
          com.awesome.byunghwa.app.alexandria.data.AlexandriaContract.BookEntry.TABLE_NAME
              + "."
              + com.awesome.byunghwa.app.alexandria.data.AlexandriaContract.BookEntry.TITLE,
          com.awesome.byunghwa.app.alexandria.data.AlexandriaContract.BookEntry.TABLE_NAME
              + "."
              + com.awesome.byunghwa.app.alexandria.data.AlexandriaContract.BookEntry.SUBTITLE,
          com.awesome.byunghwa.app.alexandria.data.AlexandriaContract.BookEntry.TABLE_NAME
              + "."
              + com.awesome.byunghwa.app.alexandria.data.AlexandriaContract.BookEntry.IMAGE_URL,
          com.awesome.byunghwa.app.alexandria.data.AlexandriaContract.BookEntry.TABLE_NAME
              + "."
              + com.awesome.byunghwa.app.alexandria.data.AlexandriaContract.BookEntry.DESC,
          "group_concat(DISTINCT "
              + com.awesome.byunghwa.app.alexandria.data.AlexandriaContract.AuthorEntry.TABLE_NAME
              + "."
              + com.awesome.byunghwa.app.alexandria.data.AlexandriaContract.AuthorEntry.AUTHOR
              + ") as "
              + com.awesome.byunghwa.app.alexandria.data.AlexandriaContract.AuthorEntry.AUTHOR,
          "group_concat(DISTINCT "
              + com.awesome.byunghwa.app.alexandria.data.AlexandriaContract.CategoryEntry.TABLE_NAME
              + "."
              + com.awesome.byunghwa.app.alexandria.data.AlexandriaContract.CategoryEntry.CATEGORY
              + ") as "
              + com.awesome.byunghwa.app.alexandria.data.AlexandriaContract.CategoryEntry.CATEGORY
        };
        retCursor =
            bookFull.query(
                dbHelper.getReadableDatabase(),
                bfd_projection,
                com.awesome.byunghwa.app.alexandria.data.AlexandriaContract.BookEntry.TABLE_NAME
                    + "."
                    + com.awesome.byunghwa.app.alexandria.data.AlexandriaContract.BookEntry._ID
                    + " = '"
                    + ContentUris.parseId(uri)
                    + "'",
                selectionArgs,
                com.awesome.byunghwa.app.alexandria.data.AlexandriaContract.BookEntry.TABLE_NAME
                    + "."
                    + com.awesome.byunghwa.app.alexandria.data.AlexandriaContract.BookEntry._ID,
                null,
                sortOrder);
        break;
      case BOOK_FULL:
        String[] bf_projection = {
          com.awesome.byunghwa.app.alexandria.data.AlexandriaContract.BookEntry.TABLE_NAME
              + "."
              + com.awesome.byunghwa.app.alexandria.data.AlexandriaContract.BookEntry.TITLE,
          com.awesome.byunghwa.app.alexandria.data.AlexandriaContract.BookEntry.TABLE_NAME
              + "."
              + com.awesome.byunghwa.app.alexandria.data.AlexandriaContract.BookEntry.IMAGE_URL,
          "group_concat(DISTINCT "
              + com.awesome.byunghwa.app.alexandria.data.AlexandriaContract.AuthorEntry.TABLE_NAME
              + "."
              + com.awesome.byunghwa.app.alexandria.data.AlexandriaContract.AuthorEntry.AUTHOR
              + ") as "
              + com.awesome.byunghwa.app.alexandria.data.AlexandriaContract.AuthorEntry.AUTHOR,
          "group_concat(DISTINCT "
              + com.awesome.byunghwa.app.alexandria.data.AlexandriaContract.CategoryEntry.TABLE_NAME
              + "."
              + com.awesome.byunghwa.app.alexandria.data.AlexandriaContract.CategoryEntry.CATEGORY
              + ") as "
              + com.awesome.byunghwa.app.alexandria.data.AlexandriaContract.CategoryEntry.CATEGORY
        };
        retCursor =
            bookFull.query(
                dbHelper.getReadableDatabase(),
                bf_projection,
                null,
                selectionArgs,
                com.awesome.byunghwa.app.alexandria.data.AlexandriaContract.BookEntry.TABLE_NAME
                    + "."
                    + com.awesome.byunghwa.app.alexandria.data.AlexandriaContract.BookEntry._ID,
                null,
                sortOrder);
        break;
      default:
        throw new UnsupportedOperationException("Unknown uri: " + uri);
    }

    retCursor.setNotificationUri(getContext().getContentResolver(), uri);

    return retCursor;
  }
Esempio n. 4
0
 @Override
 public Uri insert(Uri uri, ContentValues values) {
   final SQLiteDatabase db = dbHelper.getWritableDatabase();
   final int match = uriMatcher.match(uri);
   Uri returnUri;
   switch (match) {
     case BOOK:
       {
         long _id =
             db.insert(
                 com.awesome.byunghwa.app.alexandria.data.AlexandriaContract.BookEntry.TABLE_NAME,
                 null,
                 values);
         if (_id > 0) {
           returnUri =
               com.awesome.byunghwa.app.alexandria.data.AlexandriaContract.BookEntry.buildBookUri(
                   _id);
         } else {
           throw new android.database.SQLException("Failed to insert row into " + uri);
         }
         getContext()
             .getContentResolver()
             .notifyChange(
                 com.awesome.byunghwa.app.alexandria.data.AlexandriaContract.BookEntry
                     .buildFullBookUri(_id),
                 null);
         break;
       }
     case AUTHOR:
       {
         long _id =
             db.insert(
                 com.awesome.byunghwa.app.alexandria.data.AlexandriaContract.AuthorEntry
                     .TABLE_NAME,
                 null,
                 values);
         if (_id > 0)
           returnUri =
               com.awesome.byunghwa.app.alexandria.data.AlexandriaContract.AuthorEntry
                   .buildAuthorUri(values.getAsLong("_id"));
         else throw new android.database.SQLException("Failed to insert row into " + uri);
         break;
       }
     case CATEGORY:
       {
         long _id =
             db.insert(
                 com.awesome.byunghwa.app.alexandria.data.AlexandriaContract.CategoryEntry
                     .TABLE_NAME,
                 null,
                 values);
         if (_id > 0)
           returnUri =
               com.awesome.byunghwa.app.alexandria.data.AlexandriaContract.CategoryEntry
                   .buildCategoryUri(values.getAsLong("_id"));
         else throw new android.database.SQLException("Failed to insert row into " + uri);
         break;
       }
     default:
       throw new UnsupportedOperationException("Unknown uri: " + uri);
   }
   return returnUri;
 }