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;
} |
