コード例 #1
0
  /** Query entries from the database */
  @Override
  public Cursor query(
      Uri uri, String[] projection, String selection, String[] selectionArgs, String sortOrder) {
    if (database == null || !database.isOpen()) database = databaseHelper.getWritableDatabase();

    SQLiteQueryBuilder qb = new SQLiteQueryBuilder();
    switch (sUriMatcher.match(uri)) {
      case SENSOR_DEV:
        qb.setTables(DATABASE_TABLES[0]);
        qb.setProjectionMap(sensorDeviceMap);
        break;
      case SENSOR_DATA:
        qb.setTables(DATABASE_TABLES[1]);
        qb.setProjectionMap(sensorDataMap);
        break;
      default:
        throw new IllegalArgumentException("Unknown URI " + uri);
    }
    try {
      Cursor c = qb.query(database, projection, selection, selectionArgs, null, null, sortOrder);
      c.setNotificationUri(getContext().getContentResolver(), uri);
      return c;
    } catch (IllegalStateException e) {
      if (Aware.DEBUG) Log.e(Aware.TAG, e.getMessage());

      return null;
    }
  }
コード例 #2
0
  /** Insert entry to the database */
  @Override
  public Uri insert(Uri uri, ContentValues initialValues) {
    if (database == null || !database.isOpen()) database = databaseHelper.getWritableDatabase();

    ContentValues values =
        (initialValues != null) ? new ContentValues(initialValues) : new ContentValues();

    switch (sUriMatcher.match(uri)) {
      case SENSOR_DEV:
        long accel_id = database.insert(DATABASE_TABLES[0], Gravity_Sensor.DEVICE_ID, values);

        if (accel_id > 0) {
          Uri accelUri = ContentUris.withAppendedId(Gravity_Sensor.CONTENT_URI, accel_id);
          getContext().getContentResolver().notifyChange(accelUri, null);
          return accelUri;
        }
        throw new SQLException("Failed to insert row into " + uri);
      case SENSOR_DATA:
        long accelData_id = database.insert(DATABASE_TABLES[1], Gravity_Data.DEVICE_ID, values);

        if (accelData_id > 0) {
          Uri accelDataUri = ContentUris.withAppendedId(Gravity_Data.CONTENT_URI, accelData_id);
          getContext().getContentResolver().notifyChange(accelDataUri, null);
          return accelDataUri;
        }
        throw new SQLException("Failed to insert row into " + uri);
      default:
        throw new IllegalArgumentException("Unknown URI " + uri);
    }
  }
コード例 #3
0
 @Override
 public boolean onCreate() {
   if (databaseHelper == null)
     databaseHelper =
         new DatabaseHelper(
             getContext(), DATABASE_NAME, null, DATABASE_VERSION, DATABASE_TABLES, TABLES_FIELDS);
   database = databaseHelper.getWritableDatabase();
   return (databaseHelper != null);
 }
コード例 #4
0
  /** Update application on the database */
  @Override
  public int update(Uri uri, ContentValues values, String selection, String[] selectionArgs) {
    if (database == null || !database.isOpen()) database = databaseHelper.getWritableDatabase();
    int count = 0;
    switch (sUriMatcher.match(uri)) {
      case SENSOR_DEV:
        count = database.update(DATABASE_TABLES[0], values, selection, selectionArgs);
        break;
      case SENSOR_DATA:
        count = database.update(DATABASE_TABLES[1], values, selection, selectionArgs);
        break;
      default:
        throw new IllegalArgumentException("Unknown URI " + uri);
    }

    getContext().getContentResolver().notifyChange(uri, null);
    return count;
  }