Home
last modified time | relevance | path

Searched refs:qb (Results 1 – 25 of 30) 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.java308 final SQLiteQueryBuilder qb = new SQLiteQueryBuilder(); in queryInternal() local
309 qb.setTables(Tables.CALLS); in queryInternal()
310 qb.setProjectionMap(sCallsProjectionMap); in queryInternal()
311 qb.setStrict(true); in queryInternal()
332 qb.appendWhere("PHONE_NUMBERS_EQUAL(number, "); in queryInternal()
333 qb.appendWhereEscapeString(phoneNumber); in queryInternal()
334 qb.appendWhere(mUseStrictPhoneNumberComparation ? ", 1)" : ", 0)"); in queryInternal()
336 qb.appendWhere(Calls.NUMBER_PRESENTATION + "!=" in queryInternal()
354 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 …]
DSmsProvider.java123 SQLiteQueryBuilder qb = new SQLiteQueryBuilder(); in query() local
130 constructQueryForBox(qb, Sms.MESSAGE_TYPE_ALL, smsTable); in query()
134 constructQueryForUndelivered(qb, smsTable); in query()
138 constructQueryForBox(qb, Sms.MESSAGE_TYPE_FAILED, smsTable); in query()
142 constructQueryForBox(qb, Sms.MESSAGE_TYPE_QUEUED, smsTable); in query()
146 constructQueryForBox(qb, Sms.MESSAGE_TYPE_INBOX, smsTable); in query()
150 constructQueryForBox(qb, Sms.MESSAGE_TYPE_SENT, smsTable); in query()
154 constructQueryForBox(qb, Sms.MESSAGE_TYPE_DRAFT, smsTable); in query()
158 constructQueryForBox(qb, Sms.MESSAGE_TYPE_OUTBOX, smsTable); in query()
162 qb.setTables(smsTable); 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 …]
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()
DTelephonyProvider.java2818 SQLiteQueryBuilder qb = new SQLiteQueryBuilder(); in query() local
2819 qb.setStrict(true); // a little protection from injection attacks in query()
2820 qb.setTables(CARRIERS_TABLE); in query()
2958 qb.setTables(SIMINFO_TABLE); in query()
2972 qb.appendWhere(IS_NOT_OWNED_BY_DPC); in query()
2973 return getSubscriptionMatchingAPNList(qb, projectionIn, selection, selectionArgs, in query()
2990 qb.appendWhereStandalone(IS_OWNED_BY_DPC); in query()
2993 qb.appendWhereStandalone(IS_NOT_OWNED_BY_DPC); in query()
2995 return getSubscriptionMatchingAPNList(qb, projectionIn, selection, selectionArgs, in query()
3006 qb.appendWhere(TextUtils.join(" AND ", constraints)); in query()
[all …]
DCarrierIdProvider.java229 SQLiteQueryBuilder qb = new SQLiteQueryBuilder(); in query() local
230 qb.setTables(CARRIER_ID_TABLE); in query()
233 return qb.query(db, projectionIn, selection, selectionArgs, null, null, sortOrder); in query()
/packages/providers/MediaProvider/src/com/android/providers/media/
DMediaProvider.java1743 SQLiteQueryBuilder qb = getQueryBuilder(TYPE_QUERY, uri, table, queryArgs); in queryInternal() local
1785 appendWhereStandalone(qb, keywordColumn + " LIKE ? ESCAPE '\\'", in queryInternal()
1807 qb.setDistinct(true); in queryInternal()
1854 final Cursor c = qb.query(db, projection, in queryInternal()
3314 private static void appendWhereStandalone(@NonNull SQLiteQueryBuilder qb, in appendWhereStandalone() argument
3316 qb.appendWhereStandalone(DatabaseUtils.bindSelection(selection, selectionArgs)); in appendWhereStandalone()
3383 final SQLiteQueryBuilder qb = new SQLiteQueryBuilder(); in getQueryBuilderInternal() local
3385 qb.setDistinct(true); in getQueryBuilderInternal()
3387 qb.setProjectionAggregationAllowed(true); in getQueryBuilderInternal()
3388 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 …]
/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/providers/DownloadProvider/src/com/android/providers/downloads/
DDownloadProvider.java1357 final SQLiteQueryBuilder qb = getQueryBuilder(uri, match); in query() local
1362 return qb.query(db, projection, null, null, null, null, null); in query()
1369 final SQLiteQueryBuilder qb = getQueryBuilder(uri, match); in query() local
1371 final Cursor ret = qb.query(db, projection, selection, selectionArgs, null, null, sort); in query()
1530 final SQLiteQueryBuilder qb = getQueryBuilder(uri, match); in update() local
1531 count = qb.update(db, filteredValues, where, whereArgs); in update()
1533 try (Cursor cursor = qb.query(db, null, where, whereArgs, null, null, null); in update()
1550 qb.update(db, updateValues, Downloads.Impl._ID + "=?", in update()
1574 qb.update(db, updateValues, Downloads.Impl._ID + "=?", in update()
1671 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.java95 SQLiteQueryBuilder qb = new SQLiteQueryBuilder(); in query() local
96 qb.setTables(CellBroadcastDatabaseHelper.TABLE_NAME); in query()
106 qb.appendWhere("(_id=" + uri.getPathSegments().get(0) + ')'); in query()
122 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