| /packages/providers/ContactsProvider/src/com/android/providers/contacts/ |
| D | ContactsDatabaseHelper.java | 231 + "(SELECT " + MimetypesColumns._ID
311 "(SELECT " + AccountsColumns._ID +
324 final String OUTER_RAW_CONTACTS_ID = OUTER_RAW_CONTACTS + "." + RawContacts._ID;
347 + " WHERE " + Tables.CONTACTS +"." + Contacts._ID
348 + "=" + Tables.VISIBLE_CONTACTS +"." + Contacts._ID + ")";
354 public static final String CONCRETE_ID = Tables.CONTACTS + "." + BaseColumns._ID;
379 Tables.RAW_CONTACTS + "." + BaseColumns._ID;
440 public static final String CONCRETE_ID = Tables.DATA + "." + BaseColumns._ID;
481 public static final String CONCRETE_ID = Tables.GROUPS + "." + BaseColumns._ID;
500 public static final String _ID = BaseColumns._ID; field
[all …]
|
| D | LegacyApiSupport.java | 200 "WHERE " + Contacts._ID + "=?";
204 + RawContacts._ID + "=?";
249 String[] COLUMNS = { BaseColumns._ID };
251 int _ID = 0; field
384 sPeopleProjectionMap.put(People._ID, People._ID); in sPeopleProjectionMap.put() argument
398 " WHERE " + DataColumns.CONCRETE_RAW_CONTACT_ID + "=people." + People._ID + in sPeopleProjectionMap.put()
404 sOrganizationProjectionMap.put(android.provider.Contacts.Organizations._ID, in sOrganizationProjectionMap.put() argument
405 android.provider.Contacts.Organizations._ID); in sOrganizationProjectionMap.put()
420 sContactMethodProjectionMap.put(ContactMethods._ID, ContactMethods._ID); in sContactMethodProjectionMap.put() argument
430 sPhoneProjectionMap.put(android.provider.Contacts.Phones._ID, in sPhoneProjectionMap.put() argument
[all …]
|
| D | ContactsProvider2.java | 251 " WHERE " + Contacts._ID + "=?";
420 = new String[]{Tables.GROUPS + "." + Groups._ID};
428 + " FROM " + Tables.RAW_CONTACTS + " WHERE " + RawContacts._ID + "=?";
477 Contacts._ID + " IN "
485 + "(SELECT " + Tables.GROUPS + "." + Groups._ID
493 " WHERE " + RawContacts._ID + " IN (";
499 " WHERE " + RawContacts._ID + " IN (";
550 Data._ID,
696 .add(Contacts._ID)
760 .add(Contacts._ID)
[all …]
|
| D | DataRowHandler.java | 53 Data._ID,
60 public static final int _ID = 0; field
68 String[] COLUMNS = { Data._ID, Data.RAW_CONTACT_ID, Data.MIMETYPE };
70 int _ID = 0; field
151 long dataId = c.getLong(DataUpdateQuery._ID); in update()
158 db.update(Tables.DATA, values, Data._ID + " =?", mSelectionArgs1); in update()
206 cols, Data._ID + "=?", mSelectionArgs1, null, null, null); in handlePrimaryAndSuperPrimary()
249 long dataId = c.getLong(DataDeleteQuery._ID); in delete()
253 int count = db.delete(Tables.DATA, Data._ID + "=?", mSelectionArgs1); in delete()
279 long dataId = c.getLong(DataDeleteQuery._ID); in fixPrimary()
[all …]
|
| /packages/providers/CalendarProvider/src/com/android/providers/calendar/ |
| D | CalendarDatabaseHelper.java | 167 "old." + CalendarContract.Events._ID + ";" +
170 "old." + CalendarContract.Events._ID + ";" +
173 "old." + CalendarContract.Events._ID + ";" +
176 "old." + CalendarContract.Events._ID + ";" +
179 "old." + CalendarContract.Events._ID + ";" +
182 "old." + CalendarContract.Events._ID + ";";
189 " WHERE " + Events.ORIGINAL_ID + "=old." + Events._ID + ";";
201 "old." + CalendarContract.Events._ID + ";";
209 + " WHERE " + Calendars._ID + "=" + "old." + Calendars._ID
220 + Tables.CALENDARS + " WHERE " + Calendars._ID + "=new." + Events.CALENDAR_ID
[all …]
|
| D | CalendarProvider2.java | 102 new String[] {Events._ID};
145 private static final String GENERIC_ID = Attendees._ID;
159 Events._ID,
199 CalendarContract.EventsRawTimes.EVENT_ID + " = " + Tables.EVENTS + "." + Events._ID;
205 " WHERE " + Events._ID + "=?";
209 " WHERE " + Events._ID + "=?";
225 Tables.EVENTS + "." + Events._ID + "=" + Tables.ATTENDEES + "." + Attendees.EVENT_ID
227 Tables.EVENTS + "." + Events.CALENDAR_ID + "=" + Tables.CALENDARS + "." + Calendars._ID;
230 Tables.ATTENDEES + "." + Attendees._ID + "=? AND " + SQL_WHERE_ATTENDEE_BASE;
233 Tables.REMINDERS + "." + Reminders._ID + "=? AND " +
[all …]
|
| D | CalendarInstancesHelper.java | 81 Instances._ID + " IN " +
82 "(SELECT " + Tables.INSTANCES + "." + Instances._ID + " as _id" +
86 Tables.EVENTS + "." + Events._ID + "=" + Tables.INSTANCES + "." + Instances.EVENT_ID +
88 " WHERE " + Tables.EVENTS + "." + Events._ID + "=? OR " +
97 Instances._ID + " IN " +
98 "(SELECT " + Tables.INSTANCES + "." + Instances._ID + " as _id" +
102 Tables.EVENTS + "." + Events._ID + "=" + Tables.INSTANCES + "." + Instances.EVENT_ID +
108 Events._ID,
148 " WHERE " + Events._ID + "=?"; in getEventValue()
180 int idColumn = entries.getColumnIndex(Events._ID); in performInstanceExpansion()
|
| /packages/providers/ContactsProvider/src/com/android/providers/contacts/aggregation/ |
| D | ContactAggregator.java | 300 "SELECT COUNT(" + RawContacts._ID + ")" + in ContactAggregator()
303 + " AND " + RawContacts._ID + "<>?"); in ContactAggregator()
312 " WHERE " + RawContacts._ID + "=?" in ContactAggregator()
318 " WHERE " + Contacts._ID + "=?"); in ContactAggregator()
323 " WHERE " + Contacts._ID + "=?"); in ContactAggregator()
328 " WHERE " + Contacts._ID + "=?"); in ContactAggregator()
334 + RawContacts.STARRED + "=1)" + " WHERE " + Contacts._ID + "=?"); in ContactAggregator()
340 " WHERE " + RawContacts._ID + "=?"); in ContactAggregator()
345 " WHERE " + RawContacts._ID + "=?"); in ContactAggregator()
350 " WHERE " + RawContacts._ID + "=?"); in ContactAggregator()
[all …]
|
| /packages/apps/Browser/src/com/android/browser/provider/ |
| D | BrowserProvider2.java | 81 public static final String _ID = "_id"; field
88 public static final String _ID = "_id"; field
126 qualifyColumn(TABLE_HISTORY, History._ID),
253 map.put(Bookmarks._ID, qualifyColumn(TABLE_BOOKMARKS, Bookmarks._ID)); in map.put() argument
278 "A." + Bookmarks._ID + "=" + TABLE_BOOKMARKS + "." + Bookmarks.PARENT + in map.put()
282 "A." + Bookmarks._ID + "=" + TABLE_BOOKMARKS + "." + Bookmarks.INSERT_AFTER + in map.put()
303 map.put(History._ID, qualifyColumn(TABLE_HISTORY, History._ID)); in map.put() argument
316 map.put(SyncState._ID, SyncState._ID); in map.put() argument
330 map.put(Combined._ID, bookmarkOrHistoryColumn(Combined._ID)); in map.put() argument
336 TABLE_BOOKMARKS + "." + Bookmarks._ID + in map.put()
[all …]
|
| /packages/providers/ContactsProvider/tests/src/com/android/providers/contacts/ |
| D | ContactsProvider2Test.java | 117 Contacts._ID, in testContactsProjection()
156 Contacts._ID, in testContactsStrequentProjection()
199 Contacts._ID, in testContactsStrequentPhoneOnlyProjection()
244 Contacts._ID, in testContactsWithSnippetProjection()
284 RawContacts._ID, in testRawContactsProjection()
322 Data._ID, in testDataProjection()
367 Contacts._ID, in testDataProjection()
407 Data._ID, in testDistinctDataProjection()
443 Contacts._ID, in testDistinctDataProjection()
484 Contacts.Entity._ID, in testEntityProjection()
[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()
|
| D | PhotoStoreTest.java | 144 PhotoFiles._ID + "=?", new String[]{String.valueOf(photoFileId)}, null, null, null); in runStorageTestForResource()
165 PhotoFiles._ID + "=?", new String[]{String.valueOf(photoFileId)}, null, null, null); in runStorageTestForResourceWithCrop()
187 Cursor c = mDb.query(Tables.PHOTO_FILES, new String[]{PhotoFiles._ID}, in testRemoveEntry()
188 PhotoFiles._ID + "=?", new String[]{String.valueOf(photoFileId)}, null, null, null); in testRemoveEntry()
233 Cursor c = mDb.query(Tables.PHOTO_FILES, new String[]{PhotoFiles._ID}, in testCleanup()
234 PhotoFiles._ID + "=?", new String[]{String.valueOf(normalPhotoId)}, in testCleanup()
|
| D | LegacyContactsProviderTest.java | 73 assertSelection(People.CONTENT_URI, values, "people", People._ID, ContentUris.parseId(uri)); in testPeopleInsert()
83 assertSelection(People.CONTENT_URI, values, "people", People._ID, personId); in testPeopleUpdate()
92 mResolver.update(People.CONTENT_URI, values, People._ID + "=" + personId, null); in testPeopleUpdate()
247 ContactMethods._ID + "=" + ContentUris.parseId(emailUri1), null, values); in testEmailCrud()
249 ContactMethods._ID + "=" + ContentUris.parseId(emailUri1), null, values); in testEmailCrud()
338 "organizations", Organizations._ID, ContentUris.parseId(uri)); in testOrganizationsInsert()
406 Phones._ID, ContentUris.parseId(uri)); in testPhonesInsert()
546 ContactMethods._ID, ContentUris.parseId(uri)); in assertContactMethodInsert()
603 Extensions._ID, ContentUris.parseId(uri)); in testExtensionsInsert()
667 GroupMembership._ID, ContentUris.parseId(membershipUri)); in testGroupMembershipsInsert()
[all …]
|
| /packages/apps/Bluetooth/src/com/android/bluetooth/pbap/ |
| D | BluetoothPbapVcardManager.java | 77 Data._ID, // 0
89 Contacts._ID, // 0
101 static final String CALLLOG_SORT_ORDER = Calls._ID + " DESC";
256 null, Contacts._ID); in getPhonebookNameList()
295 null, Contacts._ID); in getContactNamesByNumber()
327 CallLog.Calls._ID, // 0 in composeAndSendCallLogVcards()
358 recordSelection = Calls._ID + "=" + startPointId; in composeAndSendCallLogVcards()
362 recordSelection = Calls._ID + ">=" + endPointId + " AND " + Calls._ID + "<=" in composeAndSendCallLogVcards()
391 Contacts._ID); in composeAndSendPhonebookVcards()
412 selection = Contacts._ID + "=" + startPointId + " AND " + CLAUSE_ONLY_VISIBLE; in composeAndSendPhonebookVcards()
[all …]
|
| /packages/providers/ApplicationsProvider/src/com/android/providers/applications/ |
| D | ApplicationsProvider.java | 88 public static final String _ID = "_id"; field in ApplicationsProvider
104 + " applicationsLookup.source = " + APPLICATIONS_TABLE + "." + _ID;
248 _ID + " INTEGER PRIMARY KEY AUTOINCREMENT," + in createDatabase()
263 "source INTEGER REFERENCES " + APPLICATIONS_TABLE + "(" + _ID + ")," + in createDatabase()
274 "DELETE FROM applicationsLookup WHERE source = new." + _ID + ";" + in createDatabase()
275 "SELECT _TOKENIZE('applicationsLookup', new." + _ID + ", new." + NAME + ", ' ', 1);" in createDatabase()
280 "SELECT _TOKENIZE('applicationsLookup', new." + _ID + ", new." + NAME + ", ' ', 1);" in createDatabase()
285 "DELETE FROM applicationsLookup WHERE source = old." + _ID + ";" + in createDatabase()
419 String groupBy = APPLICATIONS_TABLE + "." + _ID; in searchApplications()
459 addProjection(map, Applications.ApplicationColumns._ID, _ID); in buildSuggestionsProjectionMap()
[all …]
|
| /packages/providers/TelephonyProvider/src/com/android/providers/telephony/ |
| D | MmsSmsDatabaseHelper.java | 462 new String[] { Sms._ID, Sms.BODY }, in populateWordsTable()
495 new String[] { Part._ID, Part.TEXT }, in populateWordsTable()
564 Mms._ID + " INTEGER PRIMARY KEY AUTOINCREMENT," + in createMmsTables()
600 Addr._ID + " INTEGER PRIMARY KEY," + in createMmsTables()
608 Part._ID + " INTEGER PRIMARY KEY AUTOINCREMENT," + in createMmsTables()
627 BaseColumns._ID + " INTEGER PRIMARY KEY," + in createMmsTables()
715 " new." + BaseColumns._ID + "," + in createMmsTriggers()
738 " new." + BaseColumns._ID + "," + in createMmsTriggers()
897 Threads._ID + " INTEGER PRIMARY KEY AUTOINCREMENT," + in createCommonTables()
912 PendingMessages._ID + " INTEGER PRIMARY KEY," + in createCommonTables()
[all …]
|
| D | MmsProvider.java | 102 qb.appendWhere(Mms._ID + "=" + uri.getPathSegments().get(0)); in query()
109 qb.appendWhere(Mms._ID + "=" + uri.getPathSegments().get(1)); in query()
122 qb.appendWhere(Part._ID + "=" + uri.getPathSegments().get(1)); in query()
187 qb.appendWhere(BaseColumns._ID + "=" + uri.getLastPathSegment()); in query()
244 Part._ID + " = ?", new String[] { uri.getLastPathSegment() }, in getType()
552 extraSelection = Mms._ID + "=" + uri.getLastPathSegment(); in delete()
575 extraSelection = Part._ID + "=" + uri.getPathSegments().get(1); in delete()
612 Cursor cursor = db.query(TABLE_PDU, new String[] { Mms._ID }, in deleteMessages()
748 extraSelection = Mms._ID + "=" + msgId; in update()
758 extraSelection = Part._ID + "=" + uri.getPathSegments().get(1); in update()
[all …]
|
| D | MmsSmsProvider.java | 120 { BaseColumns._ID, Mms.DATE, Mms.DATE_SENT, Mms.READ, Mms.THREAD_ID, Mms.LOCKED };
141 BaseColumns._ID,
151 new String[] { CanonicalAddressesColumns._ID,
170 private static final String[] ID_PROJECTION = { BaseColumns._ID };
528 retVal = cursor.getLong(cursor.getColumnIndexOrThrow(BaseColumns._ID)); in getSingleAddressId()
743 String[] innerProjection = new String[] {BaseColumns._ID, Conversations.THREAD_ID}; in getDraftThread()
862 String[] idColumn = new String[] { BaseColumns._ID }; in getFirstLockedMessage()
869 BaseColumns._ID, "locked=1"); in getFirstLockedMessage()
875 BaseColumns._ID, "locked=1"); in getFirstLockedMessage()
1040 if (old[i].equals(BaseColumns._ID)) { in createMmsProjection()
|
| /packages/apps/Calendar/src/com/android/calendar/alerts/ |
| D | GlobalDismissManager.java | 58 Events._ID,
62 Events._ID,
66 Calendars._ID,
204 Events._ID + " = " + eventId, null, null); in dismissGlobally()
287 String eventSelection = buildMultipleIdQuery(eventIds, Events._ID); in lookupEventToCalendarMap()
293 int event_id_idx = eventCursor.getColumnIndex(Events._ID); in lookupEventToCalendarMap()
317 String calendarSelection = buildMultipleIdQuery(calendars, Calendars._ID); in lookupCalendarToAccountMap()
322 int calendar_id_idx = calendarCursor.getColumnIndex(Calendars._ID); in lookupCalendarToAccountMap()
358 int event_id_idx = cursor.getColumnIndex(Events._ID); in onReceive()
|
| /packages/apps/Launcher2/src/com/android/launcher2/ |
| D | LauncherProvider.java | 127 if (!values.containsKey(LauncherSettings.Favorites._ID)) { in dbInsertAndCheck()
355 final int idIndex = c.getColumnIndexOrThrow(LauncherSettings.Favorites._ID); in copyFromCursor()
374 values.put(LauncherSettings.Favorites._ID, c.getLong(idIndex)); in copyFromCursor()
523 new String[] { Favorites._ID, Favorites.INTENT }, in updateContactsShortcuts()
529 final int idIndex = c.getColumnIndex(Favorites._ID); in updateContactsShortcuts()
567 String updateWhere = Favorites._ID + "=" + favoriteId; in updateContactsShortcuts()
607 final int idIndex = c.getColumnIndexOrThrow(Favorites._ID); in normalizeIcons()
701 c = db.query(TABLE_FAVORITES, new String[] { Favorites._ID, Favorites.ITEM_TYPE }, in convertWidgets()
732 String updateWhere = Favorites._ID + "=" + favoriteId; in convertWidgets()
950 values.put(Favorites._ID, generateNewId()); in addAppShortcut()
[all …]
|
| /packages/apps/ContactsCommon/src/com/android/contacts/common/list/ |
| D | DirectoryListLoader.java | 46 public static final String ORDER_BY = Directory._ID;
49 Directory._ID,
67 Directory._ID,
126 : (Directory._ID + "!=" + Directory.LOCAL_INVISIBLE); in loadInBackground()
132 : (" AND " + Directory._ID + "!=" + Directory.LOCAL_INVISIBLE)); in loadInBackground()
140 : (" AND " + Directory._ID + "!=" + Directory.LOCAL_INVISIBLE)); in loadInBackground()
|
| /packages/apps/Bluetooth/src/com/android/bluetooth/opp/ |
| D | BluetoothOppProvider.java | 105 LIVE_FOLDER_PROJECTION_MAP.put(LiveFolders._ID, BluetoothShare._ID + " AS " in LIVE_FOLDER_PROJECTION_MAP.put() argument
106 + LiveFolders._ID); in LIVE_FOLDER_PROJECTION_MAP.put() argument
175 db.execSQL("CREATE TABLE " + DB_TABLE + "(" + BluetoothShare._ID in createTable()
317 qb.appendWhere(BluetoothShare._ID + "="); in query()
413 myWhere += " ( " + BluetoothShare._ID + " = " + rowId + " ) "; in update()
454 myWhere += " ( " + BluetoothShare._ID + " = " + rowId + " ) "; in delete()
|
| /packages/apps/Browser/src/com/android/browser/ |
| D | AddBookmarkPage.java | 288 long id = mMap.getLong(BrowserContract.Bookmarks._ID); in onClick()
406 mMap.putLong(BrowserContract.Bookmarks._ID, info.id);
462 BrowserContract.Bookmarks._ID, in onCreateLoader()
469 where += " AND " + BrowserContract.Bookmarks._ID + " != ?"; in onCreateLoader()
471 BrowserContract.Bookmarks._ID)) }; in onCreateLoader()
485 BrowserContract.Bookmarks._ID + " ASC"); in onCreateLoader()
903 Long id = mMap.getLong(BrowserContract.Bookmarks._ID); in save()
1086 info.id = mMap.getLong(BrowserContract.Bookmarks._ID, -1); in loadInBackground()
1090 new String[] { BrowserContract.Bookmarks._ID}, in loadInBackground()
1139 BrowserContract.Bookmarks._ID + "=?", new String[] { in loadInBackground()
|
| /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/Gallery2/src/com/android/photos/data/ |
| D | MediaCacheDatabase.java | 53 Columns._ID,
57 Columns._ID, Columns.MEDIA_SIZE, Columns.SIZE_IN_BYTES,
65 Columns._ID, Columns.URI, Columns.MEDIA_SIZE, Columns.SIZE_IN_BYTES, Columns.LAST_ACCESS,
69 + Columns._ID + " INTEGER PRIMARY KEY AUTOINCREMENT, "
134 db.update(TABLE, values, Columns._ID + " = ?", updateArgs); in getCached()
191 db.update(TABLE, values, Columns._ID + " = ?", whereArgs); in updateLength()
|