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.java1613 SQLiteQueryBuilder qb = new SQLiteQueryBuilder(); in query() local
1619 qb.setTables(LegacyTables.PEOPLE_JOIN_PRESENCE); in query()
1620 qb.setProjectionMap(sPeopleProjectionMap); in query()
1621 applyRawContactsAccount(qb); in query()
1626 qb.setTables(LegacyTables.PEOPLE_JOIN_PRESENCE); in query()
1627 qb.setProjectionMap(sPeopleProjectionMap); in query()
1628 applyRawContactsAccount(qb); in query()
1629 qb.appendWhere(" AND " + People._ID + "="); in query()
1630 qb.appendWhere(uri.getPathSegments().get(1)); in query()
1634 qb.setTables(LegacyTables.PEOPLE_JOIN_PRESENCE); in query()
[all …]
DContactsProvider2.java4876 SQLiteQueryBuilder qb = new SQLiteQueryBuilder(); in queryLocal() local
4893 setTablesAndProjectionMapForContacts(qb, uri, projection); in queryLocal()
4894 appendLocalDirectoryAndAccountSelectionIfNeeded(qb, directoryId, uri); in queryLocal()
4900 setTablesAndProjectionMapForContacts(qb, uri, projection); in queryLocal()
4902 qb.appendWhere(Contacts._ID + "=?"); in queryLocal()
4930 setTablesAndProjectionMapForContacts(qb, uri, projection); in queryLocal()
4933 qb.appendWhere(Contacts._ID + "=?"); in queryLocal()
4967 setTablesAndProjectionMapForData(qb, uri, projection, false); in queryLocal()
4972 qb.appendWhere(" AND " + Data._ID + "=" + Contacts.PHOTO_ID); in queryLocal()
4974 qb.appendWhere(" AND " + Data.CONTACT_ID + "=?"); in queryLocal()
[all …]
DVoicemailStatusTable.java87 SQLiteQueryBuilder qb = new SQLiteQueryBuilder(); in query() local
88 qb.setTables(mTableName); in query()
89 qb.setProjectionMap(sStatusProjectionMap); in query()
90 qb.setStrict(true); in query()
94 Cursor c = qb.query(db, projection, combinedClause, selectionArgs, null, null, sortOrder); in query()
DCallLogProvider.java126 SQLiteQueryBuilder qb = new SQLiteQueryBuilder(); in query() local
127 qb.setTables(Tables.CALLS); in query()
128 qb.setProjectionMap(sCallsProjectionMap); in query()
129 qb.setStrict(true); in query()
147 qb.appendWhere("PHONE_NUMBERS_EQUAL(number, "); in query()
148 qb.appendWhereEscapeString(phoneNumber); in query()
149 qb.appendWhere(mUseStrictPhoneNumberComparation ? ", 1)" : ", 0)"); in query()
158 Cursor c = qb.query(db, projection, selectionBuilder.build(), selectionArgs, null, null, in query()
DVoicemailContentTable.java196 SQLiteQueryBuilder qb = new SQLiteQueryBuilder(); in query() local
197 qb.setTables(mTableName); in query()
198 qb.setProjectionMap(mVoicemailProjectionMap); in query()
199 qb.setStrict(true); in query()
204 Cursor c = qb.query(db, projection, combinedClause, selectionArgs, null, null, sortOrder); in query()
DContactsDatabaseHelper.java4440 SQLiteQueryBuilder qb, String normalizedNumber, String numberE164) { in buildPhoneLookupAndContactQuery() argument
4444 qb.setTables(sb.toString()); in buildPhoneLookupAndContactQuery()
4448 qb.appendWhere(sb.toString()); in buildPhoneLookupAndContactQuery()
4458 public void buildMinimalPhoneLookupAndContactQuery(SQLiteQueryBuilder qb, String number) { in buildMinimalPhoneLookupAndContactQuery() argument
4462 qb.setTables(sb.toString()); in buildMinimalPhoneLookupAndContactQuery()
4466 qb.appendWhere(sb.toString()); in buildMinimalPhoneLookupAndContactQuery()
/packages/providers/TelephonyProvider/src/com/android/providers/telephony/
DSmsProvider.java92 SQLiteQueryBuilder qb = new SQLiteQueryBuilder(); in query() local
98 constructQueryForBox(qb, Sms.MESSAGE_TYPE_ALL); in query()
102 constructQueryForUndelivered(qb); in query()
106 constructQueryForBox(qb, Sms.MESSAGE_TYPE_FAILED); in query()
110 constructQueryForBox(qb, Sms.MESSAGE_TYPE_QUEUED); in query()
114 constructQueryForBox(qb, Sms.MESSAGE_TYPE_INBOX); in query()
118 constructQueryForBox(qb, Sms.MESSAGE_TYPE_SENT); in query()
122 constructQueryForBox(qb, Sms.MESSAGE_TYPE_DRAFT); in query()
126 constructQueryForBox(qb, Sms.MESSAGE_TYPE_OUTBOX); in query()
130 qb.setTables(TABLE_SMS); in query()
[all …]
DMmsProvider.java73 SQLiteQueryBuilder qb = new SQLiteQueryBuilder(); in query() local
83 constructQueryForBox(qb, Mms.MESSAGE_BOX_ALL); in query()
86 constructQueryForBox(qb, Mms.MESSAGE_BOX_INBOX); in query()
89 constructQueryForBox(qb, Mms.MESSAGE_BOX_SENT); in query()
92 constructQueryForBox(qb, Mms.MESSAGE_BOX_DRAFTS); in query()
95 constructQueryForBox(qb, Mms.MESSAGE_BOX_OUTBOX); in query()
98 qb.setTables(TABLE_PDU); in query()
99 qb.appendWhere(Mms._ID + "=" + uri.getPathSegments().get(0)); in query()
105 qb.setTables(TABLE_PDU); in query()
106 qb.appendWhere(Mms._ID + "=" + uri.getPathSegments().get(1)); in query()
[all …]
DTelephonyProvider.java426 SQLiteQueryBuilder qb = new SQLiteQueryBuilder(); in query() local
427 qb.setTables("carriers"); in query()
438 qb.appendWhere("current IS NOT NULL"); in query()
445 qb.appendWhere("_id = " + url.getPathSegments().get(1)); in query()
451 qb.appendWhere("_id = " + getPreferredApnId()); in query()
461 Cursor ret = qb.query(db, projectionIn, selection, selectionArgs, null, null, sort); in query()
/packages/apps/DeskClock/src/com/android/deskclock/
DAlarmProvider.java55 SQLiteQueryBuilder qb = new SQLiteQueryBuilder(); in query() local
61 qb.setTables("alarms"); in query()
64 qb.setTables("alarms"); in query()
65 qb.appendWhere("_id="); in query()
66 qb.appendWhere(url.getPathSegments().get(1)); in query()
73 Cursor ret = qb.query(db, projectionIn, selection, selectionArgs, in query()
/packages/providers/UserDictionaryProvider/src/com/android/providers/userdictionary/
DUserDictionaryProvider.java127 SQLiteQueryBuilder qb = new SQLiteQueryBuilder(); in query() local
131 qb.setTables(USERDICT_TABLE_NAME); in query()
132 qb.setProjectionMap(sDictProjectionMap); in query()
136 qb.setTables(USERDICT_TABLE_NAME); in query()
137 qb.setProjectionMap(sDictProjectionMap); in query()
138 qb.appendWhere("_id" + "=" + uri.getPathSegments().get(1)); in query()
155 Cursor c = qb.query(db, projection, selection, selectionArgs, null, null, orderBy); in query()
/packages/providers/MediaProvider/src/com/android/providers/media/
DMediaProvider.java1954 private boolean queryThumbnail(SQLiteQueryBuilder qb, Uri uri, String table, in queryThumbnail() argument
1956 qb.setTables(table); in queryThumbnail()
1960 qb.appendWhere("_id = " + uri.getPathSegments().get(3)); in queryThumbnail()
2017 qb.appendWhere(column + " = " + origId); in queryThumbnail()
2064 SQLiteQueryBuilder qb = new SQLiteQueryBuilder(); in query()
2085 qb.setDistinct(true); in query()
2092 qb.setTables("images"); in query()
2094 qb.setDistinct(true); in query()
2101 qb.setTables("images"); in query()
2103 qb.setDistinct(true); in query()
[all …]
/packages/providers/DrmProvider/src/com/android/providers/drm/
DDrmProvider.java142 SQLiteQueryBuilder qb = new SQLiteQueryBuilder(); in query() local
146 qb.setTables("audio"); in query()
150 qb.setTables("audio"); in query()
151 qb.appendWhere("_id=" + uri.getPathSegments().get(1)); in query()
155 qb.setTables("images"); in query()
159 qb.setTables("images"); in query()
160 qb.appendWhere("_id=" + uri.getPathSegments().get(1)); in query()
176 Cursor c = qb.query(db, projectionIn, selection, in query()
/packages/apps/Bluetooth/src/com/android/bluetooth/opp/
DBluetoothOppProvider.java307 SQLiteQueryBuilder qb = new SQLiteQueryBuilder(); in query() local
312 qb.setTables(DB_TABLE); in query()
316 qb.setTables(DB_TABLE); in query()
317 qb.appendWhere(BluetoothShare._ID + "="); in query()
318 qb.appendWhere(uri.getPathSegments().get(1)); in query()
322 qb.setTables(DB_TABLE); in query()
323 qb.setProjectionMap(LIVE_FOLDER_PROJECTION_MAP); in query()
324 qb.appendWhere(BluetoothShare.DIRECTION + "=" + BluetoothShare.DIRECTION_INBOUND in query()
377 Cursor ret = qb.query(db, projection, selection, selectionArgs, null, null, sortOrder); in query()
/packages/apps/Browser/src/com/android/browser/provider/
DBrowserProvider2.java881 SQLiteQueryBuilder qb = new SQLiteQueryBuilder(); in query() local
886 qb.setTables(VIEW_ACCOUNTS); in query()
887 qb.setProjectionMap(ACCOUNTS_PROJECTION_MAP); in query()
936 qb.setProjectionMap(BOOKMARKS_PROJECTION_MAP); in query()
937 qb.setTables(TABLE_BOOKMARKS_JOIN_IMAGES); in query()
950 qb.setTables(TABLE_BOOKMARKS_JOIN_IMAGES); in query()
962 qb.setProjectionMap(BOOKMARKS_PROJECTION_MAP); in query()
969 query = qb.buildQuery(projection, where, null, null, sortOrder, null); in query()
971 qb.setProjectionMap(BOOKMARKS_PROJECTION_MAP); in query()
981 String bookmarksBarQuery = qb.buildQuery(projection, in query()
[all …]
DSnapshotProvider.java158 SQLiteQueryBuilder qb = new SQLiteQueryBuilder(); in query() local
167 qb.setTables(TABLE_SNAPSHOTS); in query()
173 Cursor cursor = qb.query(db, projection, selection, selectionArgs, in query()
/packages/providers/ApplicationsProvider/src/com/android/providers/applications/
DApplicationsProvider.java379 SQLiteQueryBuilder qb = new SQLiteQueryBuilder(); in refreshShortcut() local
380 qb.setTables(APPLICATIONS_TABLE); in refreshShortcut()
381 qb.setProjectionMap(sSearchSuggestionsProjectionMap); in refreshShortcut()
382 qb.appendWhere("package = ? AND class = ?"); in refreshShortcut()
384 Cursor cursor = qb.query(mDb, projectionIn, null, selectionArgs, null, null, null); in refreshShortcut()
396 SQLiteQueryBuilder qb = new SQLiteQueryBuilder(); in searchApplications() local
397 qb.setTables(APPLICATIONS_LOOKUP_JOIN); in searchApplications()
398 qb.setProjectionMap(columnMap); in searchApplications()
401 qb.appendWhere(buildTokenFilter(query)); in searchApplications()
404 qb.appendWhere(LAST_RESUME_TIME + " > 0"); in searchApplications()
[all …]
/packages/providers/CalendarProvider/src/com/android/providers/calendar/
DCalendarProvider2.java821 SQLiteQueryBuilder qb = new SQLiteQueryBuilder(); in query() local
841 qb.setTables(CalendarDatabaseHelper.Views.EVENTS); in query()
842 qb.setProjectionMap(sEventsProjectionMap); in query()
848 qb.setTables(CalendarDatabaseHelper.Views.EVENTS); in query()
849 qb.setProjectionMap(sEventsProjectionMap); in query()
851 qb.appendWhere(SQL_WHERE_ID); in query()
855 qb.setTables(CalendarDatabaseHelper.Views.EVENTS); in query()
856 qb.setProjectionMap(sEventEntitiesProjectionMap); in query()
862 qb.setTables(CalendarDatabaseHelper.Views.EVENTS); in query()
863 qb.setProjectionMap(sEventEntitiesProjectionMap); in query()
[all …]
DCalendarInstancesHelper.java563 SQLiteQueryBuilder qb = new SQLiteQueryBuilder(); in getEntries() local
564 qb.setTables(CalendarDatabaseHelper.Views.EVENTS); in getEntries()
565 qb.setProjectionMap(CalendarProvider2.sEventsProjectionMap); in getEntries()
586 qb.appendWhere(SQL_WHERE_GET_EVENTS_ENTRIES); in getEntries()
595 Cursor c = qb.query(mDb, EXPAND_COLUMNS, null /* selection */, selectionArgs, in getEntries()
835 SQLiteQueryBuilder qb = new SQLiteQueryBuilder(); in getRelevantRecurrenceEntries() local
837 qb.setTables(CalendarDatabaseHelper.Views.EVENTS); in getRelevantRecurrenceEntries()
838 qb.setProjectionMap(CalendarProvider2.sEventsProjectionMap); in getRelevantRecurrenceEntries()
842 qb.appendWhere(where); in getRelevantRecurrenceEntries()
850 qb.appendWhere(where); in getRelevantRecurrenceEntries()
[all …]
/packages/apps/CellBroadcastReceiver/src/com/android/cellbroadcastreceiver/
DCellBroadcastContentProvider.java93 SQLiteQueryBuilder qb = new SQLiteQueryBuilder(); in query() local
94 qb.setTables(CellBroadcastDatabaseHelper.TABLE_NAME); in query()
104 qb.appendWhere("(_id=" + uri.getPathSegments().get(0) + ')'); in query()
120 Cursor c = qb.query(db, projection, selection, selectionArgs, null, null, orderBy); 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/apps/Gallery2/tests/src/com/android/gallery3d/data/
DLocalDataTest.java416 SQLiteQueryBuilder qb = new SQLiteQueryBuilder(); in query()
417 qb.setTables(tableName); in query()
423 qb.setDistinct(true); in query()
426 Log.v(TAG, "query = " + qb.buildQuery(projection, selection, in query()
435 Cursor c = qb.query(mDatabase, projection, selection, in query()
/packages/inputmethods/LatinIME/java/src/com/android/inputmethod/latin/
DUserHistoryDictionary.java295 SQLiteQueryBuilder qb = new SQLiteQueryBuilder(); in query() local
298 qb.setTables(MAIN_TABLE_NAME + " INNER JOIN " + FREQ_TABLE_NAME + " ON (" in query()
302 qb.setProjectionMap(sDictProjectionMap); in query()
307 Cursor c = qb.query(db, in query()
/packages/apps/Launcher2/src/com/android/launcher2/
DLauncherProvider.java113 SQLiteQueryBuilder qb = new SQLiteQueryBuilder(); in query() local
114 qb.setTables(args.table); in query()
117 Cursor result = qb.query(db, projection, args.where, args.args, null, null, sortOrder); in query()
/packages/providers/ContactsProvider/src/com/android/providers/contacts/aggregation/
DContactAggregator.java2322 public Cursor queryAggregationSuggestions(SQLiteQueryBuilder qb, in queryAggregationSuggestions() argument
2329 return queryMatchingContacts(qb, db, projection, bestMatches, maxSuggestions, filter); in queryAggregationSuggestions()
2347 private Cursor queryMatchingContacts(SQLiteQueryBuilder qb, SQLiteDatabase db, in queryMatchingContacts() argument
2368 Cursor cursor = db.query(qb.getTables(), ContactIdQuery.COLUMNS, sb.toString(), in queryMatchingContacts()
2409 cursor = qb.query(db, projection, sb.toString(), null, null, null, Contacts._ID); in queryMatchingContacts()

12