1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35
|
@Override
public Cursor query(Uri uri, String[] projection, String selection, String[] selectionArgs, String sortOrder) {
Log.d("ContentProvider", "query select uri=" + uri);
SQLiteQueryBuilder queryBuilder = new SQLiteQueryBuilder();
String part1 = "";
String part2 = "";
int uriType = sURIMatcher.match(uri);
switch (uriType) {
case VEH_VOITURE:
part1 = SQLiteQueryBuilder.buildQueryString(true, VeHSQLite.TABLE_VEH_VOITURE, projection, selection, null, null, sortOrder, null);
part2 = SQLiteQueryBuilder.buildQueryString(true, VeHSQLite.TABLE_VEH_VOITURE_CUSTOM, projection, selection, null, null, sortOrder, null);
break;
case VEH_CAMION:
part1 = SQLiteQueryBuilder.buildQueryString(true, VeHSQLite.TABLE_VEH_CAMION, projection, selection, null, null, sortOrder, null);
part2 = SQLiteQueryBuilder.buildQueryString(true, VeHSQLite.TABLE_VEH_CAMION_CUSTOM, projection, selection, null, null, sortOrder, null);
break;
default:
throw new IllegalArgumentException("Unknown URI");
}
String query = queryBuilder.buildUnionQuery(new String[]{part1, part2}, sortOrder, null);
Log.d("ContentProvider", "query select sql=" + query);
SQLiteDatabase db = mDB.getReadableDatabase();
Cursor cursor = db.rawQuery(query, null);
cursor.setNotificationUri(getContext().getContentResolver(), uri);
return cursor;
} |
Partager