diff options
author | Jay Shrauner <shrauner@google.com> | 2013-06-19 21:14:48 +0000 |
---|---|---|
committer | Android (Google) Code Review <android-gerrit@google.com> | 2013-06-19 21:14:49 +0000 |
commit | d621a10ce45c1f9e4f6caddc7aef5b2370d595b8 (patch) | |
tree | 859972ca02446d07a642e8f87c0b704655da94d1 /src/com | |
parent | d85dd8956d66febe975e3782288de4dff3f90d95 (diff) | |
parent | e31bbc395fc04e9c5f841e8e76475d98c8332271 (diff) | |
download | packages_providers_ContactsProvider-d621a10ce45c1f9e4f6caddc7aef5b2370d595b8.tar.gz packages_providers_ContactsProvider-d621a10ce45c1f9e4f6caddc7aef5b2370d595b8.tar.bz2 packages_providers_ContactsProvider-d621a10ce45c1f9e4f6caddc7aef5b2370d595b8.zip |
Merge "Add number presentation column to call log table"
Diffstat (limited to 'src/com')
-rw-r--r-- | src/com/android/providers/contacts/CallLogProvider.java | 1 | ||||
-rw-r--r-- | src/com/android/providers/contacts/ContactsDatabaseHelper.java | 35 |
2 files changed, 27 insertions, 9 deletions
diff --git a/src/com/android/providers/contacts/CallLogProvider.java b/src/com/android/providers/contacts/CallLogProvider.java index 519ea24a..e2b9ccef 100644 --- a/src/com/android/providers/contacts/CallLogProvider.java +++ b/src/com/android/providers/contacts/CallLogProvider.java @@ -69,6 +69,7 @@ public class CallLogProvider extends ContentProvider { sCallsProjectionMap = new HashMap<String, String>(); sCallsProjectionMap.put(Calls._ID, Calls._ID); sCallsProjectionMap.put(Calls.NUMBER, Calls.NUMBER); + sCallsProjectionMap.put(Calls.NUMBER_PRESENTATION, Calls.NUMBER_PRESENTATION); sCallsProjectionMap.put(Calls.DATE, Calls.DATE); sCallsProjectionMap.put(Calls.DURATION, Calls.DURATION); sCallsProjectionMap.put(Calls.TYPE, Calls.TYPE); diff --git a/src/com/android/providers/contacts/ContactsDatabaseHelper.java b/src/com/android/providers/contacts/ContactsDatabaseHelper.java index 6c791506..7229f48c 100644 --- a/src/com/android/providers/contacts/ContactsDatabaseHelper.java +++ b/src/com/android/providers/contacts/ContactsDatabaseHelper.java @@ -111,9 +111,10 @@ public class ContactsDatabaseHelper extends SQLiteOpenHelper { * 550-599 Honeycomb-MR2 * 600-699 Ice Cream Sandwich * 700-799 Jelly Bean + * 800-899 Key Lime Pie * </pre> */ - static final int DATABASE_VERSION = 710; + static final int DATABASE_VERSION = 800; private static final String DATABASE_NAME = "contacts2.db"; private static final String DATABASE_PRESENCE = "presence_db"; @@ -1254,6 +1255,8 @@ public class ContactsDatabaseHelper extends SQLiteOpenHelper { db.execSQL("CREATE TABLE " + Tables.CALLS + " (" + Calls._ID + " INTEGER PRIMARY KEY AUTOINCREMENT," + Calls.NUMBER + " TEXT," + + Calls.NUMBER_PRESENTATION + " INTEGER NOT NULL DEFAULT " + + Calls.PRESENTATION_ALLOWED + "," + Calls.DATE + " INTEGER," + Calls.DURATION + " INTEGER," + Calls.TYPE + " INTEGER," + @@ -2483,6 +2486,11 @@ public class ContactsDatabaseHelper extends SQLiteOpenHelper { oldVersion = 710; } + if (oldVersion < 800) { + upgradeToVersion800(db); + oldVersion = 800; + } + if (upgradeViewsAndTriggers) { createContactsViews(db); createGroupsView(db); @@ -3935,14 +3943,10 @@ public class ContactsDatabaseHelper extends SQLiteOpenHelper { } private void upgradeToVersion707(SQLiteDatabase db) { - db.execSQL("ALTER TABLE " + Tables.RAW_CONTACTS - + " ADD " + RawContactsColumns.PHONEBOOK_LABEL_PRIMARY + " TEXT;"); - db.execSQL("ALTER TABLE " + Tables.RAW_CONTACTS - + " ADD " + RawContactsColumns.PHONEBOOK_BUCKET_PRIMARY + " INTEGER;"); - db.execSQL("ALTER TABLE " + Tables.RAW_CONTACTS - + " ADD " + RawContactsColumns.PHONEBOOK_LABEL_ALTERNATIVE + " TEXT;"); - db.execSQL("ALTER TABLE " + Tables.RAW_CONTACTS - + " ADD " + RawContactsColumns.PHONEBOOK_BUCKET_ALTERNATIVE + " INTEGER;"); + db.execSQL("ALTER TABLE raw_contacts phonebook_label TEXT;"); + db.execSQL("ALTER TABLE raw_contacts ADD phonebook_bucket INTEGER;"); + db.execSQL("ALTER TABLE raw_contacts ADD phonebook_label_alt TEXT;"); + db.execSQL("ALTER TABLE raw_contacts ADD phonebook_bucket_alt INTEGER;"); } private void upgradeToVersion710(SQLiteDatabase db) { @@ -3968,6 +3972,19 @@ public class ContactsDatabaseHelper extends SQLiteOpenHelper { + "ON deleted_contacts(contact_deleted_timestamp)"); } + private void upgradeToVersion800(SQLiteDatabase db) { + // Default Calls.PRESENTATION_ALLOWED=1 + db.execSQL("ALTER TABLE calls ADD presentation INTEGER NOT NULL DEFAULT 1;"); + + // Re-map CallerInfo.{..}_NUMBER strings to Calls.PRESENTATION_{..} ints + // PRIVATE_NUMBER="-2" -> PRESENTATION_RESTRICTED=2 + // UNKNOWN_NUMBER="-1" -> PRESENTATION_UNKNOWN =3 + // PAYPHONE_NUMBER="-3" -> PRESENTATION_PAYPHONE =4 + db.execSQL("UPDATE calls SET presentation=2, number='' WHERE number='-2';"); + db.execSQL("UPDATE calls SET presentation=3, number='' WHERE number='-1';"); + db.execSQL("UPDATE calls SET presentation=4, number='' WHERE number='-3';"); + } + public String extractHandleFromEmailAddress(String email) { Rfc822Token[] tokens = Rfc822Tokenizer.tokenize(email); if (tokens.length == 0) { |