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 */
168920a04b4a68ed6b548bcdef5ca8736dcf8b69b1Omari Stephens
1728f8857b1b46bde18b85c6d3c2a63ac44c3c2e1cEvan Millarpackage com.android.providers.contacts;
18d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov
190bf6b318e3c994294d4a885f57906debd4a0e64eDaniel Lehmannimport static com.android.providers.contacts.ContactsActor.PACKAGE_GREY;
200bf6b318e3c994294d4a885f57906debd4a0e64eDaniel Lehmann
21e99988b266dd1263162583e81e2b408e7329b1c8Dmitri Plotnikovimport android.accounts.Account;
22bee1a6b2e7cbea778195890e442c9e50f2a4e6d9Dmitri Plotnikovimport android.content.ContentProvider;
23b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikovimport android.content.ContentResolver;
24d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikovimport android.content.ContentUris;
25d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikovimport android.content.ContentValues;
26e99988b266dd1263162583e81e2b408e7329b1c8Dmitri Plotnikovimport android.content.Context;
279261b2141aa90a4fed632fd6da03026d4c216280Fred Quintanaimport android.content.Entity;
28d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikovimport android.database.Cursor;
29dfab50ecd585e55769dea451cb3a47ff69b8b86dMakoto Onukiimport android.database.sqlite.SQLiteDatabase;
30d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikovimport android.net.Uri;
316f983fd835f0cdd5ac7931ccd49d44e9ea4c87c0Dave Santoroimport android.os.Bundle;
3280628945e7e41bb9363c2fbbd2938890b9217792Makoto Onukiimport android.provider.BaseColumns;
33bee1a6b2e7cbea778195890e442c9e50f2a4e6d9Dmitri Plotnikovimport android.provider.ContactsContract;
34d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikovimport android.provider.ContactsContract.AggregationExceptions;
35a5ad551e1753086825499f1aeb6415bb986f3588Dmitri Plotnikovimport android.provider.ContactsContract.CommonDataKinds.Email;
366d9702cec82fd27a1c3093c64df9dcc22744899aDmitri Plotnikovimport android.provider.ContactsContract.CommonDataKinds.Event;
379261b2141aa90a4fed632fd6da03026d4c216280Fred Quintanaimport android.provider.ContactsContract.CommonDataKinds.GroupMembership;
380992b9d4969ed0eee6e879db94292b635229e2b7Makoto Onukiimport android.provider.ContactsContract.CommonDataKinds.Identity;
39e99988b266dd1263162583e81e2b408e7329b1c8Dmitri Plotnikovimport android.provider.ContactsContract.CommonDataKinds.Im;
40a5ad551e1753086825499f1aeb6415bb986f3588Dmitri Plotnikovimport android.provider.ContactsContract.CommonDataKinds.Nickname;
416d9702cec82fd27a1c3093c64df9dcc22744899aDmitri Plotnikovimport android.provider.ContactsContract.CommonDataKinds.Note;
4201911fa9cfa21f198fd767eedde072acbb879f28Dmitri Plotnikovimport android.provider.ContactsContract.CommonDataKinds.Organization;
43bf659107617a6291ba8bfeebc3f2e50138075ab5Dmitri Plotnikovimport android.provider.ContactsContract.CommonDataKinds.Phone;
44ae6ca1f34cf5458d79ec803411d4308879a91e92Evan Millarimport android.provider.ContactsContract.CommonDataKinds.Photo;
45e432023d408c461295e53c0593fabb2b4c17aeb3Daisuke Miyakawaimport android.provider.ContactsContract.CommonDataKinds.SipAddress;
46e99988b266dd1263162583e81e2b408e7329b1c8Dmitri Plotnikovimport android.provider.ContactsContract.CommonDataKinds.StructuredName;
474a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikovimport android.provider.ContactsContract.CommonDataKinds.StructuredPostal;
4809ae48b82b17e24016b14a1ab64706222ab1071fDmitri Plotnikovimport android.provider.ContactsContract.Contacts;
4909ae48b82b17e24016b14a1ab64706222ab1071fDmitri Plotnikovimport android.provider.ContactsContract.Data;
5009ae48b82b17e24016b14a1ab64706222ab1071fDmitri Plotnikovimport android.provider.ContactsContract.Groups;
5109ae48b82b17e24016b14a1ab64706222ab1071fDmitri Plotnikovimport android.provider.ContactsContract.RawContacts;
526f983fd835f0cdd5ac7931ccd49d44e9ea4c87c0Dave Santoroimport android.provider.ContactsContract.SearchSnippetColumns;
5309ae48b82b17e24016b14a1ab64706222ab1071fDmitri Plotnikovimport android.provider.ContactsContract.Settings;
5409ae48b82b17e24016b14a1ab64706222ab1071fDmitri Plotnikovimport android.provider.ContactsContract.StatusUpdates;
553b505de6c622d20d40b85b361c1437a89aef82deDaniel Lehmannimport android.provider.ContactsContract.StreamItems;
5609ae48b82b17e24016b14a1ab64706222ab1071fDmitri Plotnikovimport android.test.MoreAsserts;
57d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikovimport android.test.mock.MockContentResolver;
58b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikovimport android.util.Log;
59bee1a6b2e7cbea778195890e442c9e50f2a4e6d9Dmitri Plotnikov
6038210445730ee04c351c7cc1b3800cfe23e34325Makoto Onukiimport com.android.providers.contacts.ContactsDatabaseHelper.Tables;
6138210445730ee04c351c7cc1b3800cfe23e34325Makoto Onukiimport com.android.providers.contacts.util.Hex;
6238210445730ee04c351c7cc1b3800cfe23e34325Makoto Onukiimport com.android.providers.contacts.util.MockClock;
6338210445730ee04c351c7cc1b3800cfe23e34325Makoto Onukiimport com.google.android.collect.Sets;
6438210445730ee04c351c7cc1b3800cfe23e34325Makoto Onuki
659261b2141aa90a4fed632fd6da03026d4c216280Fred Quintanaimport java.util.ArrayList;
669261b2141aa90a4fed632fd6da03026d4c216280Fred Quintanaimport java.util.Arrays;
67ac61fb8b20b05bb7a9af7c6d68bf8cdbdf675102Makoto Onukiimport java.util.BitSet;
68e99988b266dd1263162583e81e2b408e7329b1c8Dmitri Plotnikovimport java.util.Comparator;
69ff2de103f7e3eeeff4665ef63f07460fef053d6dDmitri Plotnikovimport java.util.Iterator;
7020a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikovimport java.util.Map;
71ff2de103f7e3eeeff4665ef63f07460fef053d6dDmitri Plotnikovimport java.util.Map.Entry;
7209ae48b82b17e24016b14a1ab64706222ab1071fDmitri Plotnikovimport java.util.Set;
73d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov
74d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov/**
75d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov * A common superclass for {@link ContactsProvider2}-related tests.
76d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov */
77f547fd54d7933e1c03af4a8dc10560c71c38f6b8Dave Santoropublic abstract class BaseContactsProvider2Test extends PhotoLoadingTestCase {
78d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov
79d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov    protected static final String PACKAGE = "ContactsProvider2Test";
8073f1f396c155b247b903d8f4111db17d3e13dc4dDmitri Plotnikov    public static final String READ_ONLY_ACCOUNT_TYPE =
8173f1f396c155b247b903d8f4111db17d3e13dc4dDmitri Plotnikov            SynchronousContactsProvider2.READ_ONLY_ACCOUNT_TYPE;
82d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov
83bee1a6b2e7cbea778195890e442c9e50f2a4e6d9Dmitri Plotnikov    protected ContactsActor mActor;
84d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov    protected MockContentResolver mResolver;
859261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana    protected Account mAccount = new Account("account1", "account type1");
86e2579e029472f76b2dfda141444d775c67da0ec8Cynthia Wong    protected Account mAccountTwo = new Account("account2", "account type2");
879261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana
889261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana    protected final static Long NO_LONG = new Long(0);
899261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana    protected final static String NO_STRING = new String("");
909261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana    protected final static Account NO_ACCOUNT = new Account("a", "b");
91d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov
92dfab50ecd585e55769dea451cb3a47ff69b8b86dMakoto Onuki    /**
93dfab50ecd585e55769dea451cb3a47ff69b8b86dMakoto Onuki     * Use {@link MockClock#install()} to start using it.
94dfab50ecd585e55769dea451cb3a47ff69b8b86dMakoto Onuki     * It'll be automatically uninstalled by {@link #tearDown()}.
95dfab50ecd585e55769dea451cb3a47ff69b8b86dMakoto Onuki     */
96dfab50ecd585e55769dea451cb3a47ff69b8b86dMakoto Onuki    protected static final MockClock sMockClock = new MockClock();
97dfab50ecd585e55769dea451cb3a47ff69b8b86dMakoto Onuki
98bee1a6b2e7cbea778195890e442c9e50f2a4e6d9Dmitri Plotnikov    protected Class<? extends ContentProvider> getProviderClass() {
99bee1a6b2e7cbea778195890e442c9e50f2a4e6d9Dmitri Plotnikov        return SynchronousContactsProvider2.class;
100bee1a6b2e7cbea778195890e442c9e50f2a4e6d9Dmitri Plotnikov    }
101bee1a6b2e7cbea778195890e442c9e50f2a4e6d9Dmitri Plotnikov
102bee1a6b2e7cbea778195890e442c9e50f2a4e6d9Dmitri Plotnikov    protected String getAuthority() {
103bee1a6b2e7cbea778195890e442c9e50f2a4e6d9Dmitri Plotnikov        return ContactsContract.AUTHORITY;
104bee1a6b2e7cbea778195890e442c9e50f2a4e6d9Dmitri Plotnikov    }
105bee1a6b2e7cbea778195890e442c9e50f2a4e6d9Dmitri Plotnikov
106d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov    @Override
107d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov    protected void setUp() throws Exception {
108d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov        super.setUp();
109d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov
110bee1a6b2e7cbea778195890e442c9e50f2a4e6d9Dmitri Plotnikov        mActor = new ContactsActor(getContext(), PACKAGE_GREY, getProviderClass(), getAuthority());
111d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov        mResolver = mActor.resolver;
112445ca81effbb0d61c7bc0033acf2d3dfd228fd4eDmitri Plotnikov        if (mActor.provider instanceof SynchronousContactsProvider2) {
1139a6be1610fdf40c2f7f04cfe4b66fde3a35940dcDmitri Plotnikov            getContactsProvider().wipeData();
114445ca81effbb0d61c7bc0033acf2d3dfd228fd4eDmitri Plotnikov        }
11524c1d384b45a6d3c1cc959062a9d4308335fabbfDave Santoro
11624c1d384b45a6d3c1cc959062a9d4308335fabbfDave Santoro        // Give the actor access to read/write contacts and profile data by default.
11724c1d384b45a6d3c1cc959062a9d4308335fabbfDave Santoro        mActor.addPermissions(
11824c1d384b45a6d3c1cc959062a9d4308335fabbfDave Santoro                "android.permission.READ_CONTACTS",
11924c1d384b45a6d3c1cc959062a9d4308335fabbfDave Santoro                "android.permission.WRITE_CONTACTS",
12036612112760df799ef89f7e324e5dfabd5ca0d2bDave Santoro                "android.permission.READ_SOCIAL_STREAM",
12136612112760df799ef89f7e324e5dfabd5ca0d2bDave Santoro                "android.permission.WRITE_SOCIAL_STREAM",
12224c1d384b45a6d3c1cc959062a9d4308335fabbfDave Santoro                "android.permission.READ_PROFILE",
12324c1d384b45a6d3c1cc959062a9d4308335fabbfDave Santoro                "android.permission.WRITE_PROFILE");
1249261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana    }
1259261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana
1260265a180cf027d149f11f8750652ac67ea08ca24Dmitri Plotnikov    @Override
1270265a180cf027d149f11f8750652ac67ea08ca24Dmitri Plotnikov    protected void tearDown() throws Exception {
128dfab50ecd585e55769dea451cb3a47ff69b8b86dMakoto Onuki        sMockClock.uninstall();
1290265a180cf027d149f11f8750652ac67ea08ca24Dmitri Plotnikov        super.tearDown();
1300265a180cf027d149f11f8750652ac67ea08ca24Dmitri Plotnikov    }
1310265a180cf027d149f11f8750652ac67ea08ca24Dmitri Plotnikov
1329a6be1610fdf40c2f7f04cfe4b66fde3a35940dcDmitri Plotnikov    public SynchronousContactsProvider2 getContactsProvider() {
1339a6be1610fdf40c2f7f04cfe4b66fde3a35940dcDmitri Plotnikov        return (SynchronousContactsProvider2) mActor.provider;
1349a6be1610fdf40c2f7f04cfe4b66fde3a35940dcDmitri Plotnikov    }
1359a6be1610fdf40c2f7f04cfe4b66fde3a35940dcDmitri Plotnikov
136e99988b266dd1263162583e81e2b408e7329b1c8Dmitri Plotnikov    public Context getMockContext() {
137e99988b266dd1263162583e81e2b408e7329b1c8Dmitri Plotnikov        return mActor.context;
138e99988b266dd1263162583e81e2b408e7329b1c8Dmitri Plotnikov    }
139e99988b266dd1263162583e81e2b408e7329b1c8Dmitri Plotnikov
140e99988b266dd1263162583e81e2b408e7329b1c8Dmitri Plotnikov    public void addAuthority(String authority) {
141e99988b266dd1263162583e81e2b408e7329b1c8Dmitri Plotnikov        mActor.addAuthority(authority);
142e99988b266dd1263162583e81e2b408e7329b1c8Dmitri Plotnikov    }
143e99988b266dd1263162583e81e2b408e7329b1c8Dmitri Plotnikov
144e99988b266dd1263162583e81e2b408e7329b1c8Dmitri Plotnikov    public ContentProvider addProvider(Class<? extends ContentProvider> providerClass,
145e99988b266dd1263162583e81e2b408e7329b1c8Dmitri Plotnikov            String authority) throws Exception {
146e99988b266dd1263162583e81e2b408e7329b1c8Dmitri Plotnikov        return mActor.addProvider(providerClass, authority);
147e99988b266dd1263162583e81e2b408e7329b1c8Dmitri Plotnikov    }
148e99988b266dd1263162583e81e2b408e7329b1c8Dmitri Plotnikov
1493d8b043c3341a5b6c2e781b7eba9767d5cd13267Dmitri Plotnikov    public ContentProvider getProvider() {
1503d8b043c3341a5b6c2e781b7eba9767d5cd13267Dmitri Plotnikov        return mActor.provider;
1513d8b043c3341a5b6c2e781b7eba9767d5cd13267Dmitri Plotnikov    }
1523d8b043c3341a5b6c2e781b7eba9767d5cd13267Dmitri Plotnikov
1539261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana    protected Uri maybeAddAccountQueryParameters(Uri uri, Account account) {
1549261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        if (account == null) {
1559261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana            return uri;
1569261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        }
1579261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        return uri.buildUpon()
158df9fd6b239de5829b04cb413e4dfa3e6da649c38Fred Quintana                .appendQueryParameter(RawContacts.ACCOUNT_NAME, account.name)
159df9fd6b239de5829b04cb413e4dfa3e6da649c38Fred Quintana                .appendQueryParameter(RawContacts.ACCOUNT_TYPE, account.type)
1609261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana                .build();
161d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov    }
162d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov
163d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov    protected long createRawContact() {
164226c3dc6e93ca76a84c99100caa31045cba06cf6Fred Quintana        return createRawContact(null);
165d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov    }
166d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov
167c70dc0e38ff82c6e6d6b7458637c54fbdf446aacDmitri Plotnikov    protected long createRawContactWithName() {
168e246689441b2ff39cb97de277d6caeec95358863Jeff Sharkey        return createRawContactWithName(null);
169e246689441b2ff39cb97de277d6caeec95358863Jeff Sharkey    }
170e246689441b2ff39cb97de277d6caeec95358863Jeff Sharkey
171e246689441b2ff39cb97de277d6caeec95358863Jeff Sharkey    protected long createRawContactWithName(Account account) {
172e246689441b2ff39cb97de277d6caeec95358863Jeff Sharkey        return createRawContactWithName("John", "Doe", account);
1733cfe8d532d509fbbe605454e3a32b2361b7e1501Dmitri Plotnikov    }
1743cfe8d532d509fbbe605454e3a32b2361b7e1501Dmitri Plotnikov
1753cfe8d532d509fbbe605454e3a32b2361b7e1501Dmitri Plotnikov    protected long createRawContactWithName(String firstName, String lastName) {
176e246689441b2ff39cb97de277d6caeec95358863Jeff Sharkey        return createRawContactWithName(firstName, lastName, null);
177e246689441b2ff39cb97de277d6caeec95358863Jeff Sharkey    }
178e246689441b2ff39cb97de277d6caeec95358863Jeff Sharkey
179e246689441b2ff39cb97de277d6caeec95358863Jeff Sharkey    protected long createRawContactWithName(String firstName, String lastName, Account account) {
180e246689441b2ff39cb97de277d6caeec95358863Jeff Sharkey        long rawContactId = createRawContact(account);
1813cfe8d532d509fbbe605454e3a32b2361b7e1501Dmitri Plotnikov        insertStructuredName(rawContactId, firstName, lastName);
182c70dc0e38ff82c6e6d6b7458637c54fbdf446aacDmitri Plotnikov        return rawContactId;
183c70dc0e38ff82c6e6d6b7458637c54fbdf446aacDmitri Plotnikov    }
184c70dc0e38ff82c6e6d6b7458637c54fbdf446aacDmitri Plotnikov
185e246689441b2ff39cb97de277d6caeec95358863Jeff Sharkey    protected Uri setCallerIsSyncAdapter(Uri uri, Account account) {
186e246689441b2ff39cb97de277d6caeec95358863Jeff Sharkey        if (account == null) {
187e246689441b2ff39cb97de277d6caeec95358863Jeff Sharkey            return uri;
188e246689441b2ff39cb97de277d6caeec95358863Jeff Sharkey        }
189e246689441b2ff39cb97de277d6caeec95358863Jeff Sharkey        final Uri.Builder builder = uri.buildUpon();
190e246689441b2ff39cb97de277d6caeec95358863Jeff Sharkey        builder.appendQueryParameter(ContactsContract.RawContacts.ACCOUNT_NAME, account.name);
191e246689441b2ff39cb97de277d6caeec95358863Jeff Sharkey        builder.appendQueryParameter(ContactsContract.RawContacts.ACCOUNT_TYPE, account.type);
192e246689441b2ff39cb97de277d6caeec95358863Jeff Sharkey        builder.appendQueryParameter(ContactsContract.CALLER_IS_SYNCADAPTER, "true");
193e246689441b2ff39cb97de277d6caeec95358863Jeff Sharkey        return builder.build();
194e246689441b2ff39cb97de277d6caeec95358863Jeff Sharkey    }
195e246689441b2ff39cb97de277d6caeec95358863Jeff Sharkey
196226c3dc6e93ca76a84c99100caa31045cba06cf6Fred Quintana    protected long createRawContact(Account account, String... extras) {
1979261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        ContentValues values = new ContentValues();
198dd5c25c65f09ada246c826fb6d04f0b6d4cf4388Fred Quintana        extrasVarArgsToValues(values, extras);
199dd5c25c65f09ada246c826fb6d04f0b6d4cf4388Fred Quintana        final Uri uri = maybeAddAccountQueryParameters(RawContacts.CONTENT_URI, account);
200dd5c25c65f09ada246c826fb6d04f0b6d4cf4388Fred Quintana        Uri contactUri = mResolver.insert(uri, values);
201dd5c25c65f09ada246c826fb6d04f0b6d4cf4388Fred Quintana        return ContentUris.parseId(contactUri);
202dd5c25c65f09ada246c826fb6d04f0b6d4cf4388Fred Quintana    }
203dd5c25c65f09ada246c826fb6d04f0b6d4cf4388Fred Quintana
204dd5c25c65f09ada246c826fb6d04f0b6d4cf4388Fred Quintana    protected int updateItem(Uri uri, long id, String... extras) {
205dd5c25c65f09ada246c826fb6d04f0b6d4cf4388Fred Quintana        Uri itemUri = ContentUris.withAppendedId(uri, id);
206dd5c25c65f09ada246c826fb6d04f0b6d4cf4388Fred Quintana        return updateItem(itemUri, extras);
207dd5c25c65f09ada246c826fb6d04f0b6d4cf4388Fred Quintana    }
208dd5c25c65f09ada246c826fb6d04f0b6d4cf4388Fred Quintana
209dd5c25c65f09ada246c826fb6d04f0b6d4cf4388Fred Quintana    protected int updateItem(Uri uri, String... extras) {
210dd5c25c65f09ada246c826fb6d04f0b6d4cf4388Fred Quintana        ContentValues values = new ContentValues();
211dd5c25c65f09ada246c826fb6d04f0b6d4cf4388Fred Quintana        extrasVarArgsToValues(values, extras);
212dd5c25c65f09ada246c826fb6d04f0b6d4cf4388Fred Quintana        return mResolver.update(uri, values, null, null);
213dd5c25c65f09ada246c826fb6d04f0b6d4cf4388Fred Quintana    }
214dd5c25c65f09ada246c826fb6d04f0b6d4cf4388Fred Quintana
215dd5c25c65f09ada246c826fb6d04f0b6d4cf4388Fred Quintana    private static void extrasVarArgsToValues(ContentValues values, String... extras) {
216226c3dc6e93ca76a84c99100caa31045cba06cf6Fred Quintana        for (int i = 0; i < extras.length; ) {
217226c3dc6e93ca76a84c99100caa31045cba06cf6Fred Quintana            values.put(extras[i], extras[i + 1]);
218226c3dc6e93ca76a84c99100caa31045cba06cf6Fred Quintana            i += 2;
219226c3dc6e93ca76a84c99100caa31045cba06cf6Fred Quintana        }
2209261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana    }
2219261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana
2229261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana    protected long createGroup(Account account, String sourceId, String title) {
223dd5c25c65f09ada246c826fb6d04f0b6d4cf4388Fred Quintana        return createGroup(account, sourceId, title, 1, false, false);
2240be993f8ef0078b9825a5ffe6add08a6786d8dacDmitri Plotnikov    }
2250be993f8ef0078b9825a5ffe6add08a6786d8dacDmitri Plotnikov
2260be993f8ef0078b9825a5ffe6add08a6786d8dacDmitri Plotnikov    protected long createGroup(Account account, String sourceId, String title, int visible) {
227dd5c25c65f09ada246c826fb6d04f0b6d4cf4388Fred Quintana        return createGroup(account, sourceId, title, visible, false, false);
228dd5c25c65f09ada246c826fb6d04f0b6d4cf4388Fred Quintana    }
229dd5c25c65f09ada246c826fb6d04f0b6d4cf4388Fred Quintana
230f266e8c568905337960b1fec5379841585af92a7Dmitri Plotnikov    protected long createAutoAddGroup(Account account) {
231f266e8c568905337960b1fec5379841585af92a7Dmitri Plotnikov        return createGroup(account, "auto", "auto",
232f266e8c568905337960b1fec5379841585af92a7Dmitri Plotnikov                0 /* visible */,  true /* auto-add */, false /* fav */);
233f266e8c568905337960b1fec5379841585af92a7Dmitri Plotnikov    }
234f266e8c568905337960b1fec5379841585af92a7Dmitri Plotnikov
235dd5c25c65f09ada246c826fb6d04f0b6d4cf4388Fred Quintana    protected long createGroup(Account account, String sourceId, String title,
236dd5c25c65f09ada246c826fb6d04f0b6d4cf4388Fred Quintana            int visible, boolean autoAdd, boolean favorite) {
2379261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        ContentValues values = new ContentValues();
2389261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        values.put(Groups.SOURCE_ID, sourceId);
2399261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        values.put(Groups.TITLE, title);
2400be993f8ef0078b9825a5ffe6add08a6786d8dacDmitri Plotnikov        values.put(Groups.GROUP_VISIBLE, visible);
241dd5c25c65f09ada246c826fb6d04f0b6d4cf4388Fred Quintana        values.put(Groups.AUTO_ADD, autoAdd ? 1 : 0);
242dd5c25c65f09ada246c826fb6d04f0b6d4cf4388Fred Quintana        values.put(Groups.FAVORITES, favorite ? 1 : 0);
2439261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        final Uri uri = maybeAddAccountQueryParameters(Groups.CONTENT_URI, account);
2449261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        return ContentUris.parseId(mResolver.insert(uri, values));
2459261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana    }
2469261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana
24789c626eb655440c86a2e5df076e83708c1b32c17Dmitri Plotnikov    protected void createSettings(Account account, String shouldSync, String ungroupedVisible) {
248f9b77edaf5855bf6932fbc4b4b4342273669efefDave Santoro        createSettings(new AccountWithDataSet(account.name, account.type, null),
249f9b77edaf5855bf6932fbc4b4b4342273669efefDave Santoro                shouldSync, ungroupedVisible);
250f9b77edaf5855bf6932fbc4b4b4342273669efefDave Santoro    }
251f9b77edaf5855bf6932fbc4b4b4342273669efefDave Santoro
252f9b77edaf5855bf6932fbc4b4b4342273669efefDave Santoro    protected void createSettings(AccountWithDataSet account, String shouldSync,
253f9b77edaf5855bf6932fbc4b4b4342273669efefDave Santoro            String ungroupedVisible) {
25489c626eb655440c86a2e5df076e83708c1b32c17Dmitri Plotnikov        ContentValues values = new ContentValues();
255f9b77edaf5855bf6932fbc4b4b4342273669efefDave Santoro        values.put(Settings.ACCOUNT_NAME, account.getAccountName());
256f9b77edaf5855bf6932fbc4b4b4342273669efefDave Santoro        values.put(Settings.ACCOUNT_TYPE, account.getAccountType());
257f9b77edaf5855bf6932fbc4b4b4342273669efefDave Santoro        if (account.getDataSet() != null) {
258f9b77edaf5855bf6932fbc4b4b4342273669efefDave Santoro            values.put(Settings.DATA_SET, account.getDataSet());
259f9b77edaf5855bf6932fbc4b4b4342273669efefDave Santoro        }
26089c626eb655440c86a2e5df076e83708c1b32c17Dmitri Plotnikov        values.put(Settings.SHOULD_SYNC, shouldSync);
26189c626eb655440c86a2e5df076e83708c1b32c17Dmitri Plotnikov        values.put(Settings.UNGROUPED_VISIBLE, ungroupedVisible);
26289c626eb655440c86a2e5df076e83708c1b32c17Dmitri Plotnikov        mResolver.insert(Settings.CONTENT_URI, values);
26389c626eb655440c86a2e5df076e83708c1b32c17Dmitri Plotnikov    }
26489c626eb655440c86a2e5df076e83708c1b32c17Dmitri Plotnikov
2655ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov    protected Uri insertStructuredName(long rawContactId, String givenName, String familyName) {
266d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov        ContentValues values = new ContentValues();
267d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov        StringBuilder sb = new StringBuilder();
268d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov        if (givenName != null) {
269d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov            sb.append(givenName);
270d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov        }
271d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov        if (givenName != null && familyName != null) {
272d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov            sb.append(" ");
273d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov        }
274d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov        if (familyName != null) {
275d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov            sb.append(familyName);
276d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov        }
277d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov        values.put(StructuredName.DISPLAY_NAME, sb.toString());
278d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov        values.put(StructuredName.GIVEN_NAME, givenName);
279d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov        values.put(StructuredName.FAMILY_NAME, familyName);
280d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov
2815ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov        return insertStructuredName(rawContactId, values);
2824097855e2d672b3f8e1c5c8a169efb80203bf53eDmitri Plotnikov    }
2834097855e2d672b3f8e1c5c8a169efb80203bf53eDmitri Plotnikov
2845ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov    protected Uri insertStructuredName(long rawContactId, ContentValues values) {
2855ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov        values.put(Data.RAW_CONTACT_ID, rawContactId);
2864097855e2d672b3f8e1c5c8a169efb80203bf53eDmitri Plotnikov        values.put(Data.MIMETYPE, StructuredName.CONTENT_ITEM_TYPE);
287d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov        Uri resultUri = mResolver.insert(Data.CONTENT_URI, values);
288d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov        return resultUri;
289d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov    }
290d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov
291a5d05d90333a70d471d78e82caeb5cfa2e4d4c59Tadashi G. Takaoka    protected Uri insertOrganization(long rawContactId, ContentValues values) {
292a5d05d90333a70d471d78e82caeb5cfa2e4d4c59Tadashi G. Takaoka        return insertOrganization(rawContactId, values, false);
29301911fa9cfa21f198fd767eedde072acbb879f28Dmitri Plotnikov    }
29401911fa9cfa21f198fd767eedde072acbb879f28Dmitri Plotnikov
295a5d05d90333a70d471d78e82caeb5cfa2e4d4c59Tadashi G. Takaoka    protected Uri insertOrganization(long rawContactId, ContentValues values, boolean primary) {
29601911fa9cfa21f198fd767eedde072acbb879f28Dmitri Plotnikov        values.put(Data.RAW_CONTACT_ID, rawContactId);
29701911fa9cfa21f198fd767eedde072acbb879f28Dmitri Plotnikov        values.put(Data.MIMETYPE, Organization.CONTENT_ITEM_TYPE);
29801911fa9cfa21f198fd767eedde072acbb879f28Dmitri Plotnikov        values.put(Organization.TYPE, Organization.TYPE_WORK);
29901911fa9cfa21f198fd767eedde072acbb879f28Dmitri Plotnikov        if (primary) {
3000265a180cf027d149f11f8750652ac67ea08ca24Dmitri Plotnikov            values.put(Data.IS_PRIMARY, 1);
30101911fa9cfa21f198fd767eedde072acbb879f28Dmitri Plotnikov        }
30201911fa9cfa21f198fd767eedde072acbb879f28Dmitri Plotnikov
30301911fa9cfa21f198fd767eedde072acbb879f28Dmitri Plotnikov        Uri resultUri = mResolver.insert(Data.CONTENT_URI, values);
30401911fa9cfa21f198fd767eedde072acbb879f28Dmitri Plotnikov        return resultUri;
30501911fa9cfa21f198fd767eedde072acbb879f28Dmitri Plotnikov    }
30601911fa9cfa21f198fd767eedde072acbb879f28Dmitri Plotnikov
3075ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov    protected Uri insertPhoneNumber(long rawContactId, String phoneNumber) {
30825abcf949c0dd826a770b437489b83de48975ceaDmitri Plotnikov        return insertPhoneNumber(rawContactId, phoneNumber, false);
30925abcf949c0dd826a770b437489b83de48975ceaDmitri Plotnikov    }
31025abcf949c0dd826a770b437489b83de48975ceaDmitri Plotnikov
31125abcf949c0dd826a770b437489b83de48975ceaDmitri Plotnikov    protected Uri insertPhoneNumber(long rawContactId, String phoneNumber, boolean primary) {
31258567abca253f1efa2db5c39e17e42dca589e916Daisuke Miyakawa        return insertPhoneNumber(rawContactId, phoneNumber, primary, Phone.TYPE_HOME);
31358567abca253f1efa2db5c39e17e42dca589e916Daisuke Miyakawa    }
31458567abca253f1efa2db5c39e17e42dca589e916Daisuke Miyakawa
31558567abca253f1efa2db5c39e17e42dca589e916Daisuke Miyakawa    protected Uri insertPhoneNumber(long rawContactId, String phoneNumber, boolean primary,
31658567abca253f1efa2db5c39e17e42dca589e916Daisuke Miyakawa            int type) {
317bf659107617a6291ba8bfeebc3f2e50138075ab5Dmitri Plotnikov        ContentValues values = new ContentValues();
3185ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov        values.put(Data.RAW_CONTACT_ID, rawContactId);
319bf659107617a6291ba8bfeebc3f2e50138075ab5Dmitri Plotnikov        values.put(Data.MIMETYPE, Phone.CONTENT_ITEM_TYPE);
320bf659107617a6291ba8bfeebc3f2e50138075ab5Dmitri Plotnikov        values.put(Phone.NUMBER, phoneNumber);
32158567abca253f1efa2db5c39e17e42dca589e916Daisuke Miyakawa        values.put(Phone.TYPE, type);
32225abcf949c0dd826a770b437489b83de48975ceaDmitri Plotnikov        if (primary) {
3230265a180cf027d149f11f8750652ac67ea08ca24Dmitri Plotnikov            values.put(Data.IS_PRIMARY, 1);
32425abcf949c0dd826a770b437489b83de48975ceaDmitri Plotnikov        }
325bf659107617a6291ba8bfeebc3f2e50138075ab5Dmitri Plotnikov
326bf659107617a6291ba8bfeebc3f2e50138075ab5Dmitri Plotnikov        Uri resultUri = mResolver.insert(Data.CONTENT_URI, values);
327bf659107617a6291ba8bfeebc3f2e50138075ab5Dmitri Plotnikov        return resultUri;
328bf659107617a6291ba8bfeebc3f2e50138075ab5Dmitri Plotnikov    }
329bf659107617a6291ba8bfeebc3f2e50138075ab5Dmitri Plotnikov
3305ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov    protected Uri insertEmail(long rawContactId, String email) {
33125abcf949c0dd826a770b437489b83de48975ceaDmitri Plotnikov        return insertEmail(rawContactId, email, false);
33225abcf949c0dd826a770b437489b83de48975ceaDmitri Plotnikov    }
33325abcf949c0dd826a770b437489b83de48975ceaDmitri Plotnikov
33425abcf949c0dd826a770b437489b83de48975ceaDmitri Plotnikov    protected Uri insertEmail(long rawContactId, String email, boolean primary) {
335916f2d7104bfba857412a66b40ed60fea6546222Dmitri Plotnikov        return insertEmail(rawContactId, email, primary, Email.TYPE_HOME, null);
336916f2d7104bfba857412a66b40ed60fea6546222Dmitri Plotnikov    }
337916f2d7104bfba857412a66b40ed60fea6546222Dmitri Plotnikov
338916f2d7104bfba857412a66b40ed60fea6546222Dmitri Plotnikov    protected Uri insertEmail(long rawContactId, String email, boolean primary, int type,
339916f2d7104bfba857412a66b40ed60fea6546222Dmitri Plotnikov            String label) {
340a5ad551e1753086825499f1aeb6415bb986f3588Dmitri Plotnikov        ContentValues values = new ContentValues();
3415ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov        values.put(Data.RAW_CONTACT_ID, rawContactId);
342a5ad551e1753086825499f1aeb6415bb986f3588Dmitri Plotnikov        values.put(Data.MIMETYPE, Email.CONTENT_ITEM_TYPE);
343a5ad551e1753086825499f1aeb6415bb986f3588Dmitri Plotnikov        values.put(Email.DATA, email);
344916f2d7104bfba857412a66b40ed60fea6546222Dmitri Plotnikov        values.put(Email.TYPE, type);
345916f2d7104bfba857412a66b40ed60fea6546222Dmitri Plotnikov        values.put(Email.LABEL, label);
34625abcf949c0dd826a770b437489b83de48975ceaDmitri Plotnikov        if (primary) {
347916f2d7104bfba857412a66b40ed60fea6546222Dmitri Plotnikov            values.put(Data.IS_PRIMARY, 1);
34825abcf949c0dd826a770b437489b83de48975ceaDmitri Plotnikov        }
349e432023d408c461295e53c0593fabb2b4c17aeb3Daisuke Miyakawa
350e432023d408c461295e53c0593fabb2b4c17aeb3Daisuke Miyakawa        Uri resultUri = mResolver.insert(Data.CONTENT_URI, values);
351e432023d408c461295e53c0593fabb2b4c17aeb3Daisuke Miyakawa        return resultUri;
352e432023d408c461295e53c0593fabb2b4c17aeb3Daisuke Miyakawa    }
353e432023d408c461295e53c0593fabb2b4c17aeb3Daisuke Miyakawa
354e432023d408c461295e53c0593fabb2b4c17aeb3Daisuke Miyakawa    protected Uri insertSipAddress(long rawContactId, String sipAddress) {
355e432023d408c461295e53c0593fabb2b4c17aeb3Daisuke Miyakawa        return insertSipAddress(rawContactId, sipAddress, false);
356e432023d408c461295e53c0593fabb2b4c17aeb3Daisuke Miyakawa    }
357e432023d408c461295e53c0593fabb2b4c17aeb3Daisuke Miyakawa
358e432023d408c461295e53c0593fabb2b4c17aeb3Daisuke Miyakawa    protected Uri insertSipAddress(long rawContactId, String sipAddress, boolean primary) {
359e432023d408c461295e53c0593fabb2b4c17aeb3Daisuke Miyakawa        ContentValues values = new ContentValues();
360e432023d408c461295e53c0593fabb2b4c17aeb3Daisuke Miyakawa        values.put(Data.RAW_CONTACT_ID, rawContactId);
361e432023d408c461295e53c0593fabb2b4c17aeb3Daisuke Miyakawa        values.put(Data.MIMETYPE, SipAddress.CONTENT_ITEM_TYPE);
362e432023d408c461295e53c0593fabb2b4c17aeb3Daisuke Miyakawa        values.put(SipAddress.SIP_ADDRESS, sipAddress);
363e432023d408c461295e53c0593fabb2b4c17aeb3Daisuke Miyakawa        if (primary) {
364e432023d408c461295e53c0593fabb2b4c17aeb3Daisuke Miyakawa            values.put(Data.IS_PRIMARY, 1);
365e432023d408c461295e53c0593fabb2b4c17aeb3Daisuke Miyakawa        }
366a5ad551e1753086825499f1aeb6415bb986f3588Dmitri Plotnikov
367a5ad551e1753086825499f1aeb6415bb986f3588Dmitri Plotnikov        Uri resultUri = mResolver.insert(Data.CONTENT_URI, values);
368a5ad551e1753086825499f1aeb6415bb986f3588Dmitri Plotnikov        return resultUri;
369a5ad551e1753086825499f1aeb6415bb986f3588Dmitri Plotnikov    }
370a5ad551e1753086825499f1aeb6415bb986f3588Dmitri Plotnikov
3715ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov    protected Uri insertNickname(long rawContactId, String nickname) {
372a5ad551e1753086825499f1aeb6415bb986f3588Dmitri Plotnikov        ContentValues values = new ContentValues();
3735ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov        values.put(Data.RAW_CONTACT_ID, rawContactId);
374a5ad551e1753086825499f1aeb6415bb986f3588Dmitri Plotnikov        values.put(Data.MIMETYPE, Nickname.CONTENT_ITEM_TYPE);
375a5ad551e1753086825499f1aeb6415bb986f3588Dmitri Plotnikov        values.put(Nickname.NAME, nickname);
3763cebbf7141252768d3e272e049e9c5b0cb9d710eDmitri Plotnikov        values.put(Nickname.TYPE, Nickname.TYPE_OTHER_NAME);
377a5ad551e1753086825499f1aeb6415bb986f3588Dmitri Plotnikov
378a5ad551e1753086825499f1aeb6415bb986f3588Dmitri Plotnikov        Uri resultUri = mResolver.insert(Data.CONTENT_URI, values);
379a5ad551e1753086825499f1aeb6415bb986f3588Dmitri Plotnikov        return resultUri;
380a5ad551e1753086825499f1aeb6415bb986f3588Dmitri Plotnikov    }
381a5ad551e1753086825499f1aeb6415bb986f3588Dmitri Plotnikov
3824a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov    protected Uri insertPostalAddress(long rawContactId, String formattedAddress) {
3834a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov        ContentValues values = new ContentValues();
3844a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov        values.put(Data.RAW_CONTACT_ID, rawContactId);
3854a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov        values.put(Data.MIMETYPE, StructuredPostal.CONTENT_ITEM_TYPE);
3864a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov        values.put(StructuredPostal.FORMATTED_ADDRESS, formattedAddress);
3874a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov
3884a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov        Uri resultUri = mResolver.insert(Data.CONTENT_URI, values);
3894a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov        return resultUri;
3904a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov    }
3914a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov
392eeeed5669d98897501bf2b18c88579c7effd0955Dmitri Plotnikov    protected Uri insertPostalAddress(long rawContactId, ContentValues values) {
393eeeed5669d98897501bf2b18c88579c7effd0955Dmitri Plotnikov        values.put(Data.RAW_CONTACT_ID, rawContactId);
394eeeed5669d98897501bf2b18c88579c7effd0955Dmitri Plotnikov        values.put(Data.MIMETYPE, StructuredPostal.CONTENT_ITEM_TYPE);
395eeeed5669d98897501bf2b18c88579c7effd0955Dmitri Plotnikov        Uri resultUri = mResolver.insert(Data.CONTENT_URI, values);
396eeeed5669d98897501bf2b18c88579c7effd0955Dmitri Plotnikov        return resultUri;
397eeeed5669d98897501bf2b18c88579c7effd0955Dmitri Plotnikov    }
398eeeed5669d98897501bf2b18c88579c7effd0955Dmitri Plotnikov
3995ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov    protected Uri insertPhoto(long rawContactId) {
400ae6ca1f34cf5458d79ec803411d4308879a91e92Evan Millar        ContentValues values = new ContentValues();
4015ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov        values.put(Data.RAW_CONTACT_ID, rawContactId);
402ae6ca1f34cf5458d79ec803411d4308879a91e92Evan Millar        values.put(Data.MIMETYPE, Photo.CONTENT_ITEM_TYPE);
4032482dd0309794d57233d0af37a7c12fc647e7bf9Dmitri Plotnikov        values.put(Photo.PHOTO, loadTestPhoto());
404ae6ca1f34cf5458d79ec803411d4308879a91e92Evan Millar        Uri resultUri = mResolver.insert(Data.CONTENT_URI, values);
405ae6ca1f34cf5458d79ec803411d4308879a91e92Evan Millar        return resultUri;
406ae6ca1f34cf5458d79ec803411d4308879a91e92Evan Millar    }
407ae6ca1f34cf5458d79ec803411d4308879a91e92Evan Millar
408f547fd54d7933e1c03af4a8dc10560c71c38f6b8Dave Santoro    protected Uri insertPhoto(long rawContactId, int resourceId) {
409f547fd54d7933e1c03af4a8dc10560c71c38f6b8Dave Santoro        ContentValues values = new ContentValues();
410f547fd54d7933e1c03af4a8dc10560c71c38f6b8Dave Santoro        values.put(Data.RAW_CONTACT_ID, rawContactId);
411f547fd54d7933e1c03af4a8dc10560c71c38f6b8Dave Santoro        values.put(Data.MIMETYPE, Photo.CONTENT_ITEM_TYPE);
412f547fd54d7933e1c03af4a8dc10560c71c38f6b8Dave Santoro        values.put(Photo.PHOTO, loadPhotoFromResource(resourceId, PhotoSize.ORIGINAL));
413f547fd54d7933e1c03af4a8dc10560c71c38f6b8Dave Santoro        Uri resultUri = mResolver.insert(Data.CONTENT_URI, values);
414f547fd54d7933e1c03af4a8dc10560c71c38f6b8Dave Santoro        return resultUri;
415f547fd54d7933e1c03af4a8dc10560c71c38f6b8Dave Santoro    }
416f547fd54d7933e1c03af4a8dc10560c71c38f6b8Dave Santoro
4175ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov    protected Uri insertGroupMembership(long rawContactId, String sourceId) {
4189261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        ContentValues values = new ContentValues();
4195ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov        values.put(Data.RAW_CONTACT_ID, rawContactId);
4209261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        values.put(Data.MIMETYPE, GroupMembership.CONTENT_ITEM_TYPE);
4219261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        values.put(GroupMembership.GROUP_SOURCE_ID, sourceId);
4229261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        return mResolver.insert(Data.CONTENT_URI, values);
4239261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana    }
4249261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana
4255ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov    protected Uri insertGroupMembership(long rawContactId, Long groupId) {
4269261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        ContentValues values = new ContentValues();
4275ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov        values.put(Data.RAW_CONTACT_ID, rawContactId);
4289261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        values.put(Data.MIMETYPE, GroupMembership.CONTENT_ITEM_TYPE);
4299261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        values.put(GroupMembership.GROUP_ROW_ID, groupId);
4309261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        return mResolver.insert(Data.CONTENT_URI, values);
4319261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana    }
4329261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana
433f266e8c568905337960b1fec5379841585af92a7Dmitri Plotnikov    public void removeGroupMemberships(long rawContactId) {
434f266e8c568905337960b1fec5379841585af92a7Dmitri Plotnikov        mResolver.delete(Data.CONTENT_URI,
435f266e8c568905337960b1fec5379841585af92a7Dmitri Plotnikov                Data.MIMETYPE + "=? AND " + GroupMembership.RAW_CONTACT_ID + "=?",
436f266e8c568905337960b1fec5379841585af92a7Dmitri Plotnikov                new String[] { GroupMembership.CONTENT_ITEM_TYPE, String.valueOf(rawContactId) });
437f266e8c568905337960b1fec5379841585af92a7Dmitri Plotnikov    }
438f266e8c568905337960b1fec5379841585af92a7Dmitri Plotnikov
43982bd858c9911dfbd8dca52dc276333768b0a429eDmitri Plotnikov    protected Uri insertStatusUpdate(int protocol, String customProtocol, String handle,
440aabcd1d34a71ad06ee0a9395331540484f1ceb17Vasu Nori            int presence, String status, int chatMode) {
4415d0a768b56ed4bd0dfef81b8389247ba74766659Dave Santoro        return insertStatusUpdate(protocol, customProtocol, handle, presence, status, chatMode,
4425d0a768b56ed4bd0dfef81b8389247ba74766659Dave Santoro                false);
443a23cd5b6f478f6c9dda54173e84bd0098b9f3364Dmitri Plotnikov    }
444a23cd5b6f478f6c9dda54173e84bd0098b9f3364Dmitri Plotnikov
44582bd858c9911dfbd8dca52dc276333768b0a429eDmitri Plotnikov    protected Uri insertStatusUpdate(int protocol, String customProtocol, String handle,
4465d0a768b56ed4bd0dfef81b8389247ba74766659Dave Santoro            int presence, String status, int chatMode, boolean isUserProfile) {
4475d0a768b56ed4bd0dfef81b8389247ba74766659Dave Santoro        return insertStatusUpdate(protocol, customProtocol, handle, presence, status, 0, chatMode,
4485d0a768b56ed4bd0dfef81b8389247ba74766659Dave Santoro                isUserProfile);
4495d0a768b56ed4bd0dfef81b8389247ba74766659Dave Santoro    }
4505d0a768b56ed4bd0dfef81b8389247ba74766659Dave Santoro
4515d0a768b56ed4bd0dfef81b8389247ba74766659Dave Santoro    protected Uri insertStatusUpdate(int protocol, String customProtocol, String handle,
4525d0a768b56ed4bd0dfef81b8389247ba74766659Dave Santoro            int presence, String status, long timestamp, int chatMode, boolean isUserProfile) {
453bc5c799a52b5bde2f273efd118ebe2228c3d8f15Evan Millar        ContentValues values = new ContentValues();
45482bd858c9911dfbd8dca52dc276333768b0a429eDmitri Plotnikov        values.put(StatusUpdates.PROTOCOL, protocol);
45582bd858c9911dfbd8dca52dc276333768b0a429eDmitri Plotnikov        values.put(StatusUpdates.CUSTOM_PROTOCOL, customProtocol);
45682bd858c9911dfbd8dca52dc276333768b0a429eDmitri Plotnikov        values.put(StatusUpdates.IM_HANDLE, handle);
4575d0a768b56ed4bd0dfef81b8389247ba74766659Dave Santoro        return insertStatusUpdate(values, presence, status, timestamp, chatMode, isUserProfile);
458f4015ab9ab7c26b766b5331fbf6655b8c54877eaDmitri Plotnikov    }
459f4015ab9ab7c26b766b5331fbf6655b8c54877eaDmitri Plotnikov
460f4015ab9ab7c26b766b5331fbf6655b8c54877eaDmitri Plotnikov    protected Uri insertStatusUpdate(
461f4015ab9ab7c26b766b5331fbf6655b8c54877eaDmitri Plotnikov            long dataId, int presence, String status, long timestamp, int chatMode) {
4625d0a768b56ed4bd0dfef81b8389247ba74766659Dave Santoro        return insertStatusUpdate(dataId, presence, status, timestamp, chatMode, false);
4635d0a768b56ed4bd0dfef81b8389247ba74766659Dave Santoro    }
4645d0a768b56ed4bd0dfef81b8389247ba74766659Dave Santoro
4655d0a768b56ed4bd0dfef81b8389247ba74766659Dave Santoro    protected Uri insertStatusUpdate(
4665d0a768b56ed4bd0dfef81b8389247ba74766659Dave Santoro            long dataId, int presence, String status, long timestamp, int chatMode,
4675d0a768b56ed4bd0dfef81b8389247ba74766659Dave Santoro            boolean isUserProfile) {
468f4015ab9ab7c26b766b5331fbf6655b8c54877eaDmitri Plotnikov        ContentValues values = new ContentValues();
469f4015ab9ab7c26b766b5331fbf6655b8c54877eaDmitri Plotnikov        values.put(StatusUpdates.DATA_ID, dataId);
4705d0a768b56ed4bd0dfef81b8389247ba74766659Dave Santoro        return insertStatusUpdate(values, presence, status, timestamp, chatMode, isUserProfile);
471f4015ab9ab7c26b766b5331fbf6655b8c54877eaDmitri Plotnikov    }
472f4015ab9ab7c26b766b5331fbf6655b8c54877eaDmitri Plotnikov
473f4015ab9ab7c26b766b5331fbf6655b8c54877eaDmitri Plotnikov    private Uri insertStatusUpdate(
4745d0a768b56ed4bd0dfef81b8389247ba74766659Dave Santoro            ContentValues values, int presence, String status, long timestamp, int chatMode,
4755d0a768b56ed4bd0dfef81b8389247ba74766659Dave Santoro            boolean isUserProfile) {
476a23cd5b6f478f6c9dda54173e84bd0098b9f3364Dmitri Plotnikov        if (presence != 0) {
47782bd858c9911dfbd8dca52dc276333768b0a429eDmitri Plotnikov            values.put(StatusUpdates.PRESENCE, presence);
478aabcd1d34a71ad06ee0a9395331540484f1ceb17Vasu Nori            values.put(StatusUpdates.CHAT_CAPABILITY, chatMode);
479a23cd5b6f478f6c9dda54173e84bd0098b9f3364Dmitri Plotnikov        }
480a23cd5b6f478f6c9dda54173e84bd0098b9f3364Dmitri Plotnikov        if (status != null) {
48182bd858c9911dfbd8dca52dc276333768b0a429eDmitri Plotnikov            values.put(StatusUpdates.STATUS, status);
482a23cd5b6f478f6c9dda54173e84bd0098b9f3364Dmitri Plotnikov        }
483a23cd5b6f478f6c9dda54173e84bd0098b9f3364Dmitri Plotnikov        if (timestamp != 0) {
48482bd858c9911dfbd8dca52dc276333768b0a429eDmitri Plotnikov            values.put(StatusUpdates.STATUS_TIMESTAMP, timestamp);
485a23cd5b6f478f6c9dda54173e84bd0098b9f3364Dmitri Plotnikov        }
486bc5c799a52b5bde2f273efd118ebe2228c3d8f15Evan Millar
4875d0a768b56ed4bd0dfef81b8389247ba74766659Dave Santoro        Uri insertUri = isUserProfile
4885d0a768b56ed4bd0dfef81b8389247ba74766659Dave Santoro                ? StatusUpdates.PROFILE_CONTENT_URI
4895d0a768b56ed4bd0dfef81b8389247ba74766659Dave Santoro                : StatusUpdates.CONTENT_URI;
4905d0a768b56ed4bd0dfef81b8389247ba74766659Dave Santoro        Uri resultUri = mResolver.insert(insertUri, values);
491bc5c799a52b5bde2f273efd118ebe2228c3d8f15Evan Millar        return resultUri;
492bc5c799a52b5bde2f273efd118ebe2228c3d8f15Evan Millar    }
493bc5c799a52b5bde2f273efd118ebe2228c3d8f15Evan Millar
4943b505de6c622d20d40b85b361c1437a89aef82deDaniel Lehmann    protected Uri insertStreamItem(long rawContactId, ContentValues values, Account account) {
4953b505de6c622d20d40b85b361c1437a89aef82deDaniel Lehmann        return mResolver.insert(
4963b505de6c622d20d40b85b361c1437a89aef82deDaniel Lehmann                maybeAddAccountQueryParameters(
4973b505de6c622d20d40b85b361c1437a89aef82deDaniel Lehmann                        Uri.withAppendedPath(
4983b505de6c622d20d40b85b361c1437a89aef82deDaniel Lehmann                                ContentUris.withAppendedId(RawContacts.CONTENT_URI, rawContactId),
4993b505de6c622d20d40b85b361c1437a89aef82deDaniel Lehmann                                RawContacts.StreamItems.CONTENT_DIRECTORY),
5003b505de6c622d20d40b85b361c1437a89aef82deDaniel Lehmann                        account),
5013b505de6c622d20d40b85b361c1437a89aef82deDaniel Lehmann                values);
5023b505de6c622d20d40b85b361c1437a89aef82deDaniel Lehmann    }
5033b505de6c622d20d40b85b361c1437a89aef82deDaniel Lehmann
5043b505de6c622d20d40b85b361c1437a89aef82deDaniel Lehmann    protected Uri insertStreamItemPhoto(long streamItemId, ContentValues values, Account account) {
5053b505de6c622d20d40b85b361c1437a89aef82deDaniel Lehmann        return mResolver.insert(
5063b505de6c622d20d40b85b361c1437a89aef82deDaniel Lehmann                maybeAddAccountQueryParameters(
5073b505de6c622d20d40b85b361c1437a89aef82deDaniel Lehmann                        Uri.withAppendedPath(
5083b505de6c622d20d40b85b361c1437a89aef82deDaniel Lehmann                                ContentUris.withAppendedId(StreamItems.CONTENT_URI, streamItemId),
5093b505de6c622d20d40b85b361c1437a89aef82deDaniel Lehmann                                StreamItems.StreamItemPhotos.CONTENT_DIRECTORY),
5103b505de6c622d20d40b85b361c1437a89aef82deDaniel Lehmann                        account),
5113b505de6c622d20d40b85b361c1437a89aef82deDaniel Lehmann                values);
5123b505de6c622d20d40b85b361c1437a89aef82deDaniel Lehmann    }
5133b505de6c622d20d40b85b361c1437a89aef82deDaniel Lehmann
5144dcd106ccc27dbbfaae86baf0cd57beb42c27cccDmitri Plotnikov    protected Uri insertImHandle(long rawContactId, int protocol, String customProtocol,
5154dcd106ccc27dbbfaae86baf0cd57beb42c27cccDmitri Plotnikov            String handle) {
516bc5c799a52b5bde2f273efd118ebe2228c3d8f15Evan Millar        ContentValues values = new ContentValues();
5175ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov        values.put(Data.RAW_CONTACT_ID, rawContactId);
518bc5c799a52b5bde2f273efd118ebe2228c3d8f15Evan Millar        values.put(Data.MIMETYPE, Im.CONTENT_ITEM_TYPE);
519bc5c799a52b5bde2f273efd118ebe2228c3d8f15Evan Millar        values.put(Im.PROTOCOL, protocol);
5204dcd106ccc27dbbfaae86baf0cd57beb42c27cccDmitri Plotnikov        values.put(Im.CUSTOM_PROTOCOL, customProtocol);
521bc5c799a52b5bde2f273efd118ebe2228c3d8f15Evan Millar        values.put(Im.DATA, handle);
5223cebbf7141252768d3e272e049e9c5b0cb9d710eDmitri Plotnikov        values.put(Im.TYPE, Im.TYPE_HOME);
523bc5c799a52b5bde2f273efd118ebe2228c3d8f15Evan Millar
524bc5c799a52b5bde2f273efd118ebe2228c3d8f15Evan Millar        Uri resultUri = mResolver.insert(Data.CONTENT_URI, values);
525bc5c799a52b5bde2f273efd118ebe2228c3d8f15Evan Millar        return resultUri;
526bc5c799a52b5bde2f273efd118ebe2228c3d8f15Evan Millar    }
527bc5c799a52b5bde2f273efd118ebe2228c3d8f15Evan Millar
5286d9702cec82fd27a1c3093c64df9dcc22744899aDmitri Plotnikov    protected Uri insertEvent(long rawContactId, int type, String date) {
5296d9702cec82fd27a1c3093c64df9dcc22744899aDmitri Plotnikov        ContentValues values = new ContentValues();
5306d9702cec82fd27a1c3093c64df9dcc22744899aDmitri Plotnikov        values.put(Data.RAW_CONTACT_ID, rawContactId);
5316d9702cec82fd27a1c3093c64df9dcc22744899aDmitri Plotnikov        values.put(Data.MIMETYPE, Event.CONTENT_ITEM_TYPE);
5326d9702cec82fd27a1c3093c64df9dcc22744899aDmitri Plotnikov        values.put(Event.TYPE, type);
5336d9702cec82fd27a1c3093c64df9dcc22744899aDmitri Plotnikov        values.put(Event.START_DATE, date);
5346d9702cec82fd27a1c3093c64df9dcc22744899aDmitri Plotnikov        Uri resultUri = mResolver.insert(Data.CONTENT_URI, values);
5356d9702cec82fd27a1c3093c64df9dcc22744899aDmitri Plotnikov        return resultUri;
5366d9702cec82fd27a1c3093c64df9dcc22744899aDmitri Plotnikov    }
5376d9702cec82fd27a1c3093c64df9dcc22744899aDmitri Plotnikov
5386d9702cec82fd27a1c3093c64df9dcc22744899aDmitri Plotnikov    protected Uri insertNote(long rawContactId, String note) {
5396d9702cec82fd27a1c3093c64df9dcc22744899aDmitri Plotnikov        ContentValues values = new ContentValues();
5406d9702cec82fd27a1c3093c64df9dcc22744899aDmitri Plotnikov        values.put(Data.RAW_CONTACT_ID, rawContactId);
5416d9702cec82fd27a1c3093c64df9dcc22744899aDmitri Plotnikov        values.put(Data.MIMETYPE, Note.CONTENT_ITEM_TYPE);
5426d9702cec82fd27a1c3093c64df9dcc22744899aDmitri Plotnikov        values.put(Note.NOTE, note);
5436d9702cec82fd27a1c3093c64df9dcc22744899aDmitri Plotnikov        Uri resultUri = mResolver.insert(Data.CONTENT_URI, values);
5446d9702cec82fd27a1c3093c64df9dcc22744899aDmitri Plotnikov        return resultUri;
5456d9702cec82fd27a1c3093c64df9dcc22744899aDmitri Plotnikov    }
5466d9702cec82fd27a1c3093c64df9dcc22744899aDmitri Plotnikov
5470992b9d4969ed0eee6e879db94292b635229e2b7Makoto Onuki    protected Uri insertIdentity(long rawContactId, String identity, String namespace) {
5480992b9d4969ed0eee6e879db94292b635229e2b7Makoto Onuki        ContentValues values = new ContentValues();
5490992b9d4969ed0eee6e879db94292b635229e2b7Makoto Onuki        values.put(Data.RAW_CONTACT_ID, rawContactId);
5500992b9d4969ed0eee6e879db94292b635229e2b7Makoto Onuki        values.put(Data.MIMETYPE, Identity.CONTENT_ITEM_TYPE);
5510992b9d4969ed0eee6e879db94292b635229e2b7Makoto Onuki        values.put(Identity.NAMESPACE, namespace);
5520992b9d4969ed0eee6e879db94292b635229e2b7Makoto Onuki        values.put(Identity.IDENTITY, identity);
5530992b9d4969ed0eee6e879db94292b635229e2b7Makoto Onuki
5540992b9d4969ed0eee6e879db94292b635229e2b7Makoto Onuki        Uri resultUri = mResolver.insert(Data.CONTENT_URI, values);
5550992b9d4969ed0eee6e879db94292b635229e2b7Makoto Onuki        return resultUri;
5560992b9d4969ed0eee6e879db94292b635229e2b7Makoto Onuki    }
5570992b9d4969ed0eee6e879db94292b635229e2b7Makoto Onuki
558767e109d6f08749b9ed202c0b71f3459eaae2115Dmitri Plotnikov    protected void setContactAccount(long rawContactId, String accountType, String accountName) {
559ae6ca1f34cf5458d79ec803411d4308879a91e92Evan Millar        ContentValues values = new ContentValues();
560767e109d6f08749b9ed202c0b71f3459eaae2115Dmitri Plotnikov        values.put(RawContacts.ACCOUNT_TYPE, accountType);
5616cffee46a1334d2b3ed19f436b27638451541044Dmitri Plotnikov        values.put(RawContacts.ACCOUNT_NAME, accountName);
562ae6ca1f34cf5458d79ec803411d4308879a91e92Evan Millar
563ae6ca1f34cf5458d79ec803411d4308879a91e92Evan Millar        mResolver.update(ContentUris.withAppendedId(
5645ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov                RawContacts.CONTENT_URI, rawContactId), values, null, null);
565ae6ca1f34cf5458d79ec803411d4308879a91e92Evan Millar    }
566ae6ca1f34cf5458d79ec803411d4308879a91e92Evan Millar
5670c0adda32be5de3acf392ab715cff468b6b340f8Dmitri Plotnikov    protected void setAggregationException(int type, long rawContactId1, long rawContactId2) {
568d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov        ContentValues values = new ContentValues();
5690c0adda32be5de3acf392ab715cff468b6b340f8Dmitri Plotnikov        values.put(AggregationExceptions.RAW_CONTACT_ID1, rawContactId1);
5700c0adda32be5de3acf392ab715cff468b6b340f8Dmitri Plotnikov        values.put(AggregationExceptions.RAW_CONTACT_ID2, rawContactId2);
571d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov        values.put(AggregationExceptions.TYPE, type);
5723d8b043c3341a5b6c2e781b7eba9767d5cd13267Dmitri Plotnikov        assertEquals(1, mResolver.update(AggregationExceptions.CONTENT_URI, values, null, null));
573d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov    }
574d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov
57580628945e7e41bb9363c2fbbd2938890b9217792Makoto Onuki    protected void markInvisible(long contactId) {
57680628945e7e41bb9363c2fbbd2938890b9217792Makoto Onuki        // There's no api for this, so we just tweak the DB directly.
57780628945e7e41bb9363c2fbbd2938890b9217792Makoto Onuki        SQLiteDatabase db = ((ContactsProvider2) getProvider()).getDatabaseHelper()
57880628945e7e41bb9363c2fbbd2938890b9217792Makoto Onuki                .getWritableDatabase();
57980628945e7e41bb9363c2fbbd2938890b9217792Makoto Onuki        db.execSQL("DELETE FROM " + Tables.DEFAULT_DIRECTORY +
58080628945e7e41bb9363c2fbbd2938890b9217792Makoto Onuki                " WHERE " + BaseColumns._ID + "=" + contactId);
58180628945e7e41bb9363c2fbbd2938890b9217792Makoto Onuki    }
58280628945e7e41bb9363c2fbbd2938890b9217792Makoto Onuki
583d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov    protected Cursor queryRawContact(long rawContactId) {
5840c0adda32be5de3acf392ab715cff468b6b340f8Dmitri Plotnikov        return mResolver.query(ContentUris.withAppendedId(RawContacts.CONTENT_URI, rawContactId),
5850c0adda32be5de3acf392ab715cff468b6b340f8Dmitri Plotnikov                null, null, null, null);
586d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov    }
587d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov
588d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov    protected Cursor queryContact(long contactId) {
589d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov        return mResolver.query(ContentUris.withAppendedId(Contacts.CONTENT_URI, contactId),
590d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov                null, null, null, null);
591d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov    }
592d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov
593af088aeb51685eed17580edc04b495d12232ecf9Dmitri Plotnikov    protected Cursor queryContact(long contactId, String[] projection) {
594af088aeb51685eed17580edc04b495d12232ecf9Dmitri Plotnikov        return mResolver.query(ContentUris.withAppendedId(Contacts.CONTENT_URI, contactId),
595af088aeb51685eed17580edc04b495d12232ecf9Dmitri Plotnikov                projection, null, null, null);
596bc5c799a52b5bde2f273efd118ebe2228c3d8f15Evan Millar    }
597bc5c799a52b5bde2f273efd118ebe2228c3d8f15Evan Millar
598f4015ab9ab7c26b766b5331fbf6655b8c54877eaDmitri Plotnikov    protected Uri getContactUriForRawContact(long rawContactId) {
599f4015ab9ab7c26b766b5331fbf6655b8c54877eaDmitri Plotnikov        return ContentUris.withAppendedId(Contacts.CONTENT_URI, queryContactId(rawContactId));
600f4015ab9ab7c26b766b5331fbf6655b8c54877eaDmitri Plotnikov    }
601f4015ab9ab7c26b766b5331fbf6655b8c54877eaDmitri Plotnikov
602d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov    protected long queryContactId(long rawContactId) {
603d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov        Cursor c = queryRawContact(rawContactId);
604d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov        assertTrue(c.moveToFirst());
605d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov        long contactId = c.getLong(c.getColumnIndex(RawContacts.CONTACT_ID));
606d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov        c.close();
607d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov        return contactId;
608d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov    }
609d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov
610d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov    protected long queryPhotoId(long contactId) {
611d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov        Cursor c = queryContact(contactId);
612ae6ca1f34cf5458d79ec803411d4308879a91e92Evan Millar        assertTrue(c.moveToFirst());
613d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov        long photoId = c.getInt(c.getColumnIndex(Contacts.PHOTO_ID));
614ae6ca1f34cf5458d79ec803411d4308879a91e92Evan Millar        c.close();
615ae6ca1f34cf5458d79ec803411d4308879a91e92Evan Millar        return photoId;
616ae6ca1f34cf5458d79ec803411d4308879a91e92Evan Millar    }
617ae6ca1f34cf5458d79ec803411d4308879a91e92Evan Millar
61887614d7d293b1519dc1f0f403fd59c8bf4d8a347Dave Santoro    protected long queryPhotoFileId(long contactId) {
61987614d7d293b1519dc1f0f403fd59c8bf4d8a347Dave Santoro        return getStoredLongValue(ContentUris.withAppendedId(Contacts.CONTENT_URI, contactId),
62087614d7d293b1519dc1f0f403fd59c8bf4d8a347Dave Santoro                Contacts.PHOTO_FILE_ID);
62187614d7d293b1519dc1f0f403fd59c8bf4d8a347Dave Santoro    }
62287614d7d293b1519dc1f0f403fd59c8bf4d8a347Dave Santoro
623dd5c25c65f09ada246c826fb6d04f0b6d4cf4388Fred Quintana    protected boolean queryRawContactIsStarred(long rawContactId) {
624dd5c25c65f09ada246c826fb6d04f0b6d4cf4388Fred Quintana        Cursor c = queryRawContact(rawContactId);
625dd5c25c65f09ada246c826fb6d04f0b6d4cf4388Fred Quintana        try {
626dd5c25c65f09ada246c826fb6d04f0b6d4cf4388Fred Quintana            assertTrue(c.moveToFirst());
627dd5c25c65f09ada246c826fb6d04f0b6d4cf4388Fred Quintana            return c.getLong(c.getColumnIndex(RawContacts.STARRED)) != 0;
628dd5c25c65f09ada246c826fb6d04f0b6d4cf4388Fred Quintana        } finally {
629dd5c25c65f09ada246c826fb6d04f0b6d4cf4388Fred Quintana            c.close();
630dd5c25c65f09ada246c826fb6d04f0b6d4cf4388Fred Quintana        }
631dd5c25c65f09ada246c826fb6d04f0b6d4cf4388Fred Quintana    }
632dd5c25c65f09ada246c826fb6d04f0b6d4cf4388Fred Quintana
633d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov    protected String queryDisplayName(long contactId) {
634d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov        Cursor c = queryContact(contactId);
635d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov        assertTrue(c.moveToFirst());
636d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov        String displayName = c.getString(c.getColumnIndex(Contacts.DISPLAY_NAME));
637d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov        c.close();
638d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov        return displayName;
639d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov    }
640d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov
6412149ab82f021c204618d0d3644e261fd7a8d8490Dmitri Plotnikov    protected String queryLookupKey(long contactId) {
6422d2ec88b7af615b2f05e987da45425be9cace1baTom O'Neill        Cursor c = queryContact(contactId);
6432d2ec88b7af615b2f05e987da45425be9cace1baTom O'Neill        assertTrue(c.moveToFirst());
6442d2ec88b7af615b2f05e987da45425be9cace1baTom O'Neill        String lookupKey = c.getString(c.getColumnIndex(Contacts.LOOKUP_KEY));
6452d2ec88b7af615b2f05e987da45425be9cace1baTom O'Neill        c.close();
6462d2ec88b7af615b2f05e987da45425be9cace1baTom O'Neill        return lookupKey;
6472d2ec88b7af615b2f05e987da45425be9cace1baTom O'Neill    }
6482d2ec88b7af615b2f05e987da45425be9cace1baTom O'Neill
649d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov    protected void assertAggregated(long rawContactId1, long rawContactId2) {
650d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov        long contactId1 = queryContactId(rawContactId1);
651d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov        long contactId2 = queryContactId(rawContactId2);
652d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov        assertTrue(contactId1 == contactId2);
653bf659107617a6291ba8bfeebc3f2e50138075ab5Dmitri Plotnikov    }
654bf659107617a6291ba8bfeebc3f2e50138075ab5Dmitri Plotnikov
655d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov    protected void assertAggregated(long rawContactId1, long rawContactId2,
656d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov            String expectedDisplayName) {
657d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov        long contactId1 = queryContactId(rawContactId1);
658d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov        long contactId2 = queryContactId(rawContactId2);
659d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov        assertTrue(contactId1 == contactId2);
660d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov
661d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov        String displayName = queryDisplayName(contactId1);
662d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov        assertEquals(expectedDisplayName, displayName);
663d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov    }
664d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov
665d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov    protected void assertNotAggregated(long rawContactId1, long rawContactId2) {
666d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov        long contactId1 = queryContactId(rawContactId1);
667d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov        long contactId2 = queryContactId(rawContactId2);
668d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov        assertTrue(contactId1 != contactId2);
669d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov    }
6704097855e2d672b3f8e1c5c8a169efb80203bf53eDmitri Plotnikov
6715ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov    protected void assertStructuredName(long rawContactId, String prefix, String givenName,
6724097855e2d672b3f8e1c5c8a169efb80203bf53eDmitri Plotnikov            String middleName, String familyName, String suffix) {
673f266e8c568905337960b1fec5379841585af92a7Dmitri Plotnikov        Uri uri = Uri.withAppendedPath(
674f266e8c568905337960b1fec5379841585af92a7Dmitri Plotnikov                ContentUris.withAppendedId(RawContacts.CONTENT_URI, rawContactId),
6756cffee46a1334d2b3ed19f436b27638451541044Dmitri Plotnikov                RawContacts.Data.CONTENT_DIRECTORY);
6764097855e2d672b3f8e1c5c8a169efb80203bf53eDmitri Plotnikov
6774097855e2d672b3f8e1c5c8a169efb80203bf53eDmitri Plotnikov        final String[] projection = new String[] {
6784097855e2d672b3f8e1c5c8a169efb80203bf53eDmitri Plotnikov                StructuredName.PREFIX, StructuredName.GIVEN_NAME, StructuredName.MIDDLE_NAME,
6794097855e2d672b3f8e1c5c8a169efb80203bf53eDmitri Plotnikov                StructuredName.FAMILY_NAME, StructuredName.SUFFIX
6804097855e2d672b3f8e1c5c8a169efb80203bf53eDmitri Plotnikov        };
6814097855e2d672b3f8e1c5c8a169efb80203bf53eDmitri Plotnikov
6824097855e2d672b3f8e1c5c8a169efb80203bf53eDmitri Plotnikov        Cursor c = mResolver.query(uri, projection, Data.MIMETYPE + "='"
6834097855e2d672b3f8e1c5c8a169efb80203bf53eDmitri Plotnikov                + StructuredName.CONTENT_ITEM_TYPE + "'", null, null);
6844097855e2d672b3f8e1c5c8a169efb80203bf53eDmitri Plotnikov
6854097855e2d672b3f8e1c5c8a169efb80203bf53eDmitri Plotnikov        assertTrue(c.moveToFirst());
6864097855e2d672b3f8e1c5c8a169efb80203bf53eDmitri Plotnikov        assertEquals(prefix, c.getString(0));
6874097855e2d672b3f8e1c5c8a169efb80203bf53eDmitri Plotnikov        assertEquals(givenName, c.getString(1));
6884097855e2d672b3f8e1c5c8a169efb80203bf53eDmitri Plotnikov        assertEquals(middleName, c.getString(2));
6894097855e2d672b3f8e1c5c8a169efb80203bf53eDmitri Plotnikov        assertEquals(familyName, c.getString(3));
6904097855e2d672b3f8e1c5c8a169efb80203bf53eDmitri Plotnikov        assertEquals(suffix, c.getString(4));
6914097855e2d672b3f8e1c5c8a169efb80203bf53eDmitri Plotnikov        c.close();
6924097855e2d672b3f8e1c5c8a169efb80203bf53eDmitri Plotnikov    }
6939261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana
6949261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana    protected long assertSingleGroup(Long rowId, Account account, String sourceId, String title) {
6959261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        Cursor c = mResolver.query(Groups.CONTENT_URI, null, null, null, null);
6969261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        try {
6979261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana            assertTrue(c.moveToNext());
6989261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana            long actualRowId = assertGroup(c, rowId, account, sourceId, title);
6999261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana            assertFalse(c.moveToNext());
7009261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana            return actualRowId;
7019261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        } finally {
7029261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana            c.close();
7039261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        }
7049261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana    }
7059261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana
7065ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov    protected long assertSingleGroupMembership(Long rowId, Long rawContactId, Long groupRowId,
7079261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana            String sourceId) {
7089261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        Cursor c = mResolver.query(ContactsContract.Data.CONTENT_URI, null, null, null, null);
7099261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        try {
7109261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana            assertTrue(c.moveToNext());
7115ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov            long actualRowId = assertGroupMembership(c, rowId, rawContactId, groupRowId, sourceId);
7129261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana            assertFalse(c.moveToNext());
7139261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana            return actualRowId;
7149261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        } finally {
7159261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana            c.close();
7169261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        }
7179261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana    }
7189261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana
7195ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov    protected long assertGroupMembership(Cursor c, Long rowId, Long rawContactId, Long groupRowId,
7209261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana            String sourceId) {
7219261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        assertNullOrEquals(c, rowId, Data._ID);
7225ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov        assertNullOrEquals(c, rawContactId, GroupMembership.RAW_CONTACT_ID);
7239261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        assertNullOrEquals(c, groupRowId, GroupMembership.GROUP_ROW_ID);
7249261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        assertNullOrEquals(c, sourceId, GroupMembership.GROUP_SOURCE_ID);
7259261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        return c.getLong(c.getColumnIndexOrThrow("_id"));
7269261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana    }
7279261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana
7289261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana    protected long assertGroup(Cursor c, Long rowId, Account account, String sourceId, String title) {
7299261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        assertNullOrEquals(c, rowId, Groups._ID);
7309261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        assertNullOrEquals(c, account);
7319261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        assertNullOrEquals(c, sourceId, Groups.SOURCE_ID);
7329261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        assertNullOrEquals(c, title, Groups.TITLE);
7339261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        return c.getLong(c.getColumnIndexOrThrow("_id"));
7349261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana    }
7359261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana
7369261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana    private void assertNullOrEquals(Cursor c, Account account) {
7379261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        if (account == NO_ACCOUNT) {
7389261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana            return;
7399261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        }
7409261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        if (account == null) {
7419261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana            assertTrue(c.isNull(c.getColumnIndexOrThrow(Groups.ACCOUNT_NAME)));
7429261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana            assertTrue(c.isNull(c.getColumnIndexOrThrow(Groups.ACCOUNT_TYPE)));
7439261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        } else {
744df9fd6b239de5829b04cb413e4dfa3e6da649c38Fred Quintana            assertEquals(account.name, c.getString(c.getColumnIndexOrThrow(Groups.ACCOUNT_NAME)));
745df9fd6b239de5829b04cb413e4dfa3e6da649c38Fred Quintana            assertEquals(account.type, c.getString(c.getColumnIndexOrThrow(Groups.ACCOUNT_TYPE)));
7469261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        }
7479261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana    }
7489261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana
7499261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana    private void assertNullOrEquals(Cursor c, Long value, String columnName) {
7509261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        if (value != NO_LONG) {
7519261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana            if (value == null) assertTrue(c.isNull(c.getColumnIndexOrThrow(columnName)));
7529261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana            else assertEquals((long) value, c.getLong(c.getColumnIndexOrThrow(columnName)));
7539261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        }
7549261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana    }
7559261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana
7569261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana    private void assertNullOrEquals(Cursor c, String value, String columnName) {
7579261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        if (value != NO_STRING) {
7589261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana            if (value == null) assertTrue(c.isNull(c.getColumnIndexOrThrow(columnName)));
7599261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana            else assertEquals(value, c.getString(c.getColumnIndexOrThrow(columnName)));
7609261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        }
7619261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana    }
7629261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana
7639261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana    protected void assertDataRow(ContentValues actual, String expectedMimetype,
7649261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana            Object... expectedArguments) {
7659261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        assertEquals(actual.toString(), expectedMimetype, actual.getAsString(Data.MIMETYPE));
7669261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        for (int i = 0; i < expectedArguments.length; i += 2) {
7679261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana            String columnName = (String) expectedArguments[i];
7689261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana            Object expectedValue = expectedArguments[i + 1];
7699261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana            if (expectedValue instanceof Uri) {
7709261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana                expectedValue = ContentUris.parseId((Uri) expectedValue);
7719261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana            }
7729261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana            if (expectedValue == null) {
7739261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana                assertNull(actual.toString(), actual.get(columnName));
7749261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana            }
7759261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana            if (expectedValue instanceof Long) {
776226c3dc6e93ca76a84c99100caa31045cba06cf6Fred Quintana                assertEquals("mismatch at " + columnName + " from " + actual.toString(),
777226c3dc6e93ca76a84c99100caa31045cba06cf6Fred Quintana                        expectedValue, actual.getAsLong(columnName));
7789261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana            } else if (expectedValue instanceof Integer) {
779226c3dc6e93ca76a84c99100caa31045cba06cf6Fred Quintana                assertEquals("mismatch at " + columnName + " from " + actual.toString(),
780226c3dc6e93ca76a84c99100caa31045cba06cf6Fred Quintana                        expectedValue, actual.getAsInteger(columnName));
7819261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana            } else if (expectedValue instanceof String) {
782226c3dc6e93ca76a84c99100caa31045cba06cf6Fred Quintana                assertEquals("mismatch at " + columnName + " from " + actual.toString(),
783226c3dc6e93ca76a84c99100caa31045cba06cf6Fred Quintana                        expectedValue, actual.getAsString(columnName));
7849261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana            } else {
785226c3dc6e93ca76a84c99100caa31045cba06cf6Fred Quintana                assertEquals("mismatch at " + columnName + " from " + actual.toString(),
786226c3dc6e93ca76a84c99100caa31045cba06cf6Fred Quintana                        expectedValue, actual.get(columnName));
7879261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana            }
7889261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        }
7899261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana    }
7909261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana
791dd5c25c65f09ada246c826fb6d04f0b6d4cf4388Fred Quintana    protected void assertNoRowsAndClose(Cursor c) {
792dd5c25c65f09ada246c826fb6d04f0b6d4cf4388Fred Quintana        try {
793dd5c25c65f09ada246c826fb6d04f0b6d4cf4388Fred Quintana            assertFalse(c.moveToNext());
794dd5c25c65f09ada246c826fb6d04f0b6d4cf4388Fred Quintana        } finally {
795dd5c25c65f09ada246c826fb6d04f0b6d4cf4388Fred Quintana            c.close();
796dd5c25c65f09ada246c826fb6d04f0b6d4cf4388Fred Quintana        }
797dd5c25c65f09ada246c826fb6d04f0b6d4cf4388Fred Quintana    }
798dd5c25c65f09ada246c826fb6d04f0b6d4cf4388Fred Quintana
7999261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana    protected static class IdComparator implements Comparator<ContentValues> {
80059f6477e10203617f504857f7e9aee2fda393f4fDebashish Chatterjee        @Override
8019261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        public int compare(ContentValues o1, ContentValues o2) {
8029261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana            long id1 = o1.getAsLong(ContactsContract.Data._ID);
8039261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana            long id2 = o2.getAsLong(ContactsContract.Data._ID);
8049261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana            if (id1 == id2) return 0;
8059261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana            return (id1 < id2) ? -1 : 1;
8069261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        }
8079261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana    }
8089261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana
8099261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana    protected ContentValues[] asSortedContentValuesArray(
8109261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana            ArrayList<Entity.NamedContentValues> subValues) {
8119261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        ContentValues[] result = new ContentValues[subValues.size()];
8129261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        int i = 0;
8139261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        for (Entity.NamedContentValues subValue : subValues) {
8149261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana            result[i] = subValue.values;
8159261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana            i++;
8169261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        }
8179261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        Arrays.sort(result, new IdComparator());
8189261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        return result;
8199261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana    }
8209261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana
8219261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana    protected void assertDirty(Uri uri, boolean state) {
8229261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        Cursor c = mResolver.query(uri, new String[]{"dirty"}, null, null, null);
8239261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        assertTrue(c.moveToNext());
8249261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        assertEquals(state, c.getLong(0) != 0);
8259261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        assertFalse(c.moveToNext());
8263cfe8d532d509fbbe605454e3a32b2361b7e1501Dmitri Plotnikov        c.close();
8279261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana    }
8289261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana
8299261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana    protected long getVersion(Uri uri) {
8309261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        Cursor c = mResolver.query(uri, new String[]{"version"}, null, null, null);
8319261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        assertTrue(c.moveToNext());
8329261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        long version = c.getLong(0);
8339261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        assertFalse(c.moveToNext());
8343cfe8d532d509fbbe605454e3a32b2361b7e1501Dmitri Plotnikov        c.close();
8359261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        return version;
8369261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana    }
8379261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana
8389261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana    protected void clearDirty(Uri uri) {
8399261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        ContentValues values = new ContentValues();
8409261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        values.put("dirty", 0);
8419261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana        mResolver.update(uri, values, null, null);
8429261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana    }
84320a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov
8445870f2dcc2ac7715b2c078a886ee346622e7887eDmitri Plotnikov    protected void storeValue(Uri contentUri, long id, String column, String value) {
845f5a847e8c93db02f3334dbc276debd90bdea5658Dmitri Plotnikov        storeValue(ContentUris.withAppendedId(contentUri, id), column, value);
846f5a847e8c93db02f3334dbc276debd90bdea5658Dmitri Plotnikov    }
847f5a847e8c93db02f3334dbc276debd90bdea5658Dmitri Plotnikov
848f5a847e8c93db02f3334dbc276debd90bdea5658Dmitri Plotnikov    protected void storeValue(Uri contentUri, String column, String value) {
849f5a847e8c93db02f3334dbc276debd90bdea5658Dmitri Plotnikov        ContentValues values = new ContentValues();
850f5a847e8c93db02f3334dbc276debd90bdea5658Dmitri Plotnikov        values.put(column, value);
851f5a847e8c93db02f3334dbc276debd90bdea5658Dmitri Plotnikov
852f5a847e8c93db02f3334dbc276debd90bdea5658Dmitri Plotnikov        mResolver.update(contentUri, values, null, null);
853f5a847e8c93db02f3334dbc276debd90bdea5658Dmitri Plotnikov    }
854f5a847e8c93db02f3334dbc276debd90bdea5658Dmitri Plotnikov
855f5a847e8c93db02f3334dbc276debd90bdea5658Dmitri Plotnikov    protected void storeValue(Uri contentUri, long id, String column, long value) {
856f5a847e8c93db02f3334dbc276debd90bdea5658Dmitri Plotnikov        storeValue(ContentUris.withAppendedId(contentUri, id), column, value);
857f5a847e8c93db02f3334dbc276debd90bdea5658Dmitri Plotnikov    }
858f5a847e8c93db02f3334dbc276debd90bdea5658Dmitri Plotnikov
859f5a847e8c93db02f3334dbc276debd90bdea5658Dmitri Plotnikov    protected void storeValue(Uri contentUri, String column, long value) {
8605870f2dcc2ac7715b2c078a886ee346622e7887eDmitri Plotnikov        ContentValues values = new ContentValues();
8615870f2dcc2ac7715b2c078a886ee346622e7887eDmitri Plotnikov        values.put(column, value);
8625870f2dcc2ac7715b2c078a886ee346622e7887eDmitri Plotnikov
863f5a847e8c93db02f3334dbc276debd90bdea5658Dmitri Plotnikov        mResolver.update(contentUri, values, null, null);
8645870f2dcc2ac7715b2c078a886ee346622e7887eDmitri Plotnikov    }
8655870f2dcc2ac7715b2c078a886ee346622e7887eDmitri Plotnikov
866f01c876a92b9c950a0450ed8b706ac5eb2c9b660Dmitri Plotnikov    protected void assertStoredValue(Uri contentUri, long id, String column, Object expectedValue) {
867f01c876a92b9c950a0450ed8b706ac5eb2c9b660Dmitri Plotnikov        assertStoredValue(ContentUris.withAppendedId(contentUri, id), column, expectedValue);
868f01c876a92b9c950a0450ed8b706ac5eb2c9b660Dmitri Plotnikov    }
869f01c876a92b9c950a0450ed8b706ac5eb2c9b660Dmitri Plotnikov
8705870f2dcc2ac7715b2c078a886ee346622e7887eDmitri Plotnikov    protected void assertStoredValue(Uri rowUri, String column, Object expectedValue) {
87120a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov        String value = getStoredValue(rowUri, column);
87201911fa9cfa21f198fd767eedde072acbb879f28Dmitri Plotnikov        if (expectedValue == null) {
87301911fa9cfa21f198fd767eedde072acbb879f28Dmitri Plotnikov            assertNull("Column value " + column, value);
87401911fa9cfa21f198fd767eedde072acbb879f28Dmitri Plotnikov        } else {
87501911fa9cfa21f198fd767eedde072acbb879f28Dmitri Plotnikov            assertEquals("Column value " + column, String.valueOf(expectedValue), value);
87601911fa9cfa21f198fd767eedde072acbb879f28Dmitri Plotnikov        }
87720a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov    }
87820a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov
87989c626eb655440c86a2e5df076e83708c1b32c17Dmitri Plotnikov    protected void assertStoredValue(Uri rowUri, String selection, String[] selectionArgs,
88089c626eb655440c86a2e5df076e83708c1b32c17Dmitri Plotnikov            String column, Object expectedValue) {
88189c626eb655440c86a2e5df076e83708c1b32c17Dmitri Plotnikov        String value = getStoredValue(rowUri, selection, selectionArgs, column);
88289c626eb655440c86a2e5df076e83708c1b32c17Dmitri Plotnikov        if (expectedValue == null) {
88389c626eb655440c86a2e5df076e83708c1b32c17Dmitri Plotnikov            assertNull("Column value " + column, value);
88489c626eb655440c86a2e5df076e83708c1b32c17Dmitri Plotnikov        } else {
88589c626eb655440c86a2e5df076e83708c1b32c17Dmitri Plotnikov            assertEquals("Column value " + column, String.valueOf(expectedValue), value);
88689c626eb655440c86a2e5df076e83708c1b32c17Dmitri Plotnikov        }
88789c626eb655440c86a2e5df076e83708c1b32c17Dmitri Plotnikov    }
88889c626eb655440c86a2e5df076e83708c1b32c17Dmitri Plotnikov
88920a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov    protected String getStoredValue(Uri rowUri, String column) {
89089c626eb655440c86a2e5df076e83708c1b32c17Dmitri Plotnikov        return getStoredValue(rowUri, null, null, column);
89189c626eb655440c86a2e5df076e83708c1b32c17Dmitri Plotnikov    }
89289c626eb655440c86a2e5df076e83708c1b32c17Dmitri Plotnikov
89389c626eb655440c86a2e5df076e83708c1b32c17Dmitri Plotnikov    protected String getStoredValue(Uri uri, String selection, String[] selectionArgs,
89489c626eb655440c86a2e5df076e83708c1b32c17Dmitri Plotnikov            String column) {
8958e45e5f2142db78941b095f7418cc05b71668094Dmitri Plotnikov        String value = null;
89689c626eb655440c86a2e5df076e83708c1b32c17Dmitri Plotnikov        Cursor c = mResolver.query(uri, new String[] { column }, selection, selectionArgs, null);
89720a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov        try {
898d1746e09bc7739f3d1449cececc66d5045ada498Daniel Lehmann            assertEquals("Record count for " + uri, 1, c.getCount());
89992ddc5cdc4d89ee2c6e861ae7b3a3a913ffa0100Dmitri Plotnikov
9008e45e5f2142db78941b095f7418cc05b71668094Dmitri Plotnikov            if (c.moveToFirst()) {
9016f983fd835f0cdd5ac7931ccd49d44e9ea4c87c0Dave Santoro                value = getCursorStringValue(c, column);
9028e45e5f2142db78941b095f7418cc05b71668094Dmitri Plotnikov            }
90320a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov        } finally {
90420a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov            c.close();
90520a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov        }
90620a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov        return value;
90720a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov    }
90820a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov
9096f983fd835f0cdd5ac7931ccd49d44e9ea4c87c0Dave Santoro    /**
9106f983fd835f0cdd5ac7931ccd49d44e9ea4c87c0Dave Santoro     * Retrieves the string value in the given column, handling deferred snippeting if the requested
9116f983fd835f0cdd5ac7931ccd49d44e9ea4c87c0Dave Santoro     * column is the snippet and the cursor specifies it.
9126f983fd835f0cdd5ac7931ccd49d44e9ea4c87c0Dave Santoro     */
9136f983fd835f0cdd5ac7931ccd49d44e9ea4c87c0Dave Santoro    protected String getCursorStringValue(Cursor c, String column) {
9146f983fd835f0cdd5ac7931ccd49d44e9ea4c87c0Dave Santoro        String value = c.getString(c.getColumnIndex(column));
9156f983fd835f0cdd5ac7931ccd49d44e9ea4c87c0Dave Santoro        if (SearchSnippetColumns.SNIPPET.equals(column)) {
9166f983fd835f0cdd5ac7931ccd49d44e9ea4c87c0Dave Santoro            Bundle extras = c.getExtras();
9176f983fd835f0cdd5ac7931ccd49d44e9ea4c87c0Dave Santoro            if (extras.containsKey(ContactsContract.DEFERRED_SNIPPETING)) {
9186f983fd835f0cdd5ac7931ccd49d44e9ea4c87c0Dave Santoro                String displayName = "No display name";
9196f983fd835f0cdd5ac7931ccd49d44e9ea4c87c0Dave Santoro                int displayNameColumnIndex = c.getColumnIndex(Contacts.DISPLAY_NAME);
9206f983fd835f0cdd5ac7931ccd49d44e9ea4c87c0Dave Santoro                if (displayNameColumnIndex != -1) {
9216f983fd835f0cdd5ac7931ccd49d44e9ea4c87c0Dave Santoro                    displayName = c.getString(displayNameColumnIndex);
9226f983fd835f0cdd5ac7931ccd49d44e9ea4c87c0Dave Santoro                }
9236f983fd835f0cdd5ac7931ccd49d44e9ea4c87c0Dave Santoro                String query = extras.getString(ContactsContract.DEFERRED_SNIPPETING_QUERY);
9246f983fd835f0cdd5ac7931ccd49d44e9ea4c87c0Dave Santoro                value = ContactsContract.snippetize(value, displayName, query,
9256f983fd835f0cdd5ac7931ccd49d44e9ea4c87c0Dave Santoro                        '[', ']', "...", 5);
9266f983fd835f0cdd5ac7931ccd49d44e9ea4c87c0Dave Santoro            }
9276f983fd835f0cdd5ac7931ccd49d44e9ea4c87c0Dave Santoro        }
9286f983fd835f0cdd5ac7931ccd49d44e9ea4c87c0Dave Santoro        return value;
9296f983fd835f0cdd5ac7931ccd49d44e9ea4c87c0Dave Santoro    }
9306f983fd835f0cdd5ac7931ccd49d44e9ea4c87c0Dave Santoro
9312f830d3bb66f780937203e9738e046841a070e73Daisuke Miyakawa    protected Long getStoredLongValue(Uri uri, String selection, String[] selectionArgs,
9322f830d3bb66f780937203e9738e046841a070e73Daisuke Miyakawa            String column) {
9332f830d3bb66f780937203e9738e046841a070e73Daisuke Miyakawa        Long value = null;
9342f830d3bb66f780937203e9738e046841a070e73Daisuke Miyakawa        Cursor c = mResolver.query(uri, new String[] { column }, selection, selectionArgs, null);
9352f830d3bb66f780937203e9738e046841a070e73Daisuke Miyakawa        try {
9362f830d3bb66f780937203e9738e046841a070e73Daisuke Miyakawa            assertEquals("Record count", 1, c.getCount());
9372f830d3bb66f780937203e9738e046841a070e73Daisuke Miyakawa
9382f830d3bb66f780937203e9738e046841a070e73Daisuke Miyakawa            if (c.moveToFirst()) {
9392f830d3bb66f780937203e9738e046841a070e73Daisuke Miyakawa                value = c.getLong(c.getColumnIndex(column));
9402f830d3bb66f780937203e9738e046841a070e73Daisuke Miyakawa            }
9412f830d3bb66f780937203e9738e046841a070e73Daisuke Miyakawa        } finally {
9422f830d3bb66f780937203e9738e046841a070e73Daisuke Miyakawa            c.close();
9432f830d3bb66f780937203e9738e046841a070e73Daisuke Miyakawa        }
9442f830d3bb66f780937203e9738e046841a070e73Daisuke Miyakawa        return value;
9452f830d3bb66f780937203e9738e046841a070e73Daisuke Miyakawa    }
9462f830d3bb66f780937203e9738e046841a070e73Daisuke Miyakawa
947f547fd54d7933e1c03af4a8dc10560c71c38f6b8Dave Santoro    protected Long getStoredLongValue(Uri uri, String column) {
948f547fd54d7933e1c03af4a8dc10560c71c38f6b8Dave Santoro        return getStoredLongValue(uri, null, null, column);
949f547fd54d7933e1c03af4a8dc10560c71c38f6b8Dave Santoro    }
950f547fd54d7933e1c03af4a8dc10560c71c38f6b8Dave Santoro
95120a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov    protected void assertStoredValues(Uri rowUri, ContentValues expectedValues) {
952bce6ee29f2d971ceae2bfce85a06bb3ecec6537aDmitri Plotnikov        assertStoredValues(rowUri, null, null, expectedValues);
953bce6ee29f2d971ceae2bfce85a06bb3ecec6537aDmitri Plotnikov    }
954bce6ee29f2d971ceae2bfce85a06bb3ecec6537aDmitri Plotnikov
95587426833d4c2c626e032f5d0b84a08b58024daf6Makoto Onuki    protected void assertStoredValues(Uri rowUri, ContentValues... expectedValues) {
956892a3d9ded5c64a63ae3d5d5c52c59528b466c93Dmitri Plotnikov        assertStoredValues(rowUri, null, null, expectedValues);
957892a3d9ded5c64a63ae3d5d5c52c59528b466c93Dmitri Plotnikov    }
958892a3d9ded5c64a63ae3d5d5c52c59528b466c93Dmitri Plotnikov
959bce6ee29f2d971ceae2bfce85a06bb3ecec6537aDmitri Plotnikov    protected void assertStoredValues(Uri rowUri, String selection, String[] selectionArgs,
960bce6ee29f2d971ceae2bfce85a06bb3ecec6537aDmitri Plotnikov            ContentValues expectedValues) {
961bce6ee29f2d971ceae2bfce85a06bb3ecec6537aDmitri Plotnikov        Cursor c = mResolver.query(rowUri, null, selection, selectionArgs, null);
96220a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov        try {
96320a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov            assertEquals("Record count", 1, c.getCount());
96420a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov            c.moveToFirst();
96520a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov            assertCursorValues(c, expectedValues);
96687426833d4c2c626e032f5d0b84a08b58024daf6Makoto Onuki        } catch (Error e) {
96787426833d4c2c626e032f5d0b84a08b58024daf6Makoto Onuki            TestUtils.dumpCursor(c);
96887426833d4c2c626e032f5d0b84a08b58024daf6Makoto Onuki            throw e;
96920a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov        } finally {
97020a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov            c.close();
97120a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov        }
97220a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov    }
97320a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov
974ff2de103f7e3eeeff4665ef63f07460fef053d6dDmitri Plotnikov    protected void assertStoredValuesWithProjection(Uri rowUri, ContentValues expectedValues) {
97523ba865a6d204ba4aa29d2fad9989e9c44351e81Makoto Onuki        assertStoredValuesWithProjection(rowUri, new ContentValues[] {expectedValues});
97623ba865a6d204ba4aa29d2fad9989e9c44351e81Makoto Onuki    }
97723ba865a6d204ba4aa29d2fad9989e9c44351e81Makoto Onuki
978dfab50ecd585e55769dea451cb3a47ff69b8b86dMakoto Onuki    protected void assertStoredValuesWithProjection(Uri rowUri, ContentValues... expectedValues) {
97923ba865a6d204ba4aa29d2fad9989e9c44351e81Makoto Onuki        assertTrue("Need at least one ContentValues for this test", expectedValues.length > 0);
98023ba865a6d204ba4aa29d2fad9989e9c44351e81Makoto Onuki        Cursor c = mResolver.query(rowUri, buildProjection(expectedValues[0]), null, null, null);
981ff2de103f7e3eeeff4665ef63f07460fef053d6dDmitri Plotnikov        try {
98223ba865a6d204ba4aa29d2fad9989e9c44351e81Makoto Onuki            assertEquals("Record count", expectedValues.length, c.getCount());
983ff2de103f7e3eeeff4665ef63f07460fef053d6dDmitri Plotnikov            c.moveToFirst();
984ff2de103f7e3eeeff4665ef63f07460fef053d6dDmitri Plotnikov            assertCursorValues(c, expectedValues);
98587426833d4c2c626e032f5d0b84a08b58024daf6Makoto Onuki        } catch (Error e) {
98687426833d4c2c626e032f5d0b84a08b58024daf6Makoto Onuki            TestUtils.dumpCursor(c);
98787426833d4c2c626e032f5d0b84a08b58024daf6Makoto Onuki            throw e;
988ff2de103f7e3eeeff4665ef63f07460fef053d6dDmitri Plotnikov        } finally {
989ff2de103f7e3eeeff4665ef63f07460fef053d6dDmitri Plotnikov            c.close();
990ff2de103f7e3eeeff4665ef63f07460fef053d6dDmitri Plotnikov        }
991ff2de103f7e3eeeff4665ef63f07460fef053d6dDmitri Plotnikov    }
992ff2de103f7e3eeeff4665ef63f07460fef053d6dDmitri Plotnikov
993892a3d9ded5c64a63ae3d5d5c52c59528b466c93Dmitri Plotnikov    protected void assertStoredValues(
994dfab50ecd585e55769dea451cb3a47ff69b8b86dMakoto Onuki            Uri rowUri, String selection, String[] selectionArgs, ContentValues... expectedValues) {
995dfab50ecd585e55769dea451cb3a47ff69b8b86dMakoto Onuki        assertStoredValues(mResolver.query(rowUri, null, selection, selectionArgs, null),
996dfab50ecd585e55769dea451cb3a47ff69b8b86dMakoto Onuki                expectedValues);
997dfab50ecd585e55769dea451cb3a47ff69b8b86dMakoto Onuki    }
998dfab50ecd585e55769dea451cb3a47ff69b8b86dMakoto Onuki
999dfab50ecd585e55769dea451cb3a47ff69b8b86dMakoto Onuki    private void assertStoredValues(Cursor c, ContentValues... expectedValues) {
1000892a3d9ded5c64a63ae3d5d5c52c59528b466c93Dmitri Plotnikov        try {
1001892a3d9ded5c64a63ae3d5d5c52c59528b466c93Dmitri Plotnikov            assertEquals("Record count", expectedValues.length, c.getCount());
1002892a3d9ded5c64a63ae3d5d5c52c59528b466c93Dmitri Plotnikov            assertCursorValues(c, expectedValues);
100387426833d4c2c626e032f5d0b84a08b58024daf6Makoto Onuki        } catch (Error e) {
100487426833d4c2c626e032f5d0b84a08b58024daf6Makoto Onuki            TestUtils.dumpCursor(c);
100587426833d4c2c626e032f5d0b84a08b58024daf6Makoto Onuki            throw e;
1006892a3d9ded5c64a63ae3d5d5c52c59528b466c93Dmitri Plotnikov        } finally {
1007892a3d9ded5c64a63ae3d5d5c52c59528b466c93Dmitri Plotnikov            c.close();
1008892a3d9ded5c64a63ae3d5d5c52c59528b466c93Dmitri Plotnikov        }
1009892a3d9ded5c64a63ae3d5d5c52c59528b466c93Dmitri Plotnikov    }
1010892a3d9ded5c64a63ae3d5d5c52c59528b466c93Dmitri Plotnikov
1011dfab50ecd585e55769dea451cb3a47ff69b8b86dMakoto Onuki    /**
1012dfab50ecd585e55769dea451cb3a47ff69b8b86dMakoto Onuki     * A variation of {@link #assertStoredValues}, but it queries directly to the DB.
1013dfab50ecd585e55769dea451cb3a47ff69b8b86dMakoto Onuki     */
1014dfab50ecd585e55769dea451cb3a47ff69b8b86dMakoto Onuki    protected void assertStoredValuesDb(
1015dfab50ecd585e55769dea451cb3a47ff69b8b86dMakoto Onuki            String sql, String[] selectionArgs, ContentValues... expectedValues) {
1016dfab50ecd585e55769dea451cb3a47ff69b8b86dMakoto Onuki        SQLiteDatabase db = ((ContactsProvider2) getProvider()).getDatabaseHelper()
1017dfab50ecd585e55769dea451cb3a47ff69b8b86dMakoto Onuki                .getReadableDatabase();
1018dfab50ecd585e55769dea451cb3a47ff69b8b86dMakoto Onuki        assertStoredValues(db.rawQuery(sql, selectionArgs), expectedValues);
1019dfab50ecd585e55769dea451cb3a47ff69b8b86dMakoto Onuki    }
1020dfab50ecd585e55769dea451cb3a47ff69b8b86dMakoto Onuki
1021dfab50ecd585e55769dea451cb3a47ff69b8b86dMakoto Onuki    protected void assertStoredValuesOrderly(Uri rowUri, ContentValues... expectedValues) {
10227d82ae92714f2132e3a0971d844ae8cdf10d76e7Daisuke Miyakawa        assertStoredValuesOrderly(rowUri, null, null, expectedValues);
10237d82ae92714f2132e3a0971d844ae8cdf10d76e7Daisuke Miyakawa    }
10247d82ae92714f2132e3a0971d844ae8cdf10d76e7Daisuke Miyakawa
10257d82ae92714f2132e3a0971d844ae8cdf10d76e7Daisuke Miyakawa    protected void assertStoredValuesOrderly(Uri rowUri, String selection,
1026dfab50ecd585e55769dea451cb3a47ff69b8b86dMakoto Onuki            String[] selectionArgs, ContentValues... expectedValues) {
10277d82ae92714f2132e3a0971d844ae8cdf10d76e7Daisuke Miyakawa        Cursor c = mResolver.query(rowUri, null, selection, selectionArgs, null);
10287d82ae92714f2132e3a0971d844ae8cdf10d76e7Daisuke Miyakawa        try {
10297d82ae92714f2132e3a0971d844ae8cdf10d76e7Daisuke Miyakawa            assertEquals("Record count", expectedValues.length, c.getCount());
10307d82ae92714f2132e3a0971d844ae8cdf10d76e7Daisuke Miyakawa            assertCursorValuesOrderly(c, expectedValues);
103187426833d4c2c626e032f5d0b84a08b58024daf6Makoto Onuki        } catch (Error e) {
103287426833d4c2c626e032f5d0b84a08b58024daf6Makoto Onuki            TestUtils.dumpCursor(c);
103387426833d4c2c626e032f5d0b84a08b58024daf6Makoto Onuki            throw e;
10347d82ae92714f2132e3a0971d844ae8cdf10d76e7Daisuke Miyakawa        } finally {
10357d82ae92714f2132e3a0971d844ae8cdf10d76e7Daisuke Miyakawa            c.close();
10367d82ae92714f2132e3a0971d844ae8cdf10d76e7Daisuke Miyakawa        }
10377d82ae92714f2132e3a0971d844ae8cdf10d76e7Daisuke Miyakawa    }
10387d82ae92714f2132e3a0971d844ae8cdf10d76e7Daisuke Miyakawa
103920a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov    /**
104020a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov     * Constructs a selection (where clause) out of all supplied values, uses it
104120a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov     * to query the provider and verifies that a single row is returned and it
104220a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov     * has the same values as requested.
104320a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov     */
104420a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov    protected void assertSelection(Uri uri, ContentValues values, String idColumn, long id) {
1045ff2de103f7e3eeeff4665ef63f07460fef053d6dDmitri Plotnikov        assertSelection(uri, values, idColumn, id, null);
1046ff2de103f7e3eeeff4665ef63f07460fef053d6dDmitri Plotnikov    }
1047ff2de103f7e3eeeff4665ef63f07460fef053d6dDmitri Plotnikov
1048ff2de103f7e3eeeff4665ef63f07460fef053d6dDmitri Plotnikov    public void assertSelectionWithProjection(Uri uri, ContentValues values, String idColumn,
1049ff2de103f7e3eeeff4665ef63f07460fef053d6dDmitri Plotnikov            long id) {
1050ff2de103f7e3eeeff4665ef63f07460fef053d6dDmitri Plotnikov        assertSelection(uri, values, idColumn, id, buildProjection(values));
1051ff2de103f7e3eeeff4665ef63f07460fef053d6dDmitri Plotnikov    }
1052ff2de103f7e3eeeff4665ef63f07460fef053d6dDmitri Plotnikov
1053ff2de103f7e3eeeff4665ef63f07460fef053d6dDmitri Plotnikov    private void assertSelection(Uri uri, ContentValues values, String idColumn, long id,
1054ff2de103f7e3eeeff4665ef63f07460fef053d6dDmitri Plotnikov            String[] projection) {
105520a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov        StringBuilder sb = new StringBuilder();
105620a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov        ArrayList<String> selectionArgs = new ArrayList<String>(values.size());
1057c70dc0e38ff82c6e6d6b7458637c54fbdf446aacDmitri Plotnikov        if (idColumn != null) {
1058c70dc0e38ff82c6e6d6b7458637c54fbdf446aacDmitri Plotnikov            sb.append(idColumn).append("=").append(id);
1059c70dc0e38ff82c6e6d6b7458637c54fbdf446aacDmitri Plotnikov        }
106020a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov        Set<Map.Entry<String, Object>> entries = values.valueSet();
106120a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov        for (Map.Entry<String, Object> entry : entries) {
106220a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov            String column = entry.getKey();
106320a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov            Object value = entry.getValue();
1064c70dc0e38ff82c6e6d6b7458637c54fbdf446aacDmitri Plotnikov            if (sb.length() != 0) {
1065c70dc0e38ff82c6e6d6b7458637c54fbdf446aacDmitri Plotnikov                sb.append(" AND ");
1066c70dc0e38ff82c6e6d6b7458637c54fbdf446aacDmitri Plotnikov            }
1067c70dc0e38ff82c6e6d6b7458637c54fbdf446aacDmitri Plotnikov            sb.append(column);
106820a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov            if (value == null) {
106920a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov                sb.append(" IS NULL");
107020a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov            } else {
107120a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov                sb.append("=?");
107220a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov                selectionArgs.add(String.valueOf(value));
107320a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov            }
107420a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov        }
107520a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov
1076ff2de103f7e3eeeff4665ef63f07460fef053d6dDmitri Plotnikov        Cursor c = mResolver.query(uri, projection, sb.toString(), selectionArgs.toArray(new String[0]),
107720a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov                null);
107820a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov        try {
107920a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov            assertEquals("Record count", 1, c.getCount());
108020a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov            c.moveToFirst();
108120a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov            assertCursorValues(c, values);
108287426833d4c2c626e032f5d0b84a08b58024daf6Makoto Onuki        } catch (Error e) {
108387426833d4c2c626e032f5d0b84a08b58024daf6Makoto Onuki            TestUtils.dumpCursor(c);
108487426833d4c2c626e032f5d0b84a08b58024daf6Makoto Onuki            throw e;
108520a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov        } finally {
108620a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov            c.close();
108720a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov        }
108820a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov    }
108920a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov
1090c918b0d3ab17a45a392748f43956b927c83eb402Dmitri Plotnikov    protected void assertCursorValue(Cursor cursor, String column, Object expectedValue) {
1091c918b0d3ab17a45a392748f43956b927c83eb402Dmitri Plotnikov        String actualValue = cursor.getString(cursor.getColumnIndex(column));
1092c918b0d3ab17a45a392748f43956b927c83eb402Dmitri Plotnikov        assertEquals("Column " + column, String.valueOf(expectedValue),
1093c918b0d3ab17a45a392748f43956b927c83eb402Dmitri Plotnikov                String.valueOf(actualValue));
1094c918b0d3ab17a45a392748f43956b927c83eb402Dmitri Plotnikov    }
1095c918b0d3ab17a45a392748f43956b927c83eb402Dmitri Plotnikov
109620a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov    protected void assertCursorValues(Cursor cursor, ContentValues expectedValues) {
1097892a3d9ded5c64a63ae3d5d5c52c59528b466c93Dmitri Plotnikov        StringBuilder message = new StringBuilder();
1098892a3d9ded5c64a63ae3d5d5c52c59528b466c93Dmitri Plotnikov        boolean result = equalsWithExpectedValues(cursor, expectedValues, message);
1099892a3d9ded5c64a63ae3d5d5c52c59528b466c93Dmitri Plotnikov        assertTrue(message.toString(), result);
1100892a3d9ded5c64a63ae3d5d5c52c59528b466c93Dmitri Plotnikov    }
1101892a3d9ded5c64a63ae3d5d5c52c59528b466c93Dmitri Plotnikov
110287426833d4c2c626e032f5d0b84a08b58024daf6Makoto Onuki    protected void assertCursorValues(Cursor cursor, ContentValues... expectedValues) {
1103892a3d9ded5c64a63ae3d5d5c52c59528b466c93Dmitri Plotnikov        StringBuilder message = new StringBuilder();
1104ac61fb8b20b05bb7a9af7c6d68bf8cdbdf675102Makoto Onuki
1105ac61fb8b20b05bb7a9af7c6d68bf8cdbdf675102Makoto Onuki        // In case if expectedValues contains multiple identical values, remember which cursor
1106ac61fb8b20b05bb7a9af7c6d68bf8cdbdf675102Makoto Onuki        // rows are "consumed" to prevent multiple ContentValues from hitting the same row.
1107ac61fb8b20b05bb7a9af7c6d68bf8cdbdf675102Makoto Onuki        final BitSet used = new BitSet(cursor.getCount());
1108ac61fb8b20b05bb7a9af7c6d68bf8cdbdf675102Makoto Onuki
1109892a3d9ded5c64a63ae3d5d5c52c59528b466c93Dmitri Plotnikov        for (ContentValues v : expectedValues) {
1110892a3d9ded5c64a63ae3d5d5c52c59528b466c93Dmitri Plotnikov            boolean found = false;
1111892a3d9ded5c64a63ae3d5d5c52c59528b466c93Dmitri Plotnikov            cursor.moveToPosition(-1);
1112892a3d9ded5c64a63ae3d5d5c52c59528b466c93Dmitri Plotnikov            while (cursor.moveToNext()) {
1113ac61fb8b20b05bb7a9af7c6d68bf8cdbdf675102Makoto Onuki                final int pos = cursor.getPosition();
1114ac61fb8b20b05bb7a9af7c6d68bf8cdbdf675102Makoto Onuki                if (used.get(pos)) continue;
1115892a3d9ded5c64a63ae3d5d5c52c59528b466c93Dmitri Plotnikov                found = equalsWithExpectedValues(cursor, v, message);
1116892a3d9ded5c64a63ae3d5d5c52c59528b466c93Dmitri Plotnikov                if (found) {
1117ac61fb8b20b05bb7a9af7c6d68bf8cdbdf675102Makoto Onuki                    used.set(pos);
1118892a3d9ded5c64a63ae3d5d5c52c59528b466c93Dmitri Plotnikov                    break;
1119892a3d9ded5c64a63ae3d5d5c52c59528b466c93Dmitri Plotnikov                }
1120892a3d9ded5c64a63ae3d5d5c52c59528b466c93Dmitri Plotnikov            }
1121dfab50ecd585e55769dea451cb3a47ff69b8b86dMakoto Onuki            assertTrue("Expected values can not be found " + v + "," + message.toString(), found);
1122892a3d9ded5c64a63ae3d5d5c52c59528b466c93Dmitri Plotnikov        }
1123892a3d9ded5c64a63ae3d5d5c52c59528b466c93Dmitri Plotnikov    }
1124892a3d9ded5c64a63ae3d5d5c52c59528b466c93Dmitri Plotnikov
112587426833d4c2c626e032f5d0b84a08b58024daf6Makoto Onuki    private void assertCursorValuesOrderly(Cursor cursor, ContentValues... expectedValues) {
11267d82ae92714f2132e3a0971d844ae8cdf10d76e7Daisuke Miyakawa        StringBuilder message = new StringBuilder();
11277d82ae92714f2132e3a0971d844ae8cdf10d76e7Daisuke Miyakawa        cursor.moveToPosition(-1);
11287d82ae92714f2132e3a0971d844ae8cdf10d76e7Daisuke Miyakawa        for (ContentValues v : expectedValues) {
11297d82ae92714f2132e3a0971d844ae8cdf10d76e7Daisuke Miyakawa            assertTrue(cursor.moveToNext());
1130dfab50ecd585e55769dea451cb3a47ff69b8b86dMakoto Onuki            boolean ok = equalsWithExpectedValues(cursor, v, message);
1131dfab50ecd585e55769dea451cb3a47ff69b8b86dMakoto Onuki            assertTrue("ContentValues didn't match.  Pos=" + cursor.getPosition() + ", values=" +
1132dfab50ecd585e55769dea451cb3a47ff69b8b86dMakoto Onuki                    v + message.toString(), ok);
11337d82ae92714f2132e3a0971d844ae8cdf10d76e7Daisuke Miyakawa        }
11347d82ae92714f2132e3a0971d844ae8cdf10d76e7Daisuke Miyakawa    }
11357d82ae92714f2132e3a0971d844ae8cdf10d76e7Daisuke Miyakawa
1136892a3d9ded5c64a63ae3d5d5c52c59528b466c93Dmitri Plotnikov    private boolean equalsWithExpectedValues(Cursor cursor, ContentValues expectedValues,
1137892a3d9ded5c64a63ae3d5d5c52c59528b466c93Dmitri Plotnikov            StringBuilder msgBuffer) {
1138fba89ea92f519d77ec1d762724ed11bf4ebb7d20Makoto Onuki        for (String column : expectedValues.keySet()) {
113920a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov            int index = cursor.getColumnIndex(column);
1140892a3d9ded5c64a63ae3d5d5c52c59528b466c93Dmitri Plotnikov            if (index == -1) {
1141dfab50ecd585e55769dea451cb3a47ff69b8b86dMakoto Onuki                msgBuffer.append(" No such column: ").append(column);
1142892a3d9ded5c64a63ae3d5d5c52c59528b466c93Dmitri Plotnikov                return false;
1143892a3d9ded5c64a63ae3d5d5c52c59528b466c93Dmitri Plotnikov            }
114420a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov            Object expectedValue = expectedValues.get(column);
114520a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov            String value;
114620a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov            if (expectedValue instanceof byte[]) {
114720a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov                expectedValue = Hex.encodeHex((byte[])expectedValue, false);
114820a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov                value = Hex.encodeHex(cursor.getBlob(index), false);
114920a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov            } else {
115020a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov                expectedValue = expectedValues.getAsString(column);
11516f983fd835f0cdd5ac7931ccd49d44e9ea4c87c0Dave Santoro                value = getCursorStringValue(cursor, column);
115220a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov            }
1153892a3d9ded5c64a63ae3d5d5c52c59528b466c93Dmitri Plotnikov            if (expectedValue != null && !expectedValue.equals(value) || value != null
1154892a3d9ded5c64a63ae3d5d5c52c59528b466c93Dmitri Plotnikov                    && !value.equals(expectedValue)) {
1155892a3d9ded5c64a63ae3d5d5c52c59528b466c93Dmitri Plotnikov                msgBuffer
1156dfab50ecd585e55769dea451cb3a47ff69b8b86dMakoto Onuki                        .append(" Column value ")
1157892a3d9ded5c64a63ae3d5d5c52c59528b466c93Dmitri Plotnikov                        .append(column)
1158892a3d9ded5c64a63ae3d5d5c52c59528b466c93Dmitri Plotnikov                        .append(" expected <")
1159892a3d9ded5c64a63ae3d5d5c52c59528b466c93Dmitri Plotnikov                        .append(expectedValue)
1160892a3d9ded5c64a63ae3d5d5c52c59528b466c93Dmitri Plotnikov                        .append(">, but was <")
1161892a3d9ded5c64a63ae3d5d5c52c59528b466c93Dmitri Plotnikov                        .append(value)
1162892a3d9ded5c64a63ae3d5d5c52c59528b466c93Dmitri Plotnikov                        .append('>');
1163892a3d9ded5c64a63ae3d5d5c52c59528b466c93Dmitri Plotnikov                return false;
1164892a3d9ded5c64a63ae3d5d5c52c59528b466c93Dmitri Plotnikov            }
116520a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov        }
1166892a3d9ded5c64a63ae3d5d5c52c59528b466c93Dmitri Plotnikov        return true;
116720a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov    }
116833b41fdb8d7c3c654cb070799c9d6e2b4ab16078Dmitri Plotnikov
1169ff2de103f7e3eeeff4665ef63f07460fef053d6dDmitri Plotnikov    private String[] buildProjection(ContentValues values) {
1170ff2de103f7e3eeeff4665ef63f07460fef053d6dDmitri Plotnikov        String[] projection = new String[values.size()];
1171ff2de103f7e3eeeff4665ef63f07460fef053d6dDmitri Plotnikov        Iterator<Entry<String, Object>> iter = values.valueSet().iterator();
1172ff2de103f7e3eeeff4665ef63f07460fef053d6dDmitri Plotnikov        for (int i = 0; i < projection.length; i++) {
1173ff2de103f7e3eeeff4665ef63f07460fef053d6dDmitri Plotnikov            projection[i] = iter.next().getKey();
1174ff2de103f7e3eeeff4665ef63f07460fef053d6dDmitri Plotnikov        }
1175ff2de103f7e3eeeff4665ef63f07460fef053d6dDmitri Plotnikov        return projection;
1176ff2de103f7e3eeeff4665ef63f07460fef053d6dDmitri Plotnikov    }
1177ff2de103f7e3eeeff4665ef63f07460fef053d6dDmitri Plotnikov
117833b41fdb8d7c3c654cb070799c9d6e2b4ab16078Dmitri Plotnikov    protected int getCount(Uri uri, String selection, String[] selectionArgs) {
117933b41fdb8d7c3c654cb070799c9d6e2b4ab16078Dmitri Plotnikov        Cursor c = mResolver.query(uri, null, selection, selectionArgs, null);
118033b41fdb8d7c3c654cb070799c9d6e2b4ab16078Dmitri Plotnikov        try {
118133b41fdb8d7c3c654cb070799c9d6e2b4ab16078Dmitri Plotnikov            return c.getCount();
118233b41fdb8d7c3c654cb070799c9d6e2b4ab16078Dmitri Plotnikov        } finally {
118333b41fdb8d7c3c654cb070799c9d6e2b4ab16078Dmitri Plotnikov            c.close();
118433b41fdb8d7c3c654cb070799c9d6e2b4ab16078Dmitri Plotnikov        }
118533b41fdb8d7c3c654cb070799c9d6e2b4ab16078Dmitri Plotnikov    }
1186a908fb5f39aa2021662a6cc317cc7e4db2d8bfb0Dmitri Plotnikov
1187b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov    public static void dump(ContentResolver resolver, boolean aggregatedOnly) {
1188b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov        String[] projection = new String[] {
1189b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov                Contacts._ID,
1190b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov                Contacts.DISPLAY_NAME
1191b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov        };
1192b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov        String selection = null;
1193b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov        if (aggregatedOnly) {
1194b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov            selection = Contacts._ID
1195b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov                    + " IN (SELECT contact_id" +
1196b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov                    		" FROM raw_contacts GROUP BY contact_id HAVING count(*) > 1)";
1197b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov        }
1198b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov
1199b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov        Cursor c = resolver.query(Contacts.CONTENT_URI, projection, selection, null,
1200b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov                Contacts.DISPLAY_NAME);
1201b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov        while(c.moveToNext()) {
1202b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov            long contactId = c.getLong(0);
1203b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov            Log.i("Contact   ", String.format("%5d %s", contactId, c.getString(1)));
1204b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov            dumpRawContacts(resolver, contactId);
1205b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov            Log.i("          ", ".");
1206b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov        }
1207b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov        c.close();
1208b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov    }
1209b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov
1210b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov    private static void dumpRawContacts(ContentResolver resolver, long contactId) {
1211b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov        String[] projection = new String[] {
1212b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov                RawContacts._ID,
1213b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov        };
1214b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov        Cursor c = resolver.query(RawContacts.CONTENT_URI, projection, RawContacts.CONTACT_ID + "="
1215b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov                + contactId, null, null);
1216b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov        while(c.moveToNext()) {
1217b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov            long rawContactId = c.getLong(0);
1218b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov            Log.i("RawContact", String.format("      %-5d", rawContactId));
1219b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov            dumpData(resolver, rawContactId);
1220b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov        }
1221b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov        c.close();
1222b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov    }
1223b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov
1224b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov    private static void dumpData(ContentResolver resolver, long rawContactId) {
1225b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov        String[] projection = new String[] {
1226b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov                Data.MIMETYPE,
1227b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov                Data.DATA1,
1228b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov                Data.DATA2,
1229b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov                Data.DATA3,
1230b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov        };
1231b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov        Cursor c = resolver.query(Data.CONTENT_URI, projection, Data.RAW_CONTACT_ID + "="
1232b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov                + rawContactId, null, Data.MIMETYPE);
1233b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov        while(c.moveToNext()) {
1234b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov            String mimetype = c.getString(0);
1235b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov            if (Photo.CONTENT_ITEM_TYPE.equals(mimetype)) {
1236b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov                Log.i("Photo     ", "");
1237b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov            } else {
1238b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov                mimetype = mimetype.substring(mimetype.indexOf('/') + 1);
1239b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov                Log.i("Data      ", String.format("            %-10s %s,%s,%s", mimetype,
1240b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov                        c.getString(1), c.getString(2), c.getString(3)));
1241b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov            }
1242b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov        }
1243b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov        c.close();
1244b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov    }
1245285b771bc955305fa6d49ca23f808cecc8a13d5eDmitri Plotnikov
124681d6a78dffd57f24f9aaecb6cd54e4084c3c9846Dmitri Plotnikov    protected void assertNetworkNotified(boolean expected) {
12479a6be1610fdf40c2f7f04cfe4b66fde3a35940dcDmitri Plotnikov        assertEquals(expected, (getContactsProvider()).isNetworkNotified());
124881d6a78dffd57f24f9aaecb6cd54e4084c3c9846Dmitri Plotnikov    }
12495b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill
125009ae48b82b17e24016b14a1ab64706222ab1071fDmitri Plotnikov    protected void assertProjection(Uri uri, String[] expectedProjection) {
125109ae48b82b17e24016b14a1ab64706222ab1071fDmitri Plotnikov        Cursor cursor = mResolver.query(uri, null, "0", null, null);
125209ae48b82b17e24016b14a1ab64706222ab1071fDmitri Plotnikov        String[] actualProjection = cursor.getColumnNames();
125309ae48b82b17e24016b14a1ab64706222ab1071fDmitri Plotnikov        MoreAsserts.assertEquals("Incorrect projection for URI: " + uri,
125409ae48b82b17e24016b14a1ab64706222ab1071fDmitri Plotnikov                Sets.newHashSet(expectedProjection), Sets.newHashSet(actualProjection));
125509ae48b82b17e24016b14a1ab64706222ab1071fDmitri Plotnikov        cursor.close();
125609ae48b82b17e24016b14a1ab64706222ab1071fDmitri Plotnikov    }
125709ae48b82b17e24016b14a1ab64706222ab1071fDmitri Plotnikov
1258a780048d2caafbd922444b0c08adb81790db4635Makoto Onuki    protected void assertRowCount(int expectedCount, Uri uri, String selection, String[] args) {
1259a780048d2caafbd922444b0c08adb81790db4635Makoto Onuki        Cursor cursor = mResolver.query(uri, null, selection, args, null);
1260a780048d2caafbd922444b0c08adb81790db4635Makoto Onuki
126187426833d4c2c626e032f5d0b84a08b58024daf6Makoto Onuki        try {
126287426833d4c2c626e032f5d0b84a08b58024daf6Makoto Onuki            assertEquals(expectedCount, cursor.getCount());
126387426833d4c2c626e032f5d0b84a08b58024daf6Makoto Onuki        } catch (Error e) {
126487426833d4c2c626e032f5d0b84a08b58024daf6Makoto Onuki            TestUtils.dumpCursor(cursor);
126587426833d4c2c626e032f5d0b84a08b58024daf6Makoto Onuki            throw e;
126687426833d4c2c626e032f5d0b84a08b58024daf6Makoto Onuki        } finally {
126787426833d4c2c626e032f5d0b84a08b58024daf6Makoto Onuki            cursor.close();
126887426833d4c2c626e032f5d0b84a08b58024daf6Makoto Onuki        }
1269a780048d2caafbd922444b0c08adb81790db4635Makoto Onuki    }
1270a780048d2caafbd922444b0c08adb81790db4635Makoto Onuki
12715b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill    /**
12725b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill     * A contact in the database, and the attributes used to create it.  Construct using
12735b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill     * {@link GoldenContactBuilder#build()}.
12745b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill     */
12755b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill    public final class GoldenContact {
12765b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill
12775b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill        private final long rawContactId;
12785b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill
12795b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill        private final long contactId;
12805b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill
12815b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill        private final String givenName;
12825b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill
12835b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill        private final String familyName;
12845b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill
12855b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill        private final String nickname;
12865b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill
12875b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill        private final byte[] photo;
12885b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill
12895b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill        private final String company;
12905b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill
12915b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill        private final String title;
12925b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill
12935b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill        private final String phone;
12945b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill
12955b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill        private final String email;
12965b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill
12975b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill        private GoldenContact(GoldenContactBuilder builder, long rawContactId, long contactId) {
12985b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill
12995b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill            this.rawContactId = rawContactId;
13005b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill            this.contactId = contactId;
13015b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill            givenName = builder.givenName;
13025b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill            familyName = builder.familyName;
13035b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill            nickname = builder.nickname;
13045b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill            photo = builder.photo;
13055b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill            company = builder.company;
13065b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill            title = builder.title;
13075b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill            phone = builder.phone;
13085b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill            email = builder.email;
13095b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill        }
13105b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill
13115b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill        public void delete() {
13125b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill            Uri rawContactUri = ContentUris.withAppendedId(RawContacts.CONTENT_URI, rawContactId);
13135b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill            mResolver.delete(rawContactUri, null, null);
13145b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill        }
13155b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill
13165b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill        /**
13175b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill         * Returns the index of the contact in table "raw_contacts"
13185b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill         */
13195b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill        public long getRawContactId() {
13205b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill            return rawContactId;
13215b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill        }
13225b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill
13235b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill        /**
13245b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill         * Returns the index of the contact in table "contacts"
13255b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill         */
13265b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill        public long getContactId() {
13275b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill            return contactId;
13285b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill        }
13295b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill
13305b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill        /**
13312d2ec88b7af615b2f05e987da45425be9cace1baTom O'Neill         * Returns the lookup key for the contact.
13322d2ec88b7af615b2f05e987da45425be9cace1baTom O'Neill         */
13332d2ec88b7af615b2f05e987da45425be9cace1baTom O'Neill        public String getLookupKey() {
13342d2ec88b7af615b2f05e987da45425be9cace1baTom O'Neill            return queryLookupKey(contactId);
13352d2ec88b7af615b2f05e987da45425be9cace1baTom O'Neill        }
13362d2ec88b7af615b2f05e987da45425be9cace1baTom O'Neill
13372d2ec88b7af615b2f05e987da45425be9cace1baTom O'Neill        /**
13385b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill         * Returns the contact's given name.
13395b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill         */
13405b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill        public String getGivenName() {
13415b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill            return givenName;
13425b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill        }
13435b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill
13445b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill        /**
13455b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill         * Returns the contact's family name.
13465b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill         */
13475b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill        public String getFamilyName() {
13485b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill            return familyName;
13495b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill        }
13505b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill
13515b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill        /**
13525b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill         * Returns the contact's nickname.
13535b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill         */
13545b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill        public String getNickname() {
13555b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill            return nickname;
13565b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill        }
13575b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill
13585b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill        /**
13595b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill         * Return's the contact's photo
13605b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill         */
13615b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill        public byte[] getPhoto() {
13625b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill            return photo;
13635b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill        }
13645b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill
13655b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill        /**
13665b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill         * Return's the company at which the contact works.
13675b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill         */
13685b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill        public String getCompany() {
13695b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill            return company;
13705b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill        }
13715b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill
13725b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill        /**
13735b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill         * Returns the contact's job title.
13745b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill         */
13755b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill        public String getTitle() {
13765b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill            return title;
13775b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill        }
13785b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill
13795b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill        /**
13805b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill         * Returns the contact's phone number
13815b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill         */
13825b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill        public String getPhone() {
13835b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill            return phone;
13845b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill        }
13855b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill
13865b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill        /**
13875b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill         * Returns the contact's email address
13885b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill         */
13895b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill        public String getEmail() {
13905b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill            return email;
13915b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill        }
13925b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill     }
13935b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill
13945b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill    /**
13955b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill     * Builds {@link GoldenContact} objects.  Unspecified boolean objects default to false.
13965b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill     * Unspecified String objects default to null.
13975b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill     */
13985b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill    public final class GoldenContactBuilder {
13995b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill
14005b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill        private String givenName;
14015b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill
14025b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill        private String familyName;
14035b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill
14045b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill        private String nickname;
14055b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill
14065b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill        private byte[] photo;
14075b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill
14085b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill        private String company;
14095b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill
14105b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill        private String title;
14115b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill
14125b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill        private String phone;
14135b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill
14145b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill        private String email;
14155b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill
14165b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill        /**
14175b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill         * The contact's given and family names.
14185b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill         *
14195b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill         * TODO(dplotnikov): inline, or should we require them to set both names if they set either?
14205b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill         */
14215b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill        public GoldenContactBuilder name(String givenName, String familyName) {
14225b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill            return givenName(givenName).familyName(familyName);
14235b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill        }
14245b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill
14255b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill        /**
14265b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill         * The contact's given name.
14275b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill         */
14285b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill        public GoldenContactBuilder givenName(String value) {
14295b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill            givenName = value;
14305b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill            return this;
14315b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill        }
14325b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill
14335b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill        /**
14345b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill         * The contact's family name.
14355b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill         */
14365b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill        public GoldenContactBuilder familyName(String value) {
14375b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill            familyName = value;
14385b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill            return this;
14395b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill        }
14405b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill
14415b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill        /**
14425b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill         * The contact's nickname.
14435b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill         */
14445b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill        public GoldenContactBuilder nickname(String value) {
14455b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill            nickname = value;
14465b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill            return this;
14475b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill        }
14485b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill
14495b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill        /**
14505b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill         * The contact's photo.
14515b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill         */
14525b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill        public GoldenContactBuilder photo(byte[] value) {
14535b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill            photo = value;
14545b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill            return this;
14555b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill        }
14565b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill
14575b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill        /**
14585b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill         * The company at which the contact works.
14595b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill         */
14605b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill        public GoldenContactBuilder company(String value) {
14615b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill            company = value;
14625b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill            return this;
14635b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill        }
14645b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill
14655b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill        /**
14665b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill         * The contact's job title.
14675b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill         */
14685b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill        public GoldenContactBuilder title(String value) {
14695b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill            title = value;
14705b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill            return this;
14715b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill        }
14725b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill
14735b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill        /**
14745b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill         * The contact's phone number.
14755b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill         */
14765b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill        public GoldenContactBuilder phone(String value) {
14775b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill            phone = value;
14785b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill            return this;
14795b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill        }
14805b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill
14815b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill        /**
14825b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill         * The contact's email address; also sets their IM status to {@link StatusUpdates#OFFLINE}
14835b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill         * with a presence of "Coding for Android".
14845b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill         */
14855b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill        public GoldenContactBuilder email(String value) {
14865b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill            email = value;
14875b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill            return this;
14885b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill        }
14895b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill
14905b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill        /**
14915b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill         * Builds the {@link GoldenContact} specified by this builder.
14925b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill         */
14935b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill        public GoldenContact build() {
14945b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill
14955b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill            final long groupId = createGroup(mAccount, "gsid1", "title1");
14965b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill
14975b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill            long rawContactId = createRawContact();
14985b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill            insertGroupMembership(rawContactId, groupId);
14995b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill
15005b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill            if (givenName != null || familyName != null) {
15015b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill                insertStructuredName(rawContactId, givenName, familyName);
15025b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill            }
15035b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill            if (nickname != null) {
15045b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill                insertNickname(rawContactId, nickname);
15055b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill            }
15065b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill            if (photo != null) {
15075b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill                insertPhoto(rawContactId);
15085b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill            }
15095b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill            if (company != null || title != null) {
15105b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill                insertOrganization(rawContactId);
15115b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill            }
15125b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill            if (email != null) {
15135b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill                insertEmail(rawContactId);
15145b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill            }
15155b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill            if (phone != null) {
15165b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill                insertPhone(rawContactId);
15175b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill            }
15185b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill
15195b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill            long contactId = queryContactId(rawContactId);
15205b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill
15215b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill            return new GoldenContact(this, rawContactId, contactId);
15225b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill        }
15235b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill
15245b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill        private void insertPhoto(long rawContactId) {
15255b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill            ContentValues values = new ContentValues();
15265b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill            values.put(Data.RAW_CONTACT_ID, rawContactId);
15275b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill            values.put(Data.MIMETYPE, Photo.CONTENT_ITEM_TYPE);
15285b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill            values.put(Photo.PHOTO, photo);
15295b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill            mResolver.insert(Data.CONTENT_URI, values);
15305b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill        }
15315b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill
15325b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill        private void insertOrganization(long rawContactId) {
15335b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill
15345b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill            ContentValues values = new ContentValues();
15355b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill            values.put(Data.RAW_CONTACT_ID, rawContactId);
15365b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill            values.put(Data.MIMETYPE, Organization.CONTENT_ITEM_TYPE);
15375b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill            values.put(Organization.TYPE, Organization.TYPE_WORK);
15385b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill            if (company != null) {
15395b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill                values.put(Organization.COMPANY, company);
15405b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill            }
15415b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill            if (title != null) {
15425b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill                values.put(Organization.TITLE, title);
15435b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill            }
15445b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill            mResolver.insert(Data.CONTENT_URI, values);
15455b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill        }
15465b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill
15475b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill        private void insertEmail(long rawContactId) {
15485b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill
15495b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill            ContentValues values = new ContentValues();
15505b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill            values.put(Data.RAW_CONTACT_ID, rawContactId);
15515b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill            values.put(Data.MIMETYPE, Email.CONTENT_ITEM_TYPE);
15525b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill            values.put(Email.TYPE, Email.TYPE_WORK);
15535b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill            values.put(Email.DATA, "foo@acme.com");
15545b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill            mResolver.insert(Data.CONTENT_URI, values);
15555b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill
15565b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill            int protocol = Im.PROTOCOL_GOOGLE_TALK;
15575b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill
15585b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill            values.clear();
15595b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill            values.put(StatusUpdates.PROTOCOL, protocol);
15605b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill            values.put(StatusUpdates.IM_HANDLE, email);
15615b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill            values.put(StatusUpdates.IM_ACCOUNT, "foo");
15625b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill            values.put(StatusUpdates.PRESENCE_STATUS, StatusUpdates.OFFLINE);
1563aabcd1d34a71ad06ee0a9395331540484f1ceb17Vasu Nori            values.put(StatusUpdates.CHAT_CAPABILITY, StatusUpdates.CAPABILITY_HAS_CAMERA);
15645b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill            values.put(StatusUpdates.PRESENCE_CUSTOM_STATUS, "Coding for Android");
15655b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill            mResolver.insert(StatusUpdates.CONTENT_URI, values);
15665b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill        }
15675b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill
15685b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill        private void insertPhone(long rawContactId) {
15695b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill            ContentValues values = new ContentValues();
15705b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill            values.put(Data.RAW_CONTACT_ID, rawContactId);
15715b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill            values.put(Data.MIMETYPE, Phone.CONTENT_ITEM_TYPE);
15725b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill            values.put(Data.IS_PRIMARY, 1);
15735b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill            values.put(Phone.TYPE, Phone.TYPE_HOME);
15745b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill            values.put(Phone.NUMBER, phone);
15755b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill            mResolver.insert(Data.CONTENT_URI, values);
15765b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill        }
15775b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill    }
1578d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov}
1579