| /* |
| * Copyright (C) 2010 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 android.provider.cts; |
| |
| |
| import static android.provider.ContactsContract.CommonDataKinds; |
| |
| import android.content.ContentProviderClient; |
| import android.content.ContentResolver; |
| import android.content.ContentValues; |
| import android.net.Uri; |
| import android.os.SystemClock; |
| import android.provider.ContactsContract; |
| import android.provider.ContactsContract.CommonDataKinds.Callable; |
| import android.provider.ContactsContract.CommonDataKinds.Contactables; |
| import android.provider.ContactsContract.CommonDataKinds.Email; |
| import android.provider.ContactsContract.CommonDataKinds.GroupMembership; |
| import android.provider.ContactsContract.CommonDataKinds.Organization; |
| import android.provider.ContactsContract.CommonDataKinds.Phone; |
| import android.provider.ContactsContract.CommonDataKinds.SipAddress; |
| import android.provider.ContactsContract.CommonDataKinds.StructuredName; |
| import android.provider.ContactsContract.Contacts; |
| import android.provider.ContactsContract.Contacts.Entity; |
| import android.provider.ContactsContract.Data; |
| import android.provider.ContactsContract.RawContacts; |
| import android.provider.ContactsContract.RawContactsEntity; |
| import android.provider.cts.ContactsContract_TestDataBuilder.TestContact; |
| import android.provider.cts.ContactsContract_TestDataBuilder.TestData; |
| import android.provider.cts.ContactsContract_TestDataBuilder.TestRawContact; |
| import android.provider.cts.contacts.ContactUtil; |
| import android.provider.cts.contacts.DataUtil; |
| import android.provider.cts.contacts.DatabaseAsserts; |
| import android.provider.cts.contacts.RawContactUtil; |
| import android.test.InstrumentationTestCase; |
| |
| import java.util.ArrayList; |
| |
| public class ContactsContract_DataTest extends InstrumentationTestCase { |
| private ContentResolver mResolver; |
| private ContactsContract_TestDataBuilder mBuilder; |
| |
| static final String[] DATA_PROJECTION = new String[]{ |
| Data._ID, |
| Data.RAW_CONTACT_ID, |
| Data.CONTACT_ID, |
| Data.NAME_RAW_CONTACT_ID, |
| RawContacts.RAW_CONTACT_IS_USER_PROFILE, |
| Data.DATA1, |
| Data.DATA2, |
| Data.DATA3, |
| Data.DATA4, |
| Data.DATA5, |
| Data.DATA6, |
| Data.DATA7, |
| Data.DATA8, |
| Data.DATA9, |
| Data.DATA10, |
| Data.DATA11, |
| Data.DATA12, |
| Data.DATA13, |
| Data.DATA14, |
| Data.DATA15, |
| Data.CARRIER_PRESENCE, |
| Data.DATA_VERSION, |
| Data.IS_PRIMARY, |
| Data.IS_SUPER_PRIMARY, |
| Data.MIMETYPE, |
| Data.RES_PACKAGE, |
| Data.SYNC1, |
| Data.SYNC2, |
| Data.SYNC3, |
| Data.SYNC4, |
| GroupMembership.GROUP_SOURCE_ID, |
| Data.PRESENCE, |
| Data.CHAT_CAPABILITY, |
| Data.STATUS, |
| Data.STATUS_TIMESTAMP, |
| Data.STATUS_RES_PACKAGE, |
| Data.STATUS_LABEL, |
| Data.STATUS_ICON, |
| RawContacts.ACCOUNT_NAME, |
| RawContacts.ACCOUNT_TYPE, |
| RawContacts.DATA_SET, |
| RawContacts.ACCOUNT_TYPE_AND_DATA_SET, |
| RawContacts.DIRTY, |
| RawContacts.SOURCE_ID, |
| RawContacts.VERSION, |
| Contacts.CUSTOM_RINGTONE, |
| Contacts.DISPLAY_NAME, |
| Contacts.DISPLAY_NAME_ALTERNATIVE, |
| Contacts.DISPLAY_NAME_SOURCE, |
| Contacts.IN_DEFAULT_DIRECTORY, |
| Contacts.IN_VISIBLE_GROUP, |
| Contacts.LAST_TIME_CONTACTED, |
| Contacts.LOOKUP_KEY, |
| Contacts.PHONETIC_NAME, |
| Contacts.PHONETIC_NAME_STYLE, |
| Contacts.PHOTO_ID, |
| Contacts.PHOTO_FILE_ID, |
| Contacts.PHOTO_URI, |
| Contacts.PHOTO_THUMBNAIL_URI, |
| Contacts.SEND_TO_VOICEMAIL, |
| Contacts.SORT_KEY_ALTERNATIVE, |
| Contacts.SORT_KEY_PRIMARY, |
| Contacts.STARRED, |
| Contacts.PINNED, |
| Contacts.TIMES_CONTACTED, |
| Contacts.HAS_PHONE_NUMBER, |
| Contacts.CONTACT_LAST_UPDATED_TIMESTAMP, |
| Contacts.CONTACT_PRESENCE, |
| Contacts.CONTACT_CHAT_CAPABILITY, |
| Contacts.CONTACT_STATUS, |
| Contacts.CONTACT_STATUS_TIMESTAMP, |
| Contacts.CONTACT_STATUS_RES_PACKAGE, |
| Contacts.CONTACT_STATUS_LABEL, |
| Contacts.CONTACT_STATUS_ICON, |
| Data.TIMES_USED, |
| Data.LAST_TIME_USED}; |
| |
| static final String[] RAW_CONTACTS_ENTITY_PROJECTION = new String[]{ |
| }; |
| |
| static final String[] NTITY_PROJECTION = new String[]{ |
| }; |
| |
| private static ContentValues[] sContentValues = new ContentValues[7]; |
| static { |
| ContentValues cv1 = new ContentValues(); |
| cv1.put(Contacts.DISPLAY_NAME, "Hot Tamale"); |
| cv1.put(Data.MIMETYPE, Email.CONTENT_ITEM_TYPE); |
| cv1.put(Email.DATA, "tamale@acme.com"); |
| cv1.put(Email.TYPE, Email.TYPE_HOME); |
| sContentValues[0] = cv1; |
| |
| ContentValues cv2 = new ContentValues(); |
| cv2.put(Contacts.DISPLAY_NAME, "Hot Tamale"); |
| cv2.put(Data.MIMETYPE, Phone.CONTENT_ITEM_TYPE); |
| cv2.put(Phone.DATA, "510-123-5769"); |
| cv2.put(Phone.TYPE, Phone.TYPE_HOME); |
| sContentValues[1] = cv2; |
| |
| ContentValues cv3 = new ContentValues(); |
| cv3.put(Contacts.DISPLAY_NAME, "Hot Tamale"); |
| cv3.put(Data.MIMETYPE, Email.CONTENT_ITEM_TYPE); |
| cv3.put(Email.DATA, "hot@google.com"); |
| cv3.put(Email.TYPE, Email.TYPE_WORK); |
| sContentValues[2] = cv3; |
| |
| ContentValues cv4 = new ContentValues(); |
| cv4.put(Contacts.DISPLAY_NAME, "Cold Tamago"); |
| cv4.put(Data.MIMETYPE, Email.CONTENT_ITEM_TYPE); |
| cv4.put(Email.DATA, "eggs@farmers.org"); |
| cv4.put(Email.TYPE, Email.TYPE_HOME); |
| sContentValues[3] = cv4; |
| |
| ContentValues cv5 = new ContentValues(); |
| cv5.put(Contacts.DISPLAY_NAME, "John Doe"); |
| cv5.put(Data.MIMETYPE, Email.CONTENT_ITEM_TYPE); |
| cv5.put(Email.DATA, "doeassociates@deer.com"); |
| cv5.put(Email.TYPE, Email.TYPE_WORK); |
| sContentValues[4] = cv5; |
| |
| ContentValues cv6 = new ContentValues(); |
| cv6.put(Contacts.DISPLAY_NAME, "John Doe"); |
| cv6.put(Data.MIMETYPE, Phone.CONTENT_ITEM_TYPE); |
| cv6.put(Phone.DATA, "518-354-1111"); |
| cv6.put(Phone.TYPE, Phone.TYPE_HOME); |
| sContentValues[5] = cv6; |
| |
| ContentValues cv7 = new ContentValues(); |
| cv7.put(Contacts.DISPLAY_NAME, "Cold Tamago"); |
| cv7.put(Data.MIMETYPE, SipAddress.CONTENT_ITEM_TYPE); |
| cv7.put(SipAddress.DATA, "mysip@sipaddress.com"); |
| cv7.put(SipAddress.TYPE, SipAddress.TYPE_HOME); |
| sContentValues[6] = cv7; |
| } |
| |
| private TestRawContact[] mRawContacts = new TestRawContact[3]; |
| |
| @Override |
| protected void setUp() throws Exception { |
| super.setUp(); |
| mResolver = getInstrumentation().getTargetContext().getContentResolver(); |
| ContentProviderClient provider = |
| mResolver.acquireContentProviderClient(ContactsContract.AUTHORITY); |
| mBuilder = new ContactsContract_TestDataBuilder(provider); |
| } |
| |
| @Override |
| protected void tearDown() throws Exception { |
| super.tearDown(); |
| mBuilder.cleanup(); |
| } |
| |
| public void testGetLookupUriBySourceId() throws Exception { |
| TestRawContact rawContact = mBuilder.newRawContact() |
| .with(RawContacts.ACCOUNT_TYPE, "test_type") |
| .with(RawContacts.ACCOUNT_NAME, "test_name") |
| .with(RawContacts.SOURCE_ID, "source_id") |
| .insert(); |
| |
| // TODO remove this. The method under test is currently broken: it will not |
| // work without at least one data row in the raw contact. |
| TestData data = rawContact.newDataRow(CommonDataKinds.StructuredName.CONTENT_ITEM_TYPE) |
| .with(CommonDataKinds.StructuredName.DISPLAY_NAME, "test name") |
| .insert(); |
| |
| Uri lookupUri = Data.getContactLookupUri(mResolver, data.getUri()); |
| assertNotNull("Could not produce a lookup URI", lookupUri); |
| |
| TestContact lookupContact = mBuilder.newContact().setUri(lookupUri).load(); |
| assertEquals("Lookup URI matched the wrong contact", |
| lookupContact.getId(), data.load().getRawContact().load().getContactId()); |
| } |
| |
| public void testDataProjection() throws Exception { |
| TestRawContact rawContact = mBuilder.newRawContact() |
| .with(RawContacts.ACCOUNT_TYPE, "test_type") |
| .with(RawContacts.ACCOUNT_NAME, "test_name") |
| .with(RawContacts.SOURCE_ID, "source_id") |
| .insert(); |
| TestData data = rawContact.newDataRow(CommonDataKinds.StructuredName.CONTENT_ITEM_TYPE) |
| .with(CommonDataKinds.StructuredName.DISPLAY_NAME, "test name") |
| .insert(); |
| |
| DatabaseAsserts.checkProjection(mResolver, Data.CONTENT_URI, |
| DATA_PROJECTION, |
| new long[]{data.load().getId()} |
| ); |
| } |
| |
| public void testRawContactsEntityProjection() throws Exception { |
| TestRawContact rawContact = mBuilder.newRawContact() |
| .with(RawContacts.ACCOUNT_TYPE, "test_type") |
| .with(RawContacts.ACCOUNT_NAME, "test_name") |
| .with(RawContacts.SOURCE_ID, "source_id") |
| .insert(); |
| TestData data = rawContact.newDataRow(CommonDataKinds.StructuredName.CONTENT_ITEM_TYPE) |
| .with(CommonDataKinds.StructuredName.DISPLAY_NAME, "test name") |
| .insert(); |
| |
| DatabaseAsserts.checkProjection(mResolver, RawContactsEntity.CONTENT_URI, |
| new String[]{ |
| RawContacts._ID, |
| RawContacts.CONTACT_ID, |
| RawContacts.Entity.DATA_ID, |
| RawContacts.DELETED, |
| RawContacts.STARRED, |
| RawContacts.RAW_CONTACT_IS_USER_PROFILE, |
| RawContacts.ACCOUNT_NAME, |
| RawContacts.ACCOUNT_TYPE, |
| RawContacts.DATA_SET, |
| RawContacts.ACCOUNT_TYPE_AND_DATA_SET, |
| RawContacts.DIRTY, |
| RawContacts.SOURCE_ID, |
| RawContacts.BACKUP_ID, |
| RawContacts.VERSION, |
| RawContacts.SYNC1, |
| RawContacts.SYNC2, |
| RawContacts.SYNC3, |
| RawContacts.SYNC4, |
| Data.DATA1, |
| Data.DATA2, |
| Data.DATA3, |
| Data.DATA4, |
| Data.DATA5, |
| Data.DATA6, |
| Data.DATA7, |
| Data.DATA8, |
| Data.DATA9, |
| Data.DATA10, |
| Data.DATA11, |
| Data.DATA12, |
| Data.DATA13, |
| Data.DATA14, |
| Data.DATA15, |
| Data.CARRIER_PRESENCE, |
| Data.DATA_VERSION, |
| Data.IS_PRIMARY, |
| Data.IS_SUPER_PRIMARY, |
| Data.MIMETYPE, |
| Data.RES_PACKAGE, |
| Data.SYNC1, |
| Data.SYNC2, |
| Data.SYNC3, |
| Data.SYNC4, |
| GroupMembership.GROUP_SOURCE_ID}, |
| new long[]{rawContact.getId()} |
| ); |
| } |
| |
| public void testEntityProjection() throws Exception { |
| TestRawContact rawContact = mBuilder.newRawContact() |
| .with(RawContacts.ACCOUNT_TYPE, "test_type") |
| .with(RawContacts.ACCOUNT_NAME, "test_name") |
| .with(RawContacts.SOURCE_ID, "source_id") |
| .insert(); |
| TestData data = rawContact.newDataRow(CommonDataKinds.StructuredName.CONTENT_ITEM_TYPE) |
| .with(CommonDataKinds.StructuredName.DISPLAY_NAME, "test name") |
| .insert(); |
| long contactId = rawContact.load().getContactId(); |
| |
| DatabaseAsserts.checkProjection(mResolver, Contacts.CONTENT_URI.buildUpon().appendPath( |
| String.valueOf(contactId)).appendPath( |
| Entity.CONTENT_DIRECTORY).build(), |
| new String[]{ |
| Contacts.Entity._ID, |
| Contacts.Entity.CONTACT_ID, |
| Contacts.Entity.RAW_CONTACT_ID, |
| Contacts.Entity.DATA_ID, |
| Contacts.Entity.NAME_RAW_CONTACT_ID, |
| Contacts.Entity.DELETED, |
| Contacts.IS_USER_PROFILE, |
| Contacts.CUSTOM_RINGTONE, |
| Contacts.DISPLAY_NAME, |
| Contacts.DISPLAY_NAME_ALTERNATIVE, |
| Contacts.DISPLAY_NAME_SOURCE, |
| Contacts.IN_DEFAULT_DIRECTORY, |
| Contacts.IN_VISIBLE_GROUP, |
| Contacts.LAST_TIME_CONTACTED, |
| Contacts.LOOKUP_KEY, |
| Contacts.PHONETIC_NAME, |
| Contacts.PHONETIC_NAME_STYLE, |
| Contacts.PHOTO_ID, |
| Contacts.PHOTO_FILE_ID, |
| Contacts.PHOTO_URI, |
| Contacts.PHOTO_THUMBNAIL_URI, |
| Contacts.SEND_TO_VOICEMAIL, |
| Contacts.SORT_KEY_ALTERNATIVE, |
| Contacts.SORT_KEY_PRIMARY, |
| Contacts.STARRED, |
| Contacts.PINNED, |
| Contacts.TIMES_CONTACTED, |
| Contacts.HAS_PHONE_NUMBER, |
| Contacts.CONTACT_LAST_UPDATED_TIMESTAMP, |
| Contacts.CONTACT_PRESENCE, |
| Contacts.CONTACT_CHAT_CAPABILITY, |
| Contacts.CONTACT_STATUS, |
| Contacts.CONTACT_STATUS_TIMESTAMP, |
| Contacts.CONTACT_STATUS_RES_PACKAGE, |
| Contacts.CONTACT_STATUS_LABEL, |
| Contacts.CONTACT_STATUS_ICON, |
| RawContacts.ACCOUNT_NAME, |
| RawContacts.ACCOUNT_TYPE, |
| RawContacts.DATA_SET, |
| RawContacts.ACCOUNT_TYPE_AND_DATA_SET, |
| RawContacts.DIRTY, |
| RawContacts.SOURCE_ID, |
| RawContacts.BACKUP_ID, |
| RawContacts.VERSION, |
| RawContacts.SYNC1, |
| RawContacts.SYNC2, |
| RawContacts.SYNC3, |
| RawContacts.SYNC4, |
| Data.DATA1, |
| Data.DATA2, |
| Data.DATA3, |
| Data.DATA4, |
| Data.DATA5, |
| Data.DATA6, |
| Data.DATA7, |
| Data.DATA8, |
| Data.DATA9, |
| Data.DATA10, |
| Data.DATA11, |
| Data.DATA12, |
| Data.DATA13, |
| Data.DATA14, |
| Data.DATA15, |
| Data.CARRIER_PRESENCE, |
| Data.DATA_VERSION, |
| Data.IS_PRIMARY, |
| Data.IS_SUPER_PRIMARY, |
| Data.MIMETYPE, |
| Data.RES_PACKAGE, |
| Data.SYNC1, |
| Data.SYNC2, |
| Data.SYNC3, |
| Data.SYNC4, |
| GroupMembership.GROUP_SOURCE_ID, |
| Data.PRESENCE, |
| Data.CHAT_CAPABILITY, |
| Data.STATUS, |
| Data.STATUS_TIMESTAMP, |
| Data.STATUS_RES_PACKAGE, |
| Data.STATUS_LABEL, |
| Data.STATUS_ICON, |
| Data.TIMES_USED, |
| Data.LAST_TIME_USED}, |
| new long[]{contactId} |
| ); |
| } |
| |
| public void testGetLookupUriByDisplayName() throws Exception { |
| TestRawContact rawContact = mBuilder.newRawContact() |
| .with(RawContacts.ACCOUNT_TYPE, "test_type") |
| .with(RawContacts.ACCOUNT_NAME, "test_name") |
| .insert(); |
| TestData data = rawContact.newDataRow(CommonDataKinds.StructuredName.CONTENT_ITEM_TYPE) |
| .with(CommonDataKinds.StructuredName.DISPLAY_NAME, "test name") |
| .insert(); |
| |
| Uri lookupUri = Data.getContactLookupUri(mResolver, data.getUri()); |
| assertNotNull("Could not produce a lookup URI", lookupUri); |
| |
| TestContact lookupContact = mBuilder.newContact().setUri(lookupUri).load(); |
| assertEquals("Lookup URI matched the wrong contact", |
| lookupContact.getId(), data.load().getRawContact().load().getContactId()); |
| } |
| |
| public void testContactablesUri() throws Exception { |
| TestRawContact rawContact = mBuilder.newRawContact() |
| .with(RawContacts.ACCOUNT_TYPE, "test_account") |
| .with(RawContacts.ACCOUNT_NAME, "test_name") |
| .insert(); |
| rawContact.newDataRow(CommonDataKinds.Email.CONTENT_ITEM_TYPE) |
| .with(Email.DATA, "test@test.com") |
| .with(Email.TYPE, Email.TYPE_WORK) |
| .insert(); |
| ContentValues cv = new ContentValues(); |
| cv.put(Email.DATA, "test@test.com"); |
| cv.put(Email.TYPE, Email.TYPE_WORK); |
| |
| Uri contentUri = ContactsContract.CommonDataKinds.Contactables.CONTENT_URI; |
| try { |
| assertCursorStoredValuesWithRawContactsFilter(contentUri, |
| new long[] {rawContact.getId()}, cv); |
| rawContact.newDataRow(CommonDataKinds.StructuredPostal.CONTENT_ITEM_TYPE) |
| .with(CommonDataKinds.StructuredPostal.DATA1, "100 Sesame Street") |
| .insert(); |
| |
| rawContact.newDataRow(Phone.CONTENT_ITEM_TYPE) |
| .with(Phone.DATA, "123456789") |
| .with(Phone.TYPE, Phone.TYPE_MOBILE) |
| .insert(); |
| |
| ContentValues cv2 = new ContentValues(); |
| cv.put(Phone.DATA, "123456789"); |
| cv.put(Phone.TYPE, Phone.TYPE_MOBILE); |
| |
| // Contactables Uri should return only email and phone data items. |
| DatabaseAsserts.assertStoredValuesInUriMatchExactly(mResolver, contentUri, null, |
| Data.RAW_CONTACT_ID + "=?", new String[] {String.valueOf(rawContact.getId())}, |
| null, false, cv, cv2); |
| } finally { |
| // Clean up |
| rawContact.delete(); |
| } |
| } |
| |
| public void testContactablesFilterByLastName_returnsCorrectDataRows() throws Exception { |
| long[] ids = setupContactablesTestData(); |
| Uri filterUri = Uri.withAppendedPath(Contactables.CONTENT_FILTER_URI, "tamale"); |
| assertCursorStoredValuesWithRawContactsFilter(filterUri, ids, |
| ContactablesTestHelper.getContentValues(0)); |
| } |
| |
| public void testContactablesFilterByFirstName_returnsCorrectDataRows() throws Exception { |
| long[] ids = setupContactablesTestData(); |
| Uri filterUri = Uri.withAppendedPath(Contactables.CONTENT_FILTER_URI, "hot"); |
| assertCursorStoredValuesWithRawContactsFilter(filterUri, ids, |
| ContactablesTestHelper.getContentValues(0)); |
| Uri filterUri2 = Uri.withAppendedPath(Contactables.CONTENT_FILTER_URI, "tam"); |
| assertCursorStoredValuesWithRawContactsFilter(filterUri2, ids, |
| ContactablesTestHelper.getContentValues(0, 1)); |
| } |
| |
| public void testContactablesFilterByPhonePrefix_returnsCorrectDataRows() throws Exception { |
| long[] ids = setupContactablesTestData(); |
| Uri filterUri = Uri.withAppendedPath(Contactables.CONTENT_FILTER_URI, "518"); |
| assertCursorStoredValuesWithRawContactsFilter(filterUri, ids, |
| ContactablesTestHelper.getContentValues(2)); |
| Uri filterUri2 = Uri.withAppendedPath(Contactables.CONTENT_FILTER_URI, "51"); |
| assertCursorStoredValuesWithRawContactsFilter(filterUri2, ids, |
| ContactablesTestHelper.getContentValues(0, 2)); |
| } |
| |
| public void testContactablesFilterByEmailPrefix_returnsCorrectDataRows() throws Exception { |
| long[] ids = setupContactablesTestData(); |
| Uri filterUri = Uri.withAppendedPath(Contactables.CONTENT_FILTER_URI, "doeassoc"); |
| assertCursorStoredValuesWithRawContactsFilter(filterUri, ids, |
| ContactablesTestHelper.getContentValues(2)); |
| } |
| |
| public void testContactablesFilter_doesNotExist_returnsCorrectDataRows() throws Exception { |
| long[] ids = setupContactablesTestData(); |
| Uri filterUri = Uri.withAppendedPath(Contactables.CONTENT_FILTER_URI, "doesnotexist"); |
| assertCursorStoredValuesWithRawContactsFilter(filterUri, ids, new ContentValues[0]); |
| } |
| |
| /** |
| * Verifies that Callable.CONTENT_URI returns only data items that can be called (i.e. |
| * phone numbers and sip addresses) |
| */ |
| public void testCallableUri_returnsCorrectDataRows() throws Exception { |
| long[] ids = setupContactablesTestData(); |
| Uri uri = Callable.CONTENT_URI; |
| assertCursorStoredValuesWithRawContactsFilter(uri, ids, sContentValues[1], |
| sContentValues[5], sContentValues[6]); |
| } |
| |
| public void testCallableFilterByNameOrOrganization_returnsCorrectDataRows() throws Exception { |
| long[] ids = setupContactablesTestData(); |
| Uri uri = Uri.withAppendedPath(Callable.CONTENT_FILTER_URI, "doe"); |
| // Only callables belonging to John Doe (name) and Cold Tamago (organization) are returned. |
| assertCursorStoredValuesWithRawContactsFilter(uri, ids, sContentValues[5], |
| sContentValues[6]); |
| } |
| |
| public void testCallableFilterByNumber_returnsCorrectDataRows() throws Exception { |
| long[] ids = setupContactablesTestData(); |
| Uri uri = Uri.withAppendedPath(Callable.CONTENT_FILTER_URI, "510"); |
| assertCursorStoredValuesWithRawContactsFilter(uri, ids, sContentValues[1]); |
| } |
| |
| public void testCallableFilterBySipAddress_returnsCorrectDataRows() throws Exception { |
| long[] ids = setupContactablesTestData(); |
| Uri uri = Uri.withAppendedPath(Callable.CONTENT_FILTER_URI, "mysip"); |
| assertCursorStoredValuesWithRawContactsFilter(uri, ids, sContentValues[6]); |
| } |
| |
| public void testDataInsert_updatesContactLastUpdatedTimestamp() { |
| DatabaseAsserts.ContactIdPair ids = DatabaseAsserts.assertAndCreateContact(mResolver); |
| long baseTime = ContactUtil.queryContactLastUpdatedTimestamp(mResolver, ids.mContactId); |
| |
| SystemClock.sleep(1); |
| createData(ids.mRawContactId); |
| |
| long newTime = ContactUtil.queryContactLastUpdatedTimestamp(mResolver, ids.mContactId); |
| assertTrue(newTime > baseTime); |
| |
| // Clean up |
| RawContactUtil.delete(mResolver, ids.mRawContactId, true); |
| } |
| |
| public void testDataDelete_updatesContactLastUpdatedTimestamp() { |
| DatabaseAsserts.ContactIdPair ids = DatabaseAsserts.assertAndCreateContact(mResolver); |
| |
| long dataId = createData(ids.mRawContactId); |
| |
| long baseTime = ContactUtil.queryContactLastUpdatedTimestamp(mResolver, ids.mContactId); |
| |
| SystemClock.sleep(1); |
| DataUtil.delete(mResolver, dataId); |
| |
| long newTime = ContactUtil.queryContactLastUpdatedTimestamp(mResolver, ids.mContactId); |
| assertTrue(newTime > baseTime); |
| |
| // Clean up |
| RawContactUtil.delete(mResolver, ids.mRawContactId, true); |
| } |
| |
| /** |
| * Tests that specifying the {@link android.provider.ContactsContract#REMOVE_DUPLICATE_ENTRIES} |
| * boolean parameter correctly results in deduped phone numbers. |
| */ |
| public void testPhoneQuery_removeDuplicateEntries() throws Exception{ |
| long[] ids = setupContactablesTestData(); |
| |
| // Insert duplicate data entry for raw contact 3. (existing phone number 518-354-1111) |
| mRawContacts[2].newDataRow(Phone.CONTENT_ITEM_TYPE) |
| .with(Phone.DATA, "518-354-1111") |
| .with(Phone.TYPE, Phone.TYPE_HOME) |
| .insert(); |
| |
| ContentValues dupe = new ContentValues(); |
| dupe.put(Contacts.DISPLAY_NAME, "John Doe"); |
| dupe.put(Data.MIMETYPE, Phone.CONTENT_ITEM_TYPE); |
| dupe.put(Phone.DATA, "518-354-1111"); |
| dupe.put(Phone.TYPE, Phone.TYPE_HOME); |
| |
| // Query for all phone numbers in the contacts database (without deduping). |
| // The phone number above should be listed twice, in its duplicated forms. |
| assertCursorStoredValuesWithRawContactsFilter(Phone.CONTENT_URI, ids, sContentValues[1], |
| sContentValues[5], dupe); |
| |
| // Now query for all phone numbers in the contacts database but request deduping. |
| // The phone number should now be listed only once. |
| Uri uri = Phone.CONTENT_URI.buildUpon(). |
| appendQueryParameter(ContactsContract.REMOVE_DUPLICATE_ENTRIES, "true").build(); |
| assertCursorStoredValuesWithRawContactsFilter(uri, ids, sContentValues[1], |
| sContentValues[5]); |
| } |
| |
| /** |
| * Tests that specifying the {@link android.provider.ContactsContract#REMOVE_DUPLICATE_ENTRIES} |
| * boolean parameter correctly results in deduped email addresses. |
| */ |
| public void testEmailQuery_removeDuplicateEntries() throws Exception{ |
| long[] ids = setupContactablesTestData(); |
| |
| // Insert duplicate data entry for raw contact 3. (existing email doeassociates@deer.com) |
| mRawContacts[2].newDataRow(Email.CONTENT_ITEM_TYPE) |
| .with(Email.DATA, "doeassociates@deer.com") |
| .with(Email.TYPE, Email.TYPE_WORK) |
| .insert(); |
| |
| ContentValues dupe = new ContentValues(); |
| dupe.put(Contacts.DISPLAY_NAME, "John Doe"); |
| dupe.put(Data.MIMETYPE, Email.CONTENT_ITEM_TYPE); |
| dupe.put(Email.DATA, "doeassociates@deer.com"); |
| dupe.put(Email.TYPE, Email.TYPE_WORK); |
| |
| // Query for all email addresses in the contacts database (without deduping). |
| // The email address above should be listed twice, in its duplicated forms. |
| assertCursorStoredValuesWithRawContactsFilter(Email.CONTENT_URI, ids, sContentValues[0], |
| sContentValues[2], sContentValues[3], sContentValues[4], dupe); |
| |
| // Now query for all email addresses in the contacts database but request deduping. |
| // The email address should now be listed only once. |
| Uri uri = Email.CONTENT_URI.buildUpon(). |
| appendQueryParameter(ContactsContract.REMOVE_DUPLICATE_ENTRIES, "true").build(); |
| assertCursorStoredValuesWithRawContactsFilter(uri, ids, sContentValues[0], |
| sContentValues[2], sContentValues[3], sContentValues[4]); |
| } |
| |
| public void testDataUpdate_updatesContactLastUpdatedTimestamp() { |
| DatabaseAsserts.ContactIdPair ids = DatabaseAsserts.assertAndCreateContact(mResolver); |
| long dataId = createData(ids.mRawContactId); |
| long baseTime = ContactUtil.queryContactLastUpdatedTimestamp(mResolver, ids.mContactId); |
| |
| SystemClock.sleep(1); |
| ContentValues values = new ContentValues(); |
| values.put(CommonDataKinds.Phone.NUMBER, "555-5555"); |
| DataUtil.update(mResolver, dataId, values); |
| |
| long newTime = ContactUtil.queryContactLastUpdatedTimestamp(mResolver, ids.mContactId); |
| assertTrue("Expected contact " + ids.mContactId + " last updated to be greater than " + |
| baseTime + ". But was " + newTime, newTime > baseTime); |
| |
| // Clean up |
| RawContactUtil.delete(mResolver, ids.mRawContactId, true); |
| } |
| |
| private long createData(long rawContactId) { |
| ContentValues values = new ContentValues(); |
| values.put(Data.MIMETYPE, CommonDataKinds.Phone.CONTENT_ITEM_TYPE); |
| values.put(CommonDataKinds.Phone.NUMBER, "1-800-GOOG-411"); |
| values.put(CommonDataKinds.Phone.TYPE, CommonDataKinds.Phone.TYPE_CUSTOM); |
| values.put(CommonDataKinds.Phone.LABEL, "free directory assistance"); |
| return DataUtil.insertData(mResolver, rawContactId, values); |
| } |
| |
| private void assertCursorStoredValuesWithRawContactsFilter(Uri uri, long[] rawContactsId, |
| ContentValues... expected) { |
| // We need this helper function to add a filter for specific raw contacts because |
| // otherwise tests will fail if performed on a device with existing contacts data |
| StringBuilder sb = new StringBuilder(); |
| sb.append(Data.RAW_CONTACT_ID + " in "); |
| sb.append("("); |
| for (int i = 0; i < rawContactsId.length; i++) { |
| if (i != 0) sb.append(","); |
| sb.append(rawContactsId[i]); |
| } |
| sb.append(")"); |
| DatabaseAsserts.assertStoredValuesInUriMatchExactly(mResolver, uri, null, sb.toString(), |
| null, null, false, expected); |
| } |
| |
| |
| private long[] setupContactablesTestData() throws Exception { |
| TestRawContact rawContact = mBuilder.newRawContact() |
| .with(RawContacts.ACCOUNT_TYPE, "test_account") |
| .with(RawContacts.ACCOUNT_NAME, "test_name") |
| .insert(); |
| rawContact.newDataRow(StructuredName.CONTENT_ITEM_TYPE) |
| .with(StructuredName.DISPLAY_NAME, "Hot Tamale") |
| .insert(); |
| rawContact.newDataRow(Email.CONTENT_ITEM_TYPE) |
| .with(Email.DATA, "tamale@acme.com") |
| .with(Email.TYPE, Email.TYPE_HOME) |
| .insert(); |
| rawContact.newDataRow(Email.CONTENT_ITEM_TYPE) |
| .with(Email.DATA, "hot@google.com") |
| .with(Email.TYPE, Email.TYPE_WORK) |
| .insert(); |
| rawContact.newDataRow(Phone.CONTENT_ITEM_TYPE) |
| .with(Phone.DATA, "510-123-5769") |
| .with(Email.TYPE, Phone.TYPE_HOME) |
| .insert(); |
| mRawContacts[0] = rawContact; |
| |
| TestRawContact rawContact2 = mBuilder.newRawContact() |
| .with(RawContacts.ACCOUNT_TYPE, "test_account") |
| .with(RawContacts.ACCOUNT_NAME, "test_name") |
| .insert(); |
| rawContact2.newDataRow(StructuredName.CONTENT_ITEM_TYPE) |
| .with(StructuredName.DISPLAY_NAME, "Cold Tamago") |
| .insert(); |
| rawContact2.newDataRow(Email.CONTENT_ITEM_TYPE) |
| .with(Email.DATA, "eggs@farmers.org") |
| .with(Email.TYPE, Email.TYPE_HOME) |
| .insert(); |
| rawContact2.newDataRow(SipAddress.CONTENT_ITEM_TYPE) |
| .with(SipAddress.DATA, "mysip@sipaddress.com") |
| .with(SipAddress.TYPE, SipAddress.TYPE_HOME) |
| .insert(); |
| rawContact2.newDataRow(Organization.CONTENT_ITEM_TYPE) |
| .with(Organization.COMPANY, "Doe Corp") |
| .insert(); |
| mRawContacts[1] = rawContact2; |
| |
| TestRawContact rawContact3 = mBuilder.newRawContact() |
| .with(RawContacts.ACCOUNT_TYPE, "test_account") |
| .with(RawContacts.ACCOUNT_NAME, "test_name") |
| .insert(); |
| rawContact3.newDataRow(StructuredName.CONTENT_ITEM_TYPE) |
| .with(StructuredName.DISPLAY_NAME, "John Doe") |
| .insert(); |
| rawContact3.newDataRow(Email.CONTENT_ITEM_TYPE) |
| .with(Email.DATA, "doeassociates@deer.com") |
| .with(Email.TYPE, Email.TYPE_WORK) |
| .insert(); |
| rawContact3.newDataRow(Phone.CONTENT_ITEM_TYPE) |
| .with(Phone.DATA, "518-354-1111") |
| .with(Phone.TYPE, Phone.TYPE_HOME) |
| .insert(); |
| rawContact3.newDataRow(Organization.CONTENT_ITEM_TYPE) |
| .with(Organization.DATA, "Doe Industries") |
| .insert(); |
| mRawContacts[2] = rawContact3; |
| return new long[] {rawContact.getId(), rawContact2.getId(), rawContact3.getId()}; |
| } |
| |
| // Provides functionality to set up content values for the Contactables tests |
| private static class ContactablesTestHelper { |
| |
| /** |
| * @return An arraylist of contentValues that correspond to the provided raw contacts |
| */ |
| public static ContentValues[] getContentValues(int... rawContacts) { |
| ArrayList<ContentValues> cv = new ArrayList<ContentValues>(); |
| for (int i = 0; i < rawContacts.length; i++) { |
| switch (rawContacts[i]) { |
| case 0: |
| // rawContact 0 "Hot Tamale" contains ContentValues 0, 1, and 2 |
| cv.add(sContentValues[0]); |
| cv.add(sContentValues[1]); |
| cv.add(sContentValues[2]); |
| break; |
| case 1: |
| // rawContact 1 "Cold Tamago" contains ContentValues 3 |
| cv.add(sContentValues[3]); |
| break; |
| case 2: |
| // rawContact 1 "John Doe" contains ContentValues 4, 5 |
| cv.add(sContentValues[4]); |
| cv.add(sContentValues[5]); |
| break; |
| } |
| } |
| ContentValues[] toReturn = new ContentValues[cv.size()]; |
| for (int i = 0; i < cv.size(); i++) { |
| toReturn[i] = cv.get(i); |
| } |
| return toReturn; |
| } |
| } |
| } |
| |
