BaseContactsProvider2Test.java revision 3cebbf7141252768d3e272e049e9c5b0cb9d710e
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
2028f8857b1b46bde18b85c6d3c2a63ac44c3c2e1cEvan Millarimport com.android.providers.contacts.ContactsActor;
21bc5c799a52b5bde2f273efd118ebe2228c3d8f15Evan Millar
22bee1a6b2e7cbea778195890e442c9e50f2a4e6d9Dmitri Plotnikovimport android.content.ContentProvider;
23d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikovimport android.content.ContentUris;
24d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikovimport android.content.ContentValues;
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.Aggregates;
30d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikovimport android.provider.ContactsContract.AggregationExceptions;
31d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikovimport android.provider.ContactsContract.Contacts;
32d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikovimport android.provider.ContactsContract.Data;
339261b2141aa90a4fed632fd6da03026d4c216280Fred Quintanaimport android.provider.ContactsContract.Groups;
34bc5c799a52b5bde2f273efd118ebe2228c3d8f15Evan Millarimport android.provider.ContactsContract.Presence;
35bc5c799a52b5bde2f273efd118ebe2228c3d8f15Evan Millarimport android.provider.ContactsContract.CommonDataKinds.Im;
36d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikovimport android.provider.ContactsContract.CommonDataKinds.StructuredName;
37a5ad551e1753086825499f1aeb6415bb986f3588Dmitri Plotnikovimport android.provider.ContactsContract.CommonDataKinds.Email;
389261b2141aa90a4fed632fd6da03026d4c216280Fred Quintanaimport android.provider.ContactsContract.CommonDataKinds.GroupMembership;
39a5ad551e1753086825499f1aeb6415bb986f3588Dmitri Plotnikovimport android.provider.ContactsContract.CommonDataKinds.Nickname;
40bf659107617a6291ba8bfeebc3f2e50138075ab5Dmitri Plotnikovimport android.provider.ContactsContract.CommonDataKinds.Phone;
41ae6ca1f34cf5458d79ec803411d4308879a91e92Evan Millarimport android.provider.ContactsContract.CommonDataKinds.Photo;
42d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikovimport android.test.AndroidTestCase;
43d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikovimport android.test.mock.MockContentResolver;
44d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikovimport android.test.suitebuilder.annotation.LargeTest;
459261b2141aa90a4fed632fd6da03026d4c216280Fred Quintanaimport android.accounts.Account;
46bee1a6b2e7cbea778195890e442c9e50f2a4e6d9Dmitri Plotnikov
479261b2141aa90a4fed632fd6da03026d4c216280Fred Quintanaimport java.util.Comparator;
489261b2141aa90a4fed632fd6da03026d4c216280Fred Quintanaimport java.util.ArrayList;
499261b2141aa90a4fed632fd6da03026d4c216280Fred Quintanaimport java.util.Arrays;
50d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov
51d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov/**
52d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov * A common superclass for {@link ContactsProvider2}-related tests.
53d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov */
54d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov@LargeTest
55d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikovpublic abstract class BaseContactsProvider2Test extends AndroidTestCase {
56d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov
57d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov    protected static final String PACKAGE = "ContactsProvider2Test";
58d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov
59bee1a6b2e7cbea778195890e442c9e50f2a4e6d9Dmitri Plotnikov    protected ContactsActor mActor;
60d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov    protected MockContentResolver mResolver;
619261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana    protected Account mAccount = new Account("account1", "account type1");
629261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana
639261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana    protected final static Long NO_LONG = new Long(0);
649261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana    protected final static String NO_STRING = new String("");
659261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana    protected final static Account NO_ACCOUNT = new Account("a", "b");
66d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov
67bee1a6b2e7cbea778195890e442c9e50f2a4e6d9Dmitri Plotnikov    protected Class<? extends ContentProvider> getProviderClass() {
68bee1a6b2e7cbea778195890e442c9e50f2a4e6d9Dmitri Plotnikov        return SynchronousContactsProvider2.class;
69bee1a6b2e7cbea778195890e442c9e50f2a4e6d9Dmitri Plotnikov    }
70bee1a6b2e7cbea778195890e442c9e50f2a4e6d9Dmitri Plotnikov
71bee1a6b2e7cbea778195890e442c9e50f2a4e6d9Dmitri Plotnikov    protected String getAuthority() {
72bee1a6b2e7cbea778195890e442c9e50f2a4e6d9Dmitri Plotnikov        return ContactsContract.AUTHORITY;
73bee1a6b2e7cbea778195890e442c9e50f2a4e6d9Dmitri Plotnikov    }
74bee1a6b2e7cbea778195890e442c9e50f2a4e6d9Dmitri Plotnikov
75d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov    @Override
76d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov    protected void setUp() throws Exception {
77d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov        super.setUp();
78d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov
79bee1a6b2e7cbea778195890e442c9e50f2a4e6d9Dmitri Plotnikov        mActor = new ContactsActor(getContext(), PACKAGE_GREY, getProviderClass(), getAuthority());
80d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov        mResolver = mActor.resolver;
819261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        ((SynchronousContactsProvider2) mActor.provider).getOpenHelper(mActor.context).wipeData();
829261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana    }
839261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana
849261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana    protected Uri maybeAddAccountQueryParameters(Uri uri, Account account) {
859261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        if (account == null) {
869261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana            return uri;
879261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        }
889261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        return uri.buildUpon()
899261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana                .appendQueryParameter(Contacts.ACCOUNT_NAME, account.mName)
909261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana                .appendQueryParameter(Contacts.ACCOUNT_TYPE, account.mType)
919261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana                .build();
92d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov    }
93d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov
94d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov    protected long createContact() {
95d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov        ContentValues values = new ContentValues();
96d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov        values.put(Contacts.PACKAGE, mActor.packageName);
97d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov        Uri contactUri = mResolver.insert(Contacts.CONTENT_URI, values);
98d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov        return ContentUris.parseId(contactUri);
99d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov    }
100d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov
1019261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana    protected long createContact(Account account) {
1029261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        ContentValues values = new ContentValues();
1039261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        values.put(Contacts.PACKAGE, mActor.packageName);
1049261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        final Uri uri = maybeAddAccountQueryParameters(Contacts.CONTENT_URI, account);
1059261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        Uri contactUri = mResolver.insert(uri, values);
1069261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        return ContentUris.parseId(contactUri);
1079261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana    }
1089261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana
1099261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana    protected long createGroup(Account account, String sourceId, String title) {
1109261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        ContentValues values = new ContentValues();
1119261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        values.put(Groups.PACKAGE, mActor.packageName);
1129261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        values.put(Groups.SOURCE_ID, sourceId);
1139261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        values.put(Groups.TITLE, title);
1149261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        final Uri uri = maybeAddAccountQueryParameters(Groups.CONTENT_URI, account);
1159261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        return ContentUris.parseId(mResolver.insert(uri, values));
1169261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana    }
1179261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana
118d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov    protected Uri insertStructuredName(long contactId, String givenName, String familyName) {
119d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov        ContentValues values = new ContentValues();
120d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov        StringBuilder sb = new StringBuilder();
121d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov        if (givenName != null) {
122d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov            sb.append(givenName);
123d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov        }
124d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov        if (givenName != null && familyName != null) {
125d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov            sb.append(" ");
126d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov        }
127d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov        if (familyName != null) {
128d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov            sb.append(familyName);
129d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov        }
130d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov        values.put(StructuredName.DISPLAY_NAME, sb.toString());
131d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov        values.put(StructuredName.GIVEN_NAME, givenName);
132d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov        values.put(StructuredName.FAMILY_NAME, familyName);
133d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov
1344097855e2d672b3f8e1c5c8a169efb80203bf53eDmitri Plotnikov        return insertStructuredName(contactId, values);
1354097855e2d672b3f8e1c5c8a169efb80203bf53eDmitri Plotnikov    }
1364097855e2d672b3f8e1c5c8a169efb80203bf53eDmitri Plotnikov
1374097855e2d672b3f8e1c5c8a169efb80203bf53eDmitri Plotnikov    protected Uri insertStructuredName(long contactId, ContentValues values) {
1384097855e2d672b3f8e1c5c8a169efb80203bf53eDmitri Plotnikov        values.put(Data.CONTACT_ID, contactId);
1394097855e2d672b3f8e1c5c8a169efb80203bf53eDmitri Plotnikov        values.put(Data.MIMETYPE, StructuredName.CONTENT_ITEM_TYPE);
140d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov        Uri resultUri = mResolver.insert(Data.CONTENT_URI, values);
141d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov        return resultUri;
142d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov    }
143d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov
144bf659107617a6291ba8bfeebc3f2e50138075ab5Dmitri Plotnikov    protected Uri insertPhoneNumber(long contactId, String phoneNumber) {
145bf659107617a6291ba8bfeebc3f2e50138075ab5Dmitri Plotnikov        ContentValues values = new ContentValues();
146bf659107617a6291ba8bfeebc3f2e50138075ab5Dmitri Plotnikov        values.put(Data.CONTACT_ID, contactId);
147bf659107617a6291ba8bfeebc3f2e50138075ab5Dmitri Plotnikov        values.put(Data.MIMETYPE, Phone.CONTENT_ITEM_TYPE);
148bf659107617a6291ba8bfeebc3f2e50138075ab5Dmitri Plotnikov        values.put(Phone.NUMBER, phoneNumber);
1493cebbf7141252768d3e272e049e9c5b0cb9d710eDmitri Plotnikov        values.put(Phone.TYPE, Phone.TYPE_HOME);
150bf659107617a6291ba8bfeebc3f2e50138075ab5Dmitri Plotnikov
151bf659107617a6291ba8bfeebc3f2e50138075ab5Dmitri Plotnikov        Uri resultUri = mResolver.insert(Data.CONTENT_URI, values);
152bf659107617a6291ba8bfeebc3f2e50138075ab5Dmitri Plotnikov        return resultUri;
153bf659107617a6291ba8bfeebc3f2e50138075ab5Dmitri Plotnikov    }
154bf659107617a6291ba8bfeebc3f2e50138075ab5Dmitri Plotnikov
155a5ad551e1753086825499f1aeb6415bb986f3588Dmitri Plotnikov    protected Uri insertEmail(long contactId, String email) {
156a5ad551e1753086825499f1aeb6415bb986f3588Dmitri Plotnikov        ContentValues values = new ContentValues();
157a5ad551e1753086825499f1aeb6415bb986f3588Dmitri Plotnikov        values.put(Data.CONTACT_ID, contactId);
158a5ad551e1753086825499f1aeb6415bb986f3588Dmitri Plotnikov        values.put(Data.MIMETYPE, Email.CONTENT_ITEM_TYPE);
159a5ad551e1753086825499f1aeb6415bb986f3588Dmitri Plotnikov        values.put(Email.DATA, email);
1603cebbf7141252768d3e272e049e9c5b0cb9d710eDmitri Plotnikov        values.put(Email.TYPE, Email.TYPE_HOME);
161a5ad551e1753086825499f1aeb6415bb986f3588Dmitri Plotnikov
162a5ad551e1753086825499f1aeb6415bb986f3588Dmitri Plotnikov        Uri resultUri = mResolver.insert(Data.CONTENT_URI, values);
163a5ad551e1753086825499f1aeb6415bb986f3588Dmitri Plotnikov        return resultUri;
164a5ad551e1753086825499f1aeb6415bb986f3588Dmitri Plotnikov    }
165a5ad551e1753086825499f1aeb6415bb986f3588Dmitri Plotnikov
166a5ad551e1753086825499f1aeb6415bb986f3588Dmitri Plotnikov    protected Uri insertNickname(long contactId, String nickname) {
167a5ad551e1753086825499f1aeb6415bb986f3588Dmitri Plotnikov        ContentValues values = new ContentValues();
168a5ad551e1753086825499f1aeb6415bb986f3588Dmitri Plotnikov        values.put(Data.CONTACT_ID, contactId);
169a5ad551e1753086825499f1aeb6415bb986f3588Dmitri Plotnikov        values.put(Data.MIMETYPE, Nickname.CONTENT_ITEM_TYPE);
170a5ad551e1753086825499f1aeb6415bb986f3588Dmitri Plotnikov        values.put(Nickname.NAME, nickname);
1713cebbf7141252768d3e272e049e9c5b0cb9d710eDmitri Plotnikov        values.put(Nickname.TYPE, Nickname.TYPE_OTHER_NAME);
172a5ad551e1753086825499f1aeb6415bb986f3588Dmitri Plotnikov
173a5ad551e1753086825499f1aeb6415bb986f3588Dmitri Plotnikov        Uri resultUri = mResolver.insert(Data.CONTENT_URI, values);
174a5ad551e1753086825499f1aeb6415bb986f3588Dmitri Plotnikov        return resultUri;
175a5ad551e1753086825499f1aeb6415bb986f3588Dmitri Plotnikov    }
176a5ad551e1753086825499f1aeb6415bb986f3588Dmitri Plotnikov
177ae6ca1f34cf5458d79ec803411d4308879a91e92Evan Millar    protected Uri insertPhoto(long contactId) {
178ae6ca1f34cf5458d79ec803411d4308879a91e92Evan Millar        ContentValues values = new ContentValues();
179ae6ca1f34cf5458d79ec803411d4308879a91e92Evan Millar        values.put(Data.CONTACT_ID, contactId);
180ae6ca1f34cf5458d79ec803411d4308879a91e92Evan Millar        values.put(Data.MIMETYPE, Photo.CONTENT_ITEM_TYPE);
181ae6ca1f34cf5458d79ec803411d4308879a91e92Evan Millar
182ae6ca1f34cf5458d79ec803411d4308879a91e92Evan Millar        Uri resultUri = mResolver.insert(Data.CONTENT_URI, values);
183ae6ca1f34cf5458d79ec803411d4308879a91e92Evan Millar        return resultUri;
184ae6ca1f34cf5458d79ec803411d4308879a91e92Evan Millar    }
185ae6ca1f34cf5458d79ec803411d4308879a91e92Evan Millar
1869261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana    protected Uri insertGroupMembership(long contactId, String sourceId) {
1879261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        ContentValues values = new ContentValues();
1889261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        values.put(Data.CONTACT_ID, contactId);
1899261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        values.put(Data.MIMETYPE, GroupMembership.CONTENT_ITEM_TYPE);
1909261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        values.put(GroupMembership.GROUP_SOURCE_ID, sourceId);
1919261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        return mResolver.insert(Data.CONTENT_URI, values);
1929261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana    }
1939261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana
1949261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana    protected Uri insertGroupMembership(long contactId, Long groupId) {
1959261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        ContentValues values = new ContentValues();
1969261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        values.put(Data.CONTACT_ID, contactId);
1979261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        values.put(Data.MIMETYPE, GroupMembership.CONTENT_ITEM_TYPE);
1989261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        values.put(GroupMembership.GROUP_ROW_ID, groupId);
1999261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        return mResolver.insert(Data.CONTENT_URI, values);
2009261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana    }
2019261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana
202bc5c799a52b5bde2f273efd118ebe2228c3d8f15Evan Millar    protected Uri insertPresence(int protocol, String handle, int presence) {
203bc5c799a52b5bde2f273efd118ebe2228c3d8f15Evan Millar        ContentValues values = new ContentValues();
204bc5c799a52b5bde2f273efd118ebe2228c3d8f15Evan Millar        values.put(Presence.IM_PROTOCOL, protocol);
205bc5c799a52b5bde2f273efd118ebe2228c3d8f15Evan Millar        values.put(Presence.IM_HANDLE, handle);
206bc5c799a52b5bde2f273efd118ebe2228c3d8f15Evan Millar        values.put(Presence.PRESENCE_STATUS, presence);
207bc5c799a52b5bde2f273efd118ebe2228c3d8f15Evan Millar
208bc5c799a52b5bde2f273efd118ebe2228c3d8f15Evan Millar        Uri resultUri = mResolver.insert(Presence.CONTENT_URI, values);
209bc5c799a52b5bde2f273efd118ebe2228c3d8f15Evan Millar        return resultUri;
210bc5c799a52b5bde2f273efd118ebe2228c3d8f15Evan Millar    }
211bc5c799a52b5bde2f273efd118ebe2228c3d8f15Evan Millar
212bc5c799a52b5bde2f273efd118ebe2228c3d8f15Evan Millar    protected Uri insertImHandle(long contactId, int protocol, String handle) {
213bc5c799a52b5bde2f273efd118ebe2228c3d8f15Evan Millar        ContentValues values = new ContentValues();
214bc5c799a52b5bde2f273efd118ebe2228c3d8f15Evan Millar        values.put(Data.CONTACT_ID, contactId);
215bc5c799a52b5bde2f273efd118ebe2228c3d8f15Evan Millar        values.put(Data.MIMETYPE, Im.CONTENT_ITEM_TYPE);
216bc5c799a52b5bde2f273efd118ebe2228c3d8f15Evan Millar        values.put(Im.PROTOCOL, protocol);
217bc5c799a52b5bde2f273efd118ebe2228c3d8f15Evan Millar        values.put(Im.DATA, handle);
2183cebbf7141252768d3e272e049e9c5b0cb9d710eDmitri Plotnikov        values.put(Im.TYPE, Im.TYPE_HOME);
219bc5c799a52b5bde2f273efd118ebe2228c3d8f15Evan Millar
220bc5c799a52b5bde2f273efd118ebe2228c3d8f15Evan Millar        Uri resultUri = mResolver.insert(Data.CONTENT_URI, values);
221bc5c799a52b5bde2f273efd118ebe2228c3d8f15Evan Millar        return resultUri;
222bc5c799a52b5bde2f273efd118ebe2228c3d8f15Evan Millar    }
223bc5c799a52b5bde2f273efd118ebe2228c3d8f15Evan Millar
224ae6ca1f34cf5458d79ec803411d4308879a91e92Evan Millar    protected void setContactAccountName(long contactId, String accountName) {
225ae6ca1f34cf5458d79ec803411d4308879a91e92Evan Millar        ContentValues values = new ContentValues();
226ae6ca1f34cf5458d79ec803411d4308879a91e92Evan Millar        values.put(Contacts.ACCOUNT_NAME, accountName);
227ae6ca1f34cf5458d79ec803411d4308879a91e92Evan Millar
228ae6ca1f34cf5458d79ec803411d4308879a91e92Evan Millar        mResolver.update(ContentUris.withAppendedId(
229ae6ca1f34cf5458d79ec803411d4308879a91e92Evan Millar                Contacts.CONTENT_URI, contactId), values, null, null);
230ae6ca1f34cf5458d79ec803411d4308879a91e92Evan Millar    }
231ae6ca1f34cf5458d79ec803411d4308879a91e92Evan Millar
232d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov    protected void setAggregationException(int type, long aggregateId, long contactId) {
233d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov        ContentValues values = new ContentValues();
234d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov        values.put(AggregationExceptions.AGGREGATE_ID, aggregateId);
235d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov        values.put(AggregationExceptions.CONTACT_ID, contactId);
236d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov        values.put(AggregationExceptions.TYPE, type);
237d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov        mResolver.update(AggregationExceptions.CONTENT_URI, values, null, null);
238d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov    }
239d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov
240d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov    protected Cursor queryContact(long contactId) {
241d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov        return mResolver.query(ContentUris.withAppendedId(Contacts.CONTENT_URI, contactId), null,
242d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov                null, null, null);
243d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov    }
244d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov
245d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov    protected Cursor queryAggregate(long aggregateId) {
246d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov        return mResolver.query(ContentUris.withAppendedId(Aggregates.CONTENT_URI, aggregateId),
247d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov                null, null, null, null);
248d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov    }
249d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov
250bc5c799a52b5bde2f273efd118ebe2228c3d8f15Evan Millar    protected Cursor queryAggregateSummary(long aggregateId, String[] projection) {
251bc5c799a52b5bde2f273efd118ebe2228c3d8f15Evan Millar        return mResolver.query(ContentUris.withAppendedId(Aggregates.CONTENT_SUMMARY_URI,
252bc5c799a52b5bde2f273efd118ebe2228c3d8f15Evan Millar                aggregateId), projection, null, null, null);
253bc5c799a52b5bde2f273efd118ebe2228c3d8f15Evan Millar    }
254bc5c799a52b5bde2f273efd118ebe2228c3d8f15Evan Millar
255bc5c799a52b5bde2f273efd118ebe2228c3d8f15Evan Millar    protected Cursor queryAggregateSummary() {
256bc5c799a52b5bde2f273efd118ebe2228c3d8f15Evan Millar        return mResolver.query(Aggregates.CONTENT_SUMMARY_URI, null, null, null, null);
257bc5c799a52b5bde2f273efd118ebe2228c3d8f15Evan Millar    }
258bc5c799a52b5bde2f273efd118ebe2228c3d8f15Evan Millar
259d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov    protected long queryAggregateId(long contactId) {
260d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov        Cursor c = queryContact(contactId);
261d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov        assertTrue(c.moveToFirst());
262d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov        long aggregateId = c.getLong(c.getColumnIndex(Contacts.AGGREGATE_ID));
263d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov        c.close();
264d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov        return aggregateId;
265d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov    }
266d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov
267ae6ca1f34cf5458d79ec803411d4308879a91e92Evan Millar    protected long queryPhotoId(long aggregateId) {
268ae6ca1f34cf5458d79ec803411d4308879a91e92Evan Millar        Cursor c = queryAggregate(aggregateId);
269ae6ca1f34cf5458d79ec803411d4308879a91e92Evan Millar        assertTrue(c.moveToFirst());
270ae6ca1f34cf5458d79ec803411d4308879a91e92Evan Millar        long photoId = c.getInt(c.getColumnIndex(Aggregates.PHOTO_ID));
271ae6ca1f34cf5458d79ec803411d4308879a91e92Evan Millar        c.close();
272ae6ca1f34cf5458d79ec803411d4308879a91e92Evan Millar        return photoId;
273ae6ca1f34cf5458d79ec803411d4308879a91e92Evan Millar    }
274ae6ca1f34cf5458d79ec803411d4308879a91e92Evan Millar
275d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov    protected String queryDisplayName(long aggregateId) {
276d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov        Cursor c = queryAggregate(aggregateId);
277d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov        assertTrue(c.moveToFirst());
278d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov        String displayName = c.getString(c.getColumnIndex(Aggregates.DISPLAY_NAME));
279d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov        c.close();
280d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov        return displayName;
281d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov    }
282d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov
283bf659107617a6291ba8bfeebc3f2e50138075ab5Dmitri Plotnikov    protected void assertAggregated(long contactId1, long contactId2) {
284bf659107617a6291ba8bfeebc3f2e50138075ab5Dmitri Plotnikov        long aggregateId1 = queryAggregateId(contactId1);
285bf659107617a6291ba8bfeebc3f2e50138075ab5Dmitri Plotnikov        long aggregateId2 = queryAggregateId(contactId2);
286bf659107617a6291ba8bfeebc3f2e50138075ab5Dmitri Plotnikov        assertTrue(aggregateId1 == aggregateId2);
287bf659107617a6291ba8bfeebc3f2e50138075ab5Dmitri Plotnikov    }
288bf659107617a6291ba8bfeebc3f2e50138075ab5Dmitri Plotnikov
289d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov    protected void assertAggregated(long contactId1, long contactId2, String expectedDisplayName) {
290d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov        long aggregateId1 = queryAggregateId(contactId1);
291d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov        long aggregateId2 = queryAggregateId(contactId2);
292d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov        assertTrue(aggregateId1 == aggregateId2);
293d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov
294d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov        String displayName = queryDisplayName(aggregateId1);
295d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov        assertEquals(expectedDisplayName, displayName);
296d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov    }
297d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov
298d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov    protected void assertNotAggregated(long contactId1, long contactId2) {
299d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov        long aggregateId1 = queryAggregateId(contactId1);
300d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov        long aggregateId2 = queryAggregateId(contactId2);
301d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov        assertTrue(aggregateId1 != aggregateId2);
302d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov    }
3034097855e2d672b3f8e1c5c8a169efb80203bf53eDmitri Plotnikov
3044097855e2d672b3f8e1c5c8a169efb80203bf53eDmitri Plotnikov    protected void assertStructuredName(long contactId, String prefix, String givenName,
3054097855e2d672b3f8e1c5c8a169efb80203bf53eDmitri Plotnikov            String middleName, String familyName, String suffix) {
3064097855e2d672b3f8e1c5c8a169efb80203bf53eDmitri Plotnikov        Uri uri = Uri.withAppendedPath(ContentUris.withAppendedId(Contacts.CONTENT_URI, contactId),
3074097855e2d672b3f8e1c5c8a169efb80203bf53eDmitri Plotnikov                Contacts.Data.CONTENT_DIRECTORY);
3084097855e2d672b3f8e1c5c8a169efb80203bf53eDmitri Plotnikov
3094097855e2d672b3f8e1c5c8a169efb80203bf53eDmitri Plotnikov        final String[] projection = new String[] {
3104097855e2d672b3f8e1c5c8a169efb80203bf53eDmitri Plotnikov                StructuredName.PREFIX, StructuredName.GIVEN_NAME, StructuredName.MIDDLE_NAME,
3114097855e2d672b3f8e1c5c8a169efb80203bf53eDmitri Plotnikov                StructuredName.FAMILY_NAME, StructuredName.SUFFIX
3124097855e2d672b3f8e1c5c8a169efb80203bf53eDmitri Plotnikov        };
3134097855e2d672b3f8e1c5c8a169efb80203bf53eDmitri Plotnikov
3144097855e2d672b3f8e1c5c8a169efb80203bf53eDmitri Plotnikov        Cursor c = mResolver.query(uri, projection, Data.MIMETYPE + "='"
3154097855e2d672b3f8e1c5c8a169efb80203bf53eDmitri Plotnikov                + StructuredName.CONTENT_ITEM_TYPE + "'", null, null);
3164097855e2d672b3f8e1c5c8a169efb80203bf53eDmitri Plotnikov
3174097855e2d672b3f8e1c5c8a169efb80203bf53eDmitri Plotnikov        assertTrue(c.moveToFirst());
3184097855e2d672b3f8e1c5c8a169efb80203bf53eDmitri Plotnikov        assertEquals(prefix, c.getString(0));
3194097855e2d672b3f8e1c5c8a169efb80203bf53eDmitri Plotnikov        assertEquals(givenName, c.getString(1));
3204097855e2d672b3f8e1c5c8a169efb80203bf53eDmitri Plotnikov        assertEquals(middleName, c.getString(2));
3214097855e2d672b3f8e1c5c8a169efb80203bf53eDmitri Plotnikov        assertEquals(familyName, c.getString(3));
3224097855e2d672b3f8e1c5c8a169efb80203bf53eDmitri Plotnikov        assertEquals(suffix, c.getString(4));
3234097855e2d672b3f8e1c5c8a169efb80203bf53eDmitri Plotnikov        c.close();
3244097855e2d672b3f8e1c5c8a169efb80203bf53eDmitri Plotnikov    }
3259261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana
3269261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana    protected long assertSingleGroup(Long rowId, Account account, String sourceId, String title) {
3279261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        Cursor c = mResolver.query(Groups.CONTENT_URI, null, null, null, null);
3289261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        try {
3299261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana            assertTrue(c.moveToNext());
3309261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana            long actualRowId = assertGroup(c, rowId, account, sourceId, title);
3319261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana            assertFalse(c.moveToNext());
3329261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana            return actualRowId;
3339261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        } finally {
3349261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana            c.close();
3359261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        }
3369261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana    }
3379261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana
3389261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana    protected long assertSingleGroupMembership(Long rowId, Long contactId, Long groupRowId,
3399261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana            String sourceId) {
3409261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        Cursor c = mResolver.query(ContactsContract.Data.CONTENT_URI, null, null, null, null);
3419261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        try {
3429261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana            assertTrue(c.moveToNext());
3439261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana            long actualRowId = assertGroupMembership(c, rowId, contactId, groupRowId, sourceId);
3449261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana            assertFalse(c.moveToNext());
3459261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana            return actualRowId;
3469261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        } finally {
3479261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana            c.close();
3489261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        }
3499261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana    }
3509261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana
3519261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana    protected long assertGroupMembership(Cursor c, Long rowId, Long contactId, Long groupRowId,
3529261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana            String sourceId) {
3539261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        assertNullOrEquals(c, rowId, Data._ID);
3549261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        assertNullOrEquals(c, contactId, GroupMembership.CONTACT_ID);
3559261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        assertNullOrEquals(c, groupRowId, GroupMembership.GROUP_ROW_ID);
3569261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        assertNullOrEquals(c, sourceId, GroupMembership.GROUP_SOURCE_ID);
3579261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        return c.getLong(c.getColumnIndexOrThrow("_id"));
3589261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana    }
3599261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana
3609261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana    protected long assertGroup(Cursor c, Long rowId, Account account, String sourceId, String title) {
3619261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        assertNullOrEquals(c, rowId, Groups._ID);
3629261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        assertNullOrEquals(c, account);
3639261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        assertNullOrEquals(c, sourceId, Groups.SOURCE_ID);
3649261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        assertNullOrEquals(c, title, Groups.TITLE);
3659261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        return c.getLong(c.getColumnIndexOrThrow("_id"));
3669261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana    }
3679261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana
3689261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana    private void assertNullOrEquals(Cursor c, Account account) {
3699261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        if (account == NO_ACCOUNT) {
3709261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana            return;
3719261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        }
3729261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        if (account == null) {
3739261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana            assertTrue(c.isNull(c.getColumnIndexOrThrow(Groups.ACCOUNT_NAME)));
3749261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana            assertTrue(c.isNull(c.getColumnIndexOrThrow(Groups.ACCOUNT_TYPE)));
3759261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        } else {
3769261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana            assertEquals(account.mName, c.getString(c.getColumnIndexOrThrow(Groups.ACCOUNT_NAME)));
3779261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana            assertEquals(account.mType, c.getString(c.getColumnIndexOrThrow(Groups.ACCOUNT_TYPE)));
3789261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        }
3799261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana    }
3809261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana
3819261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana    private void assertNullOrEquals(Cursor c, Long value, String columnName) {
3829261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        if (value != NO_LONG) {
3839261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana            if (value == null) assertTrue(c.isNull(c.getColumnIndexOrThrow(columnName)));
3849261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana            else assertEquals((long) value, c.getLong(c.getColumnIndexOrThrow(columnName)));
3859261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        }
3869261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana    }
3879261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana
3889261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana    private void assertNullOrEquals(Cursor c, String value, String columnName) {
3899261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        if (value != NO_STRING) {
3909261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana            if (value == null) assertTrue(c.isNull(c.getColumnIndexOrThrow(columnName)));
3919261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana            else assertEquals(value, c.getString(c.getColumnIndexOrThrow(columnName)));
3929261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        }
3939261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana    }
3949261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana
3959261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana    protected void assertDataRow(ContentValues actual, String expectedMimetype,
3969261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana            Object... expectedArguments) {
3979261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        assertEquals(actual.toString(), expectedMimetype, actual.getAsString(Data.MIMETYPE));
3989261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        for (int i = 0; i < expectedArguments.length; i += 2) {
3999261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana            String columnName = (String) expectedArguments[i];
4009261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana            Object expectedValue = expectedArguments[i + 1];
4019261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana            if (expectedValue instanceof Uri) {
4029261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana                expectedValue = ContentUris.parseId((Uri) expectedValue);
4039261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana            }
4049261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana            if (expectedValue == null) {
4059261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana                assertNull(actual.toString(), actual.get(columnName));
4069261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana            }
4079261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana            if (expectedValue instanceof Long) {
4089261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana                assertEquals(actual.toString(), expectedValue, actual.getAsLong(columnName));
4099261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana            } else if (expectedValue instanceof Integer) {
4109261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana                assertEquals(actual.toString(), expectedValue, actual.getAsInteger(columnName));
4119261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana            } else if (expectedValue instanceof String) {
4129261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana                assertEquals(actual.toString(), expectedValue, actual.getAsString(columnName));
4139261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana            } else {
4149261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana                assertEquals(actual.toString(), expectedValue, actual.get(columnName));
4159261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana            }
4169261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        }
4179261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana    }
4189261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana
4199261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana    protected static class IdComparator implements Comparator<ContentValues> {
4209261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        public int compare(ContentValues o1, ContentValues o2) {
4219261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana            long id1 = o1.getAsLong(ContactsContract.Data._ID);
4229261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana            long id2 = o2.getAsLong(ContactsContract.Data._ID);
4239261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana            if (id1 == id2) return 0;
4249261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana            return (id1 < id2) ? -1 : 1;
4259261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        }
4269261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana    }
4279261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana
4289261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana    protected ContentValues[] asSortedContentValuesArray(
4299261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana            ArrayList<Entity.NamedContentValues> subValues) {
4309261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        ContentValues[] result = new ContentValues[subValues.size()];
4319261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        int i = 0;
4329261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        for (Entity.NamedContentValues subValue : subValues) {
4339261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana            result[i] = subValue.values;
4349261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana            i++;
4359261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        }
4369261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        Arrays.sort(result, new IdComparator());
4379261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        return result;
4389261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana    }
4399261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana
4409261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana    protected void assertDirty(Uri uri, boolean state) {
4419261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        Cursor c = mResolver.query(uri, new String[]{"dirty"}, null, null, null);
4429261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        assertTrue(c.moveToNext());
4439261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        assertEquals(state, c.getLong(0) != 0);
4449261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        assertFalse(c.moveToNext());
4459261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana    }
4469261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana
4479261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana    protected long getVersion(Uri uri) {
4489261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        Cursor c = mResolver.query(uri, new String[]{"version"}, null, null, null);
4499261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        assertTrue(c.moveToNext());
4509261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        long version = c.getLong(0);
4519261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        assertFalse(c.moveToNext());
4529261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        return version;
4539261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana    }
4549261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana
4559261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana    protected void clearDirty(Uri uri) {
4569261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        ContentValues values = new ContentValues();
4579261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        values.put("dirty", 0);
4589261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        mResolver.update(uri, values, null, null);
4599261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana    }
460d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov}
461