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