/packages/apps/DeskClock/src/com/android/deskclock/provider/ |
D | ClockProvider.java | 60 sAlarmsWithInstancesProjection.put(ALARMS_TABLE_NAME + "." + AlarmsColumns._ID, 61 ALARMS_TABLE_NAME + "." + AlarmsColumns._ID); 81 sAlarmsWithInstancesProjection.put(INSTANCES_TABLE_NAME + "." + InstancesColumns._ID, 82 INSTANCES_TABLE_NAME + "." + InstancesColumns._ID); 101 ALARMS_TABLE_NAME + "." + AlarmsColumns._ID + " = " + InstancesColumns.ALARM_ID + ")"; 104 INSTANCES_TABLE_NAME + "." + InstancesColumns._ID + " IS NULL OR " + 105 INSTANCES_TABLE_NAME + "." + InstancesColumns._ID + " = (" + 106 "SELECT " + InstancesColumns._ID + 109 " = " + ALARMS_TABLE_NAME + "." + AlarmsColumns._ID + 161 qb.appendWhere(AlarmsColumns._ID + "="); in query() [all …]
|
D | ClockProvider.kt | 58 BaseColumns._ID + " = " + InstancesColumns.ALARM_ID + ")" 61 "." + BaseColumns._ID + " IS NULL OR " + 62 INSTANCES_TABLE_NAME + "." + BaseColumns._ID + " = (" + 63 "SELECT " + BaseColumns._ID + 66 " = " + ALARMS_TABLE_NAME + "." + BaseColumns._ID + 79 sAlarmsWithInstancesProjection[ALARMS_TABLE_NAME + "." + BaseColumns._ID] = 80 ALARMS_TABLE_NAME + "." + BaseColumns._ID 101 sAlarmsWithInstancesProjection[INSTANCES_TABLE_NAME + "." + BaseColumns._ID] = 102 INSTANCES_TABLE_NAME + "." + BaseColumns._ID 164 qb.appendWhere(BaseColumns._ID.toString() + "=") in query() [all …]
|
D | ClockDatabaseHelper.kt | 138 val value = values.get(BaseColumns._ID) in fixAlarmInsert() 142 val columns: Array<String> = arrayOf(BaseColumns._ID) in fixAlarmInsert() 143 val selection: String = BaseColumns._ID + " = ?" in fixAlarmInsert() 150 values.putNull(BaseColumns._ID) in fixAlarmInsert() 207 BaseColumns._ID + " INTEGER PRIMARY KEY," + in createAlarmsTable() 221 BaseColumns._ID + " INTEGER PRIMARY KEY," + in createInstanceTable() 232 ALARMS_TABLE_NAME + "(" + BaseColumns._ID + ") " + in createInstanceTable()
|
D | ClockDatabaseHelper.java | 75 ClockContract.AlarmsColumns._ID + " INTEGER PRIMARY KEY," + in createAlarmsTable() 89 ClockContract.InstancesColumns._ID + " INTEGER PRIMARY KEY," + in createInstanceTable() 100 ALARMS_TABLE_NAME + "(" + ClockContract.AlarmsColumns._ID + ") " + in createInstanceTable() 203 final Object value = values.get(ClockContract.AlarmsColumns._ID); in fixAlarmInsert() 207 final String[] columns = {ClockContract.AlarmsColumns._ID}; in fixAlarmInsert() 208 final String selection = ClockContract.AlarmsColumns._ID + " = ?"; in fixAlarmInsert() 214 values.putNull(ClockContract.AlarmsColumns._ID); in fixAlarmInsert()
|
/packages/providers/ContactsProvider/src/com/android/providers/contacts/ |
D | ContactsDatabaseHelper.java | 276 + "(SELECT " + MimetypesColumns._ID 363 String[] ID = new String[] {BaseColumns._ID}; 388 "(SELECT " + AccountsColumns._ID + 401 final String OUTER_RAW_CONTACTS_ID = OUTER_RAW_CONTACTS + "." + RawContacts._ID; 424 + " WHERE " + Tables.CONTACTS +"." + Contacts._ID 425 + "=" + Tables.VISIBLE_CONTACTS +"." + Contacts._ID + ")"; 429 + " WHERE " + Tables.CONTACTS +"." + Contacts._ID 430 + "=" + Tables.DEFAULT_DIRECTORY +"." + Contacts._ID + ")"; 436 public static final String CONCRETE_ID = Tables.CONTACTS + "." + BaseColumns._ID; 459 Tables.RAW_CONTACTS + "." + BaseColumns._ID; [all …]
|
D | LegacyApiSupport.java | 227 String[] COLUMNS = { BaseColumns._ID }; 229 int _ID = 0; field 353 sPeopleProjectionMap.put(People._ID, People._ID); in sPeopleProjectionMap.put() argument 367 " WHERE " + DataColumns.CONCRETE_RAW_CONTACT_ID + "=people." + People._ID + in sPeopleProjectionMap.put() 373 sOrganizationProjectionMap.put(android.provider.Contacts.Organizations._ID, in sOrganizationProjectionMap.put() argument 374 android.provider.Contacts.Organizations._ID); in sOrganizationProjectionMap.put() 389 sContactMethodProjectionMap.put(ContactMethods._ID, ContactMethods._ID); in sContactMethodProjectionMap.put() argument 399 sPhoneProjectionMap.put(android.provider.Contacts.Phones._ID, in sPhoneProjectionMap.put() argument 400 android.provider.Contacts.Phones._ID); in sPhoneProjectionMap.put() 415 sExtensionProjectionMap.put(android.provider.Contacts.Extensions._ID, in sExtensionProjectionMap.put() argument [all …]
|
D | DataRowHandler.java | 56 Data._ID, 63 public static final int _ID = 0; field 71 String[] COLUMNS = { Data._ID, Data.RAW_CONTACT_ID, Data.MIMETYPE }; 73 int _ID = 0; field 159 long dataId = c.getLong(DataUpdateQuery._ID); in update() 168 db.update(Tables.DATA, values, Data._ID + " =?", mSelectionArgs1); in update() 230 HASH_INPUT_COLUMNS, Data._ID + "=?", mSelectionArgs1, null, null, null); in handleHashIdForUpdate() 276 cols, Data._ID + "=?", mSelectionArgs1, null, null, null); in handlePrimaryAndSuperPrimary() 319 long dataId = c.getLong(DataDeleteQuery._ID); in delete() 323 int count = db.delete(Tables.DATA, Data._ID + "=?", mSelectionArgs1); in delete() [all …]
|
D | ContactsProvider2.java | 460 = new String[] {Tables.GROUPS + "." + Groups._ID}; 468 + " FROM " + Tables.RAW_CONTACTS + " WHERE " + RawContacts._ID + "=?"; 517 Contacts._ID + " IN " 525 + "(SELECT " + Tables.GROUPS + "." + Groups._ID 533 " WHERE " + RawContacts._ID + " IN ("; 539 " WHERE " + RawContacts._ID + " IN ("; 546 + " WHERE " + MetadataSync._ID + " IN " 556 " WHERE " + RawContacts._ID + " IN ("; 562 " WHERE " + Contacts._ID + " = ?1 AND " + Contacts.PINNED + " <= " + 603 Data._ID, [all …]
|
/packages/apps/Messaging/src/com/android/messaging/datamodel/ |
D | DatabaseHelper.java | 163 + ConversationColumns._ID + " INTEGER PRIMARY KEY AUTOINCREMENT, " 275 + MessageColumns._ID + " INTEGER PRIMARY KEY AUTOINCREMENT, " 295 + CONVERSATIONS_TABLE + "(" + ConversationColumns._ID + ") ON DELETE CASCADE " 297 + PARTICIPANTS_TABLE + "(" + ParticipantColumns._ID + ") ON DELETE SET NULL " 299 + PARTICIPANTS_TABLE + "(" + ParticipantColumns._ID + ") ON DELETE SET NULL " 347 + PartColumns._ID + " INTEGER PRIMARY KEY AUTOINCREMENT," 359 + MESSAGES_TABLE + "(" + MessageColumns._ID + ") ON DELETE CASCADE " 361 + CONVERSATIONS_TABLE + "(" + ConversationColumns._ID + ") ON DELETE CASCADE " 370 + "." + MessageColumns._ID + "=" + "NEW." + PartColumns.MESSAGE_ID + ")" 371 + " WHERE " + PARTS_TABLE + "." + PartColumns._ID + "=" + "NEW." + PartColumns._ID [all …]
|
D | BugleDatabaseOperations.java | 263 cursor = dbWrapper.rawQuery("SELECT " + ConversationColumns._ID in getExistingConversation() 298 ConversationColumns._ID + " =?", in getThreadId() 324 return isBlockedParticipant(db, participantId, ParticipantColumns._ID); in isBlockedParticipant() 522 ConversationColumns._ID + "=?", new String[] { conversationId }); in deleteConversation() 695 final String selection = ParticipantColumns._ID + "=? AND " + in addConversationSelfIdToContentValues() 700 new String[] { ParticipantColumns._ID }, selection, in addConversationSelfIdToContentValues() 776 ConversationColumns._ID, conversationId, values); in updateConversationRowIfExists() 791 return updateRowIfExists(dbWrapper, DatabaseHelper.MESSAGES_TABLE, MessageColumns._ID, in updateMessageRowIfExists() 807 return updateRowIfExists(dbWrapper, DatabaseHelper.PARTS_TABLE, PartColumns._ID, in updatePartRowIfExists() 880 ConversationColumns._ID + "=?", in getConversationSelfId() [all …]
|
/packages/providers/ContactsProvider/src/com/android/providers/contacts/aggregation/ |
D | AbstractContactAggregator.java | 312 "SELECT COUNT(" + RawContacts._ID + ")" + in AbstractContactAggregator() 315 + " AND " + RawContacts._ID + "<>?"); in AbstractContactAggregator() 324 " WHERE " + RawContacts._ID + "=?" in AbstractContactAggregator() 330 " WHERE " + Contacts._ID + "=?"); in AbstractContactAggregator() 335 " WHERE " + Contacts._ID + "=?"); in AbstractContactAggregator() 340 " WHERE " + Contacts._ID + "=?"); in AbstractContactAggregator() 346 + RawContacts.STARRED + "=1)" + " WHERE " + Contacts._ID + "=?"); in AbstractContactAggregator() 355 + ") THEN 1 ELSE 0 END)" + " WHERE " + Contacts._ID + "=?"); in AbstractContactAggregator() 362 + "WHERE " + Contacts._ID + "=?"); in AbstractContactAggregator() 368 " WHERE " + RawContacts._ID + "=?"); in AbstractContactAggregator() [all …]
|
D | ContactAggregator2.java | 192 final String sql = "SELECT " + RawContacts._ID + " FROM " + Tables.RAW_CONTACTS + in needAggregate() 194 " AND " + RawContacts._ID + "=?"; in needAggregate() 734 RawContacts._ID, 900 String selection = RawContacts._ID + " =" + rawContactId; in rawContactWithoutName() 922 mSb.append(RawContacts._ID).append(" IN ("); in updateScoreForCandidatesWithoutName() 955 + Tables.RAW_CONTACTS + "." + RawContacts._ID + ")"; 981 + Tables.RAW_CONTACTS + "." + RawContacts._ID + ")"; 987 RawContacts._ID, 1009 + Tables.RAW_CONTACTS + "." + RawContacts._ID + ")"; 1018 Tables.RAW_CONTACTS + "." + RawContacts._ID, [all …]
|
/packages/providers/CalendarProvider/src/com/android/providers/calendar/ |
D | CalendarDatabaseHelper.java | 168 "old." + CalendarContract.Events._ID + ";" + 171 "old." + CalendarContract.Events._ID + ";" + 174 "old." + CalendarContract.Events._ID + ";" + 177 "old." + CalendarContract.Events._ID + ";" + 180 "old." + CalendarContract.Events._ID + ";" + 183 "old." + CalendarContract.Events._ID + ";"; 190 " WHERE " + Events.ORIGINAL_ID + "=old." + Events._ID + ";"; 202 "old." + CalendarContract.Events._ID + ";"; 210 + " WHERE " + Calendars._ID + "=" + "old." + Calendars._ID 221 + Tables.CALENDARS + " WHERE " + Calendars._ID + "=new." + Events.CALENDAR_ID [all …]
|
/packages/apps/UniversalMediaPlayer/java/com/android/pump/db/ |
D | AudioStore.java | 85 MediaStore.Audio.Artists._ID in load() 87 String sortOrder = MediaStore.Audio.Artists._ID; in load() 91 int idColumn = cursor.getColumnIndexOrThrow(MediaStore.Audio.Artists._ID); in load() 109 MediaStore.Audio.Albums._ID, in load() 112 String sortOrder = MediaStore.Audio.Albums._ID; in load() 116 int idColumn = cursor.getColumnIndexOrThrow(MediaStore.Audio.Albums._ID); in load() 143 MediaStore.Audio.Media._ID, in load() 149 String sortOrder = MediaStore.Audio.Media._ID; in load() 153 int idColumn = cursor.getColumnIndexOrThrow(MediaStore.Audio.Media._ID); in load() 190 MediaStore.Audio.Playlists._ID in load() [all …]
|
/packages/providers/ContactsProvider/tests/src/com/android/providers/contacts/ |
D | ContactsProvider2Test.java | 207 Contacts._ID, in testContactsProjection() 248 Contacts._ID, in testContactsStrequentProjection() 293 Contacts._ID, in testContactsStrequentPhoneOnlyProjection() 342 Contacts._ID, in testContactsWithSnippetProjection() 384 RawContacts._ID, in testRawContactsProjection() 424 Data._ID, in testDataProjection() 473 Contacts._ID, in testDataProjection() 515 Data._ID, in testDistinctDataProjection() 555 Contacts._ID, in testDistinctDataProjection() 598 Contacts.Entity._ID, in testEntityProjection() [all …]
|
D | ContactsDatabaseHelperUpgradeTest.java | 157 cv(Contacts._ID, 1, in upgradeTo1201() 224 new TableColumn(AccountsColumns._ID, INTEGER, false, null), 231 new TableColumn(BaseColumns._ID, INTEGER, false, null), 256 new TableColumn(RawContacts._ID, INTEGER, false, null), 298 new TableColumn(StreamItems._ID, INTEGER, false, null), 313 new TableColumn(StreamItemPhotos._ID, INTEGER, false, null), 324 new TableColumn(PhotoFiles._ID, INTEGER, false, null), 331 new TableColumn(PackagesColumns._ID, INTEGER, false, null), 336 new TableColumn(MimetypesColumns._ID, INTEGER, false, null), 341 new TableColumn(Data._ID, INTEGER, false, null), [all …]
|
D | ContactLookupKeyTest.java | 60 assertStoredValue(lookupUri, Contacts._ID, contactId); in testLookupKeyUsingDisplayNameAndNoAccount() 64 Contacts._ID, contactId); in testLookupKeyUsingDisplayNameAndNoAccount() 68 Contacts._ID, contactId); in testLookupKeyUsingDisplayNameAndNoAccount() 94 assertStoredValue(lookupUri, Contacts._ID, contactId); in testLookupKeyUsingSourceIdAndNoAccount() 122 assertStoredValue(lookupUri1, Contacts._ID, contactId1); in testLookupKeySameSourceIdDifferentAccounts() 125 assertStoredValue(lookupUri2, Contacts._ID, contactId2); in testLookupKeySameSourceIdDifferentAccounts() 165 assertStoredValue(lookupUri, Contacts._ID, largerContactId); in testLookupKeyChoosingLargestContact()
|
/packages/apps/TV/tests/common/src/com/android/tv/testing/fakes/ |
D | FakeTvProvider.java | 112 + Channels._ID 180 sChannelProjectionMap.put(Channels._ID, CHANNELS_TABLE + "." + Channels._ID); in sChannelProjectionMap.put() argument 255 sProgramProjectionMap.put(Programs._ID, Programs._ID); in sProgramProjectionMap.put() argument 308 sWatchedProgramProjectionMap.put(WatchedPrograms._ID, WatchedPrograms._ID); in sWatchedProgramProjectionMap.put() argument 337 sRecordedProgramProjectionMap.put(RecordedPrograms._ID, RecordedPrograms._ID); in sRecordedProgramProjectionMap.put() argument 421 sPreviewProgramProjectionMap.put(PreviewPrograms._ID, PreviewPrograms._ID); in sPreviewProgramProjectionMap.put() argument 528 sWatchNextProgramProjectionMap.put(WatchNextPrograms._ID, WatchNextPrograms._ID); in sWatchNextProgramProjectionMap.put() argument 658 + RecordedPrograms._ID 732 + Channels._ID 740 + PreviewPrograms._ID [all …]
|
/packages/apps/Bluetooth/lib/mapapi/com/android/bluetooth/mapapi/ |
D | BluetoothMapContract.java | 392 String _ID = "_id"; field 474 String _ID = "_id"; field 544 String _ID = "_id"; field 749 String _ID = "_id"; field 1083 MessageColumns._ID, 1106 MessageColumns._ID, 1129 AccountColumns._ID, AccountColumns.ACCOUNT_DISPLAY_NAME, AccountColumns.FLAG_EXPOSE, 1137 AccountColumns._ID, 1148 FolderColumns._ID,
|
/packages/providers/MediaProvider/src/com/android/providers/media/ |
D | MediaDocumentsProvider.java | 477 BaseColumns._ID + "=?", in getDocumentMetadataFromIndex() 578 ImageQuery.PROJECTION, BaseColumns._ID + "=?", queryArgs, in queryDocument() 599 VideoQuery.PROJECTION, BaseColumns._ID + "=?", queryArgs, in queryDocument() 611 ArtistQuery.PROJECTION, BaseColumns._ID + "=?", queryArgs, in queryDocument() 620 AlbumQuery.PROJECTION, BaseColumns._ID + "=?", queryArgs, in queryDocument() 629 SongQuery.PROJECTION, BaseColumns._ID + "=?", queryArgs, in queryDocument() 938 BaseColumns._ID }, null, null, null); in isEmpty() 1049 ImageColumns._ID, 1055 final int _ID = 0; field 1063 final long id = cursor.getLong(ImageQuery._ID); in includeImage() [all …]
|
/packages/providers/TvProvider/src/com/android/providers/tv/ |
D | TvProvider.java | 119 + " ON (" + CHANNELS_TABLE + "." + Channels._ID + "=" 180 sChannelProjectionMap.put(Channels._ID, CHANNELS_TABLE + "." + Channels._ID); in initProjectionMaps() 242 sProgramProjectionMap.put(Programs._ID, Programs._ID); in initProjectionMaps() 302 sWatchedProgramProjectionMap.put(WatchedPrograms._ID, WatchedPrograms._ID); in initProjectionMaps() 326 sRecordedProgramProjectionMap.put(RecordedPrograms._ID, RecordedPrograms._ID); in initProjectionMaps() 399 sPreviewProgramProjectionMap.put(PreviewPrograms._ID, PreviewPrograms._ID); in initProjectionMaps() 497 sWatchNextProgramProjectionMap.put(WatchNextPrograms._ID, WatchNextPrograms._ID); in initProjectionMaps() 610 + RecordedPrograms._ID + " INTEGER PRIMARY KEY AUTOINCREMENT," 647 + "REFERENCES " + CHANNELS_TABLE + "(" + Channels._ID + ") " 652 + PreviewPrograms._ID + " INTEGER PRIMARY KEY AUTOINCREMENT," [all …]
|
/packages/apps/Messaging/tests/src/com/android/messaging/datamodel/data/ |
D | TestDataFactory.java | 48 ConversationListViewColumns._ID, 67 Phone._ID, 72 Contacts._ID, 79 ConversationMessageViewColumns._ID, 97 Media._ID, 158 ConversationMessageViewColumns._ID, row).toString(); in getMessageText() 184 ParticipantColumns._ID, in getConversationParticipantsCursor() 269 final String[] ID_PROJECTION = { BaseColumns._ID }; in getSmsMmsThreadIdCursor()
|
/packages/providers/ContactsProvider/src/com/android/providers/contacts/database/ |
D | ContactsTableUtil.java | 62 db.update(Tables.CONTACTS, values, Contacts._ID + " = ?", in updateContactLastUpdateByContactId() 96 + " WHERE " + Contacts._ID + " IN ( " in buildUpdateLastUpdateSql() 99 + " WHERE " + ContactsContract.RawContacts._ID in buildUpdateLastUpdateSql() 114 return db.delete(Tables.CONTACTS, Contacts._ID + " = ?", new String[]{contactId + ""}); in deleteContact() 129 + " where " + ContactsContract.RawContacts._ID + " = ?)" in deleteContactIfSingleton()
|
/packages/apps/Messaging/src/com/android/messaging/datamodel/data/ |
D | ConversationListItemData.java | 293 DatabaseHelper.CONVERSATIONS_TABLE + '.' + ConversationColumns._ID 294 + " as " + ConversationListViewColumns._ID + ", " 344 + DatabaseHelper.MESSAGES_TABLE + '.' + MessageColumns._ID 356 + '=' + DatabaseHelper.PARTICIPANTS_TABLE + '.' + DatabaseHelper.ParticipantColumns._ID 371 + '=' + DatabaseHelper.MESSAGES_TABLE + '.' + MessageColumns._ID + ") " 377 public static final String _ID = ConversationColumns._ID; field in ConversationListItemData.ConversationListViewColumns 414 ConversationListViewColumns._ID, 506 ConversationColumns._ID + "=?", in getExistingConversation()
|
/packages/providers/DownloadProvider/src/com/android/providers/downloads/ |
D | DownloadIdleService.java | 101 Downloads.Impl._ID, 106 final int _ID = 0; field 127 final long id = cursor.getLong(StaleQuery._ID); in cleanStale() 141 Downloads.Impl._ID, 144 final int _ID = 0; field 175 final long id = cursor.getLong(OrphanQuery._ID); in cleanOrphans()
|