BaseContactsProvider2Test.java revision e2579e029472f76b2dfda141444d775c67da0ec8
1d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov/* 2d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov * Copyright (C) 2009 The Android Open Source Project 3d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov * 4d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov * Licensed under the Apache License, Version 2.0 (the "License"); 5d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov * you may not use this file except in compliance with the License. 6d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov * You may obtain a copy of the License at 7d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov * 8d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov * http://www.apache.org/licenses/LICENSE-2.0 9d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov * 10d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov * Unless required by applicable law or agreed to in writing, software 11d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov * distributed under the License is distributed on an "AS IS" BASIS, 12d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. 13d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov * See the License for the specific language governing permissions and 14d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov * limitations under the License. 15d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov */ 1628f8857b1b46bde18b85c6d3c2a63ac44c3c2e1cEvan Millarpackage com.android.providers.contacts; 17d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov 1828f8857b1b46bde18b85c6d3c2a63ac44c3c2e1cEvan Millarimport static com.android.providers.contacts.ContactsActor.PACKAGE_GREY; 19d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov 20e99988b266dd1263162583e81e2b408e7329b1c8Dmitri Plotnikovimport android.accounts.Account; 21bee1a6b2e7cbea778195890e442c9e50f2a4e6d9Dmitri Plotnikovimport android.content.ContentProvider; 22b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikovimport android.content.ContentResolver; 23d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikovimport android.content.ContentUris; 24d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikovimport android.content.ContentValues; 25e99988b266dd1263162583e81e2b408e7329b1c8Dmitri Plotnikovimport android.content.Context; 269261b2141aa90a4fed632fd6da03026d4c216280Fred Quintanaimport android.content.Entity; 27a908fb5f39aa2021662a6cc317cc7e4db2d8bfb0Dmitri Plotnikovimport android.content.res.Resources; 28d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikovimport android.database.Cursor; 29d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikovimport android.net.Uri; 30bee1a6b2e7cbea778195890e442c9e50f2a4e6d9Dmitri Plotnikovimport android.provider.ContactsContract; 31d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikovimport android.provider.ContactsContract.AggregationExceptions; 32e99988b266dd1263162583e81e2b408e7329b1c8Dmitri Plotnikovimport android.provider.ContactsContract.Contacts; 33d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikovimport android.provider.ContactsContract.Data; 349261b2141aa90a4fed632fd6da03026d4c216280Fred Quintanaimport android.provider.ContactsContract.Groups; 35bc5c799a52b5bde2f273efd118ebe2228c3d8f15Evan Millarimport android.provider.ContactsContract.Presence; 36e99988b266dd1263162583e81e2b408e7329b1c8Dmitri Plotnikovimport android.provider.ContactsContract.RawContacts; 37a5ad551e1753086825499f1aeb6415bb986f3588Dmitri Plotnikovimport android.provider.ContactsContract.CommonDataKinds.Email; 389261b2141aa90a4fed632fd6da03026d4c216280Fred Quintanaimport android.provider.ContactsContract.CommonDataKinds.GroupMembership; 39e99988b266dd1263162583e81e2b408e7329b1c8Dmitri Plotnikovimport android.provider.ContactsContract.CommonDataKinds.Im; 40a5ad551e1753086825499f1aeb6415bb986f3588Dmitri Plotnikovimport android.provider.ContactsContract.CommonDataKinds.Nickname; 41bf659107617a6291ba8bfeebc3f2e50138075ab5Dmitri Plotnikovimport android.provider.ContactsContract.CommonDataKinds.Phone; 42ae6ca1f34cf5458d79ec803411d4308879a91e92Evan Millarimport android.provider.ContactsContract.CommonDataKinds.Photo; 43e99988b266dd1263162583e81e2b408e7329b1c8Dmitri Plotnikovimport android.provider.ContactsContract.CommonDataKinds.StructuredName; 444a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikovimport android.provider.ContactsContract.CommonDataKinds.StructuredPostal; 45d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikovimport android.test.AndroidTestCase; 46d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikovimport android.test.mock.MockContentResolver; 47d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikovimport android.test.suitebuilder.annotation.LargeTest; 48b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikovimport android.util.Log; 49bee1a6b2e7cbea778195890e442c9e50f2a4e6d9Dmitri Plotnikov 50a908fb5f39aa2021662a6cc317cc7e4db2d8bfb0Dmitri Plotnikovimport java.io.ByteArrayOutputStream; 51a908fb5f39aa2021662a6cc317cc7e4db2d8bfb0Dmitri Plotnikovimport java.io.IOException; 52a908fb5f39aa2021662a6cc317cc7e4db2d8bfb0Dmitri Plotnikovimport java.io.InputStream; 539261b2141aa90a4fed632fd6da03026d4c216280Fred Quintanaimport java.util.ArrayList; 549261b2141aa90a4fed632fd6da03026d4c216280Fred Quintanaimport java.util.Arrays; 55e99988b266dd1263162583e81e2b408e7329b1c8Dmitri Plotnikovimport java.util.Comparator; 56ff2de103f7e3eeeff4665ef63f07460fef053d6dDmitri Plotnikovimport java.util.Iterator; 5720a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikovimport java.util.Map; 5820a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikovimport java.util.Set; 59ff2de103f7e3eeeff4665ef63f07460fef053d6dDmitri Plotnikovimport java.util.Map.Entry; 60d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov 61d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov/** 62d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov * A common superclass for {@link ContactsProvider2}-related tests. 63d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov */ 64d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov@LargeTest 65d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikovpublic abstract class BaseContactsProvider2Test extends AndroidTestCase { 66d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov 67d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov protected static final String PACKAGE = "ContactsProvider2Test"; 68d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov 69bee1a6b2e7cbea778195890e442c9e50f2a4e6d9Dmitri Plotnikov protected ContactsActor mActor; 70d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov protected MockContentResolver mResolver; 719261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana protected Account mAccount = new Account("account1", "account type1"); 72e2579e029472f76b2dfda141444d775c67da0ec8Cynthia Wong protected Account mAccountTwo = new Account("account2", "account type2"); 739261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana 742482dd0309794d57233d0af37a7c12fc647e7bf9Dmitri Plotnikov private byte[] mTestPhoto; 752482dd0309794d57233d0af37a7c12fc647e7bf9Dmitri Plotnikov 769261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana protected final static Long NO_LONG = new Long(0); 779261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana protected final static String NO_STRING = new String(""); 789261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana protected final static Account NO_ACCOUNT = new Account("a", "b"); 79d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov 80bee1a6b2e7cbea778195890e442c9e50f2a4e6d9Dmitri Plotnikov protected Class<? extends ContentProvider> getProviderClass() { 81bee1a6b2e7cbea778195890e442c9e50f2a4e6d9Dmitri Plotnikov return SynchronousContactsProvider2.class; 82bee1a6b2e7cbea778195890e442c9e50f2a4e6d9Dmitri Plotnikov } 83bee1a6b2e7cbea778195890e442c9e50f2a4e6d9Dmitri Plotnikov 84bee1a6b2e7cbea778195890e442c9e50f2a4e6d9Dmitri Plotnikov protected String getAuthority() { 85bee1a6b2e7cbea778195890e442c9e50f2a4e6d9Dmitri Plotnikov return ContactsContract.AUTHORITY; 86bee1a6b2e7cbea778195890e442c9e50f2a4e6d9Dmitri Plotnikov } 87bee1a6b2e7cbea778195890e442c9e50f2a4e6d9Dmitri Plotnikov 88d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov @Override 89d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov protected void setUp() throws Exception { 90d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov super.setUp(); 91d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov 92bee1a6b2e7cbea778195890e442c9e50f2a4e6d9Dmitri Plotnikov mActor = new ContactsActor(getContext(), PACKAGE_GREY, getProviderClass(), getAuthority()); 93d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov mResolver = mActor.resolver; 94445ca81effbb0d61c7bc0033acf2d3dfd228fd4eDmitri Plotnikov if (mActor.provider instanceof SynchronousContactsProvider2) { 95445ca81effbb0d61c7bc0033acf2d3dfd228fd4eDmitri Plotnikov ((SynchronousContactsProvider2) mActor.provider) 96445ca81effbb0d61c7bc0033acf2d3dfd228fd4eDmitri Plotnikov .getOpenHelper(mActor.context).wipeData(); 97445ca81effbb0d61c7bc0033acf2d3dfd228fd4eDmitri Plotnikov } 989261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana } 999261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana 100e99988b266dd1263162583e81e2b408e7329b1c8Dmitri Plotnikov public Context getMockContext() { 101e99988b266dd1263162583e81e2b408e7329b1c8Dmitri Plotnikov return mActor.context; 102e99988b266dd1263162583e81e2b408e7329b1c8Dmitri Plotnikov } 103e99988b266dd1263162583e81e2b408e7329b1c8Dmitri Plotnikov 104e99988b266dd1263162583e81e2b408e7329b1c8Dmitri Plotnikov public void addAuthority(String authority) { 105e99988b266dd1263162583e81e2b408e7329b1c8Dmitri Plotnikov mActor.addAuthority(authority); 106e99988b266dd1263162583e81e2b408e7329b1c8Dmitri Plotnikov } 107e99988b266dd1263162583e81e2b408e7329b1c8Dmitri Plotnikov 108e99988b266dd1263162583e81e2b408e7329b1c8Dmitri Plotnikov public ContentProvider addProvider(Class<? extends ContentProvider> providerClass, 109e99988b266dd1263162583e81e2b408e7329b1c8Dmitri Plotnikov String authority) throws Exception { 110e99988b266dd1263162583e81e2b408e7329b1c8Dmitri Plotnikov return mActor.addProvider(providerClass, authority); 111e99988b266dd1263162583e81e2b408e7329b1c8Dmitri Plotnikov } 112e99988b266dd1263162583e81e2b408e7329b1c8Dmitri Plotnikov 1133d8b043c3341a5b6c2e781b7eba9767d5cd13267Dmitri Plotnikov public ContentProvider getProvider() { 1143d8b043c3341a5b6c2e781b7eba9767d5cd13267Dmitri Plotnikov return mActor.provider; 1153d8b043c3341a5b6c2e781b7eba9767d5cd13267Dmitri Plotnikov } 1163d8b043c3341a5b6c2e781b7eba9767d5cd13267Dmitri Plotnikov 1179261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana protected Uri maybeAddAccountQueryParameters(Uri uri, Account account) { 1189261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana if (account == null) { 1199261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana return uri; 1209261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana } 1219261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana return uri.buildUpon() 122df9fd6b239de5829b04cb413e4dfa3e6da649c38Fred Quintana .appendQueryParameter(RawContacts.ACCOUNT_NAME, account.name) 123df9fd6b239de5829b04cb413e4dfa3e6da649c38Fred Quintana .appendQueryParameter(RawContacts.ACCOUNT_TYPE, account.type) 1249261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana .build(); 125d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov } 126d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov 127d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov protected long createRawContact() { 128226c3dc6e93ca76a84c99100caa31045cba06cf6Fred Quintana return createRawContact(null); 129d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov } 130d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov 131c70dc0e38ff82c6e6d6b7458637c54fbdf446aacDmitri Plotnikov protected long createRawContactWithName() { 1323cfe8d532d509fbbe605454e3a32b2361b7e1501Dmitri Plotnikov return createRawContactWithName("John", "Doe"); 1333cfe8d532d509fbbe605454e3a32b2361b7e1501Dmitri Plotnikov } 1343cfe8d532d509fbbe605454e3a32b2361b7e1501Dmitri Plotnikov 1353cfe8d532d509fbbe605454e3a32b2361b7e1501Dmitri Plotnikov protected long createRawContactWithName(String firstName, String lastName) { 136c70dc0e38ff82c6e6d6b7458637c54fbdf446aacDmitri Plotnikov long rawContactId = createRawContact(null); 1373cfe8d532d509fbbe605454e3a32b2361b7e1501Dmitri Plotnikov insertStructuredName(rawContactId, firstName, lastName); 138c70dc0e38ff82c6e6d6b7458637c54fbdf446aacDmitri Plotnikov return rawContactId; 139c70dc0e38ff82c6e6d6b7458637c54fbdf446aacDmitri Plotnikov } 140c70dc0e38ff82c6e6d6b7458637c54fbdf446aacDmitri Plotnikov 141226c3dc6e93ca76a84c99100caa31045cba06cf6Fred Quintana protected long createRawContact(Account account, String... extras) { 1429261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana ContentValues values = new ContentValues(); 143226c3dc6e93ca76a84c99100caa31045cba06cf6Fred Quintana for (int i = 0; i < extras.length; ) { 144226c3dc6e93ca76a84c99100caa31045cba06cf6Fred Quintana values.put(extras[i], extras[i + 1]); 145226c3dc6e93ca76a84c99100caa31045cba06cf6Fred Quintana i += 2; 146226c3dc6e93ca76a84c99100caa31045cba06cf6Fred Quintana } 1476cffee46a1334d2b3ed19f436b27638451541044Dmitri Plotnikov final Uri uri = maybeAddAccountQueryParameters(RawContacts.CONTENT_URI, account); 1489261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana Uri contactUri = mResolver.insert(uri, values); 1499261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana return ContentUris.parseId(contactUri); 1509261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana } 1519261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana 1529261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana protected long createGroup(Account account, String sourceId, String title) { 1539261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana ContentValues values = new ContentValues(); 1549261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana values.put(Groups.SOURCE_ID, sourceId); 1559261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana values.put(Groups.TITLE, title); 156a908fb5f39aa2021662a6cc317cc7e4db2d8bfb0Dmitri Plotnikov values.put(Groups.GROUP_VISIBLE, 1); 1579261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana final Uri uri = maybeAddAccountQueryParameters(Groups.CONTENT_URI, account); 1589261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana return ContentUris.parseId(mResolver.insert(uri, values)); 1599261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana } 1609261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana 1615ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov protected Uri insertStructuredName(long rawContactId, String givenName, String familyName) { 162d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov ContentValues values = new ContentValues(); 163d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov StringBuilder sb = new StringBuilder(); 164d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov if (givenName != null) { 165d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov sb.append(givenName); 166d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov } 167d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov if (givenName != null && familyName != null) { 168d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov sb.append(" "); 169d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov } 170d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov if (familyName != null) { 171d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov sb.append(familyName); 172d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov } 173d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov values.put(StructuredName.DISPLAY_NAME, sb.toString()); 174d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov values.put(StructuredName.GIVEN_NAME, givenName); 175d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov values.put(StructuredName.FAMILY_NAME, familyName); 176d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov 1775ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov return insertStructuredName(rawContactId, values); 1784097855e2d672b3f8e1c5c8a169efb80203bf53eDmitri Plotnikov } 1794097855e2d672b3f8e1c5c8a169efb80203bf53eDmitri Plotnikov 1805ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov protected Uri insertStructuredName(long rawContactId, ContentValues values) { 1815ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov values.put(Data.RAW_CONTACT_ID, rawContactId); 1824097855e2d672b3f8e1c5c8a169efb80203bf53eDmitri Plotnikov values.put(Data.MIMETYPE, StructuredName.CONTENT_ITEM_TYPE); 183d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov Uri resultUri = mResolver.insert(Data.CONTENT_URI, values); 184d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov return resultUri; 185d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov } 186d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov 1875ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov protected Uri insertPhoneNumber(long rawContactId, String phoneNumber) { 188bf659107617a6291ba8bfeebc3f2e50138075ab5Dmitri Plotnikov ContentValues values = new ContentValues(); 1895ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov values.put(Data.RAW_CONTACT_ID, rawContactId); 190bf659107617a6291ba8bfeebc3f2e50138075ab5Dmitri Plotnikov values.put(Data.MIMETYPE, Phone.CONTENT_ITEM_TYPE); 191bf659107617a6291ba8bfeebc3f2e50138075ab5Dmitri Plotnikov values.put(Phone.NUMBER, phoneNumber); 1923cebbf7141252768d3e272e049e9c5b0cb9d710eDmitri Plotnikov values.put(Phone.TYPE, Phone.TYPE_HOME); 193bf659107617a6291ba8bfeebc3f2e50138075ab5Dmitri Plotnikov 194bf659107617a6291ba8bfeebc3f2e50138075ab5Dmitri Plotnikov Uri resultUri = mResolver.insert(Data.CONTENT_URI, values); 195bf659107617a6291ba8bfeebc3f2e50138075ab5Dmitri Plotnikov return resultUri; 196bf659107617a6291ba8bfeebc3f2e50138075ab5Dmitri Plotnikov } 197bf659107617a6291ba8bfeebc3f2e50138075ab5Dmitri Plotnikov 1985ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov protected Uri insertEmail(long rawContactId, String email) { 199a5ad551e1753086825499f1aeb6415bb986f3588Dmitri Plotnikov ContentValues values = new ContentValues(); 2005ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov values.put(Data.RAW_CONTACT_ID, rawContactId); 201a5ad551e1753086825499f1aeb6415bb986f3588Dmitri Plotnikov values.put(Data.MIMETYPE, Email.CONTENT_ITEM_TYPE); 202a5ad551e1753086825499f1aeb6415bb986f3588Dmitri Plotnikov values.put(Email.DATA, email); 2033cebbf7141252768d3e272e049e9c5b0cb9d710eDmitri Plotnikov values.put(Email.TYPE, Email.TYPE_HOME); 204a5ad551e1753086825499f1aeb6415bb986f3588Dmitri Plotnikov 205a5ad551e1753086825499f1aeb6415bb986f3588Dmitri Plotnikov Uri resultUri = mResolver.insert(Data.CONTENT_URI, values); 206a5ad551e1753086825499f1aeb6415bb986f3588Dmitri Plotnikov return resultUri; 207a5ad551e1753086825499f1aeb6415bb986f3588Dmitri Plotnikov } 208a5ad551e1753086825499f1aeb6415bb986f3588Dmitri Plotnikov 2095ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov protected Uri insertNickname(long rawContactId, String nickname) { 210a5ad551e1753086825499f1aeb6415bb986f3588Dmitri Plotnikov ContentValues values = new ContentValues(); 2115ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov values.put(Data.RAW_CONTACT_ID, rawContactId); 212a5ad551e1753086825499f1aeb6415bb986f3588Dmitri Plotnikov values.put(Data.MIMETYPE, Nickname.CONTENT_ITEM_TYPE); 213a5ad551e1753086825499f1aeb6415bb986f3588Dmitri Plotnikov values.put(Nickname.NAME, nickname); 2143cebbf7141252768d3e272e049e9c5b0cb9d710eDmitri Plotnikov values.put(Nickname.TYPE, Nickname.TYPE_OTHER_NAME); 215a5ad551e1753086825499f1aeb6415bb986f3588Dmitri Plotnikov 216a5ad551e1753086825499f1aeb6415bb986f3588Dmitri Plotnikov Uri resultUri = mResolver.insert(Data.CONTENT_URI, values); 217a5ad551e1753086825499f1aeb6415bb986f3588Dmitri Plotnikov return resultUri; 218a5ad551e1753086825499f1aeb6415bb986f3588Dmitri Plotnikov } 219a5ad551e1753086825499f1aeb6415bb986f3588Dmitri Plotnikov 2204a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov protected Uri insertPostalAddress(long rawContactId, String formattedAddress) { 2214a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov ContentValues values = new ContentValues(); 2224a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov values.put(Data.RAW_CONTACT_ID, rawContactId); 2234a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov values.put(Data.MIMETYPE, StructuredPostal.CONTENT_ITEM_TYPE); 2244a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov values.put(StructuredPostal.FORMATTED_ADDRESS, formattedAddress); 2254a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov 2264a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov Uri resultUri = mResolver.insert(Data.CONTENT_URI, values); 2274a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov return resultUri; 2284a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov } 2294a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov 2305ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov protected Uri insertPhoto(long rawContactId) { 231ae6ca1f34cf5458d79ec803411d4308879a91e92Evan Millar ContentValues values = new ContentValues(); 2325ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov values.put(Data.RAW_CONTACT_ID, rawContactId); 233ae6ca1f34cf5458d79ec803411d4308879a91e92Evan Millar values.put(Data.MIMETYPE, Photo.CONTENT_ITEM_TYPE); 2342482dd0309794d57233d0af37a7c12fc647e7bf9Dmitri Plotnikov values.put(Photo.PHOTO, loadTestPhoto()); 235ae6ca1f34cf5458d79ec803411d4308879a91e92Evan Millar Uri resultUri = mResolver.insert(Data.CONTENT_URI, values); 236ae6ca1f34cf5458d79ec803411d4308879a91e92Evan Millar return resultUri; 237ae6ca1f34cf5458d79ec803411d4308879a91e92Evan Millar } 238ae6ca1f34cf5458d79ec803411d4308879a91e92Evan Millar 2395ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov protected Uri insertGroupMembership(long rawContactId, String sourceId) { 2409261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana ContentValues values = new ContentValues(); 2415ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov values.put(Data.RAW_CONTACT_ID, rawContactId); 2429261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana values.put(Data.MIMETYPE, GroupMembership.CONTENT_ITEM_TYPE); 2439261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana values.put(GroupMembership.GROUP_SOURCE_ID, sourceId); 2449261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana return mResolver.insert(Data.CONTENT_URI, values); 2459261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana } 2469261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana 2475ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov protected Uri insertGroupMembership(long rawContactId, Long groupId) { 2489261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana ContentValues values = new ContentValues(); 2495ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov values.put(Data.RAW_CONTACT_ID, rawContactId); 2509261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana values.put(Data.MIMETYPE, GroupMembership.CONTENT_ITEM_TYPE); 2519261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana values.put(GroupMembership.GROUP_ROW_ID, groupId); 2529261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana return mResolver.insert(Data.CONTENT_URI, values); 2539261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana } 2549261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana 2554dcd106ccc27dbbfaae86baf0cd57beb42c27cccDmitri Plotnikov protected Uri insertPresence(int protocol, String customProtocol, String handle, int presence, 2564dcd106ccc27dbbfaae86baf0cd57beb42c27cccDmitri Plotnikov String status) { 257bc5c799a52b5bde2f273efd118ebe2228c3d8f15Evan Millar ContentValues values = new ContentValues(); 2584dcd106ccc27dbbfaae86baf0cd57beb42c27cccDmitri Plotnikov values.put(Presence.PROTOCOL, protocol); 2594dcd106ccc27dbbfaae86baf0cd57beb42c27cccDmitri Plotnikov values.put(Presence.CUSTOM_PROTOCOL, customProtocol); 260bc5c799a52b5bde2f273efd118ebe2228c3d8f15Evan Millar values.put(Presence.IM_HANDLE, handle); 261bc5c799a52b5bde2f273efd118ebe2228c3d8f15Evan Millar values.put(Presence.PRESENCE_STATUS, presence); 262e46667e641cd1c60998e1ccab4b60531d5b12ef7Dmitri Plotnikov values.put(Presence.PRESENCE_CUSTOM_STATUS, status); 263bc5c799a52b5bde2f273efd118ebe2228c3d8f15Evan Millar 264bc5c799a52b5bde2f273efd118ebe2228c3d8f15Evan Millar Uri resultUri = mResolver.insert(Presence.CONTENT_URI, values); 265bc5c799a52b5bde2f273efd118ebe2228c3d8f15Evan Millar return resultUri; 266bc5c799a52b5bde2f273efd118ebe2228c3d8f15Evan Millar } 267bc5c799a52b5bde2f273efd118ebe2228c3d8f15Evan Millar 2684dcd106ccc27dbbfaae86baf0cd57beb42c27cccDmitri Plotnikov protected Uri insertImHandle(long rawContactId, int protocol, String customProtocol, 2694dcd106ccc27dbbfaae86baf0cd57beb42c27cccDmitri Plotnikov String handle) { 270bc5c799a52b5bde2f273efd118ebe2228c3d8f15Evan Millar ContentValues values = new ContentValues(); 2715ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov values.put(Data.RAW_CONTACT_ID, rawContactId); 272bc5c799a52b5bde2f273efd118ebe2228c3d8f15Evan Millar values.put(Data.MIMETYPE, Im.CONTENT_ITEM_TYPE); 273bc5c799a52b5bde2f273efd118ebe2228c3d8f15Evan Millar values.put(Im.PROTOCOL, protocol); 2744dcd106ccc27dbbfaae86baf0cd57beb42c27cccDmitri Plotnikov values.put(Im.CUSTOM_PROTOCOL, customProtocol); 275bc5c799a52b5bde2f273efd118ebe2228c3d8f15Evan Millar values.put(Im.DATA, handle); 2763cebbf7141252768d3e272e049e9c5b0cb9d710eDmitri Plotnikov values.put(Im.TYPE, Im.TYPE_HOME); 277bc5c799a52b5bde2f273efd118ebe2228c3d8f15Evan Millar 278bc5c799a52b5bde2f273efd118ebe2228c3d8f15Evan Millar Uri resultUri = mResolver.insert(Data.CONTENT_URI, values); 279bc5c799a52b5bde2f273efd118ebe2228c3d8f15Evan Millar return resultUri; 280bc5c799a52b5bde2f273efd118ebe2228c3d8f15Evan Millar } 281bc5c799a52b5bde2f273efd118ebe2228c3d8f15Evan Millar 2825ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov protected void setContactAccountName(long rawContactId, String accountName) { 283ae6ca1f34cf5458d79ec803411d4308879a91e92Evan Millar ContentValues values = new ContentValues(); 2846cffee46a1334d2b3ed19f436b27638451541044Dmitri Plotnikov values.put(RawContacts.ACCOUNT_NAME, accountName); 285ae6ca1f34cf5458d79ec803411d4308879a91e92Evan Millar 286ae6ca1f34cf5458d79ec803411d4308879a91e92Evan Millar mResolver.update(ContentUris.withAppendedId( 2875ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov RawContacts.CONTENT_URI, rawContactId), values, null, null); 288ae6ca1f34cf5458d79ec803411d4308879a91e92Evan Millar } 289ae6ca1f34cf5458d79ec803411d4308879a91e92Evan Millar 290d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov protected void setAggregationException(int type, long contactId, long rawContactId) { 291d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov ContentValues values = new ContentValues(); 292d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov values.put(AggregationExceptions.CONTACT_ID, contactId); 2935ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov values.put(AggregationExceptions.RAW_CONTACT_ID, rawContactId); 294d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov values.put(AggregationExceptions.TYPE, type); 2953d8b043c3341a5b6c2e781b7eba9767d5cd13267Dmitri Plotnikov assertEquals(1, mResolver.update(AggregationExceptions.CONTENT_URI, values, null, null)); 296d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov } 297d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov 298d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov protected Cursor queryRawContact(long rawContactId) { 2995ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov return mResolver.query(ContentUris.withAppendedId(RawContacts.CONTENT_URI, rawContactId), null, 300d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov null, null, null); 301d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov } 302d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov 303d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov protected Cursor queryContact(long contactId) { 304d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov return mResolver.query(ContentUris.withAppendedId(Contacts.CONTENT_URI, contactId), 305d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov null, null, null, null); 306d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov } 307d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov 308d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov protected Cursor queryContactSummary(long contactId, String[] projection) { 309d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov return mResolver.query(ContentUris.withAppendedId(Contacts.CONTENT_SUMMARY_URI, 310d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov contactId), projection, null, null, null); 311bc5c799a52b5bde2f273efd118ebe2228c3d8f15Evan Millar } 312bc5c799a52b5bde2f273efd118ebe2228c3d8f15Evan Millar 313d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov protected Cursor queryContactSummary() { 314d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov return mResolver.query(Contacts.CONTENT_SUMMARY_URI, null, null, null, null); 315bc5c799a52b5bde2f273efd118ebe2228c3d8f15Evan Millar } 316bc5c799a52b5bde2f273efd118ebe2228c3d8f15Evan Millar 317d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov protected long queryContactId(long rawContactId) { 318d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov Cursor c = queryRawContact(rawContactId); 319d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov assertTrue(c.moveToFirst()); 320d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov long contactId = c.getLong(c.getColumnIndex(RawContacts.CONTACT_ID)); 321d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov c.close(); 322d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov return contactId; 323d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov } 324d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov 325d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov protected long queryPhotoId(long contactId) { 326d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov Cursor c = queryContact(contactId); 327ae6ca1f34cf5458d79ec803411d4308879a91e92Evan Millar assertTrue(c.moveToFirst()); 328d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov long photoId = c.getInt(c.getColumnIndex(Contacts.PHOTO_ID)); 329ae6ca1f34cf5458d79ec803411d4308879a91e92Evan Millar c.close(); 330ae6ca1f34cf5458d79ec803411d4308879a91e92Evan Millar return photoId; 331ae6ca1f34cf5458d79ec803411d4308879a91e92Evan Millar } 332ae6ca1f34cf5458d79ec803411d4308879a91e92Evan Millar 333d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov protected String queryDisplayName(long contactId) { 334d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov Cursor c = queryContact(contactId); 335d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov assertTrue(c.moveToFirst()); 336d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov String displayName = c.getString(c.getColumnIndex(Contacts.DISPLAY_NAME)); 337d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov c.close(); 338d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov return displayName; 339d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov } 340d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov 341d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov protected void assertAggregated(long rawContactId1, long rawContactId2) { 342d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov long contactId1 = queryContactId(rawContactId1); 343d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov long contactId2 = queryContactId(rawContactId2); 344d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov assertTrue(contactId1 == contactId2); 345bf659107617a6291ba8bfeebc3f2e50138075ab5Dmitri Plotnikov } 346bf659107617a6291ba8bfeebc3f2e50138075ab5Dmitri Plotnikov 347d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov protected void assertAggregated(long rawContactId1, long rawContactId2, 348d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov String expectedDisplayName) { 349d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov long contactId1 = queryContactId(rawContactId1); 350d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov long contactId2 = queryContactId(rawContactId2); 351d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov assertTrue(contactId1 == contactId2); 352d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov 353d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov String displayName = queryDisplayName(contactId1); 354d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov assertEquals(expectedDisplayName, displayName); 355d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov } 356d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov 357d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov protected void assertNotAggregated(long rawContactId1, long rawContactId2) { 358d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov long contactId1 = queryContactId(rawContactId1); 359d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov long contactId2 = queryContactId(rawContactId2); 360d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov assertTrue(contactId1 != contactId2); 361d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov } 3624097855e2d672b3f8e1c5c8a169efb80203bf53eDmitri Plotnikov 3635ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov protected void assertStructuredName(long rawContactId, String prefix, String givenName, 3644097855e2d672b3f8e1c5c8a169efb80203bf53eDmitri Plotnikov String middleName, String familyName, String suffix) { 3656cffee46a1334d2b3ed19f436b27638451541044Dmitri Plotnikov Uri uri = 3665ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov Uri.withAppendedPath(ContentUris.withAppendedId(RawContacts.CONTENT_URI, rawContactId), 3676cffee46a1334d2b3ed19f436b27638451541044Dmitri Plotnikov RawContacts.Data.CONTENT_DIRECTORY); 3684097855e2d672b3f8e1c5c8a169efb80203bf53eDmitri Plotnikov 3694097855e2d672b3f8e1c5c8a169efb80203bf53eDmitri Plotnikov final String[] projection = new String[] { 3704097855e2d672b3f8e1c5c8a169efb80203bf53eDmitri Plotnikov StructuredName.PREFIX, StructuredName.GIVEN_NAME, StructuredName.MIDDLE_NAME, 3714097855e2d672b3f8e1c5c8a169efb80203bf53eDmitri Plotnikov StructuredName.FAMILY_NAME, StructuredName.SUFFIX 3724097855e2d672b3f8e1c5c8a169efb80203bf53eDmitri Plotnikov }; 3734097855e2d672b3f8e1c5c8a169efb80203bf53eDmitri Plotnikov 3744097855e2d672b3f8e1c5c8a169efb80203bf53eDmitri Plotnikov Cursor c = mResolver.query(uri, projection, Data.MIMETYPE + "='" 3754097855e2d672b3f8e1c5c8a169efb80203bf53eDmitri Plotnikov + StructuredName.CONTENT_ITEM_TYPE + "'", null, null); 3764097855e2d672b3f8e1c5c8a169efb80203bf53eDmitri Plotnikov 3774097855e2d672b3f8e1c5c8a169efb80203bf53eDmitri Plotnikov assertTrue(c.moveToFirst()); 3784097855e2d672b3f8e1c5c8a169efb80203bf53eDmitri Plotnikov assertEquals(prefix, c.getString(0)); 3794097855e2d672b3f8e1c5c8a169efb80203bf53eDmitri Plotnikov assertEquals(givenName, c.getString(1)); 3804097855e2d672b3f8e1c5c8a169efb80203bf53eDmitri Plotnikov assertEquals(middleName, c.getString(2)); 3814097855e2d672b3f8e1c5c8a169efb80203bf53eDmitri Plotnikov assertEquals(familyName, c.getString(3)); 3824097855e2d672b3f8e1c5c8a169efb80203bf53eDmitri Plotnikov assertEquals(suffix, c.getString(4)); 3834097855e2d672b3f8e1c5c8a169efb80203bf53eDmitri Plotnikov c.close(); 3844097855e2d672b3f8e1c5c8a169efb80203bf53eDmitri Plotnikov } 3859261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana 3869261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana protected long assertSingleGroup(Long rowId, Account account, String sourceId, String title) { 3879261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana Cursor c = mResolver.query(Groups.CONTENT_URI, null, null, null, null); 3889261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana try { 3899261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana assertTrue(c.moveToNext()); 3909261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana long actualRowId = assertGroup(c, rowId, account, sourceId, title); 3919261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana assertFalse(c.moveToNext()); 3929261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana return actualRowId; 3939261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana } finally { 3949261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana c.close(); 3959261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana } 3969261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana } 3979261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana 3985ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov protected long assertSingleGroupMembership(Long rowId, Long rawContactId, Long groupRowId, 3999261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana String sourceId) { 4009261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana Cursor c = mResolver.query(ContactsContract.Data.CONTENT_URI, null, null, null, null); 4019261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana try { 4029261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana assertTrue(c.moveToNext()); 4035ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov long actualRowId = assertGroupMembership(c, rowId, rawContactId, groupRowId, sourceId); 4049261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana assertFalse(c.moveToNext()); 4059261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana return actualRowId; 4069261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana } finally { 4079261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana c.close(); 4089261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana } 4099261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana } 4109261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana 4115ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov protected long assertGroupMembership(Cursor c, Long rowId, Long rawContactId, Long groupRowId, 4129261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana String sourceId) { 4139261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana assertNullOrEquals(c, rowId, Data._ID); 4145ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov assertNullOrEquals(c, rawContactId, GroupMembership.RAW_CONTACT_ID); 4159261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana assertNullOrEquals(c, groupRowId, GroupMembership.GROUP_ROW_ID); 4169261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana assertNullOrEquals(c, sourceId, GroupMembership.GROUP_SOURCE_ID); 4179261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana return c.getLong(c.getColumnIndexOrThrow("_id")); 4189261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana } 4199261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana 4209261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana protected long assertGroup(Cursor c, Long rowId, Account account, String sourceId, String title) { 4219261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana assertNullOrEquals(c, rowId, Groups._ID); 4229261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana assertNullOrEquals(c, account); 4239261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana assertNullOrEquals(c, sourceId, Groups.SOURCE_ID); 4249261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana assertNullOrEquals(c, title, Groups.TITLE); 4259261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana return c.getLong(c.getColumnIndexOrThrow("_id")); 4269261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana } 4279261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana 4289261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana private void assertNullOrEquals(Cursor c, Account account) { 4299261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana if (account == NO_ACCOUNT) { 4309261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana return; 4319261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana } 4329261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana if (account == null) { 4339261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana assertTrue(c.isNull(c.getColumnIndexOrThrow(Groups.ACCOUNT_NAME))); 4349261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana assertTrue(c.isNull(c.getColumnIndexOrThrow(Groups.ACCOUNT_TYPE))); 4359261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana } else { 436df9fd6b239de5829b04cb413e4dfa3e6da649c38Fred Quintana assertEquals(account.name, c.getString(c.getColumnIndexOrThrow(Groups.ACCOUNT_NAME))); 437df9fd6b239de5829b04cb413e4dfa3e6da649c38Fred Quintana assertEquals(account.type, c.getString(c.getColumnIndexOrThrow(Groups.ACCOUNT_TYPE))); 4389261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana } 4399261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana } 4409261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana 4419261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana private void assertNullOrEquals(Cursor c, Long value, String columnName) { 4429261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana if (value != NO_LONG) { 4439261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana if (value == null) assertTrue(c.isNull(c.getColumnIndexOrThrow(columnName))); 4449261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana else assertEquals((long) value, c.getLong(c.getColumnIndexOrThrow(columnName))); 4459261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana } 4469261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana } 4479261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana 4489261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana private void assertNullOrEquals(Cursor c, String value, String columnName) { 4499261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana if (value != NO_STRING) { 4509261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana if (value == null) assertTrue(c.isNull(c.getColumnIndexOrThrow(columnName))); 4519261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana else assertEquals(value, c.getString(c.getColumnIndexOrThrow(columnName))); 4529261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana } 4539261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana } 4549261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana 4559261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana protected void assertDataRow(ContentValues actual, String expectedMimetype, 4569261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana Object... expectedArguments) { 4579261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana assertEquals(actual.toString(), expectedMimetype, actual.getAsString(Data.MIMETYPE)); 4589261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana for (int i = 0; i < expectedArguments.length; i += 2) { 4599261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana String columnName = (String) expectedArguments[i]; 4609261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana Object expectedValue = expectedArguments[i + 1]; 4619261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana if (expectedValue instanceof Uri) { 4629261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana expectedValue = ContentUris.parseId((Uri) expectedValue); 4639261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana } 4649261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana if (expectedValue == null) { 4659261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana assertNull(actual.toString(), actual.get(columnName)); 4669261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana } 4679261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana if (expectedValue instanceof Long) { 468226c3dc6e93ca76a84c99100caa31045cba06cf6Fred Quintana assertEquals("mismatch at " + columnName + " from " + actual.toString(), 469226c3dc6e93ca76a84c99100caa31045cba06cf6Fred Quintana expectedValue, actual.getAsLong(columnName)); 4709261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana } else if (expectedValue instanceof Integer) { 471226c3dc6e93ca76a84c99100caa31045cba06cf6Fred Quintana assertEquals("mismatch at " + columnName + " from " + actual.toString(), 472226c3dc6e93ca76a84c99100caa31045cba06cf6Fred Quintana expectedValue, actual.getAsInteger(columnName)); 4739261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana } else if (expectedValue instanceof String) { 474226c3dc6e93ca76a84c99100caa31045cba06cf6Fred Quintana assertEquals("mismatch at " + columnName + " from " + actual.toString(), 475226c3dc6e93ca76a84c99100caa31045cba06cf6Fred Quintana expectedValue, actual.getAsString(columnName)); 4769261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana } else { 477226c3dc6e93ca76a84c99100caa31045cba06cf6Fred Quintana assertEquals("mismatch at " + columnName + " from " + actual.toString(), 478226c3dc6e93ca76a84c99100caa31045cba06cf6Fred Quintana expectedValue, actual.get(columnName)); 4799261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana } 4809261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana } 4819261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana } 4829261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana 4839261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana protected static class IdComparator implements Comparator<ContentValues> { 4849261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana public int compare(ContentValues o1, ContentValues o2) { 4859261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana long id1 = o1.getAsLong(ContactsContract.Data._ID); 4869261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana long id2 = o2.getAsLong(ContactsContract.Data._ID); 4879261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana if (id1 == id2) return 0; 4889261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana return (id1 < id2) ? -1 : 1; 4899261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana } 4909261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana } 4919261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana 4929261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana protected ContentValues[] asSortedContentValuesArray( 4939261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana ArrayList<Entity.NamedContentValues> subValues) { 4949261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana ContentValues[] result = new ContentValues[subValues.size()]; 4959261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana int i = 0; 4969261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana for (Entity.NamedContentValues subValue : subValues) { 4979261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana result[i] = subValue.values; 4989261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana i++; 4999261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana } 5009261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana Arrays.sort(result, new IdComparator()); 5019261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana return result; 5029261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana } 5039261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana 5049261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana protected void assertDirty(Uri uri, boolean state) { 5059261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana Cursor c = mResolver.query(uri, new String[]{"dirty"}, null, null, null); 5069261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana assertTrue(c.moveToNext()); 5079261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana assertEquals(state, c.getLong(0) != 0); 5089261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana assertFalse(c.moveToNext()); 5093cfe8d532d509fbbe605454e3a32b2361b7e1501Dmitri Plotnikov c.close(); 5109261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana } 5119261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana 5129261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana protected long getVersion(Uri uri) { 5139261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana Cursor c = mResolver.query(uri, new String[]{"version"}, null, null, null); 5149261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana assertTrue(c.moveToNext()); 5159261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana long version = c.getLong(0); 5169261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana assertFalse(c.moveToNext()); 5173cfe8d532d509fbbe605454e3a32b2361b7e1501Dmitri Plotnikov c.close(); 5189261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana return version; 5199261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana } 5209261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana 5219261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana protected void clearDirty(Uri uri) { 5229261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana ContentValues values = new ContentValues(); 5239261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana values.put("dirty", 0); 5249261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana mResolver.update(uri, values, null, null); 5259261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana } 52620a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov 52720a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov protected void assertStoredValues(Uri rowUri, String column, String expectedValue) { 52820a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov String value = getStoredValue(rowUri, column); 52920a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov assertEquals("Column value " + column, expectedValue, value); 53020a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov } 53120a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov 53220a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov protected String getStoredValue(Uri rowUri, String column) { 5338e45e5f2142db78941b095f7418cc05b71668094Dmitri Plotnikov String value = null; 53420a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov Cursor c = mResolver.query(rowUri, new String[] { column }, null, null, null); 53520a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov try { 5368e45e5f2142db78941b095f7418cc05b71668094Dmitri Plotnikov if (c.moveToFirst()) { 5378e45e5f2142db78941b095f7418cc05b71668094Dmitri Plotnikov value = c.getString(c.getColumnIndex(column)); 5388e45e5f2142db78941b095f7418cc05b71668094Dmitri Plotnikov } 53920a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov } finally { 54020a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov c.close(); 54120a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov } 54220a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov return value; 54320a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov } 54420a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov 54520a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov protected void assertStoredValues(Uri rowUri, ContentValues expectedValues) { 54620a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov Cursor c = mResolver.query(rowUri, null, null, null, null); 54720a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov try { 54820a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov assertEquals("Record count", 1, c.getCount()); 54920a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov c.moveToFirst(); 55020a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov assertCursorValues(c, expectedValues); 55120a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov } finally { 55220a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov c.close(); 55320a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov } 55420a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov } 55520a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov 556ff2de103f7e3eeeff4665ef63f07460fef053d6dDmitri Plotnikov protected void assertStoredValuesWithProjection(Uri rowUri, ContentValues expectedValues) { 557ff2de103f7e3eeeff4665ef63f07460fef053d6dDmitri Plotnikov Cursor c = mResolver.query(rowUri, buildProjection(expectedValues), null, null, null); 558ff2de103f7e3eeeff4665ef63f07460fef053d6dDmitri Plotnikov try { 559ff2de103f7e3eeeff4665ef63f07460fef053d6dDmitri Plotnikov assertEquals("Record count", 1, c.getCount()); 560ff2de103f7e3eeeff4665ef63f07460fef053d6dDmitri Plotnikov c.moveToFirst(); 561ff2de103f7e3eeeff4665ef63f07460fef053d6dDmitri Plotnikov assertCursorValues(c, expectedValues); 562ff2de103f7e3eeeff4665ef63f07460fef053d6dDmitri Plotnikov } finally { 563ff2de103f7e3eeeff4665ef63f07460fef053d6dDmitri Plotnikov c.close(); 564ff2de103f7e3eeeff4665ef63f07460fef053d6dDmitri Plotnikov } 565ff2de103f7e3eeeff4665ef63f07460fef053d6dDmitri Plotnikov } 566ff2de103f7e3eeeff4665ef63f07460fef053d6dDmitri Plotnikov 56720a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov /** 56820a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov * Constructs a selection (where clause) out of all supplied values, uses it 56920a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov * to query the provider and verifies that a single row is returned and it 57020a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov * has the same values as requested. 57120a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov */ 57220a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov protected void assertSelection(Uri uri, ContentValues values, String idColumn, long id) { 573ff2de103f7e3eeeff4665ef63f07460fef053d6dDmitri Plotnikov assertSelection(uri, values, idColumn, id, null); 574ff2de103f7e3eeeff4665ef63f07460fef053d6dDmitri Plotnikov } 575ff2de103f7e3eeeff4665ef63f07460fef053d6dDmitri Plotnikov 576ff2de103f7e3eeeff4665ef63f07460fef053d6dDmitri Plotnikov public void assertSelectionWithProjection(Uri uri, ContentValues values, String idColumn, 577ff2de103f7e3eeeff4665ef63f07460fef053d6dDmitri Plotnikov long id) { 578ff2de103f7e3eeeff4665ef63f07460fef053d6dDmitri Plotnikov assertSelection(uri, values, idColumn, id, buildProjection(values)); 579ff2de103f7e3eeeff4665ef63f07460fef053d6dDmitri Plotnikov } 580ff2de103f7e3eeeff4665ef63f07460fef053d6dDmitri Plotnikov 581ff2de103f7e3eeeff4665ef63f07460fef053d6dDmitri Plotnikov private void assertSelection(Uri uri, ContentValues values, String idColumn, long id, 582ff2de103f7e3eeeff4665ef63f07460fef053d6dDmitri Plotnikov String[] projection) { 58320a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov StringBuilder sb = new StringBuilder(); 58420a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov ArrayList<String> selectionArgs = new ArrayList<String>(values.size()); 585c70dc0e38ff82c6e6d6b7458637c54fbdf446aacDmitri Plotnikov if (idColumn != null) { 586c70dc0e38ff82c6e6d6b7458637c54fbdf446aacDmitri Plotnikov sb.append(idColumn).append("=").append(id); 587c70dc0e38ff82c6e6d6b7458637c54fbdf446aacDmitri Plotnikov } 58820a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov Set<Map.Entry<String, Object>> entries = values.valueSet(); 58920a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov for (Map.Entry<String, Object> entry : entries) { 59020a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov String column = entry.getKey(); 59120a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov Object value = entry.getValue(); 592c70dc0e38ff82c6e6d6b7458637c54fbdf446aacDmitri Plotnikov if (sb.length() != 0) { 593c70dc0e38ff82c6e6d6b7458637c54fbdf446aacDmitri Plotnikov sb.append(" AND "); 594c70dc0e38ff82c6e6d6b7458637c54fbdf446aacDmitri Plotnikov } 595c70dc0e38ff82c6e6d6b7458637c54fbdf446aacDmitri Plotnikov sb.append(column); 59620a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov if (value == null) { 59720a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov sb.append(" IS NULL"); 59820a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov } else { 59920a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov sb.append("=?"); 60020a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov selectionArgs.add(String.valueOf(value)); 60120a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov } 60220a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov } 60320a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov 604ff2de103f7e3eeeff4665ef63f07460fef053d6dDmitri Plotnikov Cursor c = mResolver.query(uri, projection, sb.toString(), selectionArgs.toArray(new String[0]), 60520a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov null); 60620a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov try { 60720a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov assertEquals("Record count", 1, c.getCount()); 60820a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov c.moveToFirst(); 60920a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov assertCursorValues(c, values); 61020a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov } finally { 61120a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov c.close(); 61220a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov } 61320a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov } 61420a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov 61520a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov protected void assertCursorValues(Cursor cursor, ContentValues expectedValues) { 61620a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov Set<Map.Entry<String, Object>> entries = expectedValues.valueSet(); 61720a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov for (Map.Entry<String, Object> entry : entries) { 61820a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov String column = entry.getKey(); 61920a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov int index = cursor.getColumnIndex(column); 62020a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov assertTrue("No such column: " + column, index != -1); 62120a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov Object expectedValue = expectedValues.get(column); 62220a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov String value; 62320a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov if (expectedValue instanceof byte[]) { 62420a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov expectedValue = Hex.encodeHex((byte[])expectedValue, false); 62520a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov value = Hex.encodeHex(cursor.getBlob(index), false); 62620a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov } else { 62720a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov expectedValue = expectedValues.getAsString(column); 62820a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov value = cursor.getString(index); 62920a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov } 63020a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov assertEquals("Column value " + column, expectedValue, value); 63120a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov } 63220a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov } 63333b41fdb8d7c3c654cb070799c9d6e2b4ab16078Dmitri Plotnikov 634ff2de103f7e3eeeff4665ef63f07460fef053d6dDmitri Plotnikov private String[] buildProjection(ContentValues values) { 635ff2de103f7e3eeeff4665ef63f07460fef053d6dDmitri Plotnikov String[] projection = new String[values.size()]; 636ff2de103f7e3eeeff4665ef63f07460fef053d6dDmitri Plotnikov Iterator<Entry<String, Object>> iter = values.valueSet().iterator(); 637ff2de103f7e3eeeff4665ef63f07460fef053d6dDmitri Plotnikov for (int i = 0; i < projection.length; i++) { 638ff2de103f7e3eeeff4665ef63f07460fef053d6dDmitri Plotnikov projection[i] = iter.next().getKey(); 639ff2de103f7e3eeeff4665ef63f07460fef053d6dDmitri Plotnikov } 640ff2de103f7e3eeeff4665ef63f07460fef053d6dDmitri Plotnikov return projection; 641ff2de103f7e3eeeff4665ef63f07460fef053d6dDmitri Plotnikov } 642ff2de103f7e3eeeff4665ef63f07460fef053d6dDmitri Plotnikov 64333b41fdb8d7c3c654cb070799c9d6e2b4ab16078Dmitri Plotnikov protected int getCount(Uri uri, String selection, String[] selectionArgs) { 64433b41fdb8d7c3c654cb070799c9d6e2b4ab16078Dmitri Plotnikov Cursor c = mResolver.query(uri, null, selection, selectionArgs, null); 64533b41fdb8d7c3c654cb070799c9d6e2b4ab16078Dmitri Plotnikov try { 64633b41fdb8d7c3c654cb070799c9d6e2b4ab16078Dmitri Plotnikov return c.getCount(); 64733b41fdb8d7c3c654cb070799c9d6e2b4ab16078Dmitri Plotnikov } finally { 64833b41fdb8d7c3c654cb070799c9d6e2b4ab16078Dmitri Plotnikov c.close(); 64933b41fdb8d7c3c654cb070799c9d6e2b4ab16078Dmitri Plotnikov } 65033b41fdb8d7c3c654cb070799c9d6e2b4ab16078Dmitri Plotnikov } 651a908fb5f39aa2021662a6cc317cc7e4db2d8bfb0Dmitri Plotnikov 6522482dd0309794d57233d0af37a7c12fc647e7bf9Dmitri Plotnikov protected byte[] loadTestPhoto() { 6532482dd0309794d57233d0af37a7c12fc647e7bf9Dmitri Plotnikov if (mTestPhoto == null) { 6542482dd0309794d57233d0af37a7c12fc647e7bf9Dmitri Plotnikov final Resources resources = getContext().getResources(); 6552482dd0309794d57233d0af37a7c12fc647e7bf9Dmitri Plotnikov InputStream is = resources 6562482dd0309794d57233d0af37a7c12fc647e7bf9Dmitri Plotnikov .openRawResource(com.android.internal.R.drawable.ic_contact_picture); 6572482dd0309794d57233d0af37a7c12fc647e7bf9Dmitri Plotnikov ByteArrayOutputStream os = new ByteArrayOutputStream(); 6582482dd0309794d57233d0af37a7c12fc647e7bf9Dmitri Plotnikov byte[] buffer = new byte[1000]; 6592482dd0309794d57233d0af37a7c12fc647e7bf9Dmitri Plotnikov int count; 6602482dd0309794d57233d0af37a7c12fc647e7bf9Dmitri Plotnikov try { 6612482dd0309794d57233d0af37a7c12fc647e7bf9Dmitri Plotnikov while ((count = is.read(buffer)) != -1) { 6622482dd0309794d57233d0af37a7c12fc647e7bf9Dmitri Plotnikov os.write(buffer, 0, count); 6632482dd0309794d57233d0af37a7c12fc647e7bf9Dmitri Plotnikov } 6642482dd0309794d57233d0af37a7c12fc647e7bf9Dmitri Plotnikov } catch (IOException e) { 6652482dd0309794d57233d0af37a7c12fc647e7bf9Dmitri Plotnikov throw new RuntimeException(e); 6662482dd0309794d57233d0af37a7c12fc647e7bf9Dmitri Plotnikov } 6672482dd0309794d57233d0af37a7c12fc647e7bf9Dmitri Plotnikov mTestPhoto = os.toByteArray(); 668a908fb5f39aa2021662a6cc317cc7e4db2d8bfb0Dmitri Plotnikov } 6692482dd0309794d57233d0af37a7c12fc647e7bf9Dmitri Plotnikov return mTestPhoto; 670a908fb5f39aa2021662a6cc317cc7e4db2d8bfb0Dmitri Plotnikov } 671b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov 672b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov public static void dump(ContentResolver resolver, boolean aggregatedOnly) { 673b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov String[] projection = new String[] { 674b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov Contacts._ID, 675b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov Contacts.DISPLAY_NAME 676b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov }; 677b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov String selection = null; 678b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov if (aggregatedOnly) { 679b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov selection = Contacts._ID 680b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov + " IN (SELECT contact_id" + 681b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov " FROM raw_contacts GROUP BY contact_id HAVING count(*) > 1)"; 682b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov } 683b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov 684b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov Cursor c = resolver.query(Contacts.CONTENT_URI, projection, selection, null, 685b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov Contacts.DISPLAY_NAME); 686b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov while(c.moveToNext()) { 687b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov long contactId = c.getLong(0); 688b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov Log.i("Contact ", String.format("%5d %s", contactId, c.getString(1))); 689b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov dumpRawContacts(resolver, contactId); 690b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov Log.i(" ", "."); 691b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov } 692b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov c.close(); 693b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov } 694b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov 695b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov private static void dumpRawContacts(ContentResolver resolver, long contactId) { 696b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov String[] projection = new String[] { 697b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov RawContacts._ID, 698b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov }; 699b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov Cursor c = resolver.query(RawContacts.CONTENT_URI, projection, RawContacts.CONTACT_ID + "=" 700b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov + contactId, null, null); 701b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov while(c.moveToNext()) { 702b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov long rawContactId = c.getLong(0); 703b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov Log.i("RawContact", String.format(" %-5d", rawContactId)); 704b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov dumpData(resolver, rawContactId); 705b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov } 706b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov c.close(); 707b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov } 708b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov 709b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov private static void dumpData(ContentResolver resolver, long rawContactId) { 710b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov String[] projection = new String[] { 711b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov Data.MIMETYPE, 712b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov Data.DATA1, 713b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov Data.DATA2, 714b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov Data.DATA3, 715b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov }; 716b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov Cursor c = resolver.query(Data.CONTENT_URI, projection, Data.RAW_CONTACT_ID + "=" 717b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov + rawContactId, null, Data.MIMETYPE); 718b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov while(c.moveToNext()) { 719b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov String mimetype = c.getString(0); 720b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov if (Photo.CONTENT_ITEM_TYPE.equals(mimetype)) { 721b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov Log.i("Photo ", ""); 722b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov } else { 723b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov mimetype = mimetype.substring(mimetype.indexOf('/') + 1); 724b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov Log.i("Data ", String.format(" %-10s %s,%s,%s", mimetype, 725b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov c.getString(1), c.getString(2), c.getString(3))); 726b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov } 727b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov } 728b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov c.close(); 729b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov } 730d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov} 731