Home
last modified time | relevance | path

Searched refs:qb (Results 1 – 25 of 37) sorted by relevance

12

/packages/providers/ContactsProvider/src/com/android/providers/contacts/
DLegacyApiSupport.java1550 SQLiteQueryBuilder qb = new SQLiteQueryBuilder(); in query() local
1556 qb.setTables(LegacyTables.PEOPLE_JOIN_PRESENCE); in query()
1557 qb.setProjectionMap(sPeopleProjectionMap); in query()
1558 applyRawContactsAccount(qb); in query()
1563 qb.setTables(LegacyTables.PEOPLE_JOIN_PRESENCE); in query()
1564 qb.setProjectionMap(sPeopleProjectionMap); in query()
1565 applyRawContactsAccount(qb); in query()
1566 qb.appendWhere(" AND " + People._ID + "="); in query()
1567 qb.appendWhere(uri.getPathSegments().get(1)); in query()
1571 qb.setTables(LegacyTables.PEOPLE_JOIN_PRESENCE); in query()
[all …]
DContactsProvider2.java5743 SQLiteQueryBuilder qb = new SQLiteQueryBuilder(); in queryLocal() local
5760 setTablesAndProjectionMapForContacts(qb, projection); in queryLocal()
5761 appendLocalDirectoryAndAccountSelectionIfNeeded(qb, directoryId, uri); in queryLocal()
5767 setTablesAndProjectionMapForContacts(qb, projection); in queryLocal()
5769 qb.appendWhere(Contacts._ID + "=?"); in queryLocal()
5797 setTablesAndProjectionMapForContacts(qb, projection); in queryLocal()
5800 qb.appendWhere(Contacts._ID + "=?"); in queryLocal()
5834 setTablesAndProjectionMapForData(qb, uri, projection, false); in queryLocal()
5839 qb.appendWhere(" AND " + Data._ID + "=" + Contacts.PHOTO_ID); in queryLocal()
5841 qb.appendWhere(" AND " + Data.CONTACT_ID + "=?"); in queryLocal()
[all …]
DContactMetadataProvider.java130 final SQLiteQueryBuilder qb = new SQLiteQueryBuilder(); in query() local
138 setTablesAndProjectionMapForMetadata(qb); in query()
142 setTablesAndProjectionMapForMetadata(qb); in query()
149 setTablesAndProjectionMapForSyncState(qb); in query()
156 return qb.query(db, projection, selectionBuilder.build(), selectionArgs, null, in query()
328 private void setTablesAndProjectionMapForMetadata(SQLiteQueryBuilder qb){ in setTablesAndProjectionMapForMetadata() argument
329 qb.setTables(Views.METADATA_SYNC); in setTablesAndProjectionMapForMetadata()
330 qb.setProjectionMap(sMetadataProjectionMap); in setTablesAndProjectionMapForMetadata()
331 qb.setStrict(true); in setTablesAndProjectionMapForMetadata()
334 private void setTablesAndProjectionMapForSyncState(SQLiteQueryBuilder qb){ in setTablesAndProjectionMapForSyncState() argument
[all …]
DVoicemailStatusTable.java126 SQLiteQueryBuilder qb = new SQLiteQueryBuilder(); in query() local
127 qb.setTables(mTableName); in query()
128 qb.setProjectionMap(sStatusProjectionMap); in query()
129 qb.setStrict(true); in query()
133 Cursor c = qb in query()
DCallLogProvider.java322 final SQLiteQueryBuilder qb = new SQLiteQueryBuilder(); in queryInternal() local
323 qb.setTables(Tables.CALLS); in queryInternal()
324 qb.setProjectionMap(sCallsProjectionMap); in queryInternal()
325 qb.setStrict(true); in queryInternal()
346 qb.appendWhere("PHONE_NUMBERS_EQUAL(number, "); in queryInternal()
347 qb.appendWhereEscapeString(phoneNumber); in queryInternal()
348 qb.appendWhere(mUseStrictPhoneNumberComparation ? ", 1)" in queryInternal()
351 qb.appendWhere(Calls.NUMBER_PRESENTATION + "!=" in queryInternal()
369 final Cursor c = qb.query(db, projection, selectionBuilder.build(), selectionArgs, null, in queryInternal()
DVoicemailContentTable.java267 SQLiteQueryBuilder qb = new SQLiteQueryBuilder(); in query() local
268 qb.setTables(mTableName); in query()
269 qb.setProjectionMap(mVoicemailProjectionMap); in query()
270 qb.setStrict(true); in query()
275 Cursor c = qb.query(db, projection, combinedClause, selectionArgs, null, null, sortOrder); in query()
/packages/providers/TelephonyProvider/src/com/android/providers/telephony/
DHbpcdLookupProvider.java171 SQLiteQueryBuilder qb = new SQLiteQueryBuilder(); in query() local
179 qb.setTables(TABLE_MCC_IDD); in query()
180 qb.setProjectionMap(sIddProjectionMap); in query()
187 qb.setTables(TABLE_MCC_LOOKUP_TABLE); in query()
188 qb.setProjectionMap(sLookupProjectionMap); in query()
209 qb.setTables(joinT.toString()); in query()
210 qb.setProjectionMap(sConflictProjectionMap); in query()
214 qb.setTables(TABLE_MCC_SID_RANGE); in query()
215 qb.setProjectionMap(sRangeProjectionMap); in query()
222 qb.setTables(TABLE_NANP_AREA_CODE); in query()
[all …]
DMmsProvider.java102 SQLiteQueryBuilder qb = new SQLiteQueryBuilder(); in query() local
112 constructQueryForBox(qb, Mms.MESSAGE_BOX_ALL, pduTable); in query()
115 constructQueryForBox(qb, Mms.MESSAGE_BOX_INBOX, pduTable); in query()
118 constructQueryForBox(qb, Mms.MESSAGE_BOX_SENT, pduTable); in query()
121 constructQueryForBox(qb, Mms.MESSAGE_BOX_DRAFTS, pduTable); in query()
124 constructQueryForBox(qb, Mms.MESSAGE_BOX_OUTBOX, pduTable); in query()
127 qb.setTables(pduTable); in query()
128 qb.appendWhere(Mms._ID + "=" + uri.getPathSegments().get(0)); in query()
134 qb.setTables(pduTable); in query()
135 qb.appendWhere(Mms._ID + "=" + uri.getPathSegments().get(1)); in query()
[all …]
DSmsProvider.java127 SQLiteQueryBuilder qb = new SQLiteQueryBuilder(); in query() local
144 constructQueryForBox(qb, Sms.MESSAGE_TYPE_ALL, smsTable); in query()
148 constructQueryForUndelivered(qb, smsTable); in query()
152 constructQueryForBox(qb, Sms.MESSAGE_TYPE_FAILED, smsTable); in query()
156 constructQueryForBox(qb, Sms.MESSAGE_TYPE_QUEUED, smsTable); in query()
160 constructQueryForBox(qb, Sms.MESSAGE_TYPE_INBOX, smsTable); in query()
164 constructQueryForBox(qb, Sms.MESSAGE_TYPE_SENT, smsTable); in query()
168 constructQueryForBox(qb, Sms.MESSAGE_TYPE_DRAFT, smsTable); in query()
172 constructQueryForBox(qb, Sms.MESSAGE_TYPE_OUTBOX, smsTable); in query()
176 qb.setTables(smsTable); in query()
[all …]
DSmsChangesProvider.java74 SQLiteQueryBuilder qb = new SQLiteQueryBuilder(); in query() local
75 qb.setTables(TABLE_SMS_CHANGES); in query()
77 return qb.query(db, projectionIn, selection, selectionArgs, in query()
DCarrierProvider.java70 SQLiteQueryBuilder qb = new SQLiteQueryBuilder(); in query() local
71 qb.setTables(CarrierDatabaseHelper.CARRIER_KEY_TABLE); in query()
74 Cursor c = qb.query(db, projectionIn, selection, selectionArgs, null, null, sortOrder); in query()
/packages/providers/MediaProvider/src/com/android/providers/media/
DMediaProvider.java1744 SQLiteQueryBuilder qb = getQueryBuilder(TYPE_QUERY, uri, table, queryArgs); in queryInternal() local
1786 appendWhereStandalone(qb, keywordColumn + " LIKE ? ESCAPE '\\'", in queryInternal()
1808 qb.setDistinct(true); in queryInternal()
1855 final Cursor c = qb.query(db, projection, in queryInternal()
3315 private static void appendWhereStandalone(@NonNull SQLiteQueryBuilder qb, in appendWhereStandalone() argument
3317 qb.appendWhereStandalone(DatabaseUtils.bindSelection(selection, selectionArgs)); in appendWhereStandalone()
3384 final SQLiteQueryBuilder qb = new SQLiteQueryBuilder(); in getQueryBuilderInternal() local
3386 qb.setDistinct(true); in getQueryBuilderInternal()
3388 qb.setProjectionAggregationAllowed(true); in getQueryBuilderInternal()
3389 qb.setStrict(true); in getQueryBuilderInternal()
[all …]
/packages/apps/DeskClock/src/com/android/deskclock/provider/
DClockProvider.java150 SQLiteQueryBuilder qb = new SQLiteQueryBuilder(); in query() local
157 qb.setTables(ALARMS_TABLE_NAME); in query()
160 qb.setTables(ALARMS_TABLE_NAME); in query()
161 qb.appendWhere(AlarmsColumns._ID + "="); in query()
162 qb.appendWhere(uri.getLastPathSegment()); in query()
165 qb.setTables(INSTANCES_TABLE_NAME); in query()
168 qb.setTables(INSTANCES_TABLE_NAME); in query()
169 qb.appendWhere(InstancesColumns._ID + "="); in query()
170 qb.appendWhere(uri.getLastPathSegment()); in query()
173 qb.setTables(ALARM_JOIN_INSTANCE_TABLE_STATEMENT); in query()
[all …]
DClockProvider.kt156 val qb = SQLiteQueryBuilder() in query() constant
161 ALARMS -> qb.setTables(ALARMS_TABLE_NAME) in query()
163 qb.setTables(ALARMS_TABLE_NAME) in query()
164 qb.appendWhere(BaseColumns._ID.toString() + "=") in query()
165 qb.appendWhere(uri.getLastPathSegment()!!) in query()
167 INSTANCES -> qb.setTables(INSTANCES_TABLE_NAME) in query()
169 qb.setTables(INSTANCES_TABLE_NAME) in query()
170 qb.appendWhere(BaseColumns._ID.toString() + "=") in query()
171 qb.appendWhere(uri.getLastPathSegment()!!) in query()
174 qb.setTables(ALARM_JOIN_INSTANCE_TABLE_STATEMENT) in query()
[all …]
/packages/providers/CalendarProvider/src/com/android/providers/calendar/
DCalendarProvider2.java974 SQLiteQueryBuilder qb = new SQLiteQueryBuilder(); in queryInternal() local
1004 qb.setTables(CalendarDatabaseHelper.Views.EVENTS); in queryInternal()
1005 qb.setProjectionMap(sEventsProjectionMap); in queryInternal()
1011 qb.setTables(CalendarDatabaseHelper.Views.EVENTS); in queryInternal()
1012 qb.setProjectionMap(sEventsProjectionMap); in queryInternal()
1014 qb.appendWhere(SQL_WHERE_ID); in queryInternal()
1018 qb.setTables(CalendarDatabaseHelper.Views.EVENTS); in queryInternal()
1019 qb.setProjectionMap(sEventEntitiesProjectionMap); in queryInternal()
1025 qb.setTables(CalendarDatabaseHelper.Views.EVENTS); in queryInternal()
1026 qb.setProjectionMap(sEventEntitiesProjectionMap); in queryInternal()
[all …]
DCalendarInstancesHelper.java561 SQLiteQueryBuilder qb = new SQLiteQueryBuilder(); in getEntries() local
562 qb.setTables(CalendarDatabaseHelper.Views.EVENTS); in getEntries()
563 qb.setProjectionMap(CalendarProvider2.sEventsProjectionMap); in getEntries()
584 qb.appendWhere(SQL_WHERE_GET_EVENTS_ENTRIES); in getEntries()
594 Cursor c = qb.query(db, EXPAND_COLUMNS, null /* selection */, selectionArgs, in getEntries()
834 SQLiteQueryBuilder qb = new SQLiteQueryBuilder(); in getRelevantRecurrenceEntries() local
836 qb.setTables(CalendarDatabaseHelper.Views.EVENTS); in getRelevantRecurrenceEntries()
837 qb.setProjectionMap(CalendarProvider2.sEventsProjectionMap); in getRelevantRecurrenceEntries()
841 qb.appendWhere(where); in getRelevantRecurrenceEntries()
849 qb.appendWhere(where); in getRelevantRecurrenceEntries()
[all …]
/packages/apps/Messaging/src/com/android/messaging/datamodel/
DDatabaseWrapper.java197 private void explainQueryPlan(final SQLiteQueryBuilder qb, final SQLiteDatabase db, in explainQueryPlan() argument
205 final String queryString = qb.buildQuery( in explainQueryPlan()
248 final SQLiteQueryBuilder qb = new SQLiteQueryBuilder(); in query() local
249 qb.setTables(searchTable); in query()
250 explainQueryPlan(qb, mDatabase, projection, selection, selectionArgs, in query()
278 public Cursor query(final SQLiteQueryBuilder qb, in query() argument
282 explainQueryPlan(qb, mDatabase, projection, selection, queryArgs, in query()
290 final Cursor cursor = qb.query(mDatabase, projection, selection, queryArgs, groupBy, in query()
296 qb.getTables(), selection, cursor.getCount())); in query()
/packages/providers/UserDictionaryProvider/src/com/android/providers/userdictionary/
DUserDictionaryProvider.java160 SQLiteQueryBuilder qb = new SQLiteQueryBuilder(); in query() local
164 qb.setTables(USERDICT_TABLE_NAME); in query()
165 qb.setProjectionMap(sDictProjectionMap); in query()
169 qb.setTables(USERDICT_TABLE_NAME); in query()
170 qb.setProjectionMap(sDictProjectionMap); in query()
171 qb.appendWhere("_id" + "=" + uri.getPathSegments().get(1)); in query()
188 Cursor c = qb.query(db, projection, selection, selectionArgs, null, null, orderBy); in query()
/packages/apps/Bluetooth/src/com/android/bluetooth/opp/
DBluetoothOppProvider.java270 SQLiteQueryBuilder qb = new SQLiteQueryBuilder(); in query() local
271 qb.setStrict(true); in query()
276 qb.setTables(DB_TABLE); in query()
279 qb.setTables(DB_TABLE); in query()
280 qb.appendWhere(BluetoothShare._ID + "="); in query()
281 qb.appendWhere(uri.getPathSegments().get(1)); in query()
329 Cursor ret = qb.query(db, projection, selection, selectionArgs, null, null, sortOrder); in query()
/packages/providers/PartnerBookmarksProvider/src/com/android/providers/partnerbookmarks/
DPartnerBookmarksProvider.java363 SQLiteQueryBuilder qb = new SQLiteQueryBuilder(); in query() local
389 qb.setProjectionMap(BOOKMARKS_PROJECTION_MAP); in query()
390 qb.setTables(TABLE_BOOKMARKS); in query()
395 qb.setTables(TABLE_BOOKMARKS); in query()
402 qb.setProjectionMap(BOOKMARKS_PROJECTION_MAP); in query()
409 query = qb.buildQuery(projection, where, null, null, sortOrder, null); in query()
426 return qb.query(db, projection, selection, selectionArgs, groupBy, null, sortOrder, limit); in query()
/packages/modules/CellBroadcastService/src/com/android/cellbroadcastservice/
DCellBroadcastProvider.java188 SQLiteQueryBuilder qb = new SQLiteQueryBuilder(); in query() local
189 qb.setStrict(true); // a little protection from injection attacks in query()
190 qb.setTables(CELL_BROADCASTS_TABLE_NAME); in query()
207 qb.appendWhere(CellBroadcasts.MESSAGE_BROADCASTED + "=1"); in query()
208 return qb.query(getReadableDatabase(), projection, selection, selectionArgs, null, in query()
/packages/providers/DownloadProvider/src/com/android/providers/downloads/
DDownloadProvider.java1366 final SQLiteQueryBuilder qb = getQueryBuilder(uri, match); in query() local
1371 return qb.query(db, projection, null, null, null, null, null); in query()
1378 final SQLiteQueryBuilder qb = getQueryBuilder(uri, match); in query() local
1380 final Cursor ret = qb.query(db, projection, selection, selectionArgs, null, null, sort); in query()
1539 final SQLiteQueryBuilder qb = getQueryBuilder(uri, match); in update() local
1540 count = qb.update(db, filteredValues, where, whereArgs); in update()
1542 try (Cursor cursor = qb.query(db, null, where, whereArgs, null, null, null); in update()
1559 qb.update(db, updateValues, Downloads.Impl._ID + "=?", in update()
1591 qb.update(db, updateValues, Downloads.Impl._ID + "=?", in update()
1685 final SQLiteQueryBuilder qb = new SQLiteQueryBuilder(); in getQueryBuilder() local
[all …]
/packages/apps/Dialer/java/com/android/dialer/blocking/
DFilteredNumberProvider.java66 SQLiteQueryBuilder qb = new SQLiteQueryBuilder(); in query() local
67 qb.setTables(DialerDatabaseHelper.Tables.FILTERED_NUMBER_TABLE); in query()
73 qb.appendWhere(FilteredNumberColumns._ID + "=" + ContentUris.parseId(uri)); in query()
78 final Cursor c = qb.query(db, projection, selection, selectionArgs, null, null, null); in query()
/packages/apps/CellBroadcastReceiver/src/com/android/cellbroadcastreceiver/
DCellBroadcastContentProvider.java123 SQLiteQueryBuilder qb = new SQLiteQueryBuilder(); in query() local
124 qb.setTables(CellBroadcastDatabaseHelper.TABLE_NAME); in query()
134 qb.appendWhere("(_id=" + uri.getPathSegments().get(0) + ')'); in query()
150 Cursor c = qb.query(db, projection, selection, selectionArgs, null, null, orderBy); in query()
/packages/providers/BlockedNumberProvider/src/com/android/providers/blockednumber/
DBlockedNumberProvider.java290 SQLiteQueryBuilder qb = new SQLiteQueryBuilder(); in queryBlockedList() local
291 qb.setStrict(true); in queryBlockedList()
292 qb.setTables(BlockedNumberDatabaseHelper.Tables.BLOCKED_NUMBERS); in queryBlockedList()
293 qb.setProjectionMap(sBlockedNumberColumns); in queryBlockedList()
295 return qb.query(mDbHelper.getReadableDatabase(), projection, selection, selectionArgs, in queryBlockedList()

12