/* * Copyright (C) 2009 The Android Open Source Project * * Licensed under the Apache License, Version 2.0 (the "License"); * you may not use this file except in compliance with the License. * You may obtain a copy of the License at * * http://www.apache.org/licenses/LICENSE-2.0 * * Unless required by applicable law or agreed to in writing, software * distributed under the License is distributed on an "AS IS" BASIS, * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. * See the License for the specific language governing permissions and * limitations under the License. */ package com.android.providers.contacts; import com.android.internal.util.ArrayUtils; import com.android.providers.contacts.ContactsDatabaseHelper.PresenceColumns; import com.google.android.collect.Lists; import android.accounts.Account; import android.content.ContentProviderOperation; import android.content.ContentProviderResult; import android.content.ContentUris; import android.content.ContentValues; import android.content.Entity; import android.content.EntityIterator; import android.content.res.AssetFileDescriptor; import android.database.Cursor; import android.net.Uri; import android.os.RemoteException; import android.provider.ContactsContract; import android.provider.LiveFolders; import android.provider.OpenableColumns; import android.provider.ContactsContract.AggregationExceptions; import android.provider.ContactsContract.ContactCounts; import android.provider.ContactsContract.Contacts; import android.provider.ContactsContract.Data; import android.provider.ContactsContract.DisplayNameSources; import android.provider.ContactsContract.Groups; import android.provider.ContactsContract.PhoneLookup; import android.provider.ContactsContract.PhoneticNameStyle; import android.provider.ContactsContract.ProviderStatus; import android.provider.ContactsContract.RawContacts; import android.provider.ContactsContract.RawContactsEntity; import android.provider.ContactsContract.SearchSnippetColumns; import android.provider.ContactsContract.Settings; import android.provider.ContactsContract.StatusUpdates; import android.provider.ContactsContract.CommonDataKinds.Email; import android.provider.ContactsContract.CommonDataKinds.GroupMembership; import android.provider.ContactsContract.CommonDataKinds.Im; import android.provider.ContactsContract.CommonDataKinds.Nickname; import android.provider.ContactsContract.CommonDataKinds.Organization; import android.provider.ContactsContract.CommonDataKinds.Phone; import android.provider.ContactsContract.CommonDataKinds.Photo; import android.provider.ContactsContract.CommonDataKinds.StructuredName; import android.provider.ContactsContract.CommonDataKinds.StructuredPostal; import android.test.MoreAsserts; import android.test.suitebuilder.annotation.LargeTest; import java.io.FileInputStream; import java.io.IOException; import java.text.Collator; import java.util.Arrays; import java.util.Locale; /** * Unit tests for {@link ContactsProvider2}. * * Run the test like this: *


 * adb shell am instrument -e class com.android.providers.contacts.ContactsProvider2Test -w \
 *         com.android.providers.contacts.tests/android.test.InstrumentationTestRunner
 *

*/ @LargeTest public class ContactsProvider2Test extends BaseContactsProvider2Test { public void testRawContactsInsert() { ContentValues values = new ContentValues(); values.put(RawContacts.ACCOUNT_NAME, "a"); values.put(RawContacts.ACCOUNT_TYPE, "b"); values.put(RawContacts.SOURCE_ID, "c"); values.put(RawContacts.VERSION, 42); values.put(RawContacts.DIRTY, 1); values.put(RawContacts.DELETED, 1); values.put(RawContacts.AGGREGATION_MODE, RawContacts.AGGREGATION_MODE_DISABLED); values.put(RawContacts.CUSTOM_RINGTONE, "d"); values.put(RawContacts.SEND_TO_VOICEMAIL, 1); values.put(RawContacts.LAST_TIME_CONTACTED, 12345); values.put(RawContacts.STARRED, 1); values.put(RawContacts.SYNC1, "e"); values.put(RawContacts.SYNC2, "f"); values.put(RawContacts.SYNC3, "g"); values.put(RawContacts.SYNC4, "h"); Uri rowUri = mResolver.insert(RawContacts.CONTENT_URI, values); long rawContactId = ContentUris.parseId(rowUri); assertStoredValues(rowUri, values); assertSelection(RawContacts.CONTENT_URI, values, RawContacts._ID, rawContactId); assertNetworkNotified(true); } public void testDataDirectoryWithLookupUri() { ContentValues values = new ContentValues(); long rawContactId = createRawContactWithName(); insertPhoneNumber(rawContactId, "555-GOOG-411"); insertEmail(rawContactId, "google@android.com"); long contactId = queryContactId(rawContactId); String lookupKey = queryLookupKey(contactId); // Complete and valid lookup URI Uri lookupUri = ContactsContract.Contacts.getLookupUri(contactId, lookupKey); Uri dataUri = Uri.withAppendedPath(lookupUri, Contacts.Data.CONTENT_DIRECTORY); assertDataRows(dataUri, values); // Complete but stale lookup URI lookupUri = ContactsContract.Contacts.getLookupUri(contactId + 1, lookupKey); dataUri = Uri.withAppendedPath(lookupUri, Contacts.Data.CONTENT_DIRECTORY); assertDataRows(dataUri, values); // Incomplete lookup URI (lookup key only, no contact ID) dataUri = Uri.withAppendedPath(Uri.withAppendedPath(Contacts.CONTENT_LOOKUP_URI, lookupKey), Contacts.Data.CONTENT_DIRECTORY); assertDataRows(dataUri, values); } private void assertDataRows(Uri dataUri, ContentValues values) { Cursor cursor = mResolver.query(dataUri, new String[]{ Data.DATA1 }, null, null, Data._ID); assertEquals(3, cursor.getCount()); cursor.moveToFirst(); values.put(Data.DATA1, "John Doe"); assertCursorValues(cursor, values); cursor.moveToNext(); values.put(Data.DATA1, "555-GOOG-411"); assertCursorValues(cursor, values); cursor.moveToNext(); values.put(Data.DATA1, "google@android.com"); assertCursorValues(cursor, values); cursor.close(); } public void testDataInsert() { long rawContactId = createRawContactWithName("John", "Doe"); ContentValues values = new ContentValues(); putDataValues(values, rawContactId); Uri dataUri = mResolver.insert(Data.CONTENT_URI, values); long dataId = ContentUris.parseId(dataUri); long contactId = queryContactId(rawContactId); values.put(RawContacts.CONTACT_ID, contactId); assertStoredValues(dataUri, values); assertSelection(Data.CONTENT_URI, values, Data._ID, dataId); // Access the same data through the directory under RawContacts Uri rawContactUri = ContentUris.withAppendedId(RawContacts.CONTENT_URI, rawContactId); Uri rawContactDataUri = Uri.withAppendedPath(rawContactUri, RawContacts.Data.CONTENT_DIRECTORY); assertSelection(rawContactDataUri, values, Data._ID, dataId); // Access the same data through the directory under Contacts Uri contactUri = ContentUris.withAppendedId(Contacts.CONTENT_URI, contactId); Uri contactDataUri = Uri.withAppendedPath(contactUri, Contacts.Data.CONTENT_DIRECTORY); assertSelection(contactDataUri, values, Data._ID, dataId); assertNetworkNotified(true); } public void testRawContactDataQuery() { Account account1 = new Account("a", "b"); Account account2 = new Account("c", "d"); long rawContactId1 = createRawContact(account1); Uri dataUri1 = insertStructuredName(rawContactId1, "John", "Doe"); long rawContactId2 = createRawContact(account2); Uri dataUri2 = insertStructuredName(rawContactId2, "Jane", "Doe"); Uri uri1 = maybeAddAccountQueryParameters(dataUri1, account1); Uri uri2 = maybeAddAccountQueryParameters(dataUri2, account2); assertStoredValue(uri1, Data._ID, ContentUris.parseId(dataUri1)) ; assertStoredValue(uri2, Data._ID, ContentUris.parseId(dataUri2)) ; } public void testPhonesQuery() { ContentValues values = new ContentValues(); values.put(RawContacts.CUSTOM_RINGTONE, "d"); values.put(RawContacts.SEND_TO_VOICEMAIL, 1); values.put(RawContacts.LAST_TIME_CONTACTED, 12345); values.put(RawContacts.TIMES_CONTACTED, 54321); values.put(RawContacts.STARRED, 1); Uri rawContactUri = mResolver.insert(RawContacts.CONTENT_URI, values); long rawContactId = ContentUris.parseId(rawContactUri); insertStructuredName(rawContactId, "Meghan", "Knox"); Uri uri = insertPhoneNumber(rawContactId, "18004664411"); long phoneId = ContentUris.parseId(uri); long contactId = queryContactId(rawContactId); values.clear(); values.put(Data._ID, phoneId); values.put(Data.RAW_CONTACT_ID, rawContactId); values.put(RawContacts.CONTACT_ID, contactId); values.put(Data.MIMETYPE, Phone.CONTENT_ITEM_TYPE); values.put(Phone.NUMBER, "18004664411"); values.put(Phone.TYPE, Phone.TYPE_HOME); values.putNull(Phone.LABEL); values.put(Contacts.DISPLAY_NAME, "Meghan Knox"); values.put(Contacts.CUSTOM_RINGTONE, "d"); values.put(Contacts.SEND_TO_VOICEMAIL, 1); values.put(Contacts.LAST_TIME_CONTACTED, 12345); values.put(Contacts.TIMES_CONTACTED, 54321); values.put(Contacts.STARRED, 1); assertStoredValues(ContentUris.withAppendedId(Phone.CONTENT_URI, phoneId), values); assertSelection(Phone.CONTENT_URI, values, Data._ID, phoneId); } public void testPhonesFilterQuery() { long rawContactId1 = createRawContactWithName("Hot", "Tamale"); insertPhoneNumber(rawContactId1, "18004664411"); insertPhoneNumber(rawContactId1, "1-800-466-4411"); long rawContactId2 = createRawContactWithName("Hot", "Tamale"); insertPhoneNumber(rawContactId2, "1-800-466-4411"); Uri filterUri1 = Uri.withAppendedPath(Phone.CONTENT_FILTER_URI, "tamale"); ContentValues values = new ContentValues(); values.put(Contacts.DISPLAY_NAME, "Hot Tamale"); values.put(Data.MIMETYPE, Phone.CONTENT_ITEM_TYPE); values.put(Phone.NUMBER, "1-800-466-4411"); values.put(Phone.TYPE, Phone.TYPE_HOME); values.putNull(Phone.LABEL); assertStoredValuesWithProjection(filterUri1, values); Uri filterUri2 = Uri.withAppendedPath(Phone.CONTENT_FILTER_URI, "1-800-GOOG-411"); assertStoredValues(filterUri2, values); Uri filterUri3 = Uri.withAppendedPath(Phone.CONTENT_FILTER_URI, "18004664"); assertStoredValues(filterUri3, values); Uri filterUri4 = Uri.withAppendedPath(Phone.CONTENT_FILTER_URI, "encilada"); assertEquals(0, getCount(filterUri4, null, null)); Uri filterUri5 = Uri.withAppendedPath(Phone.CONTENT_FILTER_URI, "*"); assertEquals(0, getCount(filterUri5, null, null)); } public void testPhoneLookup() { ContentValues values = new ContentValues(); values.put(RawContacts.CUSTOM_RINGTONE, "d"); values.put(RawContacts.SEND_TO_VOICEMAIL, 1); Uri rawContactUri = mResolver.insert(RawContacts.CONTENT_URI, values); long rawContactId = ContentUris.parseId(rawContactUri); insertStructuredName(rawContactId, "Hot", "Tamale"); insertPhoneNumber(rawContactId, "18004664411"); Uri lookupUri1 = Uri.withAppendedPath(PhoneLookup.CONTENT_FILTER_URI, "8004664411"); values.clear(); values.put(PhoneLookup._ID, queryContactId(rawContactId)); values.put(PhoneLookup.DISPLAY_NAME, "Hot Tamale"); values.put(PhoneLookup.NUMBER, "18004664411"); values.put(PhoneLookup.TYPE, Phone.TYPE_HOME); values.putNull(PhoneLookup.LABEL); values.put(PhoneLookup.CUSTOM_RINGTONE, "d"); values.put(PhoneLookup.SEND_TO_VOICEMAIL, 1); assertStoredValues(lookupUri1, values); // The strict comparation, adopted in Donut, does not allow the behavior like // "8004664411 == 4664411", while the loose comparation, which had been used in Cupcake // and reverted back into the default in Eclair, allows it. Hmm... final boolean useStrictComparation = mContext.getResources().getBoolean( com.android.internal.R.bool.config_use_strict_phone_number_comparation); final int expectedResult = (useStrictComparation ? 0 : 1); Uri lookupUri2 = Uri.withAppendedPath(PhoneLookup.CONTENT_FILTER_URI, "4664411"); assertEquals(expectedResult, getCount(lookupUri2, null, null)); } public void testPhoneUpdate() { ContentValues values = new ContentValues(); Uri rawContactUri = mResolver.insert(RawContacts.CONTENT_URI, values); long rawContactId = ContentUris.parseId(rawContactUri); insertStructuredName(rawContactId, "Hot", "Tamale"); Uri phoneUri = insertPhoneNumber(rawContactId, "18004664411"); Uri lookupUri1 = Uri.withAppendedPath(PhoneLookup.CONTENT_FILTER_URI, "8004664411"); assertStoredValue(lookupUri1, PhoneLookup.DISPLAY_NAME, "Hot Tamale"); values.clear(); values.put(Phone.NUMBER, "18004664422"); mResolver.update(phoneUri, values, null, null); Uri lookupUri2 = Uri.withAppendedPath(PhoneLookup.CONTENT_FILTER_URI, "8004664422"); assertStoredValue(lookupUri2, PhoneLookup.DISPLAY_NAME, "Hot Tamale"); // Setting number to null will remove the phone lookup record values.clear(); values.putNull(Phone.NUMBER); mResolver.update(phoneUri, values, null, null); assertEquals(0, getCount(lookupUri2, null, null)); // Let's restore that phone lookup record values.clear(); values.put(Phone.NUMBER, "18004664422"); mResolver.update(phoneUri, values, null, null); assertStoredValue(lookupUri2, PhoneLookup.DISPLAY_NAME, "Hot Tamale"); assertNetworkNotified(true); } public void testEmailsQuery() { ContentValues values = new ContentValues(); values.put(RawContacts.CUSTOM_RINGTONE, "d"); values.put(RawContacts.SEND_TO_VOICEMAIL, 1); values.put(RawContacts.LAST_TIME_CONTACTED, 12345); values.put(RawContacts.TIMES_CONTACTED, 54321); values.put(RawContacts.STARRED, 1); Uri rawContactUri = mResolver.insert(RawContacts.CONTENT_URI, values); long rawContactId = ContentUris.parseId(rawContactUri); insertStructuredName(rawContactId, "Meghan", "Knox"); Uri uri = insertEmail(rawContactId, "meghan@acme.com"); long emailId = ContentUris.parseId(uri); long contactId = queryContactId(rawContactId); values.clear(); values.put(Data._ID, emailId); values.put(Data.RAW_CONTACT_ID, rawContactId); values.put(RawContacts.CONTACT_ID, contactId); values.put(Data.MIMETYPE, Email.CONTENT_ITEM_TYPE); values.put(Email.DATA, "meghan@acme.com"); values.put(Email.TYPE, Email.TYPE_HOME); values.putNull(Email.LABEL); values.put(Contacts.DISPLAY_NAME, "Meghan Knox"); values.put(Contacts.CUSTOM_RINGTONE, "d"); values.put(Contacts.SEND_TO_VOICEMAIL, 1); values.put(Contacts.LAST_TIME_CONTACTED, 12345); values.put(Contacts.TIMES_CONTACTED, 54321); values.put(Contacts.STARRED, 1); assertStoredValues(ContentUris.withAppendedId(Email.CONTENT_URI, emailId), values); assertSelection(Email.CONTENT_URI, values, Data._ID, emailId); } public void testEmailsLookupQuery() { long rawContactId = createRawContactWithName("Hot", "Tamale"); insertEmail(rawContactId, "tamale@acme.com"); Uri filterUri1 = Uri.withAppendedPath(Email.CONTENT_LOOKUP_URI, "tamale@acme.com"); ContentValues values = new ContentValues(); values.put(Contacts.DISPLAY_NAME, "Hot Tamale"); values.put(Data.MIMETYPE, Email.CONTENT_ITEM_TYPE); values.put(Email.DATA, "tamale@acme.com"); values.put(Email.TYPE, Email.TYPE_HOME); values.putNull(Email.LABEL); assertStoredValues(filterUri1, values); Uri filterUri2 = Uri.withAppendedPath(Email.CONTENT_LOOKUP_URI, "Ta"); assertStoredValues(filterUri2, values); Uri filterUri3 = Uri.withAppendedPath(Email.CONTENT_LOOKUP_URI, "encilada@acme.com"); assertEquals(0, getCount(filterUri3, null, null)); } public void testEmailsFilterQuery() { long rawContactId1 = createRawContactWithName("Hot", "Tamale"); insertEmail(rawContactId1, "tamale@acme.com"); insertEmail(rawContactId1, "tamale@acme.com"); long rawContactId2 = createRawContactWithName("Hot", "Tamale"); insertEmail(rawContactId2, "tamale@acme.com"); Uri filterUri1 = Uri.withAppendedPath(Email.CONTENT_FILTER_URI, "tam"); ContentValues values = new ContentValues(); values.put(Contacts.DISPLAY_NAME, "Hot Tamale"); values.put(Data.MIMETYPE, Email.CONTENT_ITEM_TYPE); values.put(Email.DATA, "tamale@acme.com"); values.put(Email.TYPE, Email.TYPE_HOME); values.putNull(Email.LABEL); assertStoredValuesWithProjection(filterUri1, values); Uri filterUri2 = Uri.withAppendedPath(Email.CONTENT_FILTER_URI, "hot"); assertStoredValuesWithProjection(filterUri2, values); Uri filterUri3 = Uri.withAppendedPath(Email.CONTENT_FILTER_URI, "hottamale"); assertStoredValuesWithProjection(filterUri3, values); Uri filterUri4 = Uri.withAppendedPath(Email.CONTENT_FILTER_URI, "tamale@acme"); assertStoredValuesWithProjection(filterUri4, values); Uri filterUri5 = Uri.withAppendedPath(Email.CONTENT_FILTER_URI, "encilada"); assertEquals(0, getCount(filterUri5, null, null)); } public void testPostalsQuery() { long rawContactId = createRawContactWithName("Alice", "Nextore"); Uri dataUri = insertPostalAddress(rawContactId, "1600 Amphiteatre Ave, Mountain View"); long dataId = ContentUris.parseId(dataUri); long contactId = queryContactId(rawContactId); ContentValues values = new ContentValues(); values.put(Data._ID, dataId); values.put(Data.RAW_CONTACT_ID, rawContactId); values.put(RawContacts.CONTACT_ID, contactId); values.put(Data.MIMETYPE, StructuredPostal.CONTENT_ITEM_TYPE); values.put(StructuredPostal.FORMATTED_ADDRESS, "1600 Amphiteatre Ave, Mountain View"); values.put(Contacts.DISPLAY_NAME, "Alice Nextore"); assertStoredValues(ContentUris.withAppendedId(StructuredPostal.CONTENT_URI, dataId), values); assertSelection(StructuredPostal.CONTENT_URI, values, Data._ID, dataId); } public void testQueryContactData() { ContentValues values = new ContentValues(); long contactId = createContact(values, "John", "Doe", "18004664411", "goog411@acme.com", StatusUpdates.INVISIBLE, 4, 1, 0); Uri contactUri = ContentUris.withAppendedId(Contacts.CONTENT_URI, contactId); assertStoredValues(contactUri, values); assertSelection(Contacts.CONTENT_URI, values, Contacts._ID, contactId); } public void testQueryContactWithStatusUpdate() { ContentValues values = new ContentValues(); long contactId = createContact(values, "John", "Doe", "18004664411", "goog411@acme.com", StatusUpdates.INVISIBLE, 4, 1, 0); values.put(Contacts.CONTACT_PRESENCE, StatusUpdates.INVISIBLE); Uri contactUri = ContentUris.withAppendedId(Contacts.CONTENT_URI, contactId); assertStoredValuesWithProjection(contactUri, values); assertSelectionWithProjection(Contacts.CONTENT_URI, values, Contacts._ID, contactId); } public void testQueryContactFilter() { ContentValues values = new ContentValues(); long rawContactId = createRawContact(values, "18004664411", "goog411@acme.com", StatusUpdates.INVISIBLE, 4, 1, 0); ContentValues nameValues = new ContentValues(); nameValues.put(StructuredName.GIVEN_NAME, "Stu"); nameValues.put(StructuredName.FAMILY_NAME, "Goulash"); nameValues.put(StructuredName.PHONETIC_FAMILY_NAME, "goo"); nameValues.put(StructuredName.PHONETIC_GIVEN_NAME, "LASH"); Uri nameUri = insertStructuredName(rawContactId, nameValues); long contactId = queryContactId(rawContactId); values.put(Contacts.CONTACT_PRESENCE, StatusUpdates.INVISIBLE); Uri filterUri1 = Uri.withAppendedPath(Contacts.CONTENT_FILTER_URI, "goulash"); assertStoredValuesWithProjection(filterUri1, values); assertContactFilter(contactId, "goolash"); assertContactFilter(contactId, "lash"); Uri filterUri2 = Uri.withAppendedPath(Contacts.CONTENT_FILTER_URI, "goolish"); assertEquals(0, getCount(filterUri2, null, null)); // Phonetic name with given/family reversed should not match Uri filterUri3 = Uri.withAppendedPath(Contacts.CONTENT_FILTER_URI, "lashgoo"); assertEquals(0, getCount(filterUri3, null, null)); nameValues.clear(); nameValues.put(StructuredName.PHONETIC_FAMILY_NAME, "ga"); nameValues.put(StructuredName.PHONETIC_GIVEN_NAME, "losh"); mResolver.update(nameUri, nameValues, null, null); assertContactFilter(contactId, "galosh"); Uri filterUri4 = Uri.withAppendedPath(Contacts.CONTENT_FILTER_URI, "goolish"); assertEquals(0, getCount(filterUri4, null, null)); } public void testQueryContactStrequent() { ContentValues values1 = new ContentValues(); createContact(values1, "Noah", "Tever", "18004664411", "a@acme.com", StatusUpdates.OFFLINE, 0, 0, 0); ContentValues values2 = new ContentValues(); createContact(values2, "Sam", "Times", "18004664412", "b@acme.com", StatusUpdates.INVISIBLE, 3, 0, 0); ContentValues values3 = new ContentValues(); createContact(values3, "Lotta", "Calling", "18004664413", "c@acme.com", StatusUpdates.AWAY, 5, 0, 0); ContentValues values4 = new ContentValues(); createContact(values4, "Fay", "Veritt", "18004664414", "d@acme.com", StatusUpdates.AVAILABLE, 0, 1, 0); Cursor c = mResolver.query(Contacts.CONTENT_STREQUENT_URI, null, null, null, Contacts._ID); assertEquals(3, c.getCount()); c.moveToFirst(); assertCursorValues(c, values4); c.moveToNext(); assertCursorValues(c, values3); c.moveToNext(); assertCursorValues(c, values2); c.close(); Uri filterUri = Uri.withAppendedPath(Contacts.CONTENT_STREQUENT_FILTER_URI, "fay"); c = mResolver.query(filterUri, null, null, null, Contacts._ID); assertEquals(1, c.getCount()); c.moveToFirst(); assertCursorValues(c, values4); c.close(); } public void testQueryContactGroup() { long groupId = createGroup(null, "testGroup", "Test Group"); ContentValues values1 = new ContentValues(); createContact(values1, "Best", "West", "18004664411", "west@acme.com", StatusUpdates.OFFLINE, 0, 0, groupId); ContentValues values2 = new ContentValues(); createContact(values2, "Rest", "East", "18004664422", "east@acme.com", StatusUpdates.AVAILABLE, 0, 0, 0); Uri filterUri1 = Uri.withAppendedPath(Contacts.CONTENT_GROUP_URI, "Test Group"); Cursor c = mResolver.query(filterUri1, null, null, null, Contacts._ID); assertEquals(1, c.getCount()); c.moveToFirst(); assertCursorValues(c, values1); c.close(); Uri filterUri2 = Uri.withAppendedPath(Contacts.CONTENT_GROUP_URI, "Test Group"); c = mResolver.query(filterUri2, null, Contacts.DISPLAY_NAME + "=?", new String[] { "Best West" }, Contacts._ID); assertEquals(1, c.getCount()); c.close(); Uri filterUri3 = Uri.withAppendedPath(Contacts.CONTENT_GROUP_URI, "Next Group"); c = mResolver.query(filterUri3, null, null, null, Contacts._ID); assertEquals(0, c.getCount()); c.close(); } public void testPhonesWithStatusUpdate() { ContentValues values = new ContentValues(); Uri rawContactUri = mResolver.insert(RawContacts.CONTENT_URI, values); long rawContactId = ContentUris.parseId(rawContactUri); insertStructuredName(rawContactId, "John", "Doe"); Uri photoUri = insertPhoto(rawContactId); long photoId = ContentUris.parseId(photoUri); values.put(Contacts.PHOTO_ID, photoId); insertPhoneNumber(rawContactId, "18004664411"); insertPhoneNumber(rawContactId, "18004664412"); insertEmail(rawContactId, "goog411@acme.com"); insertEmail(rawContactId, "goog412@acme.com"); insertStatusUpdate(Im.PROTOCOL_GOOGLE_TALK, null, "goog411@acme.com", StatusUpdates.INVISIBLE, "Bad"); insertStatusUpdate(Im.PROTOCOL_GOOGLE_TALK, null, "goog412@acme.com", StatusUpdates.AVAILABLE, "Good"); long contactId = queryContactId(rawContactId); Uri uri = Data.CONTENT_URI; Cursor c = mResolver.query(uri, null, RawContacts.CONTACT_ID + "=" + contactId + " AND " + Data.MIMETYPE + "='" + Phone.CONTENT_ITEM_TYPE + "'", null, Phone.NUMBER); assertEquals(2, c.getCount()); c.moveToFirst(); values.clear(); values.put(Contacts.CONTACT_PRESENCE, StatusUpdates.AVAILABLE); values.put(Contacts.CONTACT_STATUS, "Bad"); values.put(Contacts.DISPLAY_NAME, "John Doe"); values.put(Phone.NUMBER, "18004664411"); values.putNull(Phone.LABEL); values.put(RawContacts.CONTACT_ID, contactId); assertCursorValues(c, values); c.moveToNext(); values.clear(); values.put(Contacts.CONTACT_PRESENCE, StatusUpdates.AVAILABLE); values.put(Contacts.CONTACT_STATUS, "Bad"); values.put(Contacts.DISPLAY_NAME, "John Doe"); values.put(Phone.NUMBER, "18004664412"); values.putNull(Phone.LABEL); values.put(RawContacts.CONTACT_ID, contactId); assertCursorValues(c, values); c.close(); } public void testGroupQuery() { Account account1 = new Account("a", "b"); Account account2 = new Account("c", "d"); long groupId1 = createGroup(account1, "e", "f"); long groupId2 = createGroup(account2, "g", "h"); Uri uri1 = maybeAddAccountQueryParameters(Groups.CONTENT_URI, account1); Uri uri2 = maybeAddAccountQueryParameters(Groups.CONTENT_URI, account2); assertEquals(1, getCount(uri1, null, null)); assertEquals(1, getCount(uri2, null, null)); assertStoredValue(uri1, Groups._ID + "=" + groupId1, null, Groups._ID, groupId1) ; assertStoredValue(uri2, Groups._ID + "=" + groupId2, null, Groups._ID, groupId2) ; } public void testGroupInsert() { ContentValues values = new ContentValues(); values.put(Groups.ACCOUNT_NAME, "a"); values.put(Groups.ACCOUNT_TYPE, "b"); values.put(Groups.SOURCE_ID, "c"); values.put(Groups.VERSION, 42); values.put(Groups.GROUP_VISIBLE, 1); values.put(Groups.TITLE, "d"); values.put(Groups.TITLE_RES, 1234); values.put(Groups.NOTES, "e"); values.put(Groups.RES_PACKAGE, "f"); values.put(Groups.SYSTEM_ID, "g"); values.put(Groups.DELETED, 1); values.put(Groups.SYNC1, "h"); values.put(Groups.SYNC2, "i"); values.put(Groups.SYNC3, "j"); values.put(Groups.SYNC4, "k"); Uri rowUri = mResolver.insert(Groups.CONTENT_URI, values); values.put(Groups.DIRTY, 1); assertStoredValues(rowUri, values); } public void testSettingsQuery() { Account account1 = new Account("a", "b"); Account account2 = new Account("c", "d"); createSettings(account1, "0", "0"); createSettings(account2, "1", "1"); Uri uri1 = maybeAddAccountQueryParameters(Settings.CONTENT_URI, account1); Uri uri2 = maybeAddAccountQueryParameters(Settings.CONTENT_URI, account2); assertEquals(1, getCount(uri1, null, null)); assertEquals(1, getCount(uri2, null, null)); assertStoredValue(uri1, Settings.SHOULD_SYNC, "0") ; assertStoredValue(uri1, Settings.UNGROUPED_VISIBLE, "0") ; assertStoredValue(uri2, Settings.SHOULD_SYNC, "1") ; assertStoredValue(uri2, Settings.UNGROUPED_VISIBLE, "1") ; } public void testDisplayNameParsingWhenPartsUnspecified() { long rawContactId = createRawContact(); ContentValues values = new ContentValues(); values.put(StructuredName.DISPLAY_NAME, "Mr.John Kevin von Smith, Jr."); insertStructuredName(rawContactId, values); assertStructuredName(rawContactId, "Mr", "John", "Kevin", "von Smith", "Jr."); } public void testDisplayNameParsingWhenPartsAreNull() { long rawContactId = createRawContact(); ContentValues values = new ContentValues(); values.put(StructuredName.DISPLAY_NAME, "Mr.John Kevin von Smith, Jr."); values.putNull(StructuredName.GIVEN_NAME); values.putNull(StructuredName.FAMILY_NAME); insertStructuredName(rawContactId, values); assertStructuredName(rawContactId, "Mr", "John", "Kevin", "von Smith", "Jr."); } public void testDisplayNameParsingWhenPartsSpecified() { long rawContactId = createRawContact(); ContentValues values = new ContentValues(); values.put(StructuredName.DISPLAY_NAME, "Mr.John Kevin von Smith, Jr."); values.put(StructuredName.FAMILY_NAME, "Johnson"); insertStructuredName(rawContactId, values); assertStructuredName(rawContactId, null, null, null, "Johnson", null); } public void testContactWithoutPhoneticName() { final long rawContactId = createRawContact(null); ContentValues values = new ContentValues(); values.put(StructuredName.PREFIX, "Mr"); values.put(StructuredName.GIVEN_NAME, "John"); values.put(StructuredName.MIDDLE_NAME, "K."); values.put(StructuredName.FAMILY_NAME, "Doe"); values.put(StructuredName.SUFFIX, "Jr."); Uri dataUri = insertStructuredName(rawContactId, values); values.clear(); values.put(RawContacts.DISPLAY_NAME_SOURCE, DisplayNameSources.STRUCTURED_NAME); values.put(RawContacts.DISPLAY_NAME_PRIMARY, "John K. Doe, Jr."); values.put(RawContacts.DISPLAY_NAME_ALTERNATIVE, "Doe, John K., Jr."); values.putNull(RawContacts.PHONETIC_NAME); values.put(RawContacts.PHONETIC_NAME_STYLE, PhoneticNameStyle.UNDEFINED); values.put(RawContacts.SORT_KEY_PRIMARY, "John K. Doe, Jr."); values.put(RawContacts.SORT_KEY_ALTERNATIVE, "Doe, John K., Jr."); Uri rawContactUri = ContentUris.withAppendedId(RawContacts.CONTENT_URI, rawContactId); assertStoredValues(rawContactUri, values); values.clear(); values.put(Contacts.DISPLAY_NAME_SOURCE, DisplayNameSources.STRUCTURED_NAME); values.put(Contacts.DISPLAY_NAME_PRIMARY, "John K. Doe, Jr."); values.put(Contacts.DISPLAY_NAME_ALTERNATIVE, "Doe, John K., Jr."); values.putNull(Contacts.PHONETIC_NAME); values.put(Contacts.PHONETIC_NAME_STYLE, PhoneticNameStyle.UNDEFINED); values.put(Contacts.SORT_KEY_PRIMARY, "John K. Doe, Jr."); values.put(Contacts.SORT_KEY_ALTERNATIVE, "Doe, John K., Jr."); Uri contactUri = ContentUris.withAppendedId(Contacts.CONTENT_URI, queryContactId(rawContactId)); assertStoredValues(contactUri, values); // The same values should be available through a join with Data assertStoredValues(dataUri, values); } public void testContactWithChineseName() { // Only run this test when Chinese collation is supported if (!Arrays.asList(Collator.getAvailableLocales()).contains(Locale.CHINA)) { return; } long rawContactId = createRawContact(null); ContentValues values = new ContentValues(); values.put(StructuredName.DISPLAY_NAME, "\u6BB5\u5C0F\u6D9B"); Uri dataUri = insertStructuredName(rawContactId, values); values.clear(); values.put(RawContacts.DISPLAY_NAME_SOURCE, DisplayNameSources.STRUCTURED_NAME); values.put(RawContacts.DISPLAY_NAME_PRIMARY, "\u6BB5\u5C0F\u6D9B"); values.put(RawContacts.DISPLAY_NAME_ALTERNATIVE, "\u6BB5\u5C0F\u6D9B"); values.putNull(RawContacts.PHONETIC_NAME); values.put(RawContacts.PHONETIC_NAME_STYLE, PhoneticNameStyle.UNDEFINED); values.put(RawContacts.SORT_KEY_PRIMARY, "DUAN \u6BB5 XIAO \u5C0F TAO \u6D9B"); values.put(RawContacts.SORT_KEY_ALTERNATIVE, "DUAN \u6BB5 XIAO \u5C0F TAO \u6D9B"); Uri rawContactUri = ContentUris.withAppendedId(RawContacts.CONTENT_URI, rawContactId); assertStoredValues(rawContactUri, values); values.clear(); values.put(Contacts.DISPLAY_NAME_SOURCE, DisplayNameSources.STRUCTURED_NAME); values.put(Contacts.DISPLAY_NAME_PRIMARY, "\u6BB5\u5C0F\u6D9B"); values.put(Contacts.DISPLAY_NAME_ALTERNATIVE, "\u6BB5\u5C0F\u6D9B"); values.putNull(Contacts.PHONETIC_NAME); values.put(Contacts.PHONETIC_NAME_STYLE, PhoneticNameStyle.UNDEFINED); values.put(Contacts.SORT_KEY_PRIMARY, "DUAN \u6BB5 XIAO \u5C0F TAO \u6D9B"); values.put(Contacts.SORT_KEY_ALTERNATIVE, "DUAN \u6BB5 XIAO \u5C0F TAO \u6D9B"); Uri contactUri = ContentUris.withAppendedId(Contacts.CONTENT_URI, queryContactId(rawContactId)); assertStoredValues(contactUri, values); // The same values should be available through a join with Data assertStoredValues(dataUri, values); } public void testContactWithJapaneseName() { long rawContactId = createRawContact(null); ContentValues values = new ContentValues(); values.put(StructuredName.GIVEN_NAME, "\u7A7A\u6D77"); values.put(StructuredName.PHONETIC_GIVEN_NAME, "\u304B\u3044\u304F\u3046"); Uri dataUri = insertStructuredName(rawContactId, values); values.clear(); values.put(RawContacts.DISPLAY_NAME_SOURCE, DisplayNameSources.STRUCTURED_NAME); values.put(RawContacts.DISPLAY_NAME_PRIMARY, "\u7A7A\u6D77"); values.put(RawContacts.DISPLAY_NAME_ALTERNATIVE, "\u7A7A\u6D77"); values.put(RawContacts.PHONETIC_NAME, "\u304B\u3044\u304F\u3046"); values.put(RawContacts.PHONETIC_NAME_STYLE, PhoneticNameStyle.JAPANESE); values.put(RawContacts.SORT_KEY_PRIMARY, "\u304B\u3044\u304F\u3046"); values.put(RawContacts.SORT_KEY_ALTERNATIVE, "\u304B\u3044\u304F\u3046"); Uri rawContactUri = ContentUris.withAppendedId(RawContacts.CONTENT_URI, rawContactId); assertStoredValues(rawContactUri, values); values.clear(); values.put(Contacts.DISPLAY_NAME_SOURCE, DisplayNameSources.STRUCTURED_NAME); values.put(Contacts.DISPLAY_NAME_PRIMARY, "\u7A7A\u6D77"); values.put(Contacts.DISPLAY_NAME_ALTERNATIVE, "\u7A7A\u6D77"); values.put(Contacts.PHONETIC_NAME, "\u304B\u3044\u304F\u3046"); values.put(Contacts.PHONETIC_NAME_STYLE, PhoneticNameStyle.JAPANESE); values.put(Contacts.SORT_KEY_PRIMARY, "\u304B\u3044\u304F\u3046"); values.put(Contacts.SORT_KEY_ALTERNATIVE, "\u304B\u3044\u304F\u3046"); Uri contactUri = ContentUris.withAppendedId(Contacts.CONTENT_URI, queryContactId(rawContactId)); assertStoredValues(contactUri, values); // The same values should be available through a join with Data assertStoredValues(dataUri, values); } public void testDisplayNameUpdate() { long rawContactId1 = createRawContact(); insertEmail(rawContactId1, "potato@acme.com", true); long rawContactId2 = createRawContact(); insertPhoneNumber(rawContactId2, "123456789", true); setAggregationException(AggregationExceptions.TYPE_KEEP_TOGETHER, rawContactId1, rawContactId2); assertAggregated(rawContactId1, rawContactId2, "123456789"); insertStructuredName(rawContactId2, "Potato", "Head"); assertAggregated(rawContactId1, rawContactId2, "Potato Head"); assertNetworkNotified(true); } public void testDisplayNameFromData() { long rawContactId = createRawContact(); long contactId = queryContactId(rawContactId); ContentValues values = new ContentValues(); Uri uri = ContentUris.withAppendedId(Contacts.CONTENT_URI, contactId); assertStoredValue(uri, Contacts.DISPLAY_NAME, null); insertEmail(rawContactId, "mike@monstersinc.com"); assertStoredValue(uri, Contacts.DISPLAY_NAME, "mike@monstersinc.com"); insertEmail(rawContactId, "james@monstersinc.com", true); assertStoredValue(uri, Contacts.DISPLAY_NAME, "james@monstersinc.com"); insertPhoneNumber(rawContactId, "1-800-466-4411"); assertStoredValue(uri, Contacts.DISPLAY_NAME, "1-800-466-4411"); // If there are title and company, the company is display name. values.clear(); values.put(Organization.COMPANY, "Monsters Inc"); Uri organizationUri = insertOrganization(rawContactId, values); assertStoredValue(uri, Contacts.DISPLAY_NAME, "Monsters Inc"); // If there is nickname, that is display name. insertNickname(rawContactId, "Sully"); assertStoredValue(uri, Contacts.DISPLAY_NAME, "Sully"); // If there is structured name, that is display name. values.clear(); values.put(StructuredName.GIVEN_NAME, "James"); values.put(StructuredName.MIDDLE_NAME, "P."); values.put(StructuredName.FAMILY_NAME, "Sullivan"); insertStructuredName(rawContactId, values); assertStoredValue(uri, Contacts.DISPLAY_NAME, "James P. Sullivan"); } public void testDisplayNameFromOrganizationWithoutPhoneticName() { long rawContactId = createRawContact(); long contactId = queryContactId(rawContactId); ContentValues values = new ContentValues(); Uri uri = ContentUris.withAppendedId(Contacts.CONTENT_URI, contactId); // If there is title without company, the title is display name. values.clear(); values.put(Organization.TITLE, "Protagonist"); Uri organizationUri = insertOrganization(rawContactId, values); assertStoredValue(uri, Contacts.DISPLAY_NAME, "Protagonist"); // If there are title and company, the company is display name. values.clear(); values.put(Organization.COMPANY, "Monsters Inc"); mResolver.update(organizationUri, values, null, null); values.clear(); values.put(Contacts.DISPLAY_NAME, "Monsters Inc"); values.putNull(Contacts.PHONETIC_NAME); values.put(Contacts.PHONETIC_NAME_STYLE, PhoneticNameStyle.UNDEFINED); values.put(Contacts.SORT_KEY_PRIMARY, "Monsters Inc"); values.put(Contacts.SORT_KEY_ALTERNATIVE, "Monsters Inc"); assertStoredValues(uri, values); } public void testDisplayNameFromOrganizationWithJapanesePhoneticName() { long rawContactId = createRawContact(); long contactId = queryContactId(rawContactId); ContentValues values = new ContentValues(); Uri uri = ContentUris.withAppendedId(Contacts.CONTENT_URI, contactId); // If there is title without company, the title is display name. values.clear(); values.put(Organization.COMPANY, "DoCoMo"); values.put(Organization.PHONETIC_NAME, "\u30C9\u30B3\u30E2"); Uri organizationUri = insertOrganization(rawContactId, values); values.clear(); values.put(Contacts.DISPLAY_NAME, "DoCoMo"); values.put(Contacts.PHONETIC_NAME, "\u30C9\u30B3\u30E2"); values.put(Contacts.PHONETIC_NAME_STYLE, PhoneticNameStyle.JAPANESE); values.put(Contacts.SORT_KEY_PRIMARY, "\u30C9\u30B3\u30E2"); values.put(Contacts.SORT_KEY_ALTERNATIVE, "\u30C9\u30B3\u30E2"); assertStoredValues(uri, values); } public void testDisplayNameFromOrganizationWithChineseName() { boolean hasChineseCollator = false; final Locale locale[] = Collator.getAvailableLocales(); for (int i = 0; i < locale.length; i++) { if (locale[i].equals(Locale.CHINA)) { hasChineseCollator = true; break; } } if (!hasChineseCollator) { return; } long rawContactId = createRawContact(); long contactId = queryContactId(rawContactId); ContentValues values = new ContentValues(); Uri uri = ContentUris.withAppendedId(Contacts.CONTENT_URI, contactId); // If there is title without company, the title is display name. values.clear(); values.put(Organization.COMPANY, "\u4E2D\u56FD\u7535\u4FE1"); Uri organizationUri = insertOrganization(rawContactId, values); values.clear(); values.put(Contacts.DISPLAY_NAME, "\u4E2D\u56FD\u7535\u4FE1"); values.putNull(Contacts.PHONETIC_NAME); values.put(Contacts.PHONETIC_NAME_STYLE, PhoneticNameStyle.UNDEFINED); values.put(Contacts.SORT_KEY_PRIMARY, "ZHONG \u4E2D GUO \u56FD DIAN \u7535 XIN \u4FE1"); values.put(Contacts.SORT_KEY_ALTERNATIVE, "ZHONG \u4E2D GUO \u56FD DIAN \u7535 XIN \u4FE1"); assertStoredValues(uri, values); } public void testLookupByOrganization() { long rawContactId = createRawContact(); long contactId = queryContactId(rawContactId); ContentValues values = new ContentValues(); values.clear(); values.put(Organization.COMPANY, "acmecorp"); values.put(Organization.TITLE, "president"); Uri organizationUri = insertOrganization(rawContactId, values); assertContactFilter(contactId, "acmecorp"); assertContactFilter(contactId, "president"); values.clear(); values.put(Organization.DEPARTMENT, "software"); mResolver.update(organizationUri, values, null, null); assertContactFilter(contactId, "acmecorp"); assertContactFilter(contactId, "president"); values.clear(); values.put(Organization.COMPANY, "incredibles"); mResolver.update(organizationUri, values, null, null); assertContactFilter(contactId, "incredibles"); assertContactFilter(contactId, "president"); values.clear(); values.put(Organization.TITLE, "director"); mResolver.update(organizationUri, values, null, null); assertContactFilter(contactId, "incredibles"); assertContactFilter(contactId, "director"); values.clear(); values.put(Organization.COMPANY, "monsters"); values.put(Organization.TITLE, "scarer"); mResolver.update(organizationUri, values, null, null); assertContactFilter(contactId, "monsters"); assertContactFilter(contactId, "scarer"); } private void assertContactFilter(long contactId, String filter) { Uri filterUri = Uri.withAppendedPath(Contacts.CONTENT_FILTER_URI, Uri.encode(filter)); assertStoredValue(filterUri, Contacts._ID, contactId); } public void testSearchSnippetOrganization() throws Exception { long rawContactId = createRawContactWithName(); long contactId = queryContactId(rawContactId); // Some random data element insertEmail(rawContactId, "inc@corp.com"); ContentValues values = new ContentValues(); values.clear(); values.put(Organization.COMPANY, "acmecorp"); values.put(Organization.TITLE, "engineer"); Uri organizationUri = insertOrganization(rawContactId, values); // Add another matching organization values.put(Organization.COMPANY, "acmeinc"); insertOrganization(rawContactId, values); // Add another non-matching organization values.put(Organization.COMPANY, "corpacme"); insertOrganization(rawContactId, values); // And another data element insertEmail(rawContactId, "emca@corp.com", true, Email.TYPE_CUSTOM, "Custom"); Uri filterUri = Uri.withAppendedPath(Contacts.CONTENT_FILTER_URI, Uri.encode("acme")); values.clear(); values.put(Contacts._ID, contactId); values.put(SearchSnippetColumns.SNIPPET_DATA_ID, ContentUris.parseId(organizationUri)); values.put(SearchSnippetColumns.SNIPPET_DATA1, "acmecorp"); values.put(SearchSnippetColumns.SNIPPET_DATA4, "engineer"); values.put(SearchSnippetColumns.SNIPPET_MIMETYPE, Organization.CONTENT_ITEM_TYPE); assertStoredValues(filterUri, values); } public void testSearchSnippetEmail() throws Exception { long rawContactId = createRawContact(); long contactId = queryContactId(rawContactId); ContentValues values = new ContentValues(); Uri dataUri = insertEmail(rawContactId, "acme@corp.com", true, Email.TYPE_CUSTOM, "Custom"); Uri filterUri = Uri.withAppendedPath(Contacts.CONTENT_FILTER_URI, Uri.encode("acme")); values.clear(); values.put(Contacts._ID, contactId); values.put(SearchSnippetColumns.SNIPPET_DATA1, "acme@corp.com"); values.put(SearchSnippetColumns.SNIPPET_DATA_ID, ContentUris.parseId(dataUri)); values.put(SearchSnippetColumns.SNIPPET_MIMETYPE, Email.CONTENT_ITEM_TYPE); values.put(SearchSnippetColumns.SNIPPET_DATA2, Email.TYPE_CUSTOM); values.put(SearchSnippetColumns.SNIPPET_DATA3, "Custom"); assertStoredValues(filterUri, values); } public void testSearchSnippetNickname() throws Exception { long rawContactId = createRawContactWithName(); long contactId = queryContactId(rawContactId); ContentValues values = new ContentValues(); Uri dataUri = insertNickname(rawContactId, "Incredible"); Uri filterUri = Uri.withAppendedPath(Contacts.CONTENT_FILTER_URI, Uri.encode("inc")); values.clear(); values.put(Contacts._ID, contactId); values.put(SearchSnippetColumns.SNIPPET_DATA1, "Incredible"); values.put(SearchSnippetColumns.SNIPPET_DATA_ID, ContentUris.parseId(dataUri)); values.put(SearchSnippetColumns.SNIPPET_MIMETYPE, Nickname.CONTENT_ITEM_TYPE); assertStoredValues(filterUri, values); } public void testDisplayNameUpdateFromStructuredNameUpdate() { long rawContactId = createRawContact(); Uri nameUri = insertStructuredName(rawContactId, "Slinky", "Dog"); long contactId = queryContactId(rawContactId); Uri uri = ContentUris.withAppendedId(Contacts.CONTENT_URI, contactId); assertStoredValue(uri, Contacts.DISPLAY_NAME, "Slinky Dog"); ContentValues values = new ContentValues(); values.putNull(StructuredName.FAMILY_NAME); mResolver.update(nameUri, values, null, null); assertStoredValue(uri, Contacts.DISPLAY_NAME, "Slinky"); values.putNull(StructuredName.GIVEN_NAME); mResolver.update(nameUri, values, null, null); assertStoredValue(uri, Contacts.DISPLAY_NAME, null); values.put(StructuredName.FAMILY_NAME, "Dog"); mResolver.update(nameUri, values, null, null); assertStoredValue(uri, Contacts.DISPLAY_NAME, "Dog"); } public void testInsertDataWithContentProviderOperations() throws Exception { ContentProviderOperation cpo1 = ContentProviderOperation.newInsert(RawContacts.CONTENT_URI) .withValues(new ContentValues()) .build(); ContentProviderOperation cpo2 = ContentProviderOperation.newInsert(Data.CONTENT_URI) .withValueBackReference(Data.RAW_CONTACT_ID, 0) .withValue(Data.MIMETYPE, StructuredName.CONTENT_ITEM_TYPE) .withValue(StructuredName.GIVEN_NAME, "John") .withValue(StructuredName.FAMILY_NAME, "Doe") .build(); ContentProviderResult[] results = mResolver.applyBatch(ContactsContract.AUTHORITY, Lists.newArrayList(cpo1, cpo2)); long contactId = queryContactId(ContentUris.parseId(results[0].uri)); Uri uri = ContentUris.withAppendedId(Contacts.CONTENT_URI, contactId); assertStoredValue(uri, Contacts.DISPLAY_NAME, "John Doe"); } public void testSendToVoicemailDefault() { long rawContactId = createRawContactWithName(); long contactId = queryContactId(rawContactId); Cursor c = queryContact(contactId); assertTrue(c.moveToNext()); int sendToVoicemail = c.getInt(c.getColumnIndex(Contacts.SEND_TO_VOICEMAIL)); assertEquals(0, sendToVoicemail); c.close(); } public void testSetSendToVoicemailAndRingtone() { long rawContactId = createRawContactWithName(); long contactId = queryContactId(rawContactId); updateSendToVoicemailAndRingtone(contactId, true, "foo"); assertSendToVoicemailAndRingtone(contactId, true, "foo"); assertNetworkNotified(false); updateSendToVoicemailAndRingtoneWithSelection(contactId, false, "bar"); assertSendToVoicemailAndRingtone(contactId, false, "bar"); assertNetworkNotified(false); } public void testSendToVoicemailAndRingtoneAfterAggregation() { long rawContactId1 = createRawContactWithName("a", "b"); long contactId1 = queryContactId(rawContactId1); updateSendToVoicemailAndRingtone(contactId1, true, "foo"); long rawContactId2 = createRawContactWithName("c", "d"); long contactId2 = queryContactId(rawContactId2); updateSendToVoicemailAndRingtone(contactId2, true, "bar"); // Aggregate them setAggregationException(AggregationExceptions.TYPE_KEEP_TOGETHER, rawContactId1, rawContactId2); // Both contacts had "send to VM", the contact now has the same value assertSendToVoicemailAndRingtone(contactId1, true, "foo,bar"); // Either foo or bar } public void testDoNotSendToVoicemailAfterAggregation() { long rawContactId1 = createRawContactWithName("e", "f"); long contactId1 = queryContactId(rawContactId1); updateSendToVoicemailAndRingtone(contactId1, true, null); long rawContactId2 = createRawContactWithName("g", "h"); long contactId2 = queryContactId(rawContactId2); updateSendToVoicemailAndRingtone(contactId2, false, null); // Aggregate them setAggregationException(AggregationExceptions.TYPE_KEEP_TOGETHER, rawContactId1, rawContactId2); // Since one of the contacts had "don't send to VM" that setting wins for the aggregate assertSendToVoicemailAndRingtone(queryContactId(rawContactId1), false, null); } public void testSetSendToVoicemailAndRingtonePreservedAfterJoinAndSplit() { long rawContactId1 = createRawContactWithName("i", "j"); long contactId1 = queryContactId(rawContactId1); updateSendToVoicemailAndRingtone(contactId1, true, "foo"); long rawContactId2 = createRawContactWithName("k", "l"); long contactId2 = queryContactId(rawContactId2); updateSendToVoicemailAndRingtone(contactId2, false, "bar"); // Aggregate them setAggregationException(AggregationExceptions.TYPE_KEEP_TOGETHER, rawContactId1, rawContactId2); // Split them setAggregationException(AggregationExceptions.TYPE_KEEP_SEPARATE, rawContactId1, rawContactId2); assertSendToVoicemailAndRingtone(queryContactId(rawContactId1), true, "foo"); assertSendToVoicemailAndRingtone(queryContactId(rawContactId2), false, "bar"); } public void testStatusUpdateInsert() { long rawContactId = createRawContact(); Uri imUri = insertImHandle(rawContactId, Im.PROTOCOL_AIM, null, "aim"); long dataId = ContentUris.parseId(imUri); ContentValues values = new ContentValues(); values.put(StatusUpdates.DATA_ID, dataId); values.put(StatusUpdates.PROTOCOL, Im.PROTOCOL_AIM); values.putNull(StatusUpdates.CUSTOM_PROTOCOL); values.put(StatusUpdates.IM_HANDLE, "aim"); values.put(StatusUpdates.PRESENCE, StatusUpdates.INVISIBLE); values.put(StatusUpdates.STATUS, "Hiding"); values.put(StatusUpdates.STATUS_TIMESTAMP, 100); values.put(StatusUpdates.STATUS_RES_PACKAGE, "a.b.c"); values.put(StatusUpdates.STATUS_ICON, 1234); values.put(StatusUpdates.STATUS_LABEL, 2345); Uri resultUri = mResolver.insert(StatusUpdates.CONTENT_URI, values); assertStoredValues(resultUri, values); long contactId = queryContactId(rawContactId); Uri contactUri = ContentUris.withAppendedId(Contacts.CONTENT_URI, contactId); values.clear(); values.put(Contacts.CONTACT_PRESENCE, StatusUpdates.INVISIBLE); values.put(Contacts.CONTACT_STATUS, "Hiding"); values.put(Contacts.CONTACT_STATUS_TIMESTAMP, 100); values.put(Contacts.CONTACT_STATUS_RES_PACKAGE, "a.b.c"); values.put(Contacts.CONTACT_STATUS_ICON, 1234); values.put(Contacts.CONTACT_STATUS_LABEL, 2345); assertStoredValues(contactUri, values); values.clear(); values.put(StatusUpdates.DATA_ID, dataId); values.put(StatusUpdates.STATUS, "Cloaked"); values.put(StatusUpdates.STATUS_TIMESTAMP, 200); values.put(StatusUpdates.STATUS_RES_PACKAGE, "d.e.f"); values.put(StatusUpdates.STATUS_ICON, 4321); values.put(StatusUpdates.STATUS_LABEL, 5432); mResolver.insert(StatusUpdates.CONTENT_URI, values); values.clear(); values.put(Contacts.CONTACT_PRESENCE, StatusUpdates.INVISIBLE); values.put(Contacts.CONTACT_STATUS, "Cloaked"); values.put(Contacts.CONTACT_STATUS_TIMESTAMP, 200); values.put(Contacts.CONTACT_STATUS_RES_PACKAGE, "d.e.f"); values.put(Contacts.CONTACT_STATUS_ICON, 4321); values.put(Contacts.CONTACT_STATUS_LABEL, 5432); assertStoredValues(contactUri, values); } public void testStatusUpdateInferAttribution() { long rawContactId = createRawContact(); Uri imUri = insertImHandle(rawContactId, Im.PROTOCOL_AIM, null, "aim"); long dataId = ContentUris.parseId(imUri); ContentValues values = new ContentValues(); values.put(StatusUpdates.DATA_ID, dataId); values.put(StatusUpdates.PROTOCOL, Im.PROTOCOL_AIM); values.put(StatusUpdates.IM_HANDLE, "aim"); values.put(StatusUpdates.STATUS, "Hiding"); Uri resultUri = mResolver.insert(StatusUpdates.CONTENT_URI, values); values.clear(); values.put(StatusUpdates.DATA_ID, dataId); values.put(StatusUpdates.STATUS_LABEL, com.android.internal.R.string.imProtocolAim); values.put(StatusUpdates.STATUS, "Hiding"); assertStoredValues(resultUri, values); } public void testStatusUpdateMatchingImOrEmail() { long rawContactId = createRawContact(); insertImHandle(rawContactId, Im.PROTOCOL_AIM, null, "aim"); insertImHandle(rawContactId, Im.PROTOCOL_CUSTOM, "my_im_proto", "my_im"); insertEmail(rawContactId, "m@acme.com"); // Match on IM (standard) insertStatusUpdate(Im.PROTOCOL_AIM, null, "aim", StatusUpdates.AVAILABLE, "Available"); // Match on IM (custom) insertStatusUpdate(Im.PROTOCOL_CUSTOM, "my_im_proto", "my_im", StatusUpdates.IDLE, "Idle"); // Match on Email insertStatusUpdate(Im.PROTOCOL_GOOGLE_TALK, null, "m@acme.com", StatusUpdates.AWAY, "Away"); // No match insertStatusUpdate(Im.PROTOCOL_ICQ, null, "12345", StatusUpdates.DO_NOT_DISTURB, "Go away"); Cursor c = mResolver.query(StatusUpdates.CONTENT_URI, new String[] { StatusUpdates.DATA_ID, StatusUpdates.PROTOCOL, StatusUpdates.CUSTOM_PROTOCOL, StatusUpdates.PRESENCE, StatusUpdates.STATUS}, PresenceColumns.RAW_CONTACT_ID + "=" + rawContactId, null, StatusUpdates.DATA_ID); assertTrue(c.moveToNext()); assertStatusUpdate(c, Im.PROTOCOL_AIM, null, StatusUpdates.AVAILABLE, "Available"); assertTrue(c.moveToNext()); assertStatusUpdate(c, Im.PROTOCOL_CUSTOM, "my_im_proto", StatusUpdates.IDLE, "Idle"); assertTrue(c.moveToNext()); assertStatusUpdate(c, Im.PROTOCOL_GOOGLE_TALK, null, StatusUpdates.AWAY, "Away"); assertFalse(c.moveToNext()); c.close(); long contactId = queryContactId(rawContactId); Uri contactUri = ContentUris.withAppendedId(Contacts.CONTENT_URI, contactId); ContentValues values = new ContentValues(); values.put(Contacts.CONTACT_PRESENCE, StatusUpdates.AVAILABLE); values.put(Contacts.CONTACT_STATUS, "Available"); assertStoredValuesWithProjection(contactUri, values); } public void testStatusUpdateUpdateAndDelete() { long rawContactId = createRawContact(); insertImHandle(rawContactId, Im.PROTOCOL_AIM, null, "aim"); long contactId = queryContactId(rawContactId); Uri contactUri = ContentUris.withAppendedId(Contacts.CONTENT_URI, contactId); ContentValues values = new ContentValues(); values.putNull(Contacts.CONTACT_PRESENCE); values.putNull(Contacts.CONTACT_STATUS); assertStoredValuesWithProjection(contactUri, values); insertStatusUpdate(Im.PROTOCOL_AIM, null, "aim", StatusUpdates.AWAY, "BUSY"); insertStatusUpdate(Im.PROTOCOL_AIM, null, "aim", StatusUpdates.DO_NOT_DISTURB, "GO AWAY"); Uri statusUri = insertStatusUpdate(Im.PROTOCOL_AIM, null, "aim", StatusUpdates.AVAILABLE, "Available"); long statusId = ContentUris.parseId(statusUri); values.put(Contacts.CONTACT_PRESENCE, StatusUpdates.AVAILABLE); values.put(Contacts.CONTACT_STATUS, "Available"); assertStoredValuesWithProjection(contactUri, values); // update status_updates table to set new values for // status_updates.status // status_updates.status_ts // presence long updatedTs = 200; String testUpdate = "test_update"; String selection = StatusUpdates.DATA_ID + "=" + statusId; values.clear(); values.put(StatusUpdates.STATUS_TIMESTAMP, updatedTs); values.put(StatusUpdates.STATUS, testUpdate); values.put(StatusUpdates.PRESENCE, "presence_test"); mResolver.update(StatusUpdates.CONTENT_URI, values, StatusUpdates.DATA_ID + "=" + statusId, null); assertStoredValuesWithProjection(StatusUpdates.CONTENT_URI, values); // update status_updates table to set new values for columns in status_updates table ONLY // i.e., no rows in presence table are to be updated. updatedTs = 300; testUpdate = "test_update_new"; selection = StatusUpdates.DATA_ID + "=" + statusId; values.clear(); values.put(StatusUpdates.STATUS_TIMESTAMP, updatedTs); values.put(StatusUpdates.STATUS, testUpdate); mResolver.update(StatusUpdates.CONTENT_URI, values, StatusUpdates.DATA_ID + "=" + statusId, null); // make sure the presence column value is still the old value values.put(StatusUpdates.PRESENCE, "presence_test"); assertStoredValuesWithProjection(StatusUpdates.CONTENT_URI, values); // update status_updates table to set new values for columns in presence table ONLY // i.e., no rows in status_updates table are to be updated. selection = StatusUpdates.DATA_ID + "=" + statusId; values.clear(); values.put(StatusUpdates.PRESENCE, "presence_test_new"); mResolver.update(StatusUpdates.CONTENT_URI, values, StatusUpdates.DATA_ID + "=" + statusId, null); // make sure the status_updates table is not updated values.put(StatusUpdates.STATUS_TIMESTAMP, updatedTs); values.put(StatusUpdates.STATUS, testUpdate); assertStoredValuesWithProjection(StatusUpdates.CONTENT_URI, values); // effect "delete status_updates" operation and expect the following // data deleted from status_updates table // presence set to null mResolver.delete(StatusUpdates.CONTENT_URI, StatusUpdates.DATA_ID + "=" + statusId, null); values.clear(); values.putNull(Contacts.CONTACT_PRESENCE); assertStoredValuesWithProjection(contactUri, values); } public void testStatusUpdateWithTimestamp() { long rawContactId = createRawContact(); insertImHandle(rawContactId, Im.PROTOCOL_AIM, null, "aim"); insertImHandle(rawContactId, Im.PROTOCOL_GOOGLE_TALK, null, "gtalk"); long contactId = queryContactId(rawContactId); Uri contactUri = ContentUris.withAppendedId(Contacts.CONTENT_URI, contactId); insertStatusUpdate(Im.PROTOCOL_AIM, null, "aim", 0, "Offline", 80); insertStatusUpdate(Im.PROTOCOL_AIM, null, "aim", 0, "Available", 100); insertStatusUpdate(Im.PROTOCOL_GOOGLE_TALK, null, "gtalk", 0, "Busy", 90); // Should return the latest status ContentValues values = new ContentValues(); values.put(Contacts.CONTACT_STATUS_TIMESTAMP, 100); values.put(Contacts.CONTACT_STATUS, "Available"); assertStoredValuesWithProjection(contactUri, values); } private void assertStatusUpdate(Cursor c, int protocol, String customProtocol, int presence, String status) { ContentValues values = new ContentValues(); values.put(StatusUpdates.PROTOCOL, protocol); values.put(StatusUpdates.CUSTOM_PROTOCOL, customProtocol); values.put(StatusUpdates.PRESENCE_STATUS, presence); values.put(StatusUpdates.STATUS, status); assertCursorValues(c, values); } public void testSingleStatusUpdateRowPerContact() { int protocol1 = Im.PROTOCOL_GOOGLE_TALK; String handle1 = "test@gmail.com"; long rawContactId1 = createRawContact(); insertImHandle(rawContactId1, protocol1, null, handle1); insertStatusUpdate(protocol1, null, handle1, StatusUpdates.AVAILABLE, "Green"); insertStatusUpdate(protocol1, null, handle1, StatusUpdates.AWAY, "Yellow"); insertStatusUpdate(protocol1, null, handle1, StatusUpdates.INVISIBLE, "Red"); Cursor c = queryContact(queryContactId(rawContactId1), new String[] {Contacts.CONTACT_PRESENCE, Contacts.CONTACT_STATUS}); assertEquals(1, c.getCount()); c.moveToFirst(); assertEquals(StatusUpdates.INVISIBLE, c.getInt(0)); assertEquals("Red", c.getString(1)); c.close(); } private void updateSendToVoicemailAndRingtone(long contactId, boolean sendToVoicemail, String ringtone) { ContentValues values = new ContentValues(); values.put(Contacts.SEND_TO_VOICEMAIL, sendToVoicemail); if (ringtone != null) { values.put(Contacts.CUSTOM_RINGTONE, ringtone); } final Uri uri = ContentUris.withAppendedId(Contacts.CONTENT_URI, contactId); int count = mResolver.update(uri, values, null, null); assertEquals(1, count); } private void updateSendToVoicemailAndRingtoneWithSelection(long contactId, boolean sendToVoicemail, String ringtone) { ContentValues values = new ContentValues(); values.put(Contacts.SEND_TO_VOICEMAIL, sendToVoicemail); if (ringtone != null) { values.put(Contacts.CUSTOM_RINGTONE, ringtone); } int count = mResolver.update(Contacts.CONTENT_URI, values, Contacts._ID + "=" + contactId, null); assertEquals(1, count); } private void assertSendToVoicemailAndRingtone(long contactId, boolean expectedSendToVoicemail, String expectedRingtone) { Cursor c = queryContact(contactId); assertTrue(c.moveToNext()); int sendToVoicemail = c.getInt(c.getColumnIndex(Contacts.SEND_TO_VOICEMAIL)); assertEquals(expectedSendToVoicemail ? 1 : 0, sendToVoicemail); String ringtone = c.getString(c.getColumnIndex(Contacts.CUSTOM_RINGTONE)); if (expectedRingtone == null) { assertNull(ringtone); } else { assertTrue(ArrayUtils.contains(expectedRingtone.split(","), ringtone)); } c.close(); } public void testGroupCreationAfterMembershipInsert() { long rawContactId1 = createRawContact(mAccount); Uri groupMembershipUri = insertGroupMembership(rawContactId1, "gsid1"); long groupId = assertSingleGroup(NO_LONG, mAccount, "gsid1", null); assertSingleGroupMembership(ContentUris.parseId(groupMembershipUri), rawContactId1, groupId, "gsid1"); } public void testGroupReuseAfterMembershipInsert() { long rawContactId1 = createRawContact(mAccount); long groupId1 = createGroup(mAccount, "gsid1", "title1"); Uri groupMembershipUri = insertGroupMembership(rawContactId1, "gsid1"); assertSingleGroup(groupId1, mAccount, "gsid1", "title1"); assertSingleGroupMembership(ContentUris.parseId(groupMembershipUri), rawContactId1, groupId1, "gsid1"); } public void testGroupInsertFailureOnGroupIdConflict() { long rawContactId1 = createRawContact(mAccount); long groupId1 = createGroup(mAccount, "gsid1", "title1"); ContentValues values = new ContentValues(); values.put(GroupMembership.RAW_CONTACT_ID, rawContactId1); values.put(GroupMembership.MIMETYPE, GroupMembership.CONTENT_ITEM_TYPE); values.put(GroupMembership.GROUP_SOURCE_ID, "gsid1"); values.put(GroupMembership.GROUP_ROW_ID, groupId1); try { mResolver.insert(Data.CONTENT_URI, values); fail("the insert was expected to fail, but it succeeded"); } catch (IllegalArgumentException e) { // this was expected } } public void testContactVisibilityUpdateOnMembershipChange() { long rawContactId = createRawContact(mAccount); assertVisibility(rawContactId, "0"); long visibleGroupId = createGroup(mAccount, "123", "Visible", 1); long invisibleGroupId = createGroup(mAccount, "567", "Invisible", 0); Uri membership1 = insertGroupMembership(rawContactId, visibleGroupId); assertVisibility(rawContactId, "1"); Uri membership2 = insertGroupMembership(rawContactId, invisibleGroupId); assertVisibility(rawContactId, "1"); mResolver.delete(membership1, null, null); assertVisibility(rawContactId, "0"); ContentValues values = new ContentValues(); values.put(GroupMembership.GROUP_ROW_ID, visibleGroupId); mResolver.update(membership2, values, null, null); assertVisibility(rawContactId, "1"); } private void assertVisibility(long rawContactId, String expectedValue) { assertStoredValue(Contacts.CONTENT_URI, Contacts._ID + "=" + queryContactId(rawContactId), null, Contacts.IN_VISIBLE_GROUP, expectedValue); } public void testContentEntityIterator() throws RemoteException { // create multiple contacts and check that the selected ones are returned long id; long groupId1 = createGroup(mAccount, "gsid1", "title1"); long groupId2 = createGroup(mAccount, "gsid2", "title2"); id = createRawContact(mAccount, RawContacts.SOURCE_ID, "c0"); insertGroupMembership(id, "gsid1"); insertEmail(id, "c0@email.com"); insertPhoneNumber(id, "5551212c0"); long c1 = id = createRawContact(mAccount, RawContacts.SOURCE_ID, "c1"); Uri id_1_0 = insertGroupMembership(id, "gsid1"); Uri id_1_1 = insertGroupMembership(id, "gsid2"); Uri id_1_2 = insertEmail(id, "c1@email.com"); Uri id_1_3 = insertPhoneNumber(id, "5551212c1"); long c2 = id = createRawContact(mAccount, RawContacts.SOURCE_ID, "c2"); Uri id_2_0 = insertGroupMembership(id, "gsid1"); Uri id_2_1 = insertEmail(id, "c2@email.com"); Uri id_2_2 = insertPhoneNumber(id, "5551212c2"); long c3 = id = createRawContact(mAccount, RawContacts.SOURCE_ID, "c3"); Uri id_3_0 = insertGroupMembership(id, groupId2); Uri id_3_1 = insertEmail(id, "c3@email.com"); Uri id_3_2 = insertPhoneNumber(id, "5551212c3"); EntityIterator iterator = RawContacts.newEntityIterator(mResolver.query( maybeAddAccountQueryParameters(RawContactsEntity.CONTENT_URI, mAccount), null, RawContacts.SOURCE_ID + " in ('c1', 'c2', 'c3')", null, null)); Entity entity; ContentValues[] subValues; entity = iterator.next(); assertEquals(c1, (long) entity.getEntityValues().getAsLong(RawContacts._ID)); subValues = asSortedContentValuesArray(entity.getSubValues()); assertEquals(4, subValues.length); assertDataRow(subValues[0], GroupMembership.CONTENT_ITEM_TYPE, Data._ID, id_1_0, GroupMembership.GROUP_ROW_ID, groupId1, GroupMembership.GROUP_SOURCE_ID, "gsid1"); assertDataRow(subValues[1], GroupMembership.CONTENT_ITEM_TYPE, Data._ID, id_1_1, GroupMembership.GROUP_ROW_ID, groupId2, GroupMembership.GROUP_SOURCE_ID, "gsid2"); assertDataRow(subValues[2], Email.CONTENT_ITEM_TYPE, Data._ID, id_1_2, Email.DATA, "c1@email.com"); assertDataRow(subValues[3], Phone.CONTENT_ITEM_TYPE, Data._ID, id_1_3, Email.DATA, "5551212c1"); entity = iterator.next(); assertEquals(c2, (long) entity.getEntityValues().getAsLong(RawContacts._ID)); subValues = asSortedContentValuesArray(entity.getSubValues()); assertEquals(3, subValues.length); assertDataRow(subValues[0], GroupMembership.CONTENT_ITEM_TYPE, Data._ID, id_2_0, GroupMembership.GROUP_ROW_ID, groupId1, GroupMembership.GROUP_SOURCE_ID, "gsid1"); assertDataRow(subValues[1], Email.CONTENT_ITEM_TYPE, Data._ID, id_2_1, Email.DATA, "c2@email.com"); assertDataRow(subValues[2], Phone.CONTENT_ITEM_TYPE, Data._ID, id_2_2, Email.DATA, "5551212c2"); entity = iterator.next(); assertEquals(c3, (long) entity.getEntityValues().getAsLong(RawContacts._ID)); subValues = asSortedContentValuesArray(entity.getSubValues()); assertEquals(3, subValues.length); assertDataRow(subValues[0], GroupMembership.CONTENT_ITEM_TYPE, Data._ID, id_3_0, GroupMembership.GROUP_ROW_ID, groupId2, GroupMembership.GROUP_SOURCE_ID, "gsid2"); assertDataRow(subValues[1], Email.CONTENT_ITEM_TYPE, Data._ID, id_3_1, Email.DATA, "c3@email.com"); assertDataRow(subValues[2], Phone.CONTENT_ITEM_TYPE, Data._ID, id_3_2, Email.DATA, "5551212c3"); assertFalse(iterator.hasNext()); iterator.close(); } public void testDataCreateUpdateDeleteByMimeType() throws Exception { long rawContactId = createRawContact(); ContentValues values = new ContentValues(); values.put(Data.RAW_CONTACT_ID, rawContactId); values.put(Data.MIMETYPE, "testmimetype"); values.put(Data.RES_PACKAGE, "oldpackage"); values.put(Data.IS_PRIMARY, 1); values.put(Data.IS_SUPER_PRIMARY, 1); values.put(Data.DATA1, "old1"); values.put(Data.DATA2, "old2"); values.put(Data.DATA3, "old3"); values.put(Data.DATA4, "old4"); values.put(Data.DATA5, "old5"); values.put(Data.DATA6, "old6"); values.put(Data.DATA7, "old7"); values.put(Data.DATA8, "old8"); values.put(Data.DATA9, "old9"); values.put(Data.DATA10, "old10"); values.put(Data.DATA11, "old11"); values.put(Data.DATA12, "old12"); values.put(Data.DATA13, "old13"); values.put(Data.DATA14, "old14"); values.put(Data.DATA15, "old15"); Uri uri = mResolver.insert(Data.CONTENT_URI, values); assertStoredValues(uri, values); assertNetworkNotified(true); values.clear(); values.put(Data.RES_PACKAGE, "newpackage"); values.put(Data.IS_PRIMARY, 0); values.put(Data.IS_SUPER_PRIMARY, 0); values.put(Data.DATA1, "new1"); values.put(Data.DATA2, "new2"); values.put(Data.DATA3, "new3"); values.put(Data.DATA4, "new4"); values.put(Data.DATA5, "new5"); values.put(Data.DATA6, "new6"); values.put(Data.DATA7, "new7"); values.put(Data.DATA8, "new8"); values.put(Data.DATA9, "new9"); values.put(Data.DATA10, "new10"); values.put(Data.DATA11, "new11"); values.put(Data.DATA12, "new12"); values.put(Data.DATA13, "new13"); values.put(Data.DATA14, "new14"); values.put(Data.DATA15, "new15"); mResolver.update(Data.CONTENT_URI, values, Data.RAW_CONTACT_ID + "=" + rawContactId + " AND " + Data.MIMETYPE + "='testmimetype'", null); assertNetworkNotified(true); // Should not be able to change IS_PRIMARY and IS_SUPER_PRIMARY by the above update values.put(Data.IS_PRIMARY, 1); values.put(Data.IS_SUPER_PRIMARY, 1); assertStoredValues(uri, values); int count = mResolver.delete(Data.CONTENT_URI, Data.RAW_CONTACT_ID + "=" + rawContactId + " AND " + Data.MIMETYPE + "='testmimetype'", null); assertEquals(1, count); assertEquals(0, getCount(Data.CONTENT_URI, Data.RAW_CONTACT_ID + "=" + rawContactId + " AND " + Data.MIMETYPE + "='testmimetype'", null)); assertNetworkNotified(true); } public void testRawContactQuery() { Account account1 = new Account("a", "b"); Account account2 = new Account("c", "d"); long rawContactId1 = createRawContact(account1); long rawContactId2 = createRawContact(account2); Uri uri1 = maybeAddAccountQueryParameters(RawContacts.CONTENT_URI, account1); Uri uri2 = maybeAddAccountQueryParameters(RawContacts.CONTENT_URI, account2); assertEquals(1, getCount(uri1, null, null)); assertEquals(1, getCount(uri2, null, null)); assertStoredValue(uri1, RawContacts._ID, rawContactId1) ; assertStoredValue(uri2, RawContacts._ID, rawContactId2) ; Uri rowUri1 = ContentUris.withAppendedId(uri1, rawContactId1); Uri rowUri2 = ContentUris.withAppendedId(uri2, rawContactId2); assertStoredValue(rowUri1, RawContacts._ID, rawContactId1) ; assertStoredValue(rowUri2, RawContacts._ID, rawContactId2) ; } public void testRawContactDeletion() { long rawContactId = createRawContact(mAccount); Uri uri = ContentUris.withAppendedId(RawContacts.CONTENT_URI, rawContactId); insertImHandle(rawContactId, Im.PROTOCOL_GOOGLE_TALK, null, "deleteme@android.com"); insertStatusUpdate(Im.PROTOCOL_GOOGLE_TALK, null, "deleteme@android.com", StatusUpdates.AVAILABLE, null); long contactId = queryContactId(rawContactId); assertEquals(1, getCount(Uri.withAppendedPath(uri, RawContacts.Data.CONTENT_DIRECTORY), null, null)); assertEquals(1, getCount(StatusUpdates.CONTENT_URI, PresenceColumns.RAW_CONTACT_ID + "=" + rawContactId, null)); mResolver.delete(uri, null, null); assertStoredValue(uri, RawContacts.DELETED, "1"); assertNetworkNotified(true); Uri permanentDeletionUri = setCallerIsSyncAdapter(uri, mAccount); mResolver.delete(permanentDeletionUri, null, null); assertEquals(0, getCount(uri, null, null)); assertEquals(0, getCount(Uri.withAppendedPath(uri, RawContacts.Data.CONTENT_DIRECTORY), null, null)); assertEquals(0, getCount(StatusUpdates.CONTENT_URI, PresenceColumns.RAW_CONTACT_ID + "=" + rawContactId, null)); assertEquals(0, getCount(Contacts.CONTENT_URI, Contacts._ID + "=" + contactId, null)); assertNetworkNotified(false); } public void testRawContactDeletionKeepingAggregateContact() { long rawContactId1 = createRawContactWithName(mAccount); long rawContactId2 = createRawContactWithName(mAccount); // Same name - should be aggregated assertAggregated(rawContactId1, rawContactId2); long contactId = queryContactId(rawContactId1); Uri uri = ContentUris.withAppendedId(RawContacts.CONTENT_URI, rawContactId1); Uri permanentDeletionUri = setCallerIsSyncAdapter(uri, mAccount); mResolver.delete(permanentDeletionUri, null, null); assertEquals(0, getCount(uri, null, null)); assertEquals(1, getCount(Contacts.CONTENT_URI, Contacts._ID + "=" + contactId, null)); } public void testRawContactDeletionWithAccounts() { long rawContactId = createRawContact(mAccount); Uri uri = ContentUris.withAppendedId(RawContacts.CONTENT_URI, rawContactId); insertImHandle(rawContactId, Im.PROTOCOL_GOOGLE_TALK, null, "deleteme@android.com"); insertStatusUpdate(Im.PROTOCOL_GOOGLE_TALK, null, "deleteme@android.com", StatusUpdates.AVAILABLE, null); assertEquals(1, getCount(Uri.withAppendedPath(uri, RawContacts.Data.CONTENT_DIRECTORY), null, null)); assertEquals(1, getCount(StatusUpdates.CONTENT_URI, PresenceColumns.RAW_CONTACT_ID + "=" + rawContactId, null)); // Do not delete if we are deleting with wrong account. Uri deleteWithWrongAccountUri = RawContacts.CONTENT_URI.buildUpon() .appendQueryParameter(ContactsContract.RawContacts.ACCOUNT_NAME, mAccountTwo.name) .appendQueryParameter(ContactsContract.RawContacts.ACCOUNT_TYPE, mAccountTwo.type) .build(); mResolver.delete(deleteWithWrongAccountUri, null, null); assertStoredValue(uri, RawContacts.DELETED, "0"); // Delete if we are deleting with correct account. Uri deleteWithCorrectAccountUri = RawContacts.CONTENT_URI.buildUpon() .appendQueryParameter(ContactsContract.RawContacts.ACCOUNT_NAME, mAccount.name) .appendQueryParameter(ContactsContract.RawContacts.ACCOUNT_TYPE, mAccount.type) .build(); mResolver.delete(deleteWithCorrectAccountUri, null, null); assertStoredValue(uri, RawContacts.DELETED, "1"); } public void testAccountsUpdated() { // This is to ensure we do not delete contacts with null, null (account name, type) // accidentally. long rawContactId3 = createRawContactWithName("James", "Sullivan"); insertPhoneNumber(rawContactId3, "5234567890"); Uri rawContact3 = ContentUris.withAppendedId(RawContacts.CONTENT_URI, rawContactId3); assertEquals(1, getCount(RawContacts.CONTENT_URI, null, null)); ContactsProvider2 cp = (ContactsProvider2) getProvider(); cp.onAccountsUpdated(new Account[]{mAccount, mAccountTwo}); assertEquals(1, getCount(RawContacts.CONTENT_URI, null, null)); assertStoredValue(rawContact3, RawContacts.ACCOUNT_NAME, null); assertStoredValue(rawContact3, RawContacts.ACCOUNT_TYPE, null); long rawContactId1 = createRawContact(mAccount); insertEmail(rawContactId1, "account1@email.com"); long rawContactId2 = createRawContact(mAccountTwo); insertEmail(rawContactId2, "account2@email.com"); insertImHandle(rawContactId2, Im.PROTOCOL_GOOGLE_TALK, null, "deleteme@android.com"); insertStatusUpdate(Im.PROTOCOL_GOOGLE_TALK, null, "deleteme@android.com", StatusUpdates.AVAILABLE, null); cp.onAccountsUpdated(new Account[]{mAccount}); assertEquals(2, getCount(RawContacts.CONTENT_URI, null, null)); assertEquals(0, getCount(StatusUpdates.CONTENT_URI, PresenceColumns.RAW_CONTACT_ID + "=" + rawContactId2, null)); } public void testAccountDeletion() { Account readOnlyAccount = new Account("act", READ_ONLY_ACCOUNT_TYPE); ContactsProvider2 cp = (ContactsProvider2) getProvider(); cp.onAccountsUpdated(new Account[]{readOnlyAccount, mAccount}); long rawContactId1 = createRawContactWithName("John", "Doe", readOnlyAccount); Uri photoUri1 = insertPhoto(rawContactId1); long rawContactId2 = createRawContactWithName("john", "doe", mAccount); Uri photoUri2 = insertPhoto(rawContactId2); storeValue(photoUri2, Photo.IS_SUPER_PRIMARY, "1"); assertAggregated(rawContactId1, rawContactId2); long contactId = queryContactId(rawContactId1); // The display name should come from the writable account assertStoredValue(Uri.withAppendedPath( ContentUris.withAppendedId(Contacts.CONTENT_URI, contactId), Contacts.Data.CONTENT_DIRECTORY), Contacts.DISPLAY_NAME, "john doe"); // The photo should be the one we marked as super-primary assertStoredValue(Contacts.CONTENT_URI, contactId, Contacts.PHOTO_ID, ContentUris.parseId(photoUri2)); // Remove the writable account cp.onAccountsUpdated(new Account[]{readOnlyAccount}); // The display name should come from the remaining account assertStoredValue(Uri.withAppendedPath( ContentUris.withAppendedId(Contacts.CONTENT_URI, contactId), Contacts.Data.CONTENT_DIRECTORY), Contacts.DISPLAY_NAME, "John Doe"); // The photo should be the remaining one assertStoredValue(Contacts.CONTENT_URI, contactId, Contacts.PHOTO_ID, ContentUris.parseId(photoUri1)); } public void testContactDeletion() { long rawContactId1 = createRawContactWithName("John", "Doe"); long rawContactId2 = createRawContactWithName("John", "Doe"); long contactId = queryContactId(rawContactId1); mResolver.delete(ContentUris.withAppendedId(Contacts.CONTENT_URI, contactId), null, null); assertStoredValue(ContentUris.withAppendedId(RawContacts.CONTENT_URI, rawContactId1), RawContacts.DELETED, "1"); assertStoredValue(ContentUris.withAppendedId(RawContacts.CONTENT_URI, rawContactId2), RawContacts.DELETED, "1"); } public void testMarkAsDirtyParameter() { long rawContactId = createRawContact(mAccount); Uri rawContactUri = ContentUris.withAppendedId(RawContacts.CONTENT_URI, rawContactId); Uri uri = insertStructuredName(rawContactId, "John", "Doe"); clearDirty(rawContactUri); Uri updateUri = setCallerIsSyncAdapter(uri, mAccount); ContentValues values = new ContentValues(); values.put(StructuredName.FAMILY_NAME, "Dough"); mResolver.update(updateUri, values, null, null); assertStoredValue(uri, StructuredName.FAMILY_NAME, "Dough"); assertDirty(rawContactUri, false); assertNetworkNotified(false); } public void testRawContactDirtyAndVersion() { final long rawContactId = createRawContact(mAccount); Uri uri = ContentUris.withAppendedId(ContactsContract.RawContacts.CONTENT_URI, rawContactId); assertDirty(uri, false); long version = getVersion(uri); ContentValues values = new ContentValues(); values.put(ContactsContract.RawContacts.DIRTY, 0); values.put(ContactsContract.RawContacts.SEND_TO_VOICEMAIL, 1); values.put(ContactsContract.RawContacts.AGGREGATION_MODE, RawContacts.AGGREGATION_MODE_IMMEDIATE); values.put(ContactsContract.RawContacts.STARRED, 1); assertEquals(1, mResolver.update(uri, values, null, null)); assertEquals(version, getVersion(uri)); assertDirty(uri, false); assertNetworkNotified(false); Uri emailUri = insertEmail(rawContactId, "goo@woo.com"); assertDirty(uri, true); assertNetworkNotified(true); ++version; assertEquals(version, getVersion(uri)); clearDirty(uri); values = new ContentValues(); values.put(Email.DATA, "goo@hoo.com"); mResolver.update(emailUri, values, null, null); assertDirty(uri, true); assertNetworkNotified(true); ++version; assertEquals(version, getVersion(uri)); clearDirty(uri); mResolver.delete(emailUri, null, null); assertDirty(uri, true); assertNetworkNotified(true); ++version; assertEquals(version, getVersion(uri)); } public void testRawContactClearDirty() { final long rawContactId = createRawContact(mAccount); Uri uri = ContentUris.withAppendedId(ContactsContract.RawContacts.CONTENT_URI, rawContactId); long version = getVersion(uri); insertEmail(rawContactId, "goo@woo.com"); assertDirty(uri, true); version++; assertEquals(version, getVersion(uri)); clearDirty(uri); assertDirty(uri, false); assertEquals(version, getVersion(uri)); } public void testRawContactDeletionSetsDirty() { final long rawContactId = createRawContact(mAccount); Uri uri = ContentUris.withAppendedId(ContactsContract.RawContacts.CONTENT_URI, rawContactId); long version = getVersion(uri); clearDirty(uri); assertDirty(uri, false); mResolver.delete(uri, null, null); assertStoredValue(uri, RawContacts.DELETED, "1"); assertDirty(uri, true); assertNetworkNotified(true); version++; assertEquals(version, getVersion(uri)); } public void testDeleteContactWithoutName() { Uri rawContactUri = mResolver.insert(RawContacts.CONTENT_URI, new ContentValues()); long rawContactId = ContentUris.parseId(rawContactUri); Uri phoneUri = insertPhoneNumber(rawContactId, "555-123-45678", true); long contactId = queryContactId(rawContactId); Uri contactUri = ContentUris.withAppendedId(Contacts.CONTENT_URI, contactId); Uri lookupUri = Contacts.getLookupUri(mResolver, contactUri); int numDeleted = mResolver.delete(lookupUri, null, null); assertEquals(1, numDeleted); } public void testDeleteContactWithoutAnyData() { Uri rawContactUri = mResolver.insert(RawContacts.CONTENT_URI, new ContentValues()); long rawContactId = ContentUris.parseId(rawContactUri); long contactId = queryContactId(rawContactId); Uri contactUri = ContentUris.withAppendedId(Contacts.CONTENT_URI, contactId); Uri lookupUri = Contacts.getLookupUri(mResolver, contactUri); int numDeleted = mResolver.delete(lookupUri, null, null); assertEquals(1, numDeleted); } public void testDeleteContactWithEscapedUri() { ContentValues values = new ContentValues(); values.put(RawContacts.SOURCE_ID, "!@#$%^&*()_+=-/.,<>?;'\":[]}{\\|`~"); Uri rawContactUri = mResolver.insert(RawContacts.CONTENT_URI, values); long rawContactId = ContentUris.parseId(rawContactUri); long contactId = queryContactId(rawContactId); Uri contactUri = ContentUris.withAppendedId(Contacts.CONTENT_URI, contactId); Uri lookupUri = Contacts.getLookupUri(mResolver, contactUri); assertEquals(1, mResolver.delete(lookupUri, null, null)); } public void testQueryContactWithEscapedUri() { ContentValues values = new ContentValues(); values.put(RawContacts.SOURCE_ID, "!@#$%^&*()_+=-/.,<>?;'\":[]}{\\|`~"); Uri rawContactUri = mResolver.insert(RawContacts.CONTENT_URI, values); long rawContactId = ContentUris.parseId(rawContactUri); long contactId = queryContactId(rawContactId); Uri contactUri = ContentUris.withAppendedId(Contacts.CONTENT_URI, contactId); Uri lookupUri = Contacts.getLookupUri(mResolver, contactUri); Cursor c = mResolver.query(lookupUri, null, null, null, ""); assertEquals(1, c.getCount()); c.close(); } public void testGetPhotoUri() { ContentValues values = new ContentValues(); Uri rawContactUri = mResolver.insert(RawContacts.CONTENT_URI, values); long rawContactId = ContentUris.parseId(rawContactUri); insertStructuredName(rawContactId, "John", "Doe"); Uri photoUri = insertPhoto(rawContactId); Uri twigUri = Uri.withAppendedPath(ContentUris.withAppendedId(Contacts.CONTENT_URI, queryContactId(rawContactId)), Contacts.Photo.CONTENT_DIRECTORY); long twigId = Long.parseLong(getStoredValue(twigUri, Data._ID)); assertEquals(ContentUris.parseId(photoUri), twigId); } public void testOpenAssertFileDescriptorForPhoto() throws Exception { long rawContactId = createRawContact(); Uri photoUri = insertPhoto(rawContactId); AssetFileDescriptor fd = mResolver.openAssetFileDescriptor(photoUri, "r"); assertEquals(loadTestPhoto().length, fd.getLength()); Uri contactPhotoUri = Uri.withAppendedPath( ContentUris.withAppendedId(Contacts.CONTENT_URI, queryContactId(rawContactId)), Contacts.Photo.CONTENT_DIRECTORY); fd = mResolver.openAssetFileDescriptor(contactPhotoUri, "r"); assertEquals(loadTestPhoto().length, fd.getLength()); } public void testSuperPrimaryPhoto() { long rawContactId1 = createRawContact(new Account("a", "a")); Uri photoUri1 = insertPhoto(rawContactId1); long photoId1 = ContentUris.parseId(photoUri1); long rawContactId2 = createRawContact(new Account("b", "b")); Uri photoUri2 = insertPhoto(rawContactId2); long photoId2 = ContentUris.parseId(photoUri2); setAggregationException(AggregationExceptions.TYPE_KEEP_TOGETHER, rawContactId1, rawContactId2); Uri contactUri = ContentUris.withAppendedId(Contacts.CONTENT_URI, queryContactId(rawContactId1)); assertStoredValue(contactUri, Contacts.PHOTO_ID, photoId1); setAggregationException(AggregationExceptions.TYPE_KEEP_SEPARATE, rawContactId1, rawContactId2); ContentValues values = new ContentValues(); values.put(Data.IS_SUPER_PRIMARY, 1); mResolver.update(photoUri2, values, null, null); setAggregationException(AggregationExceptions.TYPE_KEEP_TOGETHER, rawContactId1, rawContactId2); contactUri = ContentUris.withAppendedId(Contacts.CONTENT_URI, queryContactId(rawContactId1)); assertStoredValue(contactUri, Contacts.PHOTO_ID, photoId2); mResolver.update(photoUri1, values, null, null); assertStoredValue(contactUri, Contacts.PHOTO_ID, photoId1); } public void testUpdatePhoto() { ContentValues values = new ContentValues(); Uri rawContactUri = mResolver.insert(RawContacts.CONTENT_URI, values); long rawContactId = ContentUris.parseId(rawContactUri); insertStructuredName(rawContactId, "John", "Doe"); Uri twigUri = Uri.withAppendedPath(ContentUris.withAppendedId(Contacts.CONTENT_URI, queryContactId(rawContactId)), Contacts.Photo.CONTENT_DIRECTORY); values.clear(); values.put(Data.RAW_CONTACT_ID, rawContactId); values.put(Data.MIMETYPE, Photo.CONTENT_ITEM_TYPE); values.putNull(Photo.PHOTO); Uri dataUri = mResolver.insert(Data.CONTENT_URI, values); long photoId = ContentUris.parseId(dataUri); assertNull(getStoredValue(twigUri, Data._ID)); values.clear(); values.put(Photo.PHOTO, loadTestPhoto()); mResolver.update(dataUri, values, null, null); assertNetworkNotified(true); long twigId = Long.parseLong(getStoredValue(twigUri, Data._ID)); assertEquals(photoId, twigId); } public void testUpdateRawContactDataPhoto() { // setup a contact with a null photo ContentValues values = new ContentValues(); Uri rawContactUri = mResolver.insert(RawContacts.CONTENT_URI, values); long rawContactId = ContentUris.parseId(rawContactUri); // setup a photo values.put(Data.RAW_CONTACT_ID, rawContactId); values.put(Data.MIMETYPE, Photo.CONTENT_ITEM_TYPE); values.putNull(Photo.PHOTO); // try to do an update before insert should return count == 0 Uri dataUri = Uri.withAppendedPath( ContentUris.withAppendedId(RawContacts.CONTENT_URI, rawContactId), RawContacts.Data.CONTENT_DIRECTORY); assertEquals(0, mResolver.update(dataUri, values, Data.MIMETYPE + "=?", new String[] {Photo.CONTENT_ITEM_TYPE})); mResolver.insert(Data.CONTENT_URI, values); // save a photo to the db values.clear(); values.put(Data.MIMETYPE, Photo.CONTENT_ITEM_TYPE); values.put(Photo.PHOTO, loadTestPhoto()); assertEquals(1, mResolver.update(dataUri, values, Data.MIMETYPE + "=?", new String[] {Photo.CONTENT_ITEM_TYPE})); // verify the photo Cursor storedPhoto = mResolver.query(dataUri, new String[] {Photo.PHOTO}, Data.MIMETYPE + "=?", new String[] {Photo.CONTENT_ITEM_TYPE}, null); storedPhoto.moveToFirst(); MoreAsserts.assertEquals(loadTestPhoto(), storedPhoto.getBlob(0)); storedPhoto.close(); } public void testUpdateRawContactSetStarred() { long rawContactId1 = createRawContactWithName(); Uri rawContactUri1 = ContentUris.withAppendedId(RawContacts.CONTENT_URI, rawContactId1); long rawContactId2 = createRawContactWithName(); Uri rawContactUri2 = ContentUris.withAppendedId(RawContacts.CONTENT_URI, rawContactId2); assertAggregated(rawContactId1, rawContactId2); long contactId = queryContactId(rawContactId1); Uri contactUri = ContentUris.withAppendedId(Contacts.CONTENT_URI, contactId); assertStoredValue(contactUri, Contacts.STARRED, "0"); ContentValues values = new ContentValues(); values.put(RawContacts.STARRED, "1"); mResolver.update(rawContactUri1, values, null, null); assertStoredValue(rawContactUri1, RawContacts.STARRED, "1"); assertStoredValue(rawContactUri2, RawContacts.STARRED, "0"); assertStoredValue(contactUri, Contacts.STARRED, "1"); values.put(RawContacts.STARRED, "0"); mResolver.update(rawContactUri1, values, null, null); assertStoredValue(rawContactUri1, RawContacts.STARRED, "0"); assertStoredValue(rawContactUri2, RawContacts.STARRED, "0"); assertStoredValue(contactUri, Contacts.STARRED, "0"); values.put(Contacts.STARRED, "1"); mResolver.update(contactUri, values, null, null); assertStoredValue(rawContactUri1, RawContacts.STARRED, "1"); assertStoredValue(rawContactUri2, RawContacts.STARRED, "1"); assertStoredValue(contactUri, Contacts.STARRED, "1"); } public void testLiveFolders() { long rawContactId1 = createRawContactWithName("James", "Sullivan"); insertPhoneNumber(rawContactId1, "5234567890"); long contactId1 = queryContactId(rawContactId1); long rawContactId2 = createRawContactWithName("Mike", "Wazowski"); long contactId2 = queryContactId(rawContactId2); storeValue(Contacts.CONTENT_URI, contactId2, Contacts.STARRED, "1"); long rawContactId3 = createRawContactWithName("Randall", "Boggs"); long contactId3 = queryContactId(rawContactId3); long groupId = createGroup(NO_ACCOUNT, "src1", "VIP"); insertGroupMembership(rawContactId3, groupId); assertLiveFolderContents( Uri.withAppendedPath(ContactsContract.AUTHORITY_URI, "live_folders/contacts"), contactId1, "James Sullivan", contactId2, "Mike Wazowski", contactId3, "Randall Boggs"); assertLiveFolderContents( Uri.withAppendedPath(ContactsContract.AUTHORITY_URI, "live_folders/contacts_with_phones"), contactId1, "James Sullivan"); assertLiveFolderContents( Uri.withAppendedPath(ContactsContract.AUTHORITY_URI, "live_folders/favorites"), contactId2, "Mike Wazowski"); assertLiveFolderContents( Uri.withAppendedPath(Uri.withAppendedPath(ContactsContract.AUTHORITY_URI, "live_folders/contacts"), Uri.encode("VIP")), contactId3, "Randall Boggs"); } private void assertLiveFolderContents(Uri uri, Object... expected) { Cursor c = mResolver.query(uri, new String[]{LiveFolders._ID, LiveFolders.NAME}, null, null, LiveFolders._ID); assertEquals(expected.length/2, c.getCount()); for (int i = 0; i < expected.length/2; i++) { assertTrue(c.moveToNext()); assertEquals(((Long)expected[i * 2]).longValue(), c.getLong(0)); assertEquals(expected[i * 2 + 1], c.getString(1)); } c.close(); } public void testContactCounts() { Uri uri = Contacts.CONTENT_URI.buildUpon() .appendQueryParameter(ContactCounts.ADDRESS_BOOK_INDEX_EXTRAS, "true").build(); createRawContact(); createRawContactWithName("James", "Sullivan"); createRawContactWithName("The Abominable", "Snowman"); createRawContactWithName("Mike", "Wazowski"); createRawContactWithName("randall", "boggs"); createRawContactWithName("Boo", null); createRawContactWithName("Mary", null); createRawContactWithName("Roz", null); Cursor cursor = mResolver.query(uri, new String[]{Contacts.DISPLAY_NAME}, null, null, Contacts.SORT_KEY_PRIMARY + " COLLATE LOCALIZED"); assertFirstLetterValues(cursor, null, "B", "J", "M", "R", "T"); assertFirstLetterCounts(cursor, 1, 1, 1, 2, 2, 1); cursor.close(); cursor = mResolver.query(uri, new String[]{Contacts.DISPLAY_NAME}, null, null, Contacts.SORT_KEY_ALTERNATIVE + " COLLATE LOCALIZED DESC"); assertFirstLetterValues(cursor, "W", "S", "R", "M", "B", null); assertFirstLetterCounts(cursor, 1, 2, 1, 1, 2, 1); cursor.close(); } private void assertFirstLetterValues(Cursor cursor, String... expected) { String[] actual = cursor.getExtras() .getStringArray(ContactCounts.EXTRA_ADDRESS_BOOK_INDEX_TITLES); MoreAsserts.assertEquals(expected, actual); } private void assertFirstLetterCounts(Cursor cursor, int... expected) { int[] actual = cursor.getExtras() .getIntArray(ContactCounts.EXTRA_ADDRESS_BOOK_INDEX_COUNTS); MoreAsserts.assertEquals(expected, actual); } public void testReadBooleanQueryParameter() { assertBooleanUriParameter("foo:bar", "bool", true, true); assertBooleanUriParameter("foo:bar", "bool", false, false); assertBooleanUriParameter("foo:bar?bool=0", "bool", true, false); assertBooleanUriParameter("foo:bar?bool=1", "bool", false, true); assertBooleanUriParameter("foo:bar?bool=false", "bool", true, false); assertBooleanUriParameter("foo:bar?bool=true", "bool", false, true); assertBooleanUriParameter("foo:bar?bool=FaLsE", "bool", true, false); assertBooleanUriParameter("foo:bar?bool=false&some=some", "bool", true, false); assertBooleanUriParameter("foo:bar?bool=1&some=some", "bool", false, true); assertBooleanUriParameter("foo:bar?some=bool", "bool", true, true); assertBooleanUriParameter("foo:bar?bool", "bool", true, true); } private void assertBooleanUriParameter(String uriString, String parameter, boolean defaultValue, boolean expectedValue) { assertEquals(expectedValue, ContactsProvider2.readBooleanQueryParameter( Uri.parse(uriString), parameter, defaultValue)); } public void testGetQueryParameter() { assertQueryParameter("foo:bar", "param", null); assertQueryParameter("foo:bar?param", "param", null); assertQueryParameter("foo:bar?param=", "param", ""); assertQueryParameter("foo:bar?param=val", "param", "val"); assertQueryParameter("foo:bar?param=val&some=some", "param", "val"); assertQueryParameter("foo:bar?some=some¶m=val", "param", "val"); assertQueryParameter("foo:bar?some=some¶m=val&else=else", "param", "val"); assertQueryParameter("foo:bar?param=john%40doe.com", "param", "john@doe.com"); } public void testMissingAccountTypeParameter() { // Try querying for RawContacts only using ACCOUNT_NAME final Uri queryUri = RawContacts.CONTENT_URI.buildUpon().appendQueryParameter( RawContacts.ACCOUNT_NAME, "lolwut").build(); try { final Cursor cursor = mResolver.query(queryUri, null, null, null, null); fail("Able to query with incomplete account query parameters"); } catch (IllegalArgumentException e) { // Expected behavior. } } public void testInsertInconsistentAccountType() { // Try inserting RawContact with inconsistent Accounts final Account red = new Account("red", "red"); final Account blue = new Account("blue", "blue"); final ContentValues values = new ContentValues(); values.put(RawContacts.ACCOUNT_NAME, red.name); values.put(RawContacts.ACCOUNT_TYPE, red.type); final Uri insertUri = maybeAddAccountQueryParameters(RawContacts.CONTENT_URI, blue); try { mResolver.insert(insertUri, values); fail("Able to insert RawContact with inconsistent account details"); } catch (IllegalArgumentException e) { // Expected behavior. } } public void testProviderStatus() throws Exception { Cursor cursor = mResolver.query(ProviderStatus.CONTENT_URI, new String[]{ProviderStatus.DATA1, ProviderStatus.STATUS}, null, null, null); assertTrue(cursor.moveToFirst()); assertEquals(0, cursor.getLong(0)); assertEquals(ProviderStatus.STATUS_NORMAL, cursor.getInt(1)); cursor.close(); } public void testProperties() throws Exception { ContactsProvider2 provider = (ContactsProvider2)getProvider(); ContactsDatabaseHelper helper = (ContactsDatabaseHelper)provider.getDatabaseHelper(); assertNull(helper.getProperty("non-existent", null)); assertEquals("default", helper.getProperty("non-existent", "default")); helper.setProperty("existent1", "string1"); helper.setProperty("existent2", "string2"); assertEquals("string1", helper.getProperty("existent1", "default")); assertEquals("string2", helper.getProperty("existent2", "default")); helper.setProperty("existent1", null); assertEquals("default", helper.getProperty("existent1", "default")); } private class VCardTestUriCreator { private String mLookup1; private String mLookup2; public VCardTestUriCreator(String lookup1, String lookup2) { super(); mLookup1 = lookup1; mLookup2 = lookup2; } public Uri getUri1() { return Uri.withAppendedPath(Contacts.CONTENT_VCARD_URI, mLookup1); } public Uri getUri2() { return Uri.withAppendedPath(Contacts.CONTENT_VCARD_URI, mLookup2); } public Uri getCombinedUri() { return Uri.withAppendedPath(Contacts.CONTENT_MULTI_VCARD_URI, Uri.encode(mLookup1 + ":" + mLookup2)); } } private VCardTestUriCreator createVCardTestContacts() { final long rawContactId1 = createRawContact(mAccount, RawContacts.SOURCE_ID, "4:12"); insertStructuredName(rawContactId1, "John", "Doe"); final long rawContactId2 = createRawContact(mAccount, RawContacts.SOURCE_ID, "3:4%121"); insertStructuredName(rawContactId2, "Jane", "Doh"); final long contactId1 = queryContactId(rawContactId1); final long contactId2 = queryContactId(rawContactId2); final Uri contact1Uri = ContentUris.withAppendedId(Contacts.CONTENT_URI, contactId1); final Uri contact2Uri = ContentUris.withAppendedId(Contacts.CONTENT_URI, contactId2); final String lookup1 = Uri.encode(Contacts.getLookupUri(mResolver, contact1Uri).getPathSegments().get(2)); final String lookup2 = Uri.encode(Contacts.getLookupUri(mResolver, contact2Uri).getPathSegments().get(2)); return new VCardTestUriCreator(lookup1, lookup2); } public void testQueryMultiVCard() { // No need to create any contacts here, because the query for multiple vcards // does not go into the database at all Uri uri = Uri.withAppendedPath(Contacts.CONTENT_MULTI_VCARD_URI, Uri.encode("123:456")); Cursor cursor = mResolver.query(uri, null, null, null, null); assertEquals(1, cursor.getCount()); assertTrue(cursor.moveToFirst()); assertTrue(cursor.isNull(cursor.getColumnIndex(OpenableColumns.SIZE))); String filename = cursor.getString(cursor.getColumnIndex(OpenableColumns.DISPLAY_NAME)); // The resulting name contains date and time. Ensure that before and after are correct assertTrue(filename.startsWith("vcards_")); assertTrue(filename.endsWith(".vcf")); cursor.close(); } public void testQueryFileSingleVCard() { final VCardTestUriCreator contacts = createVCardTestContacts(); { Cursor cursor = mResolver.query(contacts.getUri1(), null, null, null, null); assertEquals(1, cursor.getCount()); assertTrue(cursor.moveToFirst()); assertTrue(cursor.isNull(cursor.getColumnIndex(OpenableColumns.SIZE))); String filename = cursor.getString(cursor.getColumnIndex(OpenableColumns.DISPLAY_NAME)); assertEquals("John Doe.vcf", filename); cursor.close(); } { Cursor cursor = mResolver.query(contacts.getUri2(), null, null, null, null); assertEquals(1, cursor.getCount()); assertTrue(cursor.moveToFirst()); assertTrue(cursor.isNull(cursor.getColumnIndex(OpenableColumns.SIZE))); String filename = cursor.getString(cursor.getColumnIndex(OpenableColumns.DISPLAY_NAME)); assertEquals("Jane Doh.vcf", filename); cursor.close(); } } public void testOpenAssetFileMultiVCard() throws IOException { final VCardTestUriCreator contacts = createVCardTestContacts(); final AssetFileDescriptor descriptor = mResolver.openAssetFileDescriptor(contacts.getCombinedUri(), "r"); final FileInputStream inputStream = descriptor.createInputStream(); String data = readToEnd(inputStream); inputStream.close(); descriptor.close(); // Ensure that the resulting VCard has both contacts assertTrue(data.contains("N:Doe;John;;;")); assertTrue(data.contains("N:Doh;Jane;;;")); } public void testOpenAssetFileSingleVCard() throws IOException { final VCardTestUriCreator contacts = createVCardTestContacts(); // Ensure that the right VCard is being created in each case { final AssetFileDescriptor descriptor = mResolver.openAssetFileDescriptor(contacts.getUri1(), "r"); final FileInputStream inputStream = descriptor.createInputStream(); final String data = readToEnd(inputStream); assertTrue(data.contains("N:Doe;John;;;")); assertFalse(data.contains("N:Doh;Jane;;;")); inputStream.close(); descriptor.close(); } { final AssetFileDescriptor descriptor = mResolver.openAssetFileDescriptor(contacts.getUri2(), "r"); final FileInputStream inputStream = descriptor.createInputStream(); final String data = readToEnd(inputStream); inputStream.close(); descriptor.close(); assertFalse(data.contains("N:Doe;John;;;")); assertTrue(data.contains("N:Doh;Jane;;;")); } } public void testAutoGroupMembership() { long g1 = createGroup(mAccount, "g1", "t1", 0, true /* autoAdd */, false /* favorite */); long g2 = createGroup(mAccount, "g2", "t2", 0, false /* autoAdd */, false /* favorite */); long g3 = createGroup(mAccountTwo, "g3", "t3", 0, true /* autoAdd */, false /* favorite */); long g4 = createGroup(mAccountTwo, "g4", "t4", 0, false /* autoAdd */, false/* favorite */); long r1 = createRawContact(mAccount); long r2 = createRawContact(mAccountTwo); long r3 = createRawContact(null); Cursor c = queryGroupMemberships(mAccount); try { assertTrue(c.moveToNext()); assertEquals(g1, c.getLong(0)); assertEquals(r1, c.getLong(1)); assertFalse(c.moveToNext()); } finally { c.close(); } c = queryGroupMemberships(mAccountTwo); try { assertTrue(c.moveToNext()); assertEquals(g3, c.getLong(0)); assertEquals(r2, c.getLong(1)); assertFalse(c.moveToNext()); } finally { c.close(); } } public void testNoAutoAddMembershipAfterGroupCreation() { long r1 = createRawContact(mAccount); long r2 = createRawContact(mAccount); long r3 = createRawContact(mAccount); long r4 = createRawContact(mAccountTwo); long r5 = createRawContact(mAccountTwo); long r6 = createRawContact(null); assertNoRowsAndClose(queryGroupMemberships(mAccount)); assertNoRowsAndClose(queryGroupMemberships(mAccountTwo)); long g1 = createGroup(mAccount, "g1", "t1", 0, true /* autoAdd */, false /* favorite */); long g2 = createGroup(mAccount, "g2", "t2", 0, false /* autoAdd */, false /* favorite */); long g3 = createGroup(mAccountTwo, "g3", "t3", 0, true /* autoAdd */, false/* favorite */); assertNoRowsAndClose(queryGroupMemberships(mAccount)); assertNoRowsAndClose(queryGroupMemberships(mAccountTwo)); } // create some starred and non-starred contacts, some associated with account, some not // favorites group created // the starred contacts should be added to group // favorites group removed // no change to starred status public void testFavoritesMembershipAfterGroupCreation() { long r1 = createRawContact(mAccount, RawContacts.STARRED, "1"); long r2 = createRawContact(mAccount); long r3 = createRawContact(mAccount, RawContacts.STARRED, "1"); long r4 = createRawContact(mAccountTwo, RawContacts.STARRED, "1"); long r5 = createRawContact(mAccountTwo); long r6 = createRawContact(null, RawContacts.STARRED, "1"); long r7 = createRawContact(null); assertNoRowsAndClose(queryGroupMemberships(mAccount)); assertNoRowsAndClose(queryGroupMemberships(mAccountTwo)); long g1 = createGroup(mAccount, "g1", "t1", 0, false /* autoAdd */, true /* favorite */); long g2 = createGroup(mAccount, "g2", "t2", 0, false /* autoAdd */, false /* favorite */); long g3 = createGroup(mAccountTwo, "g3", "t3", 0, false /* autoAdd */, false/* favorite */); assertTrue(queryRawContactIsStarred(r1)); assertFalse(queryRawContactIsStarred(r2)); assertTrue(queryRawContactIsStarred(r3)); assertTrue(queryRawContactIsStarred(r4)); assertFalse(queryRawContactIsStarred(r5)); assertTrue(queryRawContactIsStarred(r6)); assertFalse(queryRawContactIsStarred(r7)); assertNoRowsAndClose(queryGroupMemberships(mAccountTwo)); Cursor c = queryGroupMemberships(mAccount); try { assertTrue(c.moveToNext()); assertEquals(g1, c.getLong(0)); assertEquals(r1, c.getLong(1)); assertTrue(c.moveToNext()); assertEquals(g1, c.getLong(0)); assertEquals(r3, c.getLong(1)); assertFalse(c.moveToNext()); } finally { c.close(); } updateItem(RawContacts.CONTENT_URI, r6, RawContacts.ACCOUNT_NAME, mAccount.name, RawContacts.ACCOUNT_TYPE, mAccount.type); assertNoRowsAndClose(queryGroupMemberships(mAccountTwo)); c = queryGroupMemberships(mAccount); try { assertTrue(c.moveToNext()); assertEquals(g1, c.getLong(0)); assertEquals(r1, c.getLong(1)); assertTrue(c.moveToNext()); assertEquals(g1, c.getLong(0)); assertEquals(r3, c.getLong(1)); assertTrue(c.moveToNext()); assertEquals(g1, c.getLong(0)); assertEquals(r6, c.getLong(1)); assertFalse(c.moveToNext()); } finally { c.close(); } mResolver.delete(ContentUris.withAppendedId(Groups.CONTENT_URI, g1), null, null); assertNoRowsAndClose(queryGroupMemberships(mAccount)); assertNoRowsAndClose(queryGroupMemberships(mAccountTwo)); assertTrue(queryRawContactIsStarred(r1)); assertFalse(queryRawContactIsStarred(r2)); assertTrue(queryRawContactIsStarred(r3)); assertTrue(queryRawContactIsStarred(r4)); assertFalse(queryRawContactIsStarred(r5)); assertTrue(queryRawContactIsStarred(r6)); assertFalse(queryRawContactIsStarred(r7)); } public void testFavoritesGroupMembershipChangeAfterStarChange() { long g1 = createGroup(mAccount, "g1", "t1", 0, false /* autoAdd */, true /* favorite */); long g2 = createGroup(mAccount, "g2", "t2", 0, false /* autoAdd */, false/* favorite */); long g4 = createGroup(mAccountTwo, "g4", "t4", 0, false /* autoAdd */, true /* favorite */); long g5 = createGroup(mAccountTwo, "g5", "t5", 0, false /* autoAdd */, false/* favorite */); long r1 = createRawContact(mAccount, RawContacts.STARRED, "1"); long r2 = createRawContact(mAccount); long r3 = createRawContact(mAccountTwo); assertNoRowsAndClose(queryGroupMemberships(mAccountTwo)); Cursor c = queryGroupMemberships(mAccount); try { assertTrue(c.moveToNext()); assertEquals(g1, c.getLong(0)); assertEquals(r1, c.getLong(1)); assertFalse(c.moveToNext()); } finally { c.close(); } // remove the star from r1 assertEquals(1, updateItem(RawContacts.CONTENT_URI, r1, RawContacts.STARRED, "0")); // Since no raw contacts are starred, there should be no group memberships. assertNoRowsAndClose(queryGroupMemberships(mAccount)); assertNoRowsAndClose(queryGroupMemberships(mAccountTwo)); // mark r1 as starred assertEquals(1, updateItem(RawContacts.CONTENT_URI, r1, RawContacts.STARRED, "1")); // Now that r1 is starred it should have a membership in the one groups from mAccount // that is marked as a favorite. // There should be no memberships in mAccountTwo since it has no starred raw contacts. assertNoRowsAndClose(queryGroupMemberships(mAccountTwo)); c = queryGroupMemberships(mAccount); try { assertTrue(c.moveToNext()); assertEquals(g1, c.getLong(0)); assertEquals(r1, c.getLong(1)); assertFalse(c.moveToNext()); } finally { c.close(); } // remove the star from r1 assertEquals(1, updateItem(RawContacts.CONTENT_URI, r1, RawContacts.STARRED, "0")); // Since no raw contacts are starred, there should be no group memberships. assertNoRowsAndClose(queryGroupMemberships(mAccount)); assertNoRowsAndClose(queryGroupMemberships(mAccountTwo)); Uri contactUri = ContentUris.withAppendedId(Contacts.CONTENT_URI, queryContactId(r1)); assertNotNull(contactUri); // mark r1 as starred via its contact lookup uri assertEquals(1, updateItem(contactUri, Contacts.STARRED, "1")); // Now that r1 is starred it should have a membership in the one groups from mAccount // that is marked as a favorite. // There should be no memberships in mAccountTwo since it has no starred raw contacts. assertNoRowsAndClose(queryGroupMemberships(mAccountTwo)); c = queryGroupMemberships(mAccount); try { assertTrue(c.moveToNext()); assertEquals(g1, c.getLong(0)); assertEquals(r1, c.getLong(1)); assertFalse(c.moveToNext()); } finally { c.close(); } // remove the star from r1 updateItem(contactUri, Contacts.STARRED, "0"); // Since no raw contacts are starred, there should be no group memberships. assertNoRowsAndClose(queryGroupMemberships(mAccount)); assertNoRowsAndClose(queryGroupMemberships(mAccountTwo)); } public void testStarChangedAfterGroupMembershipChange() { long g1 = createGroup(mAccount, "g1", "t1", 0, false /* autoAdd */, true /* favorite */); long g2 = createGroup(mAccount, "g2", "t2", 0, false /* autoAdd */, false/* favorite */); long g4 = createGroup(mAccountTwo, "g4", "t4", 0, false /* autoAdd */, true /* favorite */); long g5 = createGroup(mAccountTwo, "g5", "t5", 0, false /* autoAdd */, false/* favorite */); long r1 = createRawContact(mAccount); long r2 = createRawContact(mAccount); long r3 = createRawContact(mAccountTwo); assertFalse(queryRawContactIsStarred(r1)); assertFalse(queryRawContactIsStarred(r2)); assertFalse(queryRawContactIsStarred(r3)); Cursor c; // add r1 to one favorites group // r1's star should automatically be set // r1 should automatically be added to the other favorites group Uri urir1g1 = insertGroupMembership(r1, g1); assertTrue(queryRawContactIsStarred(r1)); assertFalse(queryRawContactIsStarred(r2)); assertFalse(queryRawContactIsStarred(r3)); assertNoRowsAndClose(queryGroupMemberships(mAccountTwo)); c = queryGroupMemberships(mAccount); try { assertTrue(c.moveToNext()); assertEquals(g1, c.getLong(0)); assertEquals(r1, c.getLong(1)); assertFalse(c.moveToNext()); } finally { c.close(); } // remove r1 from one favorites group mResolver.delete(urir1g1, null, null); // r1's star should no longer be set assertFalse(queryRawContactIsStarred(r1)); assertFalse(queryRawContactIsStarred(r2)); assertFalse(queryRawContactIsStarred(r3)); // there should be no membership rows assertNoRowsAndClose(queryGroupMemberships(mAccount)); assertNoRowsAndClose(queryGroupMemberships(mAccountTwo)); // add r3 to the one favorites group for that account // r3's star should automatically be set Uri urir3g4 = insertGroupMembership(r3, g4); assertFalse(queryRawContactIsStarred(r1)); assertFalse(queryRawContactIsStarred(r2)); assertTrue(queryRawContactIsStarred(r3)); assertNoRowsAndClose(queryGroupMemberships(mAccount)); c = queryGroupMemberships(mAccountTwo); try { assertTrue(c.moveToNext()); assertEquals(g4, c.getLong(0)); assertEquals(r3, c.getLong(1)); assertFalse(c.moveToNext()); } finally { c.close(); } // remove r3 from the favorites group mResolver.delete(urir3g4, null, null); // r3's star should automatically be cleared assertFalse(queryRawContactIsStarred(r1)); assertFalse(queryRawContactIsStarred(r2)); assertFalse(queryRawContactIsStarred(r3)); assertNoRowsAndClose(queryGroupMemberships(mAccount)); assertNoRowsAndClose(queryGroupMemberships(mAccountTwo)); } private Cursor queryGroupMemberships(Account account) { Cursor c = mResolver.query(maybeAddAccountQueryParameters(Data.CONTENT_URI, account), new String[]{GroupMembership.GROUP_ROW_ID, GroupMembership.RAW_CONTACT_ID}, Data.MIMETYPE + "=?", new String[]{GroupMembership.CONTENT_ITEM_TYPE}, GroupMembership.GROUP_SOURCE_ID); return c; } private String readToEnd(FileInputStream inputStream) { try { int ch; StringBuilder stringBuilder = new StringBuilder(); while ((ch = inputStream.read()) != -1) stringBuilder.append((char)ch); return stringBuilder.toString(); } catch (IOException e) { return null; } } private void assertQueryParameter(String uriString, String parameter, String expectedValue) { assertEquals(expectedValue, ContactsProvider2.getQueryParameter( Uri.parse(uriString), parameter)); } private long createContact(ContentValues values, String firstName, String givenName, String phoneNumber, String email, int presenceStatus, int timesContacted, int starred, long groupId) { return queryContactId(createRawContact(values, firstName, givenName, phoneNumber, email, presenceStatus, timesContacted, starred, groupId)); } private long createRawContact(ContentValues values, String firstName, String givenName, String phoneNumber, String email, int presenceStatus, int timesContacted, int starred, long groupId) { long rawContactId = createRawContact(values, phoneNumber, email, presenceStatus, timesContacted, starred, groupId); insertStructuredName(rawContactId, firstName, givenName); return rawContactId; } private long createRawContact(ContentValues values, String phoneNumber, String email, int presenceStatus, int timesContacted, int starred, long groupId) { values.put(RawContacts.STARRED, starred); values.put(RawContacts.SEND_TO_VOICEMAIL, 1); values.put(RawContacts.CUSTOM_RINGTONE, "beethoven5"); values.put(RawContacts.LAST_TIME_CONTACTED, 12345); values.put(RawContacts.TIMES_CONTACTED, timesContacted); Uri rawContactUri = mResolver.insert(RawContacts.CONTENT_URI, values); long rawContactId = ContentUris.parseId(rawContactUri); Uri photoUri = insertPhoto(rawContactId); long photoId = ContentUris.parseId(photoUri); values.put(Contacts.PHOTO_ID, photoId); insertPhoneNumber(rawContactId, phoneNumber); insertEmail(rawContactId, email); insertStatusUpdate(Im.PROTOCOL_GOOGLE_TALK, null, email, presenceStatus, "hacking"); if (groupId != 0) { insertGroupMembership(rawContactId, groupId); } return rawContactId; } private void putDataValues(ContentValues values, long rawContactId) { values.put(Data.RAW_CONTACT_ID, rawContactId); values.put(Data.MIMETYPE, "testmimetype"); values.put(Data.RES_PACKAGE, "oldpackage"); values.put(Data.IS_PRIMARY, 1); values.put(Data.IS_SUPER_PRIMARY, 1); values.put(Data.DATA1, "one"); values.put(Data.DATA2, "two"); values.put(Data.DATA3, "three"); values.put(Data.DATA4, "four"); values.put(Data.DATA5, "five"); values.put(Data.DATA6, "six"); values.put(Data.DATA7, "seven"); values.put(Data.DATA8, "eight"); values.put(Data.DATA9, "nine"); values.put(Data.DATA10, "ten"); values.put(Data.DATA11, "eleven"); values.put(Data.DATA12, "twelve"); values.put(Data.DATA13, "thirteen"); values.put(Data.DATA14, "fourteen"); values.put(Data.DATA15, "fifteen"); values.put(Data.SYNC1, "sync1"); values.put(Data.SYNC2, "sync2"); values.put(Data.SYNC3, "sync3"); values.put(Data.SYNC4, "sync4"); } }