Ejemplo n.º 1
0
 // bulkInsert is not an abstract method so override is optional
 // Use this method to insert in bulk
 // make sure callNotify is called
 @Override
 public int bulkInsert(Uri uri, ContentValues[] values) {
   MyHelper.writeMsg(CLASS_NAME + "-->bulkInsert is called");
   // Create an instance of writable database
   final SQLiteDatabase db = mMyDatabase.getWritableDatabase();
   // Identify the URIs by using the URI matcher
   final int match = sUriMatcher.match(uri);
   // Initialise the return counter
   int returnCount = 0;
   switch (match) {
     case MARKS:
       // Start a transaction
       db.beginTransaction();
       try {
         for (ContentValues value : values) {
           long _id = db.insert(MyMarks.TABLE_NAME, null, value);
           if (_id != -1) {
             returnCount++;
           }
         }
         db.setTransactionSuccessful();
       } finally {
         db.endTransaction();
       }
       // Notify that there is a change becuase new data got added
       getContext().getContentResolver().notifyChange(uri, null);
       return returnCount;
     default:
       return super.bulkInsert(uri, values);
   }
 }
Ejemplo n.º 2
0
  static {
    MyHelper.writeMsg(CLASS_NAME + "-->static part is called");
    // Define the helper classes which will built the query for us
    // This is for student table only
    myQueryBuilderStudent = new SQLiteQueryBuilder();
    myQueryBuilderStudent.setTables(MyStudent.TABLE_NAME);

    // This is for marks table only
    myQueryBuilderMarks = new SQLiteQueryBuilder();
    myQueryBuilderMarks.setTables(MyMarks.TABLE_NAME);

    // This is for join becuase data required from both the tables
    myQueryBuilderJoin = new SQLiteQueryBuilder();

    // If the data is fetched from a single table then that particular table is set using .setTables
    // but
    // since here the data will be retrieved from two tables, so an inner join is required to
    // retrieve the data.
    // it looks like "student INNER JOIN marks ON student._id = marks.stdntkey"
    myQueryBuilderJoin.setTables(
        MyStudent.TABLE_NAME
            + " INNER JOIN "
            + MyMarks.TABLE_NAME
            + " ON "
            + MyStudent.TABLE_NAME
            + "."
            + MyStudent._ID
            + " = "
            + MyMarks.TABLE_NAME
            + "."
            + MyMarks.COLUMN_NAME_STDNT_KEY);
  }
Ejemplo n.º 3
0
 @Override
 public int delete(Uri uri, String selection, String[] selectionArgs) {
   MyHelper.writeMsg(CLASS_NAME + "-->delete is called");
   final SQLiteDatabase db = mMyDatabase.getWritableDatabase();
   final int match = sUriMatcher.match(uri);
   int rowCount = 0;
   // If selection is null then throw an error
   if (selection == null) {
     throw new UnsupportedOperationException(
         "Cannot perform delete without selection. uri: " + uri);
   }
   switch (match) {
     case STUDENT:
       rowCount = db.delete(MyStudent.TABLE_NAME, selection, selectionArgs);
       break;
     case MARKS:
       rowCount = db.delete(MyMarks.TABLE_NAME, selection, selectionArgs);
       break;
     default:
       throw new UnsupportedOperationException("Unknow uri: " + uri);
   }
   // If all records are not deleted then notify the data change
   if (rowCount != 0) {
     getContext().getContentResolver().notifyChange(uri, null);
   }
   return rowCount;
 }
Ejemplo n.º 4
0
 @Override
 public Uri insert(Uri uri, ContentValues values) {
   MyHelper.writeMsg(CLASS_NAME + "-->insert is called");
   // Create an instance of writable database
   final SQLiteDatabase db = mMyDatabase.getWritableDatabase();
   // Identify the URIs by using the URI matcher
   final int match = sUriMatcher.match(uri);
   // define a long if to hold the return value
   long _id = 0;
   // define the return uri
   Uri retUri;
   switch (match) {
     case STUDENT:
       _id = db.insert(MyStudent.TABLE_NAME, null, values);
       if (_id > 0) {
         retUri = MyContract.MyStudent.buildStudentUri(_id);
       } else {
         throw new android.database.SQLException("Failed the insertion for uri " + uri);
       }
       break;
     case MARKS:
       _id = db.insert(MyMarks.TABLE_NAME, null, values);
       if (_id > 0) {
         retUri = MyContract.MyMarks.buildMarkUri(_id);
       } else {
         throw new android.database.SQLException("Failed the insertion for uri " + uri);
       }
       break;
     default:
       throw new UnsupportedOperationException("Unknown uri: " + uri);
   }
   // Notify that there is a change becuase new data got added
   getContext().getContentResolver().notifyChange(uri, null);
   return retUri;
 }
Ejemplo n.º 5
0
  @Override
  public String getType(Uri uri) {
    MyHelper.writeMsg(CLASS_NAME + "-->getType is called");

    // Identify the URIs by using the URI matcher
    final int match = sUriMatcher.match(uri);

    // Return DIR type if more than one record or ITEM if single record
    switch (match) {
      case STUDENT:
        return MyStudent.CONTENT_TYPE_DIR;
      case STUDENT_WITH_ID:
        return MyStudent.CONTENT_TYPE_ITEM;
      case STUDENT_WITH_NAME:
        return MyStudent.CONTENT_TYPE_ITEM;
      case MARKS:
        return MyMarks.CONTENT_TYPE_DIR;
      case MARKS_WITH_ROLL_SUBJECT:
        // We are expecting a single record when student roll and subject is given
        return MyMarks.CONTENT_TYPE_ITEM;
      case MARKS_WITH_ROLL_MARK:
        // Here we will retrieve => mark. So will be more than one record
        return MyMarks.CONTENT_TYPE_DIR;
      case MARKS_WITH_ROLL_MARK_QPERM:
        // Here we will retrieve => mark. So will be more than one record
        return MyMarks.CONTENT_TYPE_DIR;
      default:
        throw new UnsupportedOperationException("Cannot serve the uri: " + uri);
    }
  }
Ejemplo n.º 6
0
  private static UriMatcher myUriMatcher() {
    MyHelper.writeMsg(CLASS_NAME + "-->myUriMatcher is called");

    // The code passed into the constructor represents the code to return for the root
    // URI.  It's common to use NO_MATCH as the code for this case.
    final UriMatcher matcher = new UriMatcher(UriMatcher.NO_MATCH);

    // Let's add all the URIs
    matcher.addURI(MyContract.CONTENT_AUTHORITY, MyContract.PATH_STUDENT, STUDENT);
    matcher.addURI(MyContract.CONTENT_AUTHORITY, MyContract.PATH_STUDENT + "/#", STUDENT_WITH_ID);
    matcher.addURI(MyContract.CONTENT_AUTHORITY, MyContract.PATH_STUDENT + "/*", STUDENT_WITH_NAME);
    matcher.addURI(MyContract.CONTENT_AUTHORITY, MyContract.PATH_MARKS, MARKS);
    matcher.addURI(
        MyContract.CONTENT_AUTHORITY, MyContract.PATH_MARKS + "/#/#", MARKS_WITH_ROLL_MARK);
    // Note - order matter. If you use /#/# after /#/* then second numeric is considered as
    // alphanumeric!! Need further investigation
    matcher.addURI(
        MyContract.CONTENT_AUTHORITY, MyContract.PATH_MARKS + "/#/*", MARKS_WITH_ROLL_SUBJECT);
    // This is for the URI where Student roll and mark URI is built using query parameter.
    // But notice that we are just considering roll, hence "/#" pattern
    matcher.addURI(
        MyContract.CONTENT_AUTHORITY, MyContract.PATH_MARKS + "/#", MARKS_WITH_ROLL_MARK_QPERM);

    return matcher;
  }
Ejemplo n.º 7
0
  @Override
  public boolean onCreate() {
    MyHelper.writeMsg(CLASS_NAME + "-->onCreate is called");

    // Android calls this when it starts up the provider
    // This is called when a ContentResolver tries to access the provider for the first time
    // Do only fast running initialisation, do not perform lengthy process here

    // Create an instance of the database
    mMyDatabase = new MyDatabase(getContext());

    return false;
  }
Ejemplo n.º 8
0
 @Override
 public int update(Uri uri, ContentValues values, String selection, String[] selectionArgs) {
   MyHelper.writeMsg(CLASS_NAME + "-->update is called");
   final SQLiteDatabase db = mMyDatabase.getWritableDatabase();
   final int match = sUriMatcher.match(uri);
   int rowCount = 0;
   switch (match) {
     case STUDENT:
       rowCount = db.update(MyStudent.TABLE_NAME, values, selection, selectionArgs);
       break;
     case MARKS:
       rowCount = db.update(MyMarks.TABLE_NAME, values, selection, selectionArgs);
       break;
     default:
       throw new UnsupportedOperationException("Unknow uri: " + uri);
   }
   // Notify the data change
   if (rowCount != 0) {
     getContext().getContentResolver().notifyChange(uri, null);
   }
   return rowCount;
 }
Ejemplo n.º 9
0
 @Override
 public Cursor query(
     Uri uri, String[] projection, String selection, String[] selectionArgs, String sortOrder) {
   MyHelper.writeMsg(CLASS_NAME + "-->query is called");
   Cursor retCursor;
   // Identify the URIs by using the URI matcher
   final int match = sUriMatcher.match(uri);
   switch (match) {
     case STUDENT:
       retCursor =
           myQueryBuilderStudent.query(
               mMyDatabase.getReadableDatabase(),
               projection,
               selectionStudent,
               new String[] {Integer.toString(0)},
               null,
               null,
               sortOrder);
       break;
     case STUDENT_WITH_ID:
       long id = MyStudent.getIdFromUri(uri);
       retCursor =
           myQueryBuilderStudent.query(
               mMyDatabase.getReadableDatabase(),
               projection,
               selectionStudentId,
               new String[] {Long.toString(id)},
               null,
               null,
               sortOrder);
       break;
     case STUDENT_WITH_NAME:
       String name = MyStudent.getNameFromUri(uri);
       retCursor =
           myQueryBuilderStudent.query(
               mMyDatabase.getReadableDatabase(),
               projection,
               selectionStudentName,
               new String[] {name},
               null,
               null,
               sortOrder);
       break;
     case MARKS:
       retCursor =
           myQueryBuilderMarks.query(
               mMyDatabase.getReadableDatabase(),
               projection,
               selectionMarks,
               new String[] {Integer.toString(0)},
               null,
               null,
               sortOrder);
       break;
     case MARKS_WITH_ROLL_SUBJECT:
       int roll = MyMarks.getStudentRollFromUri(uri);
       String subj = MyMarks.getSubjectFromUri(uri);
       retCursor =
           myQueryBuilderJoin.query(
               mMyDatabase.getReadableDatabase(),
               projection,
               selectionRollSubj,
               new String[] {Integer.toString(roll), subj},
               null,
               null,
               sortOrder);
       break;
     case MARKS_WITH_ROLL_MARK:
       int roll2 = MyMarks.getStudentRollFromUri(uri);
       int mark = MyMarks.getMarkFromUri(uri);
       // MyHelper.writeMsg("roll->"+roll2);
       // MyHelper.writeMsg("mark->"+mark);
       retCursor =
           myQueryBuilderJoin.query(
               mMyDatabase.getReadableDatabase(),
               projection,
               selectionRollMark,
               new String[] {Integer.toString(roll2), Integer.toString(mark)},
               null,
               null,
               sortOrder);
       break;
     case MARKS_WITH_ROLL_MARK_QPERM:
       int roll3 = MyMarks.getStudentRollFromUri(uri);
       int mark2 = MyMarks.getQPermMarkFromUri(uri);
       retCursor =
           myQueryBuilderJoin.query(
               mMyDatabase.getReadableDatabase(),
               projection,
               // Since the selection parameters are same, so used the same variable
               selectionRollMark,
               new String[] {Integer.toString(roll3), Integer.toString(mark2)},
               null,
               null,
               sortOrder);
       break;
     default:
       throw new UnsupportedOperationException("Cannot serve the uri: " + uri);
   }
   retCursor.setNotificationUri(getContext().getContentResolver(), uri);
   return retCursor;
 }