BaseContactsProvider2Test.java revision 0bf6b318e3c994294d4a885f57906debd4a0e64e
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 2109ae48b82b17e24016b14a1ab64706222ab1071fDmitri Plotnikovimport com.google.android.collect.Sets; 2209ae48b82b17e24016b14a1ab64706222ab1071fDmitri Plotnikov 23e99988b266dd1263162583e81e2b408e7329b1c8Dmitri Plotnikovimport android.accounts.Account; 24bee1a6b2e7cbea778195890e442c9e50f2a4e6d9Dmitri Plotnikovimport android.content.ContentProvider; 25b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikovimport android.content.ContentResolver; 26d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikovimport android.content.ContentUris; 27d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikovimport android.content.ContentValues; 28e99988b266dd1263162583e81e2b408e7329b1c8Dmitri Plotnikovimport android.content.Context; 299261b2141aa90a4fed632fd6da03026d4c216280Fred Quintanaimport android.content.Entity; 30d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikovimport android.database.Cursor; 31d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikovimport android.net.Uri; 32bee1a6b2e7cbea778195890e442c9e50f2a4e6d9Dmitri Plotnikovimport android.provider.ContactsContract; 33d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikovimport android.provider.ContactsContract.AggregationExceptions; 34a5ad551e1753086825499f1aeb6415bb986f3588Dmitri Plotnikovimport android.provider.ContactsContract.CommonDataKinds.Email; 356d9702cec82fd27a1c3093c64df9dcc22744899aDmitri Plotnikovimport android.provider.ContactsContract.CommonDataKinds.Event; 369261b2141aa90a4fed632fd6da03026d4c216280Fred Quintanaimport android.provider.ContactsContract.CommonDataKinds.GroupMembership; 37e99988b266dd1263162583e81e2b408e7329b1c8Dmitri Plotnikovimport android.provider.ContactsContract.CommonDataKinds.Im; 38a5ad551e1753086825499f1aeb6415bb986f3588Dmitri Plotnikovimport android.provider.ContactsContract.CommonDataKinds.Nickname; 396d9702cec82fd27a1c3093c64df9dcc22744899aDmitri Plotnikovimport android.provider.ContactsContract.CommonDataKinds.Note; 4001911fa9cfa21f198fd767eedde072acbb879f28Dmitri Plotnikovimport android.provider.ContactsContract.CommonDataKinds.Organization; 41bf659107617a6291ba8bfeebc3f2e50138075ab5Dmitri Plotnikovimport android.provider.ContactsContract.CommonDataKinds.Phone; 42ae6ca1f34cf5458d79ec803411d4308879a91e92Evan Millarimport android.provider.ContactsContract.CommonDataKinds.Photo; 43e99988b266dd1263162583e81e2b408e7329b1c8Dmitri Plotnikovimport android.provider.ContactsContract.CommonDataKinds.StructuredName; 444a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikovimport android.provider.ContactsContract.CommonDataKinds.StructuredPostal; 4509ae48b82b17e24016b14a1ab64706222ab1071fDmitri Plotnikovimport android.provider.ContactsContract.Contacts; 4609ae48b82b17e24016b14a1ab64706222ab1071fDmitri Plotnikovimport android.provider.ContactsContract.Data; 4709ae48b82b17e24016b14a1ab64706222ab1071fDmitri Plotnikovimport android.provider.ContactsContract.Groups; 4809ae48b82b17e24016b14a1ab64706222ab1071fDmitri Plotnikovimport android.provider.ContactsContract.RawContacts; 4909ae48b82b17e24016b14a1ab64706222ab1071fDmitri Plotnikovimport android.provider.ContactsContract.Settings; 5009ae48b82b17e24016b14a1ab64706222ab1071fDmitri Plotnikovimport android.provider.ContactsContract.StatusUpdates; 513b505de6c622d20d40b85b361c1437a89aef82deDaniel Lehmannimport android.provider.ContactsContract.StreamItems; 5209ae48b82b17e24016b14a1ab64706222ab1071fDmitri Plotnikovimport android.test.MoreAsserts; 53d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikovimport android.test.mock.MockContentResolver; 54b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikovimport android.util.Log; 55bee1a6b2e7cbea778195890e442c9e50f2a4e6d9Dmitri Plotnikov 569261b2141aa90a4fed632fd6da03026d4c216280Fred Quintanaimport java.util.ArrayList; 579261b2141aa90a4fed632fd6da03026d4c216280Fred Quintanaimport java.util.Arrays; 58e99988b266dd1263162583e81e2b408e7329b1c8Dmitri Plotnikovimport java.util.Comparator; 59ff2de103f7e3eeeff4665ef63f07460fef053d6dDmitri Plotnikovimport java.util.Iterator; 6020a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikovimport java.util.Map; 61ff2de103f7e3eeeff4665ef63f07460fef053d6dDmitri Plotnikovimport java.util.Map.Entry; 6209ae48b82b17e24016b14a1ab64706222ab1071fDmitri Plotnikovimport java.util.Set; 63d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov 64d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov/** 65d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov * A common superclass for {@link ContactsProvider2}-related tests. 66d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov */ 67f547fd54d7933e1c03af4a8dc10560c71c38f6b8Dave Santoropublic abstract class BaseContactsProvider2Test extends PhotoLoadingTestCase { 68d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov 69d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov protected static final String PACKAGE = "ContactsProvider2Test"; 7073f1f396c155b247b903d8f4111db17d3e13dc4dDmitri Plotnikov public static final String READ_ONLY_ACCOUNT_TYPE = 7173f1f396c155b247b903d8f4111db17d3e13dc4dDmitri Plotnikov SynchronousContactsProvider2.READ_ONLY_ACCOUNT_TYPE; 72d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov 73bee1a6b2e7cbea778195890e442c9e50f2a4e6d9Dmitri Plotnikov protected ContactsActor mActor; 74d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov protected MockContentResolver mResolver; 759261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana protected Account mAccount = new Account("account1", "account type1"); 76e2579e029472f76b2dfda141444d775c67da0ec8Cynthia Wong protected Account mAccountTwo = new Account("account2", "account type2"); 779261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana 789261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana protected final static Long NO_LONG = new Long(0); 799261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana protected final static String NO_STRING = new String(""); 809261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana protected final static Account NO_ACCOUNT = new Account("a", "b"); 81d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov 82bee1a6b2e7cbea778195890e442c9e50f2a4e6d9Dmitri Plotnikov protected Class<? extends ContentProvider> getProviderClass() { 83bee1a6b2e7cbea778195890e442c9e50f2a4e6d9Dmitri Plotnikov return SynchronousContactsProvider2.class; 84bee1a6b2e7cbea778195890e442c9e50f2a4e6d9Dmitri Plotnikov } 85bee1a6b2e7cbea778195890e442c9e50f2a4e6d9Dmitri Plotnikov 86bee1a6b2e7cbea778195890e442c9e50f2a4e6d9Dmitri Plotnikov protected String getAuthority() { 87bee1a6b2e7cbea778195890e442c9e50f2a4e6d9Dmitri Plotnikov return ContactsContract.AUTHORITY; 88bee1a6b2e7cbea778195890e442c9e50f2a4e6d9Dmitri Plotnikov } 89bee1a6b2e7cbea778195890e442c9e50f2a4e6d9Dmitri Plotnikov 90d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov @Override 91d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov protected void setUp() throws Exception { 92d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov super.setUp(); 93d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov 94bee1a6b2e7cbea778195890e442c9e50f2a4e6d9Dmitri Plotnikov mActor = new ContactsActor(getContext(), PACKAGE_GREY, getProviderClass(), getAuthority()); 95d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov mResolver = mActor.resolver; 96445ca81effbb0d61c7bc0033acf2d3dfd228fd4eDmitri Plotnikov if (mActor.provider instanceof SynchronousContactsProvider2) { 979a6be1610fdf40c2f7f04cfe4b66fde3a35940dcDmitri Plotnikov getContactsProvider().wipeData(); 98445ca81effbb0d61c7bc0033acf2d3dfd228fd4eDmitri Plotnikov } 9924c1d384b45a6d3c1cc959062a9d4308335fabbfDave Santoro 10024c1d384b45a6d3c1cc959062a9d4308335fabbfDave Santoro // Give the actor access to read/write contacts and profile data by default. 10124c1d384b45a6d3c1cc959062a9d4308335fabbfDave Santoro mActor.addPermissions( 10224c1d384b45a6d3c1cc959062a9d4308335fabbfDave Santoro "android.permission.READ_CONTACTS", 10324c1d384b45a6d3c1cc959062a9d4308335fabbfDave Santoro "android.permission.WRITE_CONTACTS", 10424c1d384b45a6d3c1cc959062a9d4308335fabbfDave Santoro "android.permission.READ_PROFILE", 10524c1d384b45a6d3c1cc959062a9d4308335fabbfDave Santoro "android.permission.WRITE_PROFILE"); 1069261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana } 1079261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana 1080265a180cf027d149f11f8750652ac67ea08ca24Dmitri Plotnikov @Override 1090265a180cf027d149f11f8750652ac67ea08ca24Dmitri Plotnikov protected void tearDown() throws Exception { 1100265a180cf027d149f11f8750652ac67ea08ca24Dmitri Plotnikov super.tearDown(); 1110265a180cf027d149f11f8750652ac67ea08ca24Dmitri Plotnikov } 1120265a180cf027d149f11f8750652ac67ea08ca24Dmitri Plotnikov 1139a6be1610fdf40c2f7f04cfe4b66fde3a35940dcDmitri Plotnikov public SynchronousContactsProvider2 getContactsProvider() { 1149a6be1610fdf40c2f7f04cfe4b66fde3a35940dcDmitri Plotnikov return (SynchronousContactsProvider2) mActor.provider; 1159a6be1610fdf40c2f7f04cfe4b66fde3a35940dcDmitri Plotnikov } 1169a6be1610fdf40c2f7f04cfe4b66fde3a35940dcDmitri Plotnikov 117e99988b266dd1263162583e81e2b408e7329b1c8Dmitri Plotnikov public Context getMockContext() { 118e99988b266dd1263162583e81e2b408e7329b1c8Dmitri Plotnikov return mActor.context; 119e99988b266dd1263162583e81e2b408e7329b1c8Dmitri Plotnikov } 120e99988b266dd1263162583e81e2b408e7329b1c8Dmitri Plotnikov 121e99988b266dd1263162583e81e2b408e7329b1c8Dmitri Plotnikov public void addAuthority(String authority) { 122e99988b266dd1263162583e81e2b408e7329b1c8Dmitri Plotnikov mActor.addAuthority(authority); 123e99988b266dd1263162583e81e2b408e7329b1c8Dmitri Plotnikov } 124e99988b266dd1263162583e81e2b408e7329b1c8Dmitri Plotnikov 125e99988b266dd1263162583e81e2b408e7329b1c8Dmitri Plotnikov public ContentProvider addProvider(Class<? extends ContentProvider> providerClass, 126e99988b266dd1263162583e81e2b408e7329b1c8Dmitri Plotnikov String authority) throws Exception { 127e99988b266dd1263162583e81e2b408e7329b1c8Dmitri Plotnikov return mActor.addProvider(providerClass, authority); 128e99988b266dd1263162583e81e2b408e7329b1c8Dmitri Plotnikov } 129e99988b266dd1263162583e81e2b408e7329b1c8Dmitri Plotnikov 1303d8b043c3341a5b6c2e781b7eba9767d5cd13267Dmitri Plotnikov public ContentProvider getProvider() { 1313d8b043c3341a5b6c2e781b7eba9767d5cd13267Dmitri Plotnikov return mActor.provider; 1323d8b043c3341a5b6c2e781b7eba9767d5cd13267Dmitri Plotnikov } 1333d8b043c3341a5b6c2e781b7eba9767d5cd13267Dmitri Plotnikov 1349261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana protected Uri maybeAddAccountQueryParameters(Uri uri, Account account) { 1359261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana if (account == null) { 1369261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana return uri; 1379261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana } 1389261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana return uri.buildUpon() 139df9fd6b239de5829b04cb413e4dfa3e6da649c38Fred Quintana .appendQueryParameter(RawContacts.ACCOUNT_NAME, account.name) 140df9fd6b239de5829b04cb413e4dfa3e6da649c38Fred Quintana .appendQueryParameter(RawContacts.ACCOUNT_TYPE, account.type) 1419261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana .build(); 142d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov } 143d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov 144d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov protected long createRawContact() { 145226c3dc6e93ca76a84c99100caa31045cba06cf6Fred Quintana return createRawContact(null); 146d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov } 147d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov 148c70dc0e38ff82c6e6d6b7458637c54fbdf446aacDmitri Plotnikov protected long createRawContactWithName() { 149e246689441b2ff39cb97de277d6caeec95358863Jeff Sharkey return createRawContactWithName(null); 150e246689441b2ff39cb97de277d6caeec95358863Jeff Sharkey } 151e246689441b2ff39cb97de277d6caeec95358863Jeff Sharkey 152e246689441b2ff39cb97de277d6caeec95358863Jeff Sharkey protected long createRawContactWithName(Account account) { 153e246689441b2ff39cb97de277d6caeec95358863Jeff Sharkey return createRawContactWithName("John", "Doe", account); 1543cfe8d532d509fbbe605454e3a32b2361b7e1501Dmitri Plotnikov } 1553cfe8d532d509fbbe605454e3a32b2361b7e1501Dmitri Plotnikov 1563cfe8d532d509fbbe605454e3a32b2361b7e1501Dmitri Plotnikov protected long createRawContactWithName(String firstName, String lastName) { 157e246689441b2ff39cb97de277d6caeec95358863Jeff Sharkey return createRawContactWithName(firstName, lastName, null); 158e246689441b2ff39cb97de277d6caeec95358863Jeff Sharkey } 159e246689441b2ff39cb97de277d6caeec95358863Jeff Sharkey 160e246689441b2ff39cb97de277d6caeec95358863Jeff Sharkey protected long createRawContactWithName(String firstName, String lastName, Account account) { 161e246689441b2ff39cb97de277d6caeec95358863Jeff Sharkey long rawContactId = createRawContact(account); 1623cfe8d532d509fbbe605454e3a32b2361b7e1501Dmitri Plotnikov insertStructuredName(rawContactId, firstName, lastName); 163c70dc0e38ff82c6e6d6b7458637c54fbdf446aacDmitri Plotnikov return rawContactId; 164c70dc0e38ff82c6e6d6b7458637c54fbdf446aacDmitri Plotnikov } 165c70dc0e38ff82c6e6d6b7458637c54fbdf446aacDmitri Plotnikov 166e246689441b2ff39cb97de277d6caeec95358863Jeff Sharkey protected Uri setCallerIsSyncAdapter(Uri uri, Account account) { 167e246689441b2ff39cb97de277d6caeec95358863Jeff Sharkey if (account == null) { 168e246689441b2ff39cb97de277d6caeec95358863Jeff Sharkey return uri; 169e246689441b2ff39cb97de277d6caeec95358863Jeff Sharkey } 170e246689441b2ff39cb97de277d6caeec95358863Jeff Sharkey final Uri.Builder builder = uri.buildUpon(); 171e246689441b2ff39cb97de277d6caeec95358863Jeff Sharkey builder.appendQueryParameter(ContactsContract.RawContacts.ACCOUNT_NAME, account.name); 172e246689441b2ff39cb97de277d6caeec95358863Jeff Sharkey builder.appendQueryParameter(ContactsContract.RawContacts.ACCOUNT_TYPE, account.type); 173e246689441b2ff39cb97de277d6caeec95358863Jeff Sharkey builder.appendQueryParameter(ContactsContract.CALLER_IS_SYNCADAPTER, "true"); 174e246689441b2ff39cb97de277d6caeec95358863Jeff Sharkey return builder.build(); 175e246689441b2ff39cb97de277d6caeec95358863Jeff Sharkey } 176e246689441b2ff39cb97de277d6caeec95358863Jeff Sharkey 177226c3dc6e93ca76a84c99100caa31045cba06cf6Fred Quintana protected long createRawContact(Account account, String... extras) { 1789261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana ContentValues values = new ContentValues(); 179dd5c25c65f09ada246c826fb6d04f0b6d4cf4388Fred Quintana extrasVarArgsToValues(values, extras); 180dd5c25c65f09ada246c826fb6d04f0b6d4cf4388Fred Quintana final Uri uri = maybeAddAccountQueryParameters(RawContacts.CONTENT_URI, account); 181dd5c25c65f09ada246c826fb6d04f0b6d4cf4388Fred Quintana Uri contactUri = mResolver.insert(uri, values); 182dd5c25c65f09ada246c826fb6d04f0b6d4cf4388Fred Quintana return ContentUris.parseId(contactUri); 183dd5c25c65f09ada246c826fb6d04f0b6d4cf4388Fred Quintana } 184dd5c25c65f09ada246c826fb6d04f0b6d4cf4388Fred Quintana 185dd5c25c65f09ada246c826fb6d04f0b6d4cf4388Fred Quintana protected int updateItem(Uri uri, long id, String... extras) { 186dd5c25c65f09ada246c826fb6d04f0b6d4cf4388Fred Quintana Uri itemUri = ContentUris.withAppendedId(uri, id); 187dd5c25c65f09ada246c826fb6d04f0b6d4cf4388Fred Quintana return updateItem(itemUri, extras); 188dd5c25c65f09ada246c826fb6d04f0b6d4cf4388Fred Quintana } 189dd5c25c65f09ada246c826fb6d04f0b6d4cf4388Fred Quintana 190dd5c25c65f09ada246c826fb6d04f0b6d4cf4388Fred Quintana protected int updateItem(Uri uri, String... extras) { 191dd5c25c65f09ada246c826fb6d04f0b6d4cf4388Fred Quintana ContentValues values = new ContentValues(); 192dd5c25c65f09ada246c826fb6d04f0b6d4cf4388Fred Quintana extrasVarArgsToValues(values, extras); 193dd5c25c65f09ada246c826fb6d04f0b6d4cf4388Fred Quintana return mResolver.update(uri, values, null, null); 194dd5c25c65f09ada246c826fb6d04f0b6d4cf4388Fred Quintana } 195dd5c25c65f09ada246c826fb6d04f0b6d4cf4388Fred Quintana 196dd5c25c65f09ada246c826fb6d04f0b6d4cf4388Fred Quintana private static void extrasVarArgsToValues(ContentValues values, String... extras) { 197226c3dc6e93ca76a84c99100caa31045cba06cf6Fred Quintana for (int i = 0; i < extras.length; ) { 198226c3dc6e93ca76a84c99100caa31045cba06cf6Fred Quintana values.put(extras[i], extras[i + 1]); 199226c3dc6e93ca76a84c99100caa31045cba06cf6Fred Quintana i += 2; 200226c3dc6e93ca76a84c99100caa31045cba06cf6Fred Quintana } 2019261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana } 2029261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana 2039261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana protected long createGroup(Account account, String sourceId, String title) { 204dd5c25c65f09ada246c826fb6d04f0b6d4cf4388Fred Quintana return createGroup(account, sourceId, title, 1, false, false); 2050be993f8ef0078b9825a5ffe6add08a6786d8dacDmitri Plotnikov } 2060be993f8ef0078b9825a5ffe6add08a6786d8dacDmitri Plotnikov 2070be993f8ef0078b9825a5ffe6add08a6786d8dacDmitri Plotnikov protected long createGroup(Account account, String sourceId, String title, int visible) { 208dd5c25c65f09ada246c826fb6d04f0b6d4cf4388Fred Quintana return createGroup(account, sourceId, title, visible, false, false); 209dd5c25c65f09ada246c826fb6d04f0b6d4cf4388Fred Quintana } 210dd5c25c65f09ada246c826fb6d04f0b6d4cf4388Fred Quintana 211f266e8c568905337960b1fec5379841585af92a7Dmitri Plotnikov protected long createAutoAddGroup(Account account) { 212f266e8c568905337960b1fec5379841585af92a7Dmitri Plotnikov return createGroup(account, "auto", "auto", 213f266e8c568905337960b1fec5379841585af92a7Dmitri Plotnikov 0 /* visible */, true /* auto-add */, false /* fav */); 214f266e8c568905337960b1fec5379841585af92a7Dmitri Plotnikov } 215f266e8c568905337960b1fec5379841585af92a7Dmitri Plotnikov 216dd5c25c65f09ada246c826fb6d04f0b6d4cf4388Fred Quintana protected long createGroup(Account account, String sourceId, String title, 217dd5c25c65f09ada246c826fb6d04f0b6d4cf4388Fred Quintana int visible, boolean autoAdd, boolean favorite) { 2189261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana ContentValues values = new ContentValues(); 2199261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana values.put(Groups.SOURCE_ID, sourceId); 2209261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana values.put(Groups.TITLE, title); 2210be993f8ef0078b9825a5ffe6add08a6786d8dacDmitri Plotnikov values.put(Groups.GROUP_VISIBLE, visible); 222dd5c25c65f09ada246c826fb6d04f0b6d4cf4388Fred Quintana values.put(Groups.AUTO_ADD, autoAdd ? 1 : 0); 223dd5c25c65f09ada246c826fb6d04f0b6d4cf4388Fred Quintana values.put(Groups.FAVORITES, favorite ? 1 : 0); 2249261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana final Uri uri = maybeAddAccountQueryParameters(Groups.CONTENT_URI, account); 2259261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana return ContentUris.parseId(mResolver.insert(uri, values)); 2269261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana } 2279261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana 22889c626eb655440c86a2e5df076e83708c1b32c17Dmitri Plotnikov protected void createSettings(Account account, String shouldSync, String ungroupedVisible) { 22989c626eb655440c86a2e5df076e83708c1b32c17Dmitri Plotnikov ContentValues values = new ContentValues(); 23089c626eb655440c86a2e5df076e83708c1b32c17Dmitri Plotnikov values.put(Settings.ACCOUNT_NAME, account.name); 23189c626eb655440c86a2e5df076e83708c1b32c17Dmitri Plotnikov values.put(Settings.ACCOUNT_TYPE, account.type); 23289c626eb655440c86a2e5df076e83708c1b32c17Dmitri Plotnikov values.put(Settings.SHOULD_SYNC, shouldSync); 23389c626eb655440c86a2e5df076e83708c1b32c17Dmitri Plotnikov values.put(Settings.UNGROUPED_VISIBLE, ungroupedVisible); 23489c626eb655440c86a2e5df076e83708c1b32c17Dmitri Plotnikov mResolver.insert(Settings.CONTENT_URI, values); 23589c626eb655440c86a2e5df076e83708c1b32c17Dmitri Plotnikov } 23689c626eb655440c86a2e5df076e83708c1b32c17Dmitri Plotnikov 2375ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov protected Uri insertStructuredName(long rawContactId, String givenName, String familyName) { 238d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov ContentValues values = new ContentValues(); 239d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov StringBuilder sb = new StringBuilder(); 240d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov if (givenName != null) { 241d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov sb.append(givenName); 242d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov } 243d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov if (givenName != null && familyName != null) { 244d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov sb.append(" "); 245d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov } 246d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov if (familyName != null) { 247d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov sb.append(familyName); 248d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov } 249d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov values.put(StructuredName.DISPLAY_NAME, sb.toString()); 250d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov values.put(StructuredName.GIVEN_NAME, givenName); 251d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov values.put(StructuredName.FAMILY_NAME, familyName); 252d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov 2535ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov return insertStructuredName(rawContactId, values); 2544097855e2d672b3f8e1c5c8a169efb80203bf53eDmitri Plotnikov } 2554097855e2d672b3f8e1c5c8a169efb80203bf53eDmitri Plotnikov 2565ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov protected Uri insertStructuredName(long rawContactId, ContentValues values) { 2575ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov values.put(Data.RAW_CONTACT_ID, rawContactId); 2584097855e2d672b3f8e1c5c8a169efb80203bf53eDmitri Plotnikov values.put(Data.MIMETYPE, StructuredName.CONTENT_ITEM_TYPE); 259d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov Uri resultUri = mResolver.insert(Data.CONTENT_URI, values); 260d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov return resultUri; 261d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov } 262d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov 263a5d05d90333a70d471d78e82caeb5cfa2e4d4c59Tadashi G. Takaoka protected Uri insertOrganization(long rawContactId, ContentValues values) { 264a5d05d90333a70d471d78e82caeb5cfa2e4d4c59Tadashi G. Takaoka return insertOrganization(rawContactId, values, false); 26501911fa9cfa21f198fd767eedde072acbb879f28Dmitri Plotnikov } 26601911fa9cfa21f198fd767eedde072acbb879f28Dmitri Plotnikov 267a5d05d90333a70d471d78e82caeb5cfa2e4d4c59Tadashi G. Takaoka protected Uri insertOrganization(long rawContactId, ContentValues values, boolean primary) { 26801911fa9cfa21f198fd767eedde072acbb879f28Dmitri Plotnikov values.put(Data.RAW_CONTACT_ID, rawContactId); 26901911fa9cfa21f198fd767eedde072acbb879f28Dmitri Plotnikov values.put(Data.MIMETYPE, Organization.CONTENT_ITEM_TYPE); 27001911fa9cfa21f198fd767eedde072acbb879f28Dmitri Plotnikov values.put(Organization.TYPE, Organization.TYPE_WORK); 27101911fa9cfa21f198fd767eedde072acbb879f28Dmitri Plotnikov if (primary) { 2720265a180cf027d149f11f8750652ac67ea08ca24Dmitri Plotnikov values.put(Data.IS_PRIMARY, 1); 27301911fa9cfa21f198fd767eedde072acbb879f28Dmitri Plotnikov } 27401911fa9cfa21f198fd767eedde072acbb879f28Dmitri Plotnikov 27501911fa9cfa21f198fd767eedde072acbb879f28Dmitri Plotnikov Uri resultUri = mResolver.insert(Data.CONTENT_URI, values); 27601911fa9cfa21f198fd767eedde072acbb879f28Dmitri Plotnikov return resultUri; 27701911fa9cfa21f198fd767eedde072acbb879f28Dmitri Plotnikov } 27801911fa9cfa21f198fd767eedde072acbb879f28Dmitri Plotnikov 2795ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov protected Uri insertPhoneNumber(long rawContactId, String phoneNumber) { 28025abcf949c0dd826a770b437489b83de48975ceaDmitri Plotnikov return insertPhoneNumber(rawContactId, phoneNumber, false); 28125abcf949c0dd826a770b437489b83de48975ceaDmitri Plotnikov } 28225abcf949c0dd826a770b437489b83de48975ceaDmitri Plotnikov 28325abcf949c0dd826a770b437489b83de48975ceaDmitri Plotnikov protected Uri insertPhoneNumber(long rawContactId, String phoneNumber, boolean primary) { 284bf659107617a6291ba8bfeebc3f2e50138075ab5Dmitri Plotnikov ContentValues values = new ContentValues(); 2855ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov values.put(Data.RAW_CONTACT_ID, rawContactId); 286bf659107617a6291ba8bfeebc3f2e50138075ab5Dmitri Plotnikov values.put(Data.MIMETYPE, Phone.CONTENT_ITEM_TYPE); 287bf659107617a6291ba8bfeebc3f2e50138075ab5Dmitri Plotnikov values.put(Phone.NUMBER, phoneNumber); 2883cebbf7141252768d3e272e049e9c5b0cb9d710eDmitri Plotnikov values.put(Phone.TYPE, Phone.TYPE_HOME); 28925abcf949c0dd826a770b437489b83de48975ceaDmitri Plotnikov if (primary) { 2900265a180cf027d149f11f8750652ac67ea08ca24Dmitri Plotnikov values.put(Data.IS_PRIMARY, 1); 29125abcf949c0dd826a770b437489b83de48975ceaDmitri Plotnikov } 292bf659107617a6291ba8bfeebc3f2e50138075ab5Dmitri Plotnikov 293bf659107617a6291ba8bfeebc3f2e50138075ab5Dmitri Plotnikov Uri resultUri = mResolver.insert(Data.CONTENT_URI, values); 294bf659107617a6291ba8bfeebc3f2e50138075ab5Dmitri Plotnikov return resultUri; 295bf659107617a6291ba8bfeebc3f2e50138075ab5Dmitri Plotnikov } 296bf659107617a6291ba8bfeebc3f2e50138075ab5Dmitri Plotnikov 2975ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov protected Uri insertEmail(long rawContactId, String email) { 29825abcf949c0dd826a770b437489b83de48975ceaDmitri Plotnikov return insertEmail(rawContactId, email, false); 29925abcf949c0dd826a770b437489b83de48975ceaDmitri Plotnikov } 30025abcf949c0dd826a770b437489b83de48975ceaDmitri Plotnikov 30125abcf949c0dd826a770b437489b83de48975ceaDmitri Plotnikov protected Uri insertEmail(long rawContactId, String email, boolean primary) { 302916f2d7104bfba857412a66b40ed60fea6546222Dmitri Plotnikov return insertEmail(rawContactId, email, primary, Email.TYPE_HOME, null); 303916f2d7104bfba857412a66b40ed60fea6546222Dmitri Plotnikov } 304916f2d7104bfba857412a66b40ed60fea6546222Dmitri Plotnikov 305916f2d7104bfba857412a66b40ed60fea6546222Dmitri Plotnikov protected Uri insertEmail(long rawContactId, String email, boolean primary, int type, 306916f2d7104bfba857412a66b40ed60fea6546222Dmitri Plotnikov String label) { 307a5ad551e1753086825499f1aeb6415bb986f3588Dmitri Plotnikov ContentValues values = new ContentValues(); 3085ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov values.put(Data.RAW_CONTACT_ID, rawContactId); 309a5ad551e1753086825499f1aeb6415bb986f3588Dmitri Plotnikov values.put(Data.MIMETYPE, Email.CONTENT_ITEM_TYPE); 310a5ad551e1753086825499f1aeb6415bb986f3588Dmitri Plotnikov values.put(Email.DATA, email); 311916f2d7104bfba857412a66b40ed60fea6546222Dmitri Plotnikov values.put(Email.TYPE, type); 312916f2d7104bfba857412a66b40ed60fea6546222Dmitri Plotnikov values.put(Email.LABEL, label); 31325abcf949c0dd826a770b437489b83de48975ceaDmitri Plotnikov if (primary) { 314916f2d7104bfba857412a66b40ed60fea6546222Dmitri Plotnikov values.put(Data.IS_PRIMARY, 1); 31525abcf949c0dd826a770b437489b83de48975ceaDmitri Plotnikov } 316a5ad551e1753086825499f1aeb6415bb986f3588Dmitri Plotnikov 317a5ad551e1753086825499f1aeb6415bb986f3588Dmitri Plotnikov Uri resultUri = mResolver.insert(Data.CONTENT_URI, values); 318a5ad551e1753086825499f1aeb6415bb986f3588Dmitri Plotnikov return resultUri; 319a5ad551e1753086825499f1aeb6415bb986f3588Dmitri Plotnikov } 320a5ad551e1753086825499f1aeb6415bb986f3588Dmitri Plotnikov 3215ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov protected Uri insertNickname(long rawContactId, String nickname) { 322a5ad551e1753086825499f1aeb6415bb986f3588Dmitri Plotnikov ContentValues values = new ContentValues(); 3235ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov values.put(Data.RAW_CONTACT_ID, rawContactId); 324a5ad551e1753086825499f1aeb6415bb986f3588Dmitri Plotnikov values.put(Data.MIMETYPE, Nickname.CONTENT_ITEM_TYPE); 325a5ad551e1753086825499f1aeb6415bb986f3588Dmitri Plotnikov values.put(Nickname.NAME, nickname); 3263cebbf7141252768d3e272e049e9c5b0cb9d710eDmitri Plotnikov values.put(Nickname.TYPE, Nickname.TYPE_OTHER_NAME); 327a5ad551e1753086825499f1aeb6415bb986f3588Dmitri Plotnikov 328a5ad551e1753086825499f1aeb6415bb986f3588Dmitri Plotnikov Uri resultUri = mResolver.insert(Data.CONTENT_URI, values); 329a5ad551e1753086825499f1aeb6415bb986f3588Dmitri Plotnikov return resultUri; 330a5ad551e1753086825499f1aeb6415bb986f3588Dmitri Plotnikov } 331a5ad551e1753086825499f1aeb6415bb986f3588Dmitri Plotnikov 3324a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov protected Uri insertPostalAddress(long rawContactId, String formattedAddress) { 3334a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov ContentValues values = new ContentValues(); 3344a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov values.put(Data.RAW_CONTACT_ID, rawContactId); 3354a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov values.put(Data.MIMETYPE, StructuredPostal.CONTENT_ITEM_TYPE); 3364a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov values.put(StructuredPostal.FORMATTED_ADDRESS, formattedAddress); 3374a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov 3384a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov Uri resultUri = mResolver.insert(Data.CONTENT_URI, values); 3394a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov return resultUri; 3404a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov } 3414a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov 342eeeed5669d98897501bf2b18c88579c7effd0955Dmitri Plotnikov protected Uri insertPostalAddress(long rawContactId, ContentValues values) { 343eeeed5669d98897501bf2b18c88579c7effd0955Dmitri Plotnikov values.put(Data.RAW_CONTACT_ID, rawContactId); 344eeeed5669d98897501bf2b18c88579c7effd0955Dmitri Plotnikov values.put(Data.MIMETYPE, StructuredPostal.CONTENT_ITEM_TYPE); 345eeeed5669d98897501bf2b18c88579c7effd0955Dmitri Plotnikov Uri resultUri = mResolver.insert(Data.CONTENT_URI, values); 346eeeed5669d98897501bf2b18c88579c7effd0955Dmitri Plotnikov return resultUri; 347eeeed5669d98897501bf2b18c88579c7effd0955Dmitri Plotnikov } 348eeeed5669d98897501bf2b18c88579c7effd0955Dmitri Plotnikov 3495ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov protected Uri insertPhoto(long rawContactId) { 350ae6ca1f34cf5458d79ec803411d4308879a91e92Evan Millar ContentValues values = new ContentValues(); 3515ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov values.put(Data.RAW_CONTACT_ID, rawContactId); 352ae6ca1f34cf5458d79ec803411d4308879a91e92Evan Millar values.put(Data.MIMETYPE, Photo.CONTENT_ITEM_TYPE); 3532482dd0309794d57233d0af37a7c12fc647e7bf9Dmitri Plotnikov values.put(Photo.PHOTO, loadTestPhoto()); 354ae6ca1f34cf5458d79ec803411d4308879a91e92Evan Millar Uri resultUri = mResolver.insert(Data.CONTENT_URI, values); 355ae6ca1f34cf5458d79ec803411d4308879a91e92Evan Millar return resultUri; 356ae6ca1f34cf5458d79ec803411d4308879a91e92Evan Millar } 357ae6ca1f34cf5458d79ec803411d4308879a91e92Evan Millar 358f547fd54d7933e1c03af4a8dc10560c71c38f6b8Dave Santoro protected Uri insertPhoto(long rawContactId, int resourceId) { 359f547fd54d7933e1c03af4a8dc10560c71c38f6b8Dave Santoro ContentValues values = new ContentValues(); 360f547fd54d7933e1c03af4a8dc10560c71c38f6b8Dave Santoro values.put(Data.RAW_CONTACT_ID, rawContactId); 361f547fd54d7933e1c03af4a8dc10560c71c38f6b8Dave Santoro values.put(Data.MIMETYPE, Photo.CONTENT_ITEM_TYPE); 362f547fd54d7933e1c03af4a8dc10560c71c38f6b8Dave Santoro values.put(Photo.PHOTO, loadPhotoFromResource(resourceId, PhotoSize.ORIGINAL)); 363f547fd54d7933e1c03af4a8dc10560c71c38f6b8Dave Santoro Uri resultUri = mResolver.insert(Data.CONTENT_URI, values); 364f547fd54d7933e1c03af4a8dc10560c71c38f6b8Dave Santoro return resultUri; 365f547fd54d7933e1c03af4a8dc10560c71c38f6b8Dave Santoro } 366f547fd54d7933e1c03af4a8dc10560c71c38f6b8Dave Santoro 3675ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov protected Uri insertGroupMembership(long rawContactId, String sourceId) { 3689261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana ContentValues values = new ContentValues(); 3695ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov values.put(Data.RAW_CONTACT_ID, rawContactId); 3709261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana values.put(Data.MIMETYPE, GroupMembership.CONTENT_ITEM_TYPE); 3719261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana values.put(GroupMembership.GROUP_SOURCE_ID, sourceId); 3729261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana return mResolver.insert(Data.CONTENT_URI, values); 3739261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana } 3749261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana 3755ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov protected Uri insertGroupMembership(long rawContactId, Long groupId) { 3769261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana ContentValues values = new ContentValues(); 3775ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov values.put(Data.RAW_CONTACT_ID, rawContactId); 3789261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana values.put(Data.MIMETYPE, GroupMembership.CONTENT_ITEM_TYPE); 3799261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana values.put(GroupMembership.GROUP_ROW_ID, groupId); 3809261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana return mResolver.insert(Data.CONTENT_URI, values); 3819261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana } 3829261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana 383f266e8c568905337960b1fec5379841585af92a7Dmitri Plotnikov public void removeGroupMemberships(long rawContactId) { 384f266e8c568905337960b1fec5379841585af92a7Dmitri Plotnikov mResolver.delete(Data.CONTENT_URI, 385f266e8c568905337960b1fec5379841585af92a7Dmitri Plotnikov Data.MIMETYPE + "=? AND " + GroupMembership.RAW_CONTACT_ID + "=?", 386f266e8c568905337960b1fec5379841585af92a7Dmitri Plotnikov new String[] { GroupMembership.CONTENT_ITEM_TYPE, String.valueOf(rawContactId) }); 387f266e8c568905337960b1fec5379841585af92a7Dmitri Plotnikov } 388f266e8c568905337960b1fec5379841585af92a7Dmitri Plotnikov 38982bd858c9911dfbd8dca52dc276333768b0a429eDmitri Plotnikov protected Uri insertStatusUpdate(int protocol, String customProtocol, String handle, 390aabcd1d34a71ad06ee0a9395331540484f1ceb17Vasu Nori int presence, String status, int chatMode) { 391aabcd1d34a71ad06ee0a9395331540484f1ceb17Vasu Nori return insertStatusUpdate(protocol, customProtocol, handle, presence, status, 0, chatMode); 392a23cd5b6f478f6c9dda54173e84bd0098b9f3364Dmitri Plotnikov } 393a23cd5b6f478f6c9dda54173e84bd0098b9f3364Dmitri Plotnikov 39482bd858c9911dfbd8dca52dc276333768b0a429eDmitri Plotnikov protected Uri insertStatusUpdate(int protocol, String customProtocol, String handle, 395aabcd1d34a71ad06ee0a9395331540484f1ceb17Vasu Nori int presence, String status, long timestamp, int chatMode) { 396bc5c799a52b5bde2f273efd118ebe2228c3d8f15Evan Millar ContentValues values = new ContentValues(); 39782bd858c9911dfbd8dca52dc276333768b0a429eDmitri Plotnikov values.put(StatusUpdates.PROTOCOL, protocol); 39882bd858c9911dfbd8dca52dc276333768b0a429eDmitri Plotnikov values.put(StatusUpdates.CUSTOM_PROTOCOL, customProtocol); 39982bd858c9911dfbd8dca52dc276333768b0a429eDmitri Plotnikov values.put(StatusUpdates.IM_HANDLE, handle); 400f4015ab9ab7c26b766b5331fbf6655b8c54877eaDmitri Plotnikov return insertStatusUpdate(values, presence, status, timestamp, chatMode); 401f4015ab9ab7c26b766b5331fbf6655b8c54877eaDmitri Plotnikov } 402f4015ab9ab7c26b766b5331fbf6655b8c54877eaDmitri Plotnikov 403f4015ab9ab7c26b766b5331fbf6655b8c54877eaDmitri Plotnikov protected Uri insertStatusUpdate( 404f4015ab9ab7c26b766b5331fbf6655b8c54877eaDmitri Plotnikov long dataId, int presence, String status, long timestamp, int chatMode) { 405f4015ab9ab7c26b766b5331fbf6655b8c54877eaDmitri Plotnikov ContentValues values = new ContentValues(); 406f4015ab9ab7c26b766b5331fbf6655b8c54877eaDmitri Plotnikov values.put(StatusUpdates.DATA_ID, dataId); 407f4015ab9ab7c26b766b5331fbf6655b8c54877eaDmitri Plotnikov return insertStatusUpdate(values, presence, status, timestamp, chatMode); 408f4015ab9ab7c26b766b5331fbf6655b8c54877eaDmitri Plotnikov } 409f4015ab9ab7c26b766b5331fbf6655b8c54877eaDmitri Plotnikov 410f4015ab9ab7c26b766b5331fbf6655b8c54877eaDmitri Plotnikov private Uri insertStatusUpdate( 411f4015ab9ab7c26b766b5331fbf6655b8c54877eaDmitri Plotnikov ContentValues values, int presence, String status, long timestamp, int chatMode) { 412a23cd5b6f478f6c9dda54173e84bd0098b9f3364Dmitri Plotnikov if (presence != 0) { 41382bd858c9911dfbd8dca52dc276333768b0a429eDmitri Plotnikov values.put(StatusUpdates.PRESENCE, presence); 414aabcd1d34a71ad06ee0a9395331540484f1ceb17Vasu Nori values.put(StatusUpdates.CHAT_CAPABILITY, chatMode); 415a23cd5b6f478f6c9dda54173e84bd0098b9f3364Dmitri Plotnikov } 416a23cd5b6f478f6c9dda54173e84bd0098b9f3364Dmitri Plotnikov if (status != null) { 41782bd858c9911dfbd8dca52dc276333768b0a429eDmitri Plotnikov values.put(StatusUpdates.STATUS, status); 418a23cd5b6f478f6c9dda54173e84bd0098b9f3364Dmitri Plotnikov } 419a23cd5b6f478f6c9dda54173e84bd0098b9f3364Dmitri Plotnikov if (timestamp != 0) { 42082bd858c9911dfbd8dca52dc276333768b0a429eDmitri Plotnikov values.put(StatusUpdates.STATUS_TIMESTAMP, timestamp); 421a23cd5b6f478f6c9dda54173e84bd0098b9f3364Dmitri Plotnikov } 422bc5c799a52b5bde2f273efd118ebe2228c3d8f15Evan Millar 42382bd858c9911dfbd8dca52dc276333768b0a429eDmitri Plotnikov Uri resultUri = mResolver.insert(StatusUpdates.CONTENT_URI, values); 424bc5c799a52b5bde2f273efd118ebe2228c3d8f15Evan Millar return resultUri; 425bc5c799a52b5bde2f273efd118ebe2228c3d8f15Evan Millar } 426bc5c799a52b5bde2f273efd118ebe2228c3d8f15Evan Millar 4273b505de6c622d20d40b85b361c1437a89aef82deDaniel Lehmann protected Uri insertStreamItem(long rawContactId, ContentValues values, Account account) { 4283b505de6c622d20d40b85b361c1437a89aef82deDaniel Lehmann return mResolver.insert( 4293b505de6c622d20d40b85b361c1437a89aef82deDaniel Lehmann maybeAddAccountQueryParameters( 4303b505de6c622d20d40b85b361c1437a89aef82deDaniel Lehmann Uri.withAppendedPath( 4313b505de6c622d20d40b85b361c1437a89aef82deDaniel Lehmann ContentUris.withAppendedId(RawContacts.CONTENT_URI, rawContactId), 4323b505de6c622d20d40b85b361c1437a89aef82deDaniel Lehmann RawContacts.StreamItems.CONTENT_DIRECTORY), 4333b505de6c622d20d40b85b361c1437a89aef82deDaniel Lehmann account), 4343b505de6c622d20d40b85b361c1437a89aef82deDaniel Lehmann values); 4353b505de6c622d20d40b85b361c1437a89aef82deDaniel Lehmann } 4363b505de6c622d20d40b85b361c1437a89aef82deDaniel Lehmann 4373b505de6c622d20d40b85b361c1437a89aef82deDaniel Lehmann protected Uri insertStreamItemPhoto(long streamItemId, ContentValues values, Account account) { 4383b505de6c622d20d40b85b361c1437a89aef82deDaniel Lehmann return mResolver.insert( 4393b505de6c622d20d40b85b361c1437a89aef82deDaniel Lehmann maybeAddAccountQueryParameters( 4403b505de6c622d20d40b85b361c1437a89aef82deDaniel Lehmann Uri.withAppendedPath( 4413b505de6c622d20d40b85b361c1437a89aef82deDaniel Lehmann ContentUris.withAppendedId(StreamItems.CONTENT_URI, streamItemId), 4423b505de6c622d20d40b85b361c1437a89aef82deDaniel Lehmann StreamItems.StreamItemPhotos.CONTENT_DIRECTORY), 4433b505de6c622d20d40b85b361c1437a89aef82deDaniel Lehmann account), 4443b505de6c622d20d40b85b361c1437a89aef82deDaniel Lehmann values); 4453b505de6c622d20d40b85b361c1437a89aef82deDaniel Lehmann } 4463b505de6c622d20d40b85b361c1437a89aef82deDaniel Lehmann 4474dcd106ccc27dbbfaae86baf0cd57beb42c27cccDmitri Plotnikov protected Uri insertImHandle(long rawContactId, int protocol, String customProtocol, 4484dcd106ccc27dbbfaae86baf0cd57beb42c27cccDmitri Plotnikov String handle) { 449bc5c799a52b5bde2f273efd118ebe2228c3d8f15Evan Millar ContentValues values = new ContentValues(); 4505ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov values.put(Data.RAW_CONTACT_ID, rawContactId); 451bc5c799a52b5bde2f273efd118ebe2228c3d8f15Evan Millar values.put(Data.MIMETYPE, Im.CONTENT_ITEM_TYPE); 452bc5c799a52b5bde2f273efd118ebe2228c3d8f15Evan Millar values.put(Im.PROTOCOL, protocol); 4534dcd106ccc27dbbfaae86baf0cd57beb42c27cccDmitri Plotnikov values.put(Im.CUSTOM_PROTOCOL, customProtocol); 454bc5c799a52b5bde2f273efd118ebe2228c3d8f15Evan Millar values.put(Im.DATA, handle); 4553cebbf7141252768d3e272e049e9c5b0cb9d710eDmitri Plotnikov values.put(Im.TYPE, Im.TYPE_HOME); 456bc5c799a52b5bde2f273efd118ebe2228c3d8f15Evan Millar 457bc5c799a52b5bde2f273efd118ebe2228c3d8f15Evan Millar Uri resultUri = mResolver.insert(Data.CONTENT_URI, values); 458bc5c799a52b5bde2f273efd118ebe2228c3d8f15Evan Millar return resultUri; 459bc5c799a52b5bde2f273efd118ebe2228c3d8f15Evan Millar } 460bc5c799a52b5bde2f273efd118ebe2228c3d8f15Evan Millar 4616d9702cec82fd27a1c3093c64df9dcc22744899aDmitri Plotnikov protected Uri insertEvent(long rawContactId, int type, String date) { 4626d9702cec82fd27a1c3093c64df9dcc22744899aDmitri Plotnikov ContentValues values = new ContentValues(); 4636d9702cec82fd27a1c3093c64df9dcc22744899aDmitri Plotnikov values.put(Data.RAW_CONTACT_ID, rawContactId); 4646d9702cec82fd27a1c3093c64df9dcc22744899aDmitri Plotnikov values.put(Data.MIMETYPE, Event.CONTENT_ITEM_TYPE); 4656d9702cec82fd27a1c3093c64df9dcc22744899aDmitri Plotnikov values.put(Event.TYPE, type); 4666d9702cec82fd27a1c3093c64df9dcc22744899aDmitri Plotnikov values.put(Event.START_DATE, date); 4676d9702cec82fd27a1c3093c64df9dcc22744899aDmitri Plotnikov Uri resultUri = mResolver.insert(Data.CONTENT_URI, values); 4686d9702cec82fd27a1c3093c64df9dcc22744899aDmitri Plotnikov return resultUri; 4696d9702cec82fd27a1c3093c64df9dcc22744899aDmitri Plotnikov } 4706d9702cec82fd27a1c3093c64df9dcc22744899aDmitri Plotnikov 4716d9702cec82fd27a1c3093c64df9dcc22744899aDmitri Plotnikov protected Uri insertNote(long rawContactId, String note) { 4726d9702cec82fd27a1c3093c64df9dcc22744899aDmitri Plotnikov ContentValues values = new ContentValues(); 4736d9702cec82fd27a1c3093c64df9dcc22744899aDmitri Plotnikov values.put(Data.RAW_CONTACT_ID, rawContactId); 4746d9702cec82fd27a1c3093c64df9dcc22744899aDmitri Plotnikov values.put(Data.MIMETYPE, Note.CONTENT_ITEM_TYPE); 4756d9702cec82fd27a1c3093c64df9dcc22744899aDmitri Plotnikov values.put(Note.NOTE, note); 4766d9702cec82fd27a1c3093c64df9dcc22744899aDmitri Plotnikov Uri resultUri = mResolver.insert(Data.CONTENT_URI, values); 4776d9702cec82fd27a1c3093c64df9dcc22744899aDmitri Plotnikov return resultUri; 4786d9702cec82fd27a1c3093c64df9dcc22744899aDmitri Plotnikov } 4796d9702cec82fd27a1c3093c64df9dcc22744899aDmitri Plotnikov 480767e109d6f08749b9ed202c0b71f3459eaae2115Dmitri Plotnikov protected void setContactAccount(long rawContactId, String accountType, String accountName) { 481ae6ca1f34cf5458d79ec803411d4308879a91e92Evan Millar ContentValues values = new ContentValues(); 482767e109d6f08749b9ed202c0b71f3459eaae2115Dmitri Plotnikov values.put(RawContacts.ACCOUNT_TYPE, accountType); 4836cffee46a1334d2b3ed19f436b27638451541044Dmitri Plotnikov values.put(RawContacts.ACCOUNT_NAME, accountName); 484ae6ca1f34cf5458d79ec803411d4308879a91e92Evan Millar 485ae6ca1f34cf5458d79ec803411d4308879a91e92Evan Millar mResolver.update(ContentUris.withAppendedId( 4865ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov RawContacts.CONTENT_URI, rawContactId), values, null, null); 487ae6ca1f34cf5458d79ec803411d4308879a91e92Evan Millar } 488ae6ca1f34cf5458d79ec803411d4308879a91e92Evan Millar 4890c0adda32be5de3acf392ab715cff468b6b340f8Dmitri Plotnikov protected void setAggregationException(int type, long rawContactId1, long rawContactId2) { 490d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov ContentValues values = new ContentValues(); 4910c0adda32be5de3acf392ab715cff468b6b340f8Dmitri Plotnikov values.put(AggregationExceptions.RAW_CONTACT_ID1, rawContactId1); 4920c0adda32be5de3acf392ab715cff468b6b340f8Dmitri Plotnikov values.put(AggregationExceptions.RAW_CONTACT_ID2, rawContactId2); 493d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov values.put(AggregationExceptions.TYPE, type); 4943d8b043c3341a5b6c2e781b7eba9767d5cd13267Dmitri Plotnikov assertEquals(1, mResolver.update(AggregationExceptions.CONTENT_URI, values, null, null)); 495d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov } 496d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov 497d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov protected Cursor queryRawContact(long rawContactId) { 4980c0adda32be5de3acf392ab715cff468b6b340f8Dmitri Plotnikov return mResolver.query(ContentUris.withAppendedId(RawContacts.CONTENT_URI, rawContactId), 4990c0adda32be5de3acf392ab715cff468b6b340f8Dmitri Plotnikov null, null, null, null); 500d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov } 501d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov 502d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov protected Cursor queryContact(long contactId) { 503d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov return mResolver.query(ContentUris.withAppendedId(Contacts.CONTENT_URI, contactId), 504d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov null, null, null, null); 505d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov } 506d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov 507af088aeb51685eed17580edc04b495d12232ecf9Dmitri Plotnikov protected Cursor queryContact(long contactId, String[] projection) { 508af088aeb51685eed17580edc04b495d12232ecf9Dmitri Plotnikov return mResolver.query(ContentUris.withAppendedId(Contacts.CONTENT_URI, contactId), 509af088aeb51685eed17580edc04b495d12232ecf9Dmitri Plotnikov projection, null, null, null); 510bc5c799a52b5bde2f273efd118ebe2228c3d8f15Evan Millar } 511bc5c799a52b5bde2f273efd118ebe2228c3d8f15Evan Millar 512f4015ab9ab7c26b766b5331fbf6655b8c54877eaDmitri Plotnikov protected Uri getContactUriForRawContact(long rawContactId) { 513f4015ab9ab7c26b766b5331fbf6655b8c54877eaDmitri Plotnikov return ContentUris.withAppendedId(Contacts.CONTENT_URI, queryContactId(rawContactId)); 514f4015ab9ab7c26b766b5331fbf6655b8c54877eaDmitri Plotnikov } 515f4015ab9ab7c26b766b5331fbf6655b8c54877eaDmitri Plotnikov 516d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov protected long queryContactId(long rawContactId) { 517d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov Cursor c = queryRawContact(rawContactId); 518d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov assertTrue(c.moveToFirst()); 519d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov long contactId = c.getLong(c.getColumnIndex(RawContacts.CONTACT_ID)); 520d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov c.close(); 521d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov return contactId; 522d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov } 523d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov 524d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov protected long queryPhotoId(long contactId) { 525d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov Cursor c = queryContact(contactId); 526ae6ca1f34cf5458d79ec803411d4308879a91e92Evan Millar assertTrue(c.moveToFirst()); 527d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov long photoId = c.getInt(c.getColumnIndex(Contacts.PHOTO_ID)); 528ae6ca1f34cf5458d79ec803411d4308879a91e92Evan Millar c.close(); 529ae6ca1f34cf5458d79ec803411d4308879a91e92Evan Millar return photoId; 530ae6ca1f34cf5458d79ec803411d4308879a91e92Evan Millar } 531ae6ca1f34cf5458d79ec803411d4308879a91e92Evan Millar 53287614d7d293b1519dc1f0f403fd59c8bf4d8a347Dave Santoro protected long queryPhotoFileId(long contactId) { 53387614d7d293b1519dc1f0f403fd59c8bf4d8a347Dave Santoro return getStoredLongValue(ContentUris.withAppendedId(Contacts.CONTENT_URI, contactId), 53487614d7d293b1519dc1f0f403fd59c8bf4d8a347Dave Santoro Contacts.PHOTO_FILE_ID); 53587614d7d293b1519dc1f0f403fd59c8bf4d8a347Dave Santoro } 53687614d7d293b1519dc1f0f403fd59c8bf4d8a347Dave Santoro 537dd5c25c65f09ada246c826fb6d04f0b6d4cf4388Fred Quintana protected boolean queryRawContactIsStarred(long rawContactId) { 538dd5c25c65f09ada246c826fb6d04f0b6d4cf4388Fred Quintana Cursor c = queryRawContact(rawContactId); 539dd5c25c65f09ada246c826fb6d04f0b6d4cf4388Fred Quintana try { 540dd5c25c65f09ada246c826fb6d04f0b6d4cf4388Fred Quintana assertTrue(c.moveToFirst()); 541dd5c25c65f09ada246c826fb6d04f0b6d4cf4388Fred Quintana return c.getLong(c.getColumnIndex(RawContacts.STARRED)) != 0; 542dd5c25c65f09ada246c826fb6d04f0b6d4cf4388Fred Quintana } finally { 543dd5c25c65f09ada246c826fb6d04f0b6d4cf4388Fred Quintana c.close(); 544dd5c25c65f09ada246c826fb6d04f0b6d4cf4388Fred Quintana } 545dd5c25c65f09ada246c826fb6d04f0b6d4cf4388Fred Quintana } 546dd5c25c65f09ada246c826fb6d04f0b6d4cf4388Fred Quintana 547d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov protected String queryDisplayName(long contactId) { 548d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov Cursor c = queryContact(contactId); 549d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov assertTrue(c.moveToFirst()); 550d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov String displayName = c.getString(c.getColumnIndex(Contacts.DISPLAY_NAME)); 551d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov c.close(); 552d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov return displayName; 553d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov } 554d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov 5552149ab82f021c204618d0d3644e261fd7a8d8490Dmitri Plotnikov protected String queryLookupKey(long contactId) { 5562d2ec88b7af615b2f05e987da45425be9cace1baTom O'Neill Cursor c = queryContact(contactId); 5572d2ec88b7af615b2f05e987da45425be9cace1baTom O'Neill assertTrue(c.moveToFirst()); 5582d2ec88b7af615b2f05e987da45425be9cace1baTom O'Neill String lookupKey = c.getString(c.getColumnIndex(Contacts.LOOKUP_KEY)); 5592d2ec88b7af615b2f05e987da45425be9cace1baTom O'Neill c.close(); 5602d2ec88b7af615b2f05e987da45425be9cace1baTom O'Neill return lookupKey; 5612d2ec88b7af615b2f05e987da45425be9cace1baTom O'Neill } 5622d2ec88b7af615b2f05e987da45425be9cace1baTom O'Neill 563d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov protected void assertAggregated(long rawContactId1, long rawContactId2) { 564d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov long contactId1 = queryContactId(rawContactId1); 565d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov long contactId2 = queryContactId(rawContactId2); 566d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov assertTrue(contactId1 == contactId2); 567bf659107617a6291ba8bfeebc3f2e50138075ab5Dmitri Plotnikov } 568bf659107617a6291ba8bfeebc3f2e50138075ab5Dmitri Plotnikov 569d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov protected void assertAggregated(long rawContactId1, long rawContactId2, 570d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov String expectedDisplayName) { 571d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov long contactId1 = queryContactId(rawContactId1); 572d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov long contactId2 = queryContactId(rawContactId2); 573d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov assertTrue(contactId1 == contactId2); 574d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov 575d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov String displayName = queryDisplayName(contactId1); 576d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov assertEquals(expectedDisplayName, displayName); 577d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov } 578d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov 579d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov protected void assertNotAggregated(long rawContactId1, long rawContactId2) { 580d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov long contactId1 = queryContactId(rawContactId1); 581d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov long contactId2 = queryContactId(rawContactId2); 582d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov assertTrue(contactId1 != contactId2); 583d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov } 5844097855e2d672b3f8e1c5c8a169efb80203bf53eDmitri Plotnikov 5855ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov protected void assertStructuredName(long rawContactId, String prefix, String givenName, 5864097855e2d672b3f8e1c5c8a169efb80203bf53eDmitri Plotnikov String middleName, String familyName, String suffix) { 587f266e8c568905337960b1fec5379841585af92a7Dmitri Plotnikov Uri uri = Uri.withAppendedPath( 588f266e8c568905337960b1fec5379841585af92a7Dmitri Plotnikov ContentUris.withAppendedId(RawContacts.CONTENT_URI, rawContactId), 5896cffee46a1334d2b3ed19f436b27638451541044Dmitri Plotnikov RawContacts.Data.CONTENT_DIRECTORY); 5904097855e2d672b3f8e1c5c8a169efb80203bf53eDmitri Plotnikov 5914097855e2d672b3f8e1c5c8a169efb80203bf53eDmitri Plotnikov final String[] projection = new String[] { 5924097855e2d672b3f8e1c5c8a169efb80203bf53eDmitri Plotnikov StructuredName.PREFIX, StructuredName.GIVEN_NAME, StructuredName.MIDDLE_NAME, 5934097855e2d672b3f8e1c5c8a169efb80203bf53eDmitri Plotnikov StructuredName.FAMILY_NAME, StructuredName.SUFFIX 5944097855e2d672b3f8e1c5c8a169efb80203bf53eDmitri Plotnikov }; 5954097855e2d672b3f8e1c5c8a169efb80203bf53eDmitri Plotnikov 5964097855e2d672b3f8e1c5c8a169efb80203bf53eDmitri Plotnikov Cursor c = mResolver.query(uri, projection, Data.MIMETYPE + "='" 5974097855e2d672b3f8e1c5c8a169efb80203bf53eDmitri Plotnikov + StructuredName.CONTENT_ITEM_TYPE + "'", null, null); 5984097855e2d672b3f8e1c5c8a169efb80203bf53eDmitri Plotnikov 5994097855e2d672b3f8e1c5c8a169efb80203bf53eDmitri Plotnikov assertTrue(c.moveToFirst()); 6004097855e2d672b3f8e1c5c8a169efb80203bf53eDmitri Plotnikov assertEquals(prefix, c.getString(0)); 6014097855e2d672b3f8e1c5c8a169efb80203bf53eDmitri Plotnikov assertEquals(givenName, c.getString(1)); 6024097855e2d672b3f8e1c5c8a169efb80203bf53eDmitri Plotnikov assertEquals(middleName, c.getString(2)); 6034097855e2d672b3f8e1c5c8a169efb80203bf53eDmitri Plotnikov assertEquals(familyName, c.getString(3)); 6044097855e2d672b3f8e1c5c8a169efb80203bf53eDmitri Plotnikov assertEquals(suffix, c.getString(4)); 6054097855e2d672b3f8e1c5c8a169efb80203bf53eDmitri Plotnikov c.close(); 6064097855e2d672b3f8e1c5c8a169efb80203bf53eDmitri Plotnikov } 6079261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana 6089261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana protected long assertSingleGroup(Long rowId, Account account, String sourceId, String title) { 6099261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana Cursor c = mResolver.query(Groups.CONTENT_URI, null, null, null, null); 6109261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana try { 6119261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana assertTrue(c.moveToNext()); 6129261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana long actualRowId = assertGroup(c, rowId, account, sourceId, title); 6139261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana assertFalse(c.moveToNext()); 6149261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana return actualRowId; 6159261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana } finally { 6169261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana c.close(); 6179261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana } 6189261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana } 6199261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana 6205ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov protected long assertSingleGroupMembership(Long rowId, Long rawContactId, Long groupRowId, 6219261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana String sourceId) { 6229261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana Cursor c = mResolver.query(ContactsContract.Data.CONTENT_URI, null, null, null, null); 6239261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana try { 6249261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana assertTrue(c.moveToNext()); 6255ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov long actualRowId = assertGroupMembership(c, rowId, rawContactId, groupRowId, sourceId); 6269261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana assertFalse(c.moveToNext()); 6279261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana return actualRowId; 6289261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana } finally { 6299261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana c.close(); 6309261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana } 6319261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana } 6329261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana 6335ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov protected long assertGroupMembership(Cursor c, Long rowId, Long rawContactId, Long groupRowId, 6349261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana String sourceId) { 6359261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana assertNullOrEquals(c, rowId, Data._ID); 6365ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov assertNullOrEquals(c, rawContactId, GroupMembership.RAW_CONTACT_ID); 6379261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana assertNullOrEquals(c, groupRowId, GroupMembership.GROUP_ROW_ID); 6389261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana assertNullOrEquals(c, sourceId, GroupMembership.GROUP_SOURCE_ID); 6399261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana return c.getLong(c.getColumnIndexOrThrow("_id")); 6409261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana } 6419261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana 6429261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana protected long assertGroup(Cursor c, Long rowId, Account account, String sourceId, String title) { 6439261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana assertNullOrEquals(c, rowId, Groups._ID); 6449261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana assertNullOrEquals(c, account); 6459261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana assertNullOrEquals(c, sourceId, Groups.SOURCE_ID); 6469261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana assertNullOrEquals(c, title, Groups.TITLE); 6479261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana return c.getLong(c.getColumnIndexOrThrow("_id")); 6489261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana } 6499261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana 6509261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana private void assertNullOrEquals(Cursor c, Account account) { 6519261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana if (account == NO_ACCOUNT) { 6529261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana return; 6539261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana } 6549261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana if (account == null) { 6559261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana assertTrue(c.isNull(c.getColumnIndexOrThrow(Groups.ACCOUNT_NAME))); 6569261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana assertTrue(c.isNull(c.getColumnIndexOrThrow(Groups.ACCOUNT_TYPE))); 6579261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana } else { 658df9fd6b239de5829b04cb413e4dfa3e6da649c38Fred Quintana assertEquals(account.name, c.getString(c.getColumnIndexOrThrow(Groups.ACCOUNT_NAME))); 659df9fd6b239de5829b04cb413e4dfa3e6da649c38Fred Quintana assertEquals(account.type, c.getString(c.getColumnIndexOrThrow(Groups.ACCOUNT_TYPE))); 6609261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana } 6619261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana } 6629261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana 6639261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana private void assertNullOrEquals(Cursor c, Long value, String columnName) { 6649261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana if (value != NO_LONG) { 6659261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana if (value == null) assertTrue(c.isNull(c.getColumnIndexOrThrow(columnName))); 6669261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana else assertEquals((long) value, c.getLong(c.getColumnIndexOrThrow(columnName))); 6679261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana } 6689261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana } 6699261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana 6709261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana private void assertNullOrEquals(Cursor c, String value, String columnName) { 6719261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana if (value != NO_STRING) { 6729261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana if (value == null) assertTrue(c.isNull(c.getColumnIndexOrThrow(columnName))); 6739261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana else assertEquals(value, c.getString(c.getColumnIndexOrThrow(columnName))); 6749261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana } 6759261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana } 6769261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana 6779261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana protected void assertDataRow(ContentValues actual, String expectedMimetype, 6789261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana Object... expectedArguments) { 6799261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana assertEquals(actual.toString(), expectedMimetype, actual.getAsString(Data.MIMETYPE)); 6809261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana for (int i = 0; i < expectedArguments.length; i += 2) { 6819261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana String columnName = (String) expectedArguments[i]; 6829261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana Object expectedValue = expectedArguments[i + 1]; 6839261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana if (expectedValue instanceof Uri) { 6849261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana expectedValue = ContentUris.parseId((Uri) expectedValue); 6859261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana } 6869261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana if (expectedValue == null) { 6879261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana assertNull(actual.toString(), actual.get(columnName)); 6889261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana } 6899261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana if (expectedValue instanceof Long) { 690226c3dc6e93ca76a84c99100caa31045cba06cf6Fred Quintana assertEquals("mismatch at " + columnName + " from " + actual.toString(), 691226c3dc6e93ca76a84c99100caa31045cba06cf6Fred Quintana expectedValue, actual.getAsLong(columnName)); 6929261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana } else if (expectedValue instanceof Integer) { 693226c3dc6e93ca76a84c99100caa31045cba06cf6Fred Quintana assertEquals("mismatch at " + columnName + " from " + actual.toString(), 694226c3dc6e93ca76a84c99100caa31045cba06cf6Fred Quintana expectedValue, actual.getAsInteger(columnName)); 6959261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana } else if (expectedValue instanceof String) { 696226c3dc6e93ca76a84c99100caa31045cba06cf6Fred Quintana assertEquals("mismatch at " + columnName + " from " + actual.toString(), 697226c3dc6e93ca76a84c99100caa31045cba06cf6Fred Quintana expectedValue, actual.getAsString(columnName)); 6989261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana } else { 699226c3dc6e93ca76a84c99100caa31045cba06cf6Fred Quintana assertEquals("mismatch at " + columnName + " from " + actual.toString(), 700226c3dc6e93ca76a84c99100caa31045cba06cf6Fred Quintana expectedValue, actual.get(columnName)); 7019261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana } 7029261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana } 7039261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana } 7049261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana 705dd5c25c65f09ada246c826fb6d04f0b6d4cf4388Fred Quintana protected void assertNoRowsAndClose(Cursor c) { 706dd5c25c65f09ada246c826fb6d04f0b6d4cf4388Fred Quintana try { 707dd5c25c65f09ada246c826fb6d04f0b6d4cf4388Fred Quintana assertFalse(c.moveToNext()); 708dd5c25c65f09ada246c826fb6d04f0b6d4cf4388Fred Quintana } finally { 709dd5c25c65f09ada246c826fb6d04f0b6d4cf4388Fred Quintana c.close(); 710dd5c25c65f09ada246c826fb6d04f0b6d4cf4388Fred Quintana } 711dd5c25c65f09ada246c826fb6d04f0b6d4cf4388Fred Quintana } 712dd5c25c65f09ada246c826fb6d04f0b6d4cf4388Fred Quintana 7139261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana protected static class IdComparator implements Comparator<ContentValues> { 71459f6477e10203617f504857f7e9aee2fda393f4fDebashish Chatterjee @Override 7159261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana public int compare(ContentValues o1, ContentValues o2) { 7169261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana long id1 = o1.getAsLong(ContactsContract.Data._ID); 7179261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana long id2 = o2.getAsLong(ContactsContract.Data._ID); 7189261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana if (id1 == id2) return 0; 7199261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana return (id1 < id2) ? -1 : 1; 7209261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana } 7219261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana } 7229261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana 7239261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana protected ContentValues[] asSortedContentValuesArray( 7249261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana ArrayList<Entity.NamedContentValues> subValues) { 7259261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana ContentValues[] result = new ContentValues[subValues.size()]; 7269261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana int i = 0; 7279261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana for (Entity.NamedContentValues subValue : subValues) { 7289261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana result[i] = subValue.values; 7299261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana i++; 7309261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana } 7319261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana Arrays.sort(result, new IdComparator()); 7329261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana return result; 7339261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana } 7349261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana 7359261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana protected void assertDirty(Uri uri, boolean state) { 7369261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana Cursor c = mResolver.query(uri, new String[]{"dirty"}, null, null, null); 7379261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana assertTrue(c.moveToNext()); 7389261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana assertEquals(state, c.getLong(0) != 0); 7399261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana assertFalse(c.moveToNext()); 7403cfe8d532d509fbbe605454e3a32b2361b7e1501Dmitri Plotnikov c.close(); 7419261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana } 7429261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana 7439261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana protected long getVersion(Uri uri) { 7449261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana Cursor c = mResolver.query(uri, new String[]{"version"}, null, null, null); 7459261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana assertTrue(c.moveToNext()); 7469261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana long version = c.getLong(0); 7479261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana assertFalse(c.moveToNext()); 7483cfe8d532d509fbbe605454e3a32b2361b7e1501Dmitri Plotnikov c.close(); 7499261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana return version; 7509261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana } 7519261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana 7529261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana protected void clearDirty(Uri uri) { 7539261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana ContentValues values = new ContentValues(); 7549261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana values.put("dirty", 0); 7559261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana mResolver.update(uri, values, null, null); 7569261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana } 75720a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov 7585870f2dcc2ac7715b2c078a886ee346622e7887eDmitri Plotnikov protected void storeValue(Uri contentUri, long id, String column, String value) { 759f5a847e8c93db02f3334dbc276debd90bdea5658Dmitri Plotnikov storeValue(ContentUris.withAppendedId(contentUri, id), column, value); 760f5a847e8c93db02f3334dbc276debd90bdea5658Dmitri Plotnikov } 761f5a847e8c93db02f3334dbc276debd90bdea5658Dmitri Plotnikov 762f5a847e8c93db02f3334dbc276debd90bdea5658Dmitri Plotnikov protected void storeValue(Uri contentUri, String column, String value) { 763f5a847e8c93db02f3334dbc276debd90bdea5658Dmitri Plotnikov ContentValues values = new ContentValues(); 764f5a847e8c93db02f3334dbc276debd90bdea5658Dmitri Plotnikov values.put(column, value); 765f5a847e8c93db02f3334dbc276debd90bdea5658Dmitri Plotnikov 766f5a847e8c93db02f3334dbc276debd90bdea5658Dmitri Plotnikov mResolver.update(contentUri, values, null, null); 767f5a847e8c93db02f3334dbc276debd90bdea5658Dmitri Plotnikov } 768f5a847e8c93db02f3334dbc276debd90bdea5658Dmitri Plotnikov 769f5a847e8c93db02f3334dbc276debd90bdea5658Dmitri Plotnikov protected void storeValue(Uri contentUri, long id, String column, long value) { 770f5a847e8c93db02f3334dbc276debd90bdea5658Dmitri Plotnikov storeValue(ContentUris.withAppendedId(contentUri, id), column, value); 771f5a847e8c93db02f3334dbc276debd90bdea5658Dmitri Plotnikov } 772f5a847e8c93db02f3334dbc276debd90bdea5658Dmitri Plotnikov 773f5a847e8c93db02f3334dbc276debd90bdea5658Dmitri Plotnikov protected void storeValue(Uri contentUri, String column, long value) { 7745870f2dcc2ac7715b2c078a886ee346622e7887eDmitri Plotnikov ContentValues values = new ContentValues(); 7755870f2dcc2ac7715b2c078a886ee346622e7887eDmitri Plotnikov values.put(column, value); 7765870f2dcc2ac7715b2c078a886ee346622e7887eDmitri Plotnikov 777f5a847e8c93db02f3334dbc276debd90bdea5658Dmitri Plotnikov mResolver.update(contentUri, values, null, null); 7785870f2dcc2ac7715b2c078a886ee346622e7887eDmitri Plotnikov } 7795870f2dcc2ac7715b2c078a886ee346622e7887eDmitri Plotnikov 780f01c876a92b9c950a0450ed8b706ac5eb2c9b660Dmitri Plotnikov protected void assertStoredValue(Uri contentUri, long id, String column, Object expectedValue) { 781f01c876a92b9c950a0450ed8b706ac5eb2c9b660Dmitri Plotnikov assertStoredValue(ContentUris.withAppendedId(contentUri, id), column, expectedValue); 782f01c876a92b9c950a0450ed8b706ac5eb2c9b660Dmitri Plotnikov } 783f01c876a92b9c950a0450ed8b706ac5eb2c9b660Dmitri Plotnikov 7845870f2dcc2ac7715b2c078a886ee346622e7887eDmitri Plotnikov protected void assertStoredValue(Uri rowUri, String column, Object expectedValue) { 78520a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov String value = getStoredValue(rowUri, column); 78601911fa9cfa21f198fd767eedde072acbb879f28Dmitri Plotnikov if (expectedValue == null) { 78701911fa9cfa21f198fd767eedde072acbb879f28Dmitri Plotnikov assertNull("Column value " + column, value); 78801911fa9cfa21f198fd767eedde072acbb879f28Dmitri Plotnikov } else { 78901911fa9cfa21f198fd767eedde072acbb879f28Dmitri Plotnikov assertEquals("Column value " + column, String.valueOf(expectedValue), value); 79001911fa9cfa21f198fd767eedde072acbb879f28Dmitri Plotnikov } 79120a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov } 79220a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov 79389c626eb655440c86a2e5df076e83708c1b32c17Dmitri Plotnikov protected void assertStoredValue(Uri rowUri, String selection, String[] selectionArgs, 79489c626eb655440c86a2e5df076e83708c1b32c17Dmitri Plotnikov String column, Object expectedValue) { 79589c626eb655440c86a2e5df076e83708c1b32c17Dmitri Plotnikov String value = getStoredValue(rowUri, selection, selectionArgs, column); 79689c626eb655440c86a2e5df076e83708c1b32c17Dmitri Plotnikov if (expectedValue == null) { 79789c626eb655440c86a2e5df076e83708c1b32c17Dmitri Plotnikov assertNull("Column value " + column, value); 79889c626eb655440c86a2e5df076e83708c1b32c17Dmitri Plotnikov } else { 79989c626eb655440c86a2e5df076e83708c1b32c17Dmitri Plotnikov assertEquals("Column value " + column, String.valueOf(expectedValue), value); 80089c626eb655440c86a2e5df076e83708c1b32c17Dmitri Plotnikov } 80189c626eb655440c86a2e5df076e83708c1b32c17Dmitri Plotnikov } 80289c626eb655440c86a2e5df076e83708c1b32c17Dmitri Plotnikov 80320a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov protected String getStoredValue(Uri rowUri, String column) { 80489c626eb655440c86a2e5df076e83708c1b32c17Dmitri Plotnikov return getStoredValue(rowUri, null, null, column); 80589c626eb655440c86a2e5df076e83708c1b32c17Dmitri Plotnikov } 80689c626eb655440c86a2e5df076e83708c1b32c17Dmitri Plotnikov 80789c626eb655440c86a2e5df076e83708c1b32c17Dmitri Plotnikov protected String getStoredValue(Uri uri, String selection, String[] selectionArgs, 80889c626eb655440c86a2e5df076e83708c1b32c17Dmitri Plotnikov String column) { 8098e45e5f2142db78941b095f7418cc05b71668094Dmitri Plotnikov String value = null; 81089c626eb655440c86a2e5df076e83708c1b32c17Dmitri Plotnikov Cursor c = mResolver.query(uri, new String[] { column }, selection, selectionArgs, null); 81120a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov try { 81292ddc5cdc4d89ee2c6e861ae7b3a3a913ffa0100Dmitri Plotnikov assertEquals("Record count", 1, c.getCount()); 81392ddc5cdc4d89ee2c6e861ae7b3a3a913ffa0100Dmitri Plotnikov 8148e45e5f2142db78941b095f7418cc05b71668094Dmitri Plotnikov if (c.moveToFirst()) { 8158e45e5f2142db78941b095f7418cc05b71668094Dmitri Plotnikov value = c.getString(c.getColumnIndex(column)); 8168e45e5f2142db78941b095f7418cc05b71668094Dmitri Plotnikov } 81720a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov } finally { 81820a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov c.close(); 81920a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov } 82020a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov return value; 82120a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov } 82220a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov 8232f830d3bb66f780937203e9738e046841a070e73Daisuke Miyakawa protected Long getStoredLongValue(Uri uri, String selection, String[] selectionArgs, 8242f830d3bb66f780937203e9738e046841a070e73Daisuke Miyakawa String column) { 8252f830d3bb66f780937203e9738e046841a070e73Daisuke Miyakawa Long value = null; 8262f830d3bb66f780937203e9738e046841a070e73Daisuke Miyakawa Cursor c = mResolver.query(uri, new String[] { column }, selection, selectionArgs, null); 8272f830d3bb66f780937203e9738e046841a070e73Daisuke Miyakawa try { 8282f830d3bb66f780937203e9738e046841a070e73Daisuke Miyakawa assertEquals("Record count", 1, c.getCount()); 8292f830d3bb66f780937203e9738e046841a070e73Daisuke Miyakawa 8302f830d3bb66f780937203e9738e046841a070e73Daisuke Miyakawa if (c.moveToFirst()) { 8312f830d3bb66f780937203e9738e046841a070e73Daisuke Miyakawa value = c.getLong(c.getColumnIndex(column)); 8322f830d3bb66f780937203e9738e046841a070e73Daisuke Miyakawa } 8332f830d3bb66f780937203e9738e046841a070e73Daisuke Miyakawa } finally { 8342f830d3bb66f780937203e9738e046841a070e73Daisuke Miyakawa c.close(); 8352f830d3bb66f780937203e9738e046841a070e73Daisuke Miyakawa } 8362f830d3bb66f780937203e9738e046841a070e73Daisuke Miyakawa return value; 8372f830d3bb66f780937203e9738e046841a070e73Daisuke Miyakawa } 8382f830d3bb66f780937203e9738e046841a070e73Daisuke Miyakawa 839f547fd54d7933e1c03af4a8dc10560c71c38f6b8Dave Santoro protected Long getStoredLongValue(Uri uri, String column) { 840f547fd54d7933e1c03af4a8dc10560c71c38f6b8Dave Santoro return getStoredLongValue(uri, null, null, column); 841f547fd54d7933e1c03af4a8dc10560c71c38f6b8Dave Santoro } 842f547fd54d7933e1c03af4a8dc10560c71c38f6b8Dave Santoro 84320a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov protected void assertStoredValues(Uri rowUri, ContentValues expectedValues) { 844bce6ee29f2d971ceae2bfce85a06bb3ecec6537aDmitri Plotnikov assertStoredValues(rowUri, null, null, expectedValues); 845bce6ee29f2d971ceae2bfce85a06bb3ecec6537aDmitri Plotnikov } 846bce6ee29f2d971ceae2bfce85a06bb3ecec6537aDmitri Plotnikov 847892a3d9ded5c64a63ae3d5d5c52c59528b466c93Dmitri Plotnikov protected void assertStoredValues(Uri rowUri, ContentValues[] expectedValues) { 848892a3d9ded5c64a63ae3d5d5c52c59528b466c93Dmitri Plotnikov assertStoredValues(rowUri, null, null, expectedValues); 849892a3d9ded5c64a63ae3d5d5c52c59528b466c93Dmitri Plotnikov } 850892a3d9ded5c64a63ae3d5d5c52c59528b466c93Dmitri Plotnikov 851bce6ee29f2d971ceae2bfce85a06bb3ecec6537aDmitri Plotnikov protected void assertStoredValues(Uri rowUri, String selection, String[] selectionArgs, 852bce6ee29f2d971ceae2bfce85a06bb3ecec6537aDmitri Plotnikov ContentValues expectedValues) { 853bce6ee29f2d971ceae2bfce85a06bb3ecec6537aDmitri Plotnikov Cursor c = mResolver.query(rowUri, null, selection, selectionArgs, null); 85420a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov try { 85520a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov assertEquals("Record count", 1, c.getCount()); 85620a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov c.moveToFirst(); 85720a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov assertCursorValues(c, expectedValues); 85820a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov } finally { 85920a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov c.close(); 86020a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov } 86120a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov } 86220a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov 863ff2de103f7e3eeeff4665ef63f07460fef053d6dDmitri Plotnikov protected void assertStoredValuesWithProjection(Uri rowUri, ContentValues expectedValues) { 864ff2de103f7e3eeeff4665ef63f07460fef053d6dDmitri Plotnikov Cursor c = mResolver.query(rowUri, buildProjection(expectedValues), null, null, null); 865ff2de103f7e3eeeff4665ef63f07460fef053d6dDmitri Plotnikov try { 866ff2de103f7e3eeeff4665ef63f07460fef053d6dDmitri Plotnikov assertEquals("Record count", 1, c.getCount()); 867ff2de103f7e3eeeff4665ef63f07460fef053d6dDmitri Plotnikov c.moveToFirst(); 868ff2de103f7e3eeeff4665ef63f07460fef053d6dDmitri Plotnikov assertCursorValues(c, expectedValues); 869ff2de103f7e3eeeff4665ef63f07460fef053d6dDmitri Plotnikov } finally { 870ff2de103f7e3eeeff4665ef63f07460fef053d6dDmitri Plotnikov c.close(); 871ff2de103f7e3eeeff4665ef63f07460fef053d6dDmitri Plotnikov } 872ff2de103f7e3eeeff4665ef63f07460fef053d6dDmitri Plotnikov } 873ff2de103f7e3eeeff4665ef63f07460fef053d6dDmitri Plotnikov 874892a3d9ded5c64a63ae3d5d5c52c59528b466c93Dmitri Plotnikov protected void assertStoredValues( 875892a3d9ded5c64a63ae3d5d5c52c59528b466c93Dmitri Plotnikov Uri rowUri, String selection, String[] selectionArgs, ContentValues[] expectedValues) { 876892a3d9ded5c64a63ae3d5d5c52c59528b466c93Dmitri Plotnikov Cursor c = mResolver.query(rowUri, null, selection, selectionArgs, null); 877892a3d9ded5c64a63ae3d5d5c52c59528b466c93Dmitri Plotnikov try { 878892a3d9ded5c64a63ae3d5d5c52c59528b466c93Dmitri Plotnikov assertEquals("Record count", expectedValues.length, c.getCount()); 879892a3d9ded5c64a63ae3d5d5c52c59528b466c93Dmitri Plotnikov assertCursorValues(c, expectedValues); 880892a3d9ded5c64a63ae3d5d5c52c59528b466c93Dmitri Plotnikov } finally { 881892a3d9ded5c64a63ae3d5d5c52c59528b466c93Dmitri Plotnikov c.close(); 882892a3d9ded5c64a63ae3d5d5c52c59528b466c93Dmitri Plotnikov } 883892a3d9ded5c64a63ae3d5d5c52c59528b466c93Dmitri Plotnikov } 884892a3d9ded5c64a63ae3d5d5c52c59528b466c93Dmitri Plotnikov 8857d82ae92714f2132e3a0971d844ae8cdf10d76e7Daisuke Miyakawa protected void assertStoredValuesOrderly(Uri rowUri, ContentValues[] expectedValues) { 8867d82ae92714f2132e3a0971d844ae8cdf10d76e7Daisuke Miyakawa assertStoredValuesOrderly(rowUri, null, null, expectedValues); 8877d82ae92714f2132e3a0971d844ae8cdf10d76e7Daisuke Miyakawa } 8887d82ae92714f2132e3a0971d844ae8cdf10d76e7Daisuke Miyakawa 8897d82ae92714f2132e3a0971d844ae8cdf10d76e7Daisuke Miyakawa protected void assertStoredValuesOrderly(Uri rowUri, String selection, 8907d82ae92714f2132e3a0971d844ae8cdf10d76e7Daisuke Miyakawa String[] selectionArgs, ContentValues[] expectedValues) { 8917d82ae92714f2132e3a0971d844ae8cdf10d76e7Daisuke Miyakawa Cursor c = mResolver.query(rowUri, null, selection, selectionArgs, null); 8927d82ae92714f2132e3a0971d844ae8cdf10d76e7Daisuke Miyakawa try { 8937d82ae92714f2132e3a0971d844ae8cdf10d76e7Daisuke Miyakawa assertEquals("Record count", expectedValues.length, c.getCount()); 8947d82ae92714f2132e3a0971d844ae8cdf10d76e7Daisuke Miyakawa assertCursorValuesOrderly(c, expectedValues); 8957d82ae92714f2132e3a0971d844ae8cdf10d76e7Daisuke Miyakawa } finally { 8967d82ae92714f2132e3a0971d844ae8cdf10d76e7Daisuke Miyakawa c.close(); 8977d82ae92714f2132e3a0971d844ae8cdf10d76e7Daisuke Miyakawa } 8987d82ae92714f2132e3a0971d844ae8cdf10d76e7Daisuke Miyakawa } 8997d82ae92714f2132e3a0971d844ae8cdf10d76e7Daisuke Miyakawa 90020a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov /** 90120a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov * Constructs a selection (where clause) out of all supplied values, uses it 90220a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov * to query the provider and verifies that a single row is returned and it 90320a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov * has the same values as requested. 90420a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov */ 90520a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov protected void assertSelection(Uri uri, ContentValues values, String idColumn, long id) { 906ff2de103f7e3eeeff4665ef63f07460fef053d6dDmitri Plotnikov assertSelection(uri, values, idColumn, id, null); 907ff2de103f7e3eeeff4665ef63f07460fef053d6dDmitri Plotnikov } 908ff2de103f7e3eeeff4665ef63f07460fef053d6dDmitri Plotnikov 909ff2de103f7e3eeeff4665ef63f07460fef053d6dDmitri Plotnikov public void assertSelectionWithProjection(Uri uri, ContentValues values, String idColumn, 910ff2de103f7e3eeeff4665ef63f07460fef053d6dDmitri Plotnikov long id) { 911ff2de103f7e3eeeff4665ef63f07460fef053d6dDmitri Plotnikov assertSelection(uri, values, idColumn, id, buildProjection(values)); 912ff2de103f7e3eeeff4665ef63f07460fef053d6dDmitri Plotnikov } 913ff2de103f7e3eeeff4665ef63f07460fef053d6dDmitri Plotnikov 914ff2de103f7e3eeeff4665ef63f07460fef053d6dDmitri Plotnikov private void assertSelection(Uri uri, ContentValues values, String idColumn, long id, 915ff2de103f7e3eeeff4665ef63f07460fef053d6dDmitri Plotnikov String[] projection) { 91620a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov StringBuilder sb = new StringBuilder(); 91720a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov ArrayList<String> selectionArgs = new ArrayList<String>(values.size()); 918c70dc0e38ff82c6e6d6b7458637c54fbdf446aacDmitri Plotnikov if (idColumn != null) { 919c70dc0e38ff82c6e6d6b7458637c54fbdf446aacDmitri Plotnikov sb.append(idColumn).append("=").append(id); 920c70dc0e38ff82c6e6d6b7458637c54fbdf446aacDmitri Plotnikov } 92120a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov Set<Map.Entry<String, Object>> entries = values.valueSet(); 92220a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov for (Map.Entry<String, Object> entry : entries) { 92320a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov String column = entry.getKey(); 92420a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov Object value = entry.getValue(); 925c70dc0e38ff82c6e6d6b7458637c54fbdf446aacDmitri Plotnikov if (sb.length() != 0) { 926c70dc0e38ff82c6e6d6b7458637c54fbdf446aacDmitri Plotnikov sb.append(" AND "); 927c70dc0e38ff82c6e6d6b7458637c54fbdf446aacDmitri Plotnikov } 928c70dc0e38ff82c6e6d6b7458637c54fbdf446aacDmitri Plotnikov sb.append(column); 92920a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov if (value == null) { 93020a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov sb.append(" IS NULL"); 93120a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov } else { 93220a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov sb.append("=?"); 93320a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov selectionArgs.add(String.valueOf(value)); 93420a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov } 93520a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov } 93620a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov 937ff2de103f7e3eeeff4665ef63f07460fef053d6dDmitri Plotnikov Cursor c = mResolver.query(uri, projection, sb.toString(), selectionArgs.toArray(new String[0]), 93820a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov null); 93920a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov try { 94020a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov assertEquals("Record count", 1, c.getCount()); 94120a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov c.moveToFirst(); 94220a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov assertCursorValues(c, values); 94320a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov } finally { 94420a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov c.close(); 94520a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov } 94620a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov } 94720a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov 948c918b0d3ab17a45a392748f43956b927c83eb402Dmitri Plotnikov protected void assertCursorValue(Cursor cursor, String column, Object expectedValue) { 949c918b0d3ab17a45a392748f43956b927c83eb402Dmitri Plotnikov String actualValue = cursor.getString(cursor.getColumnIndex(column)); 950c918b0d3ab17a45a392748f43956b927c83eb402Dmitri Plotnikov assertEquals("Column " + column, String.valueOf(expectedValue), 951c918b0d3ab17a45a392748f43956b927c83eb402Dmitri Plotnikov String.valueOf(actualValue)); 952c918b0d3ab17a45a392748f43956b927c83eb402Dmitri Plotnikov } 953c918b0d3ab17a45a392748f43956b927c83eb402Dmitri Plotnikov 95420a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov protected void assertCursorValues(Cursor cursor, ContentValues expectedValues) { 955892a3d9ded5c64a63ae3d5d5c52c59528b466c93Dmitri Plotnikov StringBuilder message = new StringBuilder(); 956892a3d9ded5c64a63ae3d5d5c52c59528b466c93Dmitri Plotnikov boolean result = equalsWithExpectedValues(cursor, expectedValues, message); 957892a3d9ded5c64a63ae3d5d5c52c59528b466c93Dmitri Plotnikov assertTrue(message.toString(), result); 958892a3d9ded5c64a63ae3d5d5c52c59528b466c93Dmitri Plotnikov } 959892a3d9ded5c64a63ae3d5d5c52c59528b466c93Dmitri Plotnikov 960892a3d9ded5c64a63ae3d5d5c52c59528b466c93Dmitri Plotnikov protected void assertCursorValues(Cursor cursor, ContentValues[] expectedValues) { 961892a3d9ded5c64a63ae3d5d5c52c59528b466c93Dmitri Plotnikov StringBuilder message = new StringBuilder(); 962892a3d9ded5c64a63ae3d5d5c52c59528b466c93Dmitri Plotnikov for (ContentValues v : expectedValues) { 963892a3d9ded5c64a63ae3d5d5c52c59528b466c93Dmitri Plotnikov boolean found = false; 964892a3d9ded5c64a63ae3d5d5c52c59528b466c93Dmitri Plotnikov cursor.moveToPosition(-1); 965892a3d9ded5c64a63ae3d5d5c52c59528b466c93Dmitri Plotnikov while (cursor.moveToNext()) { 966892a3d9ded5c64a63ae3d5d5c52c59528b466c93Dmitri Plotnikov found = equalsWithExpectedValues(cursor, v, message); 967892a3d9ded5c64a63ae3d5d5c52c59528b466c93Dmitri Plotnikov if (found) { 968892a3d9ded5c64a63ae3d5d5c52c59528b466c93Dmitri Plotnikov break; 969892a3d9ded5c64a63ae3d5d5c52c59528b466c93Dmitri Plotnikov } 970892a3d9ded5c64a63ae3d5d5c52c59528b466c93Dmitri Plotnikov } 971892a3d9ded5c64a63ae3d5d5c52c59528b466c93Dmitri Plotnikov assertTrue("Expected values can not be found " + v + message.toString(), found); 972892a3d9ded5c64a63ae3d5d5c52c59528b466c93Dmitri Plotnikov } 973892a3d9ded5c64a63ae3d5d5c52c59528b466c93Dmitri Plotnikov } 974892a3d9ded5c64a63ae3d5d5c52c59528b466c93Dmitri Plotnikov 9757d82ae92714f2132e3a0971d844ae8cdf10d76e7Daisuke Miyakawa protected void assertCursorValuesOrderly(Cursor cursor, ContentValues[] expectedValues) { 9767d82ae92714f2132e3a0971d844ae8cdf10d76e7Daisuke Miyakawa StringBuilder message = new StringBuilder(); 9777d82ae92714f2132e3a0971d844ae8cdf10d76e7Daisuke Miyakawa cursor.moveToPosition(-1); 9787d82ae92714f2132e3a0971d844ae8cdf10d76e7Daisuke Miyakawa for (ContentValues v : expectedValues) { 9797d82ae92714f2132e3a0971d844ae8cdf10d76e7Daisuke Miyakawa assertTrue(cursor.moveToNext()); 9807d82ae92714f2132e3a0971d844ae8cdf10d76e7Daisuke Miyakawa assertTrue("ContentValues didn't match " + v + message.toString(), 9817d82ae92714f2132e3a0971d844ae8cdf10d76e7Daisuke Miyakawa equalsWithExpectedValues(cursor, v, message)); 9827d82ae92714f2132e3a0971d844ae8cdf10d76e7Daisuke Miyakawa } 9837d82ae92714f2132e3a0971d844ae8cdf10d76e7Daisuke Miyakawa } 9847d82ae92714f2132e3a0971d844ae8cdf10d76e7Daisuke Miyakawa 985892a3d9ded5c64a63ae3d5d5c52c59528b466c93Dmitri Plotnikov private boolean equalsWithExpectedValues(Cursor cursor, ContentValues expectedValues, 986892a3d9ded5c64a63ae3d5d5c52c59528b466c93Dmitri Plotnikov StringBuilder msgBuffer) { 98720a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov Set<Map.Entry<String, Object>> entries = expectedValues.valueSet(); 98820a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov for (Map.Entry<String, Object> entry : entries) { 98920a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov String column = entry.getKey(); 99020a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov int index = cursor.getColumnIndex(column); 991892a3d9ded5c64a63ae3d5d5c52c59528b466c93Dmitri Plotnikov if (index == -1) { 992892a3d9ded5c64a63ae3d5d5c52c59528b466c93Dmitri Plotnikov msgBuffer.append("No such column: ").append(column); 993892a3d9ded5c64a63ae3d5d5c52c59528b466c93Dmitri Plotnikov return false; 994892a3d9ded5c64a63ae3d5d5c52c59528b466c93Dmitri Plotnikov } 99520a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov Object expectedValue = expectedValues.get(column); 99620a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov String value; 99720a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov if (expectedValue instanceof byte[]) { 99820a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov expectedValue = Hex.encodeHex((byte[])expectedValue, false); 99920a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov value = Hex.encodeHex(cursor.getBlob(index), false); 100020a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov } else { 100120a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov expectedValue = expectedValues.getAsString(column); 100220a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov value = cursor.getString(index); 100320a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov } 1004892a3d9ded5c64a63ae3d5d5c52c59528b466c93Dmitri Plotnikov if (expectedValue != null && !expectedValue.equals(value) || value != null 1005892a3d9ded5c64a63ae3d5d5c52c59528b466c93Dmitri Plotnikov && !value.equals(expectedValue)) { 1006892a3d9ded5c64a63ae3d5d5c52c59528b466c93Dmitri Plotnikov msgBuffer 1007892a3d9ded5c64a63ae3d5d5c52c59528b466c93Dmitri Plotnikov .append("Column value ") 1008892a3d9ded5c64a63ae3d5d5c52c59528b466c93Dmitri Plotnikov .append(column) 1009892a3d9ded5c64a63ae3d5d5c52c59528b466c93Dmitri Plotnikov .append(" expected <") 1010892a3d9ded5c64a63ae3d5d5c52c59528b466c93Dmitri Plotnikov .append(expectedValue) 1011892a3d9ded5c64a63ae3d5d5c52c59528b466c93Dmitri Plotnikov .append(">, but was <") 1012892a3d9ded5c64a63ae3d5d5c52c59528b466c93Dmitri Plotnikov .append(value) 1013892a3d9ded5c64a63ae3d5d5c52c59528b466c93Dmitri Plotnikov .append('>'); 1014892a3d9ded5c64a63ae3d5d5c52c59528b466c93Dmitri Plotnikov return false; 1015892a3d9ded5c64a63ae3d5d5c52c59528b466c93Dmitri Plotnikov } 101620a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov } 1017892a3d9ded5c64a63ae3d5d5c52c59528b466c93Dmitri Plotnikov return true; 101820a94c86ede7380c8dd8df2f6a72b3c00ac1bed8Dmitri Plotnikov } 101933b41fdb8d7c3c654cb070799c9d6e2b4ab16078Dmitri Plotnikov 1020ff2de103f7e3eeeff4665ef63f07460fef053d6dDmitri Plotnikov private String[] buildProjection(ContentValues values) { 1021ff2de103f7e3eeeff4665ef63f07460fef053d6dDmitri Plotnikov String[] projection = new String[values.size()]; 1022ff2de103f7e3eeeff4665ef63f07460fef053d6dDmitri Plotnikov Iterator<Entry<String, Object>> iter = values.valueSet().iterator(); 1023ff2de103f7e3eeeff4665ef63f07460fef053d6dDmitri Plotnikov for (int i = 0; i < projection.length; i++) { 1024ff2de103f7e3eeeff4665ef63f07460fef053d6dDmitri Plotnikov projection[i] = iter.next().getKey(); 1025ff2de103f7e3eeeff4665ef63f07460fef053d6dDmitri Plotnikov } 1026ff2de103f7e3eeeff4665ef63f07460fef053d6dDmitri Plotnikov return projection; 1027ff2de103f7e3eeeff4665ef63f07460fef053d6dDmitri Plotnikov } 1028ff2de103f7e3eeeff4665ef63f07460fef053d6dDmitri Plotnikov 102933b41fdb8d7c3c654cb070799c9d6e2b4ab16078Dmitri Plotnikov protected int getCount(Uri uri, String selection, String[] selectionArgs) { 103033b41fdb8d7c3c654cb070799c9d6e2b4ab16078Dmitri Plotnikov Cursor c = mResolver.query(uri, null, selection, selectionArgs, null); 103133b41fdb8d7c3c654cb070799c9d6e2b4ab16078Dmitri Plotnikov try { 103233b41fdb8d7c3c654cb070799c9d6e2b4ab16078Dmitri Plotnikov return c.getCount(); 103333b41fdb8d7c3c654cb070799c9d6e2b4ab16078Dmitri Plotnikov } finally { 103433b41fdb8d7c3c654cb070799c9d6e2b4ab16078Dmitri Plotnikov c.close(); 103533b41fdb8d7c3c654cb070799c9d6e2b4ab16078Dmitri Plotnikov } 103633b41fdb8d7c3c654cb070799c9d6e2b4ab16078Dmitri Plotnikov } 1037a908fb5f39aa2021662a6cc317cc7e4db2d8bfb0Dmitri Plotnikov 1038b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov public static void dump(ContentResolver resolver, boolean aggregatedOnly) { 1039b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov String[] projection = new String[] { 1040b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov Contacts._ID, 1041b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov Contacts.DISPLAY_NAME 1042b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov }; 1043b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov String selection = null; 1044b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov if (aggregatedOnly) { 1045b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov selection = Contacts._ID 1046b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov + " IN (SELECT contact_id" + 1047b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov " FROM raw_contacts GROUP BY contact_id HAVING count(*) > 1)"; 1048b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov } 1049b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov 1050b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov Cursor c = resolver.query(Contacts.CONTENT_URI, projection, selection, null, 1051b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov Contacts.DISPLAY_NAME); 1052b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov while(c.moveToNext()) { 1053b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov long contactId = c.getLong(0); 1054b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov Log.i("Contact ", String.format("%5d %s", contactId, c.getString(1))); 1055b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov dumpRawContacts(resolver, contactId); 1056b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov Log.i(" ", "."); 1057b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov } 1058b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov c.close(); 1059b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov } 1060b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov 1061b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov private static void dumpRawContacts(ContentResolver resolver, long contactId) { 1062b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov String[] projection = new String[] { 1063b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov RawContacts._ID, 1064b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov }; 1065b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov Cursor c = resolver.query(RawContacts.CONTENT_URI, projection, RawContacts.CONTACT_ID + "=" 1066b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov + contactId, null, null); 1067b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov while(c.moveToNext()) { 1068b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov long rawContactId = c.getLong(0); 1069b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov Log.i("RawContact", String.format(" %-5d", rawContactId)); 1070b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov dumpData(resolver, rawContactId); 1071b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov } 1072b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov c.close(); 1073b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov } 1074b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov 1075b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov private static void dumpData(ContentResolver resolver, long rawContactId) { 1076b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov String[] projection = new String[] { 1077b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov Data.MIMETYPE, 1078b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov Data.DATA1, 1079b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov Data.DATA2, 1080b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov Data.DATA3, 1081b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov }; 1082b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov Cursor c = resolver.query(Data.CONTENT_URI, projection, Data.RAW_CONTACT_ID + "=" 1083b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov + rawContactId, null, Data.MIMETYPE); 1084b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov while(c.moveToNext()) { 1085b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov String mimetype = c.getString(0); 1086b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov if (Photo.CONTENT_ITEM_TYPE.equals(mimetype)) { 1087b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov Log.i("Photo ", ""); 1088b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov } else { 1089b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov mimetype = mimetype.substring(mimetype.indexOf('/') + 1); 1090b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov Log.i("Data ", String.format(" %-10s %s,%s,%s", mimetype, 1091b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov c.getString(1), c.getString(2), c.getString(3))); 1092b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov } 1093b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov } 1094b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov c.close(); 1095b58058243bcd4405ad5ba5c3a465c46a35182ff7Dmitri Plotnikov } 1096285b771bc955305fa6d49ca23f808cecc8a13d5eDmitri Plotnikov 109781d6a78dffd57f24f9aaecb6cd54e4084c3c9846Dmitri Plotnikov protected void assertNetworkNotified(boolean expected) { 10989a6be1610fdf40c2f7f04cfe4b66fde3a35940dcDmitri Plotnikov assertEquals(expected, (getContactsProvider()).isNetworkNotified()); 109981d6a78dffd57f24f9aaecb6cd54e4084c3c9846Dmitri Plotnikov } 11005b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill 110109ae48b82b17e24016b14a1ab64706222ab1071fDmitri Plotnikov protected void assertProjection(Uri uri, String[] expectedProjection) { 110209ae48b82b17e24016b14a1ab64706222ab1071fDmitri Plotnikov Cursor cursor = mResolver.query(uri, null, "0", null, null); 110309ae48b82b17e24016b14a1ab64706222ab1071fDmitri Plotnikov String[] actualProjection = cursor.getColumnNames(); 110409ae48b82b17e24016b14a1ab64706222ab1071fDmitri Plotnikov MoreAsserts.assertEquals("Incorrect projection for URI: " + uri, 110509ae48b82b17e24016b14a1ab64706222ab1071fDmitri Plotnikov Sets.newHashSet(expectedProjection), Sets.newHashSet(actualProjection)); 110609ae48b82b17e24016b14a1ab64706222ab1071fDmitri Plotnikov cursor.close(); 110709ae48b82b17e24016b14a1ab64706222ab1071fDmitri Plotnikov } 110809ae48b82b17e24016b14a1ab64706222ab1071fDmitri Plotnikov 11095b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill /** 11105b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill * A contact in the database, and the attributes used to create it. Construct using 11115b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill * {@link GoldenContactBuilder#build()}. 11125b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill */ 11135b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill public final class GoldenContact { 11145b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill 11155b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill private final long rawContactId; 11165b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill 11175b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill private final long contactId; 11185b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill 11195b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill private final String givenName; 11205b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill 11215b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill private final String familyName; 11225b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill 11235b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill private final String nickname; 11245b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill 11255b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill private final byte[] photo; 11265b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill 11275b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill private final String company; 11285b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill 11295b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill private final String title; 11305b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill 11315b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill private final String phone; 11325b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill 11335b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill private final String email; 11345b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill 11355b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill private GoldenContact(GoldenContactBuilder builder, long rawContactId, long contactId) { 11365b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill 11375b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill this.rawContactId = rawContactId; 11385b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill this.contactId = contactId; 11395b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill givenName = builder.givenName; 11405b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill familyName = builder.familyName; 11415b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill nickname = builder.nickname; 11425b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill photo = builder.photo; 11435b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill company = builder.company; 11445b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill title = builder.title; 11455b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill phone = builder.phone; 11465b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill email = builder.email; 11475b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill } 11485b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill 11495b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill public void delete() { 11505b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill Uri rawContactUri = ContentUris.withAppendedId(RawContacts.CONTENT_URI, rawContactId); 11515b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill mResolver.delete(rawContactUri, null, null); 11525b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill } 11535b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill 11545b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill /** 11555b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill * Returns the index of the contact in table "raw_contacts" 11565b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill */ 11575b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill public long getRawContactId() { 11585b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill return rawContactId; 11595b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill } 11605b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill 11615b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill /** 11625b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill * Returns the index of the contact in table "contacts" 11635b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill */ 11645b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill public long getContactId() { 11655b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill return contactId; 11665b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill } 11675b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill 11685b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill /** 11692d2ec88b7af615b2f05e987da45425be9cace1baTom O'Neill * Returns the lookup key for the contact. 11702d2ec88b7af615b2f05e987da45425be9cace1baTom O'Neill */ 11712d2ec88b7af615b2f05e987da45425be9cace1baTom O'Neill public String getLookupKey() { 11722d2ec88b7af615b2f05e987da45425be9cace1baTom O'Neill return queryLookupKey(contactId); 11732d2ec88b7af615b2f05e987da45425be9cace1baTom O'Neill } 11742d2ec88b7af615b2f05e987da45425be9cace1baTom O'Neill 11752d2ec88b7af615b2f05e987da45425be9cace1baTom O'Neill /** 11765b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill * Returns the contact's given name. 11775b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill */ 11785b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill public String getGivenName() { 11795b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill return givenName; 11805b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill } 11815b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill 11825b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill /** 11835b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill * Returns the contact's family name. 11845b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill */ 11855b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill public String getFamilyName() { 11865b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill return familyName; 11875b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill } 11885b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill 11895b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill /** 11905b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill * Returns the contact's nickname. 11915b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill */ 11925b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill public String getNickname() { 11935b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill return nickname; 11945b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill } 11955b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill 11965b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill /** 11975b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill * Return's the contact's photo 11985b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill */ 11995b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill public byte[] getPhoto() { 12005b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill return photo; 12015b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill } 12025b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill 12035b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill /** 12045b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill * Return's the company at which the contact works. 12055b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill */ 12065b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill public String getCompany() { 12075b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill return company; 12085b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill } 12095b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill 12105b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill /** 12115b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill * Returns the contact's job title. 12125b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill */ 12135b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill public String getTitle() { 12145b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill return title; 12155b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill } 12165b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill 12175b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill /** 12185b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill * Returns the contact's phone number 12195b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill */ 12205b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill public String getPhone() { 12215b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill return phone; 12225b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill } 12235b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill 12245b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill /** 12255b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill * Returns the contact's email address 12265b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill */ 12275b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill public String getEmail() { 12285b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill return email; 12295b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill } 12305b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill } 12315b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill 12325b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill /** 12335b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill * Builds {@link GoldenContact} objects. Unspecified boolean objects default to false. 12345b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill * Unspecified String objects default to null. 12355b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill */ 12365b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill public final class GoldenContactBuilder { 12375b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill 12385b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill private String givenName; 12395b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill 12405b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill private String familyName; 12415b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill 12425b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill private String nickname; 12435b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill 12445b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill private byte[] photo; 12455b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill 12465b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill private String company; 12475b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill 12485b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill private String title; 12495b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill 12505b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill private String phone; 12515b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill 12525b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill private String email; 12535b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill 12545b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill /** 12555b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill * The contact's given and family names. 12565b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill * 12575b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill * TODO(dplotnikov): inline, or should we require them to set both names if they set either? 12585b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill */ 12595b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill public GoldenContactBuilder name(String givenName, String familyName) { 12605b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill return givenName(givenName).familyName(familyName); 12615b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill } 12625b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill 12635b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill /** 12645b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill * The contact's given name. 12655b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill */ 12665b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill public GoldenContactBuilder givenName(String value) { 12675b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill givenName = value; 12685b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill return this; 12695b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill } 12705b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill 12715b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill /** 12725b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill * The contact's family name. 12735b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill */ 12745b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill public GoldenContactBuilder familyName(String value) { 12755b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill familyName = value; 12765b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill return this; 12775b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill } 12785b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill 12795b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill /** 12805b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill * The contact's nickname. 12815b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill */ 12825b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill public GoldenContactBuilder nickname(String value) { 12835b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill nickname = value; 12845b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill return this; 12855b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill } 12865b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill 12875b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill /** 12885b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill * The contact's photo. 12895b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill */ 12905b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill public GoldenContactBuilder photo(byte[] value) { 12915b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill photo = value; 12925b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill return this; 12935b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill } 12945b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill 12955b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill /** 12965b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill * The company at which the contact works. 12975b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill */ 12985b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill public GoldenContactBuilder company(String value) { 12995b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill company = value; 13005b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill return this; 13015b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill } 13025b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill 13035b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill /** 13045b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill * The contact's job title. 13055b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill */ 13065b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill public GoldenContactBuilder title(String value) { 13075b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill title = value; 13085b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill return this; 13095b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill } 13105b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill 13115b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill /** 13125b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill * The contact's phone number. 13135b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill */ 13145b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill public GoldenContactBuilder phone(String value) { 13155b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill phone = value; 13165b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill return this; 13175b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill } 13185b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill 13195b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill /** 13205b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill * The contact's email address; also sets their IM status to {@link StatusUpdates#OFFLINE} 13215b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill * with a presence of "Coding for Android". 13225b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill */ 13235b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill public GoldenContactBuilder email(String value) { 13245b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill email = value; 13255b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill return this; 13265b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill } 13275b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill 13285b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill /** 13295b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill * Builds the {@link GoldenContact} specified by this builder. 13305b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill */ 13315b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill public GoldenContact build() { 13325b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill 13335b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill final long groupId = createGroup(mAccount, "gsid1", "title1"); 13345b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill 13355b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill long rawContactId = createRawContact(); 13365b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill insertGroupMembership(rawContactId, groupId); 13375b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill 13385b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill if (givenName != null || familyName != null) { 13395b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill insertStructuredName(rawContactId, givenName, familyName); 13405b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill } 13415b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill if (nickname != null) { 13425b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill insertNickname(rawContactId, nickname); 13435b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill } 13445b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill if (photo != null) { 13455b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill insertPhoto(rawContactId); 13465b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill } 13475b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill if (company != null || title != null) { 13485b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill insertOrganization(rawContactId); 13495b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill } 13505b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill if (email != null) { 13515b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill insertEmail(rawContactId); 13525b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill } 13535b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill if (phone != null) { 13545b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill insertPhone(rawContactId); 13555b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill } 13565b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill 13575b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill long contactId = queryContactId(rawContactId); 13585b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill 13595b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill return new GoldenContact(this, rawContactId, contactId); 13605b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill } 13615b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill 13625b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill private void insertPhoto(long rawContactId) { 13635b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill ContentValues values = new ContentValues(); 13645b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill values.put(Data.RAW_CONTACT_ID, rawContactId); 13655b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill values.put(Data.MIMETYPE, Photo.CONTENT_ITEM_TYPE); 13665b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill values.put(Photo.PHOTO, photo); 13675b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill mResolver.insert(Data.CONTENT_URI, values); 13685b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill } 13695b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill 13705b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill private void insertOrganization(long rawContactId) { 13715b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill 13725b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill ContentValues values = new ContentValues(); 13735b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill values.put(Data.RAW_CONTACT_ID, rawContactId); 13745b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill values.put(Data.MIMETYPE, Organization.CONTENT_ITEM_TYPE); 13755b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill values.put(Organization.TYPE, Organization.TYPE_WORK); 13765b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill if (company != null) { 13775b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill values.put(Organization.COMPANY, company); 13785b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill } 13795b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill if (title != null) { 13805b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill values.put(Organization.TITLE, title); 13815b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill } 13825b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill mResolver.insert(Data.CONTENT_URI, values); 13835b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill } 13845b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill 13855b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill private void insertEmail(long rawContactId) { 13865b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill 13875b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill ContentValues values = new ContentValues(); 13885b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill values.put(Data.RAW_CONTACT_ID, rawContactId); 13895b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill values.put(Data.MIMETYPE, Email.CONTENT_ITEM_TYPE); 13905b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill values.put(Email.TYPE, Email.TYPE_WORK); 13915b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill values.put(Email.DATA, "foo@acme.com"); 13925b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill mResolver.insert(Data.CONTENT_URI, values); 13935b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill 13945b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill int protocol = Im.PROTOCOL_GOOGLE_TALK; 13955b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill 13965b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill values.clear(); 13975b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill values.put(StatusUpdates.PROTOCOL, protocol); 13985b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill values.put(StatusUpdates.IM_HANDLE, email); 13995b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill values.put(StatusUpdates.IM_ACCOUNT, "foo"); 14005b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill values.put(StatusUpdates.PRESENCE_STATUS, StatusUpdates.OFFLINE); 1401aabcd1d34a71ad06ee0a9395331540484f1ceb17Vasu Nori values.put(StatusUpdates.CHAT_CAPABILITY, StatusUpdates.CAPABILITY_HAS_CAMERA); 14025b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill values.put(StatusUpdates.PRESENCE_CUSTOM_STATUS, "Coding for Android"); 14035b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill mResolver.insert(StatusUpdates.CONTENT_URI, values); 14045b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill } 14055b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill 14065b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill private void insertPhone(long rawContactId) { 14075b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill ContentValues values = new ContentValues(); 14085b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill values.put(Data.RAW_CONTACT_ID, rawContactId); 14095b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill values.put(Data.MIMETYPE, Phone.CONTENT_ITEM_TYPE); 14105b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill values.put(Data.IS_PRIMARY, 1); 14115b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill values.put(Phone.TYPE, Phone.TYPE_HOME); 14125b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill values.put(Phone.NUMBER, phone); 14135b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill mResolver.insert(Data.CONTENT_URI, values); 14145b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill } 14155b3b3ec368625c07a2c94d2199a75099d4d9b8a9Tom O'Neill } 1416d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov} 1417