1f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov/* 2f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov * Copyright (C) 2010 The Android Open Source Project 3f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov * 4f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov * Licensed under the Apache License, Version 2.0 (the "License"); you may not 5f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov * use this file except in compliance with the License. You may obtain a copy of 6f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov * the License at 7f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov * 8f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov * http://www.apache.org/licenses/LICENSE-2.0 9f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov * 10f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov * Unless required by applicable law or agreed to in writing, software 11f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov * distributed under the License is distributed on an "AS IS" BASIS, WITHOUT 12f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov * WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the 13f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov * License for the specific language governing permissions and limitations under 14f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov * the License 15f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov */ 16f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikovpackage com.android.providers.contacts; 17f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov 18f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikovimport android.content.ContentValues; 196d9702cec82fd27a1c3093c64df9dcc22744899aDmitri Plotnikovimport android.content.Context; 20f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikovimport android.database.Cursor; 21f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikovimport android.database.DatabaseUtils; 22f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikovimport android.database.sqlite.SQLiteDatabase; 23f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikovimport android.provider.ContactsContract.CommonDataKinds.GroupMembership; 24f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikovimport android.provider.ContactsContract.Groups; 25f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikovimport android.provider.ContactsContract.RawContacts; 26f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov 2738210445730ee04c351c7cc1b3800cfe23e34325Makoto Onukiimport com.android.providers.contacts.ContactsDatabaseHelper.Clauses; 2838210445730ee04c351c7cc1b3800cfe23e34325Makoto Onukiimport com.android.providers.contacts.ContactsDatabaseHelper.DataColumns; 2938210445730ee04c351c7cc1b3800cfe23e34325Makoto Onukiimport com.android.providers.contacts.ContactsDatabaseHelper.GroupsColumns; 3038210445730ee04c351c7cc1b3800cfe23e34325Makoto Onukiimport com.android.providers.contacts.ContactsDatabaseHelper.Projections; 3138210445730ee04c351c7cc1b3800cfe23e34325Makoto Onukiimport com.android.providers.contacts.ContactsDatabaseHelper.RawContactsColumns; 3238210445730ee04c351c7cc1b3800cfe23e34325Makoto Onukiimport com.android.providers.contacts.ContactsDatabaseHelper.Tables; 3338210445730ee04c351c7cc1b3800cfe23e34325Makoto Onukiimport com.android.providers.contacts.ContactsProvider2.GroupIdCacheEntry; 3438210445730ee04c351c7cc1b3800cfe23e34325Makoto Onukiimport com.android.providers.contacts.aggregation.ContactAggregator; 3538210445730ee04c351c7cc1b3800cfe23e34325Makoto Onuki 36f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikovimport java.util.ArrayList; 37f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikovimport java.util.HashMap; 38f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov 39f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov/** 40f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov * Handler for group membership data rows. 41f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov */ 42f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikovpublic class DataRowHandlerForGroupMembership extends DataRowHandler { 43f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov 44f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov interface RawContactsQuery { 45f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov String TABLE = Tables.RAW_CONTACTS; 46f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov 47f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov String[] COLUMNS = new String[] { 48f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov RawContacts.DELETED, 499d990d339c9e3a9e03f6fe13c260d36665f00e61Makoto Onuki RawContactsColumns.ACCOUNT_ID, 50f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov }; 51f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov 52f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov int DELETED = 0; 539d990d339c9e3a9e03f6fe13c260d36665f00e61Makoto Onuki int ACCOUNT_ID = 1; 54f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov } 55f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov 56f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov private static final String SELECTION_RAW_CONTACT_ID = RawContacts._ID + "=?"; 57f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov 58f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov private static final String QUERY_COUNT_FAVORITES_GROUP_MEMBERSHIPS_BY_RAW_CONTACT_ID = 59f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov "SELECT COUNT(*) FROM " + Tables.DATA + " LEFT OUTER JOIN " + Tables .GROUPS 60f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov + " ON " + Tables.DATA + "." + GroupMembership.GROUP_ROW_ID 61f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov + "=" + GroupsColumns.CONCRETE_ID 62f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov + " WHERE " + DataColumns.MIMETYPE_ID + "=?" 63f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov + " AND " + Tables.DATA + "." + GroupMembership.RAW_CONTACT_ID + "=?" 64f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov + " AND " + Groups.FAVORITES + "!=0"; 65f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov 66f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov private final HashMap<String, ArrayList<GroupIdCacheEntry>> mGroupIdCache; 67f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov 686d9702cec82fd27a1c3093c64df9dcc22744899aDmitri Plotnikov public DataRowHandlerForGroupMembership(Context context, ContactsDatabaseHelper dbHelper, 69f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov ContactAggregator aggregator, 70f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov HashMap<String, ArrayList<GroupIdCacheEntry>> groupIdCache) { 716d9702cec82fd27a1c3093c64df9dcc22744899aDmitri Plotnikov super(context, dbHelper, aggregator, GroupMembership.CONTENT_ITEM_TYPE); 72f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov mGroupIdCache = groupIdCache; 73f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov } 74f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov 75f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov @Override 76f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov public long insert(SQLiteDatabase db, TransactionContext txContext, long rawContactId, 77f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov ContentValues values) { 78f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov resolveGroupSourceIdInValues(txContext, rawContactId, db, values, true); 79f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov long dataId = super.insert(db, txContext, rawContactId, values); 80f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov if (hasFavoritesGroupMembership(db, rawContactId)) { 81f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov updateRawContactsStar(db, rawContactId, true /* starred */); 82f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov } 83bd9abbb6b03b4ec1e28ad3fa2fcba5d1eb8609eaDmitri Plotnikov updateVisibility(txContext, rawContactId); 84f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov return dataId; 85f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov } 86f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov 87f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov @Override 88f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov public boolean update(SQLiteDatabase db, TransactionContext txContext, ContentValues values, 89f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov Cursor c, boolean callerIsSyncAdapter) { 90f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov long rawContactId = c.getLong(DataUpdateQuery.RAW_CONTACT_ID); 91f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov boolean wasStarred = hasFavoritesGroupMembership(db, rawContactId); 92f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov resolveGroupSourceIdInValues(txContext, rawContactId, db, values, false); 93f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov if (!super.update(db, txContext, values, c, callerIsSyncAdapter)) { 94f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov return false; 95f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov } 96f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov boolean isStarred = hasFavoritesGroupMembership(db, rawContactId); 97f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov if (wasStarred != isStarred) { 98f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov updateRawContactsStar(db, rawContactId, isStarred); 99f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov } 100bd9abbb6b03b4ec1e28ad3fa2fcba5d1eb8609eaDmitri Plotnikov updateVisibility(txContext, rawContactId); 101f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov return true; 102f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov } 103f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov 104f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov private void updateRawContactsStar(SQLiteDatabase db, long rawContactId, boolean starred) { 105f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov ContentValues rawContactValues = new ContentValues(); 106f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov rawContactValues.put(RawContacts.STARRED, starred ? 1 : 0); 107f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov if (db.update(Tables.RAW_CONTACTS, rawContactValues, SELECTION_RAW_CONTACT_ID, 108f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov new String[]{Long.toString(rawContactId)}) > 0) { 109f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov mContactAggregator.updateStarred(rawContactId); 110f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov } 111f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov } 112f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov 113f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov private boolean hasFavoritesGroupMembership(SQLiteDatabase db, long rawContactId) { 114f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov // TODO compiled SQL statement 115f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov final long groupMembershipMimetypeId = mDbHelper 116f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov .getMimeTypeId(GroupMembership.CONTENT_ITEM_TYPE); 117f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov boolean isStarred = 0 < DatabaseUtils 118f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov .longForQuery(db, QUERY_COUNT_FAVORITES_GROUP_MEMBERSHIPS_BY_RAW_CONTACT_ID, 119f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov new String[]{Long.toString(groupMembershipMimetypeId), Long.toString(rawContactId)}); 120f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov return isStarred; 121f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov } 122f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov 123f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov @Override 124f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov public int delete(SQLiteDatabase db, TransactionContext txContext, Cursor c) { 125f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov long rawContactId = c.getLong(DataDeleteQuery.RAW_CONTACT_ID); 126f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov boolean wasStarred = hasFavoritesGroupMembership(db, rawContactId); 127f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov int count = super.delete(db, txContext, c); 128f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov boolean isStarred = hasFavoritesGroupMembership(db, rawContactId); 129f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov if (wasStarred && !isStarred) { 130f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov updateRawContactsStar(db, rawContactId, false /* starred */); 131f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov } 132bd9abbb6b03b4ec1e28ad3fa2fcba5d1eb8609eaDmitri Plotnikov updateVisibility(txContext, rawContactId); 133f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov return count; 134f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov } 135f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov 136bd9abbb6b03b4ec1e28ad3fa2fcba5d1eb8609eaDmitri Plotnikov private void updateVisibility(TransactionContext txContext, long rawContactId) { 137f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov long contactId = mDbHelper.getContactId(rawContactId); 138f266e8c568905337960b1fec5379841585af92a7Dmitri Plotnikov if (contactId == 0) { 139f266e8c568905337960b1fec5379841585af92a7Dmitri Plotnikov return; 140f266e8c568905337960b1fec5379841585af92a7Dmitri Plotnikov } 141f266e8c568905337960b1fec5379841585af92a7Dmitri Plotnikov 142bd9abbb6b03b4ec1e28ad3fa2fcba5d1eb8609eaDmitri Plotnikov if (mDbHelper.updateContactVisibleOnlyIfChanged(txContext, contactId)) { 143f266e8c568905337960b1fec5379841585af92a7Dmitri Plotnikov mContactAggregator.updateAggregationAfterVisibilityChange(contactId); 144f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov } 145f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov } 146f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov 147f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov private void resolveGroupSourceIdInValues(TransactionContext txContext, 148f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov long rawContactId, SQLiteDatabase db, ContentValues values, boolean isInsert) { 149f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov boolean containsGroupSourceId = values.containsKey(GroupMembership.GROUP_SOURCE_ID); 150f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov boolean containsGroupId = values.containsKey(GroupMembership.GROUP_ROW_ID); 151f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov if (containsGroupSourceId && containsGroupId) { 152f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov throw new IllegalArgumentException( 153f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov "you are not allowed to set both the GroupMembership.GROUP_SOURCE_ID " 154f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov + "and GroupMembership.GROUP_ROW_ID"); 155f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov } 156f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov 157f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov if (!containsGroupSourceId && !containsGroupId) { 158f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov if (isInsert) { 159f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov throw new IllegalArgumentException( 160f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov "you must set exactly one of GroupMembership.GROUP_SOURCE_ID " 161f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov + "and GroupMembership.GROUP_ROW_ID"); 162f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov } else { 163f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov return; 164f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov } 165f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov } 166f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov 167f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov if (containsGroupSourceId) { 168f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov final String sourceId = values.getAsString(GroupMembership.GROUP_SOURCE_ID); 169f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov final long groupId = getOrMakeGroup(db, rawContactId, sourceId, 1709d990d339c9e3a9e03f6fe13c260d36665f00e61Makoto Onuki txContext.getAccountIdOrNullForRawContact(rawContactId)); 171f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov values.remove(GroupMembership.GROUP_SOURCE_ID); 172f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov values.put(GroupMembership.GROUP_ROW_ID, groupId); 173f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov } 174f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov } 175f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov 176f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov /** 177f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov * Returns the group id of the group with sourceId and the same account as rawContactId. 1789d990d339c9e3a9e03f6fe13c260d36665f00e61Makoto Onuki * If the group doesn't already exist then it is first created. 1799d990d339c9e3a9e03f6fe13c260d36665f00e61Makoto Onuki * 180f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov * @param db SQLiteDatabase to use for this operation 1819d990d339c9e3a9e03f6fe13c260d36665f00e61Makoto Onuki * @param rawContactId the raw contact this group is associated with 1829d990d339c9e3a9e03f6fe13c260d36665f00e61Makoto Onuki * @param sourceId the source ID of the group to query or create 1839d990d339c9e3a9e03f6fe13c260d36665f00e61Makoto Onuki * @param accountIdOrNull the account ID for the raw contact. If null it'll be queried from 1849d990d339c9e3a9e03f6fe13c260d36665f00e61Makoto Onuki * the raw_contacts table. 185f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov * @return the group id of the existing or created group 186f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov * @throws IllegalArgumentException if the contact is not associated with an account 187f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov * @throws IllegalStateException if a group needs to be created but the creation failed 188f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov */ 189f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov private long getOrMakeGroup(SQLiteDatabase db, long rawContactId, String sourceId, 1909d990d339c9e3a9e03f6fe13c260d36665f00e61Makoto Onuki Long accountIdOrNull) { 191f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov 1929d990d339c9e3a9e03f6fe13c260d36665f00e61Makoto Onuki if (accountIdOrNull == null) { 193f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov mSelectionArgs1[0] = String.valueOf(rawContactId); 194f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov Cursor c = db.query(RawContactsQuery.TABLE, RawContactsQuery.COLUMNS, 1959d990d339c9e3a9e03f6fe13c260d36665f00e61Makoto Onuki RawContactsColumns.CONCRETE_ID + "=?", mSelectionArgs1, null, null, null); 196f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov try { 197f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov if (c.moveToFirst()) { 1989d990d339c9e3a9e03f6fe13c260d36665f00e61Makoto Onuki accountIdOrNull = c.getLong(RawContactsQuery.ACCOUNT_ID); 199f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov } 200f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov } finally { 201f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov c.close(); 202f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov } 203f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov } 204f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov 2059d990d339c9e3a9e03f6fe13c260d36665f00e61Makoto Onuki if (accountIdOrNull == null) { 2069d990d339c9e3a9e03f6fe13c260d36665f00e61Makoto Onuki throw new IllegalArgumentException("Raw contact not found for _ID=" + rawContactId); 207f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov } 2089d990d339c9e3a9e03f6fe13c260d36665f00e61Makoto Onuki final long accountId = accountIdOrNull; 209f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov 210f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov ArrayList<GroupIdCacheEntry> entries = mGroupIdCache.get(sourceId); 211f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov if (entries == null) { 212f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov entries = new ArrayList<GroupIdCacheEntry>(1); 213f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov mGroupIdCache.put(sourceId, entries); 214f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov } 215f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov 216f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov int count = entries.size(); 217f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov for (int i = 0; i < count; i++) { 218f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov GroupIdCacheEntry entry = entries.get(i); 2199d990d339c9e3a9e03f6fe13c260d36665f00e61Makoto Onuki if (entry.accountId == accountId) { 220f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov return entry.groupId; 221f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov } 222f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov } 223f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov 224f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov GroupIdCacheEntry entry = new GroupIdCacheEntry(); 2259d990d339c9e3a9e03f6fe13c260d36665f00e61Makoto Onuki entry.accountId = accountId; 226f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov entry.sourceId = sourceId; 227f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov entries.add(0, entry); 228f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov 2299d990d339c9e3a9e03f6fe13c260d36665f00e61Makoto Onuki // look up the group that contains this sourceId and has the same account as the contact 2309d990d339c9e3a9e03f6fe13c260d36665f00e61Makoto Onuki // referred to by rawContactId 2319d990d339c9e3a9e03f6fe13c260d36665f00e61Makoto Onuki Cursor c = db.query(Tables.GROUPS, Projections.ID, 232f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov Clauses.GROUP_HAS_ACCOUNT_AND_SOURCE_ID, 2339d990d339c9e3a9e03f6fe13c260d36665f00e61Makoto Onuki new String[]{sourceId, Long.toString(accountId)}, null, null, null); 2349d990d339c9e3a9e03f6fe13c260d36665f00e61Makoto Onuki 235f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov try { 236f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov if (c.moveToFirst()) { 237f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov entry.groupId = c.getLong(0); 238f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov } else { 239f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov ContentValues groupValues = new ContentValues(); 2409d990d339c9e3a9e03f6fe13c260d36665f00e61Makoto Onuki groupValues.put(GroupsColumns.ACCOUNT_ID, accountId); 241f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov groupValues.put(Groups.SOURCE_ID, sourceId); 2429d990d339c9e3a9e03f6fe13c260d36665f00e61Makoto Onuki long groupId = db.insert(Tables.GROUPS, null, groupValues); 243f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov if (groupId < 0) { 244f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov throw new IllegalStateException("unable to create a new group with " 245f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov + "this sourceid: " + groupValues); 246f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov } 247f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov entry.groupId = groupId; 248f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov } 249f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov } finally { 250f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov c.close(); 251f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov } 252f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov 253f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov return entry.groupId; 254f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov } 255f6d4922f664127d0455b45b1f7444c4553581282Dmitri Plotnikov} 256