ContactsDatabaseHelper.java revision 47ab23770b9f010a5e5277cda68267fe0613a1cc
1b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey/* 2b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey * Copyright (C) 2009 The Android Open Source Project 3b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey * 4b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey * Licensed under the Apache License, Version 2.0 (the "License"); 5b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey * you may not use this file except in compliance with the License. 6b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey * You may obtain a copy of the License at 7b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey * 8b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey * http://www.apache.org/licenses/LICENSE-2.0 9b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey * 10b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey * Unless required by applicable law or agreed to in writing, software 11b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey * distributed under the License is distributed on an "AS IS" BASIS, 12b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. 13b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey * See the License for the specific language governing permissions and 14b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey * limitations under the License 15b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey */ 16b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey 1728f8857b1b46bde18b85c6d3c2a63ac44c3c2e1cEvan Millarpackage com.android.providers.contacts; 18b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey 1967dde51ab932dc84d95a203b113989b13437f13dJeff Sharkeyimport com.android.internal.content.SyncStateContentProviderHelper; 2067dde51ab932dc84d95a203b113989b13437f13dJeff Sharkey 2182bd858c9911dfbd8dca52dc276333768b0a429eDmitri Plotnikovimport android.content.ContentResolver; 22619871b0fb0175d75ff9336bfe5aec0b27b9bdadJeff Sharkeyimport android.content.ContentValues; 23b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkeyimport android.content.Context; 24619871b0fb0175d75ff9336bfe5aec0b27b9bdadJeff Sharkeyimport android.content.pm.ApplicationInfo; 25619871b0fb0175d75ff9336bfe5aec0b27b9bdadJeff Sharkeyimport android.content.pm.PackageManager; 26619871b0fb0175d75ff9336bfe5aec0b27b9bdadJeff Sharkeyimport android.content.pm.PackageManager.NameNotFoundException; 27d91272b48f97243533c6580981e12a4847b5783fJeff Hamiltonimport android.content.res.Resources; 28b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkeyimport android.database.DatabaseUtils; 29f79538095a1af16dcd6e641448b627f60f197802Dmitri Plotnikovimport android.database.SQLException; 30b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkeyimport android.database.sqlite.SQLiteDatabase; 31b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkeyimport android.database.sqlite.SQLiteDoneException; 32b597adb79f1f57a24be2be09e3f45fa0f04f6f8fDmitri Plotnikovimport android.database.sqlite.SQLiteException; 33b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkeyimport android.database.sqlite.SQLiteOpenHelper; 34bf659107617a6291ba8bfeebc3f2e50138075ab5Dmitri Plotnikovimport android.database.sqlite.SQLiteQueryBuilder; 35b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkeyimport android.database.sqlite.SQLiteStatement; 364a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikovimport android.os.Binder; 37a3bd0246ca3741877488bca7aadd91c79b2fd8d2Fred Quintanaimport android.os.Bundle; 38b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkeyimport android.provider.BaseColumns; 39a3bd0246ca3741877488bca7aadd91c79b2fd8d2Fred Quintanaimport android.provider.ContactsContract; 40e99988b266dd1263162583e81e2b408e7329b1c8Dmitri Plotnikovimport android.provider.CallLog.Calls; 41b174c7ccd337a7bea6269139c9b09acc69ae40c1Dmitri Plotnikovimport android.provider.ContactsContract.AggregationExceptions; 42d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikovimport android.provider.ContactsContract.Contacts; 43de4c4d84028c6c6999c6d9277b54b661f207b992Evan Millarimport android.provider.ContactsContract.Data; 44ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkeyimport android.provider.ContactsContract.Groups; 45d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikovimport android.provider.ContactsContract.RawContacts; 46eb9ffdccfa19f5b2f22e688f733fd77e39605f9eJeff Sharkeyimport android.provider.ContactsContract.Settings; 4782bd858c9911dfbd8dca52dc276333768b0a429eDmitri Plotnikovimport android.provider.ContactsContract.StatusUpdates; 48ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkeyimport android.provider.ContactsContract.CommonDataKinds.GroupMembership; 49bf659107617a6291ba8bfeebc3f2e50138075ab5Dmitri Plotnikovimport android.provider.ContactsContract.CommonDataKinds.Phone; 5067dde51ab932dc84d95a203b113989b13437f13dJeff Sharkeyimport android.provider.SocialContract.Activities; 51bf659107617a6291ba8bfeebc3f2e50138075ab5Dmitri Plotnikovimport android.telephony.PhoneNumberUtils; 52b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkeyimport android.util.Log; 53b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey 54b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkeyimport java.util.HashMap; 55b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey 56b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey/** 57b38ed2c5ffeb20efc677b4a9229db4a00603aa8dDmitri Plotnikov * Database helper for contacts. Designed as a singleton to make sure that all 58b38ed2c5ffeb20efc677b4a9229db4a00603aa8dDmitri Plotnikov * {@link android.content.ContentProvider} users get the same reference. 59b38ed2c5ffeb20efc677b4a9229db4a00603aa8dDmitri Plotnikov * Provides handy methods for maintaining package and mime-type lookup tables. 60b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey */ 61b38ed2c5ffeb20efc677b4a9229db4a00603aa8dDmitri Plotnikov/* package */ class ContactsDatabaseHelper extends SQLiteOpenHelper { 62b38ed2c5ffeb20efc677b4a9229db4a00603aa8dDmitri Plotnikov private static final String TAG = "ContactsDatabaseHelper"; 63b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey 6447ab23770b9f010a5e5277cda68267fe0613a1ccDmitri Plotnikov private static final int DATABASE_VERSION = 103; 65e07913c61c320b0cc2036db3b714e39534d8cd7aJeff Sharkey 66b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey private static final String DATABASE_NAME = "contacts2.db"; 671f42f1958113b2dadc6cf26b51192b42f883f3b0Jeff Sharkey private static final String DATABASE_PRESENCE = "presence_db"; 68b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey 69b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey public interface Tables { 70d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov public static final String CONTACTS = "contacts"; 715ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov public static final String RAW_CONTACTS = "raw_contacts"; 72ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey public static final String PACKAGES = "packages"; 73ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey public static final String MIMETYPES = "mimetypes"; 74b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey public static final String PHONE_LOOKUP = "phone_lookup"; 75a8dc456684a104c7e5547ba17d44f952022cd8c5Dmitri Plotnikov public static final String NAME_LOOKUP = "name_lookup"; 76b174c7ccd337a7bea6269139c9b09acc69ae40c1Dmitri Plotnikov public static final String AGGREGATION_EXCEPTIONS = "agg_exceptions"; 77eb9ffdccfa19f5b2f22e688f733fd77e39605f9eJeff Sharkey public static final String SETTINGS = "settings"; 78b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey public static final String DATA = "data"; 79ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey public static final String GROUPS = "groups"; 801f42f1958113b2dadc6cf26b51192b42f883f3b0Jeff Sharkey public static final String PRESENCE = "presence"; 81e46667e641cd1c60998e1ccab4b60531d5b12ef7Dmitri Plotnikov public static final String AGGREGATED_PRESENCE = "agg_presence"; 82b597adb79f1f57a24be2be09e3f45fa0f04f6f8fDmitri Plotnikov public static final String NICKNAME_LOOKUP = "nickname_lookup"; 83e99988b266dd1263162583e81e2b408e7329b1c8Dmitri Plotnikov public static final String CALLS = "calls"; 84226c3dc6e93ca76a84c99100caa31045cba06cf6Fred Quintana public static final String CONTACT_ENTITIES = "contact_entities_view"; 85d237c80845d8e13164d34278d3c20e31f8d80b4dDaisuke Miyakawa public static final String CONTACT_ENTITIES_RESTRICTED = "contact_entities_view_restricted"; 86a23cd5b6f478f6c9dda54173e84bd0098b9f3364Dmitri Plotnikov public static final String STATUS_UPDATES = "status_updates"; 87b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey 88ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey public static final String DATA_JOIN_MIMETYPES = "data " 891b03c2d019966fba89dad3678dd9f04e4e5f4802Dmitri Plotnikov + "JOIN mimetypes ON (data.mimetype_id = mimetypes._id)"; 90b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey 9111944a13b31aa7c98f1079697f24b3a1999ca571Dmitri Plotnikov public static final String DATA_JOIN_RAW_CONTACTS = "data " 928e45e5f2142db78941b095f7418cc05b71668094Dmitri Plotnikov + "JOIN raw_contacts ON (data.raw_contact_id = raw_contacts._id)"; 9311944a13b31aa7c98f1079697f24b3a1999ca571Dmitri Plotnikov 945ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov public static final String DATA_JOIN_MIMETYPE_RAW_CONTACTS = "data " 95c70dc0e38ff82c6e6d6b7458637c54fbdf446aacDmitri Plotnikov + "JOIN mimetypes ON (data.mimetype_id = mimetypes._id) " 96c70dc0e38ff82c6e6d6b7458637c54fbdf446aacDmitri Plotnikov + "JOIN raw_contacts ON (data.raw_contact_id = raw_contacts._id)"; 97bf659107617a6291ba8bfeebc3f2e50138075ab5Dmitri Plotnikov 985ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov public static final String DATA_JOIN_RAW_CONTACTS_GROUPS = "data " 991b03c2d019966fba89dad3678dd9f04e4e5f4802Dmitri Plotnikov + "JOIN raw_contacts ON (data.raw_contact_id = raw_contacts._id)" 100ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey + "LEFT OUTER JOIN groups ON (groups._id = data." + GroupMembership.GROUP_ROW_ID 101ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey + ")"; 102ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey 1035ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov public static final String DATA_JOIN_PACKAGES_MIMETYPES_RAW_CONTACTS = "data " 1041b03c2d019966fba89dad3678dd9f04e4e5f4802Dmitri Plotnikov + "JOIN mimetypes ON (data.mimetype_id = mimetypes._id) " 1051b03c2d019966fba89dad3678dd9f04e4e5f4802Dmitri Plotnikov + "JOIN raw_contacts ON (data.raw_contact_id = raw_contacts._id) " 1061b03c2d019966fba89dad3678dd9f04e4e5f4802Dmitri Plotnikov + "LEFT OUTER JOIN packages ON (data.package_id = packages._id)"; 10767dde51ab932dc84d95a203b113989b13437f13dJeff Sharkey 108d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov public static final String DATA_JOIN_PACKAGES_MIMETYPES_RAW_CONTACTS_CONTACTS = "data " 1091b03c2d019966fba89dad3678dd9f04e4e5f4802Dmitri Plotnikov + "JOIN raw_contacts ON (data.raw_contact_id = raw_contacts._id) " 1101b03c2d019966fba89dad3678dd9f04e4e5f4802Dmitri Plotnikov + "JOIN mimetypes ON (data.mimetype_id = mimetypes._id) " 11167dde51ab932dc84d95a203b113989b13437f13dJeff Sharkey + "LEFT OUTER JOIN packages ON (data.package_id = packages._id) " 112d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov + "LEFT OUTER JOIN contacts ON (raw_contacts.contact_id = contacts._id)"; 1137e4676dfcaa8853b81c2133e0e318ed3436fe787Fred Quintana 1142815f58f72f109790585931f601a63ddc02536a5Evan Millar public static final String RAW_CONTACTS_JOIN_CONTACTS = "raw_contacts " 1152815f58f72f109790585931f601a63ddc02536a5Evan Millar + "LEFT OUTER JOIN contacts ON (raw_contacts.contact_id = contacts._id)"; 1162815f58f72f109790585931f601a63ddc02536a5Evan Millar 117e07913c61c320b0cc2036db3b714e39534d8cd7aJeff Sharkey // NOTE: This requires late binding of GroupMembership MIME-type 118e07913c61c320b0cc2036db3b714e39534d8cd7aJeff Sharkey public static final String RAW_CONTACTS_JOIN_SETTINGS_DATA_GROUPS = "raw_contacts " 119e07913c61c320b0cc2036db3b714e39534d8cd7aJeff Sharkey + "LEFT OUTER JOIN settings ON (" 120e07913c61c320b0cc2036db3b714e39534d8cd7aJeff Sharkey + "raw_contacts.account_name = settings.account_name AND " 121e07913c61c320b0cc2036db3b714e39534d8cd7aJeff Sharkey + "raw_contacts.account_type = settings.account_type) " 122e07913c61c320b0cc2036db3b714e39534d8cd7aJeff Sharkey + "LEFT OUTER JOIN data ON (data.mimetype_id=? AND " 123e07913c61c320b0cc2036db3b714e39534d8cd7aJeff Sharkey + "data.raw_contact_id = raw_contacts._id) " 124e07913c61c320b0cc2036db3b714e39534d8cd7aJeff Sharkey + "LEFT OUTER JOIN groups ON (groups._id = data." + GroupMembership.GROUP_ROW_ID 125e07913c61c320b0cc2036db3b714e39534d8cd7aJeff Sharkey + ")"; 126e07913c61c320b0cc2036db3b714e39534d8cd7aJeff Sharkey 127e07913c61c320b0cc2036db3b714e39534d8cd7aJeff Sharkey // NOTE: This requires late binding of GroupMembership MIME-type 128e07913c61c320b0cc2036db3b714e39534d8cd7aJeff Sharkey public static final String SETTINGS_JOIN_RAW_CONTACTS_DATA_MIMETYPES_CONTACTS = "settings " 129e07913c61c320b0cc2036db3b714e39534d8cd7aJeff Sharkey + "LEFT OUTER JOIN raw_contacts ON (" 130e07913c61c320b0cc2036db3b714e39534d8cd7aJeff Sharkey + "raw_contacts.account_name = settings.account_name AND " 131e07913c61c320b0cc2036db3b714e39534d8cd7aJeff Sharkey + "raw_contacts.account_type = settings.account_type) " 132e07913c61c320b0cc2036db3b714e39534d8cd7aJeff Sharkey + "LEFT OUTER JOIN data ON (data.mimetype_id=? AND " 133e07913c61c320b0cc2036db3b714e39534d8cd7aJeff Sharkey + "data.raw_contact_id = raw_contacts._id) " 134e07913c61c320b0cc2036db3b714e39534d8cd7aJeff Sharkey + "LEFT OUTER JOIN contacts ON (raw_contacts.contact_id = contacts._id)"; 135e07913c61c320b0cc2036db3b714e39534d8cd7aJeff Sharkey 136d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov public static final String DATA_JOIN_MIMETYPES_RAW_CONTACTS_CONTACTS = "data " 1371b03c2d019966fba89dad3678dd9f04e4e5f4802Dmitri Plotnikov + "JOIN mimetypes ON (data.mimetype_id = mimetypes._id) " 1381b03c2d019966fba89dad3678dd9f04e4e5f4802Dmitri Plotnikov + "JOIN raw_contacts ON (data.raw_contact_id = raw_contacts._id) " 139d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov + "LEFT OUTER JOIN contacts ON (raw_contacts.contact_id = contacts._id)"; 140ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey 141c70dc0e38ff82c6e6d6b7458637c54fbdf446aacDmitri Plotnikov public static final String DATA_INNER_JOIN_MIMETYPES_RAW_CONTACTS_CONTACTS = "data " 142c70dc0e38ff82c6e6d6b7458637c54fbdf446aacDmitri Plotnikov + "JOIN mimetypes ON (data.mimetype_id = mimetypes._id) " 143c70dc0e38ff82c6e6d6b7458637c54fbdf446aacDmitri Plotnikov + "JOIN raw_contacts ON (data.raw_contact_id = raw_contacts._id) " 144c70dc0e38ff82c6e6d6b7458637c54fbdf446aacDmitri Plotnikov + "JOIN contacts ON (raw_contacts.contact_id = contacts._id)"; 145c70dc0e38ff82c6e6d6b7458637c54fbdf446aacDmitri Plotnikov 146d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov public static final String DATA_JOIN_PACKAGES_MIMETYPES_RAW_CONTACTS_CONTACTS_GROUPS = 1475ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov "data " 1481b03c2d019966fba89dad3678dd9f04e4e5f4802Dmitri Plotnikov + "JOIN mimetypes ON (data.mimetype_id = mimetypes._id) " 1491b03c2d019966fba89dad3678dd9f04e4e5f4802Dmitri Plotnikov + "JOIN raw_contacts ON (data.raw_contact_id = raw_contacts._id) " 15067dde51ab932dc84d95a203b113989b13437f13dJeff Sharkey + "LEFT OUTER JOIN packages ON (data.package_id = packages._id) " 1519261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana + "LEFT OUTER JOIN groups " 1529261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana + " ON (mimetypes.mimetype='" + GroupMembership.CONTENT_ITEM_TYPE + "' " 1539261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana + " AND groups._id = data." + GroupMembership.GROUP_ROW_ID + ") " 154d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov + "LEFT OUTER JOIN contacts ON (raw_contacts.contact_id = contacts._id)"; 1559261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana 1565ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov public static final String DATA_JOIN_PACKAGES_MIMETYPES_RAW_CONTACTS_GROUPS = "data " 1571b03c2d019966fba89dad3678dd9f04e4e5f4802Dmitri Plotnikov + "JOIN mimetypes ON (data.mimetype_id = mimetypes._id) " 1581b03c2d019966fba89dad3678dd9f04e4e5f4802Dmitri Plotnikov + "JOIN raw_contacts ON (data.raw_contact_id = raw_contacts._id) " 15967dde51ab932dc84d95a203b113989b13437f13dJeff Sharkey + "LEFT OUTER JOIN packages ON (data.package_id = packages._id) " 1609261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana + "LEFT OUTER JOIN groups " 1619261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana + " ON (mimetypes.mimetype='" + GroupMembership.CONTENT_ITEM_TYPE + "' " 1629261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana + " AND groups._id = data." + GroupMembership.GROUP_ROW_ID + ") "; 163ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey 164ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey public static final String GROUPS_JOIN_PACKAGES = "groups " 165ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey + "LEFT OUTER JOIN packages ON (groups.package_id = packages._id)"; 166ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey 167d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov public static final String GROUPS_JOIN_PACKAGES_DATA_RAW_CONTACTS_CONTACTS = "groups " 168ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey + "LEFT OUTER JOIN packages ON (groups.package_id = packages._id) " 1699261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana + "LEFT OUTER JOIN data " 1709261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana + " ON (groups._id = data." + GroupMembership.GROUP_ROW_ID + ") " 1715ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov + "LEFT OUTER JOIN raw_contacts ON (data.raw_contact_id = raw_contacts._id) " 172d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov + "LEFT OUTER JOIN contacts ON (raw_contacts.contact_id = contacts._id)"; 173b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey 174b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey public static final String ACTIVITIES = "activities"; 175b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey 176ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey public static final String ACTIVITIES_JOIN_MIMETYPES = "activities " 177ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey + "LEFT OUTER JOIN mimetypes ON (activities.mimetype_id = mimetypes._id)"; 178b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey 179d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov public static final String ACTIVITIES_JOIN_PACKAGES_MIMETYPES_RAW_CONTACTS_CONTACTS = 1805ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov "activities " 18167dde51ab932dc84d95a203b113989b13437f13dJeff Sharkey + "LEFT OUTER JOIN packages ON (activities.package_id = packages._id) " 182ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey + "LEFT OUTER JOIN mimetypes ON (activities.mimetype_id = mimetypes._id) " 1835ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov + "LEFT OUTER JOIN raw_contacts ON (activities.author_contact_id = " + 1845ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov "raw_contacts._id) " 185d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov + "LEFT OUTER JOIN contacts ON (raw_contacts.contact_id = contacts._id)"; 1867e4676dfcaa8853b81c2133e0e318ed3436fe787Fred Quintana 1875ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov public static final String NAME_LOOKUP_JOIN_RAW_CONTACTS = "name_lookup " 1885ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov + "INNER JOIN raw_contacts ON (name_lookup.raw_contact_id = raw_contacts._id)"; 189b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey } 190b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey 1914a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov public interface Views { 1924a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov public static final String DATA_ALL = "view_data"; 1934a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov public static final String DATA_RESTRICTED = "view_data_restricted"; 1944a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov 1954a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov public static final String RAW_CONTACTS_ALL = "view_raw_contacts"; 1964a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov public static final String RAW_CONTACTS_RESTRICTED = "view_raw_contacts_restricted"; 1974a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov 1984a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov public static final String CONTACTS_ALL = "view_contacts"; 1994a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov public static final String CONTACTS_RESTRICTED = "view_contacts_restricted"; 20089c626eb655440c86a2e5df076e83708c1b32c17Dmitri Plotnikov 20189c626eb655440c86a2e5df076e83708c1b32c17Dmitri Plotnikov public static final String GROUPS_ALL = "view_groups"; 2024a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov } 2034a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov 2041f42f1958113b2dadc6cf26b51192b42f883f3b0Jeff Sharkey public interface Clauses { 205e07913c61c320b0cc2036db3b714e39534d8cd7aJeff Sharkey final String MIMETYPE_IS_GROUP_MEMBERSHIP = MimetypesColumns.CONCRETE_MIMETYPE + "='" 206e07913c61c320b0cc2036db3b714e39534d8cd7aJeff Sharkey + GroupMembership.CONTENT_ITEM_TYPE + "'"; 207ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey 208e07913c61c320b0cc2036db3b714e39534d8cd7aJeff Sharkey final String BELONGS_TO_GROUP = DataColumns.CONCRETE_GROUP_ID + "=" 209ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey + GroupsColumns.CONCRETE_ID; 210ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey 21168936cefd4caa779169ea00ffd1adc399e634c9bJeff Sharkey final String HAVING_NO_GROUPS = "COUNT(" + DataColumns.CONCRETE_GROUP_ID + ") == 0"; 2129261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana 21368936cefd4caa779169ea00ffd1adc399e634c9bJeff Sharkey final String GROUP_BY_ACCOUNT_CONTACT_ID = SettingsColumns.CONCRETE_ACCOUNT_NAME + "," 21468936cefd4caa779169ea00ffd1adc399e634c9bJeff Sharkey + SettingsColumns.CONCRETE_ACCOUNT_TYPE + "," + RawContacts.CONTACT_ID; 215e07913c61c320b0cc2036db3b714e39534d8cd7aJeff Sharkey 216e07913c61c320b0cc2036db3b714e39534d8cd7aJeff Sharkey final String RAW_CONTACT_IS_LOCAL = RawContactsColumns.CONCRETE_ACCOUNT_NAME 217e07913c61c320b0cc2036db3b714e39534d8cd7aJeff Sharkey + " IS NULL AND " + RawContactsColumns.CONCRETE_ACCOUNT_TYPE + " IS NULL"; 218e07913c61c320b0cc2036db3b714e39534d8cd7aJeff Sharkey 219e07913c61c320b0cc2036db3b714e39534d8cd7aJeff Sharkey final String ZERO_GROUP_MEMBERSHIPS = "COUNT(" + GroupsColumns.CONCRETE_ID + ")=0"; 220e07913c61c320b0cc2036db3b714e39534d8cd7aJeff Sharkey 2211a21fa6383449df4bf0d46138a23aa02dfa235a0Jeff Sharkey final String OUTER_RAW_CONTACTS = "outer_raw_contacts"; 2221a21fa6383449df4bf0d46138a23aa02dfa235a0Jeff Sharkey final String OUTER_RAW_CONTACTS_ID = OUTER_RAW_CONTACTS + "." + RawContacts._ID; 2231a21fa6383449df4bf0d46138a23aa02dfa235a0Jeff Sharkey 224b3ce7aaa2390698c9424d17df4d2979dcd902cfdDmitri Plotnikov final String CONTACT_IS_VISIBLE = 225b3ce7aaa2390698c9424d17df4d2979dcd902cfdDmitri Plotnikov "SELECT " + 2261a21fa6383449df4bf0d46138a23aa02dfa235a0Jeff Sharkey "MAX((SELECT (CASE WHEN " + 227b3ce7aaa2390698c9424d17df4d2979dcd902cfdDmitri Plotnikov "(CASE" + 228b3ce7aaa2390698c9424d17df4d2979dcd902cfdDmitri Plotnikov " WHEN " + RAW_CONTACT_IS_LOCAL + 229b3ce7aaa2390698c9424d17df4d2979dcd902cfdDmitri Plotnikov " THEN 1 " + 230b3ce7aaa2390698c9424d17df4d2979dcd902cfdDmitri Plotnikov " WHEN " + ZERO_GROUP_MEMBERSHIPS + 231b3ce7aaa2390698c9424d17df4d2979dcd902cfdDmitri Plotnikov " THEN " + Settings.UNGROUPED_VISIBLE + 232b3ce7aaa2390698c9424d17df4d2979dcd902cfdDmitri Plotnikov " ELSE MAX(" + Groups.GROUP_VISIBLE + ")" + 233b3ce7aaa2390698c9424d17df4d2979dcd902cfdDmitri Plotnikov "END)=1 THEN 1 ELSE 0 END)" + 234b3ce7aaa2390698c9424d17df4d2979dcd902cfdDmitri Plotnikov " FROM " + Tables.RAW_CONTACTS_JOIN_SETTINGS_DATA_GROUPS + 2351a21fa6383449df4bf0d46138a23aa02dfa235a0Jeff Sharkey " WHERE " + RawContactsColumns.CONCRETE_ID + "=" + OUTER_RAW_CONTACTS_ID + "))" + 2361a21fa6383449df4bf0d46138a23aa02dfa235a0Jeff Sharkey " FROM " + Tables.RAW_CONTACTS + " AS " + OUTER_RAW_CONTACTS + 237b3ce7aaa2390698c9424d17df4d2979dcd902cfdDmitri Plotnikov " WHERE " + RawContacts.CONTACT_ID + "=" + ContactsColumns.CONCRETE_ID + 238b3ce7aaa2390698c9424d17df4d2979dcd902cfdDmitri Plotnikov " GROUP BY " + RawContacts.CONTACT_ID; 239e07913c61c320b0cc2036db3b714e39534d8cd7aJeff Sharkey 240e07913c61c320b0cc2036db3b714e39534d8cd7aJeff Sharkey final String GROUP_HAS_ACCOUNT_AND_SOURCE_ID = Groups.SOURCE_ID + "=? AND " 241e07913c61c320b0cc2036db3b714e39534d8cd7aJeff Sharkey + Groups.ACCOUNT_NAME + "=? AND " + Groups.ACCOUNT_TYPE + "=?"; 2421f42f1958113b2dadc6cf26b51192b42f883f3b0Jeff Sharkey } 2431f42f1958113b2dadc6cf26b51192b42f883f3b0Jeff Sharkey 244d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov public interface ContactsColumns { 2454a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov /** 2464a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov * This flag is set for a contact if it has only one constituent raw contact and 2474a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov * it is restricted. 2484a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov */ 24967dde51ab932dc84d95a203b113989b13437f13dJeff Sharkey public static final String SINGLE_IS_RESTRICTED = "single_is_restricted"; 250ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey 251a23cd5b6f478f6c9dda54173e84bd0098b9f3364Dmitri Plotnikov public static final String LAST_STATUS_UPDATE_ID = "status_update_id"; 252a23cd5b6f478f6c9dda54173e84bd0098b9f3364Dmitri Plotnikov 253d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov public static final String CONCRETE_ID = Tables.CONTACTS + "." + BaseColumns._ID; 254d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov public static final String CONCRETE_DISPLAY_NAME = Tables.CONTACTS + "." 255d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov + Contacts.DISPLAY_NAME; 25667dde51ab932dc84d95a203b113989b13437f13dJeff Sharkey 257d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov public static final String CONCRETE_TIMES_CONTACTED = Tables.CONTACTS + "." 258d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov + Contacts.TIMES_CONTACTED; 259d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov public static final String CONCRETE_LAST_TIME_CONTACTED = Tables.CONTACTS + "." 260d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov + Contacts.LAST_TIME_CONTACTED; 261d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov public static final String CONCRETE_STARRED = Tables.CONTACTS + "." + Contacts.STARRED; 262d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov public static final String CONCRETE_CUSTOM_RINGTONE = Tables.CONTACTS + "." 263d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov + Contacts.CUSTOM_RINGTONE; 264d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov public static final String CONCRETE_SEND_TO_VOICEMAIL = Tables.CONTACTS + "." 265d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov + Contacts.SEND_TO_VOICEMAIL; 266619871b0fb0175d75ff9336bfe5aec0b27b9bdadJeff Sharkey } 267619871b0fb0175d75ff9336bfe5aec0b27b9bdadJeff Sharkey 2686cffee46a1334d2b3ed19f436b27638451541044Dmitri Plotnikov public interface RawContactsColumns { 26933b41fdb8d7c3c654cb070799c9d6e2b4ab16078Dmitri Plotnikov public static final String CONCRETE_ID = 2705ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov Tables.RAW_CONTACTS + "." + BaseColumns._ID; 2719261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana public static final String CONCRETE_ACCOUNT_NAME = 2725ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov Tables.RAW_CONTACTS + "." + RawContacts.ACCOUNT_NAME; 2739261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana public static final String CONCRETE_ACCOUNT_TYPE = 2745ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov Tables.RAW_CONTACTS + "." + RawContacts.ACCOUNT_TYPE; 27533b41fdb8d7c3c654cb070799c9d6e2b4ab16078Dmitri Plotnikov public static final String CONCRETE_SOURCE_ID = 2765ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov Tables.RAW_CONTACTS + "." + RawContacts.SOURCE_ID; 27733b41fdb8d7c3c654cb070799c9d6e2b4ab16078Dmitri Plotnikov public static final String CONCRETE_VERSION = 2785ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov Tables.RAW_CONTACTS + "." + RawContacts.VERSION; 27933b41fdb8d7c3c654cb070799c9d6e2b4ab16078Dmitri Plotnikov public static final String CONCRETE_DIRTY = 2805ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov Tables.RAW_CONTACTS + "." + RawContacts.DIRTY; 28133b41fdb8d7c3c654cb070799c9d6e2b4ab16078Dmitri Plotnikov public static final String CONCRETE_DELETED = 2825ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov Tables.RAW_CONTACTS + "." + RawContacts.DELETED; 2837a4550f2afb24b2112b6c937f416c6f46ece35f4Fred Quintana public static final String CONCRETE_SYNC1 = 2847a4550f2afb24b2112b6c937f416c6f46ece35f4Fred Quintana Tables.RAW_CONTACTS + "." + RawContacts.SYNC1; 2857a4550f2afb24b2112b6c937f416c6f46ece35f4Fred Quintana public static final String CONCRETE_SYNC2 = 2867a4550f2afb24b2112b6c937f416c6f46ece35f4Fred Quintana Tables.RAW_CONTACTS + "." + RawContacts.SYNC2; 2877a4550f2afb24b2112b6c937f416c6f46ece35f4Fred Quintana public static final String CONCRETE_SYNC3 = 2887a4550f2afb24b2112b6c937f416c6f46ece35f4Fred Quintana Tables.RAW_CONTACTS + "." + RawContacts.SYNC3; 2897a4550f2afb24b2112b6c937f416c6f46ece35f4Fred Quintana public static final String CONCRETE_SYNC4 = 2907a4550f2afb24b2112b6c937f416c6f46ece35f4Fred Quintana Tables.RAW_CONTACTS + "." + RawContacts.SYNC4; 291c76d0a78fe2d3471195cfa555bab016eec154f07Jeff Sharkey public static final String CONCRETE_STARRED = 292c76d0a78fe2d3471195cfa555bab016eec154f07Jeff Sharkey Tables.RAW_CONTACTS + "." + RawContacts.STARRED; 2938e45e5f2142db78941b095f7418cc05b71668094Dmitri Plotnikov 29425abcf949c0dd826a770b437489b83de48975ceaDmitri Plotnikov public static final String DISPLAY_NAME = "display_name"; 29525abcf949c0dd826a770b437489b83de48975ceaDmitri Plotnikov public static final String DISPLAY_NAME_SOURCE = "display_name_source"; 2968e45e5f2142db78941b095f7418cc05b71668094Dmitri Plotnikov public static final String AGGREGATION_NEEDED = "aggregation_needed"; 297619871b0fb0175d75ff9336bfe5aec0b27b9bdadJeff Sharkey } 298619871b0fb0175d75ff9336bfe5aec0b27b9bdadJeff Sharkey 29925abcf949c0dd826a770b437489b83de48975ceaDmitri Plotnikov /** 30025abcf949c0dd826a770b437489b83de48975ceaDmitri Plotnikov * Types of data used to produce the display name for a contact. Listed in the order 30125abcf949c0dd826a770b437489b83de48975ceaDmitri Plotnikov * of increasing priority. 30225abcf949c0dd826a770b437489b83de48975ceaDmitri Plotnikov */ 30325abcf949c0dd826a770b437489b83de48975ceaDmitri Plotnikov public interface DisplayNameSources { 30425abcf949c0dd826a770b437489b83de48975ceaDmitri Plotnikov int UNDEFINED = 0; 30525abcf949c0dd826a770b437489b83de48975ceaDmitri Plotnikov int EMAIL = 10; 30625abcf949c0dd826a770b437489b83de48975ceaDmitri Plotnikov int PHONE = 20; 30725abcf949c0dd826a770b437489b83de48975ceaDmitri Plotnikov int ORGANIZATION = 30; 308a5d05d90333a70d471d78e82caeb5cfa2e4d4c59Tadashi G. Takaoka int NICKNAME = 35; 30925abcf949c0dd826a770b437489b83de48975ceaDmitri Plotnikov int STRUCTURED_NAME = 40; 31025abcf949c0dd826a770b437489b83de48975ceaDmitri Plotnikov } 31125abcf949c0dd826a770b437489b83de48975ceaDmitri Plotnikov 312619871b0fb0175d75ff9336bfe5aec0b27b9bdadJeff Sharkey public interface DataColumns { 31367dde51ab932dc84d95a203b113989b13437f13dJeff Sharkey public static final String PACKAGE_ID = "package_id"; 314b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey public static final String MIMETYPE_ID = "mimetype_id"; 315ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey 316ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey public static final String CONCRETE_ID = Tables.DATA + "." + BaseColumns._ID; 317226c3dc6e93ca76a84c99100caa31045cba06cf6Fred Quintana public static final String CONCRETE_MIMETYPE_ID = Tables.DATA + "." + MIMETYPE_ID; 318d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov public static final String CONCRETE_RAW_CONTACT_ID = Tables.DATA + "." 319d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov + Data.RAW_CONTACT_ID; 320ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey public static final String CONCRETE_GROUP_ID = Tables.DATA + "." 321ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey + GroupMembership.GROUP_ROW_ID; 322e80e514a6175ad2ee03ea6eff6201e0e47d5a710Dmitri Plotnikov 323e80e514a6175ad2ee03ea6eff6201e0e47d5a710Dmitri Plotnikov public static final String CONCRETE_DATA1 = Tables.DATA + "." + Data.DATA1; 324e80e514a6175ad2ee03ea6eff6201e0e47d5a710Dmitri Plotnikov public static final String CONCRETE_DATA2 = Tables.DATA + "." + Data.DATA2; 325e80e514a6175ad2ee03ea6eff6201e0e47d5a710Dmitri Plotnikov public static final String CONCRETE_DATA3 = Tables.DATA + "." + Data.DATA3; 326e80e514a6175ad2ee03ea6eff6201e0e47d5a710Dmitri Plotnikov public static final String CONCRETE_DATA4 = Tables.DATA + "." + Data.DATA4; 327e80e514a6175ad2ee03ea6eff6201e0e47d5a710Dmitri Plotnikov public static final String CONCRETE_DATA5 = Tables.DATA + "." + Data.DATA5; 328e80e514a6175ad2ee03ea6eff6201e0e47d5a710Dmitri Plotnikov public static final String CONCRETE_DATA6 = Tables.DATA + "." + Data.DATA6; 329e80e514a6175ad2ee03ea6eff6201e0e47d5a710Dmitri Plotnikov public static final String CONCRETE_DATA7 = Tables.DATA + "." + Data.DATA7; 330e80e514a6175ad2ee03ea6eff6201e0e47d5a710Dmitri Plotnikov public static final String CONCRETE_DATA8 = Tables.DATA + "." + Data.DATA8; 331e80e514a6175ad2ee03ea6eff6201e0e47d5a710Dmitri Plotnikov public static final String CONCRETE_DATA9 = Tables.DATA + "." + Data.DATA9; 332e80e514a6175ad2ee03ea6eff6201e0e47d5a710Dmitri Plotnikov public static final String CONCRETE_DATA10 = Tables.DATA + "." + Data.DATA10; 3330f8f3b3e4a6ad18c5868d0215cc137845a2ddc74Dmitri Plotnikov public static final String CONCRETE_DATA11 = Tables.DATA + "." + Data.DATA11; 3340f8f3b3e4a6ad18c5868d0215cc137845a2ddc74Dmitri Plotnikov public static final String CONCRETE_DATA12 = Tables.DATA + "." + Data.DATA12; 3350f8f3b3e4a6ad18c5868d0215cc137845a2ddc74Dmitri Plotnikov public static final String CONCRETE_DATA13 = Tables.DATA + "." + Data.DATA13; 3360f8f3b3e4a6ad18c5868d0215cc137845a2ddc74Dmitri Plotnikov public static final String CONCRETE_DATA14 = Tables.DATA + "." + Data.DATA14; 3370f8f3b3e4a6ad18c5868d0215cc137845a2ddc74Dmitri Plotnikov public static final String CONCRETE_DATA15 = Tables.DATA + "." + Data.DATA15; 338e80e514a6175ad2ee03ea6eff6201e0e47d5a710Dmitri Plotnikov public static final String CONCRETE_IS_PRIMARY = Tables.DATA + "." + Data.IS_PRIMARY; 339226c3dc6e93ca76a84c99100caa31045cba06cf6Fred Quintana public static final String CONCRETE_PACKAGE_ID = Tables.DATA + "." + PACKAGE_ID; 340e80e514a6175ad2ee03ea6eff6201e0e47d5a710Dmitri Plotnikov } 341e80e514a6175ad2ee03ea6eff6201e0e47d5a710Dmitri Plotnikov 3420f8f3b3e4a6ad18c5868d0215cc137845a2ddc74Dmitri Plotnikov // Used only for legacy API support 3430f8f3b3e4a6ad18c5868d0215cc137845a2ddc74Dmitri Plotnikov public interface ExtensionsColumns { 3440f8f3b3e4a6ad18c5868d0215cc137845a2ddc74Dmitri Plotnikov public static final String NAME = Data.DATA1; 3450f8f3b3e4a6ad18c5868d0215cc137845a2ddc74Dmitri Plotnikov public static final String VALUE = Data.DATA2; 3460f8f3b3e4a6ad18c5868d0215cc137845a2ddc74Dmitri Plotnikov } 3470f8f3b3e4a6ad18c5868d0215cc137845a2ddc74Dmitri Plotnikov 3480f8f3b3e4a6ad18c5868d0215cc137845a2ddc74Dmitri Plotnikov public interface GroupMembershipColumns { 3495ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov public static final String RAW_CONTACT_ID = Data.RAW_CONTACT_ID; 3500f8f3b3e4a6ad18c5868d0215cc137845a2ddc74Dmitri Plotnikov public static final String GROUP_ROW_ID = GroupMembership.GROUP_ROW_ID; 3510f8f3b3e4a6ad18c5868d0215cc137845a2ddc74Dmitri Plotnikov } 3520f8f3b3e4a6ad18c5868d0215cc137845a2ddc74Dmitri Plotnikov 353e80e514a6175ad2ee03ea6eff6201e0e47d5a710Dmitri Plotnikov public interface PhoneColumns { 354e80e514a6175ad2ee03ea6eff6201e0e47d5a710Dmitri Plotnikov public static final String NORMALIZED_NUMBER = Data.DATA4; 355e80e514a6175ad2ee03ea6eff6201e0e47d5a710Dmitri Plotnikov public static final String CONCRETE_NORMALIZED_NUMBER = DataColumns.CONCRETE_DATA4; 356ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey } 357ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey 358ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey public interface GroupsColumns { 35967dde51ab932dc84d95a203b113989b13437f13dJeff Sharkey public static final String PACKAGE_ID = "package_id"; 36067dde51ab932dc84d95a203b113989b13437f13dJeff Sharkey 361ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey public static final String CONCRETE_ID = Tables.GROUPS + "." + BaseColumns._ID; 36267dde51ab932dc84d95a203b113989b13437f13dJeff Sharkey public static final String CONCRETE_SOURCE_ID = Tables.GROUPS + "." + Groups.SOURCE_ID; 363341e4621f2ee7614c66bc25dd3da70eaaa866b46Jeff Sharkey public static final String CONCRETE_ACCOUNT_NAME = Tables.GROUPS + "." + Groups.ACCOUNT_NAME; 364341e4621f2ee7614c66bc25dd3da70eaaa866b46Jeff Sharkey public static final String CONCRETE_ACCOUNT_TYPE = Tables.GROUPS + "." + Groups.ACCOUNT_TYPE; 365341e4621f2ee7614c66bc25dd3da70eaaa866b46Jeff Sharkey } 366b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey 367b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey public interface ActivitiesColumns { 368b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey public static final String PACKAGE_ID = "package_id"; 369b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey public static final String MIMETYPE_ID = "mimetype_id"; 370b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey } 371b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey 372b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey public interface PhoneLookupColumns { 373b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey public static final String _ID = BaseColumns._ID; 374b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey public static final String DATA_ID = "data_id"; 3755ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov public static final String RAW_CONTACT_ID = "raw_contact_id"; 376b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey public static final String NORMALIZED_NUMBER = "normalized_number"; 377b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey } 378b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey 379a8dc456684a104c7e5547ba17d44f952022cd8c5Dmitri Plotnikov public interface NameLookupColumns { 3805ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov public static final String RAW_CONTACT_ID = "raw_contact_id"; 38114bba94bbe0f2e215ad7b3b9417754a1ba0d95bfDmitri Plotnikov public static final String DATA_ID = "data_id"; 382a8dc456684a104c7e5547ba17d44f952022cd8c5Dmitri Plotnikov public static final String NORMALIZED_NAME = "normalized_name"; 383a8dc456684a104c7e5547ba17d44f952022cd8c5Dmitri Plotnikov public static final String NAME_TYPE = "name_type"; 384a8dc456684a104c7e5547ba17d44f952022cd8c5Dmitri Plotnikov } 385a8dc456684a104c7e5547ba17d44f952022cd8c5Dmitri Plotnikov 386a5ad551e1753086825499f1aeb6415bb986f3588Dmitri Plotnikov public final static class NameLookupType { 3872a03d9c2bf627795963561a0f9406b23dc93fec5Dmitri Plotnikov public static final int NAME_EXACT = 0; 3882a03d9c2bf627795963561a0f9406b23dc93fec5Dmitri Plotnikov public static final int NAME_VARIANT = 1; 3892a03d9c2bf627795963561a0f9406b23dc93fec5Dmitri Plotnikov public static final int NAME_COLLATION_KEY = 2; 3902a03d9c2bf627795963561a0f9406b23dc93fec5Dmitri Plotnikov public static final int NICKNAME = 3; 3912a03d9c2bf627795963561a0f9406b23dc93fec5Dmitri Plotnikov public static final int EMAIL_BASED_NICKNAME = 4; 392a5d05d90333a70d471d78e82caeb5cfa2e4d4c59Tadashi G. Takaoka public static final int ORGANIZATION = 5; 393a8dc456684a104c7e5547ba17d44f952022cd8c5Dmitri Plotnikov 394a5ad551e1753086825499f1aeb6415bb986f3588Dmitri Plotnikov // This is the highest name lookup type code plus one 395a5d05d90333a70d471d78e82caeb5cfa2e4d4c59Tadashi G. Takaoka public static final int TYPE_COUNT = 6; 396a5ad551e1753086825499f1aeb6415bb986f3588Dmitri Plotnikov 397a5ad551e1753086825499f1aeb6415bb986f3588Dmitri Plotnikov public static boolean isBasedOnStructuredName(int nameLookupType) { 3982a03d9c2bf627795963561a0f9406b23dc93fec5Dmitri Plotnikov return nameLookupType == NameLookupType.NAME_EXACT 3992a03d9c2bf627795963561a0f9406b23dc93fec5Dmitri Plotnikov || nameLookupType == NameLookupType.NAME_VARIANT 4002a03d9c2bf627795963561a0f9406b23dc93fec5Dmitri Plotnikov || nameLookupType == NameLookupType.NAME_COLLATION_KEY; 401a5ad551e1753086825499f1aeb6415bb986f3588Dmitri Plotnikov } 402a8dc456684a104c7e5547ba17d44f952022cd8c5Dmitri Plotnikov } 403a8dc456684a104c7e5547ba17d44f952022cd8c5Dmitri Plotnikov 404ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey public interface PackagesColumns { 405b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey public static final String _ID = BaseColumns._ID; 406b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey public static final String PACKAGE = "package"; 407226c3dc6e93ca76a84c99100caa31045cba06cf6Fred Quintana 408226c3dc6e93ca76a84c99100caa31045cba06cf6Fred Quintana public static final String CONCRETE_ID = Tables.PACKAGES + "." + _ID; 409b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey } 410b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey 411ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey public interface MimetypesColumns { 412b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey public static final String _ID = BaseColumns._ID; 413b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey public static final String MIMETYPE = "mimetype"; 414ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey 415ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey public static final String CONCRETE_ID = Tables.MIMETYPES + "." + BaseColumns._ID; 416ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey public static final String CONCRETE_MIMETYPE = Tables.MIMETYPES + "." + MIMETYPE; 417b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey } 418b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey 419b174c7ccd337a7bea6269139c9b09acc69ae40c1Dmitri Plotnikov public interface AggregationExceptionColumns { 420b174c7ccd337a7bea6269139c9b09acc69ae40c1Dmitri Plotnikov public static final String _ID = BaseColumns._ID; 421b174c7ccd337a7bea6269139c9b09acc69ae40c1Dmitri Plotnikov } 422b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey 423b597adb79f1f57a24be2be09e3f45fa0f04f6f8fDmitri Plotnikov public interface NicknameLookupColumns { 424b597adb79f1f57a24be2be09e3f45fa0f04f6f8fDmitri Plotnikov public static final String NAME = "name"; 425b597adb79f1f57a24be2be09e3f45fa0f04f6f8fDmitri Plotnikov public static final String CLUSTER = "cluster"; 426b597adb79f1f57a24be2be09e3f45fa0f04f6f8fDmitri Plotnikov } 427b597adb79f1f57a24be2be09e3f45fa0f04f6f8fDmitri Plotnikov 428e07913c61c320b0cc2036db3b714e39534d8cd7aJeff Sharkey public interface SettingsColumns { 429e07913c61c320b0cc2036db3b714e39534d8cd7aJeff Sharkey public static final String CONCRETE_ACCOUNT_NAME = Tables.SETTINGS + "." 430e07913c61c320b0cc2036db3b714e39534d8cd7aJeff Sharkey + Settings.ACCOUNT_NAME; 431e07913c61c320b0cc2036db3b714e39534d8cd7aJeff Sharkey public static final String CONCRETE_ACCOUNT_TYPE = Tables.SETTINGS + "." 432e07913c61c320b0cc2036db3b714e39534d8cd7aJeff Sharkey + Settings.ACCOUNT_TYPE; 433e07913c61c320b0cc2036db3b714e39534d8cd7aJeff Sharkey } 434e07913c61c320b0cc2036db3b714e39534d8cd7aJeff Sharkey 4354dcd106ccc27dbbfaae86baf0cd57beb42c27cccDmitri Plotnikov public interface PresenceColumns { 4364dcd106ccc27dbbfaae86baf0cd57beb42c27cccDmitri Plotnikov String RAW_CONTACT_ID = "presence_raw_contact_id"; 437bffeabdf3dcf58f963ad1bb4d3e6e51f3ac16cfdDmitri Plotnikov String CONTACT_ID = "presence_contact_id"; 4384dcd106ccc27dbbfaae86baf0cd57beb42c27cccDmitri Plotnikov } 4394dcd106ccc27dbbfaae86baf0cd57beb42c27cccDmitri Plotnikov 440e46667e641cd1c60998e1ccab4b60531d5b12ef7Dmitri Plotnikov public interface AggregatedPresenceColumns { 441e46667e641cd1c60998e1ccab4b60531d5b12ef7Dmitri Plotnikov String CONTACT_ID = "presence_contact_id"; 4423296d3469bce0041a6cefc44d0486a2a7d0c9f82Jeff Sharkey 4433296d3469bce0041a6cefc44d0486a2a7d0c9f82Jeff Sharkey String CONCRETE_CONTACT_ID = Tables.AGGREGATED_PRESENCE + "." + CONTACT_ID; 444e46667e641cd1c60998e1ccab4b60531d5b12ef7Dmitri Plotnikov } 445e46667e641cd1c60998e1ccab4b60531d5b12ef7Dmitri Plotnikov 446a23cd5b6f478f6c9dda54173e84bd0098b9f3364Dmitri Plotnikov public interface StatusUpdatesColumns { 447a23cd5b6f478f6c9dda54173e84bd0098b9f3364Dmitri Plotnikov String DATA_ID = "status_update_data_id"; 4483296d3469bce0041a6cefc44d0486a2a7d0c9f82Jeff Sharkey 4493296d3469bce0041a6cefc44d0486a2a7d0c9f82Jeff Sharkey String CONCRETE_DATA_ID = Tables.STATUS_UPDATES + "." + DATA_ID; 4503296d3469bce0041a6cefc44d0486a2a7d0c9f82Jeff Sharkey 4513296d3469bce0041a6cefc44d0486a2a7d0c9f82Jeff Sharkey String CONCRETE_PRESENCE = Tables.STATUS_UPDATES + "." + StatusUpdates.PRESENCE; 4523296d3469bce0041a6cefc44d0486a2a7d0c9f82Jeff Sharkey String CONCRETE_STATUS = Tables.STATUS_UPDATES + "." + StatusUpdates.STATUS; 4533296d3469bce0041a6cefc44d0486a2a7d0c9f82Jeff Sharkey String CONCRETE_STATUS_TIMESTAMP = Tables.STATUS_UPDATES + "." 4543296d3469bce0041a6cefc44d0486a2a7d0c9f82Jeff Sharkey + StatusUpdates.STATUS_TIMESTAMP; 4553296d3469bce0041a6cefc44d0486a2a7d0c9f82Jeff Sharkey String CONCRETE_STATUS_RES_PACKAGE = Tables.STATUS_UPDATES + "." 4563296d3469bce0041a6cefc44d0486a2a7d0c9f82Jeff Sharkey + StatusUpdates.STATUS_RES_PACKAGE; 4573296d3469bce0041a6cefc44d0486a2a7d0c9f82Jeff Sharkey String CONCRETE_STATUS_LABEL = Tables.STATUS_UPDATES + "." + StatusUpdates.STATUS_LABEL; 4583296d3469bce0041a6cefc44d0486a2a7d0c9f82Jeff Sharkey String CONCRETE_STATUS_ICON = Tables.STATUS_UPDATES + "." + StatusUpdates.STATUS_ICON; 4593296d3469bce0041a6cefc44d0486a2a7d0c9f82Jeff Sharkey } 4603296d3469bce0041a6cefc44d0486a2a7d0c9f82Jeff Sharkey 4613296d3469bce0041a6cefc44d0486a2a7d0c9f82Jeff Sharkey public interface ContactsStatusUpdatesColumns { 4623296d3469bce0041a6cefc44d0486a2a7d0c9f82Jeff Sharkey String ALIAS = "contacts_" + Tables.STATUS_UPDATES; 4633296d3469bce0041a6cefc44d0486a2a7d0c9f82Jeff Sharkey 4643296d3469bce0041a6cefc44d0486a2a7d0c9f82Jeff Sharkey String CONCRETE_DATA_ID = ALIAS + "." + StatusUpdatesColumns.DATA_ID; 4653296d3469bce0041a6cefc44d0486a2a7d0c9f82Jeff Sharkey 4663296d3469bce0041a6cefc44d0486a2a7d0c9f82Jeff Sharkey String CONCRETE_PRESENCE = ALIAS + "." + StatusUpdates.PRESENCE; 4673296d3469bce0041a6cefc44d0486a2a7d0c9f82Jeff Sharkey String CONCRETE_STATUS = ALIAS + "." + StatusUpdates.STATUS; 4683296d3469bce0041a6cefc44d0486a2a7d0c9f82Jeff Sharkey String CONCRETE_STATUS_TIMESTAMP = ALIAS + "." + StatusUpdates.STATUS_TIMESTAMP; 4693296d3469bce0041a6cefc44d0486a2a7d0c9f82Jeff Sharkey String CONCRETE_STATUS_RES_PACKAGE = ALIAS + "." + StatusUpdates.STATUS_RES_PACKAGE; 4703296d3469bce0041a6cefc44d0486a2a7d0c9f82Jeff Sharkey String CONCRETE_STATUS_LABEL = ALIAS + "." + StatusUpdates.STATUS_LABEL; 4713296d3469bce0041a6cefc44d0486a2a7d0c9f82Jeff Sharkey String CONCRETE_STATUS_ICON = ALIAS + "." + StatusUpdates.STATUS_ICON; 472a23cd5b6f478f6c9dda54173e84bd0098b9f3364Dmitri Plotnikov } 473a23cd5b6f478f6c9dda54173e84bd0098b9f3364Dmitri Plotnikov 4743296d3469bce0041a6cefc44d0486a2a7d0c9f82Jeff Sharkey /** In-memory cache of previously found MIME-type mappings */ 475bf659107617a6291ba8bfeebc3f2e50138075ab5Dmitri Plotnikov private final HashMap<String, Long> mMimetypeCache = new HashMap<String, Long>(); 476b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey /** In-memory cache of previously found package name mappings */ 477bf659107617a6291ba8bfeebc3f2e50138075ab5Dmitri Plotnikov private final HashMap<String, Long> mPackageCache = new HashMap<String, Long>(); 478b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey 479b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey 480b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey /** Compiled statements for querying and inserting mappings */ 481b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey private SQLiteStatement mMimetypeQuery; 482b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey private SQLiteStatement mPackageQuery; 483d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov private SQLiteStatement mContactIdQuery; 484f4e1358f1c8f5fe5e9e7689e36e04c57c2385169Dmitri Plotnikov private SQLiteStatement mAggregationModeQuery; 485b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey private SQLiteStatement mMimetypeInsert; 486b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey private SQLiteStatement mPackageInsert; 487b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey private SQLiteStatement mDataMimetypeQuery; 488b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey private SQLiteStatement mActivitiesMimetypeQuery; 489b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey 490b597adb79f1f57a24be2be09e3f45fa0f04f6f8fDmitri Plotnikov private final Context mContext; 49135ed95769096bb5dd406ad7d1fcaa49a0e35a307Fred Quintana private final SyncStateContentProviderHelper mSyncState; 492f23764675b35b5262a39c79aad8e9842460274b2Dmitri Plotnikov 493b597adb79f1f57a24be2be09e3f45fa0f04f6f8fDmitri Plotnikov 494d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov /** Compiled statements for updating {@link Contacts#IN_VISIBLE_GROUP}. */ 495e07913c61c320b0cc2036db3b714e39534d8cd7aJeff Sharkey private SQLiteStatement mVisibleUpdate; 496ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey private SQLiteStatement mVisibleSpecificUpdate; 497ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey 498f79538095a1af16dcd6e641448b627f60f197802Dmitri Plotnikov private boolean mReopenDatabase = false; 499f79538095a1af16dcd6e641448b627f60f197802Dmitri Plotnikov 500b38ed2c5ffeb20efc677b4a9229db4a00603aa8dDmitri Plotnikov private static ContactsDatabaseHelper sSingleton = null; 501b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey 5023a6a49cfb06272e3e25f3c390a9cf4002da6e34dDaisuke Miyakawa private boolean mUseStrictPhoneNumberComparation; 5033a6a49cfb06272e3e25f3c390a9cf4002da6e34dDaisuke Miyakawa 504d91272b48f97243533c6580981e12a4847b5783fJeff Hamilton /** 505d91272b48f97243533c6580981e12a4847b5783fJeff Hamilton * List of package names with access to {@link RawContacts#IS_RESTRICTED} data. 506d91272b48f97243533c6580981e12a4847b5783fJeff Hamilton */ 507d91272b48f97243533c6580981e12a4847b5783fJeff Hamilton private String[] mUnrestrictedPackages; 508d91272b48f97243533c6580981e12a4847b5783fJeff Hamilton 509b38ed2c5ffeb20efc677b4a9229db4a00603aa8dDmitri Plotnikov public static synchronized ContactsDatabaseHelper getInstance(Context context) { 510b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey if (sSingleton == null) { 511b38ed2c5ffeb20efc677b4a9229db4a00603aa8dDmitri Plotnikov sSingleton = new ContactsDatabaseHelper(context); 512b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey } 513b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey return sSingleton; 514b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey } 515b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey 5161f42f1958113b2dadc6cf26b51192b42f883f3b0Jeff Sharkey /** 51731b86315536573a72dc7fff1baac3b314e5a04c3Dmitri Plotnikov * Private constructor, callers except unit tests should obtain an instance through 51835ed95769096bb5dd406ad7d1fcaa49a0e35a307Fred Quintana * {@link #getInstance(android.content.Context)} instead. 5191f42f1958113b2dadc6cf26b51192b42f883f3b0Jeff Sharkey */ 520b38ed2c5ffeb20efc677b4a9229db4a00603aa8dDmitri Plotnikov ContactsDatabaseHelper(Context context) { 521b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey super(context, DATABASE_NAME, null, DATABASE_VERSION); 522b5a3163481794babda78716e576e35818de0cc03Dianne Hackborn if (false) Log.i(TAG, "Creating OpenHelper"); 523d91272b48f97243533c6580981e12a4847b5783fJeff Hamilton Resources resources = context.getResources(); 524619871b0fb0175d75ff9336bfe5aec0b27b9bdadJeff Sharkey 525b597adb79f1f57a24be2be09e3f45fa0f04f6f8fDmitri Plotnikov mContext = context; 52628b3769e3fcecae56c3fc70cbcb0f95282b9640eFred Quintana mSyncState = new SyncStateContentProviderHelper(); 5273a6a49cfb06272e3e25f3c390a9cf4002da6e34dDaisuke Miyakawa mUseStrictPhoneNumberComparation = 528d91272b48f97243533c6580981e12a4847b5783fJeff Hamilton resources.getBoolean( 529d91272b48f97243533c6580981e12a4847b5783fJeff Hamilton com.android.internal.R.bool.config_use_strict_phone_number_comparation); 5300f5116227592cb8e724542c598daffa383964679Dmitri Plotnikov int resourceId = resources.getIdentifier("unrestricted_packages", "array", 5310f5116227592cb8e724542c598daffa383964679Dmitri Plotnikov context.getPackageName()); 5320f5116227592cb8e724542c598daffa383964679Dmitri Plotnikov if (resourceId != 0) { 5330f5116227592cb8e724542c598daffa383964679Dmitri Plotnikov mUnrestrictedPackages = resources.getStringArray(resourceId); 5340f5116227592cb8e724542c598daffa383964679Dmitri Plotnikov } else { 5350f5116227592cb8e724542c598daffa383964679Dmitri Plotnikov mUnrestrictedPackages = new String[0]; 5360f5116227592cb8e724542c598daffa383964679Dmitri Plotnikov } 537b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey } 538b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey 539b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey @Override 540b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey public void onOpen(SQLiteDatabase db) { 54135ed95769096bb5dd406ad7d1fcaa49a0e35a307Fred Quintana mSyncState.onDatabaseOpened(db); 54235ed95769096bb5dd406ad7d1fcaa49a0e35a307Fred Quintana 543b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey // Create compiled statements for package and mimetype lookups 544ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey mMimetypeQuery = db.compileStatement("SELECT " + MimetypesColumns._ID + " FROM " 545ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey + Tables.MIMETYPES + " WHERE " + MimetypesColumns.MIMETYPE + "=?"); 546ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey mPackageQuery = db.compileStatement("SELECT " + PackagesColumns._ID + " FROM " 547ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey + Tables.PACKAGES + " WHERE " + PackagesColumns.PACKAGE + "=?"); 548d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov mContactIdQuery = db.compileStatement("SELECT " + RawContacts.CONTACT_ID + " FROM " 5495ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov + Tables.RAW_CONTACTS + " WHERE " + RawContacts._ID + "=?"); 5506cffee46a1334d2b3ed19f436b27638451541044Dmitri Plotnikov mAggregationModeQuery = db.compileStatement("SELECT " + RawContacts.AGGREGATION_MODE 5515ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov + " FROM " + Tables.RAW_CONTACTS + " WHERE " + RawContacts._ID + "=?"); 552ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey mMimetypeInsert = db.compileStatement("INSERT INTO " + Tables.MIMETYPES + "(" 553ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey + MimetypesColumns.MIMETYPE + ") VALUES (?)"); 554ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey mPackageInsert = db.compileStatement("INSERT INTO " + Tables.PACKAGES + "(" 555ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey + PackagesColumns.PACKAGE + ") VALUES (?)"); 556ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey 557ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey mDataMimetypeQuery = db.compileStatement("SELECT " + MimetypesColumns.MIMETYPE + " FROM " 558ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey + Tables.DATA_JOIN_MIMETYPES + " WHERE " + Tables.DATA + "." + Data._ID + "=?"); 559ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey mActivitiesMimetypeQuery = db.compileStatement("SELECT " + MimetypesColumns.MIMETYPE 560ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey + " FROM " + Tables.ACTIVITIES_JOIN_MIMETYPES + " WHERE " + Tables.ACTIVITIES + "." 561b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey + Activities._ID + "=?"); 5621f42f1958113b2dadc6cf26b51192b42f883f3b0Jeff Sharkey 563e07913c61c320b0cc2036db3b714e39534d8cd7aJeff Sharkey // Compile statements for updating visibility 564d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov final String visibleUpdate = "UPDATE " + Tables.CONTACTS + " SET " 565e07913c61c320b0cc2036db3b714e39534d8cd7aJeff Sharkey + Contacts.IN_VISIBLE_GROUP + "=(" + Clauses.CONTACT_IS_VISIBLE + ")"; 566ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey 567e07913c61c320b0cc2036db3b714e39534d8cd7aJeff Sharkey mVisibleUpdate = db.compileStatement(visibleUpdate); 568ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey mVisibleSpecificUpdate = db.compileStatement(visibleUpdate + " WHERE " 569d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov + ContactsColumns.CONCRETE_ID + "=?"); 570ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey 5711f42f1958113b2dadc6cf26b51192b42f883f3b0Jeff Sharkey db.execSQL("ATTACH DATABASE ':memory:' AS " + DATABASE_PRESENCE + ";"); 572e46667e641cd1c60998e1ccab4b60531d5b12ef7Dmitri Plotnikov db.execSQL("CREATE TABLE IF NOT EXISTS " + DATABASE_PRESENCE + "." + Tables.PRESENCE + " ("+ 57382bd858c9911dfbd8dca52dc276333768b0a429eDmitri Plotnikov StatusUpdates.DATA_ID + " INTEGER PRIMARY KEY REFERENCES data(_id)," + 57482bd858c9911dfbd8dca52dc276333768b0a429eDmitri Plotnikov StatusUpdates.PROTOCOL + " INTEGER NOT NULL," + 57582bd858c9911dfbd8dca52dc276333768b0a429eDmitri Plotnikov StatusUpdates.CUSTOM_PROTOCOL + " TEXT," + 57682bd858c9911dfbd8dca52dc276333768b0a429eDmitri Plotnikov StatusUpdates.IM_HANDLE + " TEXT," + 57782bd858c9911dfbd8dca52dc276333768b0a429eDmitri Plotnikov StatusUpdates.IM_ACCOUNT + " TEXT," + 578a23cd5b6f478f6c9dda54173e84bd0098b9f3364Dmitri Plotnikov PresenceColumns.CONTACT_ID + " INTEGER REFERENCES contacts(_id)," + 579a23cd5b6f478f6c9dda54173e84bd0098b9f3364Dmitri Plotnikov PresenceColumns.RAW_CONTACT_ID + " INTEGER REFERENCES raw_contacts(_id)," + 58082bd858c9911dfbd8dca52dc276333768b0a429eDmitri Plotnikov StatusUpdates.PRESENCE + " INTEGER," + 58182bd858c9911dfbd8dca52dc276333768b0a429eDmitri Plotnikov "UNIQUE(" + StatusUpdates.PROTOCOL + ", " + StatusUpdates.CUSTOM_PROTOCOL 58282bd858c9911dfbd8dca52dc276333768b0a429eDmitri Plotnikov + ", " + StatusUpdates.IM_HANDLE + ", " + StatusUpdates.IM_ACCOUNT + ")" + 5831f42f1958113b2dadc6cf26b51192b42f883f3b0Jeff Sharkey ");"); 5841f42f1958113b2dadc6cf26b51192b42f883f3b0Jeff Sharkey 585e46667e641cd1c60998e1ccab4b60531d5b12ef7Dmitri Plotnikov db.execSQL("CREATE INDEX IF NOT EXISTS " + DATABASE_PRESENCE + ".presenceIndex" + " ON " 5864dcd106ccc27dbbfaae86baf0cd57beb42c27cccDmitri Plotnikov + Tables.PRESENCE + " (" + PresenceColumns.RAW_CONTACT_ID + ");"); 587e46667e641cd1c60998e1ccab4b60531d5b12ef7Dmitri Plotnikov 588e46667e641cd1c60998e1ccab4b60531d5b12ef7Dmitri Plotnikov db.execSQL("CREATE TABLE IF NOT EXISTS " 589e46667e641cd1c60998e1ccab4b60531d5b12ef7Dmitri Plotnikov + DATABASE_PRESENCE + "." + Tables.AGGREGATED_PRESENCE + " ("+ 590e46667e641cd1c60998e1ccab4b60531d5b12ef7Dmitri Plotnikov AggregatedPresenceColumns.CONTACT_ID 591e46667e641cd1c60998e1ccab4b60531d5b12ef7Dmitri Plotnikov + " INTEGER PRIMARY KEY REFERENCES contacts(_id)," + 59282bd858c9911dfbd8dca52dc276333768b0a429eDmitri Plotnikov StatusUpdates.PRESENCE_STATUS + " INTEGER" + 593e46667e641cd1c60998e1ccab4b60531d5b12ef7Dmitri Plotnikov ");"); 594bffeabdf3dcf58f963ad1bb4d3e6e51f3ac16cfdDmitri Plotnikov 595bffeabdf3dcf58f963ad1bb4d3e6e51f3ac16cfdDmitri Plotnikov 596bffeabdf3dcf58f963ad1bb4d3e6e51f3ac16cfdDmitri Plotnikov db.execSQL("CREATE TRIGGER " + DATABASE_PRESENCE + "." + Tables.PRESENCE + "_deleted" 597bffeabdf3dcf58f963ad1bb4d3e6e51f3ac16cfdDmitri Plotnikov + " BEFORE DELETE ON " + DATABASE_PRESENCE + "." + Tables.PRESENCE 598bffeabdf3dcf58f963ad1bb4d3e6e51f3ac16cfdDmitri Plotnikov + " BEGIN " 599bffeabdf3dcf58f963ad1bb4d3e6e51f3ac16cfdDmitri Plotnikov + " DELETE FROM " + Tables.AGGREGATED_PRESENCE 600bffeabdf3dcf58f963ad1bb4d3e6e51f3ac16cfdDmitri Plotnikov + " WHERE " + AggregatedPresenceColumns.CONTACT_ID + " = " + 601bffeabdf3dcf58f963ad1bb4d3e6e51f3ac16cfdDmitri Plotnikov "(SELECT " + PresenceColumns.CONTACT_ID + 602bffeabdf3dcf58f963ad1bb4d3e6e51f3ac16cfdDmitri Plotnikov " FROM " + Tables.PRESENCE + 603bffeabdf3dcf58f963ad1bb4d3e6e51f3ac16cfdDmitri Plotnikov " WHERE " + PresenceColumns.RAW_CONTACT_ID 604bffeabdf3dcf58f963ad1bb4d3e6e51f3ac16cfdDmitri Plotnikov + "=OLD." + PresenceColumns.RAW_CONTACT_ID + 605bffeabdf3dcf58f963ad1bb4d3e6e51f3ac16cfdDmitri Plotnikov " AND NOT EXISTS" + 606bffeabdf3dcf58f963ad1bb4d3e6e51f3ac16cfdDmitri Plotnikov "(SELECT " + PresenceColumns.RAW_CONTACT_ID + 607bffeabdf3dcf58f963ad1bb4d3e6e51f3ac16cfdDmitri Plotnikov " FROM " + Tables.PRESENCE + 608bffeabdf3dcf58f963ad1bb4d3e6e51f3ac16cfdDmitri Plotnikov " WHERE " + PresenceColumns.CONTACT_ID 609bffeabdf3dcf58f963ad1bb4d3e6e51f3ac16cfdDmitri Plotnikov + "=OLD." + PresenceColumns.CONTACT_ID + 610bffeabdf3dcf58f963ad1bb4d3e6e51f3ac16cfdDmitri Plotnikov " AND " + PresenceColumns.RAW_CONTACT_ID 611bffeabdf3dcf58f963ad1bb4d3e6e51f3ac16cfdDmitri Plotnikov + "!=OLD." + PresenceColumns.RAW_CONTACT_ID + "));" 612bffeabdf3dcf58f963ad1bb4d3e6e51f3ac16cfdDmitri Plotnikov + " END"); 613bffeabdf3dcf58f963ad1bb4d3e6e51f3ac16cfdDmitri Plotnikov 614bffeabdf3dcf58f963ad1bb4d3e6e51f3ac16cfdDmitri Plotnikov String replaceAggregatePresenceSql = 615bffeabdf3dcf58f963ad1bb4d3e6e51f3ac16cfdDmitri Plotnikov "INSERT OR REPLACE INTO " + Tables.AGGREGATED_PRESENCE + "(" 616bffeabdf3dcf58f963ad1bb4d3e6e51f3ac16cfdDmitri Plotnikov + AggregatedPresenceColumns.CONTACT_ID + ", " 61782bd858c9911dfbd8dca52dc276333768b0a429eDmitri Plotnikov + StatusUpdates.PRESENCE_STATUS + ")" + 618bffeabdf3dcf58f963ad1bb4d3e6e51f3ac16cfdDmitri Plotnikov " SELECT " + PresenceColumns.CONTACT_ID + "," 61982bd858c9911dfbd8dca52dc276333768b0a429eDmitri Plotnikov + "MAX(" + StatusUpdates.PRESENCE_STATUS + ")" + 620bffeabdf3dcf58f963ad1bb4d3e6e51f3ac16cfdDmitri Plotnikov " FROM " + Tables.PRESENCE + 621bffeabdf3dcf58f963ad1bb4d3e6e51f3ac16cfdDmitri Plotnikov " WHERE " + PresenceColumns.CONTACT_ID 622bffeabdf3dcf58f963ad1bb4d3e6e51f3ac16cfdDmitri Plotnikov + "=NEW." + PresenceColumns.CONTACT_ID + ";"; 623bffeabdf3dcf58f963ad1bb4d3e6e51f3ac16cfdDmitri Plotnikov 624bffeabdf3dcf58f963ad1bb4d3e6e51f3ac16cfdDmitri Plotnikov db.execSQL("CREATE TRIGGER " + DATABASE_PRESENCE + "." + Tables.PRESENCE + "_inserted" 625bffeabdf3dcf58f963ad1bb4d3e6e51f3ac16cfdDmitri Plotnikov + " AFTER INSERT ON " + DATABASE_PRESENCE + "." + Tables.PRESENCE 626bffeabdf3dcf58f963ad1bb4d3e6e51f3ac16cfdDmitri Plotnikov + " BEGIN " 627bffeabdf3dcf58f963ad1bb4d3e6e51f3ac16cfdDmitri Plotnikov + replaceAggregatePresenceSql 628bffeabdf3dcf58f963ad1bb4d3e6e51f3ac16cfdDmitri Plotnikov + " END"); 629bffeabdf3dcf58f963ad1bb4d3e6e51f3ac16cfdDmitri Plotnikov 630bffeabdf3dcf58f963ad1bb4d3e6e51f3ac16cfdDmitri Plotnikov db.execSQL("CREATE TRIGGER " + DATABASE_PRESENCE + "." + Tables.PRESENCE + "_updated" 631bffeabdf3dcf58f963ad1bb4d3e6e51f3ac16cfdDmitri Plotnikov + " AFTER UPDATE ON " + DATABASE_PRESENCE + "." + Tables.PRESENCE 632bffeabdf3dcf58f963ad1bb4d3e6e51f3ac16cfdDmitri Plotnikov + " BEGIN " 633bffeabdf3dcf58f963ad1bb4d3e6e51f3ac16cfdDmitri Plotnikov + replaceAggregatePresenceSql 634bffeabdf3dcf58f963ad1bb4d3e6e51f3ac16cfdDmitri Plotnikov + " END"); 635b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey } 636b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey 637b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey @Override 638b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey public void onCreate(SQLiteDatabase db) { 639b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey Log.i(TAG, "Bootstrapping database"); 640b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey 64135ed95769096bb5dd406ad7d1fcaa49a0e35a307Fred Quintana mSyncState.createDatabase(db); 64235ed95769096bb5dd406ad7d1fcaa49a0e35a307Fred Quintana 643b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey // One row per group of contacts corresponding to the same person 644d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov db.execSQL("CREATE TABLE " + Tables.CONTACTS + " (" + 645b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey BaseColumns._ID + " INTEGER PRIMARY KEY AUTOINCREMENT," + 646d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov Contacts.DISPLAY_NAME + " TEXT," + 647d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov Contacts.PHOTO_ID + " INTEGER REFERENCES data(_id)," + 648d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov Contacts.CUSTOM_RINGTONE + " TEXT," + 649d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov Contacts.SEND_TO_VOICEMAIL + " INTEGER NOT NULL DEFAULT 0," + 650d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov Contacts.TIMES_CONTACTED + " INTEGER NOT NULL DEFAULT 0," + 651d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov Contacts.LAST_TIME_CONTACTED + " INTEGER," + 652d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov Contacts.STARRED + " INTEGER NOT NULL DEFAULT 0," + 653cdbd854decda3f493b395c8867f2cd131d95d09fDmitri Plotnikov Contacts.IN_VISIBLE_GROUP + " INTEGER NOT NULL DEFAULT 1," + 654f992bfab334b760d36a053fc0b439382dcfb51adDmitri Plotnikov Contacts.HAS_PHONE_NUMBER + " INTEGER NOT NULL DEFAULT 0," + 6555870f2dcc2ac7715b2c078a886ee346622e7887eDmitri Plotnikov Contacts.LOOKUP_KEY + " TEXT," + 656a23cd5b6f478f6c9dda54173e84bd0098b9f3364Dmitri Plotnikov ContactsColumns.LAST_STATUS_UPDATE_ID + " INTEGER REFERENCES data(_id)," + 6574a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov ContactsColumns.SINGLE_IS_RESTRICTED + " INTEGER NOT NULL DEFAULT 0" + 658b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey ");"); 659b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey 66054d6316486a810f45abade9d985dbb52b6cb17e2Dmitri Plotnikov db.execSQL("CREATE INDEX contacts_visible_index ON " + Tables.CONTACTS + " (" + 661737858a04a157a0afad9ec81372c75d14bf68788Jeff Hamilton Contacts.IN_VISIBLE_GROUP + "," + 662737858a04a157a0afad9ec81372c75d14bf68788Jeff Hamilton Contacts.DISPLAY_NAME + " COLLATE LOCALIZED" + 66354d6316486a810f45abade9d985dbb52b6cb17e2Dmitri Plotnikov ");"); 66454d6316486a810f45abade9d985dbb52b6cb17e2Dmitri Plotnikov 66554d6316486a810f45abade9d985dbb52b6cb17e2Dmitri Plotnikov db.execSQL("CREATE INDEX contacts_has_phone_index ON " + Tables.CONTACTS + " (" + 66654d6316486a810f45abade9d985dbb52b6cb17e2Dmitri Plotnikov Contacts.HAS_PHONE_NUMBER + 66754d6316486a810f45abade9d985dbb52b6cb17e2Dmitri Plotnikov ");"); 66854d6316486a810f45abade9d985dbb52b6cb17e2Dmitri Plotnikov 66954d6316486a810f45abade9d985dbb52b6cb17e2Dmitri Plotnikov db.execSQL("CREATE INDEX contacts_restricted_index ON " + Tables.CONTACTS + " (" + 67054d6316486a810f45abade9d985dbb52b6cb17e2Dmitri Plotnikov ContactsColumns.SINGLE_IS_RESTRICTED + 67154d6316486a810f45abade9d985dbb52b6cb17e2Dmitri Plotnikov ");"); 67254d6316486a810f45abade9d985dbb52b6cb17e2Dmitri Plotnikov 673b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey // Contacts table 6745ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov db.execSQL("CREATE TABLE " + Tables.RAW_CONTACTS + " (" + 6756cffee46a1334d2b3ed19f436b27638451541044Dmitri Plotnikov RawContacts._ID + " INTEGER PRIMARY KEY AUTOINCREMENT," + 6766cffee46a1334d2b3ed19f436b27638451541044Dmitri Plotnikov RawContacts.IS_RESTRICTED + " INTEGER DEFAULT 0," + 6776cffee46a1334d2b3ed19f436b27638451541044Dmitri Plotnikov RawContacts.ACCOUNT_NAME + " STRING DEFAULT NULL, " + 6786cffee46a1334d2b3ed19f436b27638451541044Dmitri Plotnikov RawContacts.ACCOUNT_TYPE + " STRING DEFAULT NULL, " + 6796cffee46a1334d2b3ed19f436b27638451541044Dmitri Plotnikov RawContacts.SOURCE_ID + " TEXT," + 6806cffee46a1334d2b3ed19f436b27638451541044Dmitri Plotnikov RawContacts.VERSION + " INTEGER NOT NULL DEFAULT 1," + 68173776ffd5c00e94db987ee30864e9c7a8396d22dDmitri Plotnikov RawContacts.DIRTY + " INTEGER NOT NULL DEFAULT 0," + 68233b41fdb8d7c3c654cb070799c9d6e2b4ab16078Dmitri Plotnikov RawContacts.DELETED + " INTEGER NOT NULL DEFAULT 0," + 68354d6316486a810f45abade9d985dbb52b6cb17e2Dmitri Plotnikov RawContacts.CONTACT_ID + " INTEGER REFERENCES contacts(_id)," + 6846cffee46a1334d2b3ed19f436b27638451541044Dmitri Plotnikov RawContacts.AGGREGATION_MODE + " INTEGER NOT NULL DEFAULT " + 6856cffee46a1334d2b3ed19f436b27638451541044Dmitri Plotnikov RawContacts.AGGREGATION_MODE_DEFAULT + "," + 6868e45e5f2142db78941b095f7418cc05b71668094Dmitri Plotnikov RawContactsColumns.AGGREGATION_NEEDED + " INTEGER NOT NULL DEFAULT 1," + 6876cffee46a1334d2b3ed19f436b27638451541044Dmitri Plotnikov RawContacts.CUSTOM_RINGTONE + " TEXT," + 6886cffee46a1334d2b3ed19f436b27638451541044Dmitri Plotnikov RawContacts.SEND_TO_VOICEMAIL + " INTEGER NOT NULL DEFAULT 0," + 6896cffee46a1334d2b3ed19f436b27638451541044Dmitri Plotnikov RawContacts.TIMES_CONTACTED + " INTEGER NOT NULL DEFAULT 0," + 6906cffee46a1334d2b3ed19f436b27638451541044Dmitri Plotnikov RawContacts.LAST_TIME_CONTACTED + " INTEGER," + 69133b41fdb8d7c3c654cb070799c9d6e2b4ab16078Dmitri Plotnikov RawContacts.STARRED + " INTEGER NOT NULL DEFAULT 0," + 6923cfe8d532d509fbbe605454e3a32b2361b7e1501Dmitri Plotnikov RawContactsColumns.DISPLAY_NAME + " TEXT," + 69325abcf949c0dd826a770b437489b83de48975ceaDmitri Plotnikov RawContactsColumns.DISPLAY_NAME_SOURCE + " INTEGER NOT NULL DEFAULT " + 69425abcf949c0dd826a770b437489b83de48975ceaDmitri Plotnikov DisplayNameSources.UNDEFINED + "," + 6953cfe8d532d509fbbe605454e3a32b2361b7e1501Dmitri Plotnikov RawContacts.SYNC1 + " TEXT, " + 6963cfe8d532d509fbbe605454e3a32b2361b7e1501Dmitri Plotnikov RawContacts.SYNC2 + " TEXT, " + 6973cfe8d532d509fbbe605454e3a32b2361b7e1501Dmitri Plotnikov RawContacts.SYNC3 + " TEXT, " + 6983cfe8d532d509fbbe605454e3a32b2361b7e1501Dmitri Plotnikov RawContacts.SYNC4 + " TEXT " + 699b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey ");"); 700b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey 701ba965ceeb86dd9404d43f418daae357bc4afbdcdJeff Hamilton db.execSQL("CREATE TRIGGER raw_contacts_times_contacted UPDATE OF " + 702ba965ceeb86dd9404d43f418daae357bc4afbdcdJeff Hamilton RawContacts.LAST_TIME_CONTACTED + " ON " + Tables.RAW_CONTACTS + " " + 703ba965ceeb86dd9404d43f418daae357bc4afbdcdJeff Hamilton "BEGIN " + 704ba965ceeb86dd9404d43f418daae357bc4afbdcdJeff Hamilton "UPDATE " + Tables.RAW_CONTACTS + " SET " 705ba965ceeb86dd9404d43f418daae357bc4afbdcdJeff Hamilton + RawContacts.TIMES_CONTACTED + " = " + "" + 706ba965ceeb86dd9404d43f418daae357bc4afbdcdJeff Hamilton "(new." + RawContacts.TIMES_CONTACTED + " + 1)" 707ba965ceeb86dd9404d43f418daae357bc4afbdcdJeff Hamilton + " WHERE _id = new._id;" + 708ba965ceeb86dd9404d43f418daae357bc4afbdcdJeff Hamilton "END"); 709ba965ceeb86dd9404d43f418daae357bc4afbdcdJeff Hamilton 71054d6316486a810f45abade9d985dbb52b6cb17e2Dmitri Plotnikov db.execSQL("CREATE INDEX raw_contacts_contact_id_index ON " + Tables.RAW_CONTACTS + " (" + 71154d6316486a810f45abade9d985dbb52b6cb17e2Dmitri Plotnikov RawContacts.CONTACT_ID + 71254d6316486a810f45abade9d985dbb52b6cb17e2Dmitri Plotnikov ");"); 71354d6316486a810f45abade9d985dbb52b6cb17e2Dmitri Plotnikov 7145f515d93c04729e6cdc9b704d18579162d71d5f2Dmitri Plotnikov db.execSQL("CREATE INDEX raw_contacts_source_id_index ON " + Tables.RAW_CONTACTS + " (" + 7155f515d93c04729e6cdc9b704d18579162d71d5f2Dmitri Plotnikov RawContacts.SOURCE_ID + ", " + 7165f515d93c04729e6cdc9b704d18579162d71d5f2Dmitri Plotnikov RawContacts.ACCOUNT_TYPE + ", " + 7175f515d93c04729e6cdc9b704d18579162d71d5f2Dmitri Plotnikov RawContacts.ACCOUNT_NAME + 7185f515d93c04729e6cdc9b704d18579162d71d5f2Dmitri Plotnikov ");"); 7195f515d93c04729e6cdc9b704d18579162d71d5f2Dmitri Plotnikov 720f79538095a1af16dcd6e641448b627f60f197802Dmitri Plotnikov // TODO readd the index and investigate a controlled use of it 721f79538095a1af16dcd6e641448b627f60f197802Dmitri Plotnikov// db.execSQL("CREATE INDEX raw_contacts_agg_index ON " + Tables.RAW_CONTACTS + " (" + 722f79538095a1af16dcd6e641448b627f60f197802Dmitri Plotnikov// RawContactsColumns.AGGREGATION_NEEDED + 723f79538095a1af16dcd6e641448b627f60f197802Dmitri Plotnikov// ");"); 7248e45e5f2142db78941b095f7418cc05b71668094Dmitri Plotnikov 725b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey // Package name mapping table 726ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey db.execSQL("CREATE TABLE " + Tables.PACKAGES + " (" + 727ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey PackagesColumns._ID + " INTEGER PRIMARY KEY AUTOINCREMENT," + 728ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey PackagesColumns.PACKAGE + " TEXT NOT NULL" + 729b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey ");"); 730b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey 731ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey // Mimetype mapping table 732ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey db.execSQL("CREATE TABLE " + Tables.MIMETYPES + " (" + 733ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey MimetypesColumns._ID + " INTEGER PRIMARY KEY AUTOINCREMENT," + 734ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey MimetypesColumns.MIMETYPE + " TEXT NOT NULL" + 735b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey ");"); 736b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey 737b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey // Public generic data table 738b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey db.execSQL("CREATE TABLE " + Tables.DATA + " (" + 739b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey Data._ID + " INTEGER PRIMARY KEY AUTOINCREMENT," + 74067dde51ab932dc84d95a203b113989b13437f13dJeff Sharkey DataColumns.PACKAGE_ID + " INTEGER REFERENCES package(_id)," + 741b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey DataColumns.MIMETYPE_ID + " INTEGER REFERENCES mimetype(_id) NOT NULL," + 74211944a13b31aa7c98f1079697f24b3a1999ca571Dmitri Plotnikov Data.RAW_CONTACT_ID + " INTEGER REFERENCES raw_contacts(_id) NOT NULL," + 743f5b20724819e51b339ff6ba5b8eb6b444cc31452Fred Quintana Data.IS_PRIMARY + " INTEGER NOT NULL DEFAULT 0," + 744f5b20724819e51b339ff6ba5b8eb6b444cc31452Fred Quintana Data.IS_SUPER_PRIMARY + " INTEGER NOT NULL DEFAULT 0," + 745f5b20724819e51b339ff6ba5b8eb6b444cc31452Fred Quintana Data.DATA_VERSION + " INTEGER NOT NULL DEFAULT 0," + 746f5b20724819e51b339ff6ba5b8eb6b444cc31452Fred Quintana Data.DATA1 + " TEXT," + 747f5b20724819e51b339ff6ba5b8eb6b444cc31452Fred Quintana Data.DATA2 + " TEXT," + 748f5b20724819e51b339ff6ba5b8eb6b444cc31452Fred Quintana Data.DATA3 + " TEXT," + 749f5b20724819e51b339ff6ba5b8eb6b444cc31452Fred Quintana Data.DATA4 + " TEXT," + 750f5b20724819e51b339ff6ba5b8eb6b444cc31452Fred Quintana Data.DATA5 + " TEXT," + 751f5b20724819e51b339ff6ba5b8eb6b444cc31452Fred Quintana Data.DATA6 + " TEXT," + 752f5b20724819e51b339ff6ba5b8eb6b444cc31452Fred Quintana Data.DATA7 + " TEXT," + 753f5b20724819e51b339ff6ba5b8eb6b444cc31452Fred Quintana Data.DATA8 + " TEXT," + 754f5b20724819e51b339ff6ba5b8eb6b444cc31452Fred Quintana Data.DATA9 + " TEXT," + 75567dde51ab932dc84d95a203b113989b13437f13dJeff Sharkey Data.DATA10 + " TEXT," + 75667dde51ab932dc84d95a203b113989b13437f13dJeff Sharkey Data.DATA11 + " TEXT," + 75767dde51ab932dc84d95a203b113989b13437f13dJeff Sharkey Data.DATA12 + " TEXT," + 75867dde51ab932dc84d95a203b113989b13437f13dJeff Sharkey Data.DATA13 + " TEXT," + 75967dde51ab932dc84d95a203b113989b13437f13dJeff Sharkey Data.DATA14 + " TEXT," + 7603cfe8d532d509fbbe605454e3a32b2361b7e1501Dmitri Plotnikov Data.DATA15 + " TEXT," + 7613cfe8d532d509fbbe605454e3a32b2361b7e1501Dmitri Plotnikov Data.SYNC1 + " TEXT, " + 7623cfe8d532d509fbbe605454e3a32b2361b7e1501Dmitri Plotnikov Data.SYNC2 + " TEXT, " + 7633cfe8d532d509fbbe605454e3a32b2361b7e1501Dmitri Plotnikov Data.SYNC3 + " TEXT, " + 7643cfe8d532d509fbbe605454e3a32b2361b7e1501Dmitri Plotnikov Data.SYNC4 + " TEXT " + 765b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey ");"); 766b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey 76711944a13b31aa7c98f1079697f24b3a1999ca571Dmitri Plotnikov db.execSQL("CREATE INDEX data_raw_contact_id ON " + Tables.DATA + " (" + 76811944a13b31aa7c98f1079697f24b3a1999ca571Dmitri Plotnikov Data.RAW_CONTACT_ID + 76911944a13b31aa7c98f1079697f24b3a1999ca571Dmitri Plotnikov ");"); 77011944a13b31aa7c98f1079697f24b3a1999ca571Dmitri Plotnikov 77111944a13b31aa7c98f1079697f24b3a1999ca571Dmitri Plotnikov /** 77211944a13b31aa7c98f1079697f24b3a1999ca571Dmitri Plotnikov * For email lookup and similar queries. 77311944a13b31aa7c98f1079697f24b3a1999ca571Dmitri Plotnikov */ 774f23764675b35b5262a39c79aad8e9842460274b2Dmitri Plotnikov db.execSQL("CREATE INDEX data_mimetype_data1_index ON " + Tables.DATA + " (" + 77511944a13b31aa7c98f1079697f24b3a1999ca571Dmitri Plotnikov DataColumns.MIMETYPE_ID + "," + 776f23764675b35b5262a39c79aad8e9842460274b2Dmitri Plotnikov Data.DATA1 + 77711944a13b31aa7c98f1079697f24b3a1999ca571Dmitri Plotnikov ");"); 77811944a13b31aa7c98f1079697f24b3a1999ca571Dmitri Plotnikov 779b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey // Private phone numbers table used for lookup 780b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey db.execSQL("CREATE TABLE " + Tables.PHONE_LOOKUP + " (" + 781f79538095a1af16dcd6e641448b627f60f197802Dmitri Plotnikov PhoneLookupColumns.DATA_ID 782f79538095a1af16dcd6e641448b627f60f197802Dmitri Plotnikov + " INTEGER PRIMARY KEY REFERENCES data(_id) NOT NULL," + 7835ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov PhoneLookupColumns.RAW_CONTACT_ID 7845ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov + " INTEGER REFERENCES raw_contacts(_id) NOT NULL," + 785b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey PhoneLookupColumns.NORMALIZED_NUMBER + " TEXT NOT NULL" + 786b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey ");"); 787b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey 788b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey db.execSQL("CREATE INDEX phone_lookup_index ON " + Tables.PHONE_LOOKUP + " (" + 789f79538095a1af16dcd6e641448b627f60f197802Dmitri Plotnikov PhoneLookupColumns.NORMALIZED_NUMBER + "," + 790f79538095a1af16dcd6e641448b627f60f197802Dmitri Plotnikov PhoneLookupColumns.RAW_CONTACT_ID + "," + 791b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey PhoneLookupColumns.DATA_ID + 792b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey ");"); 793b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey 794a8dc456684a104c7e5547ba17d44f952022cd8c5Dmitri Plotnikov // Private name/nickname table used for lookup 795a8dc456684a104c7e5547ba17d44f952022cd8c5Dmitri Plotnikov db.execSQL("CREATE TABLE " + Tables.NAME_LOOKUP + " (" + 79614bba94bbe0f2e215ad7b3b9417754a1ba0d95bfDmitri Plotnikov NameLookupColumns.DATA_ID 79714bba94bbe0f2e215ad7b3b9417754a1ba0d95bfDmitri Plotnikov + " INTEGER REFERENCES data(_id) NOT NULL," + 7985ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov NameLookupColumns.RAW_CONTACT_ID 7995ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov + " INTEGER REFERENCES raw_contacts(_id) NOT NULL," + 80011944a13b31aa7c98f1079697f24b3a1999ca571Dmitri Plotnikov NameLookupColumns.NORMALIZED_NAME + " TEXT NOT NULL," + 80111944a13b31aa7c98f1079697f24b3a1999ca571Dmitri Plotnikov NameLookupColumns.NAME_TYPE + " INTEGER NOT NULL," + 80214bba94bbe0f2e215ad7b3b9417754a1ba0d95bfDmitri Plotnikov "PRIMARY KEY (" 80314bba94bbe0f2e215ad7b3b9417754a1ba0d95bfDmitri Plotnikov + NameLookupColumns.DATA_ID + ", " 80411944a13b31aa7c98f1079697f24b3a1999ca571Dmitri Plotnikov + NameLookupColumns.NORMALIZED_NAME + ", " 80511944a13b31aa7c98f1079697f24b3a1999ca571Dmitri Plotnikov + NameLookupColumns.NAME_TYPE + ")" + 806a8dc456684a104c7e5547ba17d44f952022cd8c5Dmitri Plotnikov ");"); 807a8dc456684a104c7e5547ba17d44f952022cd8c5Dmitri Plotnikov 808a8dc456684a104c7e5547ba17d44f952022cd8c5Dmitri Plotnikov db.execSQL("CREATE INDEX name_lookup_index ON " + Tables.NAME_LOOKUP + " (" + 809f79538095a1af16dcd6e641448b627f60f197802Dmitri Plotnikov NameLookupColumns.NORMALIZED_NAME + "," + 810f79538095a1af16dcd6e641448b627f60f197802Dmitri Plotnikov NameLookupColumns.NAME_TYPE + ", " + 8115ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov NameLookupColumns.RAW_CONTACT_ID + 812a8dc456684a104c7e5547ba17d44f952022cd8c5Dmitri Plotnikov ");"); 813a8dc456684a104c7e5547ba17d44f952022cd8c5Dmitri Plotnikov 81414bba94bbe0f2e215ad7b3b9417754a1ba0d95bfDmitri Plotnikov db.execSQL("CREATE INDEX name_lookup_raw_contact_id_index ON " + Tables.NAME_LOOKUP + " (" + 81514bba94bbe0f2e215ad7b3b9417754a1ba0d95bfDmitri Plotnikov NameLookupColumns.RAW_CONTACT_ID + 81614bba94bbe0f2e215ad7b3b9417754a1ba0d95bfDmitri Plotnikov ");"); 81714bba94bbe0f2e215ad7b3b9417754a1ba0d95bfDmitri Plotnikov 818b597adb79f1f57a24be2be09e3f45fa0f04f6f8fDmitri Plotnikov db.execSQL("CREATE TABLE " + Tables.NICKNAME_LOOKUP + " (" + 819b597adb79f1f57a24be2be09e3f45fa0f04f6f8fDmitri Plotnikov NicknameLookupColumns.NAME + " TEXT," + 820b597adb79f1f57a24be2be09e3f45fa0f04f6f8fDmitri Plotnikov NicknameLookupColumns.CLUSTER + " TEXT" + 821b597adb79f1f57a24be2be09e3f45fa0f04f6f8fDmitri Plotnikov ");"); 822b597adb79f1f57a24be2be09e3f45fa0f04f6f8fDmitri Plotnikov 823b597adb79f1f57a24be2be09e3f45fa0f04f6f8fDmitri Plotnikov db.execSQL("CREATE UNIQUE INDEX nickname_lookup_index ON " + Tables.NICKNAME_LOOKUP + " (" + 824b597adb79f1f57a24be2be09e3f45fa0f04f6f8fDmitri Plotnikov NicknameLookupColumns.NAME + ", " + 825b597adb79f1f57a24be2be09e3f45fa0f04f6f8fDmitri Plotnikov NicknameLookupColumns.CLUSTER + 826b597adb79f1f57a24be2be09e3f45fa0f04f6f8fDmitri Plotnikov ");"); 827b597adb79f1f57a24be2be09e3f45fa0f04f6f8fDmitri Plotnikov 828ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey // Groups table 829ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey db.execSQL("CREATE TABLE " + Tables.GROUPS + " (" + 830ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey Groups._ID + " INTEGER PRIMARY KEY AUTOINCREMENT," + 83167dde51ab932dc84d95a203b113989b13437f13dJeff Sharkey GroupsColumns.PACKAGE_ID + " INTEGER REFERENCES package(_id)," + 832035b4cc204be2641079a0b04e9ee9791a8f8248bFred Quintana Groups.ACCOUNT_NAME + " STRING DEFAULT NULL, " + 833035b4cc204be2641079a0b04e9ee9791a8f8248bFred Quintana Groups.ACCOUNT_TYPE + " STRING DEFAULT NULL, " + 834ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey Groups.SOURCE_ID + " TEXT," + 8359261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana Groups.VERSION + " INTEGER NOT NULL DEFAULT 1," + 83673776ffd5c00e94db987ee30864e9c7a8396d22dDmitri Plotnikov Groups.DIRTY + " INTEGER NOT NULL DEFAULT 0," + 837ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey Groups.TITLE + " TEXT," + 83867dde51ab932dc84d95a203b113989b13437f13dJeff Sharkey Groups.TITLE_RES + " INTEGER," + 8390f8f3b3e4a6ad18c5868d0215cc137845a2ddc74Dmitri Plotnikov Groups.NOTES + " TEXT," + 8400f8f3b3e4a6ad18c5868d0215cc137845a2ddc74Dmitri Plotnikov Groups.SYSTEM_ID + " TEXT," + 84194021b213e4db367f60b30fcbfe9019e28571784Fred Quintana Groups.DELETED + " INTEGER NOT NULL DEFAULT 0," + 842eb9ffdccfa19f5b2f22e688f733fd77e39605f9eJeff Sharkey Groups.GROUP_VISIBLE + " INTEGER NOT NULL DEFAULT 0," + 843ea547d55f864133861b2db44221ae0c2ac6c1a68Fred Quintana Groups.SHOULD_SYNC + " INTEGER NOT NULL DEFAULT 1," + 8443cfe8d532d509fbbe605454e3a32b2361b7e1501Dmitri Plotnikov Groups.SYNC1 + " TEXT, " + 8453cfe8d532d509fbbe605454e3a32b2361b7e1501Dmitri Plotnikov Groups.SYNC2 + " TEXT, " + 8463cfe8d532d509fbbe605454e3a32b2361b7e1501Dmitri Plotnikov Groups.SYNC3 + " TEXT, " + 8473cfe8d532d509fbbe605454e3a32b2361b7e1501Dmitri Plotnikov Groups.SYNC4 + " TEXT " + 848ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey ");"); 849ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey 8505f515d93c04729e6cdc9b704d18579162d71d5f2Dmitri Plotnikov db.execSQL("CREATE INDEX groups_source_id_index ON " + Tables.GROUPS + " (" + 8515f515d93c04729e6cdc9b704d18579162d71d5f2Dmitri Plotnikov Groups.SOURCE_ID + ", " + 8525f515d93c04729e6cdc9b704d18579162d71d5f2Dmitri Plotnikov Groups.ACCOUNT_TYPE + ", " + 8535f515d93c04729e6cdc9b704d18579162d71d5f2Dmitri Plotnikov Groups.ACCOUNT_NAME + 8545f515d93c04729e6cdc9b704d18579162d71d5f2Dmitri Plotnikov ");"); 8555f515d93c04729e6cdc9b704d18579162d71d5f2Dmitri Plotnikov 856b174c7ccd337a7bea6269139c9b09acc69ae40c1Dmitri Plotnikov db.execSQL("CREATE TABLE IF NOT EXISTS " + Tables.AGGREGATION_EXCEPTIONS + " (" + 857b174c7ccd337a7bea6269139c9b09acc69ae40c1Dmitri Plotnikov AggregationExceptionColumns._ID + " INTEGER PRIMARY KEY AUTOINCREMENT," + 858b174c7ccd337a7bea6269139c9b09acc69ae40c1Dmitri Plotnikov AggregationExceptions.TYPE + " INTEGER NOT NULL, " + 8590c0adda32be5de3acf392ab715cff468b6b340f8Dmitri Plotnikov AggregationExceptions.RAW_CONTACT_ID1 8605ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov + " INTEGER REFERENCES raw_contacts(_id), " + 8610c0adda32be5de3acf392ab715cff468b6b340f8Dmitri Plotnikov AggregationExceptions.RAW_CONTACT_ID2 8625ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov + " INTEGER REFERENCES raw_contacts(_id)" + 863b0160a0bcf6d59eaa43fd501e124b95f873e0157Marc Blank ");"); 864b174c7ccd337a7bea6269139c9b09acc69ae40c1Dmitri Plotnikov 865b174c7ccd337a7bea6269139c9b09acc69ae40c1Dmitri Plotnikov db.execSQL("CREATE UNIQUE INDEX IF NOT EXISTS aggregation_exception_index1 ON " + 866b174c7ccd337a7bea6269139c9b09acc69ae40c1Dmitri Plotnikov Tables.AGGREGATION_EXCEPTIONS + " (" + 8670c0adda32be5de3acf392ab715cff468b6b340f8Dmitri Plotnikov AggregationExceptions.RAW_CONTACT_ID1 + ", " + 8680c0adda32be5de3acf392ab715cff468b6b340f8Dmitri Plotnikov AggregationExceptions.RAW_CONTACT_ID2 + 869b174c7ccd337a7bea6269139c9b09acc69ae40c1Dmitri Plotnikov ");"); 870b174c7ccd337a7bea6269139c9b09acc69ae40c1Dmitri Plotnikov 871b174c7ccd337a7bea6269139c9b09acc69ae40c1Dmitri Plotnikov db.execSQL("CREATE UNIQUE INDEX IF NOT EXISTS aggregation_exception_index2 ON " + 872b174c7ccd337a7bea6269139c9b09acc69ae40c1Dmitri Plotnikov Tables.AGGREGATION_EXCEPTIONS + " (" + 8730c0adda32be5de3acf392ab715cff468b6b340f8Dmitri Plotnikov AggregationExceptions.RAW_CONTACT_ID2 + ", " + 8740c0adda32be5de3acf392ab715cff468b6b340f8Dmitri Plotnikov AggregationExceptions.RAW_CONTACT_ID1 + 875b174c7ccd337a7bea6269139c9b09acc69ae40c1Dmitri Plotnikov ");"); 876b174c7ccd337a7bea6269139c9b09acc69ae40c1Dmitri Plotnikov 877eb9ffdccfa19f5b2f22e688f733fd77e39605f9eJeff Sharkey db.execSQL("CREATE TABLE IF NOT EXISTS " + Tables.SETTINGS + " (" + 878eb9ffdccfa19f5b2f22e688f733fd77e39605f9eJeff Sharkey Settings.ACCOUNT_NAME + " STRING NOT NULL," + 879eb9ffdccfa19f5b2f22e688f733fd77e39605f9eJeff Sharkey Settings.ACCOUNT_TYPE + " STRING NOT NULL," + 880eb9ffdccfa19f5b2f22e688f733fd77e39605f9eJeff Sharkey Settings.UNGROUPED_VISIBLE + " INTEGER NOT NULL DEFAULT 0," + 881eb9ffdccfa19f5b2f22e688f733fd77e39605f9eJeff Sharkey Settings.SHOULD_SYNC + " INTEGER NOT NULL DEFAULT 1, " + 882eb9ffdccfa19f5b2f22e688f733fd77e39605f9eJeff Sharkey "PRIMARY KEY (" + Settings.ACCOUNT_NAME + ", " + 883e07913c61c320b0cc2036db3b714e39534d8cd7aJeff Sharkey Settings.ACCOUNT_TYPE + ") ON CONFLICT REPLACE" + 884eb9ffdccfa19f5b2f22e688f733fd77e39605f9eJeff Sharkey ");"); 885eb9ffdccfa19f5b2f22e688f733fd77e39605f9eJeff Sharkey 886e99988b266dd1263162583e81e2b408e7329b1c8Dmitri Plotnikov // The table for recent calls is here so we can do table joins 887e99988b266dd1263162583e81e2b408e7329b1c8Dmitri Plotnikov // on people, phones, and calls all in one place. 888e99988b266dd1263162583e81e2b408e7329b1c8Dmitri Plotnikov db.execSQL("CREATE TABLE " + Tables.CALLS + " (" + 889e99988b266dd1263162583e81e2b408e7329b1c8Dmitri Plotnikov Calls._ID + " INTEGER PRIMARY KEY AUTOINCREMENT," + 890e99988b266dd1263162583e81e2b408e7329b1c8Dmitri Plotnikov Calls.NUMBER + " TEXT," + 891e99988b266dd1263162583e81e2b408e7329b1c8Dmitri Plotnikov Calls.DATE + " INTEGER," + 892e99988b266dd1263162583e81e2b408e7329b1c8Dmitri Plotnikov Calls.DURATION + " INTEGER," + 893e99988b266dd1263162583e81e2b408e7329b1c8Dmitri Plotnikov Calls.TYPE + " INTEGER," + 894e99988b266dd1263162583e81e2b408e7329b1c8Dmitri Plotnikov Calls.NEW + " INTEGER," + 895e99988b266dd1263162583e81e2b408e7329b1c8Dmitri Plotnikov Calls.CACHED_NAME + " TEXT," + 896e99988b266dd1263162583e81e2b408e7329b1c8Dmitri Plotnikov Calls.CACHED_NUMBER_TYPE + " INTEGER," + 897e99988b266dd1263162583e81e2b408e7329b1c8Dmitri Plotnikov Calls.CACHED_NUMBER_LABEL + " TEXT" + 898e99988b266dd1263162583e81e2b408e7329b1c8Dmitri Plotnikov ");"); 899e99988b266dd1263162583e81e2b408e7329b1c8Dmitri Plotnikov 900b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey // Activities table 901b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey db.execSQL("CREATE TABLE " + Tables.ACTIVITIES + " (" + 902b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey Activities._ID + " INTEGER PRIMARY KEY AUTOINCREMENT," + 90367dde51ab932dc84d95a203b113989b13437f13dJeff Sharkey ActivitiesColumns.PACKAGE_ID + " INTEGER REFERENCES package(_id)," + 904b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey ActivitiesColumns.MIMETYPE_ID + " INTEGER REFERENCES mimetype(_id) NOT NULL," + 905b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey Activities.RAW_ID + " TEXT," + 906499791a4f9ab29fa94ff48dd7acff55b2ac089a7Dmitri Plotnikov Activities.IN_REPLY_TO + " TEXT," + 9075ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov Activities.AUTHOR_CONTACT_ID + " INTEGER REFERENCES raw_contacts(_id)," + 9085ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov Activities.TARGET_CONTACT_ID + " INTEGER REFERENCES raw_contacts(_id)," + 909b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey Activities.PUBLISHED + " INTEGER NOT NULL," + 910499791a4f9ab29fa94ff48dd7acff55b2ac089a7Dmitri Plotnikov Activities.THREAD_PUBLISHED + " INTEGER NOT NULL," + 911b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey Activities.TITLE + " TEXT NOT NULL," + 912b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey Activities.SUMMARY + " TEXT," + 913adb55c2d8295d300961d86a3605c8ddc469cd4a2Dmitri Plotnikov Activities.LINK + " TEXT, " + 914b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey Activities.THUMBNAIL + " BLOB" + 915b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey ");"); 916b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey 917a23cd5b6f478f6c9dda54173e84bd0098b9f3364Dmitri Plotnikov db.execSQL("CREATE TABLE " + Tables.STATUS_UPDATES + " (" + 918a23cd5b6f478f6c9dda54173e84bd0098b9f3364Dmitri Plotnikov StatusUpdatesColumns.DATA_ID + " INTEGER PRIMARY KEY REFERENCES data(_id)," + 9190a185cdcb65d1beb2a295fffbe2ae11a6a2c097fDmitri Plotnikov StatusUpdates.STATUS + " TEXT," + 9200a185cdcb65d1beb2a295fffbe2ae11a6a2c097fDmitri Plotnikov StatusUpdates.STATUS_TIMESTAMP + " INTEGER," + 9210a185cdcb65d1beb2a295fffbe2ae11a6a2c097fDmitri Plotnikov StatusUpdates.STATUS_RES_PACKAGE + " TEXT, " + 9220a185cdcb65d1beb2a295fffbe2ae11a6a2c097fDmitri Plotnikov StatusUpdates.STATUS_LABEL + " INTEGER, " + 9230a185cdcb65d1beb2a295fffbe2ae11a6a2c097fDmitri Plotnikov StatusUpdates.STATUS_ICON + " INTEGER" + 924a23cd5b6f478f6c9dda54173e84bd0098b9f3364Dmitri Plotnikov ");"); 925a23cd5b6f478f6c9dda54173e84bd0098b9f3364Dmitri Plotnikov 926a0e72d9b20207ec244f92ace2917932990f2bc8bDmitri Plotnikov createContactsViews(db); 927a0e72d9b20207ec244f92ace2917932990f2bc8bDmitri Plotnikov createGroupsView(db); 92846b7bfa3728bf878d1a9dac9fea35fa629975e1bFred Quintana createContactEntitiesView(db); 929fda634f3eeff6aed8e8dddca92fc07aa44befeddDmitri Plotnikov createContactsTriggers(db); 9304a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov 931a0e72d9b20207ec244f92ace2917932990f2bc8bDmitri Plotnikov loadNicknameLookupTable(db); 932a0e72d9b20207ec244f92ace2917932990f2bc8bDmitri Plotnikov 933a0e72d9b20207ec244f92ace2917932990f2bc8bDmitri Plotnikov // Add the legacy API support views, etc 934a0e72d9b20207ec244f92ace2917932990f2bc8bDmitri Plotnikov LegacyApiSupport.createDatabase(db); 935a0e72d9b20207ec244f92ace2917932990f2bc8bDmitri Plotnikov 936a0e72d9b20207ec244f92ace2917932990f2bc8bDmitri Plotnikov // This will create a sqlite_stat1 table that is used for query optimization 937a0e72d9b20207ec244f92ace2917932990f2bc8bDmitri Plotnikov db.execSQL("ANALYZE;"); 938a0e72d9b20207ec244f92ace2917932990f2bc8bDmitri Plotnikov 939a0e72d9b20207ec244f92ace2917932990f2bc8bDmitri Plotnikov updateSqliteStats(db); 940a0e72d9b20207ec244f92ace2917932990f2bc8bDmitri Plotnikov 941a0e72d9b20207ec244f92ace2917932990f2bc8bDmitri Plotnikov // We need to close and reopen the database connection so that the stats are 942a0e72d9b20207ec244f92ace2917932990f2bc8bDmitri Plotnikov // taken into account. Make a note of it and do the actual reopening in the 943a0e72d9b20207ec244f92ace2917932990f2bc8bDmitri Plotnikov // getWritableDatabase method. 944a0e72d9b20207ec244f92ace2917932990f2bc8bDmitri Plotnikov mReopenDatabase = true; 945a0e72d9b20207ec244f92ace2917932990f2bc8bDmitri Plotnikov 946a0e72d9b20207ec244f92ace2917932990f2bc8bDmitri Plotnikov ContentResolver.requestSync(null /* all accounts */, 947a0e72d9b20207ec244f92ace2917932990f2bc8bDmitri Plotnikov ContactsContract.AUTHORITY, new Bundle()); 948a0e72d9b20207ec244f92ace2917932990f2bc8bDmitri Plotnikov } 949a0e72d9b20207ec244f92ace2917932990f2bc8bDmitri Plotnikov 950fda634f3eeff6aed8e8dddca92fc07aa44befeddDmitri Plotnikov private void createContactsTriggers(SQLiteDatabase db) { 951fda634f3eeff6aed8e8dddca92fc07aa44befeddDmitri Plotnikov 952fda634f3eeff6aed8e8dddca92fc07aa44befeddDmitri Plotnikov /* 953fda634f3eeff6aed8e8dddca92fc07aa44befeddDmitri Plotnikov * Automatically delete Data rows when a raw contact is deleted. 954fda634f3eeff6aed8e8dddca92fc07aa44befeddDmitri Plotnikov */ 955fda634f3eeff6aed8e8dddca92fc07aa44befeddDmitri Plotnikov db.execSQL("DROP TRIGGER IF EXISTS " + Tables.RAW_CONTACTS + "_deleted;"); 956fda634f3eeff6aed8e8dddca92fc07aa44befeddDmitri Plotnikov db.execSQL("CREATE TRIGGER " + Tables.RAW_CONTACTS + "_deleted " 957fda634f3eeff6aed8e8dddca92fc07aa44befeddDmitri Plotnikov + " BEFORE DELETE ON " + Tables.RAW_CONTACTS 958fda634f3eeff6aed8e8dddca92fc07aa44befeddDmitri Plotnikov + " BEGIN " 959fda634f3eeff6aed8e8dddca92fc07aa44befeddDmitri Plotnikov + " DELETE FROM " + Tables.DATA 960fda634f3eeff6aed8e8dddca92fc07aa44befeddDmitri Plotnikov + " WHERE " + Data.RAW_CONTACT_ID 961fda634f3eeff6aed8e8dddca92fc07aa44befeddDmitri Plotnikov + "=OLD." + RawContacts._ID + ";" 962fda634f3eeff6aed8e8dddca92fc07aa44befeddDmitri Plotnikov + " DELETE FROM " + Tables.AGGREGATION_EXCEPTIONS 963fda634f3eeff6aed8e8dddca92fc07aa44befeddDmitri Plotnikov + " WHERE " + AggregationExceptions.RAW_CONTACT_ID1 964fda634f3eeff6aed8e8dddca92fc07aa44befeddDmitri Plotnikov + "=OLD." + RawContacts._ID 965fda634f3eeff6aed8e8dddca92fc07aa44befeddDmitri Plotnikov + " OR " + AggregationExceptions.RAW_CONTACT_ID2 966fda634f3eeff6aed8e8dddca92fc07aa44befeddDmitri Plotnikov + "=OLD." + RawContacts._ID + ";" 967fda634f3eeff6aed8e8dddca92fc07aa44befeddDmitri Plotnikov + " DELETE FROM " + Tables.CONTACTS 968fda634f3eeff6aed8e8dddca92fc07aa44befeddDmitri Plotnikov + " WHERE " + Contacts._ID + "=OLD." + RawContacts.CONTACT_ID 969fda634f3eeff6aed8e8dddca92fc07aa44befeddDmitri Plotnikov + " AND (SELECT COUNT(*) FROM " + Tables.RAW_CONTACTS 970fda634f3eeff6aed8e8dddca92fc07aa44befeddDmitri Plotnikov + " WHERE " + RawContacts.CONTACT_ID + "=OLD." + RawContacts.CONTACT_ID 971fda634f3eeff6aed8e8dddca92fc07aa44befeddDmitri Plotnikov + " )=1;" 972fda634f3eeff6aed8e8dddca92fc07aa44befeddDmitri Plotnikov + " END"); 973fda634f3eeff6aed8e8dddca92fc07aa44befeddDmitri Plotnikov 974fda634f3eeff6aed8e8dddca92fc07aa44befeddDmitri Plotnikov 975fda634f3eeff6aed8e8dddca92fc07aa44befeddDmitri Plotnikov db.execSQL("DROP TRIGGER IF EXISTS contacts_times_contacted;"); 976fda634f3eeff6aed8e8dddca92fc07aa44befeddDmitri Plotnikov db.execSQL("CREATE TRIGGER contacts_times_contacted UPDATE OF " + 977fda634f3eeff6aed8e8dddca92fc07aa44befeddDmitri Plotnikov Contacts.LAST_TIME_CONTACTED + " ON " + Tables.CONTACTS + " " + 978fda634f3eeff6aed8e8dddca92fc07aa44befeddDmitri Plotnikov "BEGIN " + 979fda634f3eeff6aed8e8dddca92fc07aa44befeddDmitri Plotnikov "UPDATE " + Tables.CONTACTS + " SET " 980fda634f3eeff6aed8e8dddca92fc07aa44befeddDmitri Plotnikov + Contacts.TIMES_CONTACTED + " = " + "" + 981fda634f3eeff6aed8e8dddca92fc07aa44befeddDmitri Plotnikov "(new." + Contacts.TIMES_CONTACTED + " + 1)" 982fda634f3eeff6aed8e8dddca92fc07aa44befeddDmitri Plotnikov + " WHERE _id = new._id;" + 983fda634f3eeff6aed8e8dddca92fc07aa44befeddDmitri Plotnikov "END"); 984fda634f3eeff6aed8e8dddca92fc07aa44befeddDmitri Plotnikov 985fda634f3eeff6aed8e8dddca92fc07aa44befeddDmitri Plotnikov /* 986fda634f3eeff6aed8e8dddca92fc07aa44befeddDmitri Plotnikov * Triggers that update {@link RawContacts#VERSION} when the contact is 987fda634f3eeff6aed8e8dddca92fc07aa44befeddDmitri Plotnikov * marked for deletion or any time a data row is inserted, updated or 988fda634f3eeff6aed8e8dddca92fc07aa44befeddDmitri Plotnikov * deleted. 989fda634f3eeff6aed8e8dddca92fc07aa44befeddDmitri Plotnikov */ 990fda634f3eeff6aed8e8dddca92fc07aa44befeddDmitri Plotnikov db.execSQL("DROP TRIGGER IF EXISTS " + Tables.RAW_CONTACTS + "_marked_deleted;"); 991fda634f3eeff6aed8e8dddca92fc07aa44befeddDmitri Plotnikov db.execSQL("CREATE TRIGGER " + Tables.RAW_CONTACTS + "_marked_deleted " 992fda634f3eeff6aed8e8dddca92fc07aa44befeddDmitri Plotnikov + " BEFORE UPDATE ON " + Tables.RAW_CONTACTS 993fda634f3eeff6aed8e8dddca92fc07aa44befeddDmitri Plotnikov + " BEGIN " 994fda634f3eeff6aed8e8dddca92fc07aa44befeddDmitri Plotnikov + " UPDATE " + Tables.RAW_CONTACTS 995fda634f3eeff6aed8e8dddca92fc07aa44befeddDmitri Plotnikov + " SET " 996fda634f3eeff6aed8e8dddca92fc07aa44befeddDmitri Plotnikov + RawContacts.VERSION + "=OLD." + RawContacts.VERSION + "+1 " 997fda634f3eeff6aed8e8dddca92fc07aa44befeddDmitri Plotnikov + " WHERE " + RawContacts._ID + "=OLD." + RawContacts._ID 998fda634f3eeff6aed8e8dddca92fc07aa44befeddDmitri Plotnikov + " AND NEW." + RawContacts.DELETED + "!= OLD." + RawContacts.DELETED + ";" 999fda634f3eeff6aed8e8dddca92fc07aa44befeddDmitri Plotnikov + " END"); 1000fda634f3eeff6aed8e8dddca92fc07aa44befeddDmitri Plotnikov 1001fda634f3eeff6aed8e8dddca92fc07aa44befeddDmitri Plotnikov db.execSQL("DROP TRIGGER IF EXISTS " + Tables.DATA + "_updated;"); 1002fda634f3eeff6aed8e8dddca92fc07aa44befeddDmitri Plotnikov db.execSQL("CREATE TRIGGER " + Tables.DATA + "_updated BEFORE UPDATE ON " + Tables.DATA 1003fda634f3eeff6aed8e8dddca92fc07aa44befeddDmitri Plotnikov + " BEGIN " 1004fda634f3eeff6aed8e8dddca92fc07aa44befeddDmitri Plotnikov + " UPDATE " + Tables.DATA 1005fda634f3eeff6aed8e8dddca92fc07aa44befeddDmitri Plotnikov + " SET " + Data.DATA_VERSION + "=OLD." + Data.DATA_VERSION + "+1 " 1006fda634f3eeff6aed8e8dddca92fc07aa44befeddDmitri Plotnikov + " WHERE " + Data._ID + "=OLD." + Data._ID + ";" 1007fda634f3eeff6aed8e8dddca92fc07aa44befeddDmitri Plotnikov + " UPDATE " + Tables.RAW_CONTACTS 1008fda634f3eeff6aed8e8dddca92fc07aa44befeddDmitri Plotnikov + " SET " + RawContacts.VERSION + "=" + RawContacts.VERSION + "+1 " 1009fda634f3eeff6aed8e8dddca92fc07aa44befeddDmitri Plotnikov + " WHERE " + RawContacts._ID + "=OLD." + Data.RAW_CONTACT_ID + ";" 1010fda634f3eeff6aed8e8dddca92fc07aa44befeddDmitri Plotnikov + " END"); 1011fda634f3eeff6aed8e8dddca92fc07aa44befeddDmitri Plotnikov 1012fda634f3eeff6aed8e8dddca92fc07aa44befeddDmitri Plotnikov db.execSQL("DROP TRIGGER IF EXISTS " + Tables.DATA + "_deleted;"); 1013fda634f3eeff6aed8e8dddca92fc07aa44befeddDmitri Plotnikov db.execSQL("CREATE TRIGGER " + Tables.DATA + "_deleted BEFORE DELETE ON " + Tables.DATA 1014fda634f3eeff6aed8e8dddca92fc07aa44befeddDmitri Plotnikov + " BEGIN " 1015fda634f3eeff6aed8e8dddca92fc07aa44befeddDmitri Plotnikov + " UPDATE " + Tables.RAW_CONTACTS 1016fda634f3eeff6aed8e8dddca92fc07aa44befeddDmitri Plotnikov + " SET " + RawContacts.VERSION + "=" + RawContacts.VERSION + "+1 " 1017fda634f3eeff6aed8e8dddca92fc07aa44befeddDmitri Plotnikov + " WHERE " + RawContacts._ID + "=OLD." + Data.RAW_CONTACT_ID + ";" 1018fda634f3eeff6aed8e8dddca92fc07aa44befeddDmitri Plotnikov + " DELETE FROM " + Tables.PHONE_LOOKUP 1019fda634f3eeff6aed8e8dddca92fc07aa44befeddDmitri Plotnikov + " WHERE " + PhoneLookupColumns.DATA_ID + "=OLD." + Data._ID + ";" 1020fda634f3eeff6aed8e8dddca92fc07aa44befeddDmitri Plotnikov + " DELETE FROM " + Tables.STATUS_UPDATES 1021fda634f3eeff6aed8e8dddca92fc07aa44befeddDmitri Plotnikov + " WHERE " + StatusUpdatesColumns.DATA_ID + "=OLD." + Data._ID + ";" 1022fda634f3eeff6aed8e8dddca92fc07aa44befeddDmitri Plotnikov + " DELETE FROM " + Tables.NAME_LOOKUP 1023fda634f3eeff6aed8e8dddca92fc07aa44befeddDmitri Plotnikov + " WHERE " + NameLookupColumns.DATA_ID + "=OLD." + Data._ID + ";" 1024fda634f3eeff6aed8e8dddca92fc07aa44befeddDmitri Plotnikov + " END"); 1025fda634f3eeff6aed8e8dddca92fc07aa44befeddDmitri Plotnikov 1026fda634f3eeff6aed8e8dddca92fc07aa44befeddDmitri Plotnikov 1027fda634f3eeff6aed8e8dddca92fc07aa44befeddDmitri Plotnikov db.execSQL("DROP TRIGGER IF EXISTS " + Tables.GROUPS + "_updated1;"); 1028fda634f3eeff6aed8e8dddca92fc07aa44befeddDmitri Plotnikov db.execSQL("CREATE TRIGGER " + Tables.GROUPS + "_updated1 " 1029fda634f3eeff6aed8e8dddca92fc07aa44befeddDmitri Plotnikov + " BEFORE UPDATE ON " + Tables.GROUPS 1030fda634f3eeff6aed8e8dddca92fc07aa44befeddDmitri Plotnikov + " BEGIN " 1031fda634f3eeff6aed8e8dddca92fc07aa44befeddDmitri Plotnikov + " UPDATE " + Tables.GROUPS 1032fda634f3eeff6aed8e8dddca92fc07aa44befeddDmitri Plotnikov + " SET " 1033fda634f3eeff6aed8e8dddca92fc07aa44befeddDmitri Plotnikov + Groups.VERSION + "=OLD." + Groups.VERSION + "+1" 1034fda634f3eeff6aed8e8dddca92fc07aa44befeddDmitri Plotnikov + " WHERE " + Groups._ID + "=OLD." + Groups._ID + ";" 1035fda634f3eeff6aed8e8dddca92fc07aa44befeddDmitri Plotnikov + " END"); 1036fda634f3eeff6aed8e8dddca92fc07aa44befeddDmitri Plotnikov } 1037fda634f3eeff6aed8e8dddca92fc07aa44befeddDmitri Plotnikov 1038a0e72d9b20207ec244f92ace2917932990f2bc8bDmitri Plotnikov private static void createContactsViews(SQLiteDatabase db) { 1039a0e72d9b20207ec244f92ace2917932990f2bc8bDmitri Plotnikov db.execSQL("DROP VIEW IF EXISTS " + Views.CONTACTS_ALL + ";"); 1040a0e72d9b20207ec244f92ace2917932990f2bc8bDmitri Plotnikov db.execSQL("DROP VIEW IF EXISTS " + Views.CONTACTS_RESTRICTED + ";"); 1041a0e72d9b20207ec244f92ace2917932990f2bc8bDmitri Plotnikov db.execSQL("DROP VIEW IF EXISTS " + Views.DATA_ALL + ";"); 1042a0e72d9b20207ec244f92ace2917932990f2bc8bDmitri Plotnikov db.execSQL("DROP VIEW IF EXISTS " + Views.DATA_RESTRICTED + ";"); 1043a0e72d9b20207ec244f92ace2917932990f2bc8bDmitri Plotnikov db.execSQL("DROP VIEW IF EXISTS " + Views.RAW_CONTACTS_ALL + ";"); 1044a0e72d9b20207ec244f92ace2917932990f2bc8bDmitri Plotnikov db.execSQL("DROP VIEW IF EXISTS " + Views.RAW_CONTACTS_RESTRICTED + ";"); 1045a0e72d9b20207ec244f92ace2917932990f2bc8bDmitri Plotnikov 10464a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov String dataColumns = 10474a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov Data.IS_PRIMARY + ", " 10484a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + Data.IS_SUPER_PRIMARY + ", " 10494a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + Data.DATA_VERSION + ", " 10504a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + PackagesColumns.PACKAGE + " AS " + Data.RES_PACKAGE + "," 10514a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + MimetypesColumns.MIMETYPE + " AS " + Data.MIMETYPE + ", " 10524a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + Data.DATA1 + ", " 10534a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + Data.DATA2 + ", " 10544a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + Data.DATA3 + ", " 10554a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + Data.DATA4 + ", " 10564a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + Data.DATA5 + ", " 10574a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + Data.DATA6 + ", " 10584a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + Data.DATA7 + ", " 10594a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + Data.DATA8 + ", " 10604a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + Data.DATA9 + ", " 10614a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + Data.DATA10 + ", " 10624a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + Data.DATA11 + ", " 10634a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + Data.DATA12 + ", " 10644a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + Data.DATA13 + ", " 10654a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + Data.DATA14 + ", " 10664a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + Data.DATA15 + ", " 10674a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + Data.SYNC1 + ", " 10684a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + Data.SYNC2 + ", " 10694a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + Data.SYNC3 + ", " 10704a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + Data.SYNC4; 10714a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov 10724a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov String syncColumns = 10734a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov RawContactsColumns.CONCRETE_ACCOUNT_NAME + " AS " + RawContacts.ACCOUNT_NAME + "," 10744a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + RawContactsColumns.CONCRETE_ACCOUNT_TYPE + " AS " + RawContacts.ACCOUNT_TYPE + "," 10754a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + RawContactsColumns.CONCRETE_SOURCE_ID + " AS " + RawContacts.SOURCE_ID + "," 10764a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + RawContactsColumns.CONCRETE_VERSION + " AS " + RawContacts.VERSION + "," 10774a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + RawContactsColumns.CONCRETE_DIRTY + " AS " + RawContacts.DIRTY + "," 10784a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + RawContactsColumns.CONCRETE_SYNC1 + " AS " + RawContacts.SYNC1 + "," 10794a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + RawContactsColumns.CONCRETE_SYNC2 + " AS " + RawContacts.SYNC2 + "," 10804a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + RawContactsColumns.CONCRETE_SYNC3 + " AS " + RawContacts.SYNC3 + "," 10814a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + RawContactsColumns.CONCRETE_SYNC4 + " AS " + RawContacts.SYNC4; 10824a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov 10834a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov String contactOptionColumns = 10844a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov ContactsColumns.CONCRETE_CUSTOM_RINGTONE 10854a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + " AS " + RawContacts.CUSTOM_RINGTONE + "," 10864a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + ContactsColumns.CONCRETE_SEND_TO_VOICEMAIL 10874a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + " AS " + RawContacts.SEND_TO_VOICEMAIL + "," 10884a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + ContactsColumns.CONCRETE_LAST_TIME_CONTACTED 10894a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + " AS " + RawContacts.LAST_TIME_CONTACTED + "," 10904a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + ContactsColumns.CONCRETE_TIMES_CONTACTED 10914a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + " AS " + RawContacts.TIMES_CONTACTED + "," 10924a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + ContactsColumns.CONCRETE_STARRED 10934a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + " AS " + RawContacts.STARRED; 10944a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov 10954a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov String dataSelect = "SELECT " 10964a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + DataColumns.CONCRETE_ID + " AS " + Data._ID + "," 10974a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + Data.RAW_CONTACT_ID + ", " 10984a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + RawContacts.CONTACT_ID + ", " 10994a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + syncColumns + ", " 11004a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + dataColumns + ", " 11014a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + contactOptionColumns + ", " 11024a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + ContactsColumns.CONCRETE_DISPLAY_NAME + " AS " + Contacts.DISPLAY_NAME + ", " 11035870f2dcc2ac7715b2c078a886ee346622e7887eDmitri Plotnikov + Contacts.LOOKUP_KEY + ", " 11044a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + Contacts.PHOTO_ID + ", " 1105a0e72d9b20207ec244f92ace2917932990f2bc8bDmitri Plotnikov + Contacts.IN_VISIBLE_GROUP + ", " 1106a23cd5b6f478f6c9dda54173e84bd0098b9f3364Dmitri Plotnikov + ContactsColumns.LAST_STATUS_UPDATE_ID + ", " 11074a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + Tables.GROUPS + "." + Groups.SOURCE_ID + " AS " + GroupMembership.GROUP_SOURCE_ID 11084a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + " FROM " + Tables.DATA 1109a0e72d9b20207ec244f92ace2917932990f2bc8bDmitri Plotnikov + " JOIN " + Tables.MIMETYPES + " ON (" 11104a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + DataColumns.CONCRETE_MIMETYPE_ID + "=" + MimetypesColumns.CONCRETE_ID + ")" 1111a0e72d9b20207ec244f92ace2917932990f2bc8bDmitri Plotnikov + " JOIN " + Tables.RAW_CONTACTS + " ON (" 11124a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + DataColumns.CONCRETE_RAW_CONTACT_ID + "=" + RawContactsColumns.CONCRETE_ID + ")" 1113a0e72d9b20207ec244f92ace2917932990f2bc8bDmitri Plotnikov + " JOIN " + Tables.CONTACTS + " ON (" 1114a0e72d9b20207ec244f92ace2917932990f2bc8bDmitri Plotnikov + RawContacts.CONTACT_ID + "=" + Tables.CONTACTS + "." + Contacts._ID + ")" 1115a0e72d9b20207ec244f92ace2917932990f2bc8bDmitri Plotnikov + " LEFT OUTER JOIN " + Tables.PACKAGES + " ON (" 1116a0e72d9b20207ec244f92ace2917932990f2bc8bDmitri Plotnikov + DataColumns.CONCRETE_PACKAGE_ID + "=" + PackagesColumns.CONCRETE_ID + ")" 11174a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + " LEFT OUTER JOIN " + Tables.GROUPS + " ON (" 11184a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + MimetypesColumns.CONCRETE_MIMETYPE + "='" + GroupMembership.CONTENT_ITEM_TYPE 1119f23764675b35b5262a39c79aad8e9842460274b2Dmitri Plotnikov + "' AND " + GroupsColumns.CONCRETE_ID + "=" 1120a0e72d9b20207ec244f92ace2917932990f2bc8bDmitri Plotnikov + Tables.DATA + "." + GroupMembership.GROUP_ROW_ID + ")"; 11214a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov 11224a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov db.execSQL("CREATE VIEW " + Views.DATA_ALL + " AS " + dataSelect); 11234a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov db.execSQL("CREATE VIEW " + Views.DATA_RESTRICTED + " AS " + dataSelect + " WHERE " 11244a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + RawContacts.IS_RESTRICTED + "=0"); 11254a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov 11264a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov String rawContactOptionColumns = 11274a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov RawContacts.CUSTOM_RINGTONE + "," 11284a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + RawContacts.SEND_TO_VOICEMAIL + "," 11294a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + RawContacts.LAST_TIME_CONTACTED + "," 11304a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + RawContacts.TIMES_CONTACTED + "," 11314a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + RawContacts.STARRED; 11324a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov 11334a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov String rawContactsSelect = "SELECT " 11344a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + RawContactsColumns.CONCRETE_ID + " AS " + RawContacts._ID + "," 11354a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + RawContacts.CONTACT_ID + ", " 11364a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + RawContacts.AGGREGATION_MODE + ", " 11374a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + RawContacts.DELETED + ", " 11384a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + rawContactOptionColumns + ", " 11394a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + syncColumns 11404a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + " FROM " + Tables.RAW_CONTACTS; 11414a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov 11424a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov db.execSQL("CREATE VIEW " + Views.RAW_CONTACTS_ALL + " AS " + rawContactsSelect); 11434a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov db.execSQL("CREATE VIEW " + Views.RAW_CONTACTS_RESTRICTED + " AS " + rawContactsSelect 11444a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + " WHERE " + RawContacts.IS_RESTRICTED + "=0"); 11454a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov 11464a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov String contactsColumns = 11474a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov ContactsColumns.CONCRETE_CUSTOM_RINGTONE 11484a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + " AS " + Contacts.CUSTOM_RINGTONE + ", " 11494a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + ContactsColumns.CONCRETE_DISPLAY_NAME 11504a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + " AS " + Contacts.DISPLAY_NAME + ", " 11514a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + Contacts.IN_VISIBLE_GROUP + ", " 1152f992bfab334b760d36a053fc0b439382dcfb51adDmitri Plotnikov + Contacts.HAS_PHONE_NUMBER + ", " 11535870f2dcc2ac7715b2c078a886ee346622e7887eDmitri Plotnikov + Contacts.LOOKUP_KEY + ", " 11545870f2dcc2ac7715b2c078a886ee346622e7887eDmitri Plotnikov + Contacts.PHOTO_ID + ", " 1155a0e72d9b20207ec244f92ace2917932990f2bc8bDmitri Plotnikov + Contacts.IN_VISIBLE_GROUP + ", " 11564a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + ContactsColumns.CONCRETE_LAST_TIME_CONTACTED 11574a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + " AS " + Contacts.LAST_TIME_CONTACTED + ", " 11584a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + ContactsColumns.CONCRETE_SEND_TO_VOICEMAIL 11594a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + " AS " + Contacts.SEND_TO_VOICEMAIL + ", " 11604a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + ContactsColumns.CONCRETE_STARRED 11614a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + " AS " + Contacts.STARRED + ", " 11624a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + ContactsColumns.CONCRETE_TIMES_CONTACTED 1163a23cd5b6f478f6c9dda54173e84bd0098b9f3364Dmitri Plotnikov + " AS " + Contacts.TIMES_CONTACTED + ", " 1164a23cd5b6f478f6c9dda54173e84bd0098b9f3364Dmitri Plotnikov + ContactsColumns.LAST_STATUS_UPDATE_ID; 11654a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov 11664a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov String contactsSelect = "SELECT " 11674a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + ContactsColumns.CONCRETE_ID + " AS " + Contacts._ID + "," 1168f992bfab334b760d36a053fc0b439382dcfb51adDmitri Plotnikov + contactsColumns 11694a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + " FROM " + Tables.CONTACTS; 11704a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov 11714a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov String restrictedContactsSelect = "SELECT " 11724a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + ContactsColumns.CONCRETE_ID + " AS " + Contacts._ID + "," 1173f992bfab334b760d36a053fc0b439382dcfb51adDmitri Plotnikov + contactsColumns 11744a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + " FROM " + Tables.CONTACTS 11754a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + " WHERE " + ContactsColumns.SINGLE_IS_RESTRICTED + "=0"; 11764a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov 11774a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov db.execSQL("CREATE VIEW " + Views.CONTACTS_ALL + " AS " + contactsSelect); 11784a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov db.execSQL("CREATE VIEW " + Views.CONTACTS_RESTRICTED + " AS " + restrictedContactsSelect); 1179a0e72d9b20207ec244f92ace2917932990f2bc8bDmitri Plotnikov } 11804a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov 1181a0e72d9b20207ec244f92ace2917932990f2bc8bDmitri Plotnikov private static void createGroupsView(SQLiteDatabase db) { 1182a0e72d9b20207ec244f92ace2917932990f2bc8bDmitri Plotnikov db.execSQL("DROP VIEW IF EXISTS " + Views.GROUPS_ALL + ";"); 118389c626eb655440c86a2e5df076e83708c1b32c17Dmitri Plotnikov String groupsColumns = 118489c626eb655440c86a2e5df076e83708c1b32c17Dmitri Plotnikov Groups.ACCOUNT_NAME + "," 118589c626eb655440c86a2e5df076e83708c1b32c17Dmitri Plotnikov + Groups.ACCOUNT_TYPE + "," 118689c626eb655440c86a2e5df076e83708c1b32c17Dmitri Plotnikov + Groups.SOURCE_ID + "," 118789c626eb655440c86a2e5df076e83708c1b32c17Dmitri Plotnikov + Groups.VERSION + "," 118889c626eb655440c86a2e5df076e83708c1b32c17Dmitri Plotnikov + Groups.DIRTY + "," 118989c626eb655440c86a2e5df076e83708c1b32c17Dmitri Plotnikov + Groups.TITLE + "," 119089c626eb655440c86a2e5df076e83708c1b32c17Dmitri Plotnikov + Groups.TITLE_RES + "," 119189c626eb655440c86a2e5df076e83708c1b32c17Dmitri Plotnikov + Groups.NOTES + "," 119289c626eb655440c86a2e5df076e83708c1b32c17Dmitri Plotnikov + Groups.SYSTEM_ID + "," 119389c626eb655440c86a2e5df076e83708c1b32c17Dmitri Plotnikov + Groups.DELETED + "," 119489c626eb655440c86a2e5df076e83708c1b32c17Dmitri Plotnikov + Groups.GROUP_VISIBLE + "," 119589c626eb655440c86a2e5df076e83708c1b32c17Dmitri Plotnikov + Groups.SHOULD_SYNC + "," 119689c626eb655440c86a2e5df076e83708c1b32c17Dmitri Plotnikov + Groups.SYNC1 + "," 119789c626eb655440c86a2e5df076e83708c1b32c17Dmitri Plotnikov + Groups.SYNC2 + "," 119889c626eb655440c86a2e5df076e83708c1b32c17Dmitri Plotnikov + Groups.SYNC3 + "," 119989c626eb655440c86a2e5df076e83708c1b32c17Dmitri Plotnikov + Groups.SYNC4 + "," 120089c626eb655440c86a2e5df076e83708c1b32c17Dmitri Plotnikov + PackagesColumns.PACKAGE + " AS " + Groups.RES_PACKAGE; 120189c626eb655440c86a2e5df076e83708c1b32c17Dmitri Plotnikov 120289c626eb655440c86a2e5df076e83708c1b32c17Dmitri Plotnikov String groupsSelect = "SELECT " 120389c626eb655440c86a2e5df076e83708c1b32c17Dmitri Plotnikov + GroupsColumns.CONCRETE_ID + " AS " + Groups._ID + "," 120489c626eb655440c86a2e5df076e83708c1b32c17Dmitri Plotnikov + groupsColumns 120589c626eb655440c86a2e5df076e83708c1b32c17Dmitri Plotnikov + " FROM " + Tables.GROUPS_JOIN_PACKAGES; 120689c626eb655440c86a2e5df076e83708c1b32c17Dmitri Plotnikov 120789c626eb655440c86a2e5df076e83708c1b32c17Dmitri Plotnikov db.execSQL("CREATE VIEW " + Views.GROUPS_ALL + " AS " + groupsSelect); 1208b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey } 1209b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey 121046b7bfa3728bf878d1a9dac9fea35fa629975e1bFred Quintana private static void createContactEntitiesView(SQLiteDatabase db) { 1211a0e72d9b20207ec244f92ace2917932990f2bc8bDmitri Plotnikov db.execSQL("DROP VIEW IF EXISTS " + Tables.CONTACT_ENTITIES + ";"); 1212a0e72d9b20207ec244f92ace2917932990f2bc8bDmitri Plotnikov db.execSQL("DROP VIEW IF EXISTS " + Tables.CONTACT_ENTITIES_RESTRICTED + ";"); 1213a0e72d9b20207ec244f92ace2917932990f2bc8bDmitri Plotnikov 121446b7bfa3728bf878d1a9dac9fea35fa629975e1bFred Quintana String contactEntitiesSelect = "SELECT " 121546b7bfa3728bf878d1a9dac9fea35fa629975e1bFred Quintana + RawContactsColumns.CONCRETE_ACCOUNT_NAME + " AS " + RawContacts.ACCOUNT_NAME + "," 121646b7bfa3728bf878d1a9dac9fea35fa629975e1bFred Quintana + RawContactsColumns.CONCRETE_ACCOUNT_TYPE + " AS " + RawContacts.ACCOUNT_TYPE + "," 121746b7bfa3728bf878d1a9dac9fea35fa629975e1bFred Quintana + RawContactsColumns.CONCRETE_SOURCE_ID + " AS " + RawContacts.SOURCE_ID + "," 121846b7bfa3728bf878d1a9dac9fea35fa629975e1bFred Quintana + RawContactsColumns.CONCRETE_VERSION + " AS " + RawContacts.VERSION + "," 121946b7bfa3728bf878d1a9dac9fea35fa629975e1bFred Quintana + RawContactsColumns.CONCRETE_DIRTY + " AS " + RawContacts.DIRTY + "," 122046b7bfa3728bf878d1a9dac9fea35fa629975e1bFred Quintana + RawContactsColumns.CONCRETE_DELETED + " AS " + RawContacts.DELETED + "," 122146b7bfa3728bf878d1a9dac9fea35fa629975e1bFred Quintana + PackagesColumns.PACKAGE + " AS " + Data.RES_PACKAGE + "," 122246b7bfa3728bf878d1a9dac9fea35fa629975e1bFred Quintana + RawContacts.CONTACT_ID + ", " 122346b7bfa3728bf878d1a9dac9fea35fa629975e1bFred Quintana + RawContactsColumns.CONCRETE_SYNC1 + " AS " + RawContacts.SYNC1 + ", " 122446b7bfa3728bf878d1a9dac9fea35fa629975e1bFred Quintana + RawContactsColumns.CONCRETE_SYNC2 + " AS " + RawContacts.SYNC2 + ", " 122546b7bfa3728bf878d1a9dac9fea35fa629975e1bFred Quintana + RawContactsColumns.CONCRETE_SYNC3 + " AS " + RawContacts.SYNC3 + ", " 122646b7bfa3728bf878d1a9dac9fea35fa629975e1bFred Quintana + RawContactsColumns.CONCRETE_SYNC4 + " AS " + RawContacts.SYNC4 + ", " 122746b7bfa3728bf878d1a9dac9fea35fa629975e1bFred Quintana + Data.MIMETYPE + ", " 122846b7bfa3728bf878d1a9dac9fea35fa629975e1bFred Quintana + Data.DATA1 + ", " 122946b7bfa3728bf878d1a9dac9fea35fa629975e1bFred Quintana + Data.DATA2 + ", " 123046b7bfa3728bf878d1a9dac9fea35fa629975e1bFred Quintana + Data.DATA3 + ", " 123146b7bfa3728bf878d1a9dac9fea35fa629975e1bFred Quintana + Data.DATA4 + ", " 123246b7bfa3728bf878d1a9dac9fea35fa629975e1bFred Quintana + Data.DATA5 + ", " 123346b7bfa3728bf878d1a9dac9fea35fa629975e1bFred Quintana + Data.DATA6 + ", " 123446b7bfa3728bf878d1a9dac9fea35fa629975e1bFred Quintana + Data.DATA7 + ", " 123546b7bfa3728bf878d1a9dac9fea35fa629975e1bFred Quintana + Data.DATA8 + ", " 123646b7bfa3728bf878d1a9dac9fea35fa629975e1bFred Quintana + Data.DATA9 + ", " 123746b7bfa3728bf878d1a9dac9fea35fa629975e1bFred Quintana + Data.DATA10 + ", " 123846b7bfa3728bf878d1a9dac9fea35fa629975e1bFred Quintana + Data.DATA11 + ", " 123946b7bfa3728bf878d1a9dac9fea35fa629975e1bFred Quintana + Data.DATA12 + ", " 124046b7bfa3728bf878d1a9dac9fea35fa629975e1bFred Quintana + Data.DATA13 + ", " 124146b7bfa3728bf878d1a9dac9fea35fa629975e1bFred Quintana + Data.DATA14 + ", " 124246b7bfa3728bf878d1a9dac9fea35fa629975e1bFred Quintana + Data.DATA15 + ", " 124346b7bfa3728bf878d1a9dac9fea35fa629975e1bFred Quintana + Data.SYNC1 + ", " 124446b7bfa3728bf878d1a9dac9fea35fa629975e1bFred Quintana + Data.SYNC2 + ", " 124546b7bfa3728bf878d1a9dac9fea35fa629975e1bFred Quintana + Data.SYNC3 + ", " 124646b7bfa3728bf878d1a9dac9fea35fa629975e1bFred Quintana + Data.SYNC4 + ", " 124746b7bfa3728bf878d1a9dac9fea35fa629975e1bFred Quintana + RawContactsColumns.CONCRETE_ID + " AS " + RawContacts._ID + ", " 124846b7bfa3728bf878d1a9dac9fea35fa629975e1bFred Quintana + Data.IS_PRIMARY + ", " 124946b7bfa3728bf878d1a9dac9fea35fa629975e1bFred Quintana + Data.IS_SUPER_PRIMARY + ", " 125046b7bfa3728bf878d1a9dac9fea35fa629975e1bFred Quintana + Data.DATA_VERSION + ", " 125146b7bfa3728bf878d1a9dac9fea35fa629975e1bFred Quintana + DataColumns.CONCRETE_ID + " AS " + RawContacts.Entity.DATA_ID + "," 125246b7bfa3728bf878d1a9dac9fea35fa629975e1bFred Quintana + RawContactsColumns.CONCRETE_STARRED + " AS " + RawContacts.STARRED + "," 125346b7bfa3728bf878d1a9dac9fea35fa629975e1bFred Quintana + Tables.GROUPS + "." + Groups.SOURCE_ID + " AS " + GroupMembership.GROUP_SOURCE_ID 125446b7bfa3728bf878d1a9dac9fea35fa629975e1bFred Quintana + " FROM " + Tables.RAW_CONTACTS 125546b7bfa3728bf878d1a9dac9fea35fa629975e1bFred Quintana + " LEFT OUTER JOIN " + Tables.DATA + " ON (" 125646b7bfa3728bf878d1a9dac9fea35fa629975e1bFred Quintana + DataColumns.CONCRETE_RAW_CONTACT_ID + "=" + RawContactsColumns.CONCRETE_ID + ")" 125746b7bfa3728bf878d1a9dac9fea35fa629975e1bFred Quintana + " LEFT OUTER JOIN " + Tables.PACKAGES + " ON (" 125846b7bfa3728bf878d1a9dac9fea35fa629975e1bFred Quintana + DataColumns.CONCRETE_PACKAGE_ID + "=" + PackagesColumns.CONCRETE_ID + ")" 125946b7bfa3728bf878d1a9dac9fea35fa629975e1bFred Quintana + " LEFT OUTER JOIN " + Tables.MIMETYPES + " ON (" 126046b7bfa3728bf878d1a9dac9fea35fa629975e1bFred Quintana + DataColumns.CONCRETE_MIMETYPE_ID + "=" + MimetypesColumns.CONCRETE_ID + ")" 126146b7bfa3728bf878d1a9dac9fea35fa629975e1bFred Quintana + " LEFT OUTER JOIN " + Tables.GROUPS + " ON (" 126246b7bfa3728bf878d1a9dac9fea35fa629975e1bFred Quintana + MimetypesColumns.CONCRETE_MIMETYPE + "='" + GroupMembership.CONTENT_ITEM_TYPE 126346b7bfa3728bf878d1a9dac9fea35fa629975e1bFred Quintana + "' AND " + GroupsColumns.CONCRETE_ID + "=" 126446b7bfa3728bf878d1a9dac9fea35fa629975e1bFred Quintana + Tables.DATA + "." + GroupMembership.GROUP_ROW_ID + ")"; 126546b7bfa3728bf878d1a9dac9fea35fa629975e1bFred Quintana 126646b7bfa3728bf878d1a9dac9fea35fa629975e1bFred Quintana db.execSQL("CREATE VIEW " + Tables.CONTACT_ENTITIES + " AS " 126746b7bfa3728bf878d1a9dac9fea35fa629975e1bFred Quintana + contactEntitiesSelect); 126846b7bfa3728bf878d1a9dac9fea35fa629975e1bFred Quintana db.execSQL("CREATE VIEW " + Tables.CONTACT_ENTITIES_RESTRICTED + " AS " 126946b7bfa3728bf878d1a9dac9fea35fa629975e1bFred Quintana + contactEntitiesSelect + " WHERE " + RawContacts.IS_RESTRICTED + "=0"); 127046b7bfa3728bf878d1a9dac9fea35fa629975e1bFred Quintana } 127146b7bfa3728bf878d1a9dac9fea35fa629975e1bFred Quintana 1272b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey @Override 1273b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) { 127446b7bfa3728bf878d1a9dac9fea35fa629975e1bFred Quintana if (oldVersion < 99) { 127546b7bfa3728bf878d1a9dac9fea35fa629975e1bFred Quintana Log.i(TAG, "Upgrading from version " + oldVersion + " to " + newVersion 127646b7bfa3728bf878d1a9dac9fea35fa629975e1bFred Quintana + ", data will be lost!"); 127746b7bfa3728bf878d1a9dac9fea35fa629975e1bFred Quintana 127846b7bfa3728bf878d1a9dac9fea35fa629975e1bFred Quintana db.execSQL("DROP TABLE IF EXISTS " + Tables.CONTACTS + ";"); 127946b7bfa3728bf878d1a9dac9fea35fa629975e1bFred Quintana db.execSQL("DROP TABLE IF EXISTS " + Tables.RAW_CONTACTS + ";"); 128046b7bfa3728bf878d1a9dac9fea35fa629975e1bFred Quintana db.execSQL("DROP TABLE IF EXISTS " + Tables.PACKAGES + ";"); 128146b7bfa3728bf878d1a9dac9fea35fa629975e1bFred Quintana db.execSQL("DROP TABLE IF EXISTS " + Tables.MIMETYPES + ";"); 128246b7bfa3728bf878d1a9dac9fea35fa629975e1bFred Quintana db.execSQL("DROP TABLE IF EXISTS " + Tables.DATA + ";"); 128346b7bfa3728bf878d1a9dac9fea35fa629975e1bFred Quintana db.execSQL("DROP TABLE IF EXISTS " + Tables.PHONE_LOOKUP + ";"); 128446b7bfa3728bf878d1a9dac9fea35fa629975e1bFred Quintana db.execSQL("DROP TABLE IF EXISTS " + Tables.NAME_LOOKUP + ";"); 128546b7bfa3728bf878d1a9dac9fea35fa629975e1bFred Quintana db.execSQL("DROP TABLE IF EXISTS " + Tables.NICKNAME_LOOKUP + ";"); 128646b7bfa3728bf878d1a9dac9fea35fa629975e1bFred Quintana db.execSQL("DROP TABLE IF EXISTS " + Tables.GROUPS + ";"); 128746b7bfa3728bf878d1a9dac9fea35fa629975e1bFred Quintana db.execSQL("DROP TABLE IF EXISTS " + Tables.ACTIVITIES + ";"); 128846b7bfa3728bf878d1a9dac9fea35fa629975e1bFred Quintana db.execSQL("DROP TABLE IF EXISTS " + Tables.CALLS + ";"); 128946b7bfa3728bf878d1a9dac9fea35fa629975e1bFred Quintana db.execSQL("DROP TABLE IF EXISTS " + Tables.SETTINGS + ";"); 129046b7bfa3728bf878d1a9dac9fea35fa629975e1bFred Quintana db.execSQL("DROP TABLE IF EXISTS " + Tables.STATUS_UPDATES + ";"); 129146b7bfa3728bf878d1a9dac9fea35fa629975e1bFred Quintana 129246b7bfa3728bf878d1a9dac9fea35fa629975e1bFred Quintana // TODO: we should not be dropping agg_exceptions and contact_options. In case that 129346b7bfa3728bf878d1a9dac9fea35fa629975e1bFred Quintana // table's schema changes, we should try to preserve the data, because it was entered 129446b7bfa3728bf878d1a9dac9fea35fa629975e1bFred Quintana // by the user and has never been synched to the server. 129546b7bfa3728bf878d1a9dac9fea35fa629975e1bFred Quintana db.execSQL("DROP TABLE IF EXISTS " + Tables.AGGREGATION_EXCEPTIONS + ";"); 129646b7bfa3728bf878d1a9dac9fea35fa629975e1bFred Quintana 129746b7bfa3728bf878d1a9dac9fea35fa629975e1bFred Quintana onCreate(db); 129846b7bfa3728bf878d1a9dac9fea35fa629975e1bFred Quintana return; 129946b7bfa3728bf878d1a9dac9fea35fa629975e1bFred Quintana } 1300f79538095a1af16dcd6e641448b627f60f197802Dmitri Plotnikov 130146b7bfa3728bf878d1a9dac9fea35fa629975e1bFred Quintana Log.i(TAG, "Upgrading from version " + oldVersion + " to " + newVersion); 1302a0e72d9b20207ec244f92ace2917932990f2bc8bDmitri Plotnikov 130346b7bfa3728bf878d1a9dac9fea35fa629975e1bFred Quintana if (oldVersion == 99) { 130446b7bfa3728bf878d1a9dac9fea35fa629975e1bFred Quintana createContactEntitiesView(db); 130546b7bfa3728bf878d1a9dac9fea35fa629975e1bFred Quintana oldVersion++; 130646b7bfa3728bf878d1a9dac9fea35fa629975e1bFred Quintana } 130746b7bfa3728bf878d1a9dac9fea35fa629975e1bFred Quintana 1308a0e72d9b20207ec244f92ace2917932990f2bc8bDmitri Plotnikov if (oldVersion == 100) { 1309a0e72d9b20207ec244f92ace2917932990f2bc8bDmitri Plotnikov db.execSQL("CREATE INDEX IF NOT EXISTS mimetypes_mimetype_index ON " 1310a0e72d9b20207ec244f92ace2917932990f2bc8bDmitri Plotnikov + Tables.MIMETYPES + " (" 1311a0e72d9b20207ec244f92ace2917932990f2bc8bDmitri Plotnikov + MimetypesColumns.MIMETYPE + "," 1312a0e72d9b20207ec244f92ace2917932990f2bc8bDmitri Plotnikov + MimetypesColumns._ID + ");"); 1313a0e72d9b20207ec244f92ace2917932990f2bc8bDmitri Plotnikov updateIndexStats(db, Tables.MIMETYPES, 1314a0e72d9b20207ec244f92ace2917932990f2bc8bDmitri Plotnikov "mimetypes_mimetype_index", "50 1 1"); 1315a0e72d9b20207ec244f92ace2917932990f2bc8bDmitri Plotnikov 1316a0e72d9b20207ec244f92ace2917932990f2bc8bDmitri Plotnikov createContactsViews(db); 1317a0e72d9b20207ec244f92ace2917932990f2bc8bDmitri Plotnikov oldVersion++; 1318a0e72d9b20207ec244f92ace2917932990f2bc8bDmitri Plotnikov } 1319a0e72d9b20207ec244f92ace2917932990f2bc8bDmitri Plotnikov 1320fda634f3eeff6aed8e8dddca92fc07aa44befeddDmitri Plotnikov if (oldVersion == 101) { 1321fda634f3eeff6aed8e8dddca92fc07aa44befeddDmitri Plotnikov createContactsTriggers(db); 1322fda634f3eeff6aed8e8dddca92fc07aa44befeddDmitri Plotnikov oldVersion++; 1323fda634f3eeff6aed8e8dddca92fc07aa44befeddDmitri Plotnikov } 1324fda634f3eeff6aed8e8dddca92fc07aa44befeddDmitri Plotnikov 132547ab23770b9f010a5e5277cda68267fe0613a1ccDmitri Plotnikov if (oldVersion == 102) { 132647ab23770b9f010a5e5277cda68267fe0613a1ccDmitri Plotnikov LegacyApiSupport.createDatabase(db); 132747ab23770b9f010a5e5277cda68267fe0613a1ccDmitri Plotnikov oldVersion++; 132847ab23770b9f010a5e5277cda68267fe0613a1ccDmitri Plotnikov } 132947ab23770b9f010a5e5277cda68267fe0613a1ccDmitri Plotnikov 133046b7bfa3728bf878d1a9dac9fea35fa629975e1bFred Quintana if (oldVersion != newVersion) { 133146b7bfa3728bf878d1a9dac9fea35fa629975e1bFred Quintana throw new IllegalStateException( 133246b7bfa3728bf878d1a9dac9fea35fa629975e1bFred Quintana "error upgrading the database to version " + newVersion); 133346b7bfa3728bf878d1a9dac9fea35fa629975e1bFred Quintana } 1334b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey } 1335b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey 1336a8dc456684a104c7e5547ba17d44f952022cd8c5Dmitri Plotnikov /** 1337f79538095a1af16dcd6e641448b627f60f197802Dmitri Plotnikov * Adds index stats into the SQLite database to force it to always use the lookup indexes. 1338f79538095a1af16dcd6e641448b627f60f197802Dmitri Plotnikov */ 1339f79538095a1af16dcd6e641448b627f60f197802Dmitri Plotnikov private void updateSqliteStats(SQLiteDatabase db) { 1340f79538095a1af16dcd6e641448b627f60f197802Dmitri Plotnikov 1341f79538095a1af16dcd6e641448b627f60f197802Dmitri Plotnikov // Specific stats strings are based on an actual large database after running ANALYZE 1342f79538095a1af16dcd6e641448b627f60f197802Dmitri Plotnikov try { 13438fddc066662d58e8d6a436decb8dafbf28ce652eDmitri Plotnikov updateIndexStats(db, Tables.CONTACTS, 13448fddc066662d58e8d6a436decb8dafbf28ce652eDmitri Plotnikov "contacts_restricted_index", "10000 9000"); 13458fddc066662d58e8d6a436decb8dafbf28ce652eDmitri Plotnikov updateIndexStats(db, Tables.CONTACTS, 13468fddc066662d58e8d6a436decb8dafbf28ce652eDmitri Plotnikov "contacts_has_phone_index", "10000 500"); 13478fddc066662d58e8d6a436decb8dafbf28ce652eDmitri Plotnikov updateIndexStats(db, Tables.CONTACTS, 1348737858a04a157a0afad9ec81372c75d14bf68788Jeff Hamilton "contacts_visible_index", "10000 500 1"); 13498fddc066662d58e8d6a436decb8dafbf28ce652eDmitri Plotnikov 13508fddc066662d58e8d6a436decb8dafbf28ce652eDmitri Plotnikov updateIndexStats(db, Tables.RAW_CONTACTS, 13518fddc066662d58e8d6a436decb8dafbf28ce652eDmitri Plotnikov "raw_contacts_source_id_index", "10000 1 1 1"); 13528fddc066662d58e8d6a436decb8dafbf28ce652eDmitri Plotnikov updateIndexStats(db, Tables.RAW_CONTACTS, 13538fddc066662d58e8d6a436decb8dafbf28ce652eDmitri Plotnikov "raw_contacts_contact_id_index", "10000 2"); 13548fddc066662d58e8d6a436decb8dafbf28ce652eDmitri Plotnikov 13558fddc066662d58e8d6a436decb8dafbf28ce652eDmitri Plotnikov updateIndexStats(db, Tables.NAME_LOOKUP, 13568fddc066662d58e8d6a436decb8dafbf28ce652eDmitri Plotnikov "name_lookup_raw_contact_id_index", "10000 3"); 13578fddc066662d58e8d6a436decb8dafbf28ce652eDmitri Plotnikov updateIndexStats(db, Tables.NAME_LOOKUP, 13588fddc066662d58e8d6a436decb8dafbf28ce652eDmitri Plotnikov "name_lookup_index", "10000 3 2 2"); 13598fddc066662d58e8d6a436decb8dafbf28ce652eDmitri Plotnikov updateIndexStats(db, Tables.NAME_LOOKUP, 13608fddc066662d58e8d6a436decb8dafbf28ce652eDmitri Plotnikov "sqlite_autoindex_name_lookup_1", "10000 3 2 1"); 13618fddc066662d58e8d6a436decb8dafbf28ce652eDmitri Plotnikov 13628fddc066662d58e8d6a436decb8dafbf28ce652eDmitri Plotnikov updateIndexStats(db, Tables.PHONE_LOOKUP, 13638fddc066662d58e8d6a436decb8dafbf28ce652eDmitri Plotnikov "phone_lookup_index", "10000 2 2 1"); 13648fddc066662d58e8d6a436decb8dafbf28ce652eDmitri Plotnikov 13658fddc066662d58e8d6a436decb8dafbf28ce652eDmitri Plotnikov updateIndexStats(db, Tables.DATA, 13668fddc066662d58e8d6a436decb8dafbf28ce652eDmitri Plotnikov "data_mimetype_data1_index", "60000 5000 2"); 13678fddc066662d58e8d6a436decb8dafbf28ce652eDmitri Plotnikov updateIndexStats(db, Tables.DATA, 13688fddc066662d58e8d6a436decb8dafbf28ce652eDmitri Plotnikov "data_raw_contact_id", "60000 10"); 13698fddc066662d58e8d6a436decb8dafbf28ce652eDmitri Plotnikov 13708fddc066662d58e8d6a436decb8dafbf28ce652eDmitri Plotnikov updateIndexStats(db, Tables.GROUPS, 13718fddc066662d58e8d6a436decb8dafbf28ce652eDmitri Plotnikov "groups_source_id_index", "50 1 1 1"); 13728fddc066662d58e8d6a436decb8dafbf28ce652eDmitri Plotnikov 13738fddc066662d58e8d6a436decb8dafbf28ce652eDmitri Plotnikov updateIndexStats(db, Tables.NICKNAME_LOOKUP, 13748fddc066662d58e8d6a436decb8dafbf28ce652eDmitri Plotnikov "sqlite_autoindex_name_lookup_1", "500 2 1"); 13758fddc066662d58e8d6a436decb8dafbf28ce652eDmitri Plotnikov 1376f79538095a1af16dcd6e641448b627f60f197802Dmitri Plotnikov } catch (SQLException e) { 1377f79538095a1af16dcd6e641448b627f60f197802Dmitri Plotnikov Log.e(TAG, "Could not update index stats", e); 1378f79538095a1af16dcd6e641448b627f60f197802Dmitri Plotnikov } 1379f79538095a1af16dcd6e641448b627f60f197802Dmitri Plotnikov } 1380f79538095a1af16dcd6e641448b627f60f197802Dmitri Plotnikov 1381f79538095a1af16dcd6e641448b627f60f197802Dmitri Plotnikov /** 1382f79538095a1af16dcd6e641448b627f60f197802Dmitri Plotnikov * Stores statistics for a given index. 1383f79538095a1af16dcd6e641448b627f60f197802Dmitri Plotnikov * 1384f79538095a1af16dcd6e641448b627f60f197802Dmitri Plotnikov * @param stats has the following structure: the first index is the expected size of 1385f79538095a1af16dcd6e641448b627f60f197802Dmitri Plotnikov * the table. The following integer(s) are the expected number of records selected with the 1386f79538095a1af16dcd6e641448b627f60f197802Dmitri Plotnikov * index. There should be one integer per indexed column. 1387f79538095a1af16dcd6e641448b627f60f197802Dmitri Plotnikov */ 1388f79538095a1af16dcd6e641448b627f60f197802Dmitri Plotnikov private void updateIndexStats(SQLiteDatabase db, String table, String index, String stats) { 1389f79538095a1af16dcd6e641448b627f60f197802Dmitri Plotnikov db.execSQL("DELETE FROM sqlite_stat1 WHERE tbl='" + table + "' AND idx='" + index + "';"); 1390f79538095a1af16dcd6e641448b627f60f197802Dmitri Plotnikov db.execSQL("INSERT INTO sqlite_stat1 (tbl,idx,stat)" 1391f79538095a1af16dcd6e641448b627f60f197802Dmitri Plotnikov + " VALUES ('" + table + "','" + index + "','" + stats + "');"); 1392f79538095a1af16dcd6e641448b627f60f197802Dmitri Plotnikov } 1393f79538095a1af16dcd6e641448b627f60f197802Dmitri Plotnikov 1394f79538095a1af16dcd6e641448b627f60f197802Dmitri Plotnikov @Override 1395f79538095a1af16dcd6e641448b627f60f197802Dmitri Plotnikov public synchronized SQLiteDatabase getWritableDatabase() { 1396f79538095a1af16dcd6e641448b627f60f197802Dmitri Plotnikov SQLiteDatabase db = super.getWritableDatabase(); 1397f79538095a1af16dcd6e641448b627f60f197802Dmitri Plotnikov if (mReopenDatabase) { 1398f79538095a1af16dcd6e641448b627f60f197802Dmitri Plotnikov mReopenDatabase = false; 1399f79538095a1af16dcd6e641448b627f60f197802Dmitri Plotnikov close(); 1400f79538095a1af16dcd6e641448b627f60f197802Dmitri Plotnikov db = super.getWritableDatabase(); 1401f79538095a1af16dcd6e641448b627f60f197802Dmitri Plotnikov } 1402f79538095a1af16dcd6e641448b627f60f197802Dmitri Plotnikov return db; 1403f79538095a1af16dcd6e641448b627f60f197802Dmitri Plotnikov } 1404f79538095a1af16dcd6e641448b627f60f197802Dmitri Plotnikov 1405f79538095a1af16dcd6e641448b627f60f197802Dmitri Plotnikov /** 1406a8dc456684a104c7e5547ba17d44f952022cd8c5Dmitri Plotnikov * Wipes all data except mime type and package lookup tables. 1407a8dc456684a104c7e5547ba17d44f952022cd8c5Dmitri Plotnikov */ 1408a8dc456684a104c7e5547ba17d44f952022cd8c5Dmitri Plotnikov public void wipeData() { 1409a8dc456684a104c7e5547ba17d44f952022cd8c5Dmitri Plotnikov SQLiteDatabase db = getWritableDatabase(); 14103d8b043c3341a5b6c2e781b7eba9767d5cd13267Dmitri Plotnikov 1411d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov db.execSQL("DELETE FROM " + Tables.CONTACTS + ";"); 14125ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov db.execSQL("DELETE FROM " + Tables.RAW_CONTACTS + ";"); 1413a8dc456684a104c7e5547ba17d44f952022cd8c5Dmitri Plotnikov db.execSQL("DELETE FROM " + Tables.DATA + ";"); 1414a8dc456684a104c7e5547ba17d44f952022cd8c5Dmitri Plotnikov db.execSQL("DELETE FROM " + Tables.PHONE_LOOKUP + ";"); 1415a8dc456684a104c7e5547ba17d44f952022cd8c5Dmitri Plotnikov db.execSQL("DELETE FROM " + Tables.NAME_LOOKUP + ";"); 1416ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey db.execSQL("DELETE FROM " + Tables.GROUPS + ";"); 1417b174c7ccd337a7bea6269139c9b09acc69ae40c1Dmitri Plotnikov db.execSQL("DELETE FROM " + Tables.AGGREGATION_EXCEPTIONS + ";"); 1418eb9ffdccfa19f5b2f22e688f733fd77e39605f9eJeff Sharkey db.execSQL("DELETE FROM " + Tables.SETTINGS + ";"); 1419a8dc456684a104c7e5547ba17d44f952022cd8c5Dmitri Plotnikov db.execSQL("DELETE FROM " + Tables.ACTIVITIES + ";"); 14203d8b043c3341a5b6c2e781b7eba9767d5cd13267Dmitri Plotnikov db.execSQL("DELETE FROM " + Tables.CALLS + ";"); 1421b597adb79f1f57a24be2be09e3f45fa0f04f6f8fDmitri Plotnikov 1422b597adb79f1f57a24be2be09e3f45fa0f04f6f8fDmitri Plotnikov // Note: we are not removing reference data from Tables.NICKNAME_LOOKUP 1423b597adb79f1f57a24be2be09e3f45fa0f04f6f8fDmitri Plotnikov 1424a8dc456684a104c7e5547ba17d44f952022cd8c5Dmitri Plotnikov db.execSQL("VACUUM;"); 1425a8dc456684a104c7e5547ba17d44f952022cd8c5Dmitri Plotnikov } 1426b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey 1427b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey /** 1428619871b0fb0175d75ff9336bfe5aec0b27b9bdadJeff Sharkey * Return the {@link ApplicationInfo#uid} for the given package name. 1429619871b0fb0175d75ff9336bfe5aec0b27b9bdadJeff Sharkey */ 1430619871b0fb0175d75ff9336bfe5aec0b27b9bdadJeff Sharkey public static int getUidForPackageName(PackageManager pm, String packageName) { 1431619871b0fb0175d75ff9336bfe5aec0b27b9bdadJeff Sharkey try { 1432619871b0fb0175d75ff9336bfe5aec0b27b9bdadJeff Sharkey ApplicationInfo clientInfo = pm.getApplicationInfo(packageName, 0 /* no flags */); 1433619871b0fb0175d75ff9336bfe5aec0b27b9bdadJeff Sharkey return clientInfo.uid; 1434619871b0fb0175d75ff9336bfe5aec0b27b9bdadJeff Sharkey } catch (NameNotFoundException e) { 1435619871b0fb0175d75ff9336bfe5aec0b27b9bdadJeff Sharkey throw new RuntimeException(e); 1436619871b0fb0175d75ff9336bfe5aec0b27b9bdadJeff Sharkey } 1437619871b0fb0175d75ff9336bfe5aec0b27b9bdadJeff Sharkey } 1438619871b0fb0175d75ff9336bfe5aec0b27b9bdadJeff Sharkey 1439619871b0fb0175d75ff9336bfe5aec0b27b9bdadJeff Sharkey /** 1440b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey * Perform an internal string-to-integer lookup using the compiled 1441b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey * {@link SQLiteStatement} provided, using the in-memory cache to speed up 1442b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey * lookups. If a mapping isn't found in cache or database, it will be 1443b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey * created. All new, uncached answers are added to the cache automatically. 1444b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey * 1445b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey * @param query Compiled statement used to query for the mapping. 1446b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey * @param insert Compiled statement used to insert a new mapping when no 1447b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey * existing one is found in cache or from query. 1448b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey * @param value Value to find mapping for. 1449b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey * @param cache In-memory cache of previous answers. 1450b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey * @return An unique integer mapping for the given value. 1451b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey */ 1452b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey private synchronized long getCachedId(SQLiteStatement query, SQLiteStatement insert, 1453b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey String value, HashMap<String, Long> cache) { 1454b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey // Try an in-memory cache lookup 1455b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey if (cache.containsKey(value)) { 1456b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey return cache.get(value); 1457b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey } 1458b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey 1459b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey long id = -1; 1460b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey try { 1461b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey // Try searching database for mapping 1462b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey DatabaseUtils.bindObjectToProgram(query, 1, value); 1463b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey id = query.simpleQueryForLong(); 1464b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey } catch (SQLiteDoneException e) { 1465b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey // Nothing found, so try inserting new mapping 1466b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey DatabaseUtils.bindObjectToProgram(insert, 1, value); 1467b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey id = insert.executeInsert(); 1468b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey } 1469b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey 1470b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey if (id != -1) { 1471b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey // Cache and return the new answer 1472b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey cache.put(value, id); 1473b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey return id; 1474b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey } else { 1475b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey // Otherwise throw if no mapping found or created 1476b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey throw new IllegalStateException("Couldn't find or create internal " 1477b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey + "lookup table entry for value " + value); 1478b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey } 1479b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey } 1480b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey 1481b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey /** 1482ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey * Convert a package name into an integer, using {@link Tables#PACKAGES} for 1483b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey * lookups and possible allocation of new IDs as needed. 1484b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey */ 1485b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey public long getPackageId(String packageName) { 1486b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey // Make sure compiled statements are ready by opening database 1487b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey getReadableDatabase(); 1488b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey return getCachedId(mPackageQuery, mPackageInsert, packageName, mPackageCache); 1489b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey } 1490b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey 1491b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey /** 1492ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey * Convert a mimetype into an integer, using {@link Tables#MIMETYPES} for 1493b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey * lookups and possible allocation of new IDs as needed. 1494b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey */ 1495b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey public long getMimeTypeId(String mimetype) { 1496b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey // Make sure compiled statements are ready by opening database 1497b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey getReadableDatabase(); 1498b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey return getCachedId(mMimetypeQuery, mMimetypeInsert, mimetype, mMimetypeCache); 1499b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey } 1500b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey 1501b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey /** 1502ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey * Find the mimetype for the given {@link Data#_ID}. 1503b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey */ 1504b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey public String getDataMimeType(long dataId) { 1505b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey // Make sure compiled statements are ready by opening database 1506b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey getReadableDatabase(); 1507b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey try { 1508b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey // Try database query to find mimetype 1509b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey DatabaseUtils.bindObjectToProgram(mDataMimetypeQuery, 1, dataId); 1510b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey String mimetype = mDataMimetypeQuery.simpleQueryForString(); 1511b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey return mimetype; 1512b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey } catch (SQLiteDoneException e) { 1513b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey // No valid mapping found, so return null 1514b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey return null; 1515b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey } 1516b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey } 1517b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey 1518b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey /** 1519b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey * Find the mime-type for the given {@link Activities#_ID}. 1520b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey */ 1521b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey public String getActivityMimeType(long activityId) { 1522b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey // Make sure compiled statements are ready by opening database 1523b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey getReadableDatabase(); 1524b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey try { 1525b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey // Try database query to find mimetype 1526b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey DatabaseUtils.bindObjectToProgram(mActivitiesMimetypeQuery, 1, activityId); 1527b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey String mimetype = mActivitiesMimetypeQuery.simpleQueryForString(); 1528b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey return mimetype; 1529b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey } catch (SQLiteDoneException e) { 1530b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey // No valid mapping found, so return null 1531b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey return null; 1532b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey } 1533b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey } 15346bccc079d8fea5c51f9fa6fd06044bd8f5109c6fDmitri Plotnikov 15356bccc079d8fea5c51f9fa6fd06044bd8f5109c6fDmitri Plotnikov /** 1536d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov * Update {@link Contacts#IN_VISIBLE_GROUP} for all contacts. 1537ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey */ 1538ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey public void updateAllVisible() { 1539ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey final long groupMembershipMimetypeId = getMimeTypeId(GroupMembership.CONTENT_ITEM_TYPE); 1540e07913c61c320b0cc2036db3b714e39534d8cd7aJeff Sharkey mVisibleUpdate.bindLong(1, groupMembershipMimetypeId); 1541e07913c61c320b0cc2036db3b714e39534d8cd7aJeff Sharkey mVisibleUpdate.execute(); 1542ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey } 1543ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey 1544ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey /** 1545d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov * Update {@link Contacts#IN_VISIBLE_GROUP} for a specific contact. 1546ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey */ 1547d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov public void updateContactVisible(long aggId) { 1548ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey final long groupMembershipMimetypeId = getMimeTypeId(GroupMembership.CONTENT_ITEM_TYPE); 1549ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey mVisibleSpecificUpdate.bindLong(1, groupMembershipMimetypeId); 1550ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey mVisibleSpecificUpdate.bindLong(2, aggId); 1551ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey mVisibleSpecificUpdate.execute(); 1552ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey } 1553ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey 1554ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey /** 1555d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov * Returns contact ID for the given contact or zero if it is NULL. 15566bccc079d8fea5c51f9fa6fd06044bd8f5109c6fDmitri Plotnikov */ 1557d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov public long getContactId(long rawContactId) { 15586bccc079d8fea5c51f9fa6fd06044bd8f5109c6fDmitri Plotnikov getReadableDatabase(); 15596bccc079d8fea5c51f9fa6fd06044bd8f5109c6fDmitri Plotnikov try { 1560d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov DatabaseUtils.bindObjectToProgram(mContactIdQuery, 1, rawContactId); 1561d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov return mContactIdQuery.simpleQueryForLong(); 15626bccc079d8fea5c51f9fa6fd06044bd8f5109c6fDmitri Plotnikov } catch (SQLiteDoneException e) { 1563a3bd0246ca3741877488bca7aadd91c79b2fd8d2Fred Quintana // No valid mapping found, so return 0 15646bccc079d8fea5c51f9fa6fd06044bd8f5109c6fDmitri Plotnikov return 0; 15656bccc079d8fea5c51f9fa6fd06044bd8f5109c6fDmitri Plotnikov } 15666bccc079d8fea5c51f9fa6fd06044bd8f5109c6fDmitri Plotnikov } 156761bbb2287e8102b7e03922c03809c34b7b317d1cDmitri Plotnikov 15685ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov public int getAggregationMode(long rawContactId) { 1569f4e1358f1c8f5fe5e9e7689e36e04c57c2385169Dmitri Plotnikov getReadableDatabase(); 1570f4e1358f1c8f5fe5e9e7689e36e04c57c2385169Dmitri Plotnikov try { 15715ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov DatabaseUtils.bindObjectToProgram(mAggregationModeQuery, 1, rawContactId); 1572f4e1358f1c8f5fe5e9e7689e36e04c57c2385169Dmitri Plotnikov return (int)mAggregationModeQuery.simpleQueryForLong(); 1573f4e1358f1c8f5fe5e9e7689e36e04c57c2385169Dmitri Plotnikov } catch (SQLiteDoneException e) { 15746cffee46a1334d2b3ed19f436b27638451541044Dmitri Plotnikov // No valid row found, so return "disabled" 15756cffee46a1334d2b3ed19f436b27638451541044Dmitri Plotnikov return RawContacts.AGGREGATION_MODE_DISABLED; 1576f4e1358f1c8f5fe5e9e7689e36e04c57c2385169Dmitri Plotnikov } 1577f4e1358f1c8f5fe5e9e7689e36e04c57c2385169Dmitri Plotnikov } 1578f4e1358f1c8f5fe5e9e7689e36e04c57c2385169Dmitri Plotnikov 1579e3eb7ef438010c893c429f3031dcc7298171865dDmitri Plotnikov public void buildPhoneLookupAndRawContactQuery(SQLiteQueryBuilder qb, String number) { 1580e3eb7ef438010c893c429f3031dcc7298171865dDmitri Plotnikov String normalizedNumber = PhoneNumberUtils.toCallerIDMinMatch(number); 1581f79538095a1af16dcd6e641448b627f60f197802Dmitri Plotnikov qb.setTables(Tables.DATA_JOIN_RAW_CONTACTS + 1582f79538095a1af16dcd6e641448b627f60f197802Dmitri Plotnikov " JOIN " + Tables.PHONE_LOOKUP 1583f79538095a1af16dcd6e641448b627f60f197802Dmitri Plotnikov + " ON(" + DataColumns.CONCRETE_ID + "=" + PhoneLookupColumns.DATA_ID + ")"); 1584f79538095a1af16dcd6e641448b627f60f197802Dmitri Plotnikov 1585e3eb7ef438010c893c429f3031dcc7298171865dDmitri Plotnikov StringBuilder sb = new StringBuilder(); 1586f79538095a1af16dcd6e641448b627f60f197802Dmitri Plotnikov sb.append(PhoneLookupColumns.NORMALIZED_NUMBER + " GLOB '"); 1587f79538095a1af16dcd6e641448b627f60f197802Dmitri Plotnikov sb.append(normalizedNumber); 1588f79538095a1af16dcd6e641448b627f60f197802Dmitri Plotnikov sb.append("*' AND PHONE_NUMBERS_EQUAL(data." + Phone.NUMBER + ", "); 1589f79538095a1af16dcd6e641448b627f60f197802Dmitri Plotnikov DatabaseUtils.appendEscapedSQLString(sb, number); 15903a6a49cfb06272e3e25f3c390a9cf4002da6e34dDaisuke Miyakawa sb.append(mUseStrictPhoneNumberComparation ? ", 1)" : ", 0)"); 1591e3eb7ef438010c893c429f3031dcc7298171865dDmitri Plotnikov 1592e3eb7ef438010c893c429f3031dcc7298171865dDmitri Plotnikov qb.appendWhere(sb.toString()); 1593e3eb7ef438010c893c429f3031dcc7298171865dDmitri Plotnikov } 1594e3eb7ef438010c893c429f3031dcc7298171865dDmitri Plotnikov 1595e3eb7ef438010c893c429f3031dcc7298171865dDmitri Plotnikov public void buildPhoneLookupAndContactQuery(SQLiteQueryBuilder qb, String number) { 1596e3eb7ef438010c893c429f3031dcc7298171865dDmitri Plotnikov String normalizedNumber = PhoneNumberUtils.toCallerIDMinMatch(number); 1597e3eb7ef438010c893c429f3031dcc7298171865dDmitri Plotnikov StringBuilder sb = new StringBuilder(); 1598e3eb7ef438010c893c429f3031dcc7298171865dDmitri Plotnikov appendPhoneLookupTables(sb, normalizedNumber, true); 1599e3eb7ef438010c893c429f3031dcc7298171865dDmitri Plotnikov qb.setTables(sb.toString()); 1600e3eb7ef438010c893c429f3031dcc7298171865dDmitri Plotnikov 1601e3eb7ef438010c893c429f3031dcc7298171865dDmitri Plotnikov sb = new StringBuilder(); 1602e3eb7ef438010c893c429f3031dcc7298171865dDmitri Plotnikov appendPhoneLookupSelection(sb, number); 1603e3eb7ef438010c893c429f3031dcc7298171865dDmitri Plotnikov qb.appendWhere(sb.toString()); 1604bf659107617a6291ba8bfeebc3f2e50138075ab5Dmitri Plotnikov } 1605bf659107617a6291ba8bfeebc3f2e50138075ab5Dmitri Plotnikov 1606e3eb7ef438010c893c429f3031dcc7298171865dDmitri Plotnikov public String buildPhoneLookupAsNestedQuery(String number) { 1607e3eb7ef438010c893c429f3031dcc7298171865dDmitri Plotnikov StringBuilder sb = new StringBuilder(); 1608fb362d1a5df250a49fad06db323b0d41fe0e3757Dmitri Plotnikov final String normalizedNumber = PhoneNumberUtils.toCallerIDMinMatch(number); 1609e3eb7ef438010c893c429f3031dcc7298171865dDmitri Plotnikov sb.append("(SELECT DISTINCT raw_contact_id" + " FROM "); 1610e3eb7ef438010c893c429f3031dcc7298171865dDmitri Plotnikov appendPhoneLookupTables(sb, normalizedNumber, false); 1611e3eb7ef438010c893c429f3031dcc7298171865dDmitri Plotnikov sb.append(" WHERE "); 1612e3eb7ef438010c893c429f3031dcc7298171865dDmitri Plotnikov appendPhoneLookupSelection(sb, number); 1613e3eb7ef438010c893c429f3031dcc7298171865dDmitri Plotnikov sb.append(")"); 1614e3eb7ef438010c893c429f3031dcc7298171865dDmitri Plotnikov return sb.toString(); 1615e3eb7ef438010c893c429f3031dcc7298171865dDmitri Plotnikov } 1616e3eb7ef438010c893c429f3031dcc7298171865dDmitri Plotnikov 1617e3eb7ef438010c893c429f3031dcc7298171865dDmitri Plotnikov private void appendPhoneLookupTables(StringBuilder sb, final String normalizedNumber, 1618e3eb7ef438010c893c429f3031dcc7298171865dDmitri Plotnikov boolean joinContacts) { 1619e3eb7ef438010c893c429f3031dcc7298171865dDmitri Plotnikov sb.append(Tables.RAW_CONTACTS); 1620e3eb7ef438010c893c429f3031dcc7298171865dDmitri Plotnikov if (joinContacts) { 1621e3eb7ef438010c893c429f3031dcc7298171865dDmitri Plotnikov sb.append(" JOIN " + getContactView() + " contacts" 1622e3eb7ef438010c893c429f3031dcc7298171865dDmitri Plotnikov + " ON (contacts._id = raw_contacts.contact_id)"); 1623e3eb7ef438010c893c429f3031dcc7298171865dDmitri Plotnikov } 1624e3eb7ef438010c893c429f3031dcc7298171865dDmitri Plotnikov sb.append(", (SELECT data_id FROM phone_lookup " 1625fb362d1a5df250a49fad06db323b0d41fe0e3757Dmitri Plotnikov + "WHERE (phone_lookup.normalized_number GLOB '"); 1626fb362d1a5df250a49fad06db323b0d41fe0e3757Dmitri Plotnikov sb.append(normalizedNumber); 1627e3eb7ef438010c893c429f3031dcc7298171865dDmitri Plotnikov sb.append("*')) AS lookup, " + Tables.DATA); 1628e3eb7ef438010c893c429f3031dcc7298171865dDmitri Plotnikov } 1629e3eb7ef438010c893c429f3031dcc7298171865dDmitri Plotnikov 1630e3eb7ef438010c893c429f3031dcc7298171865dDmitri Plotnikov private void appendPhoneLookupSelection(StringBuilder sb, String number) { 1631e3eb7ef438010c893c429f3031dcc7298171865dDmitri Plotnikov sb.append("lookup.data_id=data._id AND data.raw_contact_id=raw_contacts._id" 1632fb362d1a5df250a49fad06db323b0d41fe0e3757Dmitri Plotnikov + " AND PHONE_NUMBERS_EQUAL(data." + Phone.NUMBER + ", "); 1633fb362d1a5df250a49fad06db323b0d41fe0e3757Dmitri Plotnikov DatabaseUtils.appendEscapedSQLString(sb, number); 16343a6a49cfb06272e3e25f3c390a9cf4002da6e34dDaisuke Miyakawa sb.append(mUseStrictPhoneNumberComparation ? ", 1)" : ", 0)"); 1635fb362d1a5df250a49fad06db323b0d41fe0e3757Dmitri Plotnikov } 1636bf659107617a6291ba8bfeebc3f2e50138075ab5Dmitri Plotnikov 1637619871b0fb0175d75ff9336bfe5aec0b27b9bdadJeff Sharkey /** 1638b597adb79f1f57a24be2be09e3f45fa0f04f6f8fDmitri Plotnikov * Loads common nickname mappings into the database. 1639b597adb79f1f57a24be2be09e3f45fa0f04f6f8fDmitri Plotnikov */ 1640b597adb79f1f57a24be2be09e3f45fa0f04f6f8fDmitri Plotnikov private void loadNicknameLookupTable(SQLiteDatabase db) { 164128f8857b1b46bde18b85c6d3c2a63ac44c3c2e1cEvan Millar String[] strings = mContext.getResources().getStringArray( 164228f8857b1b46bde18b85c6d3c2a63ac44c3c2e1cEvan Millar com.android.internal.R.array.common_nicknames); 1643b597adb79f1f57a24be2be09e3f45fa0f04f6f8fDmitri Plotnikov if (strings == null || strings.length == 0) { 1644b597adb79f1f57a24be2be09e3f45fa0f04f6f8fDmitri Plotnikov return; 1645b597adb79f1f57a24be2be09e3f45fa0f04f6f8fDmitri Plotnikov } 1646b597adb79f1f57a24be2be09e3f45fa0f04f6f8fDmitri Plotnikov 1647b597adb79f1f57a24be2be09e3f45fa0f04f6f8fDmitri Plotnikov SQLiteStatement nicknameLookupInsert = db.compileStatement("INSERT INTO " 1648b597adb79f1f57a24be2be09e3f45fa0f04f6f8fDmitri Plotnikov + Tables.NICKNAME_LOOKUP + "(" + NicknameLookupColumns.NAME + "," 1649b597adb79f1f57a24be2be09e3f45fa0f04f6f8fDmitri Plotnikov + NicknameLookupColumns.CLUSTER + ") VALUES (?,?)"); 1650b597adb79f1f57a24be2be09e3f45fa0f04f6f8fDmitri Plotnikov 1651b597adb79f1f57a24be2be09e3f45fa0f04f6f8fDmitri Plotnikov for (int clusterId = 0; clusterId < strings.length; clusterId++) { 1652b597adb79f1f57a24be2be09e3f45fa0f04f6f8fDmitri Plotnikov String[] names = strings[clusterId].split(","); 1653b597adb79f1f57a24be2be09e3f45fa0f04f6f8fDmitri Plotnikov for (int j = 0; j < names.length; j++) { 1654b597adb79f1f57a24be2be09e3f45fa0f04f6f8fDmitri Plotnikov String name = NameNormalizer.normalize(names[j]); 1655b597adb79f1f57a24be2be09e3f45fa0f04f6f8fDmitri Plotnikov try { 1656b597adb79f1f57a24be2be09e3f45fa0f04f6f8fDmitri Plotnikov DatabaseUtils.bindObjectToProgram(nicknameLookupInsert, 1, name); 1657b597adb79f1f57a24be2be09e3f45fa0f04f6f8fDmitri Plotnikov DatabaseUtils.bindObjectToProgram(nicknameLookupInsert, 2, 1658b597adb79f1f57a24be2be09e3f45fa0f04f6f8fDmitri Plotnikov String.valueOf(clusterId)); 1659b597adb79f1f57a24be2be09e3f45fa0f04f6f8fDmitri Plotnikov nicknameLookupInsert.executeInsert(); 1660b597adb79f1f57a24be2be09e3f45fa0f04f6f8fDmitri Plotnikov } catch (SQLiteException e) { 1661b597adb79f1f57a24be2be09e3f45fa0f04f6f8fDmitri Plotnikov 1662b597adb79f1f57a24be2be09e3f45fa0f04f6f8fDmitri Plotnikov // Print the exception and keep going - this is not a fatal error 1663b597adb79f1f57a24be2be09e3f45fa0f04f6f8fDmitri Plotnikov Log.e(TAG, "Cannot insert nickname: " + names[j], e); 1664b597adb79f1f57a24be2be09e3f45fa0f04f6f8fDmitri Plotnikov } 1665b597adb79f1f57a24be2be09e3f45fa0f04f6f8fDmitri Plotnikov } 1666b597adb79f1f57a24be2be09e3f45fa0f04f6f8fDmitri Plotnikov } 1667b597adb79f1f57a24be2be09e3f45fa0f04f6f8fDmitri Plotnikov } 1668b597adb79f1f57a24be2be09e3f45fa0f04f6f8fDmitri Plotnikov 1669f4e1358f1c8f5fe5e9e7689e36e04c57c2385169Dmitri Plotnikov public static void copyStringValue(ContentValues toValues, String toKey, 1670f4e1358f1c8f5fe5e9e7689e36e04c57c2385169Dmitri Plotnikov ContentValues fromValues, String fromKey) { 1671f4e1358f1c8f5fe5e9e7689e36e04c57c2385169Dmitri Plotnikov if (fromValues.containsKey(fromKey)) { 1672f4e1358f1c8f5fe5e9e7689e36e04c57c2385169Dmitri Plotnikov toValues.put(toKey, fromValues.getAsString(fromKey)); 1673f4e1358f1c8f5fe5e9e7689e36e04c57c2385169Dmitri Plotnikov } 1674f4e1358f1c8f5fe5e9e7689e36e04c57c2385169Dmitri Plotnikov } 1675f4e1358f1c8f5fe5e9e7689e36e04c57c2385169Dmitri Plotnikov 1676f4e1358f1c8f5fe5e9e7689e36e04c57c2385169Dmitri Plotnikov public static void copyLongValue(ContentValues toValues, String toKey, 1677f4e1358f1c8f5fe5e9e7689e36e04c57c2385169Dmitri Plotnikov ContentValues fromValues, String fromKey) { 1678f4e1358f1c8f5fe5e9e7689e36e04c57c2385169Dmitri Plotnikov if (fromValues.containsKey(fromKey)) { 1679f4e1358f1c8f5fe5e9e7689e36e04c57c2385169Dmitri Plotnikov long longValue; 1680f4e1358f1c8f5fe5e9e7689e36e04c57c2385169Dmitri Plotnikov Object value = fromValues.get(fromKey); 1681f4e1358f1c8f5fe5e9e7689e36e04c57c2385169Dmitri Plotnikov if (value instanceof Boolean) { 1682f4e1358f1c8f5fe5e9e7689e36e04c57c2385169Dmitri Plotnikov if ((Boolean)value) { 1683f4e1358f1c8f5fe5e9e7689e36e04c57c2385169Dmitri Plotnikov longValue = 1; 1684f4e1358f1c8f5fe5e9e7689e36e04c57c2385169Dmitri Plotnikov } else { 1685f4e1358f1c8f5fe5e9e7689e36e04c57c2385169Dmitri Plotnikov longValue = 0; 1686f4e1358f1c8f5fe5e9e7689e36e04c57c2385169Dmitri Plotnikov } 16871b7a7947242bb3b8caaed871775e62d486144c9fDmitri Plotnikov } else if (value instanceof String) { 16881b7a7947242bb3b8caaed871775e62d486144c9fDmitri Plotnikov longValue = Long.parseLong((String)value); 1689f4e1358f1c8f5fe5e9e7689e36e04c57c2385169Dmitri Plotnikov } else { 16901b7a7947242bb3b8caaed871775e62d486144c9fDmitri Plotnikov longValue = ((Number)value).longValue(); 1691f4e1358f1c8f5fe5e9e7689e36e04c57c2385169Dmitri Plotnikov } 1692f4e1358f1c8f5fe5e9e7689e36e04c57c2385169Dmitri Plotnikov toValues.put(toKey, longValue); 1693f4e1358f1c8f5fe5e9e7689e36e04c57c2385169Dmitri Plotnikov } 1694f4e1358f1c8f5fe5e9e7689e36e04c57c2385169Dmitri Plotnikov } 1695f4e1358f1c8f5fe5e9e7689e36e04c57c2385169Dmitri Plotnikov 169635ed95769096bb5dd406ad7d1fcaa49a0e35a307Fred Quintana public SyncStateContentProviderHelper getSyncState() { 169735ed95769096bb5dd406ad7d1fcaa49a0e35a307Fred Quintana return mSyncState; 169835ed95769096bb5dd406ad7d1fcaa49a0e35a307Fred Quintana } 1699c70dc0e38ff82c6e6d6b7458637c54fbdf446aacDmitri Plotnikov 1700c70dc0e38ff82c6e6d6b7458637c54fbdf446aacDmitri Plotnikov /** 1701c70dc0e38ff82c6e6d6b7458637c54fbdf446aacDmitri Plotnikov * Delete the aggregate contact if it has no constituent raw contacts other 1702c70dc0e38ff82c6e6d6b7458637c54fbdf446aacDmitri Plotnikov * than the supplied one. 1703c70dc0e38ff82c6e6d6b7458637c54fbdf446aacDmitri Plotnikov */ 1704c70dc0e38ff82c6e6d6b7458637c54fbdf446aacDmitri Plotnikov public void removeContactIfSingleton(long rawContactId) { 1705c70dc0e38ff82c6e6d6b7458637c54fbdf446aacDmitri Plotnikov SQLiteDatabase db = getWritableDatabase(); 1706c70dc0e38ff82c6e6d6b7458637c54fbdf446aacDmitri Plotnikov 1707c70dc0e38ff82c6e6d6b7458637c54fbdf446aacDmitri Plotnikov // Obtain contact ID from the supplied raw contact ID 1708c70dc0e38ff82c6e6d6b7458637c54fbdf446aacDmitri Plotnikov String contactIdFromRawContactId = "(SELECT " + RawContacts.CONTACT_ID + " FROM " 1709c70dc0e38ff82c6e6d6b7458637c54fbdf446aacDmitri Plotnikov + Tables.RAW_CONTACTS + " WHERE " + RawContacts._ID + "=" + rawContactId + ")"; 1710c70dc0e38ff82c6e6d6b7458637c54fbdf446aacDmitri Plotnikov 1711c70dc0e38ff82c6e6d6b7458637c54fbdf446aacDmitri Plotnikov // Find other raw contacts in the same aggregate contact 1712c70dc0e38ff82c6e6d6b7458637c54fbdf446aacDmitri Plotnikov String otherRawContacts = "(SELECT contacts1." + RawContacts._ID + " FROM " 1713c70dc0e38ff82c6e6d6b7458637c54fbdf446aacDmitri Plotnikov + Tables.RAW_CONTACTS + " contacts1 JOIN " + Tables.RAW_CONTACTS + " contacts2 ON (" 1714c70dc0e38ff82c6e6d6b7458637c54fbdf446aacDmitri Plotnikov + "contacts1." + RawContacts.CONTACT_ID + "=contacts2." + RawContacts.CONTACT_ID 1715c70dc0e38ff82c6e6d6b7458637c54fbdf446aacDmitri Plotnikov + ") WHERE contacts1." + RawContacts._ID + "!=" + rawContactId + "" 1716c70dc0e38ff82c6e6d6b7458637c54fbdf446aacDmitri Plotnikov + " AND contacts2." + RawContacts._ID + "=" + rawContactId + ")"; 1717c70dc0e38ff82c6e6d6b7458637c54fbdf446aacDmitri Plotnikov 1718c70dc0e38ff82c6e6d6b7458637c54fbdf446aacDmitri Plotnikov db.execSQL("DELETE FROM " + Tables.CONTACTS 1719c70dc0e38ff82c6e6d6b7458637c54fbdf446aacDmitri Plotnikov + " WHERE " + Contacts._ID + "=" + contactIdFromRawContactId 1720c70dc0e38ff82c6e6d6b7458637c54fbdf446aacDmitri Plotnikov + " AND NOT EXISTS " + otherRawContacts + ";"); 1721c70dc0e38ff82c6e6d6b7458637c54fbdf446aacDmitri Plotnikov } 17224a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov 17234a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov /** 17244a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov * Check if {@link Binder#getCallingUid()} should be allowed access to 17254a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov * {@link RawContacts#IS_RESTRICTED} data. 17264a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov */ 1727d91272b48f97243533c6580981e12a4847b5783fJeff Hamilton boolean hasAccessToRestrictedData() { 17284a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov final PackageManager pm = mContext.getPackageManager(); 17294a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov final String[] callerPackages = pm.getPackagesForUid(Binder.getCallingUid()); 17304a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov 17314a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov // Has restricted access if caller matches any packages 17324a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov for (String callerPackage : callerPackages) { 1733d91272b48f97243533c6580981e12a4847b5783fJeff Hamilton if (hasAccessToRestrictedData(callerPackage)) { 1734763100dcfabb368e72f25d24fe181c352bdb66d6Evan Millar return true; 1735763100dcfabb368e72f25d24fe181c352bdb66d6Evan Millar } 1736763100dcfabb368e72f25d24fe181c352bdb66d6Evan Millar } 1737763100dcfabb368e72f25d24fe181c352bdb66d6Evan Millar return false; 1738763100dcfabb368e72f25d24fe181c352bdb66d6Evan Millar } 1739763100dcfabb368e72f25d24fe181c352bdb66d6Evan Millar 1740763100dcfabb368e72f25d24fe181c352bdb66d6Evan Millar /** 1741763100dcfabb368e72f25d24fe181c352bdb66d6Evan Millar * Check if requestingPackage should be allowed access to 1742763100dcfabb368e72f25d24fe181c352bdb66d6Evan Millar * {@link RawContacts#IS_RESTRICTED} data. 1743763100dcfabb368e72f25d24fe181c352bdb66d6Evan Millar */ 1744d91272b48f97243533c6580981e12a4847b5783fJeff Hamilton boolean hasAccessToRestrictedData(String requestingPackage) { 1745d91272b48f97243533c6580981e12a4847b5783fJeff Hamilton if (mUnrestrictedPackages != null) { 1746d91272b48f97243533c6580981e12a4847b5783fJeff Hamilton for (String allowedPackage : mUnrestrictedPackages) { 1747d91272b48f97243533c6580981e12a4847b5783fJeff Hamilton if (allowedPackage.equals(requestingPackage)) { 1748d91272b48f97243533c6580981e12a4847b5783fJeff Hamilton return true; 1749d91272b48f97243533c6580981e12a4847b5783fJeff Hamilton } 17504a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov } 17514a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov } 17524a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov return false; 17534a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov } 17544a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov 17554a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov public String getDataView() { 1756d237c80845d8e13164d34278d3c20e31f8d80b4dDaisuke Miyakawa return getDataView(false); 1757d237c80845d8e13164d34278d3c20e31f8d80b4dDaisuke Miyakawa } 1758d237c80845d8e13164d34278d3c20e31f8d80b4dDaisuke Miyakawa 1759d237c80845d8e13164d34278d3c20e31f8d80b4dDaisuke Miyakawa public String getDataView(boolean requireRestrictedView) { 1760d91272b48f97243533c6580981e12a4847b5783fJeff Hamilton return (hasAccessToRestrictedData() && !requireRestrictedView) ? 1761d237c80845d8e13164d34278d3c20e31f8d80b4dDaisuke Miyakawa Views.DATA_ALL : Views.DATA_RESTRICTED; 17624a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov } 17634a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov 17644a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov public String getRawContactView() { 1765763100dcfabb368e72f25d24fe181c352bdb66d6Evan Millar return getRawContactView(false); 1766763100dcfabb368e72f25d24fe181c352bdb66d6Evan Millar } 1767763100dcfabb368e72f25d24fe181c352bdb66d6Evan Millar 1768763100dcfabb368e72f25d24fe181c352bdb66d6Evan Millar public String getRawContactView(boolean requireRestrictedView) { 1769d91272b48f97243533c6580981e12a4847b5783fJeff Hamilton return (hasAccessToRestrictedData() && !requireRestrictedView) ? 1770763100dcfabb368e72f25d24fe181c352bdb66d6Evan Millar Views.RAW_CONTACTS_ALL : Views.RAW_CONTACTS_RESTRICTED; 17714a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov } 17724a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov 17734a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov public String getContactView() { 1774763100dcfabb368e72f25d24fe181c352bdb66d6Evan Millar return getContactView(false); 17754a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov } 17764a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov 1777763100dcfabb368e72f25d24fe181c352bdb66d6Evan Millar public String getContactView(boolean requireRestrictedView) { 1778d91272b48f97243533c6580981e12a4847b5783fJeff Hamilton return (hasAccessToRestrictedData() && !requireRestrictedView) ? 1779763100dcfabb368e72f25d24fe181c352bdb66d6Evan Millar Views.CONTACTS_ALL : Views.CONTACTS_RESTRICTED; 1780f9aeb84d61c01a473819e9173f8311ca5d678a8dJeff Sharkey } 1781f9aeb84d61c01a473819e9173f8311ca5d678a8dJeff Sharkey 178289c626eb655440c86a2e5df076e83708c1b32c17Dmitri Plotnikov public String getGroupView() { 178389c626eb655440c86a2e5df076e83708c1b32c17Dmitri Plotnikov return Views.GROUPS_ALL; 178489c626eb655440c86a2e5df076e83708c1b32c17Dmitri Plotnikov } 178589c626eb655440c86a2e5df076e83708c1b32c17Dmitri Plotnikov 1786d237c80845d8e13164d34278d3c20e31f8d80b4dDaisuke Miyakawa public String getContactEntitiesView() { 1787d237c80845d8e13164d34278d3c20e31f8d80b4dDaisuke Miyakawa return getContactEntitiesView(false); 1788d237c80845d8e13164d34278d3c20e31f8d80b4dDaisuke Miyakawa } 1789d237c80845d8e13164d34278d3c20e31f8d80b4dDaisuke Miyakawa 1790d237c80845d8e13164d34278d3c20e31f8d80b4dDaisuke Miyakawa public String getContactEntitiesView(boolean requireRestrictedView) { 1791d91272b48f97243533c6580981e12a4847b5783fJeff Hamilton return (hasAccessToRestrictedData() && !requireRestrictedView) ? 1792d237c80845d8e13164d34278d3c20e31f8d80b4dDaisuke Miyakawa Tables.CONTACT_ENTITIES : Tables.CONTACT_ENTITIES_RESTRICTED; 1793d237c80845d8e13164d34278d3c20e31f8d80b4dDaisuke Miyakawa } 1794d237c80845d8e13164d34278d3c20e31f8d80b4dDaisuke Miyakawa 1795ff2de103f7e3eeeff4665ef63f07460fef053d6dDmitri Plotnikov /** 1796ff2de103f7e3eeeff4665ef63f07460fef053d6dDmitri Plotnikov * Test if any of the columns appear in the given projection. 1797ff2de103f7e3eeeff4665ef63f07460fef053d6dDmitri Plotnikov */ 1798ff2de103f7e3eeeff4665ef63f07460fef053d6dDmitri Plotnikov public boolean isInProjection(String[] projection, String... columns) { 179982bd858c9911dfbd8dca52dc276333768b0a429eDmitri Plotnikov if (projection == null) { 180082bd858c9911dfbd8dca52dc276333768b0a429eDmitri Plotnikov return true; 180182bd858c9911dfbd8dca52dc276333768b0a429eDmitri Plotnikov } 1802ff2de103f7e3eeeff4665ef63f07460fef053d6dDmitri Plotnikov 180382bd858c9911dfbd8dca52dc276333768b0a429eDmitri Plotnikov // Optimized for a single-column test 180482bd858c9911dfbd8dca52dc276333768b0a429eDmitri Plotnikov if (columns.length == 1) { 180582bd858c9911dfbd8dca52dc276333768b0a429eDmitri Plotnikov String column = columns[0]; 180682bd858c9911dfbd8dca52dc276333768b0a429eDmitri Plotnikov for (String test : projection) { 180782bd858c9911dfbd8dca52dc276333768b0a429eDmitri Plotnikov if (column.equals(test)) { 180882bd858c9911dfbd8dca52dc276333768b0a429eDmitri Plotnikov return true; 180982bd858c9911dfbd8dca52dc276333768b0a429eDmitri Plotnikov } 181082bd858c9911dfbd8dca52dc276333768b0a429eDmitri Plotnikov } 181182bd858c9911dfbd8dca52dc276333768b0a429eDmitri Plotnikov } else { 181282bd858c9911dfbd8dca52dc276333768b0a429eDmitri Plotnikov for (String test : projection) { 181382bd858c9911dfbd8dca52dc276333768b0a429eDmitri Plotnikov for (String column : columns) { 1814ff2de103f7e3eeeff4665ef63f07460fef053d6dDmitri Plotnikov if (column.equals(test)) { 1815ff2de103f7e3eeeff4665ef63f07460fef053d6dDmitri Plotnikov return true; 1816ff2de103f7e3eeeff4665ef63f07460fef053d6dDmitri Plotnikov } 1817ff2de103f7e3eeeff4665ef63f07460fef053d6dDmitri Plotnikov } 1818ff2de103f7e3eeeff4665ef63f07460fef053d6dDmitri Plotnikov } 1819ff2de103f7e3eeeff4665ef63f07460fef053d6dDmitri Plotnikov } 1820ff2de103f7e3eeeff4665ef63f07460fef053d6dDmitri Plotnikov return false; 18214a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov } 1822b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey} 1823