diff options
author | Android (Google) Code Review <android-gerrit@google.com> | 2009-10-13 16:28:35 -0400 |
---|---|---|
committer | Android (Google) Code Review <android-gerrit@google.com> | 2009-10-13 16:28:35 -0400 |
commit | 22d6a52eace0dab1e6a570bbfeb2b49c2858214f (patch) | |
tree | 66ddd5fe2873841ba52c2ff9c3319fdf9fafb31a | |
parent | 28fc68980c991f1367b5540ac54b99f6e8068e11 (diff) | |
parent | 47ab23770b9f010a5e5277cda68267fe0613a1cc (diff) | |
download | ContactsProvider-22d6a52eace0dab1e6a570bbfeb2b49c2858214f.tar.gz |
Merge change If9a8aee5 into eclairandroid-sdk-tools_r4android-sdk-tools_r3android-sdk-2.0_r1android-2.0_r1
* changes:
[Issue 2185274] Optimizing queries used by Google Voice
-rw-r--r-- | src/com/android/providers/contacts/ContactsDatabaseHelper.java | 7 | ||||
-rw-r--r-- | src/com/android/providers/contacts/LegacyApiSupport.java | 9 |
2 files changed, 13 insertions, 3 deletions
diff --git a/src/com/android/providers/contacts/ContactsDatabaseHelper.java b/src/com/android/providers/contacts/ContactsDatabaseHelper.java index 504e604b..6b22e206 100644 --- a/src/com/android/providers/contacts/ContactsDatabaseHelper.java +++ b/src/com/android/providers/contacts/ContactsDatabaseHelper.java @@ -61,7 +61,7 @@ import java.util.HashMap; /* package */ class ContactsDatabaseHelper extends SQLiteOpenHelper { private static final String TAG = "ContactsDatabaseHelper"; - private static final int DATABASE_VERSION = 102; + private static final int DATABASE_VERSION = 103; private static final String DATABASE_NAME = "contacts2.db"; private static final String DATABASE_PRESENCE = "presence_db"; @@ -1322,6 +1322,11 @@ import java.util.HashMap; oldVersion++; } + if (oldVersion == 102) { + LegacyApiSupport.createDatabase(db); + oldVersion++; + } + if (oldVersion != newVersion) { throw new IllegalStateException( "error upgrading the database to version " + newVersion); diff --git a/src/com/android/providers/contacts/LegacyApiSupport.java b/src/com/android/providers/contacts/LegacyApiSupport.java index 6654403b..a26881d5 100644 --- a/src/com/android/providers/contacts/LegacyApiSupport.java +++ b/src/com/android/providers/contacts/LegacyApiSupport.java @@ -20,6 +20,7 @@ import com.android.providers.contacts.ContactsDatabaseHelper.ExtensionsColumns; import com.android.providers.contacts.ContactsDatabaseHelper.GroupsColumns; import com.android.providers.contacts.ContactsDatabaseHelper.MimetypesColumns; import com.android.providers.contacts.ContactsDatabaseHelper.PhoneColumns; +import com.android.providers.contacts.ContactsDatabaseHelper.PhoneLookupColumns; import com.android.providers.contacts.ContactsDatabaseHelper.PresenceColumns; import com.android.providers.contacts.ContactsDatabaseHelper.RawContactsColumns; import com.android.providers.contacts.ContactsDatabaseHelper.StatusUpdatesColumns; @@ -637,10 +638,14 @@ public class LegacyApiSupport { + " AS " + android.provider.Contacts.Phones.TYPE + ", " + Tables.DATA + "." + Phone.LABEL + " AS " + android.provider.Contacts.Phones.LABEL + ", " + - PhoneColumns.CONCRETE_NORMALIZED_NUMBER + Tables.PHONE_LOOKUP + "." + PhoneLookupColumns.NORMALIZED_NUMBER + " AS " + android.provider.Contacts.Phones.NUMBER_KEY + ", " + peopleColumns + - " FROM " + Tables.DATA + DATA_JOINS + + " FROM " + Tables.DATA + + " JOIN " + Tables.PHONE_LOOKUP + + " ON (" + Tables.DATA + "._id = " + + Tables.PHONE_LOOKUP + "." + PhoneLookupColumns.DATA_ID + ")" + + DATA_JOINS + " WHERE " + MimetypesColumns.CONCRETE_MIMETYPE + "='" + Phone.CONTENT_ITEM_TYPE + "'" + " AND " + Tables.RAW_CONTACTS + "." + RawContacts.DELETED + "=0" |