Lines Matching defs:qb
5814 SQLiteQueryBuilder qb = new SQLiteQueryBuilder();
5831 setTablesAndProjectionMapForContacts(qb, projection);
5832 appendLocalDirectoryAndAccountSelectionIfNeeded(qb, directoryId, uri);
5838 setTablesAndProjectionMapForContacts(qb, projection);
5840 qb.appendWhere(Contacts._ID + "=?");
5868 setTablesAndProjectionMapForContacts(qb, projection);
5871 qb.appendWhere(Contacts._ID + "=?");
5905 setTablesAndProjectionMapForData(qb, uri, projection, false);
5910 qb.appendWhere(" AND " + Data._ID + "=" + Contacts.PHOTO_ID);
5912 qb.appendWhere(" AND " + Data.CONTACT_ID + "=?");
5918 setTablesAndProjectionMapForStreamItems(qb);
5920 qb.appendWhere(StreamItems.CONTACT_ID + "=?");
5947 setTablesAndProjectionMapForStreamItems(qb);
5950 qb.appendWhere(RawContacts.CONTACT_ID + "=?");
5957 qb.setTables(Views.CONTACTS);
5958 qb.setProjectionMap(sContactsVCardProjectionMap);
5961 qb.appendWhere(Contacts._ID + "=?");
5987 qb, uri, projection, filterParam, directoryId,
6046 qb.setTables(tableBuilder.toString());
6047 qb.setProjectionMap(sStrequentPhoneOnlyProjectionMap);
6053 qb.appendWhere(DbQueryUtils.concatenateClauses(
6059 starredInnerQuery = qb.buildQuery(subProjection, null, null,
6062 qb = new SQLiteQueryBuilder();
6063 qb.setStrict(true);
6080 qb.setTables(tableBuilder.toString());
6081 qb.setProjectionMap(sStrequentPhoneOnlyProjectionMap);
6082 qb.appendWhere(DbQueryUtils.concatenateClauses(
6088 frequentInnerQuery = qb.buildQuery(subProjection, null, null, null,
6093 qb.setStrict(true);
6094 setTablesAndProjectionMapForContacts(qb, projection, false);
6095 qb.setProjectionMap(sStrequentStarredProjectionMap);
6097 starredInnerQuery = qb.buildQuery(subProjection,
6103 qb = new SQLiteQueryBuilder();
6104 qb.setStrict(true);
6106 setTablesAndProjectionMapForContacts(qb, projection, true);
6107 qb.setProjectionMap(sStrequentFrequentProjectionMap);
6108 qb.appendWhere(DbQueryUtils.concatenateClauses(
6115 frequentInnerQuery = qb.buildQuery(subProjection,
6129 qb.buildUnionQuery(new String[] {starredQuery, frequentQuery}, null, null);
6156 setTablesAndProjectionMapForContacts(qb, projection, true);
6157 qb.setProjectionMap(sStrequentFrequentProjectionMap);
6169 setTablesAndProjectionMapForContacts(qb, projection);
6171 qb.appendWhere(CONTACTS_IN_GROUP_SELECT);
6181 setTablesAndProjectionMapForContacts(qb, projection);
6186 setTablesAndProjectionMapForEntities(qb, uri, projection);
6191 qb.setTables(Views.CONTACTS);
6192 qb.setProjectionMap(sContactsVCardProjectionMap);
6198 setTablesAndProjectionMapForData(qb, uri, projection, false);
6200 qb.appendWhere(" AND " + RawContacts.CONTACT_ID + "=?");
6206 setTablesAndProjectionMapForData(qb, uri, projection, false);
6208 qb.appendWhere(" AND " + RawContacts.CONTACT_ID + "=?");
6209 qb.appendWhere(" AND " + Data._ID + "=" + Contacts.PHOTO_ID);
6215 setTablesAndProjectionMapForEntities(qb, uri, projection);
6217 qb.appendWhere(" AND " + RawContacts.CONTACT_ID + "=?");
6246 setTablesAndProjectionMapForEntities(qb, uri, projection);
6249 qb.appendWhere(" AND " + Contacts.Entity.CONTACT_ID + "=?");
6254 setTablesAndProjectionMapForStreamItems(qb);
6259 setTablesAndProjectionMapForStreamItems(qb);
6261 qb.appendWhere(StreamItems._ID + "=?");
6271 setTablesAndProjectionMapForStreamItemPhotos(qb);
6276 setTablesAndProjectionMapForStreamItemPhotos(qb);
6279 qb.appendWhere(StreamItemPhotosColumns.CONCRETE_STREAM_ITEM_ID + "=?");
6284 setTablesAndProjectionMapForStreamItemPhotos(qb);
6289 qb.appendWhere(StreamItemPhotosColumns.CONCRETE_STREAM_ITEM_ID + "=? AND " +
6311 setTablesAndProjectionMapForData(qb, uri, projection, false);
6313 qb.appendWhere(" AND ((" + mimeTypeIsPhoneExpression +
6316 qb.appendWhere(" AND " + mimeTypeIsPhoneExpression);
6343 setTablesAndProjectionMapForData(qb, uri, projection, false);
6346 qb.appendWhere(" AND ((" + mimeTypeIsPhoneExpression +
6349 qb.appendWhere(" AND " + mimeTypeIsPhoneExpression);
6351 qb.appendWhere(" AND " + Data._ID + "=?");
6365 setTablesAndProjectionMapForData(qb, uri, projection, true, typeInt);
6367 qb.appendWhere(" AND ((" + mimeTypeIsPhoneExpression +
6370 qb.appendWhere(" AND " + mimeTypeIsPhoneExpression);
6442 qb.appendWhere(sb);
6492 setTablesAndProjectionMapForData(qb, uri, projection, false);
6493 qb.appendWhere(" AND " + DataColumns.MIMETYPE_ID + " = "
6509 setTablesAndProjectionMapForData(qb, uri, projection, false);
6511 qb.appendWhere(" AND " + DataColumns.MIMETYPE_ID + " = "
6518 setTablesAndProjectionMapForData(qb, uri, projection, false);
6519 qb.appendWhere(" AND " + DataColumns.MIMETYPE_ID + " = "
6525 qb.appendWhere(" AND UPPER(" + Email.DATA + ")=UPPER(?)");
6543 setTablesAndProjectionMapForData(qb, uri, projection, true, typeInt);
6555 qb.appendWhere(" AND 0");
6585 qb.appendWhere(sb);
6626 setTablesAndProjectionMapForData(qb, uri, projection, false);
6640 qb.appendWhere(" AND 0");
6645 qb.appendWhere(" AND " + Data.CONTACT_ID + " in " +
6661 qb.appendWhere(sb);
6721 qb.appendWhere(sb);
6727 setTablesAndProjectionMapForData(qb, uri, projection, false);
6728 qb.appendWhere(" AND " + DataColumns.MIMETYPE_ID + " = "
6744 setTablesAndProjectionMapForData(qb, uri, projection, false);
6746 qb.appendWhere(" AND " + DataColumns.MIMETYPE_ID + " = "
6748 qb.appendWhere(" AND " + Data._ID + "=?");
6754 setTablesAndProjectionMapForRawContacts(qb, uri);
6761 setTablesAndProjectionMapForRawContacts(qb, uri);
6763 qb.appendWhere(" AND " + RawContacts._ID + "=?");
6771 setTablesAndProjectionMapForData(qb, uri, projection, false);
6773 qb.appendWhere(" AND " + Data.RAW_CONTACT_ID + "=?");
6779 setTablesAndProjectionMapForStreamItems(qb);
6781 qb.appendWhere(StreamItems.RAW_CONTACT_ID + "=?");
6788 setTablesAndProjectionMapForStreamItems(qb);
6791 qb.appendWhere(StreamItems.RAW_CONTACT_ID + "=? AND " +
6799 setTablesAndProjectionMapForRawEntities(qb, uri);
6800 qb.appendWhere(" AND " + RawContacts._ID + "=?");
6808 setTablesAndProjectionMapForData(qb, uri, projection, false, typeInt);
6810 qb.appendWhere(" AND " + Data.CONTACT_ID + " in " +
6818 setTablesAndProjectionMapForData(qb, uri, projection, false);
6820 qb.appendWhere(" AND " + Data._ID + "=?");
6825 setTablesAndProjectionMapForData(qb, uri, projection, false);
6826 qb.appendWhere(" AND " + Data._ID + "=" + Contacts.PHOTO_ID);
6850 setTablesAndProjectionMapForData(qb, uri, null, false, true);
6867 qb, normalizedNumber, numberE164);
6868 qb.setProjectionMap(sPhoneLookupProjectionMap);
6884 qb.setStrict(true);
6886 Cursor cursor = doQuery(db, qb, projectionWithNumber, selection, selectionArgs,
6896 qb = new SQLiteQueryBuilder();
6897 qb.setProjectionMap(sPhoneLookupProjectionMap);
6898 qb.setStrict(true);
6903 mDbHelper.get().buildFallbackPhoneLookupAndContactQuery(qb, number);
6905 final Cursor fallbackCursor = doQuery(db, qb, projectionWithNumber,
6921 qb.setTables(Views.GROUPS);
6922 qb.setProjectionMap(sGroupsProjectionMap);
6923 appendAccountIdFromParameter(qb, uri);
6928 qb.setTables(Views.GROUPS);
6929 qb.setProjectionMap(sGroupsProjectionMap);
6931 qb.appendWhere(Groups._ID + "=?");
6946 qb.setTables(tables);
6947 qb.setProjectionMap(sGroupsSummaryProjectionMap);
6948 appendAccountIdFromParameter(qb, uri);
6954 qb.setTables(Tables.AGGREGATION_EXCEPTIONS);
6955 qb.setProjectionMap(sAggregationExceptionsProjectionMap);
6988 setTablesAndProjectionMapForContacts(qb, projection);
6990 return mAggregator.get().queryAggregationSuggestions(qb, projection, contactId,
6995 qb.setTables(Tables.SETTINGS);
6996 qb.setProjectionMap(sSettingsProjectionMap);
6997 appendAccountFromParameter(qb, uri);
7019 setTableAndProjectionMapForStatusUpdates(qb, projection);
7024 setTableAndProjectionMapForStatusUpdates(qb, projection);
7026 qb.appendWhere(DataColumns.CONCRETE_ID + "=?");
7045 setTablesAndProjectionMapForRawEntities(qb, uri);
7059 setTablesAndProjectionMapForRawEntities(qb, uri);
7061 qb.appendWhere(" AND " + RawContacts._ID + "=?");
7082 qb.setTables(Tables.DIRECTORIES);
7083 qb.setProjectionMap(sDirectoryProjectionMap);
7089 qb.setTables(Tables.DIRECTORIES);
7090 qb.setProjectionMap(sDirectoryProjectionMap);
7092 qb.appendWhere(Directory._ID + "=?");
7124 qb.setTables(Tables.DELETED_CONTACTS);
7125 qb.setProjectionMap(sDeletedContactsProjectionMap);
7131 qb.setTables(Tables.DELETED_CONTACTS);
7132 qb.setProjectionMap(sDeletedContactsProjectionMap);
7133 qb.appendWhere(DeletedContacts.CONTACT_ID + "=?");
7143 qb.setStrict(true);
7148 doQuery(db, qb, projection, selection, selectionArgs, localizedSortOrder, groupBy,
7152 bundleFastScrollingIndexExtras(cursor, uri, db, qb, selection,
7190 private Cursor doQuery(final SQLiteDatabase db, SQLiteQueryBuilder qb, String[] projection,
7195 qb.setProjectionMap(sCountProjectionMap);
7197 final Cursor c = qb.query(db, projection, selection, selectionArgs, groupBy, having,
7608 final SQLiteDatabase db, SQLiteQueryBuilder qb, String selection,
7643 b = getFastScrollingIndexExtras(db, qb, selection, selectionArgs,
7684 final SQLiteQueryBuilder qb, final String selection, final String[] selectionArgs,
7732 qb.setProjectionMap(projectionMap);
7737 Cursor indexCursor = qb.query(db, AddressBookIndexQuery.COLUMNS, selection, selectionArgs,
8022 private void setTablesAndProjectionMapForContacts(SQLiteQueryBuilder qb, String[] projection) {
8023 setTablesAndProjectionMapForContacts(qb, projection, false);
8032 SQLiteQueryBuilder qb, String[] projection, boolean includeDataUsageStat) {
8052 qb.setTables(sb.toString());
8053 qb.setProjectionMap(sContactsProjectionMap);
8060 private void setTablesAndProjectionMapForContactsWithSnippet(SQLiteQueryBuilder qb, Uri uri,
8077 qb.setTables(sb.toString());
8078 qb.setProjectionMap(sContactsProjectionWithSnippetMap);
8282 private void setTablesAndProjectionMapForRawContacts(SQLiteQueryBuilder qb, Uri uri) {
8285 qb.setTables(sb.toString());
8286 qb.setProjectionMap(sRawContactsProjectionMap);
8287 appendAccountIdFromParameter(qb, uri);
8290 private void setTablesAndProjectionMapForRawEntities(SQLiteQueryBuilder qb, Uri uri) {
8291 qb.setTables(Views.RAW_ENTITIES);
8292 qb.setProjectionMap(sRawEntityProjectionMap);
8293 appendAccountIdFromParameter(qb, uri);
8297 SQLiteQueryBuilder qb, Uri uri, String[] projection, boolean distinct) {
8299 setTablesAndProjectionMapForData(qb, uri, projection, distinct, false, null);
8302 private void setTablesAndProjectionMapForData(SQLiteQueryBuilder qb, Uri uri,
8304 setTablesAndProjectionMapForData(qb, uri, projection, distinct, addSipLookupColumns, null);
8311 private void setTablesAndProjectionMapForData(SQLiteQueryBuilder qb, Uri uri,
8313 setTablesAndProjectionMapForData(qb, uri, projection, distinct, false, usageType);
8316 private void setTablesAndProjectionMapForData(SQLiteQueryBuilder qb, Uri uri,
8330 qb.setTables(sb.toString());
8334 qb.setDistinct(useDistinct);
8344 qb.setProjectionMap(projectionMap);
8345 appendAccountIdFromParameter(qb, uri);
8349 SQLiteQueryBuilder qb, String[] projection) {
8357 qb.setTables(sb.toString());
8358 qb.setProjectionMap(sStatusUpdatesProjectionMap);
8361 private void setTablesAndProjectionMapForStreamItems(SQLiteQueryBuilder qb) {
8362 qb.setTables(Views.STREAM_ITEMS);
8363 qb.setProjectionMap(sStreamItemsProjectionMap);
8366 private void setTablesAndProjectionMapForStreamItemPhotos(SQLiteQueryBuilder qb) {
8367 qb.setTables(Tables.PHOTO_FILES
8377 qb.setProjectionMap(sStreamItemPhotosProjectionMap);
8381 SQLiteQueryBuilder qb, Uri uri, String[] projection) {
8394 qb.setTables(sb.toString());
8395 qb.setProjectionMap(sEntityProjectionMap);
8396 appendAccountIdFromParameter(qb, uri);
8488 SQLiteQueryBuilder qb, long directoryId, Uri uri) {
8517 qb.appendWhere(sb.toString());
8520 private void appendAccountFromParameter(SQLiteQueryBuilder qb, Uri uri) {
8538 qb.appendWhere(toAppend);
8540 qb.appendWhere("1");
8544 private void appendAccountIdFromParameter(SQLiteQueryBuilder qb, Uri uri) {
8554 qb.appendWhere("(1=2)");
8556 qb.appendWhere(
8560 qb.appendWhere("1");
8814 SQLiteQueryBuilder qb = new SQLiteQueryBuilder();
8815 setTablesAndProjectionMapForContacts(qb, projection);
8817 Cursor c = qb.query(db, projection, Contacts._ID + "=?",
8839 SQLiteQueryBuilder qb = new SQLiteQueryBuilder();
8841 setTablesAndProjectionMapForData(qb, uri, projection, false);
8843 Cursor c = qb.query(db, projection,