ContactsDatabaseHelper.java revision d91272b48f97243533c6580981e12a4847b5783f
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 646a809c1d28c1ba36203d9e54709a08667478d9d7Dmitri Plotnikov private static final int DATABASE_VERSION = 98; 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"; 442e46667e641cd1c60998e1ccab4b60531d5b12ef7Dmitri Plotnikov } 443e46667e641cd1c60998e1ccab4b60531d5b12ef7Dmitri Plotnikov 444a23cd5b6f478f6c9dda54173e84bd0098b9f3364Dmitri Plotnikov public interface StatusUpdatesColumns { 445a23cd5b6f478f6c9dda54173e84bd0098b9f3364Dmitri Plotnikov String DATA_ID = "status_update_data_id"; 446a23cd5b6f478f6c9dda54173e84bd0098b9f3364Dmitri Plotnikov } 447a23cd5b6f478f6c9dda54173e84bd0098b9f3364Dmitri Plotnikov 448b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey /** In-memory cache of previously found mimetype mappings */ 449bf659107617a6291ba8bfeebc3f2e50138075ab5Dmitri Plotnikov private final HashMap<String, Long> mMimetypeCache = new HashMap<String, Long>(); 450b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey /** In-memory cache of previously found package name mappings */ 451bf659107617a6291ba8bfeebc3f2e50138075ab5Dmitri Plotnikov private final HashMap<String, Long> mPackageCache = new HashMap<String, Long>(); 452b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey 453b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey 454b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey /** Compiled statements for querying and inserting mappings */ 455b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey private SQLiteStatement mMimetypeQuery; 456b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey private SQLiteStatement mPackageQuery; 457d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov private SQLiteStatement mContactIdQuery; 458f4e1358f1c8f5fe5e9e7689e36e04c57c2385169Dmitri Plotnikov private SQLiteStatement mAggregationModeQuery; 459b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey private SQLiteStatement mMimetypeInsert; 460b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey private SQLiteStatement mPackageInsert; 461b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey private SQLiteStatement mDataMimetypeQuery; 462b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey private SQLiteStatement mActivitiesMimetypeQuery; 463b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey 464b597adb79f1f57a24be2be09e3f45fa0f04f6f8fDmitri Plotnikov private final Context mContext; 46535ed95769096bb5dd406ad7d1fcaa49a0e35a307Fred Quintana private final SyncStateContentProviderHelper mSyncState; 466f23764675b35b5262a39c79aad8e9842460274b2Dmitri Plotnikov 467b597adb79f1f57a24be2be09e3f45fa0f04f6f8fDmitri Plotnikov 468d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov /** Compiled statements for updating {@link Contacts#IN_VISIBLE_GROUP}. */ 469e07913c61c320b0cc2036db3b714e39534d8cd7aJeff Sharkey private SQLiteStatement mVisibleUpdate; 470ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey private SQLiteStatement mVisibleSpecificUpdate; 471ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey 472f79538095a1af16dcd6e641448b627f60f197802Dmitri Plotnikov private boolean mReopenDatabase = false; 473f79538095a1af16dcd6e641448b627f60f197802Dmitri Plotnikov 474b38ed2c5ffeb20efc677b4a9229db4a00603aa8dDmitri Plotnikov private static ContactsDatabaseHelper sSingleton = null; 475b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey 4763a6a49cfb06272e3e25f3c390a9cf4002da6e34dDaisuke Miyakawa private boolean mUseStrictPhoneNumberComparation; 4773a6a49cfb06272e3e25f3c390a9cf4002da6e34dDaisuke Miyakawa 478d91272b48f97243533c6580981e12a4847b5783fJeff Hamilton /** 479d91272b48f97243533c6580981e12a4847b5783fJeff Hamilton * List of package names with access to {@link RawContacts#IS_RESTRICTED} data. 480d91272b48f97243533c6580981e12a4847b5783fJeff Hamilton */ 481d91272b48f97243533c6580981e12a4847b5783fJeff Hamilton private String[] mUnrestrictedPackages; 482d91272b48f97243533c6580981e12a4847b5783fJeff Hamilton 483b38ed2c5ffeb20efc677b4a9229db4a00603aa8dDmitri Plotnikov public static synchronized ContactsDatabaseHelper getInstance(Context context) { 484b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey if (sSingleton == null) { 485b38ed2c5ffeb20efc677b4a9229db4a00603aa8dDmitri Plotnikov sSingleton = new ContactsDatabaseHelper(context); 486b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey } 487b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey return sSingleton; 488b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey } 489b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey 4901f42f1958113b2dadc6cf26b51192b42f883f3b0Jeff Sharkey /** 49131b86315536573a72dc7fff1baac3b314e5a04c3Dmitri Plotnikov * Private constructor, callers except unit tests should obtain an instance through 49235ed95769096bb5dd406ad7d1fcaa49a0e35a307Fred Quintana * {@link #getInstance(android.content.Context)} instead. 4931f42f1958113b2dadc6cf26b51192b42f883f3b0Jeff Sharkey */ 494b38ed2c5ffeb20efc677b4a9229db4a00603aa8dDmitri Plotnikov ContactsDatabaseHelper(Context context) { 495b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey super(context, DATABASE_NAME, null, DATABASE_VERSION); 496b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey Log.i(TAG, "Creating OpenHelper"); 497d91272b48f97243533c6580981e12a4847b5783fJeff Hamilton Resources resources = context.getResources(); 498619871b0fb0175d75ff9336bfe5aec0b27b9bdadJeff Sharkey 499b597adb79f1f57a24be2be09e3f45fa0f04f6f8fDmitri Plotnikov mContext = context; 50028b3769e3fcecae56c3fc70cbcb0f95282b9640eFred Quintana mSyncState = new SyncStateContentProviderHelper(); 5013a6a49cfb06272e3e25f3c390a9cf4002da6e34dDaisuke Miyakawa mUseStrictPhoneNumberComparation = 502d91272b48f97243533c6580981e12a4847b5783fJeff Hamilton resources.getBoolean( 503d91272b48f97243533c6580981e12a4847b5783fJeff Hamilton com.android.internal.R.bool.config_use_strict_phone_number_comparation); 504d91272b48f97243533c6580981e12a4847b5783fJeff Hamilton mUnrestrictedPackages = resources.getStringArray( 505d91272b48f97243533c6580981e12a4847b5783fJeff Hamilton resources.getIdentifier("unrestricted_packages", "array", 506d91272b48f97243533c6580981e12a4847b5783fJeff Hamilton context.getPackageName())); 507b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey } 508b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey 509b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey @Override 510b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey public void onOpen(SQLiteDatabase db) { 51135ed95769096bb5dd406ad7d1fcaa49a0e35a307Fred Quintana mSyncState.onDatabaseOpened(db); 51235ed95769096bb5dd406ad7d1fcaa49a0e35a307Fred Quintana 513b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey // Create compiled statements for package and mimetype lookups 514ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey mMimetypeQuery = db.compileStatement("SELECT " + MimetypesColumns._ID + " FROM " 515ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey + Tables.MIMETYPES + " WHERE " + MimetypesColumns.MIMETYPE + "=?"); 516ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey mPackageQuery = db.compileStatement("SELECT " + PackagesColumns._ID + " FROM " 517ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey + Tables.PACKAGES + " WHERE " + PackagesColumns.PACKAGE + "=?"); 518d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov mContactIdQuery = db.compileStatement("SELECT " + RawContacts.CONTACT_ID + " FROM " 5195ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov + Tables.RAW_CONTACTS + " WHERE " + RawContacts._ID + "=?"); 5206cffee46a1334d2b3ed19f436b27638451541044Dmitri Plotnikov mAggregationModeQuery = db.compileStatement("SELECT " + RawContacts.AGGREGATION_MODE 5215ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov + " FROM " + Tables.RAW_CONTACTS + " WHERE " + RawContacts._ID + "=?"); 522ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey mMimetypeInsert = db.compileStatement("INSERT INTO " + Tables.MIMETYPES + "(" 523ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey + MimetypesColumns.MIMETYPE + ") VALUES (?)"); 524ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey mPackageInsert = db.compileStatement("INSERT INTO " + Tables.PACKAGES + "(" 525ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey + PackagesColumns.PACKAGE + ") VALUES (?)"); 526ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey 527ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey mDataMimetypeQuery = db.compileStatement("SELECT " + MimetypesColumns.MIMETYPE + " FROM " 528ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey + Tables.DATA_JOIN_MIMETYPES + " WHERE " + Tables.DATA + "." + Data._ID + "=?"); 529ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey mActivitiesMimetypeQuery = db.compileStatement("SELECT " + MimetypesColumns.MIMETYPE 530ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey + " FROM " + Tables.ACTIVITIES_JOIN_MIMETYPES + " WHERE " + Tables.ACTIVITIES + "." 531b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey + Activities._ID + "=?"); 5321f42f1958113b2dadc6cf26b51192b42f883f3b0Jeff Sharkey 533e07913c61c320b0cc2036db3b714e39534d8cd7aJeff Sharkey // Compile statements for updating visibility 534d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov final String visibleUpdate = "UPDATE " + Tables.CONTACTS + " SET " 535e07913c61c320b0cc2036db3b714e39534d8cd7aJeff Sharkey + Contacts.IN_VISIBLE_GROUP + "=(" + Clauses.CONTACT_IS_VISIBLE + ")"; 536ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey 537e07913c61c320b0cc2036db3b714e39534d8cd7aJeff Sharkey mVisibleUpdate = db.compileStatement(visibleUpdate); 538ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey mVisibleSpecificUpdate = db.compileStatement(visibleUpdate + " WHERE " 539d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov + ContactsColumns.CONCRETE_ID + "=?"); 540ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey 5411f42f1958113b2dadc6cf26b51192b42f883f3b0Jeff Sharkey db.execSQL("ATTACH DATABASE ':memory:' AS " + DATABASE_PRESENCE + ";"); 542e46667e641cd1c60998e1ccab4b60531d5b12ef7Dmitri Plotnikov db.execSQL("CREATE TABLE IF NOT EXISTS " + DATABASE_PRESENCE + "." + Tables.PRESENCE + " ("+ 54382bd858c9911dfbd8dca52dc276333768b0a429eDmitri Plotnikov StatusUpdates.DATA_ID + " INTEGER PRIMARY KEY REFERENCES data(_id)," + 54482bd858c9911dfbd8dca52dc276333768b0a429eDmitri Plotnikov StatusUpdates.PROTOCOL + " INTEGER NOT NULL," + 54582bd858c9911dfbd8dca52dc276333768b0a429eDmitri Plotnikov StatusUpdates.CUSTOM_PROTOCOL + " TEXT," + 54682bd858c9911dfbd8dca52dc276333768b0a429eDmitri Plotnikov StatusUpdates.IM_HANDLE + " TEXT," + 54782bd858c9911dfbd8dca52dc276333768b0a429eDmitri Plotnikov StatusUpdates.IM_ACCOUNT + " TEXT," + 548a23cd5b6f478f6c9dda54173e84bd0098b9f3364Dmitri Plotnikov PresenceColumns.CONTACT_ID + " INTEGER REFERENCES contacts(_id)," + 549a23cd5b6f478f6c9dda54173e84bd0098b9f3364Dmitri Plotnikov PresenceColumns.RAW_CONTACT_ID + " INTEGER REFERENCES raw_contacts(_id)," + 55082bd858c9911dfbd8dca52dc276333768b0a429eDmitri Plotnikov StatusUpdates.PRESENCE + " INTEGER," + 55182bd858c9911dfbd8dca52dc276333768b0a429eDmitri Plotnikov "UNIQUE(" + StatusUpdates.PROTOCOL + ", " + StatusUpdates.CUSTOM_PROTOCOL 55282bd858c9911dfbd8dca52dc276333768b0a429eDmitri Plotnikov + ", " + StatusUpdates.IM_HANDLE + ", " + StatusUpdates.IM_ACCOUNT + ")" + 5531f42f1958113b2dadc6cf26b51192b42f883f3b0Jeff Sharkey ");"); 5541f42f1958113b2dadc6cf26b51192b42f883f3b0Jeff Sharkey 555e46667e641cd1c60998e1ccab4b60531d5b12ef7Dmitri Plotnikov db.execSQL("CREATE INDEX IF NOT EXISTS " + DATABASE_PRESENCE + ".presenceIndex" + " ON " 5564dcd106ccc27dbbfaae86baf0cd57beb42c27cccDmitri Plotnikov + Tables.PRESENCE + " (" + PresenceColumns.RAW_CONTACT_ID + ");"); 557e46667e641cd1c60998e1ccab4b60531d5b12ef7Dmitri Plotnikov 558e46667e641cd1c60998e1ccab4b60531d5b12ef7Dmitri Plotnikov db.execSQL("CREATE TABLE IF NOT EXISTS " 559e46667e641cd1c60998e1ccab4b60531d5b12ef7Dmitri Plotnikov + DATABASE_PRESENCE + "." + Tables.AGGREGATED_PRESENCE + " ("+ 560e46667e641cd1c60998e1ccab4b60531d5b12ef7Dmitri Plotnikov AggregatedPresenceColumns.CONTACT_ID 561e46667e641cd1c60998e1ccab4b60531d5b12ef7Dmitri Plotnikov + " INTEGER PRIMARY KEY REFERENCES contacts(_id)," + 56282bd858c9911dfbd8dca52dc276333768b0a429eDmitri Plotnikov StatusUpdates.PRESENCE_STATUS + " INTEGER" + 563e46667e641cd1c60998e1ccab4b60531d5b12ef7Dmitri Plotnikov ");"); 564bffeabdf3dcf58f963ad1bb4d3e6e51f3ac16cfdDmitri Plotnikov 565bffeabdf3dcf58f963ad1bb4d3e6e51f3ac16cfdDmitri Plotnikov 566bffeabdf3dcf58f963ad1bb4d3e6e51f3ac16cfdDmitri Plotnikov db.execSQL("CREATE TRIGGER " + DATABASE_PRESENCE + "." + Tables.PRESENCE + "_deleted" 567bffeabdf3dcf58f963ad1bb4d3e6e51f3ac16cfdDmitri Plotnikov + " BEFORE DELETE ON " + DATABASE_PRESENCE + "." + Tables.PRESENCE 568bffeabdf3dcf58f963ad1bb4d3e6e51f3ac16cfdDmitri Plotnikov + " BEGIN " 569bffeabdf3dcf58f963ad1bb4d3e6e51f3ac16cfdDmitri Plotnikov + " DELETE FROM " + Tables.AGGREGATED_PRESENCE 570bffeabdf3dcf58f963ad1bb4d3e6e51f3ac16cfdDmitri Plotnikov + " WHERE " + AggregatedPresenceColumns.CONTACT_ID + " = " + 571bffeabdf3dcf58f963ad1bb4d3e6e51f3ac16cfdDmitri Plotnikov "(SELECT " + PresenceColumns.CONTACT_ID + 572bffeabdf3dcf58f963ad1bb4d3e6e51f3ac16cfdDmitri Plotnikov " FROM " + Tables.PRESENCE + 573bffeabdf3dcf58f963ad1bb4d3e6e51f3ac16cfdDmitri Plotnikov " WHERE " + PresenceColumns.RAW_CONTACT_ID 574bffeabdf3dcf58f963ad1bb4d3e6e51f3ac16cfdDmitri Plotnikov + "=OLD." + PresenceColumns.RAW_CONTACT_ID + 575bffeabdf3dcf58f963ad1bb4d3e6e51f3ac16cfdDmitri Plotnikov " AND NOT EXISTS" + 576bffeabdf3dcf58f963ad1bb4d3e6e51f3ac16cfdDmitri Plotnikov "(SELECT " + PresenceColumns.RAW_CONTACT_ID + 577bffeabdf3dcf58f963ad1bb4d3e6e51f3ac16cfdDmitri Plotnikov " FROM " + Tables.PRESENCE + 578bffeabdf3dcf58f963ad1bb4d3e6e51f3ac16cfdDmitri Plotnikov " WHERE " + PresenceColumns.CONTACT_ID 579bffeabdf3dcf58f963ad1bb4d3e6e51f3ac16cfdDmitri Plotnikov + "=OLD." + PresenceColumns.CONTACT_ID + 580bffeabdf3dcf58f963ad1bb4d3e6e51f3ac16cfdDmitri Plotnikov " AND " + PresenceColumns.RAW_CONTACT_ID 581bffeabdf3dcf58f963ad1bb4d3e6e51f3ac16cfdDmitri Plotnikov + "!=OLD." + PresenceColumns.RAW_CONTACT_ID + "));" 582bffeabdf3dcf58f963ad1bb4d3e6e51f3ac16cfdDmitri Plotnikov + " END"); 583bffeabdf3dcf58f963ad1bb4d3e6e51f3ac16cfdDmitri Plotnikov 584bffeabdf3dcf58f963ad1bb4d3e6e51f3ac16cfdDmitri Plotnikov String replaceAggregatePresenceSql = 585bffeabdf3dcf58f963ad1bb4d3e6e51f3ac16cfdDmitri Plotnikov "INSERT OR REPLACE INTO " + Tables.AGGREGATED_PRESENCE + "(" 586bffeabdf3dcf58f963ad1bb4d3e6e51f3ac16cfdDmitri Plotnikov + AggregatedPresenceColumns.CONTACT_ID + ", " 58782bd858c9911dfbd8dca52dc276333768b0a429eDmitri Plotnikov + StatusUpdates.PRESENCE_STATUS + ")" + 588bffeabdf3dcf58f963ad1bb4d3e6e51f3ac16cfdDmitri Plotnikov " SELECT " + PresenceColumns.CONTACT_ID + "," 58982bd858c9911dfbd8dca52dc276333768b0a429eDmitri Plotnikov + "MAX(" + StatusUpdates.PRESENCE_STATUS + ")" + 590bffeabdf3dcf58f963ad1bb4d3e6e51f3ac16cfdDmitri Plotnikov " FROM " + Tables.PRESENCE + 591bffeabdf3dcf58f963ad1bb4d3e6e51f3ac16cfdDmitri Plotnikov " WHERE " + PresenceColumns.CONTACT_ID 592bffeabdf3dcf58f963ad1bb4d3e6e51f3ac16cfdDmitri Plotnikov + "=NEW." + PresenceColumns.CONTACT_ID + ";"; 593bffeabdf3dcf58f963ad1bb4d3e6e51f3ac16cfdDmitri Plotnikov 594bffeabdf3dcf58f963ad1bb4d3e6e51f3ac16cfdDmitri Plotnikov db.execSQL("CREATE TRIGGER " + DATABASE_PRESENCE + "." + Tables.PRESENCE + "_inserted" 595bffeabdf3dcf58f963ad1bb4d3e6e51f3ac16cfdDmitri Plotnikov + " AFTER INSERT ON " + DATABASE_PRESENCE + "." + Tables.PRESENCE 596bffeabdf3dcf58f963ad1bb4d3e6e51f3ac16cfdDmitri Plotnikov + " BEGIN " 597bffeabdf3dcf58f963ad1bb4d3e6e51f3ac16cfdDmitri Plotnikov + replaceAggregatePresenceSql 598bffeabdf3dcf58f963ad1bb4d3e6e51f3ac16cfdDmitri Plotnikov + " END"); 599bffeabdf3dcf58f963ad1bb4d3e6e51f3ac16cfdDmitri Plotnikov 600bffeabdf3dcf58f963ad1bb4d3e6e51f3ac16cfdDmitri Plotnikov db.execSQL("CREATE TRIGGER " + DATABASE_PRESENCE + "." + Tables.PRESENCE + "_updated" 601bffeabdf3dcf58f963ad1bb4d3e6e51f3ac16cfdDmitri Plotnikov + " AFTER UPDATE ON " + DATABASE_PRESENCE + "." + Tables.PRESENCE 602bffeabdf3dcf58f963ad1bb4d3e6e51f3ac16cfdDmitri Plotnikov + " BEGIN " 603bffeabdf3dcf58f963ad1bb4d3e6e51f3ac16cfdDmitri Plotnikov + replaceAggregatePresenceSql 604bffeabdf3dcf58f963ad1bb4d3e6e51f3ac16cfdDmitri Plotnikov + " END"); 605b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey } 606b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey 607b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey @Override 608b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey public void onCreate(SQLiteDatabase db) { 609b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey Log.i(TAG, "Bootstrapping database"); 610b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey 61135ed95769096bb5dd406ad7d1fcaa49a0e35a307Fred Quintana mSyncState.createDatabase(db); 61235ed95769096bb5dd406ad7d1fcaa49a0e35a307Fred Quintana 613b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey // One row per group of contacts corresponding to the same person 614d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov db.execSQL("CREATE TABLE " + Tables.CONTACTS + " (" + 615b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey BaseColumns._ID + " INTEGER PRIMARY KEY AUTOINCREMENT," + 616d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov Contacts.DISPLAY_NAME + " TEXT," + 617d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov Contacts.PHOTO_ID + " INTEGER REFERENCES data(_id)," + 618d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov Contacts.CUSTOM_RINGTONE + " TEXT," + 619d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov Contacts.SEND_TO_VOICEMAIL + " INTEGER NOT NULL DEFAULT 0," + 620d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov Contacts.TIMES_CONTACTED + " INTEGER NOT NULL DEFAULT 0," + 621d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov Contacts.LAST_TIME_CONTACTED + " INTEGER," + 622d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov Contacts.STARRED + " INTEGER NOT NULL DEFAULT 0," + 623cdbd854decda3f493b395c8867f2cd131d95d09fDmitri Plotnikov Contacts.IN_VISIBLE_GROUP + " INTEGER NOT NULL DEFAULT 1," + 624f992bfab334b760d36a053fc0b439382dcfb51adDmitri Plotnikov Contacts.HAS_PHONE_NUMBER + " INTEGER NOT NULL DEFAULT 0," + 6255870f2dcc2ac7715b2c078a886ee346622e7887eDmitri Plotnikov Contacts.LOOKUP_KEY + " TEXT," + 626a23cd5b6f478f6c9dda54173e84bd0098b9f3364Dmitri Plotnikov ContactsColumns.LAST_STATUS_UPDATE_ID + " INTEGER REFERENCES data(_id)," + 6274a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov ContactsColumns.SINGLE_IS_RESTRICTED + " INTEGER NOT NULL DEFAULT 0" + 628b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey ");"); 629b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey 630ba965ceeb86dd9404d43f418daae357bc4afbdcdJeff Hamilton db.execSQL("CREATE TRIGGER contacts_times_contacted UPDATE OF " + 631ba965ceeb86dd9404d43f418daae357bc4afbdcdJeff Hamilton Contacts.LAST_TIME_CONTACTED + " ON " + Tables.CONTACTS + " " + 632ba965ceeb86dd9404d43f418daae357bc4afbdcdJeff Hamilton "BEGIN " + 633ba965ceeb86dd9404d43f418daae357bc4afbdcdJeff Hamilton "UPDATE " + Tables.CONTACTS + " SET " 634ba965ceeb86dd9404d43f418daae357bc4afbdcdJeff Hamilton + Contacts.TIMES_CONTACTED + " = " + "" + 635ba965ceeb86dd9404d43f418daae357bc4afbdcdJeff Hamilton "(new." + Contacts.TIMES_CONTACTED + " + 1)" 636ba965ceeb86dd9404d43f418daae357bc4afbdcdJeff Hamilton + " WHERE _id = new._id;" + 637ba965ceeb86dd9404d43f418daae357bc4afbdcdJeff Hamilton "END"); 638ba965ceeb86dd9404d43f418daae357bc4afbdcdJeff Hamilton 63954d6316486a810f45abade9d985dbb52b6cb17e2Dmitri Plotnikov db.execSQL("CREATE INDEX contacts_visible_index ON " + Tables.CONTACTS + " (" + 640737858a04a157a0afad9ec81372c75d14bf68788Jeff Hamilton Contacts.IN_VISIBLE_GROUP + "," + 641737858a04a157a0afad9ec81372c75d14bf68788Jeff Hamilton Contacts.DISPLAY_NAME + " COLLATE LOCALIZED" + 64254d6316486a810f45abade9d985dbb52b6cb17e2Dmitri Plotnikov ");"); 64354d6316486a810f45abade9d985dbb52b6cb17e2Dmitri Plotnikov 64454d6316486a810f45abade9d985dbb52b6cb17e2Dmitri Plotnikov db.execSQL("CREATE INDEX contacts_has_phone_index ON " + Tables.CONTACTS + " (" + 64554d6316486a810f45abade9d985dbb52b6cb17e2Dmitri Plotnikov Contacts.HAS_PHONE_NUMBER + 64654d6316486a810f45abade9d985dbb52b6cb17e2Dmitri Plotnikov ");"); 64754d6316486a810f45abade9d985dbb52b6cb17e2Dmitri Plotnikov 64854d6316486a810f45abade9d985dbb52b6cb17e2Dmitri Plotnikov db.execSQL("CREATE INDEX contacts_restricted_index ON " + Tables.CONTACTS + " (" + 64954d6316486a810f45abade9d985dbb52b6cb17e2Dmitri Plotnikov ContactsColumns.SINGLE_IS_RESTRICTED + 65054d6316486a810f45abade9d985dbb52b6cb17e2Dmitri Plotnikov ");"); 65154d6316486a810f45abade9d985dbb52b6cb17e2Dmitri Plotnikov 652b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey // Contacts table 6535ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov db.execSQL("CREATE TABLE " + Tables.RAW_CONTACTS + " (" + 6546cffee46a1334d2b3ed19f436b27638451541044Dmitri Plotnikov RawContacts._ID + " INTEGER PRIMARY KEY AUTOINCREMENT," + 6556cffee46a1334d2b3ed19f436b27638451541044Dmitri Plotnikov RawContacts.IS_RESTRICTED + " INTEGER DEFAULT 0," + 6566cffee46a1334d2b3ed19f436b27638451541044Dmitri Plotnikov RawContacts.ACCOUNT_NAME + " STRING DEFAULT NULL, " + 6576cffee46a1334d2b3ed19f436b27638451541044Dmitri Plotnikov RawContacts.ACCOUNT_TYPE + " STRING DEFAULT NULL, " + 6586cffee46a1334d2b3ed19f436b27638451541044Dmitri Plotnikov RawContacts.SOURCE_ID + " TEXT," + 6596cffee46a1334d2b3ed19f436b27638451541044Dmitri Plotnikov RawContacts.VERSION + " INTEGER NOT NULL DEFAULT 1," + 66073776ffd5c00e94db987ee30864e9c7a8396d22dDmitri Plotnikov RawContacts.DIRTY + " INTEGER NOT NULL DEFAULT 0," + 66133b41fdb8d7c3c654cb070799c9d6e2b4ab16078Dmitri Plotnikov RawContacts.DELETED + " INTEGER NOT NULL DEFAULT 0," + 66254d6316486a810f45abade9d985dbb52b6cb17e2Dmitri Plotnikov RawContacts.CONTACT_ID + " INTEGER REFERENCES contacts(_id)," + 6636cffee46a1334d2b3ed19f436b27638451541044Dmitri Plotnikov RawContacts.AGGREGATION_MODE + " INTEGER NOT NULL DEFAULT " + 6646cffee46a1334d2b3ed19f436b27638451541044Dmitri Plotnikov RawContacts.AGGREGATION_MODE_DEFAULT + "," + 6658e45e5f2142db78941b095f7418cc05b71668094Dmitri Plotnikov RawContactsColumns.AGGREGATION_NEEDED + " INTEGER NOT NULL DEFAULT 1," + 6666cffee46a1334d2b3ed19f436b27638451541044Dmitri Plotnikov RawContacts.CUSTOM_RINGTONE + " TEXT," + 6676cffee46a1334d2b3ed19f436b27638451541044Dmitri Plotnikov RawContacts.SEND_TO_VOICEMAIL + " INTEGER NOT NULL DEFAULT 0," + 6686cffee46a1334d2b3ed19f436b27638451541044Dmitri Plotnikov RawContacts.TIMES_CONTACTED + " INTEGER NOT NULL DEFAULT 0," + 6696cffee46a1334d2b3ed19f436b27638451541044Dmitri Plotnikov RawContacts.LAST_TIME_CONTACTED + " INTEGER," + 67033b41fdb8d7c3c654cb070799c9d6e2b4ab16078Dmitri Plotnikov RawContacts.STARRED + " INTEGER NOT NULL DEFAULT 0," + 6713cfe8d532d509fbbe605454e3a32b2361b7e1501Dmitri Plotnikov RawContactsColumns.DISPLAY_NAME + " TEXT," + 67225abcf949c0dd826a770b437489b83de48975ceaDmitri Plotnikov RawContactsColumns.DISPLAY_NAME_SOURCE + " INTEGER NOT NULL DEFAULT " + 67325abcf949c0dd826a770b437489b83de48975ceaDmitri Plotnikov DisplayNameSources.UNDEFINED + "," + 6743cfe8d532d509fbbe605454e3a32b2361b7e1501Dmitri Plotnikov RawContacts.SYNC1 + " TEXT, " + 6753cfe8d532d509fbbe605454e3a32b2361b7e1501Dmitri Plotnikov RawContacts.SYNC2 + " TEXT, " + 6763cfe8d532d509fbbe605454e3a32b2361b7e1501Dmitri Plotnikov RawContacts.SYNC3 + " TEXT, " + 6773cfe8d532d509fbbe605454e3a32b2361b7e1501Dmitri Plotnikov RawContacts.SYNC4 + " TEXT " + 678b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey ");"); 679b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey 680ba965ceeb86dd9404d43f418daae357bc4afbdcdJeff Hamilton db.execSQL("CREATE TRIGGER raw_contacts_times_contacted UPDATE OF " + 681ba965ceeb86dd9404d43f418daae357bc4afbdcdJeff Hamilton RawContacts.LAST_TIME_CONTACTED + " ON " + Tables.RAW_CONTACTS + " " + 682ba965ceeb86dd9404d43f418daae357bc4afbdcdJeff Hamilton "BEGIN " + 683ba965ceeb86dd9404d43f418daae357bc4afbdcdJeff Hamilton "UPDATE " + Tables.RAW_CONTACTS + " SET " 684ba965ceeb86dd9404d43f418daae357bc4afbdcdJeff Hamilton + RawContacts.TIMES_CONTACTED + " = " + "" + 685ba965ceeb86dd9404d43f418daae357bc4afbdcdJeff Hamilton "(new." + RawContacts.TIMES_CONTACTED + " + 1)" 686ba965ceeb86dd9404d43f418daae357bc4afbdcdJeff Hamilton + " WHERE _id = new._id;" + 687ba965ceeb86dd9404d43f418daae357bc4afbdcdJeff Hamilton "END"); 688ba965ceeb86dd9404d43f418daae357bc4afbdcdJeff Hamilton 68954d6316486a810f45abade9d985dbb52b6cb17e2Dmitri Plotnikov db.execSQL("CREATE INDEX raw_contacts_contact_id_index ON " + Tables.RAW_CONTACTS + " (" + 69054d6316486a810f45abade9d985dbb52b6cb17e2Dmitri Plotnikov RawContacts.CONTACT_ID + 69154d6316486a810f45abade9d985dbb52b6cb17e2Dmitri Plotnikov ");"); 69254d6316486a810f45abade9d985dbb52b6cb17e2Dmitri Plotnikov 6935f515d93c04729e6cdc9b704d18579162d71d5f2Dmitri Plotnikov db.execSQL("CREATE INDEX raw_contacts_source_id_index ON " + Tables.RAW_CONTACTS + " (" + 6945f515d93c04729e6cdc9b704d18579162d71d5f2Dmitri Plotnikov RawContacts.SOURCE_ID + ", " + 6955f515d93c04729e6cdc9b704d18579162d71d5f2Dmitri Plotnikov RawContacts.ACCOUNT_TYPE + ", " + 6965f515d93c04729e6cdc9b704d18579162d71d5f2Dmitri Plotnikov RawContacts.ACCOUNT_NAME + 6975f515d93c04729e6cdc9b704d18579162d71d5f2Dmitri Plotnikov ");"); 6985f515d93c04729e6cdc9b704d18579162d71d5f2Dmitri Plotnikov 699f79538095a1af16dcd6e641448b627f60f197802Dmitri Plotnikov // TODO readd the index and investigate a controlled use of it 700f79538095a1af16dcd6e641448b627f60f197802Dmitri Plotnikov// db.execSQL("CREATE INDEX raw_contacts_agg_index ON " + Tables.RAW_CONTACTS + " (" + 701f79538095a1af16dcd6e641448b627f60f197802Dmitri Plotnikov// RawContactsColumns.AGGREGATION_NEEDED + 702f79538095a1af16dcd6e641448b627f60f197802Dmitri Plotnikov// ");"); 7038e45e5f2142db78941b095f7418cc05b71668094Dmitri Plotnikov 704b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey // Package name mapping table 705ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey db.execSQL("CREATE TABLE " + Tables.PACKAGES + " (" + 706ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey PackagesColumns._ID + " INTEGER PRIMARY KEY AUTOINCREMENT," + 707ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey PackagesColumns.PACKAGE + " TEXT NOT NULL" + 708b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey ");"); 709b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey 710ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey // Mimetype mapping table 711ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey db.execSQL("CREATE TABLE " + Tables.MIMETYPES + " (" + 712ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey MimetypesColumns._ID + " INTEGER PRIMARY KEY AUTOINCREMENT," + 713ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey MimetypesColumns.MIMETYPE + " TEXT NOT NULL" + 714b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey ");"); 715b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey 716b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey // Public generic data table 717b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey db.execSQL("CREATE TABLE " + Tables.DATA + " (" + 718b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey Data._ID + " INTEGER PRIMARY KEY AUTOINCREMENT," + 71967dde51ab932dc84d95a203b113989b13437f13dJeff Sharkey DataColumns.PACKAGE_ID + " INTEGER REFERENCES package(_id)," + 720b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey DataColumns.MIMETYPE_ID + " INTEGER REFERENCES mimetype(_id) NOT NULL," + 72111944a13b31aa7c98f1079697f24b3a1999ca571Dmitri Plotnikov Data.RAW_CONTACT_ID + " INTEGER REFERENCES raw_contacts(_id) NOT NULL," + 722f5b20724819e51b339ff6ba5b8eb6b444cc31452Fred Quintana Data.IS_PRIMARY + " INTEGER NOT NULL DEFAULT 0," + 723f5b20724819e51b339ff6ba5b8eb6b444cc31452Fred Quintana Data.IS_SUPER_PRIMARY + " INTEGER NOT NULL DEFAULT 0," + 724f5b20724819e51b339ff6ba5b8eb6b444cc31452Fred Quintana Data.DATA_VERSION + " INTEGER NOT NULL DEFAULT 0," + 725f5b20724819e51b339ff6ba5b8eb6b444cc31452Fred Quintana Data.DATA1 + " TEXT," + 726f5b20724819e51b339ff6ba5b8eb6b444cc31452Fred Quintana Data.DATA2 + " TEXT," + 727f5b20724819e51b339ff6ba5b8eb6b444cc31452Fred Quintana Data.DATA3 + " TEXT," + 728f5b20724819e51b339ff6ba5b8eb6b444cc31452Fred Quintana Data.DATA4 + " TEXT," + 729f5b20724819e51b339ff6ba5b8eb6b444cc31452Fred Quintana Data.DATA5 + " TEXT," + 730f5b20724819e51b339ff6ba5b8eb6b444cc31452Fred Quintana Data.DATA6 + " TEXT," + 731f5b20724819e51b339ff6ba5b8eb6b444cc31452Fred Quintana Data.DATA7 + " TEXT," + 732f5b20724819e51b339ff6ba5b8eb6b444cc31452Fred Quintana Data.DATA8 + " TEXT," + 733f5b20724819e51b339ff6ba5b8eb6b444cc31452Fred Quintana Data.DATA9 + " TEXT," + 73467dde51ab932dc84d95a203b113989b13437f13dJeff Sharkey Data.DATA10 + " TEXT," + 73567dde51ab932dc84d95a203b113989b13437f13dJeff Sharkey Data.DATA11 + " TEXT," + 73667dde51ab932dc84d95a203b113989b13437f13dJeff Sharkey Data.DATA12 + " TEXT," + 73767dde51ab932dc84d95a203b113989b13437f13dJeff Sharkey Data.DATA13 + " TEXT," + 73867dde51ab932dc84d95a203b113989b13437f13dJeff Sharkey Data.DATA14 + " TEXT," + 7393cfe8d532d509fbbe605454e3a32b2361b7e1501Dmitri Plotnikov Data.DATA15 + " TEXT," + 7403cfe8d532d509fbbe605454e3a32b2361b7e1501Dmitri Plotnikov Data.SYNC1 + " TEXT, " + 7413cfe8d532d509fbbe605454e3a32b2361b7e1501Dmitri Plotnikov Data.SYNC2 + " TEXT, " + 7423cfe8d532d509fbbe605454e3a32b2361b7e1501Dmitri Plotnikov Data.SYNC3 + " TEXT, " + 7433cfe8d532d509fbbe605454e3a32b2361b7e1501Dmitri Plotnikov Data.SYNC4 + " TEXT " + 744b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey ");"); 745b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey 74611944a13b31aa7c98f1079697f24b3a1999ca571Dmitri Plotnikov db.execSQL("CREATE INDEX data_raw_contact_id ON " + Tables.DATA + " (" + 74711944a13b31aa7c98f1079697f24b3a1999ca571Dmitri Plotnikov Data.RAW_CONTACT_ID + 74811944a13b31aa7c98f1079697f24b3a1999ca571Dmitri Plotnikov ");"); 74911944a13b31aa7c98f1079697f24b3a1999ca571Dmitri Plotnikov 75011944a13b31aa7c98f1079697f24b3a1999ca571Dmitri Plotnikov /** 75111944a13b31aa7c98f1079697f24b3a1999ca571Dmitri Plotnikov * For email lookup and similar queries. 75211944a13b31aa7c98f1079697f24b3a1999ca571Dmitri Plotnikov */ 753f23764675b35b5262a39c79aad8e9842460274b2Dmitri Plotnikov db.execSQL("CREATE INDEX data_mimetype_data1_index ON " + Tables.DATA + " (" + 75411944a13b31aa7c98f1079697f24b3a1999ca571Dmitri Plotnikov DataColumns.MIMETYPE_ID + "," + 755f23764675b35b5262a39c79aad8e9842460274b2Dmitri Plotnikov Data.DATA1 + 75611944a13b31aa7c98f1079697f24b3a1999ca571Dmitri Plotnikov ");"); 75711944a13b31aa7c98f1079697f24b3a1999ca571Dmitri Plotnikov 758f5b20724819e51b339ff6ba5b8eb6b444cc31452Fred Quintana /** 75961d61cb4d13a33c5581765fb4c0f1b3c0b2cdf4cDmitri Plotnikov * Automatically delete Data rows when a raw contact is deleted. 760f5b20724819e51b339ff6ba5b8eb6b444cc31452Fred Quintana */ 7615ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov db.execSQL("CREATE TRIGGER " + Tables.RAW_CONTACTS + "_deleted " 7625ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov + " BEFORE DELETE ON " + Tables.RAW_CONTACTS 763f5b20724819e51b339ff6ba5b8eb6b444cc31452Fred Quintana + " BEGIN " 764f5b20724819e51b339ff6ba5b8eb6b444cc31452Fred Quintana + " DELETE FROM " + Tables.DATA 765a5bfaf55790262eea97de432d9e7f313c219c066Dmitri Plotnikov + " WHERE " + Data.RAW_CONTACT_ID 766a5bfaf55790262eea97de432d9e7f313c219c066Dmitri Plotnikov + "=OLD." + RawContacts._ID + ";" 767f5b20724819e51b339ff6ba5b8eb6b444cc31452Fred Quintana + " DELETE FROM " + Tables.PHONE_LOOKUP 768a5bfaf55790262eea97de432d9e7f313c219c066Dmitri Plotnikov + " WHERE " + PhoneLookupColumns.RAW_CONTACT_ID 769a5bfaf55790262eea97de432d9e7f313c219c066Dmitri Plotnikov + "=OLD." + RawContacts._ID + ";" 770a5bfaf55790262eea97de432d9e7f313c219c066Dmitri Plotnikov + " DELETE FROM " + Tables.NAME_LOOKUP 771a5bfaf55790262eea97de432d9e7f313c219c066Dmitri Plotnikov + " WHERE " + NameLookupColumns.RAW_CONTACT_ID 772a5bfaf55790262eea97de432d9e7f313c219c066Dmitri Plotnikov + "=OLD." + RawContacts._ID + ";" 773a5bfaf55790262eea97de432d9e7f313c219c066Dmitri Plotnikov + " DELETE FROM " + Tables.AGGREGATION_EXCEPTIONS 7740c0adda32be5de3acf392ab715cff468b6b340f8Dmitri Plotnikov + " WHERE " + AggregationExceptions.RAW_CONTACT_ID1 775a5bfaf55790262eea97de432d9e7f313c219c066Dmitri Plotnikov + "=OLD." + RawContacts._ID 7760c0adda32be5de3acf392ab715cff468b6b340f8Dmitri Plotnikov + " OR " + AggregationExceptions.RAW_CONTACT_ID2 777a5bfaf55790262eea97de432d9e7f313c219c066Dmitri Plotnikov + "=OLD." + RawContacts._ID + ";" 778a5bfaf55790262eea97de432d9e7f313c219c066Dmitri Plotnikov + " DELETE FROM " + Tables.CONTACTS 779a5bfaf55790262eea97de432d9e7f313c219c066Dmitri Plotnikov + " WHERE " + Contacts._ID + "=OLD." + RawContacts.CONTACT_ID 780a5bfaf55790262eea97de432d9e7f313c219c066Dmitri Plotnikov + " AND (SELECT COUNT(*) FROM " + Tables.RAW_CONTACTS 781a5bfaf55790262eea97de432d9e7f313c219c066Dmitri Plotnikov + " WHERE " + RawContacts.CONTACT_ID + "=OLD." + RawContacts.CONTACT_ID 782a5bfaf55790262eea97de432d9e7f313c219c066Dmitri Plotnikov + " )=1;" 783f5b20724819e51b339ff6ba5b8eb6b444cc31452Fred Quintana + " END"); 784f5b20724819e51b339ff6ba5b8eb6b444cc31452Fred Quintana 78561d61cb4d13a33c5581765fb4c0f1b3c0b2cdf4cDmitri Plotnikov /** 78673776ffd5c00e94db987ee30864e9c7a8396d22dDmitri Plotnikov * Triggers that update {@link RawContacts#VERSION} when the contact is 78773776ffd5c00e94db987ee30864e9c7a8396d22dDmitri Plotnikov * marked for deletion or any time a data row is inserted, updated or 78873776ffd5c00e94db987ee30864e9c7a8396d22dDmitri Plotnikov * deleted. 78961d61cb4d13a33c5581765fb4c0f1b3c0b2cdf4cDmitri Plotnikov */ 79061d61cb4d13a33c5581765fb4c0f1b3c0b2cdf4cDmitri Plotnikov db.execSQL("CREATE TRIGGER " + Tables.RAW_CONTACTS + "_marked_deleted " 79161d61cb4d13a33c5581765fb4c0f1b3c0b2cdf4cDmitri Plotnikov + " BEFORE UPDATE ON " + Tables.RAW_CONTACTS 79261d61cb4d13a33c5581765fb4c0f1b3c0b2cdf4cDmitri Plotnikov + " BEGIN " 79361d61cb4d13a33c5581765fb4c0f1b3c0b2cdf4cDmitri Plotnikov + " UPDATE " + Tables.RAW_CONTACTS 79461d61cb4d13a33c5581765fb4c0f1b3c0b2cdf4cDmitri Plotnikov + " SET " 79573776ffd5c00e94db987ee30864e9c7a8396d22dDmitri Plotnikov + RawContacts.VERSION + "=OLD." + RawContacts.VERSION + "+1 " 79661d61cb4d13a33c5581765fb4c0f1b3c0b2cdf4cDmitri Plotnikov + " WHERE " + RawContacts._ID + "=OLD." + RawContacts._ID 79761d61cb4d13a33c5581765fb4c0f1b3c0b2cdf4cDmitri Plotnikov + " AND NEW." + RawContacts.DELETED + "!= OLD." + RawContacts.DELETED + ";" 79861d61cb4d13a33c5581765fb4c0f1b3c0b2cdf4cDmitri Plotnikov + " END"); 79961d61cb4d13a33c5581765fb4c0f1b3c0b2cdf4cDmitri Plotnikov 800c2543da57fb6c90de4fa2de90db2df7f539f0483Fred Quintana db.execSQL("CREATE TRIGGER " + Tables.DATA + "_updated BEFORE UPDATE ON " + Tables.DATA 801f5b20724819e51b339ff6ba5b8eb6b444cc31452Fred Quintana + " BEGIN " 802f5b20724819e51b339ff6ba5b8eb6b444cc31452Fred Quintana + " UPDATE " + Tables.DATA 803f5b20724819e51b339ff6ba5b8eb6b444cc31452Fred Quintana + " SET " + Data.DATA_VERSION + "=OLD." + Data.DATA_VERSION + "+1 " 804f5b20724819e51b339ff6ba5b8eb6b444cc31452Fred Quintana + " WHERE " + Data._ID + "=OLD." + Data._ID + ";" 8055ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov + " UPDATE " + Tables.RAW_CONTACTS 80673776ffd5c00e94db987ee30864e9c7a8396d22dDmitri Plotnikov + " SET " + RawContacts.VERSION + "=" + RawContacts.VERSION + "+1 " 8075ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov + " WHERE " + RawContacts._ID + "=OLD." + Data.RAW_CONTACT_ID + ";" 808f5b20724819e51b339ff6ba5b8eb6b444cc31452Fred Quintana + " END"); 809f5b20724819e51b339ff6ba5b8eb6b444cc31452Fred Quintana 810f5b20724819e51b339ff6ba5b8eb6b444cc31452Fred Quintana db.execSQL("CREATE TRIGGER " + Tables.DATA + "_deleted BEFORE DELETE ON " + Tables.DATA 811f5b20724819e51b339ff6ba5b8eb6b444cc31452Fred Quintana + " BEGIN " 8125ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov + " UPDATE " + Tables.RAW_CONTACTS 81373776ffd5c00e94db987ee30864e9c7a8396d22dDmitri Plotnikov + " SET " + RawContacts.VERSION + "=" + RawContacts.VERSION + "+1 " 8145ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov + " WHERE " + RawContacts._ID + "=OLD." + Data.RAW_CONTACT_ID + ";" 815f5b20724819e51b339ff6ba5b8eb6b444cc31452Fred Quintana + " DELETE FROM " + Tables.PHONE_LOOKUP 816f5b20724819e51b339ff6ba5b8eb6b444cc31452Fred Quintana + " WHERE " + PhoneLookupColumns.DATA_ID + "=OLD." + Data._ID + ";" 817f5b20724819e51b339ff6ba5b8eb6b444cc31452Fred Quintana + " END"); 818f5b20724819e51b339ff6ba5b8eb6b444cc31452Fred Quintana 819b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey // Private phone numbers table used for lookup 820b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey db.execSQL("CREATE TABLE " + Tables.PHONE_LOOKUP + " (" + 821f79538095a1af16dcd6e641448b627f60f197802Dmitri Plotnikov PhoneLookupColumns.DATA_ID 822f79538095a1af16dcd6e641448b627f60f197802Dmitri Plotnikov + " INTEGER PRIMARY KEY REFERENCES data(_id) NOT NULL," + 8235ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov PhoneLookupColumns.RAW_CONTACT_ID 8245ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov + " INTEGER REFERENCES raw_contacts(_id) NOT NULL," + 825b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey PhoneLookupColumns.NORMALIZED_NUMBER + " TEXT NOT NULL" + 826b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey ");"); 827b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey 828b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey db.execSQL("CREATE INDEX phone_lookup_index ON " + Tables.PHONE_LOOKUP + " (" + 829f79538095a1af16dcd6e641448b627f60f197802Dmitri Plotnikov PhoneLookupColumns.NORMALIZED_NUMBER + "," + 830f79538095a1af16dcd6e641448b627f60f197802Dmitri Plotnikov PhoneLookupColumns.RAW_CONTACT_ID + "," + 831b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey PhoneLookupColumns.DATA_ID + 832b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey ");"); 833b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey 834a8dc456684a104c7e5547ba17d44f952022cd8c5Dmitri Plotnikov // Private name/nickname table used for lookup 835a8dc456684a104c7e5547ba17d44f952022cd8c5Dmitri Plotnikov db.execSQL("CREATE TABLE " + Tables.NAME_LOOKUP + " (" + 83614bba94bbe0f2e215ad7b3b9417754a1ba0d95bfDmitri Plotnikov NameLookupColumns.DATA_ID 83714bba94bbe0f2e215ad7b3b9417754a1ba0d95bfDmitri Plotnikov + " INTEGER REFERENCES data(_id) NOT NULL," + 8385ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov NameLookupColumns.RAW_CONTACT_ID 8395ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov + " INTEGER REFERENCES raw_contacts(_id) NOT NULL," + 84011944a13b31aa7c98f1079697f24b3a1999ca571Dmitri Plotnikov NameLookupColumns.NORMALIZED_NAME + " TEXT NOT NULL," + 84111944a13b31aa7c98f1079697f24b3a1999ca571Dmitri Plotnikov NameLookupColumns.NAME_TYPE + " INTEGER NOT NULL," + 84214bba94bbe0f2e215ad7b3b9417754a1ba0d95bfDmitri Plotnikov "PRIMARY KEY (" 84314bba94bbe0f2e215ad7b3b9417754a1ba0d95bfDmitri Plotnikov + NameLookupColumns.DATA_ID + ", " 84411944a13b31aa7c98f1079697f24b3a1999ca571Dmitri Plotnikov + NameLookupColumns.NORMALIZED_NAME + ", " 84511944a13b31aa7c98f1079697f24b3a1999ca571Dmitri Plotnikov + NameLookupColumns.NAME_TYPE + ")" + 846a8dc456684a104c7e5547ba17d44f952022cd8c5Dmitri Plotnikov ");"); 847a8dc456684a104c7e5547ba17d44f952022cd8c5Dmitri Plotnikov 848a8dc456684a104c7e5547ba17d44f952022cd8c5Dmitri Plotnikov db.execSQL("CREATE INDEX name_lookup_index ON " + Tables.NAME_LOOKUP + " (" + 849f79538095a1af16dcd6e641448b627f60f197802Dmitri Plotnikov NameLookupColumns.NORMALIZED_NAME + "," + 850f79538095a1af16dcd6e641448b627f60f197802Dmitri Plotnikov NameLookupColumns.NAME_TYPE + ", " + 8515ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov NameLookupColumns.RAW_CONTACT_ID + 852a8dc456684a104c7e5547ba17d44f952022cd8c5Dmitri Plotnikov ");"); 853a8dc456684a104c7e5547ba17d44f952022cd8c5Dmitri Plotnikov 85414bba94bbe0f2e215ad7b3b9417754a1ba0d95bfDmitri Plotnikov db.execSQL("CREATE INDEX name_lookup_raw_contact_id_index ON " + Tables.NAME_LOOKUP + " (" + 85514bba94bbe0f2e215ad7b3b9417754a1ba0d95bfDmitri Plotnikov NameLookupColumns.RAW_CONTACT_ID + 85614bba94bbe0f2e215ad7b3b9417754a1ba0d95bfDmitri Plotnikov ");"); 85714bba94bbe0f2e215ad7b3b9417754a1ba0d95bfDmitri Plotnikov 858b597adb79f1f57a24be2be09e3f45fa0f04f6f8fDmitri Plotnikov db.execSQL("CREATE TABLE " + Tables.NICKNAME_LOOKUP + " (" + 859b597adb79f1f57a24be2be09e3f45fa0f04f6f8fDmitri Plotnikov NicknameLookupColumns.NAME + " TEXT," + 860b597adb79f1f57a24be2be09e3f45fa0f04f6f8fDmitri Plotnikov NicknameLookupColumns.CLUSTER + " TEXT" + 861b597adb79f1f57a24be2be09e3f45fa0f04f6f8fDmitri Plotnikov ");"); 862b597adb79f1f57a24be2be09e3f45fa0f04f6f8fDmitri Plotnikov 863b597adb79f1f57a24be2be09e3f45fa0f04f6f8fDmitri Plotnikov db.execSQL("CREATE UNIQUE INDEX nickname_lookup_index ON " + Tables.NICKNAME_LOOKUP + " (" + 864b597adb79f1f57a24be2be09e3f45fa0f04f6f8fDmitri Plotnikov NicknameLookupColumns.NAME + ", " + 865b597adb79f1f57a24be2be09e3f45fa0f04f6f8fDmitri Plotnikov NicknameLookupColumns.CLUSTER + 866b597adb79f1f57a24be2be09e3f45fa0f04f6f8fDmitri Plotnikov ");"); 867b597adb79f1f57a24be2be09e3f45fa0f04f6f8fDmitri Plotnikov 868ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey // Groups table 869ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey db.execSQL("CREATE TABLE " + Tables.GROUPS + " (" + 870ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey Groups._ID + " INTEGER PRIMARY KEY AUTOINCREMENT," + 87167dde51ab932dc84d95a203b113989b13437f13dJeff Sharkey GroupsColumns.PACKAGE_ID + " INTEGER REFERENCES package(_id)," + 872035b4cc204be2641079a0b04e9ee9791a8f8248bFred Quintana Groups.ACCOUNT_NAME + " STRING DEFAULT NULL, " + 873035b4cc204be2641079a0b04e9ee9791a8f8248bFred Quintana Groups.ACCOUNT_TYPE + " STRING DEFAULT NULL, " + 874ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey Groups.SOURCE_ID + " TEXT," + 8759261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana Groups.VERSION + " INTEGER NOT NULL DEFAULT 1," + 87673776ffd5c00e94db987ee30864e9c7a8396d22dDmitri Plotnikov Groups.DIRTY + " INTEGER NOT NULL DEFAULT 0," + 877ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey Groups.TITLE + " TEXT," + 87867dde51ab932dc84d95a203b113989b13437f13dJeff Sharkey Groups.TITLE_RES + " INTEGER," + 8790f8f3b3e4a6ad18c5868d0215cc137845a2ddc74Dmitri Plotnikov Groups.NOTES + " TEXT," + 8800f8f3b3e4a6ad18c5868d0215cc137845a2ddc74Dmitri Plotnikov Groups.SYSTEM_ID + " TEXT," + 88194021b213e4db367f60b30fcbfe9019e28571784Fred Quintana Groups.DELETED + " INTEGER NOT NULL DEFAULT 0," + 882eb9ffdccfa19f5b2f22e688f733fd77e39605f9eJeff Sharkey Groups.GROUP_VISIBLE + " INTEGER NOT NULL DEFAULT 0," + 883ea547d55f864133861b2db44221ae0c2ac6c1a68Fred Quintana Groups.SHOULD_SYNC + " INTEGER NOT NULL DEFAULT 1," + 8843cfe8d532d509fbbe605454e3a32b2361b7e1501Dmitri Plotnikov Groups.SYNC1 + " TEXT, " + 8853cfe8d532d509fbbe605454e3a32b2361b7e1501Dmitri Plotnikov Groups.SYNC2 + " TEXT, " + 8863cfe8d532d509fbbe605454e3a32b2361b7e1501Dmitri Plotnikov Groups.SYNC3 + " TEXT, " + 8873cfe8d532d509fbbe605454e3a32b2361b7e1501Dmitri Plotnikov Groups.SYNC4 + " TEXT " + 888ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey ");"); 889ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey 8905f515d93c04729e6cdc9b704d18579162d71d5f2Dmitri Plotnikov db.execSQL("CREATE INDEX groups_source_id_index ON " + Tables.GROUPS + " (" + 8915f515d93c04729e6cdc9b704d18579162d71d5f2Dmitri Plotnikov Groups.SOURCE_ID + ", " + 8925f515d93c04729e6cdc9b704d18579162d71d5f2Dmitri Plotnikov Groups.ACCOUNT_TYPE + ", " + 8935f515d93c04729e6cdc9b704d18579162d71d5f2Dmitri Plotnikov Groups.ACCOUNT_NAME + 8945f515d93c04729e6cdc9b704d18579162d71d5f2Dmitri Plotnikov ");"); 8955f515d93c04729e6cdc9b704d18579162d71d5f2Dmitri Plotnikov 8969261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana db.execSQL("CREATE TRIGGER " + Tables.GROUPS + "_updated1 " 8979261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana + " BEFORE UPDATE ON " + Tables.GROUPS 8989261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana + " BEGIN " 8999261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana + " UPDATE " + Tables.GROUPS 9009261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana + " SET " 90173776ffd5c00e94db987ee30864e9c7a8396d22dDmitri Plotnikov + Groups.VERSION + "=OLD." + Groups.VERSION + "+1" 9029261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana + " WHERE " + Groups._ID + "=OLD." + Groups._ID + ";" 9039261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana + " END"); 9049261b2141aa90a4fed632fd6da03026d4c216280Fred Quintana 905b174c7ccd337a7bea6269139c9b09acc69ae40c1Dmitri Plotnikov db.execSQL("CREATE TABLE IF NOT EXISTS " + Tables.AGGREGATION_EXCEPTIONS + " (" + 906b174c7ccd337a7bea6269139c9b09acc69ae40c1Dmitri Plotnikov AggregationExceptionColumns._ID + " INTEGER PRIMARY KEY AUTOINCREMENT," + 907b174c7ccd337a7bea6269139c9b09acc69ae40c1Dmitri Plotnikov AggregationExceptions.TYPE + " INTEGER NOT NULL, " + 9080c0adda32be5de3acf392ab715cff468b6b340f8Dmitri Plotnikov AggregationExceptions.RAW_CONTACT_ID1 9095ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov + " INTEGER REFERENCES raw_contacts(_id), " + 9100c0adda32be5de3acf392ab715cff468b6b340f8Dmitri Plotnikov AggregationExceptions.RAW_CONTACT_ID2 9115ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov + " INTEGER REFERENCES raw_contacts(_id)" + 912b0160a0bcf6d59eaa43fd501e124b95f873e0157Marc Blank ");"); 913b174c7ccd337a7bea6269139c9b09acc69ae40c1Dmitri Plotnikov 914b174c7ccd337a7bea6269139c9b09acc69ae40c1Dmitri Plotnikov db.execSQL("CREATE UNIQUE INDEX IF NOT EXISTS aggregation_exception_index1 ON " + 915b174c7ccd337a7bea6269139c9b09acc69ae40c1Dmitri Plotnikov Tables.AGGREGATION_EXCEPTIONS + " (" + 9160c0adda32be5de3acf392ab715cff468b6b340f8Dmitri Plotnikov AggregationExceptions.RAW_CONTACT_ID1 + ", " + 9170c0adda32be5de3acf392ab715cff468b6b340f8Dmitri Plotnikov AggregationExceptions.RAW_CONTACT_ID2 + 918b174c7ccd337a7bea6269139c9b09acc69ae40c1Dmitri Plotnikov ");"); 919b174c7ccd337a7bea6269139c9b09acc69ae40c1Dmitri Plotnikov 920b174c7ccd337a7bea6269139c9b09acc69ae40c1Dmitri Plotnikov db.execSQL("CREATE UNIQUE INDEX IF NOT EXISTS aggregation_exception_index2 ON " + 921b174c7ccd337a7bea6269139c9b09acc69ae40c1Dmitri Plotnikov Tables.AGGREGATION_EXCEPTIONS + " (" + 9220c0adda32be5de3acf392ab715cff468b6b340f8Dmitri Plotnikov AggregationExceptions.RAW_CONTACT_ID2 + ", " + 9230c0adda32be5de3acf392ab715cff468b6b340f8Dmitri Plotnikov AggregationExceptions.RAW_CONTACT_ID1 + 924b174c7ccd337a7bea6269139c9b09acc69ae40c1Dmitri Plotnikov ");"); 925b174c7ccd337a7bea6269139c9b09acc69ae40c1Dmitri Plotnikov 926eb9ffdccfa19f5b2f22e688f733fd77e39605f9eJeff Sharkey db.execSQL("CREATE TABLE IF NOT EXISTS " + Tables.SETTINGS + " (" + 927eb9ffdccfa19f5b2f22e688f733fd77e39605f9eJeff Sharkey Settings.ACCOUNT_NAME + " STRING NOT NULL," + 928eb9ffdccfa19f5b2f22e688f733fd77e39605f9eJeff Sharkey Settings.ACCOUNT_TYPE + " STRING NOT NULL," + 929eb9ffdccfa19f5b2f22e688f733fd77e39605f9eJeff Sharkey Settings.UNGROUPED_VISIBLE + " INTEGER NOT NULL DEFAULT 0," + 930eb9ffdccfa19f5b2f22e688f733fd77e39605f9eJeff Sharkey Settings.SHOULD_SYNC + " INTEGER NOT NULL DEFAULT 1, " + 931eb9ffdccfa19f5b2f22e688f733fd77e39605f9eJeff Sharkey "PRIMARY KEY (" + Settings.ACCOUNT_NAME + ", " + 932e07913c61c320b0cc2036db3b714e39534d8cd7aJeff Sharkey Settings.ACCOUNT_TYPE + ") ON CONFLICT REPLACE" + 933eb9ffdccfa19f5b2f22e688f733fd77e39605f9eJeff Sharkey ");"); 934eb9ffdccfa19f5b2f22e688f733fd77e39605f9eJeff Sharkey 935e99988b266dd1263162583e81e2b408e7329b1c8Dmitri Plotnikov // The table for recent calls is here so we can do table joins 936e99988b266dd1263162583e81e2b408e7329b1c8Dmitri Plotnikov // on people, phones, and calls all in one place. 937e99988b266dd1263162583e81e2b408e7329b1c8Dmitri Plotnikov db.execSQL("CREATE TABLE " + Tables.CALLS + " (" + 938e99988b266dd1263162583e81e2b408e7329b1c8Dmitri Plotnikov Calls._ID + " INTEGER PRIMARY KEY AUTOINCREMENT," + 939e99988b266dd1263162583e81e2b408e7329b1c8Dmitri Plotnikov Calls.NUMBER + " TEXT," + 940e99988b266dd1263162583e81e2b408e7329b1c8Dmitri Plotnikov Calls.DATE + " INTEGER," + 941e99988b266dd1263162583e81e2b408e7329b1c8Dmitri Plotnikov Calls.DURATION + " INTEGER," + 942e99988b266dd1263162583e81e2b408e7329b1c8Dmitri Plotnikov Calls.TYPE + " INTEGER," + 943e99988b266dd1263162583e81e2b408e7329b1c8Dmitri Plotnikov Calls.NEW + " INTEGER," + 944e99988b266dd1263162583e81e2b408e7329b1c8Dmitri Plotnikov Calls.CACHED_NAME + " TEXT," + 945e99988b266dd1263162583e81e2b408e7329b1c8Dmitri Plotnikov Calls.CACHED_NUMBER_TYPE + " INTEGER," + 946e99988b266dd1263162583e81e2b408e7329b1c8Dmitri Plotnikov Calls.CACHED_NUMBER_LABEL + " TEXT" + 947e99988b266dd1263162583e81e2b408e7329b1c8Dmitri Plotnikov ");"); 948e99988b266dd1263162583e81e2b408e7329b1c8Dmitri Plotnikov 949b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey // Activities table 950b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey db.execSQL("CREATE TABLE " + Tables.ACTIVITIES + " (" + 951b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey Activities._ID + " INTEGER PRIMARY KEY AUTOINCREMENT," + 95267dde51ab932dc84d95a203b113989b13437f13dJeff Sharkey ActivitiesColumns.PACKAGE_ID + " INTEGER REFERENCES package(_id)," + 953b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey ActivitiesColumns.MIMETYPE_ID + " INTEGER REFERENCES mimetype(_id) NOT NULL," + 954b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey Activities.RAW_ID + " TEXT," + 955499791a4f9ab29fa94ff48dd7acff55b2ac089a7Dmitri Plotnikov Activities.IN_REPLY_TO + " TEXT," + 9565ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov Activities.AUTHOR_CONTACT_ID + " INTEGER REFERENCES raw_contacts(_id)," + 9575ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov Activities.TARGET_CONTACT_ID + " INTEGER REFERENCES raw_contacts(_id)," + 958b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey Activities.PUBLISHED + " INTEGER NOT NULL," + 959499791a4f9ab29fa94ff48dd7acff55b2ac089a7Dmitri Plotnikov Activities.THREAD_PUBLISHED + " INTEGER NOT NULL," + 960b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey Activities.TITLE + " TEXT NOT NULL," + 961b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey Activities.SUMMARY + " TEXT," + 962adb55c2d8295d300961d86a3605c8ddc469cd4a2Dmitri Plotnikov Activities.LINK + " TEXT, " + 963b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey Activities.THUMBNAIL + " BLOB" + 964b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey ");"); 965b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey 966a23cd5b6f478f6c9dda54173e84bd0098b9f3364Dmitri Plotnikov db.execSQL("CREATE TABLE " + Tables.STATUS_UPDATES + " (" + 967a23cd5b6f478f6c9dda54173e84bd0098b9f3364Dmitri Plotnikov StatusUpdatesColumns.DATA_ID + " INTEGER PRIMARY KEY REFERENCES data(_id)," + 9680a185cdcb65d1beb2a295fffbe2ae11a6a2c097fDmitri Plotnikov StatusUpdates.STATUS + " TEXT," + 9690a185cdcb65d1beb2a295fffbe2ae11a6a2c097fDmitri Plotnikov StatusUpdates.STATUS_TIMESTAMP + " INTEGER," + 9700a185cdcb65d1beb2a295fffbe2ae11a6a2c097fDmitri Plotnikov StatusUpdates.STATUS_RES_PACKAGE + " TEXT, " + 9710a185cdcb65d1beb2a295fffbe2ae11a6a2c097fDmitri Plotnikov StatusUpdates.STATUS_LABEL + " INTEGER, " + 9720a185cdcb65d1beb2a295fffbe2ae11a6a2c097fDmitri Plotnikov StatusUpdates.STATUS_ICON + " INTEGER" + 973a23cd5b6f478f6c9dda54173e84bd0098b9f3364Dmitri Plotnikov ");"); 974a23cd5b6f478f6c9dda54173e84bd0098b9f3364Dmitri Plotnikov 975d237c80845d8e13164d34278d3c20e31f8d80b4dDaisuke Miyakawa String contactEntitiesSelect = "SELECT " 976226c3dc6e93ca76a84c99100caa31045cba06cf6Fred Quintana + RawContactsColumns.CONCRETE_ACCOUNT_NAME + " AS " + RawContacts.ACCOUNT_NAME + "," 977226c3dc6e93ca76a84c99100caa31045cba06cf6Fred Quintana + RawContactsColumns.CONCRETE_ACCOUNT_TYPE + " AS " + RawContacts.ACCOUNT_TYPE + "," 978226c3dc6e93ca76a84c99100caa31045cba06cf6Fred Quintana + RawContactsColumns.CONCRETE_SOURCE_ID + " AS " + RawContacts.SOURCE_ID + "," 979226c3dc6e93ca76a84c99100caa31045cba06cf6Fred Quintana + RawContactsColumns.CONCRETE_VERSION + " AS " + RawContacts.VERSION + "," 980226c3dc6e93ca76a84c99100caa31045cba06cf6Fred Quintana + RawContactsColumns.CONCRETE_DIRTY + " AS " + RawContacts.DIRTY + "," 98194021b213e4db367f60b30fcbfe9019e28571784Fred Quintana + RawContactsColumns.CONCRETE_DELETED + " AS " + RawContacts.DELETED + "," 982226c3dc6e93ca76a84c99100caa31045cba06cf6Fred Quintana + PackagesColumns.PACKAGE + " AS " + Data.RES_PACKAGE + "," 983e7c19a079df0ba9be2fbba494ba6efd838658f78Fred Quintana + RawContacts.CONTACT_ID + ", " 9847a4550f2afb24b2112b6c937f416c6f46ece35f4Fred Quintana + RawContactsColumns.CONCRETE_SYNC1 + " AS " + RawContacts.SYNC1 + ", " 9857a4550f2afb24b2112b6c937f416c6f46ece35f4Fred Quintana + RawContactsColumns.CONCRETE_SYNC2 + " AS " + RawContacts.SYNC2 + ", " 9867a4550f2afb24b2112b6c937f416c6f46ece35f4Fred Quintana + RawContactsColumns.CONCRETE_SYNC3 + " AS " + RawContacts.SYNC3 + ", " 9877a4550f2afb24b2112b6c937f416c6f46ece35f4Fred Quintana + RawContactsColumns.CONCRETE_SYNC4 + " AS " + RawContacts.SYNC4 + ", " 988226c3dc6e93ca76a84c99100caa31045cba06cf6Fred Quintana + Data.MIMETYPE + ", " 989226c3dc6e93ca76a84c99100caa31045cba06cf6Fred Quintana + Data.DATA1 + ", " 990226c3dc6e93ca76a84c99100caa31045cba06cf6Fred Quintana + Data.DATA2 + ", " 991226c3dc6e93ca76a84c99100caa31045cba06cf6Fred Quintana + Data.DATA3 + ", " 992226c3dc6e93ca76a84c99100caa31045cba06cf6Fred Quintana + Data.DATA4 + ", " 993226c3dc6e93ca76a84c99100caa31045cba06cf6Fred Quintana + Data.DATA5 + ", " 994226c3dc6e93ca76a84c99100caa31045cba06cf6Fred Quintana + Data.DATA6 + ", " 995226c3dc6e93ca76a84c99100caa31045cba06cf6Fred Quintana + Data.DATA7 + ", " 996226c3dc6e93ca76a84c99100caa31045cba06cf6Fred Quintana + Data.DATA8 + ", " 997226c3dc6e93ca76a84c99100caa31045cba06cf6Fred Quintana + Data.DATA9 + ", " 998226c3dc6e93ca76a84c99100caa31045cba06cf6Fred Quintana + Data.DATA10 + ", " 999226c3dc6e93ca76a84c99100caa31045cba06cf6Fred Quintana + Data.DATA11 + ", " 1000226c3dc6e93ca76a84c99100caa31045cba06cf6Fred Quintana + Data.DATA12 + ", " 1001226c3dc6e93ca76a84c99100caa31045cba06cf6Fred Quintana + Data.DATA13 + ", " 1002226c3dc6e93ca76a84c99100caa31045cba06cf6Fred Quintana + Data.DATA14 + ", " 1003226c3dc6e93ca76a84c99100caa31045cba06cf6Fred Quintana + Data.DATA15 + ", " 10047a4550f2afb24b2112b6c937f416c6f46ece35f4Fred Quintana + Data.SYNC1 + ", " 10057a4550f2afb24b2112b6c937f416c6f46ece35f4Fred Quintana + Data.SYNC2 + ", " 10067a4550f2afb24b2112b6c937f416c6f46ece35f4Fred Quintana + Data.SYNC3 + ", " 10077a4550f2afb24b2112b6c937f416c6f46ece35f4Fred Quintana + Data.SYNC4 + ", " 10082b6b4cdd4e715029f3e8d9e78a6a24abd5b78ba2Fred Quintana + RawContactsColumns.CONCRETE_ID + " AS " + Data.RAW_CONTACT_ID + ", " 1009226c3dc6e93ca76a84c99100caa31045cba06cf6Fred Quintana + Data.IS_PRIMARY + ", " 10103cb415e7b97c3e318d7a16aaf7cc5c6b825d349aEvan Millar + Data.IS_SUPER_PRIMARY + ", " 1011226c3dc6e93ca76a84c99100caa31045cba06cf6Fred Quintana + Data.DATA_VERSION + ", " 1012226c3dc6e93ca76a84c99100caa31045cba06cf6Fred Quintana + DataColumns.CONCRETE_ID + " AS " + RawContacts._ID + "," 1013c76d0a78fe2d3471195cfa555bab016eec154f07Jeff Sharkey + RawContactsColumns.CONCRETE_STARRED + " AS " + RawContacts.STARRED + "," 1014226c3dc6e93ca76a84c99100caa31045cba06cf6Fred Quintana + Tables.GROUPS + "." + Groups.SOURCE_ID + " AS " + GroupMembership.GROUP_SOURCE_ID 10152b6b4cdd4e715029f3e8d9e78a6a24abd5b78ba2Fred Quintana + " FROM " + Tables.RAW_CONTACTS 10162b6b4cdd4e715029f3e8d9e78a6a24abd5b78ba2Fred Quintana + " LEFT OUTER JOIN " + Tables.DATA + " ON (" 10172b6b4cdd4e715029f3e8d9e78a6a24abd5b78ba2Fred Quintana + DataColumns.CONCRETE_RAW_CONTACT_ID + "=" + RawContactsColumns.CONCRETE_ID + ")" 1018226c3dc6e93ca76a84c99100caa31045cba06cf6Fred Quintana + " LEFT OUTER JOIN " + Tables.PACKAGES + " ON (" 1019226c3dc6e93ca76a84c99100caa31045cba06cf6Fred Quintana + DataColumns.CONCRETE_PACKAGE_ID + "=" + PackagesColumns.CONCRETE_ID + ")" 1020226c3dc6e93ca76a84c99100caa31045cba06cf6Fred Quintana + " LEFT OUTER JOIN " + Tables.MIMETYPES + " ON (" 1021226c3dc6e93ca76a84c99100caa31045cba06cf6Fred Quintana + DataColumns.CONCRETE_MIMETYPE_ID + "=" + MimetypesColumns.CONCRETE_ID + ")" 1022226c3dc6e93ca76a84c99100caa31045cba06cf6Fred Quintana + " LEFT OUTER JOIN " + Tables.GROUPS + " ON (" 1023226c3dc6e93ca76a84c99100caa31045cba06cf6Fred Quintana + MimetypesColumns.CONCRETE_MIMETYPE + "='" + GroupMembership.CONTENT_ITEM_TYPE 1024f23764675b35b5262a39c79aad8e9842460274b2Dmitri Plotnikov + "' AND " + GroupsColumns.CONCRETE_ID + "=" 1025d237c80845d8e13164d34278d3c20e31f8d80b4dDaisuke Miyakawa + Tables.DATA + "." + GroupMembership.GROUP_ROW_ID + ")"; 1026226c3dc6e93ca76a84c99100caa31045cba06cf6Fred Quintana 1027d237c80845d8e13164d34278d3c20e31f8d80b4dDaisuke Miyakawa db.execSQL("CREATE VIEW " + Tables.CONTACT_ENTITIES + " AS " 1028d237c80845d8e13164d34278d3c20e31f8d80b4dDaisuke Miyakawa + contactEntitiesSelect); 1029d237c80845d8e13164d34278d3c20e31f8d80b4dDaisuke Miyakawa db.execSQL("CREATE VIEW " + Tables.CONTACT_ENTITIES_RESTRICTED + " AS " 1030d237c80845d8e13164d34278d3c20e31f8d80b4dDaisuke Miyakawa + contactEntitiesSelect + " WHERE " + RawContacts.IS_RESTRICTED + "=0"); 10314a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov 10324a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov String dataColumns = 10334a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov Data.IS_PRIMARY + ", " 10344a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + Data.IS_SUPER_PRIMARY + ", " 10354a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + Data.DATA_VERSION + ", " 10364a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + PackagesColumns.PACKAGE + " AS " + Data.RES_PACKAGE + "," 10374a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + MimetypesColumns.MIMETYPE + " AS " + Data.MIMETYPE + ", " 10384a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + Data.DATA1 + ", " 10394a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + Data.DATA2 + ", " 10404a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + Data.DATA3 + ", " 10414a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + Data.DATA4 + ", " 10424a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + Data.DATA5 + ", " 10434a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + Data.DATA6 + ", " 10444a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + Data.DATA7 + ", " 10454a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + Data.DATA8 + ", " 10464a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + Data.DATA9 + ", " 10474a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + Data.DATA10 + ", " 10484a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + Data.DATA11 + ", " 10494a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + Data.DATA12 + ", " 10504a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + Data.DATA13 + ", " 10514a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + Data.DATA14 + ", " 10524a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + Data.DATA15 + ", " 10534a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + Data.SYNC1 + ", " 10544a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + Data.SYNC2 + ", " 10554a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + Data.SYNC3 + ", " 10564a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + Data.SYNC4; 10574a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov 10584a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov String syncColumns = 10594a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov RawContactsColumns.CONCRETE_ACCOUNT_NAME + " AS " + RawContacts.ACCOUNT_NAME + "," 10604a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + RawContactsColumns.CONCRETE_ACCOUNT_TYPE + " AS " + RawContacts.ACCOUNT_TYPE + "," 10614a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + RawContactsColumns.CONCRETE_SOURCE_ID + " AS " + RawContacts.SOURCE_ID + "," 10624a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + RawContactsColumns.CONCRETE_VERSION + " AS " + RawContacts.VERSION + "," 10634a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + RawContactsColumns.CONCRETE_DIRTY + " AS " + RawContacts.DIRTY + "," 10644a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + RawContactsColumns.CONCRETE_SYNC1 + " AS " + RawContacts.SYNC1 + "," 10654a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + RawContactsColumns.CONCRETE_SYNC2 + " AS " + RawContacts.SYNC2 + "," 10664a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + RawContactsColumns.CONCRETE_SYNC3 + " AS " + RawContacts.SYNC3 + "," 10674a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + RawContactsColumns.CONCRETE_SYNC4 + " AS " + RawContacts.SYNC4; 10684a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov 10694a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov String contactOptionColumns = 10704a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov ContactsColumns.CONCRETE_CUSTOM_RINGTONE 10714a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + " AS " + RawContacts.CUSTOM_RINGTONE + "," 10724a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + ContactsColumns.CONCRETE_SEND_TO_VOICEMAIL 10734a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + " AS " + RawContacts.SEND_TO_VOICEMAIL + "," 10744a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + ContactsColumns.CONCRETE_LAST_TIME_CONTACTED 10754a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + " AS " + RawContacts.LAST_TIME_CONTACTED + "," 10764a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + ContactsColumns.CONCRETE_TIMES_CONTACTED 10774a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + " AS " + RawContacts.TIMES_CONTACTED + "," 10784a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + ContactsColumns.CONCRETE_STARRED 10794a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + " AS " + RawContacts.STARRED; 10804a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov 10814a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov String dataSelect = "SELECT " 10824a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + DataColumns.CONCRETE_ID + " AS " + Data._ID + "," 10834a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + Data.RAW_CONTACT_ID + ", " 10844a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + RawContacts.CONTACT_ID + ", " 10854a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + syncColumns + ", " 10864a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + dataColumns + ", " 10874a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + contactOptionColumns + ", " 10884a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + ContactsColumns.CONCRETE_DISPLAY_NAME + " AS " + Contacts.DISPLAY_NAME + ", " 10895870f2dcc2ac7715b2c078a886ee346622e7887eDmitri Plotnikov + Contacts.LOOKUP_KEY + ", " 10904a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + Contacts.PHOTO_ID + ", " 1091a23cd5b6f478f6c9dda54173e84bd0098b9f3364Dmitri Plotnikov + ContactsColumns.LAST_STATUS_UPDATE_ID + ", " 10924a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + Tables.GROUPS + "." + Groups.SOURCE_ID + " AS " + GroupMembership.GROUP_SOURCE_ID 10934a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + " FROM " + Tables.DATA 10944a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + " LEFT OUTER JOIN " + Tables.PACKAGES + " ON (" 10954a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + DataColumns.CONCRETE_PACKAGE_ID + "=" + PackagesColumns.CONCRETE_ID + ")" 10964a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + " LEFT OUTER JOIN " + Tables.MIMETYPES + " ON (" 10974a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + DataColumns.CONCRETE_MIMETYPE_ID + "=" + MimetypesColumns.CONCRETE_ID + ")" 10984a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + " LEFT OUTER JOIN " + Tables.RAW_CONTACTS + " ON (" 10994a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + DataColumns.CONCRETE_RAW_CONTACT_ID + "=" + RawContactsColumns.CONCRETE_ID + ")" 11004a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + " LEFT OUTER JOIN " + Tables.GROUPS + " ON (" 11014a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + MimetypesColumns.CONCRETE_MIMETYPE + "='" + GroupMembership.CONTENT_ITEM_TYPE 1102f23764675b35b5262a39c79aad8e9842460274b2Dmitri Plotnikov + "' AND " + GroupsColumns.CONCRETE_ID + "=" 1103f23764675b35b5262a39c79aad8e9842460274b2Dmitri Plotnikov + Tables.DATA + "." + GroupMembership.GROUP_ROW_ID + ")" 11044a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + " LEFT OUTER JOIN " + Tables.CONTACTS + " ON (" 11054a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + RawContacts.CONTACT_ID + "=" + Tables.CONTACTS + "." + Contacts._ID + ")"; 11064a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov 11074a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov db.execSQL("CREATE VIEW " + Views.DATA_ALL + " AS " + dataSelect); 11084a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov db.execSQL("CREATE VIEW " + Views.DATA_RESTRICTED + " AS " + dataSelect + " WHERE " 11094a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + RawContacts.IS_RESTRICTED + "=0"); 11104a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov 11114a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov String rawContactOptionColumns = 11124a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov RawContacts.CUSTOM_RINGTONE + "," 11134a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + RawContacts.SEND_TO_VOICEMAIL + "," 11144a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + RawContacts.LAST_TIME_CONTACTED + "," 11154a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + RawContacts.TIMES_CONTACTED + "," 11164a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + RawContacts.STARRED; 11174a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov 11184a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov String rawContactsSelect = "SELECT " 11194a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + RawContactsColumns.CONCRETE_ID + " AS " + RawContacts._ID + "," 11204a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + RawContacts.CONTACT_ID + ", " 11214a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + RawContacts.AGGREGATION_MODE + ", " 11224a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + RawContacts.DELETED + ", " 11234a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + rawContactOptionColumns + ", " 11244a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + syncColumns 11254a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + " FROM " + Tables.RAW_CONTACTS; 11264a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov 11274a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov db.execSQL("CREATE VIEW " + Views.RAW_CONTACTS_ALL + " AS " + rawContactsSelect); 11284a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov db.execSQL("CREATE VIEW " + Views.RAW_CONTACTS_RESTRICTED + " AS " + rawContactsSelect 11294a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + " WHERE " + RawContacts.IS_RESTRICTED + "=0"); 11304a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov 11314a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov String contactsColumns = 11324a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov ContactsColumns.CONCRETE_CUSTOM_RINGTONE 11334a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + " AS " + Contacts.CUSTOM_RINGTONE + ", " 11344a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + ContactsColumns.CONCRETE_DISPLAY_NAME 11354a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + " AS " + Contacts.DISPLAY_NAME + ", " 11364a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + Contacts.IN_VISIBLE_GROUP + ", " 1137f992bfab334b760d36a053fc0b439382dcfb51adDmitri Plotnikov + Contacts.HAS_PHONE_NUMBER + ", " 11385870f2dcc2ac7715b2c078a886ee346622e7887eDmitri Plotnikov + Contacts.LOOKUP_KEY + ", " 11395870f2dcc2ac7715b2c078a886ee346622e7887eDmitri Plotnikov + Contacts.PHOTO_ID + ", " 11404a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + ContactsColumns.CONCRETE_LAST_TIME_CONTACTED 11414a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + " AS " + Contacts.LAST_TIME_CONTACTED + ", " 11424a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + ContactsColumns.CONCRETE_SEND_TO_VOICEMAIL 11434a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + " AS " + Contacts.SEND_TO_VOICEMAIL + ", " 11444a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + ContactsColumns.CONCRETE_STARRED 11454a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + " AS " + Contacts.STARRED + ", " 11464a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + ContactsColumns.CONCRETE_TIMES_CONTACTED 1147a23cd5b6f478f6c9dda54173e84bd0098b9f3364Dmitri Plotnikov + " AS " + Contacts.TIMES_CONTACTED + ", " 1148a23cd5b6f478f6c9dda54173e84bd0098b9f3364Dmitri Plotnikov + ContactsColumns.LAST_STATUS_UPDATE_ID; 11494a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov 11504a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov String contactsSelect = "SELECT " 11514a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + ContactsColumns.CONCRETE_ID + " AS " + Contacts._ID + "," 1152f992bfab334b760d36a053fc0b439382dcfb51adDmitri Plotnikov + contactsColumns 11534a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + " FROM " + Tables.CONTACTS; 11544a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov 11554a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov String restrictedContactsSelect = "SELECT " 11564a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + ContactsColumns.CONCRETE_ID + " AS " + Contacts._ID + "," 1157f992bfab334b760d36a053fc0b439382dcfb51adDmitri Plotnikov + contactsColumns 11584a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + " FROM " + Tables.CONTACTS 11594a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov + " WHERE " + ContactsColumns.SINGLE_IS_RESTRICTED + "=0"; 11604a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov 11614a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov db.execSQL("CREATE VIEW " + Views.CONTACTS_ALL + " AS " + contactsSelect); 11624a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov db.execSQL("CREATE VIEW " + Views.CONTACTS_RESTRICTED + " AS " + restrictedContactsSelect); 11634a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov 116489c626eb655440c86a2e5df076e83708c1b32c17Dmitri Plotnikov String groupsColumns = 116589c626eb655440c86a2e5df076e83708c1b32c17Dmitri Plotnikov Groups.ACCOUNT_NAME + "," 116689c626eb655440c86a2e5df076e83708c1b32c17Dmitri Plotnikov + Groups.ACCOUNT_TYPE + "," 116789c626eb655440c86a2e5df076e83708c1b32c17Dmitri Plotnikov + Groups.SOURCE_ID + "," 116889c626eb655440c86a2e5df076e83708c1b32c17Dmitri Plotnikov + Groups.VERSION + "," 116989c626eb655440c86a2e5df076e83708c1b32c17Dmitri Plotnikov + Groups.DIRTY + "," 117089c626eb655440c86a2e5df076e83708c1b32c17Dmitri Plotnikov + Groups.TITLE + "," 117189c626eb655440c86a2e5df076e83708c1b32c17Dmitri Plotnikov + Groups.TITLE_RES + "," 117289c626eb655440c86a2e5df076e83708c1b32c17Dmitri Plotnikov + Groups.NOTES + "," 117389c626eb655440c86a2e5df076e83708c1b32c17Dmitri Plotnikov + Groups.SYSTEM_ID + "," 117489c626eb655440c86a2e5df076e83708c1b32c17Dmitri Plotnikov + Groups.DELETED + "," 117589c626eb655440c86a2e5df076e83708c1b32c17Dmitri Plotnikov + Groups.GROUP_VISIBLE + "," 117689c626eb655440c86a2e5df076e83708c1b32c17Dmitri Plotnikov + Groups.SHOULD_SYNC + "," 117789c626eb655440c86a2e5df076e83708c1b32c17Dmitri Plotnikov + Groups.SYNC1 + "," 117889c626eb655440c86a2e5df076e83708c1b32c17Dmitri Plotnikov + Groups.SYNC2 + "," 117989c626eb655440c86a2e5df076e83708c1b32c17Dmitri Plotnikov + Groups.SYNC3 + "," 118089c626eb655440c86a2e5df076e83708c1b32c17Dmitri Plotnikov + Groups.SYNC4 + "," 118189c626eb655440c86a2e5df076e83708c1b32c17Dmitri Plotnikov + PackagesColumns.PACKAGE + " AS " + Groups.RES_PACKAGE; 118289c626eb655440c86a2e5df076e83708c1b32c17Dmitri Plotnikov 118389c626eb655440c86a2e5df076e83708c1b32c17Dmitri Plotnikov String groupsSelect = "SELECT " 118489c626eb655440c86a2e5df076e83708c1b32c17Dmitri Plotnikov + GroupsColumns.CONCRETE_ID + " AS " + Groups._ID + "," 118589c626eb655440c86a2e5df076e83708c1b32c17Dmitri Plotnikov + groupsColumns 118689c626eb655440c86a2e5df076e83708c1b32c17Dmitri Plotnikov + " FROM " + Tables.GROUPS_JOIN_PACKAGES; 118789c626eb655440c86a2e5df076e83708c1b32c17Dmitri Plotnikov 118889c626eb655440c86a2e5df076e83708c1b32c17Dmitri Plotnikov db.execSQL("CREATE VIEW " + Views.GROUPS_ALL + " AS " + groupsSelect); 118989c626eb655440c86a2e5df076e83708c1b32c17Dmitri Plotnikov 1190b597adb79f1f57a24be2be09e3f45fa0f04f6f8fDmitri Plotnikov loadNicknameLookupTable(db); 11914a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov 1192b61f0d658092919aa2bb201787cf3fcbe1d3d048Jeff Hamilton // Add the legacy API support views, etc 1193b61f0d658092919aa2bb201787cf3fcbe1d3d048Jeff Hamilton LegacyApiSupport.createDatabase(db); 1194f79538095a1af16dcd6e641448b627f60f197802Dmitri Plotnikov 1195f79538095a1af16dcd6e641448b627f60f197802Dmitri Plotnikov // This will create a sqlite_stat1 table that is used for query optimization 1196f79538095a1af16dcd6e641448b627f60f197802Dmitri Plotnikov db.execSQL("ANALYZE;"); 1197f79538095a1af16dcd6e641448b627f60f197802Dmitri Plotnikov 1198f79538095a1af16dcd6e641448b627f60f197802Dmitri Plotnikov updateSqliteStats(db); 1199f79538095a1af16dcd6e641448b627f60f197802Dmitri Plotnikov 1200f79538095a1af16dcd6e641448b627f60f197802Dmitri Plotnikov // We need to close and reopen the database connection so that the stats are 1201f79538095a1af16dcd6e641448b627f60f197802Dmitri Plotnikov // taken into account. Make a note of it and do the actual reopening in the 1202f79538095a1af16dcd6e641448b627f60f197802Dmitri Plotnikov // getWritableDatabase method. 1203f79538095a1af16dcd6e641448b627f60f197802Dmitri Plotnikov mReopenDatabase = true; 1204a3bd0246ca3741877488bca7aadd91c79b2fd8d2Fred Quintana 1205a3bd0246ca3741877488bca7aadd91c79b2fd8d2Fred Quintana ContentResolver.requestSync(null /* all accounts */, 1206a3bd0246ca3741877488bca7aadd91c79b2fd8d2Fred Quintana ContactsContract.AUTHORITY, new Bundle()); 1207b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey } 1208b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey 1209b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey @Override 1210b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) { 1211f79538095a1af16dcd6e641448b627f60f197802Dmitri Plotnikov 12127e4676dfcaa8853b81c2133e0e318ed3436fe787Fred Quintana Log.i(TAG, "Upgrading from version " + oldVersion + " to " + newVersion 1213b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey + ", data will be lost!"); 1214b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey 1215d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov db.execSQL("DROP TABLE IF EXISTS " + Tables.CONTACTS + ";"); 12165ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov db.execSQL("DROP TABLE IF EXISTS " + Tables.RAW_CONTACTS + ";"); 1217ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey db.execSQL("DROP TABLE IF EXISTS " + Tables.PACKAGES + ";"); 1218ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey db.execSQL("DROP TABLE IF EXISTS " + Tables.MIMETYPES + ";"); 1219b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey db.execSQL("DROP TABLE IF EXISTS " + Tables.DATA + ";"); 1220b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey db.execSQL("DROP TABLE IF EXISTS " + Tables.PHONE_LOOKUP + ";"); 1221a8dc456684a104c7e5547ba17d44f952022cd8c5Dmitri Plotnikov db.execSQL("DROP TABLE IF EXISTS " + Tables.NAME_LOOKUP + ";"); 1222b597adb79f1f57a24be2be09e3f45fa0f04f6f8fDmitri Plotnikov db.execSQL("DROP TABLE IF EXISTS " + Tables.NICKNAME_LOOKUP + ";"); 1223ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey db.execSQL("DROP TABLE IF EXISTS " + Tables.GROUPS + ";"); 1224b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey db.execSQL("DROP TABLE IF EXISTS " + Tables.ACTIVITIES + ";"); 12253d8b043c3341a5b6c2e781b7eba9767d5cd13267Dmitri Plotnikov db.execSQL("DROP TABLE IF EXISTS " + Tables.CALLS + ";"); 1226eb9ffdccfa19f5b2f22e688f733fd77e39605f9eJeff Sharkey db.execSQL("DROP TABLE IF EXISTS " + Tables.SETTINGS + ";"); 1227a23cd5b6f478f6c9dda54173e84bd0098b9f3364Dmitri Plotnikov db.execSQL("DROP TABLE IF EXISTS " + Tables.STATUS_UPDATES + ";"); 1228b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey 1229f1ce2d5008e490f447d6f5ff04a784c8ae066e9dJeff Sharkey db.execSQL("DROP VIEW IF EXISTS " + Tables.CONTACT_ENTITIES + ";"); 1230d237c80845d8e13164d34278d3c20e31f8d80b4dDaisuke Miyakawa db.execSQL("DROP VIEW IF EXISTS " + Tables.CONTACT_ENTITIES_RESTRICTED + ";"); 12314a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov db.execSQL("DROP VIEW IF EXISTS " + Views.CONTACTS_ALL + ";"); 12324a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov db.execSQL("DROP VIEW IF EXISTS " + Views.CONTACTS_RESTRICTED + ";"); 12334a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov db.execSQL("DROP VIEW IF EXISTS " + Views.DATA_ALL + ";"); 12344a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov db.execSQL("DROP VIEW IF EXISTS " + Views.DATA_RESTRICTED + ";"); 12354a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov db.execSQL("DROP VIEW IF EXISTS " + Views.RAW_CONTACTS_ALL + ";"); 12364a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov db.execSQL("DROP VIEW IF EXISTS " + Views.RAW_CONTACTS_RESTRICTED + ";"); 1237f2f14a3dfb4b53a056e000c0aa17fbae13bd445eDmitri Plotnikov db.execSQL("DROP VIEW IF EXISTS " + Views.GROUPS_ALL + ";"); 1238f1ce2d5008e490f447d6f5ff04a784c8ae066e9dJeff Sharkey 1239d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov // TODO: we should not be dropping agg_exceptions and contact_options. In case that table's 1240d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov // schema changes, we should try to preserve the data, because it was entered by the user 1241d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov // and has never been synched to the server. 1242d35d9c748af4c3182679c4c546137acfc11eb7a8Dmitri Plotnikov db.execSQL("DROP TABLE IF EXISTS " + Tables.AGGREGATION_EXCEPTIONS + ";"); 1243b174c7ccd337a7bea6269139c9b09acc69ae40c1Dmitri Plotnikov 1244b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey onCreate(db); 1245b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey } 1246b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey 1247a8dc456684a104c7e5547ba17d44f952022cd8c5Dmitri Plotnikov /** 1248f79538095a1af16dcd6e641448b627f60f197802Dmitri Plotnikov * Adds index stats into the SQLite database to force it to always use the lookup indexes. 1249f79538095a1af16dcd6e641448b627f60f197802Dmitri Plotnikov */ 1250f79538095a1af16dcd6e641448b627f60f197802Dmitri Plotnikov private void updateSqliteStats(SQLiteDatabase db) { 1251f79538095a1af16dcd6e641448b627f60f197802Dmitri Plotnikov 1252f79538095a1af16dcd6e641448b627f60f197802Dmitri Plotnikov // Specific stats strings are based on an actual large database after running ANALYZE 1253f79538095a1af16dcd6e641448b627f60f197802Dmitri Plotnikov try { 12548fddc066662d58e8d6a436decb8dafbf28ce652eDmitri Plotnikov updateIndexStats(db, Tables.CONTACTS, 12558fddc066662d58e8d6a436decb8dafbf28ce652eDmitri Plotnikov "contacts_restricted_index", "10000 9000"); 12568fddc066662d58e8d6a436decb8dafbf28ce652eDmitri Plotnikov updateIndexStats(db, Tables.CONTACTS, 12578fddc066662d58e8d6a436decb8dafbf28ce652eDmitri Plotnikov "contacts_has_phone_index", "10000 500"); 12588fddc066662d58e8d6a436decb8dafbf28ce652eDmitri Plotnikov updateIndexStats(db, Tables.CONTACTS, 1259737858a04a157a0afad9ec81372c75d14bf68788Jeff Hamilton "contacts_visible_index", "10000 500 1"); 12608fddc066662d58e8d6a436decb8dafbf28ce652eDmitri Plotnikov 12618fddc066662d58e8d6a436decb8dafbf28ce652eDmitri Plotnikov updateIndexStats(db, Tables.RAW_CONTACTS, 12628fddc066662d58e8d6a436decb8dafbf28ce652eDmitri Plotnikov "raw_contacts_source_id_index", "10000 1 1 1"); 12638fddc066662d58e8d6a436decb8dafbf28ce652eDmitri Plotnikov updateIndexStats(db, Tables.RAW_CONTACTS, 12648fddc066662d58e8d6a436decb8dafbf28ce652eDmitri Plotnikov "raw_contacts_contact_id_index", "10000 2"); 12658fddc066662d58e8d6a436decb8dafbf28ce652eDmitri Plotnikov 12668fddc066662d58e8d6a436decb8dafbf28ce652eDmitri Plotnikov updateIndexStats(db, Tables.NAME_LOOKUP, 12678fddc066662d58e8d6a436decb8dafbf28ce652eDmitri Plotnikov "name_lookup_raw_contact_id_index", "10000 3"); 12688fddc066662d58e8d6a436decb8dafbf28ce652eDmitri Plotnikov updateIndexStats(db, Tables.NAME_LOOKUP, 12698fddc066662d58e8d6a436decb8dafbf28ce652eDmitri Plotnikov "name_lookup_index", "10000 3 2 2"); 12708fddc066662d58e8d6a436decb8dafbf28ce652eDmitri Plotnikov updateIndexStats(db, Tables.NAME_LOOKUP, 12718fddc066662d58e8d6a436decb8dafbf28ce652eDmitri Plotnikov "sqlite_autoindex_name_lookup_1", "10000 3 2 1"); 12728fddc066662d58e8d6a436decb8dafbf28ce652eDmitri Plotnikov 12738fddc066662d58e8d6a436decb8dafbf28ce652eDmitri Plotnikov updateIndexStats(db, Tables.PHONE_LOOKUP, 12748fddc066662d58e8d6a436decb8dafbf28ce652eDmitri Plotnikov "phone_lookup_index", "10000 2 2 1"); 12758fddc066662d58e8d6a436decb8dafbf28ce652eDmitri Plotnikov 12768fddc066662d58e8d6a436decb8dafbf28ce652eDmitri Plotnikov updateIndexStats(db, Tables.DATA, 12778fddc066662d58e8d6a436decb8dafbf28ce652eDmitri Plotnikov "data_mimetype_data1_index", "60000 5000 2"); 12788fddc066662d58e8d6a436decb8dafbf28ce652eDmitri Plotnikov updateIndexStats(db, Tables.DATA, 12798fddc066662d58e8d6a436decb8dafbf28ce652eDmitri Plotnikov "data_raw_contact_id", "60000 10"); 12808fddc066662d58e8d6a436decb8dafbf28ce652eDmitri Plotnikov 12818fddc066662d58e8d6a436decb8dafbf28ce652eDmitri Plotnikov updateIndexStats(db, Tables.GROUPS, 12828fddc066662d58e8d6a436decb8dafbf28ce652eDmitri Plotnikov "groups_source_id_index", "50 1 1 1"); 12838fddc066662d58e8d6a436decb8dafbf28ce652eDmitri Plotnikov 12848fddc066662d58e8d6a436decb8dafbf28ce652eDmitri Plotnikov updateIndexStats(db, Tables.NICKNAME_LOOKUP, 12858fddc066662d58e8d6a436decb8dafbf28ce652eDmitri Plotnikov "sqlite_autoindex_name_lookup_1", "500 2 1"); 12868fddc066662d58e8d6a436decb8dafbf28ce652eDmitri Plotnikov 1287f79538095a1af16dcd6e641448b627f60f197802Dmitri Plotnikov } catch (SQLException e) { 1288f79538095a1af16dcd6e641448b627f60f197802Dmitri Plotnikov Log.e(TAG, "Could not update index stats", e); 1289f79538095a1af16dcd6e641448b627f60f197802Dmitri Plotnikov } 1290f79538095a1af16dcd6e641448b627f60f197802Dmitri Plotnikov } 1291f79538095a1af16dcd6e641448b627f60f197802Dmitri Plotnikov 1292f79538095a1af16dcd6e641448b627f60f197802Dmitri Plotnikov /** 1293f79538095a1af16dcd6e641448b627f60f197802Dmitri Plotnikov * Stores statistics for a given index. 1294f79538095a1af16dcd6e641448b627f60f197802Dmitri Plotnikov * 1295f79538095a1af16dcd6e641448b627f60f197802Dmitri Plotnikov * @param stats has the following structure: the first index is the expected size of 1296f79538095a1af16dcd6e641448b627f60f197802Dmitri Plotnikov * the table. The following integer(s) are the expected number of records selected with the 1297f79538095a1af16dcd6e641448b627f60f197802Dmitri Plotnikov * index. There should be one integer per indexed column. 1298f79538095a1af16dcd6e641448b627f60f197802Dmitri Plotnikov */ 1299f79538095a1af16dcd6e641448b627f60f197802Dmitri Plotnikov private void updateIndexStats(SQLiteDatabase db, String table, String index, String stats) { 1300f79538095a1af16dcd6e641448b627f60f197802Dmitri Plotnikov db.execSQL("DELETE FROM sqlite_stat1 WHERE tbl='" + table + "' AND idx='" + index + "';"); 1301f79538095a1af16dcd6e641448b627f60f197802Dmitri Plotnikov db.execSQL("INSERT INTO sqlite_stat1 (tbl,idx,stat)" 1302f79538095a1af16dcd6e641448b627f60f197802Dmitri Plotnikov + " VALUES ('" + table + "','" + index + "','" + stats + "');"); 1303f79538095a1af16dcd6e641448b627f60f197802Dmitri Plotnikov } 1304f79538095a1af16dcd6e641448b627f60f197802Dmitri Plotnikov 1305f79538095a1af16dcd6e641448b627f60f197802Dmitri Plotnikov @Override 1306f79538095a1af16dcd6e641448b627f60f197802Dmitri Plotnikov public synchronized SQLiteDatabase getWritableDatabase() { 1307f79538095a1af16dcd6e641448b627f60f197802Dmitri Plotnikov SQLiteDatabase db = super.getWritableDatabase(); 1308f79538095a1af16dcd6e641448b627f60f197802Dmitri Plotnikov if (mReopenDatabase) { 1309f79538095a1af16dcd6e641448b627f60f197802Dmitri Plotnikov mReopenDatabase = false; 1310f79538095a1af16dcd6e641448b627f60f197802Dmitri Plotnikov close(); 1311f79538095a1af16dcd6e641448b627f60f197802Dmitri Plotnikov db = super.getWritableDatabase(); 1312f79538095a1af16dcd6e641448b627f60f197802Dmitri Plotnikov } 1313f79538095a1af16dcd6e641448b627f60f197802Dmitri Plotnikov return db; 1314f79538095a1af16dcd6e641448b627f60f197802Dmitri Plotnikov } 1315f79538095a1af16dcd6e641448b627f60f197802Dmitri Plotnikov 1316f79538095a1af16dcd6e641448b627f60f197802Dmitri Plotnikov /** 1317a8dc456684a104c7e5547ba17d44f952022cd8c5Dmitri Plotnikov * Wipes all data except mime type and package lookup tables. 1318a8dc456684a104c7e5547ba17d44f952022cd8c5Dmitri Plotnikov */ 1319a8dc456684a104c7e5547ba17d44f952022cd8c5Dmitri Plotnikov public void wipeData() { 1320a8dc456684a104c7e5547ba17d44f952022cd8c5Dmitri Plotnikov SQLiteDatabase db = getWritableDatabase(); 13213d8b043c3341a5b6c2e781b7eba9767d5cd13267Dmitri Plotnikov 1322d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov db.execSQL("DELETE FROM " + Tables.CONTACTS + ";"); 13235ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov db.execSQL("DELETE FROM " + Tables.RAW_CONTACTS + ";"); 1324a8dc456684a104c7e5547ba17d44f952022cd8c5Dmitri Plotnikov db.execSQL("DELETE FROM " + Tables.DATA + ";"); 1325a8dc456684a104c7e5547ba17d44f952022cd8c5Dmitri Plotnikov db.execSQL("DELETE FROM " + Tables.PHONE_LOOKUP + ";"); 1326a8dc456684a104c7e5547ba17d44f952022cd8c5Dmitri Plotnikov db.execSQL("DELETE FROM " + Tables.NAME_LOOKUP + ";"); 1327ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey db.execSQL("DELETE FROM " + Tables.GROUPS + ";"); 1328b174c7ccd337a7bea6269139c9b09acc69ae40c1Dmitri Plotnikov db.execSQL("DELETE FROM " + Tables.AGGREGATION_EXCEPTIONS + ";"); 1329eb9ffdccfa19f5b2f22e688f733fd77e39605f9eJeff Sharkey db.execSQL("DELETE FROM " + Tables.SETTINGS + ";"); 1330a8dc456684a104c7e5547ba17d44f952022cd8c5Dmitri Plotnikov db.execSQL("DELETE FROM " + Tables.ACTIVITIES + ";"); 13313d8b043c3341a5b6c2e781b7eba9767d5cd13267Dmitri Plotnikov db.execSQL("DELETE FROM " + Tables.CALLS + ";"); 1332b597adb79f1f57a24be2be09e3f45fa0f04f6f8fDmitri Plotnikov 1333b597adb79f1f57a24be2be09e3f45fa0f04f6f8fDmitri Plotnikov // Note: we are not removing reference data from Tables.NICKNAME_LOOKUP 1334b597adb79f1f57a24be2be09e3f45fa0f04f6f8fDmitri Plotnikov 1335a8dc456684a104c7e5547ba17d44f952022cd8c5Dmitri Plotnikov db.execSQL("VACUUM;"); 1336a8dc456684a104c7e5547ba17d44f952022cd8c5Dmitri Plotnikov } 1337b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey 1338b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey /** 1339619871b0fb0175d75ff9336bfe5aec0b27b9bdadJeff Sharkey * Return the {@link ApplicationInfo#uid} for the given package name. 1340619871b0fb0175d75ff9336bfe5aec0b27b9bdadJeff Sharkey */ 1341619871b0fb0175d75ff9336bfe5aec0b27b9bdadJeff Sharkey public static int getUidForPackageName(PackageManager pm, String packageName) { 1342619871b0fb0175d75ff9336bfe5aec0b27b9bdadJeff Sharkey try { 1343619871b0fb0175d75ff9336bfe5aec0b27b9bdadJeff Sharkey ApplicationInfo clientInfo = pm.getApplicationInfo(packageName, 0 /* no flags */); 1344619871b0fb0175d75ff9336bfe5aec0b27b9bdadJeff Sharkey return clientInfo.uid; 1345619871b0fb0175d75ff9336bfe5aec0b27b9bdadJeff Sharkey } catch (NameNotFoundException e) { 1346619871b0fb0175d75ff9336bfe5aec0b27b9bdadJeff Sharkey throw new RuntimeException(e); 1347619871b0fb0175d75ff9336bfe5aec0b27b9bdadJeff Sharkey } 1348619871b0fb0175d75ff9336bfe5aec0b27b9bdadJeff Sharkey } 1349619871b0fb0175d75ff9336bfe5aec0b27b9bdadJeff Sharkey 1350619871b0fb0175d75ff9336bfe5aec0b27b9bdadJeff Sharkey /** 1351b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey * Perform an internal string-to-integer lookup using the compiled 1352b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey * {@link SQLiteStatement} provided, using the in-memory cache to speed up 1353b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey * lookups. If a mapping isn't found in cache or database, it will be 1354b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey * created. All new, uncached answers are added to the cache automatically. 1355b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey * 1356b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey * @param query Compiled statement used to query for the mapping. 1357b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey * @param insert Compiled statement used to insert a new mapping when no 1358b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey * existing one is found in cache or from query. 1359b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey * @param value Value to find mapping for. 1360b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey * @param cache In-memory cache of previous answers. 1361b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey * @return An unique integer mapping for the given value. 1362b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey */ 1363b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey private synchronized long getCachedId(SQLiteStatement query, SQLiteStatement insert, 1364b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey String value, HashMap<String, Long> cache) { 1365b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey // Try an in-memory cache lookup 1366b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey if (cache.containsKey(value)) { 1367b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey return cache.get(value); 1368b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey } 1369b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey 1370b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey long id = -1; 1371b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey try { 1372b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey // Try searching database for mapping 1373b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey DatabaseUtils.bindObjectToProgram(query, 1, value); 1374b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey id = query.simpleQueryForLong(); 1375b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey } catch (SQLiteDoneException e) { 1376b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey // Nothing found, so try inserting new mapping 1377b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey DatabaseUtils.bindObjectToProgram(insert, 1, value); 1378b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey id = insert.executeInsert(); 1379b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey } 1380b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey 1381b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey if (id != -1) { 1382b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey // Cache and return the new answer 1383b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey cache.put(value, id); 1384b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey return id; 1385b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey } else { 1386b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey // Otherwise throw if no mapping found or created 1387b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey throw new IllegalStateException("Couldn't find or create internal " 1388b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey + "lookup table entry for value " + value); 1389b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey } 1390b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey } 1391b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey 1392b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey /** 1393ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey * Convert a package name into an integer, using {@link Tables#PACKAGES} for 1394b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey * lookups and possible allocation of new IDs as needed. 1395b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey */ 1396b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey public long getPackageId(String packageName) { 1397b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey // Make sure compiled statements are ready by opening database 1398b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey getReadableDatabase(); 1399b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey return getCachedId(mPackageQuery, mPackageInsert, packageName, mPackageCache); 1400b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey } 1401b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey 1402b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey /** 1403ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey * Convert a mimetype into an integer, using {@link Tables#MIMETYPES} for 1404b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey * lookups and possible allocation of new IDs as needed. 1405b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey */ 1406b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey public long getMimeTypeId(String mimetype) { 1407b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey // Make sure compiled statements are ready by opening database 1408b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey getReadableDatabase(); 1409b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey return getCachedId(mMimetypeQuery, mMimetypeInsert, mimetype, mMimetypeCache); 1410b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey } 1411b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey 1412b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey /** 1413ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey * Find the mimetype for the given {@link Data#_ID}. 1414b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey */ 1415b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey public String getDataMimeType(long dataId) { 1416b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey // Make sure compiled statements are ready by opening database 1417b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey getReadableDatabase(); 1418b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey try { 1419b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey // Try database query to find mimetype 1420b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey DatabaseUtils.bindObjectToProgram(mDataMimetypeQuery, 1, dataId); 1421b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey String mimetype = mDataMimetypeQuery.simpleQueryForString(); 1422b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey return mimetype; 1423b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey } catch (SQLiteDoneException e) { 1424b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey // No valid mapping found, so return null 1425b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey return null; 1426b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey } 1427b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey } 1428b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey 1429b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey /** 1430b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey * Find the mime-type for the given {@link Activities#_ID}. 1431b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey */ 1432b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey public String getActivityMimeType(long activityId) { 1433b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey // Make sure compiled statements are ready by opening database 1434b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey getReadableDatabase(); 1435b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey try { 1436b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey // Try database query to find mimetype 1437b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey DatabaseUtils.bindObjectToProgram(mActivitiesMimetypeQuery, 1, activityId); 1438b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey String mimetype = mActivitiesMimetypeQuery.simpleQueryForString(); 1439b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey return mimetype; 1440b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey } catch (SQLiteDoneException e) { 1441b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey // No valid mapping found, so return null 1442b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey return null; 1443b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey } 1444b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey } 14456bccc079d8fea5c51f9fa6fd06044bd8f5109c6fDmitri Plotnikov 14466bccc079d8fea5c51f9fa6fd06044bd8f5109c6fDmitri Plotnikov /** 1447d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov * Update {@link Contacts#IN_VISIBLE_GROUP} for all contacts. 1448ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey */ 1449ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey public void updateAllVisible() { 1450ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey final long groupMembershipMimetypeId = getMimeTypeId(GroupMembership.CONTENT_ITEM_TYPE); 1451e07913c61c320b0cc2036db3b714e39534d8cd7aJeff Sharkey mVisibleUpdate.bindLong(1, groupMembershipMimetypeId); 1452e07913c61c320b0cc2036db3b714e39534d8cd7aJeff Sharkey mVisibleUpdate.execute(); 1453ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey } 1454ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey 1455ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey /** 1456d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov * Update {@link Contacts#IN_VISIBLE_GROUP} for a specific contact. 1457ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey */ 1458d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov public void updateContactVisible(long aggId) { 1459ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey final long groupMembershipMimetypeId = getMimeTypeId(GroupMembership.CONTENT_ITEM_TYPE); 1460ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey mVisibleSpecificUpdate.bindLong(1, groupMembershipMimetypeId); 1461ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey mVisibleSpecificUpdate.bindLong(2, aggId); 1462ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey mVisibleSpecificUpdate.execute(); 1463ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey } 1464ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey 1465ca8172420c0913dff96ea607d477d8b8abfe5ddbJeff Sharkey /** 1466d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov * Returns contact ID for the given contact or zero if it is NULL. 14676bccc079d8fea5c51f9fa6fd06044bd8f5109c6fDmitri Plotnikov */ 1468d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov public long getContactId(long rawContactId) { 14696bccc079d8fea5c51f9fa6fd06044bd8f5109c6fDmitri Plotnikov getReadableDatabase(); 14706bccc079d8fea5c51f9fa6fd06044bd8f5109c6fDmitri Plotnikov try { 1471d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov DatabaseUtils.bindObjectToProgram(mContactIdQuery, 1, rawContactId); 1472d3fde755e73cd3912a488e7cb7d412d3c5f6ca94Dmitri Plotnikov return mContactIdQuery.simpleQueryForLong(); 14736bccc079d8fea5c51f9fa6fd06044bd8f5109c6fDmitri Plotnikov } catch (SQLiteDoneException e) { 1474a3bd0246ca3741877488bca7aadd91c79b2fd8d2Fred Quintana // No valid mapping found, so return 0 14756bccc079d8fea5c51f9fa6fd06044bd8f5109c6fDmitri Plotnikov return 0; 14766bccc079d8fea5c51f9fa6fd06044bd8f5109c6fDmitri Plotnikov } 14776bccc079d8fea5c51f9fa6fd06044bd8f5109c6fDmitri Plotnikov } 147861bbb2287e8102b7e03922c03809c34b7b317d1cDmitri Plotnikov 14795ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov public int getAggregationMode(long rawContactId) { 1480f4e1358f1c8f5fe5e9e7689e36e04c57c2385169Dmitri Plotnikov getReadableDatabase(); 1481f4e1358f1c8f5fe5e9e7689e36e04c57c2385169Dmitri Plotnikov try { 14825ef0401c311c62e53bde415b99cbb0ff83b0a9a2Dmitri Plotnikov DatabaseUtils.bindObjectToProgram(mAggregationModeQuery, 1, rawContactId); 1483f4e1358f1c8f5fe5e9e7689e36e04c57c2385169Dmitri Plotnikov return (int)mAggregationModeQuery.simpleQueryForLong(); 1484f4e1358f1c8f5fe5e9e7689e36e04c57c2385169Dmitri Plotnikov } catch (SQLiteDoneException e) { 14856cffee46a1334d2b3ed19f436b27638451541044Dmitri Plotnikov // No valid row found, so return "disabled" 14866cffee46a1334d2b3ed19f436b27638451541044Dmitri Plotnikov return RawContacts.AGGREGATION_MODE_DISABLED; 1487f4e1358f1c8f5fe5e9e7689e36e04c57c2385169Dmitri Plotnikov } 1488f4e1358f1c8f5fe5e9e7689e36e04c57c2385169Dmitri Plotnikov } 1489f4e1358f1c8f5fe5e9e7689e36e04c57c2385169Dmitri Plotnikov 1490e3eb7ef438010c893c429f3031dcc7298171865dDmitri Plotnikov public void buildPhoneLookupAndRawContactQuery(SQLiteQueryBuilder qb, String number) { 1491e3eb7ef438010c893c429f3031dcc7298171865dDmitri Plotnikov String normalizedNumber = PhoneNumberUtils.toCallerIDMinMatch(number); 1492f79538095a1af16dcd6e641448b627f60f197802Dmitri Plotnikov qb.setTables(Tables.DATA_JOIN_RAW_CONTACTS + 1493f79538095a1af16dcd6e641448b627f60f197802Dmitri Plotnikov " JOIN " + Tables.PHONE_LOOKUP 1494f79538095a1af16dcd6e641448b627f60f197802Dmitri Plotnikov + " ON(" + DataColumns.CONCRETE_ID + "=" + PhoneLookupColumns.DATA_ID + ")"); 1495f79538095a1af16dcd6e641448b627f60f197802Dmitri Plotnikov 1496e3eb7ef438010c893c429f3031dcc7298171865dDmitri Plotnikov StringBuilder sb = new StringBuilder(); 1497f79538095a1af16dcd6e641448b627f60f197802Dmitri Plotnikov sb.append(PhoneLookupColumns.NORMALIZED_NUMBER + " GLOB '"); 1498f79538095a1af16dcd6e641448b627f60f197802Dmitri Plotnikov sb.append(normalizedNumber); 1499f79538095a1af16dcd6e641448b627f60f197802Dmitri Plotnikov sb.append("*' AND PHONE_NUMBERS_EQUAL(data." + Phone.NUMBER + ", "); 1500f79538095a1af16dcd6e641448b627f60f197802Dmitri Plotnikov DatabaseUtils.appendEscapedSQLString(sb, number); 15013a6a49cfb06272e3e25f3c390a9cf4002da6e34dDaisuke Miyakawa sb.append(mUseStrictPhoneNumberComparation ? ", 1)" : ", 0)"); 1502e3eb7ef438010c893c429f3031dcc7298171865dDmitri Plotnikov 1503e3eb7ef438010c893c429f3031dcc7298171865dDmitri Plotnikov qb.appendWhere(sb.toString()); 1504e3eb7ef438010c893c429f3031dcc7298171865dDmitri Plotnikov } 1505e3eb7ef438010c893c429f3031dcc7298171865dDmitri Plotnikov 1506e3eb7ef438010c893c429f3031dcc7298171865dDmitri Plotnikov public void buildPhoneLookupAndContactQuery(SQLiteQueryBuilder qb, String number) { 1507e3eb7ef438010c893c429f3031dcc7298171865dDmitri Plotnikov String normalizedNumber = PhoneNumberUtils.toCallerIDMinMatch(number); 1508e3eb7ef438010c893c429f3031dcc7298171865dDmitri Plotnikov StringBuilder sb = new StringBuilder(); 1509e3eb7ef438010c893c429f3031dcc7298171865dDmitri Plotnikov appendPhoneLookupTables(sb, normalizedNumber, true); 1510e3eb7ef438010c893c429f3031dcc7298171865dDmitri Plotnikov qb.setTables(sb.toString()); 1511e3eb7ef438010c893c429f3031dcc7298171865dDmitri Plotnikov 1512e3eb7ef438010c893c429f3031dcc7298171865dDmitri Plotnikov sb = new StringBuilder(); 1513e3eb7ef438010c893c429f3031dcc7298171865dDmitri Plotnikov appendPhoneLookupSelection(sb, number); 1514e3eb7ef438010c893c429f3031dcc7298171865dDmitri Plotnikov qb.appendWhere(sb.toString()); 1515bf659107617a6291ba8bfeebc3f2e50138075ab5Dmitri Plotnikov } 1516bf659107617a6291ba8bfeebc3f2e50138075ab5Dmitri Plotnikov 1517e3eb7ef438010c893c429f3031dcc7298171865dDmitri Plotnikov public String buildPhoneLookupAsNestedQuery(String number) { 1518e3eb7ef438010c893c429f3031dcc7298171865dDmitri Plotnikov StringBuilder sb = new StringBuilder(); 1519fb362d1a5df250a49fad06db323b0d41fe0e3757Dmitri Plotnikov final String normalizedNumber = PhoneNumberUtils.toCallerIDMinMatch(number); 1520e3eb7ef438010c893c429f3031dcc7298171865dDmitri Plotnikov sb.append("(SELECT DISTINCT raw_contact_id" + " FROM "); 1521e3eb7ef438010c893c429f3031dcc7298171865dDmitri Plotnikov appendPhoneLookupTables(sb, normalizedNumber, false); 1522e3eb7ef438010c893c429f3031dcc7298171865dDmitri Plotnikov sb.append(" WHERE "); 1523e3eb7ef438010c893c429f3031dcc7298171865dDmitri Plotnikov appendPhoneLookupSelection(sb, number); 1524e3eb7ef438010c893c429f3031dcc7298171865dDmitri Plotnikov sb.append(")"); 1525e3eb7ef438010c893c429f3031dcc7298171865dDmitri Plotnikov return sb.toString(); 1526e3eb7ef438010c893c429f3031dcc7298171865dDmitri Plotnikov } 1527e3eb7ef438010c893c429f3031dcc7298171865dDmitri Plotnikov 1528e3eb7ef438010c893c429f3031dcc7298171865dDmitri Plotnikov private void appendPhoneLookupTables(StringBuilder sb, final String normalizedNumber, 1529e3eb7ef438010c893c429f3031dcc7298171865dDmitri Plotnikov boolean joinContacts) { 1530e3eb7ef438010c893c429f3031dcc7298171865dDmitri Plotnikov sb.append(Tables.RAW_CONTACTS); 1531e3eb7ef438010c893c429f3031dcc7298171865dDmitri Plotnikov if (joinContacts) { 1532e3eb7ef438010c893c429f3031dcc7298171865dDmitri Plotnikov sb.append(" JOIN " + getContactView() + " contacts" 1533e3eb7ef438010c893c429f3031dcc7298171865dDmitri Plotnikov + " ON (contacts._id = raw_contacts.contact_id)"); 1534e3eb7ef438010c893c429f3031dcc7298171865dDmitri Plotnikov } 1535e3eb7ef438010c893c429f3031dcc7298171865dDmitri Plotnikov sb.append(", (SELECT data_id FROM phone_lookup " 1536fb362d1a5df250a49fad06db323b0d41fe0e3757Dmitri Plotnikov + "WHERE (phone_lookup.normalized_number GLOB '"); 1537fb362d1a5df250a49fad06db323b0d41fe0e3757Dmitri Plotnikov sb.append(normalizedNumber); 1538e3eb7ef438010c893c429f3031dcc7298171865dDmitri Plotnikov sb.append("*')) AS lookup, " + Tables.DATA); 1539e3eb7ef438010c893c429f3031dcc7298171865dDmitri Plotnikov } 1540e3eb7ef438010c893c429f3031dcc7298171865dDmitri Plotnikov 1541e3eb7ef438010c893c429f3031dcc7298171865dDmitri Plotnikov private void appendPhoneLookupSelection(StringBuilder sb, String number) { 1542e3eb7ef438010c893c429f3031dcc7298171865dDmitri Plotnikov sb.append("lookup.data_id=data._id AND data.raw_contact_id=raw_contacts._id" 1543fb362d1a5df250a49fad06db323b0d41fe0e3757Dmitri Plotnikov + " AND PHONE_NUMBERS_EQUAL(data." + Phone.NUMBER + ", "); 1544fb362d1a5df250a49fad06db323b0d41fe0e3757Dmitri Plotnikov DatabaseUtils.appendEscapedSQLString(sb, number); 15453a6a49cfb06272e3e25f3c390a9cf4002da6e34dDaisuke Miyakawa sb.append(mUseStrictPhoneNumberComparation ? ", 1)" : ", 0)"); 1546fb362d1a5df250a49fad06db323b0d41fe0e3757Dmitri Plotnikov } 1547bf659107617a6291ba8bfeebc3f2e50138075ab5Dmitri Plotnikov 1548619871b0fb0175d75ff9336bfe5aec0b27b9bdadJeff Sharkey /** 1549b597adb79f1f57a24be2be09e3f45fa0f04f6f8fDmitri Plotnikov * Loads common nickname mappings into the database. 1550b597adb79f1f57a24be2be09e3f45fa0f04f6f8fDmitri Plotnikov */ 1551b597adb79f1f57a24be2be09e3f45fa0f04f6f8fDmitri Plotnikov private void loadNicknameLookupTable(SQLiteDatabase db) { 155228f8857b1b46bde18b85c6d3c2a63ac44c3c2e1cEvan Millar String[] strings = mContext.getResources().getStringArray( 155328f8857b1b46bde18b85c6d3c2a63ac44c3c2e1cEvan Millar com.android.internal.R.array.common_nicknames); 1554b597adb79f1f57a24be2be09e3f45fa0f04f6f8fDmitri Plotnikov if (strings == null || strings.length == 0) { 1555b597adb79f1f57a24be2be09e3f45fa0f04f6f8fDmitri Plotnikov return; 1556b597adb79f1f57a24be2be09e3f45fa0f04f6f8fDmitri Plotnikov } 1557b597adb79f1f57a24be2be09e3f45fa0f04f6f8fDmitri Plotnikov 1558b597adb79f1f57a24be2be09e3f45fa0f04f6f8fDmitri Plotnikov SQLiteStatement nicknameLookupInsert = db.compileStatement("INSERT INTO " 1559b597adb79f1f57a24be2be09e3f45fa0f04f6f8fDmitri Plotnikov + Tables.NICKNAME_LOOKUP + "(" + NicknameLookupColumns.NAME + "," 1560b597adb79f1f57a24be2be09e3f45fa0f04f6f8fDmitri Plotnikov + NicknameLookupColumns.CLUSTER + ") VALUES (?,?)"); 1561b597adb79f1f57a24be2be09e3f45fa0f04f6f8fDmitri Plotnikov 1562b597adb79f1f57a24be2be09e3f45fa0f04f6f8fDmitri Plotnikov for (int clusterId = 0; clusterId < strings.length; clusterId++) { 1563b597adb79f1f57a24be2be09e3f45fa0f04f6f8fDmitri Plotnikov String[] names = strings[clusterId].split(","); 1564b597adb79f1f57a24be2be09e3f45fa0f04f6f8fDmitri Plotnikov for (int j = 0; j < names.length; j++) { 1565b597adb79f1f57a24be2be09e3f45fa0f04f6f8fDmitri Plotnikov String name = NameNormalizer.normalize(names[j]); 1566b597adb79f1f57a24be2be09e3f45fa0f04f6f8fDmitri Plotnikov try { 1567b597adb79f1f57a24be2be09e3f45fa0f04f6f8fDmitri Plotnikov DatabaseUtils.bindObjectToProgram(nicknameLookupInsert, 1, name); 1568b597adb79f1f57a24be2be09e3f45fa0f04f6f8fDmitri Plotnikov DatabaseUtils.bindObjectToProgram(nicknameLookupInsert, 2, 1569b597adb79f1f57a24be2be09e3f45fa0f04f6f8fDmitri Plotnikov String.valueOf(clusterId)); 1570b597adb79f1f57a24be2be09e3f45fa0f04f6f8fDmitri Plotnikov nicknameLookupInsert.executeInsert(); 1571b597adb79f1f57a24be2be09e3f45fa0f04f6f8fDmitri Plotnikov } catch (SQLiteException e) { 1572b597adb79f1f57a24be2be09e3f45fa0f04f6f8fDmitri Plotnikov 1573b597adb79f1f57a24be2be09e3f45fa0f04f6f8fDmitri Plotnikov // Print the exception and keep going - this is not a fatal error 1574b597adb79f1f57a24be2be09e3f45fa0f04f6f8fDmitri Plotnikov Log.e(TAG, "Cannot insert nickname: " + names[j], e); 1575b597adb79f1f57a24be2be09e3f45fa0f04f6f8fDmitri Plotnikov } 1576b597adb79f1f57a24be2be09e3f45fa0f04f6f8fDmitri Plotnikov } 1577b597adb79f1f57a24be2be09e3f45fa0f04f6f8fDmitri Plotnikov } 1578b597adb79f1f57a24be2be09e3f45fa0f04f6f8fDmitri Plotnikov } 1579b597adb79f1f57a24be2be09e3f45fa0f04f6f8fDmitri Plotnikov 1580f4e1358f1c8f5fe5e9e7689e36e04c57c2385169Dmitri Plotnikov public static void copyStringValue(ContentValues toValues, String toKey, 1581f4e1358f1c8f5fe5e9e7689e36e04c57c2385169Dmitri Plotnikov ContentValues fromValues, String fromKey) { 1582f4e1358f1c8f5fe5e9e7689e36e04c57c2385169Dmitri Plotnikov if (fromValues.containsKey(fromKey)) { 1583f4e1358f1c8f5fe5e9e7689e36e04c57c2385169Dmitri Plotnikov toValues.put(toKey, fromValues.getAsString(fromKey)); 1584f4e1358f1c8f5fe5e9e7689e36e04c57c2385169Dmitri Plotnikov } 1585f4e1358f1c8f5fe5e9e7689e36e04c57c2385169Dmitri Plotnikov } 1586f4e1358f1c8f5fe5e9e7689e36e04c57c2385169Dmitri Plotnikov 1587f4e1358f1c8f5fe5e9e7689e36e04c57c2385169Dmitri Plotnikov public static void copyLongValue(ContentValues toValues, String toKey, 1588f4e1358f1c8f5fe5e9e7689e36e04c57c2385169Dmitri Plotnikov ContentValues fromValues, String fromKey) { 1589f4e1358f1c8f5fe5e9e7689e36e04c57c2385169Dmitri Plotnikov if (fromValues.containsKey(fromKey)) { 1590f4e1358f1c8f5fe5e9e7689e36e04c57c2385169Dmitri Plotnikov long longValue; 1591f4e1358f1c8f5fe5e9e7689e36e04c57c2385169Dmitri Plotnikov Object value = fromValues.get(fromKey); 1592f4e1358f1c8f5fe5e9e7689e36e04c57c2385169Dmitri Plotnikov if (value instanceof Boolean) { 1593f4e1358f1c8f5fe5e9e7689e36e04c57c2385169Dmitri Plotnikov if ((Boolean)value) { 1594f4e1358f1c8f5fe5e9e7689e36e04c57c2385169Dmitri Plotnikov longValue = 1; 1595f4e1358f1c8f5fe5e9e7689e36e04c57c2385169Dmitri Plotnikov } else { 1596f4e1358f1c8f5fe5e9e7689e36e04c57c2385169Dmitri Plotnikov longValue = 0; 1597f4e1358f1c8f5fe5e9e7689e36e04c57c2385169Dmitri Plotnikov } 15981b7a7947242bb3b8caaed871775e62d486144c9fDmitri Plotnikov } else if (value instanceof String) { 15991b7a7947242bb3b8caaed871775e62d486144c9fDmitri Plotnikov longValue = Long.parseLong((String)value); 1600f4e1358f1c8f5fe5e9e7689e36e04c57c2385169Dmitri Plotnikov } else { 16011b7a7947242bb3b8caaed871775e62d486144c9fDmitri Plotnikov longValue = ((Number)value).longValue(); 1602f4e1358f1c8f5fe5e9e7689e36e04c57c2385169Dmitri Plotnikov } 1603f4e1358f1c8f5fe5e9e7689e36e04c57c2385169Dmitri Plotnikov toValues.put(toKey, longValue); 1604f4e1358f1c8f5fe5e9e7689e36e04c57c2385169Dmitri Plotnikov } 1605f4e1358f1c8f5fe5e9e7689e36e04c57c2385169Dmitri Plotnikov } 1606f4e1358f1c8f5fe5e9e7689e36e04c57c2385169Dmitri Plotnikov 160735ed95769096bb5dd406ad7d1fcaa49a0e35a307Fred Quintana public SyncStateContentProviderHelper getSyncState() { 160835ed95769096bb5dd406ad7d1fcaa49a0e35a307Fred Quintana return mSyncState; 160935ed95769096bb5dd406ad7d1fcaa49a0e35a307Fred Quintana } 1610c70dc0e38ff82c6e6d6b7458637c54fbdf446aacDmitri Plotnikov 1611c70dc0e38ff82c6e6d6b7458637c54fbdf446aacDmitri Plotnikov /** 1612c70dc0e38ff82c6e6d6b7458637c54fbdf446aacDmitri Plotnikov * Delete the aggregate contact if it has no constituent raw contacts other 1613c70dc0e38ff82c6e6d6b7458637c54fbdf446aacDmitri Plotnikov * than the supplied one. 1614c70dc0e38ff82c6e6d6b7458637c54fbdf446aacDmitri Plotnikov */ 1615c70dc0e38ff82c6e6d6b7458637c54fbdf446aacDmitri Plotnikov public void removeContactIfSingleton(long rawContactId) { 1616c70dc0e38ff82c6e6d6b7458637c54fbdf446aacDmitri Plotnikov SQLiteDatabase db = getWritableDatabase(); 1617c70dc0e38ff82c6e6d6b7458637c54fbdf446aacDmitri Plotnikov 1618c70dc0e38ff82c6e6d6b7458637c54fbdf446aacDmitri Plotnikov // Obtain contact ID from the supplied raw contact ID 1619c70dc0e38ff82c6e6d6b7458637c54fbdf446aacDmitri Plotnikov String contactIdFromRawContactId = "(SELECT " + RawContacts.CONTACT_ID + " FROM " 1620c70dc0e38ff82c6e6d6b7458637c54fbdf446aacDmitri Plotnikov + Tables.RAW_CONTACTS + " WHERE " + RawContacts._ID + "=" + rawContactId + ")"; 1621c70dc0e38ff82c6e6d6b7458637c54fbdf446aacDmitri Plotnikov 1622c70dc0e38ff82c6e6d6b7458637c54fbdf446aacDmitri Plotnikov // Find other raw contacts in the same aggregate contact 1623c70dc0e38ff82c6e6d6b7458637c54fbdf446aacDmitri Plotnikov String otherRawContacts = "(SELECT contacts1." + RawContacts._ID + " FROM " 1624c70dc0e38ff82c6e6d6b7458637c54fbdf446aacDmitri Plotnikov + Tables.RAW_CONTACTS + " contacts1 JOIN " + Tables.RAW_CONTACTS + " contacts2 ON (" 1625c70dc0e38ff82c6e6d6b7458637c54fbdf446aacDmitri Plotnikov + "contacts1." + RawContacts.CONTACT_ID + "=contacts2." + RawContacts.CONTACT_ID 1626c70dc0e38ff82c6e6d6b7458637c54fbdf446aacDmitri Plotnikov + ") WHERE contacts1." + RawContacts._ID + "!=" + rawContactId + "" 1627c70dc0e38ff82c6e6d6b7458637c54fbdf446aacDmitri Plotnikov + " AND contacts2." + RawContacts._ID + "=" + rawContactId + ")"; 1628c70dc0e38ff82c6e6d6b7458637c54fbdf446aacDmitri Plotnikov 1629c70dc0e38ff82c6e6d6b7458637c54fbdf446aacDmitri Plotnikov db.execSQL("DELETE FROM " + Tables.CONTACTS 1630c70dc0e38ff82c6e6d6b7458637c54fbdf446aacDmitri Plotnikov + " WHERE " + Contacts._ID + "=" + contactIdFromRawContactId 1631c70dc0e38ff82c6e6d6b7458637c54fbdf446aacDmitri Plotnikov + " AND NOT EXISTS " + otherRawContacts + ";"); 1632c70dc0e38ff82c6e6d6b7458637c54fbdf446aacDmitri Plotnikov } 16334a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov 16344a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov /** 16354a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov * Check if {@link Binder#getCallingUid()} should be allowed access to 16364a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov * {@link RawContacts#IS_RESTRICTED} data. 16374a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov */ 1638d91272b48f97243533c6580981e12a4847b5783fJeff Hamilton boolean hasAccessToRestrictedData() { 16394a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov final PackageManager pm = mContext.getPackageManager(); 16404a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov final String[] callerPackages = pm.getPackagesForUid(Binder.getCallingUid()); 16414a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov 16424a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov // Has restricted access if caller matches any packages 16434a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov for (String callerPackage : callerPackages) { 1644d91272b48f97243533c6580981e12a4847b5783fJeff Hamilton if (hasAccessToRestrictedData(callerPackage)) { 1645763100dcfabb368e72f25d24fe181c352bdb66d6Evan Millar return true; 1646763100dcfabb368e72f25d24fe181c352bdb66d6Evan Millar } 1647763100dcfabb368e72f25d24fe181c352bdb66d6Evan Millar } 1648763100dcfabb368e72f25d24fe181c352bdb66d6Evan Millar return false; 1649763100dcfabb368e72f25d24fe181c352bdb66d6Evan Millar } 1650763100dcfabb368e72f25d24fe181c352bdb66d6Evan Millar 1651763100dcfabb368e72f25d24fe181c352bdb66d6Evan Millar /** 1652763100dcfabb368e72f25d24fe181c352bdb66d6Evan Millar * Check if requestingPackage should be allowed access to 1653763100dcfabb368e72f25d24fe181c352bdb66d6Evan Millar * {@link RawContacts#IS_RESTRICTED} data. 1654763100dcfabb368e72f25d24fe181c352bdb66d6Evan Millar */ 1655d91272b48f97243533c6580981e12a4847b5783fJeff Hamilton boolean hasAccessToRestrictedData(String requestingPackage) { 1656d91272b48f97243533c6580981e12a4847b5783fJeff Hamilton if (mUnrestrictedPackages != null) { 1657d91272b48f97243533c6580981e12a4847b5783fJeff Hamilton for (String allowedPackage : mUnrestrictedPackages) { 1658d91272b48f97243533c6580981e12a4847b5783fJeff Hamilton if (allowedPackage.equals(requestingPackage)) { 1659d91272b48f97243533c6580981e12a4847b5783fJeff Hamilton return true; 1660d91272b48f97243533c6580981e12a4847b5783fJeff Hamilton } 16614a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov } 16624a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov } 16634a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov return false; 16644a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov } 16654a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov 16664a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov public String getDataView() { 1667d237c80845d8e13164d34278d3c20e31f8d80b4dDaisuke Miyakawa return getDataView(false); 1668d237c80845d8e13164d34278d3c20e31f8d80b4dDaisuke Miyakawa } 1669d237c80845d8e13164d34278d3c20e31f8d80b4dDaisuke Miyakawa 1670d237c80845d8e13164d34278d3c20e31f8d80b4dDaisuke Miyakawa public String getDataView(boolean requireRestrictedView) { 1671d91272b48f97243533c6580981e12a4847b5783fJeff Hamilton return (hasAccessToRestrictedData() && !requireRestrictedView) ? 1672d237c80845d8e13164d34278d3c20e31f8d80b4dDaisuke Miyakawa Views.DATA_ALL : Views.DATA_RESTRICTED; 16734a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov } 16744a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov 16754a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov public String getRawContactView() { 1676763100dcfabb368e72f25d24fe181c352bdb66d6Evan Millar return getRawContactView(false); 1677763100dcfabb368e72f25d24fe181c352bdb66d6Evan Millar } 1678763100dcfabb368e72f25d24fe181c352bdb66d6Evan Millar 1679763100dcfabb368e72f25d24fe181c352bdb66d6Evan Millar public String getRawContactView(boolean requireRestrictedView) { 1680d91272b48f97243533c6580981e12a4847b5783fJeff Hamilton return (hasAccessToRestrictedData() && !requireRestrictedView) ? 1681763100dcfabb368e72f25d24fe181c352bdb66d6Evan Millar Views.RAW_CONTACTS_ALL : Views.RAW_CONTACTS_RESTRICTED; 16824a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov } 16834a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov 16844a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov public String getContactView() { 1685763100dcfabb368e72f25d24fe181c352bdb66d6Evan Millar return getContactView(false); 16864a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov } 16874a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov 1688763100dcfabb368e72f25d24fe181c352bdb66d6Evan Millar public String getContactView(boolean requireRestrictedView) { 1689d91272b48f97243533c6580981e12a4847b5783fJeff Hamilton return (hasAccessToRestrictedData() && !requireRestrictedView) ? 1690763100dcfabb368e72f25d24fe181c352bdb66d6Evan Millar Views.CONTACTS_ALL : Views.CONTACTS_RESTRICTED; 1691f9aeb84d61c01a473819e9173f8311ca5d678a8dJeff Sharkey } 1692f9aeb84d61c01a473819e9173f8311ca5d678a8dJeff Sharkey 169389c626eb655440c86a2e5df076e83708c1b32c17Dmitri Plotnikov public String getGroupView() { 169489c626eb655440c86a2e5df076e83708c1b32c17Dmitri Plotnikov return Views.GROUPS_ALL; 169589c626eb655440c86a2e5df076e83708c1b32c17Dmitri Plotnikov } 169689c626eb655440c86a2e5df076e83708c1b32c17Dmitri Plotnikov 1697d237c80845d8e13164d34278d3c20e31f8d80b4dDaisuke Miyakawa public String getContactEntitiesView() { 1698d237c80845d8e13164d34278d3c20e31f8d80b4dDaisuke Miyakawa return getContactEntitiesView(false); 1699d237c80845d8e13164d34278d3c20e31f8d80b4dDaisuke Miyakawa } 1700d237c80845d8e13164d34278d3c20e31f8d80b4dDaisuke Miyakawa 1701d237c80845d8e13164d34278d3c20e31f8d80b4dDaisuke Miyakawa public String getContactEntitiesView(boolean requireRestrictedView) { 1702d91272b48f97243533c6580981e12a4847b5783fJeff Hamilton return (hasAccessToRestrictedData() && !requireRestrictedView) ? 1703d237c80845d8e13164d34278d3c20e31f8d80b4dDaisuke Miyakawa Tables.CONTACT_ENTITIES : Tables.CONTACT_ENTITIES_RESTRICTED; 1704d237c80845d8e13164d34278d3c20e31f8d80b4dDaisuke Miyakawa } 1705d237c80845d8e13164d34278d3c20e31f8d80b4dDaisuke Miyakawa 1706ff2de103f7e3eeeff4665ef63f07460fef053d6dDmitri Plotnikov /** 1707ff2de103f7e3eeeff4665ef63f07460fef053d6dDmitri Plotnikov * Test if any of the columns appear in the given projection. 1708ff2de103f7e3eeeff4665ef63f07460fef053d6dDmitri Plotnikov */ 1709ff2de103f7e3eeeff4665ef63f07460fef053d6dDmitri Plotnikov public boolean isInProjection(String[] projection, String... columns) { 171082bd858c9911dfbd8dca52dc276333768b0a429eDmitri Plotnikov if (projection == null) { 171182bd858c9911dfbd8dca52dc276333768b0a429eDmitri Plotnikov return true; 171282bd858c9911dfbd8dca52dc276333768b0a429eDmitri Plotnikov } 1713ff2de103f7e3eeeff4665ef63f07460fef053d6dDmitri Plotnikov 171482bd858c9911dfbd8dca52dc276333768b0a429eDmitri Plotnikov // Optimized for a single-column test 171582bd858c9911dfbd8dca52dc276333768b0a429eDmitri Plotnikov if (columns.length == 1) { 171682bd858c9911dfbd8dca52dc276333768b0a429eDmitri Plotnikov String column = columns[0]; 171782bd858c9911dfbd8dca52dc276333768b0a429eDmitri Plotnikov for (String test : projection) { 171882bd858c9911dfbd8dca52dc276333768b0a429eDmitri Plotnikov if (column.equals(test)) { 171982bd858c9911dfbd8dca52dc276333768b0a429eDmitri Plotnikov return true; 172082bd858c9911dfbd8dca52dc276333768b0a429eDmitri Plotnikov } 172182bd858c9911dfbd8dca52dc276333768b0a429eDmitri Plotnikov } 172282bd858c9911dfbd8dca52dc276333768b0a429eDmitri Plotnikov } else { 172382bd858c9911dfbd8dca52dc276333768b0a429eDmitri Plotnikov for (String test : projection) { 172482bd858c9911dfbd8dca52dc276333768b0a429eDmitri Plotnikov for (String column : columns) { 1725ff2de103f7e3eeeff4665ef63f07460fef053d6dDmitri Plotnikov if (column.equals(test)) { 1726ff2de103f7e3eeeff4665ef63f07460fef053d6dDmitri Plotnikov return true; 1727ff2de103f7e3eeeff4665ef63f07460fef053d6dDmitri Plotnikov } 1728ff2de103f7e3eeeff4665ef63f07460fef053d6dDmitri Plotnikov } 1729ff2de103f7e3eeeff4665ef63f07460fef053d6dDmitri Plotnikov } 1730ff2de103f7e3eeeff4665ef63f07460fef053d6dDmitri Plotnikov } 1731ff2de103f7e3eeeff4665ef63f07460fef053d6dDmitri Plotnikov return false; 17324a023070dab9a069be4cac5f5ba5554b66238484Dmitri Plotnikov } 1733b650982af7aeb2800efdcea587b8ce153259cf1cJeff Sharkey} 1734