BaseContactsProvider2Test.java revision c70dc0e38ff82c6e6d6b7458637c54fbdf446aac
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;
22d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikovimport android.content.ContentUris;
23d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikovimport android.content.ContentValues;
24e99988b266dd1263162583e81e2b408e7329b1c8Dmitri Plotnikovimport android.content.Context;
259261b2141aa90a4fed632fd6da03026d4c216280Fred Quintanaimport android.content.Entity;
26d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikovimport android.database.Cursor;
27d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikovimport android.net.Uri;
28bee1a6b2e7cbea778195890e442c9e50f2a4e6d9Dmitri Plotnikovimport android.provider.ContactsContract;
29d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikovimport android.provider.ContactsContract.AggregationExceptions;
30e99988b266dd1263162583e81e2b408e7329b1c8Dmitri Plotnikovimport android.provider.ContactsContract.Contacts;
31d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikovimport android.provider.ContactsContract.Data;
329261b2141aa90a4fed632fd6da03026d4c216280Fred Quintanaimport android.provider.ContactsContract.Groups;
33bc5c799a52b5bde2f273efd118ebe2228c3d8f15Evan Millarimport android.provider.ContactsContract.Presence;
34e99988b266dd1263162583e81e2b408e7329b1c8Dmitri Plotnikovimport android.provider.ContactsContract.RawContacts;
35a5ad551e1753086825499f1aeb6415bb986f3588Dmitri Plotnikovimport android.provider.ContactsContract.CommonDataKinds.Email;
369261b2141aa90a4fed632fd6da03026d4c216280Fred Quintanaimport android.provider.ContactsContract.CommonDataKinds.GroupMembership;
37e99988b266dd1263162583e81e2b408e7329b1c8Dmitri Plotnikovimport android.provider.ContactsContract.CommonDataKinds.Im;
38a5ad551e1753086825499f1aeb6415bb986f3588Dmitri Plotnikovimport android.provider.ContactsContract.CommonDataKinds.Nickname;
39bf659107617a6291ba8bfeebc3f2e50138075ab5Dmitri Plotnikovimport android.provider.ContactsContract.CommonDataKinds.Phone;
40ae6ca1f34cf5458d79ec803411d4308879a91e92Evan Millarimport android.provider.ContactsContract.CommonDataKinds.Photo;
41e99988b266dd1263162583e81e2b408e7329b1c8Dmitri Plotnikovimport android.provider.ContactsContract.CommonDataKinds.StructuredName;
42d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikovimport android.test.AndroidTestCase;
43d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikovimport android.test.mock.MockContentResolver;
44d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikovimport android.test.suitebuilder.annotation.LargeTest;
45bee1a6b2e7cbea778195890e442c9e50f2a4e6d9Dmitri Plotnikov
469261b2141aa90a4fed632fd6da03026d4c216280Fred Quintanaimport java.util.ArrayList;
479261b2141aa90a4fed632fd6da03026d4c216280Fred Quintanaimport java.util.Arrays;
48e99988b266dd1263162583e81e2b408e7329b1c8Dmitri Plotnikovimport java.util.Comparator;
4920a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikovimport java.util.Map;
5020a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikovimport java.util.Set;
51d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov
52d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov/**
53d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov * A common superclass for {@link ContactsProvider2}-related tests.
54d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov */
55d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov@LargeTest
56d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikovpublic abstract class BaseContactsProvider2Test extends AndroidTestCase {
57d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov
58d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov    protected static final String PACKAGE = "ContactsProvider2Test";
59d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov
60bee1a6b2e7cbea778195890e442c9e50f2a4e6d9Dmitri Plotnikov    protected ContactsActor mActor;
61d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov    protected MockContentResolver mResolver;
629261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana    protected Account mAccount = new Account("account1", "account type1");
639261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana
649261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana    protected final static Long NO_LONG = new Long(0);
659261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana    protected final static String NO_STRING = new String("");
669261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana    protected final static Account NO_ACCOUNT = new Account("a", "b");
67d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov
68bee1a6b2e7cbea778195890e442c9e50f2a4e6d9Dmitri Plotnikov    protected Class<? extends ContentProvider> getProviderClass() {
69bee1a6b2e7cbea778195890e442c9e50f2a4e6d9Dmitri Plotnikov        return SynchronousContactsProvider2.class;
70bee1a6b2e7cbea778195890e442c9e50f2a4e6d9Dmitri Plotnikov    }
71bee1a6b2e7cbea778195890e442c9e50f2a4e6d9Dmitri Plotnikov
72bee1a6b2e7cbea778195890e442c9e50f2a4e6d9Dmitri Plotnikov    protected String getAuthority() {
73bee1a6b2e7cbea778195890e442c9e50f2a4e6d9Dmitri Plotnikov        return ContactsContract.AUTHORITY;
74bee1a6b2e7cbea778195890e442c9e50f2a4e6d9Dmitri Plotnikov    }
75bee1a6b2e7cbea778195890e442c9e50f2a4e6d9Dmitri Plotnikov
76d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov    @Override
77d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov    protected void setUp() throws Exception {
78d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov        super.setUp();
79d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov
80bee1a6b2e7cbea778195890e442c9e50f2a4e6d9Dmitri Plotnikov        mActor = new ContactsActor(getContext(), PACKAGE_GREY, getProviderClass(), getAuthority());
81d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov        mResolver = mActor.resolver;
82445ca81effbb0d61c7bc0033acf2d3dfd228fd4eDmitri Plotnikov        if (mActor.provider instanceof SynchronousContactsProvider2) {
83445ca81effbb0d61c7bc0033acf2d3dfd228fd4eDmitri Plotnikov            ((SynchronousContactsProvider2) mActor.provider)
84445ca81effbb0d61c7bc0033acf2d3dfd228fd4eDmitri Plotnikov                    .getOpenHelper(mActor.context).wipeData();
85445ca81effbb0d61c7bc0033acf2d3dfd228fd4eDmitri Plotnikov        }
869261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana    }
879261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana
88e99988b266dd1263162583e81e2b408e7329b1c8Dmitri Plotnikov    public Context getMockContext() {
89e99988b266dd1263162583e81e2b408e7329b1c8Dmitri Plotnikov        return mActor.context;
90e99988b266dd1263162583e81e2b408e7329b1c8Dmitri Plotnikov    }
91e99988b266dd1263162583e81e2b408e7329b1c8Dmitri Plotnikov
92e99988b266dd1263162583e81e2b408e7329b1c8Dmitri Plotnikov    public void addAuthority(String authority) {
93e99988b266dd1263162583e81e2b408e7329b1c8Dmitri Plotnikov        mActor.addAuthority(authority);
94e99988b266dd1263162583e81e2b408e7329b1c8Dmitri Plotnikov    }
95e99988b266dd1263162583e81e2b408e7329b1c8Dmitri Plotnikov
96e99988b266dd1263162583e81e2b408e7329b1c8Dmitri Plotnikov    public ContentProvider addProvider(Class<? extends ContentProvider> providerClass,
97e99988b266dd1263162583e81e2b408e7329b1c8Dmitri Plotnikov            String authority) throws Exception {
98e99988b266dd1263162583e81e2b408e7329b1c8Dmitri Plotnikov        return mActor.addProvider(providerClass, authority);
99e99988b266dd1263162583e81e2b408e7329b1c8Dmitri Plotnikov    }
100e99988b266dd1263162583e81e2b408e7329b1c8Dmitri Plotnikov
1019261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana    protected Uri maybeAddAccountQueryParameters(Uri uri, Account account) {
1029261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        if (account == null) {
1039261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana            return uri;
1049261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        }
1059261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        return uri.buildUpon()
1066cffee46a1334d2b3ed19f436b27638451541044Dmitri Plotnikov                .appendQueryParameter(RawContacts.ACCOUNT_NAME, account.mName)
1076cffee46a1334d2b3ed19f436b27638451541044Dmitri Plotnikov                .appendQueryParameter(RawContacts.ACCOUNT_TYPE, account.mType)
1089261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana                .build();
109d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov    }
110d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov
111d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov    protected long createRawContact() {
112226c3dc6e93ca76a84c99100caa31045cba06cf6Fred Quintana        return createRawContact(null);
113d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov    }
114d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov
115c70dc0e38ff82c6e6d6b7458637c54fbdf446aacDmitri Plotnikov    protected long createRawContactWithName() {
116c70dc0e38ff82c6e6d6b7458637c54fbdf446aacDmitri Plotnikov        long rawContactId = createRawContact(null);
117c70dc0e38ff82c6e6d6b7458637c54fbdf446aacDmitri Plotnikov        insertStructuredName(rawContactId, "John", "Doe");
118c70dc0e38ff82c6e6d6b7458637c54fbdf446aacDmitri Plotnikov        return rawContactId;
119c70dc0e38ff82c6e6d6b7458637c54fbdf446aacDmitri Plotnikov    }
120c70dc0e38ff82c6e6d6b7458637c54fbdf446aacDmitri Plotnikov
121226c3dc6e93ca76a84c99100caa31045cba06cf6Fred Quintana    protected long createRawContact(Account account, String... extras) {
1229261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        ContentValues values = new ContentValues();
123226c3dc6e93ca76a84c99100caa31045cba06cf6Fred Quintana        for (int i = 0; i < extras.length; ) {
124226c3dc6e93ca76a84c99100caa31045cba06cf6Fred Quintana            values.put(extras[i], extras[i + 1]);
125226c3dc6e93ca76a84c99100caa31045cba06cf6Fred Quintana            i += 2;
126226c3dc6e93ca76a84c99100caa31045cba06cf6Fred Quintana        }
1276cffee46a1334d2b3ed19f436b27638451541044Dmitri Plotnikov        final Uri uri = maybeAddAccountQueryParameters(RawContacts.CONTENT_URI, account);
1289261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        Uri contactUri = mResolver.insert(uri, values);
1299261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        return ContentUris.parseId(contactUri);
1309261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana    }
1319261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana
1329261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana    protected long createGroup(Account account, String sourceId, String title) {
1339261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        ContentValues values = new ContentValues();
1349261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        values.put(Groups.SOURCE_ID, sourceId);
1359261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        values.put(Groups.TITLE, title);
1369261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        final Uri uri = maybeAddAccountQueryParameters(Groups.CONTENT_URI, account);
1379261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        return ContentUris.parseId(mResolver.insert(uri, values));
1389261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana    }
1399261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana
1405ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov    protected Uri insertStructuredName(long rawContactId, String givenName, String familyName) {
141d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov        ContentValues values = new ContentValues();
142d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov        StringBuilder sb = new StringBuilder();
143d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov        if (givenName != null) {
144d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov            sb.append(givenName);
145d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov        }
146d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov        if (givenName != null && familyName != null) {
147d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov            sb.append(" ");
148d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov        }
149d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov        if (familyName != null) {
150d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov            sb.append(familyName);
151d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov        }
152d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov        values.put(StructuredName.DISPLAY_NAME, sb.toString());
153d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov        values.put(StructuredName.GIVEN_NAME, givenName);
154d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov        values.put(StructuredName.FAMILY_NAME, familyName);
155d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov
1565ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov        return insertStructuredName(rawContactId, values);
1574097855e2d672b3f8e1c5c8a169efb80203bf53eDmitri Plotnikov    }
1584097855e2d672b3f8e1c5c8a169efb80203bf53eDmitri Plotnikov
1595ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov    protected Uri insertStructuredName(long rawContactId, ContentValues values) {
1605ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov        values.put(Data.RAW_CONTACT_ID, rawContactId);
1614097855e2d672b3f8e1c5c8a169efb80203bf53eDmitri Plotnikov        values.put(Data.MIMETYPE, StructuredName.CONTENT_ITEM_TYPE);
162d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov        Uri resultUri = mResolver.insert(Data.CONTENT_URI, values);
163d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov        return resultUri;
164d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov    }
165d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov
1665ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov    protected Uri insertPhoneNumber(long rawContactId, String phoneNumber) {
167bf659107617a6291ba8bfeebc3f2e50138075ab5Dmitri Plotnikov        ContentValues values = new ContentValues();
1685ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov        values.put(Data.RAW_CONTACT_ID, rawContactId);
169bf659107617a6291ba8bfeebc3f2e50138075ab5Dmitri Plotnikov        values.put(Data.MIMETYPE, Phone.CONTENT_ITEM_TYPE);
170bf659107617a6291ba8bfeebc3f2e50138075ab5Dmitri Plotnikov        values.put(Phone.NUMBER, phoneNumber);
1713cebbf7141252768d3e272e049e9c5b0cb9d710eDmitri Plotnikov        values.put(Phone.TYPE, Phone.TYPE_HOME);
172bf659107617a6291ba8bfeebc3f2e50138075ab5Dmitri Plotnikov
173bf659107617a6291ba8bfeebc3f2e50138075ab5Dmitri Plotnikov        Uri resultUri = mResolver.insert(Data.CONTENT_URI, values);
174bf659107617a6291ba8bfeebc3f2e50138075ab5Dmitri Plotnikov        return resultUri;
175bf659107617a6291ba8bfeebc3f2e50138075ab5Dmitri Plotnikov    }
176bf659107617a6291ba8bfeebc3f2e50138075ab5Dmitri Plotnikov
1775ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov    protected Uri insertEmail(long rawContactId, String email) {
178a5ad551e1753086825499f1aeb6415bb986f3588Dmitri Plotnikov        ContentValues values = new ContentValues();
1795ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov        values.put(Data.RAW_CONTACT_ID, rawContactId);
180a5ad551e1753086825499f1aeb6415bb986f3588Dmitri Plotnikov        values.put(Data.MIMETYPE, Email.CONTENT_ITEM_TYPE);
181a5ad551e1753086825499f1aeb6415bb986f3588Dmitri Plotnikov        values.put(Email.DATA, email);
1823cebbf7141252768d3e272e049e9c5b0cb9d710eDmitri Plotnikov        values.put(Email.TYPE, Email.TYPE_HOME);
183a5ad551e1753086825499f1aeb6415bb986f3588Dmitri Plotnikov
184a5ad551e1753086825499f1aeb6415bb986f3588Dmitri Plotnikov        Uri resultUri = mResolver.insert(Data.CONTENT_URI, values);
185a5ad551e1753086825499f1aeb6415bb986f3588Dmitri Plotnikov        return resultUri;
186a5ad551e1753086825499f1aeb6415bb986f3588Dmitri Plotnikov    }
187a5ad551e1753086825499f1aeb6415bb986f3588Dmitri Plotnikov
1885ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov    protected Uri insertNickname(long rawContactId, String nickname) {
189a5ad551e1753086825499f1aeb6415bb986f3588Dmitri Plotnikov        ContentValues values = new ContentValues();
1905ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov        values.put(Data.RAW_CONTACT_ID, rawContactId);
191a5ad551e1753086825499f1aeb6415bb986f3588Dmitri Plotnikov        values.put(Data.MIMETYPE, Nickname.CONTENT_ITEM_TYPE);
192a5ad551e1753086825499f1aeb6415bb986f3588Dmitri Plotnikov        values.put(Nickname.NAME, nickname);
1933cebbf7141252768d3e272e049e9c5b0cb9d710eDmitri Plotnikov        values.put(Nickname.TYPE, Nickname.TYPE_OTHER_NAME);
194a5ad551e1753086825499f1aeb6415bb986f3588Dmitri Plotnikov
195a5ad551e1753086825499f1aeb6415bb986f3588Dmitri Plotnikov        Uri resultUri = mResolver.insert(Data.CONTENT_URI, values);
196a5ad551e1753086825499f1aeb6415bb986f3588Dmitri Plotnikov        return resultUri;
197a5ad551e1753086825499f1aeb6415bb986f3588Dmitri Plotnikov    }
198a5ad551e1753086825499f1aeb6415bb986f3588Dmitri Plotnikov
1995ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov    protected Uri insertPhoto(long rawContactId) {
200ae6ca1f34cf5458d79ec803411d4308879a91e92Evan Millar        ContentValues values = new ContentValues();
2015ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov        values.put(Data.RAW_CONTACT_ID, rawContactId);
202ae6ca1f34cf5458d79ec803411d4308879a91e92Evan Millar        values.put(Data.MIMETYPE, Photo.CONTENT_ITEM_TYPE);
203ae6ca1f34cf5458d79ec803411d4308879a91e92Evan Millar
204ae6ca1f34cf5458d79ec803411d4308879a91e92Evan Millar        Uri resultUri = mResolver.insert(Data.CONTENT_URI, values);
205ae6ca1f34cf5458d79ec803411d4308879a91e92Evan Millar        return resultUri;
206ae6ca1f34cf5458d79ec803411d4308879a91e92Evan Millar    }
207ae6ca1f34cf5458d79ec803411d4308879a91e92Evan Millar
2085ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov    protected Uri insertGroupMembership(long rawContactId, String sourceId) {
2099261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        ContentValues values = new ContentValues();
2105ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov        values.put(Data.RAW_CONTACT_ID, rawContactId);
2119261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        values.put(Data.MIMETYPE, GroupMembership.CONTENT_ITEM_TYPE);
2129261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        values.put(GroupMembership.GROUP_SOURCE_ID, sourceId);
2139261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        return mResolver.insert(Data.CONTENT_URI, values);
2149261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana    }
2159261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana
2165ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov    protected Uri insertGroupMembership(long rawContactId, Long groupId) {
2179261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        ContentValues values = new ContentValues();
2185ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov        values.put(Data.RAW_CONTACT_ID, rawContactId);
2199261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        values.put(Data.MIMETYPE, GroupMembership.CONTENT_ITEM_TYPE);
2209261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        values.put(GroupMembership.GROUP_ROW_ID, groupId);
2219261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        return mResolver.insert(Data.CONTENT_URI, values);
2229261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana    }
2239261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana
224bc5c799a52b5bde2f273efd118ebe2228c3d8f15Evan Millar    protected Uri insertPresence(int protocol, String handle, int presence) {
225bc5c799a52b5bde2f273efd118ebe2228c3d8f15Evan Millar        ContentValues values = new ContentValues();
226bc5c799a52b5bde2f273efd118ebe2228c3d8f15Evan Millar        values.put(Presence.IM_PROTOCOL, protocol);
227bc5c799a52b5bde2f273efd118ebe2228c3d8f15Evan Millar        values.put(Presence.IM_HANDLE, handle);
228bc5c799a52b5bde2f273efd118ebe2228c3d8f15Evan Millar        values.put(Presence.PRESENCE_STATUS, presence);
229bc5c799a52b5bde2f273efd118ebe2228c3d8f15Evan Millar
230bc5c799a52b5bde2f273efd118ebe2228c3d8f15Evan Millar        Uri resultUri = mResolver.insert(Presence.CONTENT_URI, values);
231bc5c799a52b5bde2f273efd118ebe2228c3d8f15Evan Millar        return resultUri;
232bc5c799a52b5bde2f273efd118ebe2228c3d8f15Evan Millar    }
233bc5c799a52b5bde2f273efd118ebe2228c3d8f15Evan Millar
2345ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov    protected Uri insertImHandle(long rawContactId, int protocol, String handle) {
235bc5c799a52b5bde2f273efd118ebe2228c3d8f15Evan Millar        ContentValues values = new ContentValues();
2365ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov        values.put(Data.RAW_CONTACT_ID, rawContactId);
237bc5c799a52b5bde2f273efd118ebe2228c3d8f15Evan Millar        values.put(Data.MIMETYPE, Im.CONTENT_ITEM_TYPE);
238bc5c799a52b5bde2f273efd118ebe2228c3d8f15Evan Millar        values.put(Im.PROTOCOL, protocol);
239bc5c799a52b5bde2f273efd118ebe2228c3d8f15Evan Millar        values.put(Im.DATA, handle);
2403cebbf7141252768d3e272e049e9c5b0cb9d710eDmitri Plotnikov        values.put(Im.TYPE, Im.TYPE_HOME);
241bc5c799a52b5bde2f273efd118ebe2228c3d8f15Evan Millar
242bc5c799a52b5bde2f273efd118ebe2228c3d8f15Evan Millar        Uri resultUri = mResolver.insert(Data.CONTENT_URI, values);
243bc5c799a52b5bde2f273efd118ebe2228c3d8f15Evan Millar        return resultUri;
244bc5c799a52b5bde2f273efd118ebe2228c3d8f15Evan Millar    }
245bc5c799a52b5bde2f273efd118ebe2228c3d8f15Evan Millar
2465ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov    protected void setContactAccountName(long rawContactId, String accountName) {
247ae6ca1f34cf5458d79ec803411d4308879a91e92Evan Millar        ContentValues values = new ContentValues();
2486cffee46a1334d2b3ed19f436b27638451541044Dmitri Plotnikov        values.put(RawContacts.ACCOUNT_NAME, accountName);
249ae6ca1f34cf5458d79ec803411d4308879a91e92Evan Millar
250ae6ca1f34cf5458d79ec803411d4308879a91e92Evan Millar        mResolver.update(ContentUris.withAppendedId(
2515ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov                RawContacts.CONTENT_URI, rawContactId), values, null, null);
252ae6ca1f34cf5458d79ec803411d4308879a91e92Evan Millar    }
253ae6ca1f34cf5458d79ec803411d4308879a91e92Evan Millar
254d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov    protected void setAggregationException(int type, long contactId, long rawContactId) {
255d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov        ContentValues values = new ContentValues();
256d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov        values.put(AggregationExceptions.CONTACT_ID, contactId);
2575ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov        values.put(AggregationExceptions.RAW_CONTACT_ID, rawContactId);
258d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov        values.put(AggregationExceptions.TYPE, type);
259d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov        mResolver.update(AggregationExceptions.CONTENT_URI, values, null, null);
260d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov    }
261d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov
262d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov    protected Cursor queryRawContact(long rawContactId) {
2635ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov        return mResolver.query(ContentUris.withAppendedId(RawContacts.CONTENT_URI, rawContactId), null,
264d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov                null, null, null);
265d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov    }
266d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov
267d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov    protected Cursor queryContact(long contactId) {
268d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov        return mResolver.query(ContentUris.withAppendedId(Contacts.CONTENT_URI, contactId),
269d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov                null, null, null, null);
270d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov    }
271d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov
272d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov    protected Cursor queryContactSummary(long contactId, String[] projection) {
273d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov        return mResolver.query(ContentUris.withAppendedId(Contacts.CONTENT_SUMMARY_URI,
274d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov                contactId), projection, null, null, null);
275bc5c799a52b5bde2f273efd118ebe2228c3d8f15Evan Millar    }
276bc5c799a52b5bde2f273efd118ebe2228c3d8f15Evan Millar
277d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov    protected Cursor queryContactSummary() {
278d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov        return mResolver.query(Contacts.CONTENT_SUMMARY_URI, null, null, null, null);
279bc5c799a52b5bde2f273efd118ebe2228c3d8f15Evan Millar    }
280bc5c799a52b5bde2f273efd118ebe2228c3d8f15Evan Millar
281d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov    protected long queryContactId(long rawContactId) {
282d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov        Cursor c = queryRawContact(rawContactId);
283d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov        assertTrue(c.moveToFirst());
284d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov        long contactId = c.getLong(c.getColumnIndex(RawContacts.CONTACT_ID));
285d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov        c.close();
286d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov        return contactId;
287d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov    }
288d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov
289d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov    protected long queryPhotoId(long contactId) {
290d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov        Cursor c = queryContact(contactId);
291ae6ca1f34cf5458d79ec803411d4308879a91e92Evan Millar        assertTrue(c.moveToFirst());
292d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov        long photoId = c.getInt(c.getColumnIndex(Contacts.PHOTO_ID));
293ae6ca1f34cf5458d79ec803411d4308879a91e92Evan Millar        c.close();
294ae6ca1f34cf5458d79ec803411d4308879a91e92Evan Millar        return photoId;
295ae6ca1f34cf5458d79ec803411d4308879a91e92Evan Millar    }
296ae6ca1f34cf5458d79ec803411d4308879a91e92Evan Millar
297d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov    protected String queryDisplayName(long contactId) {
298d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov        Cursor c = queryContact(contactId);
299d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov        assertTrue(c.moveToFirst());
300d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov        String displayName = c.getString(c.getColumnIndex(Contacts.DISPLAY_NAME));
301d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov        c.close();
302d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov        return displayName;
303d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov    }
304d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov
305d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov    protected void assertAggregated(long rawContactId1, long rawContactId2) {
306d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov        long contactId1 = queryContactId(rawContactId1);
307d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov        long contactId2 = queryContactId(rawContactId2);
308d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov        assertTrue(contactId1 == contactId2);
309bf659107617a6291ba8bfeebc3f2e50138075ab5Dmitri Plotnikov    }
310bf659107617a6291ba8bfeebc3f2e50138075ab5Dmitri Plotnikov
311d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov    protected void assertAggregated(long rawContactId1, long rawContactId2,
312d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov            String expectedDisplayName) {
313d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov        long contactId1 = queryContactId(rawContactId1);
314d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov        long contactId2 = queryContactId(rawContactId2);
315d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov        assertTrue(contactId1 == contactId2);
316d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov
317d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov        String displayName = queryDisplayName(contactId1);
318d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov        assertEquals(expectedDisplayName, displayName);
319d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov    }
320d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov
321d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov    protected void assertNotAggregated(long rawContactId1, long rawContactId2) {
322d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov        long contactId1 = queryContactId(rawContactId1);
323d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov        long contactId2 = queryContactId(rawContactId2);
324d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov        assertTrue(contactId1 != contactId2);
325d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov    }
3264097855e2d672b3f8e1c5c8a169efb80203bf53eDmitri Plotnikov
3275ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov    protected void assertStructuredName(long rawContactId, String prefix, String givenName,
3284097855e2d672b3f8e1c5c8a169efb80203bf53eDmitri Plotnikov            String middleName, String familyName, String suffix) {
3296cffee46a1334d2b3ed19f436b27638451541044Dmitri Plotnikov        Uri uri =
3305ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov                Uri.withAppendedPath(ContentUris.withAppendedId(RawContacts.CONTENT_URI, rawContactId),
3316cffee46a1334d2b3ed19f436b27638451541044Dmitri Plotnikov                RawContacts.Data.CONTENT_DIRECTORY);
3324097855e2d672b3f8e1c5c8a169efb80203bf53eDmitri Plotnikov
3334097855e2d672b3f8e1c5c8a169efb80203bf53eDmitri Plotnikov        final String[] projection = new String[] {
3344097855e2d672b3f8e1c5c8a169efb80203bf53eDmitri Plotnikov                StructuredName.PREFIX, StructuredName.GIVEN_NAME, StructuredName.MIDDLE_NAME,
3354097855e2d672b3f8e1c5c8a169efb80203bf53eDmitri Plotnikov                StructuredName.FAMILY_NAME, StructuredName.SUFFIX
3364097855e2d672b3f8e1c5c8a169efb80203bf53eDmitri Plotnikov        };
3374097855e2d672b3f8e1c5c8a169efb80203bf53eDmitri Plotnikov
3384097855e2d672b3f8e1c5c8a169efb80203bf53eDmitri Plotnikov        Cursor c = mResolver.query(uri, projection, Data.MIMETYPE + "='"
3394097855e2d672b3f8e1c5c8a169efb80203bf53eDmitri Plotnikov                + StructuredName.CONTENT_ITEM_TYPE + "'", null, null);
3404097855e2d672b3f8e1c5c8a169efb80203bf53eDmitri Plotnikov
3414097855e2d672b3f8e1c5c8a169efb80203bf53eDmitri Plotnikov        assertTrue(c.moveToFirst());
3424097855e2d672b3f8e1c5c8a169efb80203bf53eDmitri Plotnikov        assertEquals(prefix, c.getString(0));
3434097855e2d672b3f8e1c5c8a169efb80203bf53eDmitri Plotnikov        assertEquals(givenName, c.getString(1));
3444097855e2d672b3f8e1c5c8a169efb80203bf53eDmitri Plotnikov        assertEquals(middleName, c.getString(2));
3454097855e2d672b3f8e1c5c8a169efb80203bf53eDmitri Plotnikov        assertEquals(familyName, c.getString(3));
3464097855e2d672b3f8e1c5c8a169efb80203bf53eDmitri Plotnikov        assertEquals(suffix, c.getString(4));
3474097855e2d672b3f8e1c5c8a169efb80203bf53eDmitri Plotnikov        c.close();
3484097855e2d672b3f8e1c5c8a169efb80203bf53eDmitri Plotnikov    }
3499261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana
3509261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana    protected long assertSingleGroup(Long rowId, Account account, String sourceId, String title) {
3519261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        Cursor c = mResolver.query(Groups.CONTENT_URI, null, null, null, null);
3529261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        try {
3539261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana            assertTrue(c.moveToNext());
3549261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana            long actualRowId = assertGroup(c, rowId, account, sourceId, title);
3559261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana            assertFalse(c.moveToNext());
3569261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana            return actualRowId;
3579261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        } finally {
3589261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana            c.close();
3599261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        }
3609261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana    }
3619261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana
3625ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov    protected long assertSingleGroupMembership(Long rowId, Long rawContactId, Long groupRowId,
3639261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana            String sourceId) {
3649261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        Cursor c = mResolver.query(ContactsContract.Data.CONTENT_URI, null, null, null, null);
3659261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        try {
3669261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana            assertTrue(c.moveToNext());
3675ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov            long actualRowId = assertGroupMembership(c, rowId, rawContactId, groupRowId, sourceId);
3689261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana            assertFalse(c.moveToNext());
3699261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana            return actualRowId;
3709261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        } finally {
3719261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana            c.close();
3729261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        }
3739261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana    }
3749261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana
3755ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov    protected long assertGroupMembership(Cursor c, Long rowId, Long rawContactId, Long groupRowId,
3769261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana            String sourceId) {
3779261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        assertNullOrEquals(c, rowId, Data._ID);
3785ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov        assertNullOrEquals(c, rawContactId, GroupMembership.RAW_CONTACT_ID);
3799261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        assertNullOrEquals(c, groupRowId, GroupMembership.GROUP_ROW_ID);
3809261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        assertNullOrEquals(c, sourceId, GroupMembership.GROUP_SOURCE_ID);
3819261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        return c.getLong(c.getColumnIndexOrThrow("_id"));
3829261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana    }
3839261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana
3849261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana    protected long assertGroup(Cursor c, Long rowId, Account account, String sourceId, String title) {
3859261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        assertNullOrEquals(c, rowId, Groups._ID);
3869261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        assertNullOrEquals(c, account);
3879261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        assertNullOrEquals(c, sourceId, Groups.SOURCE_ID);
3889261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        assertNullOrEquals(c, title, Groups.TITLE);
3899261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        return c.getLong(c.getColumnIndexOrThrow("_id"));
3909261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana    }
3919261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana
3929261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana    private void assertNullOrEquals(Cursor c, Account account) {
3939261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        if (account == NO_ACCOUNT) {
3949261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana            return;
3959261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        }
3969261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        if (account == null) {
3979261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana            assertTrue(c.isNull(c.getColumnIndexOrThrow(Groups.ACCOUNT_NAME)));
3989261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana            assertTrue(c.isNull(c.getColumnIndexOrThrow(Groups.ACCOUNT_TYPE)));
3999261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        } else {
4009261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana            assertEquals(account.mName, c.getString(c.getColumnIndexOrThrow(Groups.ACCOUNT_NAME)));
4019261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana            assertEquals(account.mType, c.getString(c.getColumnIndexOrThrow(Groups.ACCOUNT_TYPE)));
4029261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        }
4039261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana    }
4049261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana
4059261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana    private void assertNullOrEquals(Cursor c, Long value, String columnName) {
4069261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        if (value != NO_LONG) {
4079261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana            if (value == null) assertTrue(c.isNull(c.getColumnIndexOrThrow(columnName)));
4089261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana            else assertEquals((long) value, c.getLong(c.getColumnIndexOrThrow(columnName)));
4099261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        }
4109261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana    }
4119261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana
4129261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana    private void assertNullOrEquals(Cursor c, String value, String columnName) {
4139261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        if (value != NO_STRING) {
4149261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana            if (value == null) assertTrue(c.isNull(c.getColumnIndexOrThrow(columnName)));
4159261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana            else assertEquals(value, c.getString(c.getColumnIndexOrThrow(columnName)));
4169261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        }
4179261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana    }
4189261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana
4199261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana    protected void assertDataRow(ContentValues actual, String expectedMimetype,
4209261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana            Object... expectedArguments) {
4219261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        assertEquals(actual.toString(), expectedMimetype, actual.getAsString(Data.MIMETYPE));
4229261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        for (int i = 0; i < expectedArguments.length; i += 2) {
4239261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana            String columnName = (String) expectedArguments[i];
4249261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana            Object expectedValue = expectedArguments[i + 1];
4259261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana            if (expectedValue instanceof Uri) {
4269261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana                expectedValue = ContentUris.parseId((Uri) expectedValue);
4279261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana            }
4289261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana            if (expectedValue == null) {
4299261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana                assertNull(actual.toString(), actual.get(columnName));
4309261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana            }
4319261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana            if (expectedValue instanceof Long) {
432226c3dc6e93ca76a84c99100caa31045cba06cf6Fred Quintana                assertEquals("mismatch at " + columnName + " from " + actual.toString(),
433226c3dc6e93ca76a84c99100caa31045cba06cf6Fred Quintana                        expectedValue, actual.getAsLong(columnName));
4349261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana            } else if (expectedValue instanceof Integer) {
435226c3dc6e93ca76a84c99100caa31045cba06cf6Fred Quintana                assertEquals("mismatch at " + columnName + " from " + actual.toString(),
436226c3dc6e93ca76a84c99100caa31045cba06cf6Fred Quintana                        expectedValue, actual.getAsInteger(columnName));
4379261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana            } else if (expectedValue instanceof String) {
438226c3dc6e93ca76a84c99100caa31045cba06cf6Fred Quintana                assertEquals("mismatch at " + columnName + " from " + actual.toString(),
439226c3dc6e93ca76a84c99100caa31045cba06cf6Fred Quintana                        expectedValue, actual.getAsString(columnName));
4409261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana            } else {
441226c3dc6e93ca76a84c99100caa31045cba06cf6Fred Quintana                assertEquals("mismatch at " + columnName + " from " + actual.toString(),
442226c3dc6e93ca76a84c99100caa31045cba06cf6Fred Quintana                        expectedValue, actual.get(columnName));
4439261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana            }
4449261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        }
4459261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana    }
4469261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana
4479261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana    protected static class IdComparator implements Comparator<ContentValues> {
4489261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        public int compare(ContentValues o1, ContentValues o2) {
4499261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana            long id1 = o1.getAsLong(ContactsContract.Data._ID);
4509261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana            long id2 = o2.getAsLong(ContactsContract.Data._ID);
4519261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana            if (id1 == id2) return 0;
4529261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana            return (id1 < id2) ? -1 : 1;
4539261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        }
4549261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana    }
4559261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana
4569261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana    protected ContentValues[] asSortedContentValuesArray(
4579261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana            ArrayList<Entity.NamedContentValues> subValues) {
4589261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        ContentValues[] result = new ContentValues[subValues.size()];
4599261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        int i = 0;
4609261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        for (Entity.NamedContentValues subValue : subValues) {
4619261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana            result[i] = subValue.values;
4629261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana            i++;
4639261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        }
4649261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        Arrays.sort(result, new IdComparator());
4659261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        return result;
4669261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana    }
4679261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana
4689261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana    protected void assertDirty(Uri uri, boolean state) {
4699261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        Cursor c = mResolver.query(uri, new String[]{"dirty"}, null, null, null);
4709261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        assertTrue(c.moveToNext());
4719261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        assertEquals(state, c.getLong(0) != 0);
4729261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        assertFalse(c.moveToNext());
4739261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana    }
4749261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana
4759261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana    protected long getVersion(Uri uri) {
4769261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        Cursor c = mResolver.query(uri, new String[]{"version"}, null, null, null);
4779261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        assertTrue(c.moveToNext());
4789261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        long version = c.getLong(0);
4799261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        assertFalse(c.moveToNext());
4809261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        return version;
4819261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana    }
4829261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana
4839261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana    protected void clearDirty(Uri uri) {
4849261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        ContentValues values = new ContentValues();
4859261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        values.put("dirty", 0);
4869261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        mResolver.update(uri, values, null, null);
4879261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana    }
48820a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov
48920a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov    protected void assertStoredValues(Uri rowUri, String column, String expectedValue) {
49020a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov        String value = getStoredValue(rowUri, column);
49120a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov        assertEquals("Column value " + column, expectedValue, value);
49220a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov    }
49320a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov
49420a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov    protected String getStoredValue(Uri rowUri, String column) {
49520a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov        String value;
49620a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov        Cursor c = mResolver.query(rowUri, new String[] { column }, null, null, null);
49720a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov        try {
49820a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov            c.moveToFirst();
49920a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov            value = c.getString(c.getColumnIndex(column));
50020a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov        } finally {
50120a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov            c.close();
50220a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov        }
50320a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov        return value;
50420a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov    }
50520a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov
50620a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov    protected void assertStoredValues(Uri rowUri, ContentValues expectedValues) {
50720a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov        Cursor c = mResolver.query(rowUri, null, null, null, null);
50820a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov        try {
50920a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov            assertEquals("Record count", 1, c.getCount());
51020a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov            c.moveToFirst();
51120a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov            assertCursorValues(c, expectedValues);
51220a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov        } finally {
51320a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov            c.close();
51420a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov        }
51520a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov    }
51620a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov
51720a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov    /**
51820a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov     * Constructs a selection (where clause) out of all supplied values, uses it
51920a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov     * to query the provider and verifies that a single row is returned and it
52020a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov     * has the same values as requested.
52120a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov     */
52220a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov    protected void assertSelection(Uri uri, ContentValues values, String idColumn, long id) {
52320a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov        StringBuilder sb = new StringBuilder();
52420a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov        ArrayList<String> selectionArgs = new ArrayList<String>(values.size());
525c70dc0e38ff82c6e6d6b7458637c54fbdf446aacDmitri Plotnikov        if (idColumn != null) {
526c70dc0e38ff82c6e6d6b7458637c54fbdf446aacDmitri Plotnikov            sb.append(idColumn).append("=").append(id);
527c70dc0e38ff82c6e6d6b7458637c54fbdf446aacDmitri Plotnikov        }
52820a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov        Set<Map.Entry<String, Object>> entries = values.valueSet();
52920a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov        for (Map.Entry<String, Object> entry : entries) {
53020a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov            String column = entry.getKey();
53120a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov            Object value = entry.getValue();
532c70dc0e38ff82c6e6d6b7458637c54fbdf446aacDmitri Plotnikov            if (sb.length() != 0) {
533c70dc0e38ff82c6e6d6b7458637c54fbdf446aacDmitri Plotnikov                sb.append(" AND ");
534c70dc0e38ff82c6e6d6b7458637c54fbdf446aacDmitri Plotnikov            }
535c70dc0e38ff82c6e6d6b7458637c54fbdf446aacDmitri Plotnikov            sb.append(column);
53620a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov            if (value == null) {
53720a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov                sb.append(" IS NULL");
53820a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov            } else {
53920a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov                sb.append("=?");
54020a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov                selectionArgs.add(String.valueOf(value));
54120a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov            }
54220a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov        }
54320a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov
54420a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov        Cursor c = mResolver.query(uri, null, sb.toString(), selectionArgs.toArray(new String[0]),
54520a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov                null);
54620a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov        try {
54720a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov            assertEquals("Record count", 1, c.getCount());
54820a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov            c.moveToFirst();
54920a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov            assertCursorValues(c, values);
55020a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov        } finally {
55120a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov            c.close();
55220a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov        }
55320a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov    }
55420a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov
55520a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov    protected void assertCursorValues(Cursor cursor, ContentValues expectedValues) {
55620a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov        Set<Map.Entry<String, Object>> entries = expectedValues.valueSet();
55720a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov        for (Map.Entry<String, Object> entry : entries) {
55820a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov            String column = entry.getKey();
55920a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov            int index = cursor.getColumnIndex(column);
56020a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov            assertTrue("No such column: " + column, index != -1);
56120a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov            Object expectedValue = expectedValues.get(column);
56220a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov            String value;
56320a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov            if (expectedValue instanceof byte[]) {
56420a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov                expectedValue = Hex.encodeHex((byte[])expectedValue, false);
56520a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov                value = Hex.encodeHex(cursor.getBlob(index), false);
56620a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov            } else {
56720a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov                expectedValue = expectedValues.getAsString(column);
56820a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov                value = cursor.getString(index);
56920a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov            }
57020a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov            assertEquals("Column value " + column, expectedValue, value);
57120a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov        }
57220a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov    }
57333b41fdb8d7c3c654cb070799c9d6e2b4ab16078Dmitri Plotnikov
57433b41fdb8d7c3c654cb070799c9d6e2b4ab16078Dmitri Plotnikov    protected int getCount(Uri uri, String selection, String[] selectionArgs) {
57533b41fdb8d7c3c654cb070799c9d6e2b4ab16078Dmitri Plotnikov        Cursor c = mResolver.query(uri, null, selection, selectionArgs, null);
57633b41fdb8d7c3c654cb070799c9d6e2b4ab16078Dmitri Plotnikov        try {
57733b41fdb8d7c3c654cb070799c9d6e2b4ab16078Dmitri Plotnikov            return c.getCount();
57833b41fdb8d7c3c654cb070799c9d6e2b4ab16078Dmitri Plotnikov        } finally {
57933b41fdb8d7c3c654cb070799c9d6e2b4ab16078Dmitri Plotnikov            c.close();
58033b41fdb8d7c3c654cb070799c9d6e2b4ab16078Dmitri Plotnikov        }
58133b41fdb8d7c3c654cb070799c9d6e2b4ab16078Dmitri Plotnikov    }
582d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov}
583