History log of /packages/providers/CalendarProvider/src/com/android/providers/calendar/CalendarDatabaseHelper.java
Revision Date Author Comments (<<< Hide modified files) (Show modified files >>>)
503a798e5f76ecce75607277292bd9a326ba79ec 08-Jun-2015 Tony Mak <tonymak@google.com> Fix crash when inserting reminder/attendee/extended property to a non-existent event

The problem is when inserting reminder/attendee/extended property, the code assumes the event it belongs to exists.
However, it may not be true in some edge cases.
For example, user is on the event edit page, while the event is being deleted in server at this moment.

Add checking to confirm the event does exists before having the insert logic.
As all logics in insert is run within a single transaction, we can be assured that the event does exist throughout the transaction.

Bug: b2/13287671

Change-Id: I655720c67ab3176d52759c43032682874aa3eb8b
/packages/providers/CalendarProvider/src/com/android/providers/calendar/CalendarDatabaseHelper.java
d3b51e172bba03af7d2fcc3559cfa73b6ce60095 28-Oct-2013 Alon Albert <aalbert@google.com> Handle Missing Event Row

When checking for Calendars.CAN_PARTIALLY_UPDATE in duplicateEvent() , don't
crash if there is no matching event id in the db.

Bug: 11392862
Change-Id: I895c3a307b842c4340c851da27c25951d3e7968f
/packages/providers/CalendarProvider/src/com/android/providers/calendar/CalendarDatabaseHelper.java
7a2531a4b68e9efe14353cc7f4a64a8c5613e5d3 18-Dec-2012 Alon Albert <aalbert@google.com> Put some useful information in User-Agent Header

Put information in User-Agent:
* Build fingerprint
* Calendar or CalendarSyncAdapter package name + version code
* Package name of app making changes to provider for uphill syncs

Example:
google/mantaray/manta:K/MASTER/eng.aalbert.20121217.140040:eng/dev-keys:com.google.android.calendar:201212060:com.google.android.calendar Google-HTTP-Java-Client/1.11.0-beta (gzip)

Change-Id: I729c64ba9b922523d35903fcaf2a51cc234799a8
/packages/providers/CalendarProvider/src/com/android/providers/calendar/CalendarDatabaseHelper.java
501e60bcb1b519d80723f7b64ba60bd079b8ec8d 17-Sep-2012 Sara Ting <sarating@google.com> Adding new column 'uid2445' to Events table to support future handling of ical/ics format.

Bug:7029852
Change-Id: Ie2e5c0126583a68d2da81b6cc7c0101e29eb0649
/packages/providers/CalendarProvider/src/com/android/providers/calendar/CalendarDatabaseHelper.java
b2695bf3cfb173c4c5ba7bfd3c93ba8a51d65810 18-Sep-2012 Alon Albert <aalbert@google.com> Add some columns

isPrimary to Calendars
isOrganizer to Events

Bug: 6888477

Change-Id: I6ea7d69eec4a7226bf3e9fac216a31b5cd170782
/packages/providers/CalendarProvider/src/com/android/providers/calendar/CalendarDatabaseHelper.java
0332925aa9db8c4826327edd85030a4791b7a8e6 29-Apr-2012 Michael Chan <chanm@google.com> Fixed so potential memory leaks.

Bug: 6396900
Change-Id: Id02c323b567bfc49ae1da4dbe4335ba150241232
/packages/providers/CalendarProvider/src/com/android/providers/calendar/CalendarDatabaseHelper.java
c81732aeadada8f8bc4c216a317ba458374af2c9 21-Apr-2012 Michael Chan <chanm@google.com> Add support for custom app and uri in events

Bug: 6325441
Change-Id: If4a0f855e21d10aa63be67c5bb702618b776b29b
/packages/providers/CalendarProvider/src/com/android/providers/calendar/CalendarDatabaseHelper.java
bafe9de156292f65b1079dd1eb586669f573d9e6 18-Apr-2012 Michael Chan <chanm@google.com> Add support for identity in attendees

Bug: 6353721
Change-Id: If167941b90b256073444f2660df2360f79872276
/packages/providers/CalendarProvider/src/com/android/providers/calendar/CalendarDatabaseHelper.java
0d8699eedb0f3bcec1854b9753ae59154a122726 03-Mar-2012 Michael Chan <chanm@google.com> Drop all table when downgrading

Change-Id: I172d82eabeaa0f55831da9d105beb995ad1c3448
/packages/providers/CalendarProvider/src/com/android/providers/calendar/CalendarDatabaseHelper.java
ff5d02de9fddecbd5649f243233514e256a705c2 24-Mar-2012 Isaac Katzenelson <isaack@android.com> Fix original sync id bug in event exceptions

Bug: 6168812 original_id and/or original_sync_id may be wrong when there are multiple accounts
Change-Id: Icdc77abcc492a28b1ed04931f53b0ee9d8bffda8
/packages/providers/CalendarProvider/src/com/android/providers/calendar/CalendarDatabaseHelper.java
c339afc7df041ebfc5f4587f78cf38562aa23459 02-Mar-2012 Alon Albert <aalbert@google.com> Add displayColor column to view_events
Also fix bug with color change triggers

Change-Id: I0b62fb966cd9f24f47646c3a3613403e4ff4cc1e
/packages/providers/CalendarProvider/src/com/android/providers/calendar/CalendarDatabaseHelper.java
9adfc5e7e2c0b41ba2f53eb2397886dd61ec5f8a 05-Dec-2011 Andy McFadden <fadden@android.com> am 6d38c46e: am 3ac8148c: Speed up database update

* commit '6d38c46ea04674a1cbfafd04a0313a65f915c9f3':
Speed up database update
3ac8148cdc79bde4b009ccb6a9ffda77bdb547d3 03-Dec-2011 Andy McFadden <fadden@android.com> Speed up database update

Drop the trigger on sync_id before doing a bulk update of sync_id
fields. This dramatically reduces the time required for the
calendar database update when there are lots of events.

Bug 5699796

Change-Id: I94c2fb624b5b63bfdf760b3092697f9205a634c9
/packages/providers/CalendarProvider/src/com/android/providers/calendar/CalendarDatabaseHelper.java
457ecf55b9d83b7fbd99f7707eea2d10ee2bd551 01-Nov-2011 Alon Albert <aalbert@google.com> Don't schedule a sync with SYNC_EXTRAS_MANUAL from the provider. This flag ignores the sync settings for the account

Bug: 5433356
Change-Id: Ie07e2147ac9feed5ed6f53c9ae239532de8d8e86
/packages/providers/CalendarProvider/src/com/android/providers/calendar/CalendarDatabaseHelper.java
387535fec9f646e0b7acb82d5354f2b5ebee4395 27-Oct-2011 RoboErik <epastern@google.com> change COLOR_INDEX to COLOR_KEY

for https://android-git.corp.google.com/g/#/c/145200/

Change-Id: I90355ff4ed0ebebc7701dbec485087034e0ad338
/packages/providers/CalendarProvider/src/com/android/providers/calendar/CalendarDatabaseHelper.java
2f251c778c06d21ed7693a70f4a1268ff929242e 18-Oct-2011 RoboErik <epastern@google.com> Adds a Colors table to the db and updates events/cals tables

This adds provider support for the new set of APIs being added
for colors. Adds allowedAvailability and allowedAttendeeType
to the Calendars table. Also removes old code for handling event
specific time zones before the server supported it.

Cherry pick of https://android-git.corp.google.com/g/#/c/143430/

Change-Id: I2e28350338657641f8a736bcedfbc1df92f5a5fd
/packages/providers/CalendarProvider/src/com/android/providers/calendar/CalendarDatabaseHelper.java
1c72909abbfe7559bcc880c339399f1eaa0478f3 08-Oct-2011 Andy McFadden <fadden@android.com> Auto-update Events.hasAlarm

The "hasAlarm" column in the Events table is supposed to be read-only
for applications, updated automatically by the provider as reminders
are added and deleted. This wasn't implemented (the Calendar app was
doing it manually).

Bug 5424486

Change-Id: Id4d167fe081b77fbd514b9a700359fd84d9e43e8
/packages/providers/CalendarProvider/src/com/android/providers/calendar/CalendarDatabaseHelper.java
bf986d8deeeed9566e0badeba89d4800533cbca6 04-Aug-2011 Andy McFadden <fadden@android.com> Correct allowedReminders defaults

This reduces the default set of allowed reminders to {default,alert},
and adds an upgrade step that expands the set to include email when
the calendar is a Google calendar.

Bug 5117661

Change-Id: I094858b16cc1f0ca8bd0aefd48124997079800b3
/packages/providers/CalendarProvider/src/com/android/providers/calendar/CalendarDatabaseHelper.java
7544af675ce2fd78f33198e5e9194f2bc7bd129f 01-Aug-2011 Andy McFadden <fadden@android.com> Recognize new-old database versions

Correcting the orphaned Attendees / Reminders issue in older
releases required introducing new database versions. We need to
recognize these.

Bug 5063315

Change-Id: Ibd1af65c5f24728f3b73a3b33ce529bbca010799
/packages/providers/CalendarProvider/src/com/android/providers/calendar/CalendarDatabaseHelper.java
935132618f821883f101db31af24e6d4c2b1e82c 29-Jul-2011 Andy McFadden <fadden@android.com> Avoid re-use of orphaned data

Data is being added to Attendees and Reminders that is associated
with delete Events. When the Event ID is re-used, the orphaned
data attaches to the new event. To avoid this, change the Event
ID column to "autoincrement", ensuring that IDs are never re-used.

At database upgrade time, delete any orphaned rows.

Bug 5063315

Change-Id: I02051bf271ea9b9fd05c27e50f546177f42f43d0
/packages/providers/CalendarProvider/src/com/android/providers/calendar/CalendarDatabaseHelper.java
470aa5bc291ca33d51dda356f38ac2954026da9a 13-Jun-2011 Alon Albert <aalbert@google.com> Upgrade database for GData 2 & Partial Update for Google accounts.

* Change event id's from ".../private/full/... to .../events/...
* Set Calendars.canPartiallyUpdate to 1 to support partial updates
* Nuke sync state so we re-sync with a fresh etag and edit url

Also re-add DIRTY to sEventEntitiesProjectionMap after it was dropped
by accident in a previous CL.

Change-Id: Ic3fed903c76ce94fb2b60ba746f4bd31b3df23f4
/packages/providers/CalendarProvider/src/com/android/providers/calendar/CalendarDatabaseHelper.java
b9644fe24edf9e25f0b21c1394e88d25070e0238 14-Jun-2011 RoboErik <epastern@google.com> Rename Calendar.java to CalendarContract.java

Change-Id: Iecdf0141d6baeed4a93b4f219a72f7ed8a5b9ff3
/packages/providers/CalendarProvider/src/com/android/providers/calendar/CalendarDatabaseHelper.java
02f97c538fc46a08d857d2c807c76fd0eec12493 08-Jun-2011 RoboErik <epastern@google.com> Upgrade db to v305

-Add CAL_SYNC columns up to 10
-Rename Calendars.access_level to calendar_access_level
-Rename calendars _sync_version to cal_sync7
-Rename calendars _sync_time to cal_sync8
-Rename displayName to calendar_displayName
-Rename _sync_local_id to sync_data2
-Rename htmlUri to sync_data3
-Rename events _sync_version to sync_data4
-Rename events _sync_time to sync_data5
-Rename commentsUri to sync_data6
-Migrate Events _sync_mark to sync_data8
-Change sync_data2 from INTEGER to TEXT
-Change sync_data8 from INTEGER to TEXT
-Add SYNC_DATA columns up to 10
-Add EVENT_COLOR to Events table

Change-Id: I2b818bf54fbce57cb32918d239ec21035a499330
/packages/providers/CalendarProvider/src/com/android/providers/calendar/CalendarDatabaseHelper.java
bcba82631ab0ee16efe58f0e0b0b9c18d93a6fd2 24-May-2011 Andy McFadden <fadden@android.com> First cut at recurring event exception API

This adds two calls to the calendar provider:

insert(<baseURI>/exception/<original-event-id>)

This creates an exception to a recurring event. Depending on the
values provided, this may alter all instances, all future instances,
or just a single instance of the event.

delete(<baseURI>/exception/<original-event-id>/<exception-event-id>)

This deletes an exception to a recurring event.

Bug 4473786

Change-Id: I9bff5de24694dcd49d2036c6c99dd45b34b24c0f
/packages/providers/CalendarProvider/src/com/android/providers/calendar/CalendarDatabaseHelper.java
9ec70fada3d8f7cf56d6b0d0947823ec5bce572c 04-Jun-2011 Alon Albert <aalbert@google.com> Prepare Calendar Provider for GData 2.0 & Partial Update

This CL prepares support for GData 2.0 by adding the _SYNC_7 column to the Events table.
This column will contain the edit URL which used to be in SYNC_VERSION but in 2.0, will hold the eTag instead.

It also prepares for Partial Update by adding a column called lastSynced to Events & a column called canPartiallyUpdate to Calendars.
If a sync adapter sets canPartiallyUpdate to 1, the provider will dup events before modifying them locally and mark them as dups using the lastSynced column.
When a sync adapter then updates an event and sets DIRTY to 0, the provider will remove the duplicated event.

Since no sync adapters yet set canPartiallyUpdate or use SYNC_7, this change should effectivly be a NOP.

Change-Id: I651056b3c0306391e9e559ceb185e77187118846
/packages/providers/CalendarProvider/src/com/android/providers/calendar/CalendarDatabaseHelper.java
fa332ecedc0c340109811552407142f6e4f600b2 31-May-2011 RoboErik <epastern@google.com> Migrate syncN columns to cal_syncN

Change-Id: I2d7aa19c55f95cd9256a5c7289e6214d4bff3d5d
/packages/providers/CalendarProvider/src/com/android/providers/calendar/CalendarDatabaseHelper.java
da641c374b00946f37bfe00e53bb292f4e0103d8 25-May-2011 RoboErik <epastern@google.com> b/4466577 Migrate eventEndTimezone to sync_data1 for EAS

Change-Id: I02b3771e39c6e5e81dde05480683b5d5a991997f
/packages/providers/CalendarProvider/src/com/android/providers/calendar/CalendarDatabaseHelper.java
34c32cd924eb8ee28381106b37044b78fd8cbc30 14-May-2011 RoboErik <epastern@google.com> Add original_id column + logic. db -> v301

Adds an original_id to the Events table for local reference to
an original event for exceptions. It also adds logic to keep this
value in sync with the original_sync_id so apps don't have to
update for it to continue working.

Change-Id: I0034ecedb6f7b582ba823daab8656b7778781d84
/packages/providers/CalendarProvider/src/com/android/providers/calendar/CalendarDatabaseHelper.java
c8383567db3ade2aea28447ad3bd09ac3033bcd7 06-May-2011 RoboErik <epastern@google.com> Upgrade Calendars table and db to v300

Changes several column names in the calendars table and jumps
the versioning for the db up to 300.

Change-Id: I515b3e0a54d73c8a6d25ca2d9f7c153fae68a210
/packages/providers/CalendarProvider/src/com/android/providers/calendar/CalendarDatabaseHelper.java
180076a810558478f55ade53ebef0a2ddfa6bbc0 25-Apr-2011 Andy McFadden <fadden@android.com> Rename function

createCalendarsTable201() was actually creating 202.

Change-Id: I399465b912bfcdb22363ac82b7772247afbb1274
/packages/providers/CalendarProvider/src/com/android/providers/calendar/CalendarDatabaseHelper.java
d5f4742d7ba16d791edd9fd33a1a2a42eeac709b 19-Apr-2011 RoboErik <epastern@google.com> Adds test to compare schema of upgraded and new db

Change-Id: I3a27b9eadb01fff9459b179a28100bb014a24785
/packages/providers/CalendarProvider/src/com/android/providers/calendar/CalendarDatabaseHelper.java
4067700dbedcf4c8a379c9ecba9b5603972b4607 19-Apr-2011 Andy McFadden <fadden@android.com> Update calendar database schema

This increases the version from 204 to 205, and includes these changes:
- rename+reorder "_sync_mark" to "sync6" (changing type from INTEGER to TEXT)
- rename "selected" to "visible"
- rename "organizerCanRespond" to "canOrganizerRespond"
- add "canModifyTimeZone"
- add "maxReminders"
- remove "_sync_local_id" (a/k/a _SYNC_DATA)

This CL will be accompanied by changes to:
frameworks/base
packages/apps/Calendar
packages/apps/Exchange
vendor/google
vendor/unbundled_google/packages/GoogleCalendarSyncAdapter

Change-Id: Idc82c26819432ac8756230a4fb0dd8165d255f27
/packages/providers/CalendarProvider/src/com/android/providers/calendar/CalendarDatabaseHelper.java
2cff10f1a005bd7302245d4c680cf851193c3a97 15-Apr-2011 RoboErik <epastern@google.com> Inlines all the fields used during upgrade and tests

W/o inline, changing the fields will cause any old update code that
uses them to break without warning. Added a test forupgrading all
the way from v50 to the current version and fixed some bugs that
showed up as a result of the test.

Change-Id: I3673c784bfbe38d65d2a04b7e5aaeaf8cdcb21fa
/packages/providers/CalendarProvider/src/com/android/providers/calendar/CalendarDatabaseHelper.java
c4d44fd028e7f5f44f46439c3410dab3456e6d3f 05-Nov-2010 Fabrice Di Meglio <fdimeglio@google.com> Fix bug #1776278 (consider supplying our own (unique) eid for calendar entries created on the device)

- change schema for adding SYNC_ADAPTER_DATA into the Events view
- put the "gCal:uid" value into the Events.SYNC_ADAPTER_DATA column

Change-Id: I08788e9cd6d899c00d77a9b4b7f61d36a1e40aa3
/packages/providers/CalendarProvider/src/com/android/providers/calendar/CalendarDatabaseHelper.java
258fc0a0054d6aba8556921c270379cea6bf3de1 13-Oct-2010 Fabrice Di Meglio <fdimeglio@google.com> More code cleaning

- use table / columns constants where they were missing

Change-Id: I3a72e88bf0c70919bd7590a9e067053cb24b5d85
/packages/providers/CalendarProvider/src/com/android/providers/calendar/CalendarDatabaseHelper.java
deefe0733f0e52fc68f7234ba765163545880e41 08-Oct-2010 Bjorn Bringert <bringert@android.com> cal: Move SyncStateContentProviderHelper to frameworks/ex

Change-Id: I086fc7ea7ef62f24c138ba7d26da3a0f48919862
/packages/providers/CalendarProvider/src/com/android/providers/calendar/CalendarDatabaseHelper.java
c2d2953fa4ac4bf9066f40d97858e69e519269f1 01-Oct-2010 Fabrice Di Meglio <fdimeglio@google.com> resolved conflicts for merge of 3443e3eb to master

Change-Id: I3ae69d380d1fefd4cb69e7e0d234fc424914020d
3443e3ebeaa39e8415b43e7cf3b218caee554e9b 30-Sep-2010 Fabrice Di Meglio <fdimeglio@google.com> Fix bug #3025267 (Calendar App TZ are messed up when using Secondary TZ feature in Web Calendar)

- updateEventsStartEndFromEventRawTimesLocked() is now using the Event's timezone instead of the device one
- update unit tests

Fixed also cleaning of old CalendarCache data.

Change-Id: Ia7d543eda26a4a0dee1d7174f84d0f50097b81b0
/packages/providers/CalendarProvider/src/com/android/providers/calendar/CalendarDatabaseHelper.java
2c59eec67ab5a46ddb1ca9284f1116c1fd821a33 24-Sep-2010 Fabrice Di Meglio <fdimeglio@google.com> Fix but #2942211 (Suppress CalendarDatabaseHelpder code that deals with versions...)

- remove upgrade code for obsolete versions 72, 73, 74

Change-Id: Ib49828a80be18bb3291be0bd644c72b3120166fa
/packages/providers/CalendarProvider/src/com/android/providers/calendar/CalendarDatabaseHelper.java
9ea309741d32d9634a0eb6786f1cc3057d3f82a6 23-Sep-2010 Fabrice Di Meglio <fdimeglio@google.com> Fix bug #3029831 (Finalizing a Cursor that has not been deactivated or closed. database...) - DO NOT MERGE

- add missing cursor.close() statement

Change-Id: I5a4287a6944bbc3091d30af45480e863405a8316
/packages/providers/CalendarProvider/src/com/android/providers/calendar/CalendarDatabaseHelper.java
58313767dd0e7e3823c35ca61b40eddb9dd229bb 23-Sep-2010 Fabrice Di Meglio <fdimeglio@google.com> Fix bug #3029831 (Finalizing a Cursor that has not been deactivated or closed. database...)

- add missing cursor.close() statement

Change-Id: Id37be1d7b83049c090c4a83d5b690844c2bf561c
/packages/providers/CalendarProvider/src/com/android/providers/calendar/CalendarDatabaseHelper.java
315d9326acd39566959f3c547225483f1fb6aefc 11-Sep-2010 Fabrice Di Meglio <fdimeglio@google.com> Manually merge "Add home timezone support" from Gingerbread:

- add querying CalendarCache key/values thru CalendarProvider
- add unit tests

Change-Id: I21bf5935789c663ba01409142df734007c5a3a4e
/packages/providers/CalendarProvider/src/com/android/providers/calendar/CalendarDatabaseHelper.java
68040cf2602bb15bb4cf1072cf99132118d5a805 03-Sep-2010 Fabrice Di Meglio <fdimeglio@google.com> Add home timezone support - DO NOT MERGE

- add querying CalendarCache key/values thru CalendarProvider
- add unit tests

Change-Id: I87da6b5174c800dca76d3965a7d7cb8953003e1a
/packages/providers/CalendarProvider/src/com/android/providers/calendar/CalendarDatabaseHelper.java
b492524403ca34b0cb03bfad6456909494479925 21-Aug-2010 Fabrice Di Meglio <fdimeglio@google.com> Merge Froyo fix for CalendarCache init (Change I268be53d)

- update database schema version to 200 (need room for potential Gingerbread updates)
- fix initial row insert into CalendarCache table
- recreate the CalendarCache table with correct data when upgrading the schema
- make old 72/73/74 versions numbers obsolete on Honeycomb

Change-Id: Iaba940798ce1677d02efad342f79a9ce00be45ad
/packages/providers/CalendarProvider/src/com/android/providers/calendar/CalendarDatabaseHelper.java
a2f46bd2223d1bdad7ecd69803288493f73bc4bc 20-Aug-2010 Fabrice Di Meglio <fdimeglio@google.com> Merge Froyo fix for CalendarCache init (Change I268be53d) - DO NOT MERGE

- update database schema version to 100 (need room for potential Froyo updates)
- fix initial row insert into CalendarCache table
- recreate the CalendarCache table with correct data when upgrading the schema

Change-Id: I5d6844c3a10fdf63aedd9e7b7952cae144d6c35e
/packages/providers/CalendarProvider/src/com/android/providers/calendar/CalendarDatabaseHelper.java
81d904d66bd746c077cc0baa6cf1f51fe030eac4 13-Jul-2010 Mason Tang <masontang@google.com> Added event search to the provider, fixed provider unit tests

- Implemented using LIKE pattern matching, no changes to the database
- This is completely transparent to the database itself
- The CalendarProvider2 unit tests will now pass...sometimes

Change-Id: I47f8285ad97edb6943951a563eaf9c5df83043d9
/packages/providers/CalendarProvider/src/com/android/providers/calendar/CalendarDatabaseHelper.java
7e7329964ddd60c98e93a7eda18b68944a630382 16-Jul-2010 Fabrice Di Meglio <fdimeglio@google.com> Fix bug #2846543 Delete HIDDEN column from the "Calendars" table

- delete the "hidden" column and udpate the schema version for adding the "sync5" column

Change-Id: Ibeba3ab547626b4f6f8a0cb0f2dd49874e4d73d6
/packages/providers/CalendarProvider/src/com/android/providers/calendar/CalendarDatabaseHelper.java
836bc8e9da32b8231f1b0d57be271730d7a5368d 08-Jul-2010 Fabrice Di Meglio <fdimeglio@google.com> Fix bug #2793828 (Sync/visible setting on the phone should not affect what's visible on the web.)

- introduce "sync4" column into Calendars table to store "selected" from Web calendar

Change-Id: I29e8dc07969a4bc605cdfb4159c33cc5841b0c2e
/packages/providers/CalendarProvider/src/com/android/providers/calendar/CalendarDatabaseHelper.java
1fc162fc3a3bb466a39146cf59a8b51ec5d9de52 08-Jul-2010 Fabrice Di Meglio <fdimeglio@google.com> Fix calendar database update to version 72

- need to delete the trigger as it is still there even after altering the table name

Change-Id: I03633c204c8667de5cb39a08996d2c4caddede72
/packages/providers/CalendarProvider/src/com/android/providers/calendar/CalendarDatabaseHelper.java
1b6beb61ef04c3da6ab0bdf8504ffecea2b9534c 30-Jun-2010 Fabrice Di Meglio <fdimeglio@google.com> Fix bug #2779582 (Columns cleanup for the Calendars table)

- suppress deprecated "url" column
- replace eventsUrl / editUrl / selfUrl columns by sync1 / sync2 / sync3
- upgrade database

Change-Id: I03553dd926374f1125650db90af6ac4156261e8a
/packages/providers/CalendarProvider/src/com/android/providers/calendar/CalendarDatabaseHelper.java
bedfbe0065e48c652814bd3b864dabf7589f344b 17-Jun-2010 Fabrice Di Meglio <fdimeglio@google.com> Fix broken AFTER_EVENT_INSERT_SQL trigger for CalendarDatabaseHelper

- was broken in https://android-git.corp.google.com/g/#change,54504

as part of fix for http://b/2772317

Change-Id: I11d3ed62a2cd3f16edab2eb25ec3edd7abe41e28
/packages/providers/CalendarProvider/src/com/android/providers/calendar/CalendarDatabaseHelper.java
c59a6b5d8ff6b941fc44e9181e668fe0ec7df088 16-Jun-2010 Fabrice Di Meglio <fdimeglio@google.com> Fix bug #2772731 (Start deprecation of "url" Calendars column in favor of "eventsUrl" column)

- suppress references to Calendars.URL

Change-Id: I40ffe3ca5c6113bc09802521f1c4b35eb8c67d80
/packages/providers/CalendarProvider/src/com/android/providers/calendar/CalendarDatabaseHelper.java
7cb72fa3ea680dce378d8dac71f878e52e03f83a 16-Jun-2010 Fabrice Di Meglio <fdimeglio@google.com> Fix bug# 2772317 (CalendarDatabaseHelper internal cleanup)

- use constants defined into Calendar interfaces

Change-Id: Ia1e87e0605c75619677826fc8a1dcadbe0973ca6
/packages/providers/CalendarProvider/src/com/android/providers/calendar/CalendarDatabaseHelper.java
43b3eba05ef67bdd4b0a2b285b6ed2b377c136c5 22-May-2010 Fabrice Di Meglio <fdimeglio@google.com> Fix bug #1661857 (switch from using meta feed to the new allcalendars feed)

- add support for new database schema for Calendars table (new columns: selfUrl, editUrl, alternateUrl, eventsUrl)
- add database upgrade code
- update Events.DELETE constant
- add Calendars Entity support

Change-Id: I040d153ce9ba15f77b582c083a79ea6e8e777535
/packages/providers/CalendarProvider/src/com/android/providers/calendar/CalendarDatabaseHelper.java
25b0f0ee070a5fff18cfcaffa86cb1607941c8a5 26-May-2010 Jeff Hamilton <jham@android.com> Add a PRE_BOOT_COMPLETED receiver.

It runs the first time after an OTA and either creates
the database or runs the upgrade path on it. This may
take a significatn amount of time so it's done before
the boot animation completes.

Bug: 2713849
Change-Id: Ie7ac396bd82577cd421daa102ad05c0abf55b6f0
/packages/providers/CalendarProvider/src/com/android/providers/calendar/CalendarDatabaseHelper.java
e3730b9dce00439666e7ef324a28263a0ee92032 12-Apr-2010 Erik <roboerik@android.com> b/2440161 Made UTC override timezone for allday events

Exchange events had an incorrect timezone set for allDay events and we were setting
sec, min, hour to zero on that timezone. This change will make it override any tz
set and force allDay events to be in UTC.

Change-Id: I14fbdcc14bae2ef45b2e5e0c70e68e4c26136d7b
/packages/providers/CalendarProvider/src/com/android/providers/calendar/CalendarDatabaseHelper.java
7b40dde3168f4af2c757cb43955aa3bfe1668666 08-Apr-2010 Erik <roboerik@android.com> b/2560858 Upgrade will clean up allDay events

Added an upgrade step that will clean up allDay events in the database. This
will set times to have hms be 0 for allday events and try to format duration
into P<#>D. This doesn't fix other problems, such as fields having a value
when they shouldn't.

Change-Id: Ifb1e28bd2e536324e73558ce79da44f7c5b550d7
/packages/providers/CalendarProvider/src/com/android/providers/calendar/CalendarDatabaseHelper.java
679d544f38aa33d00c12884b987d8f8af2a6a6d3 09-Apr-2010 Fabrice Di Meglio <fdimeglio@google.com> A better and simplier fix for bug #2556677 (pre-froyo->froyo calendar schema upgrade mangles CalendarMetaData schema, causing strange instance expansion issues)

We need to clean the Instance table and recreate the CalendarMetaData table
when database version is between 59 and 66 included.

Change-Id: If105ce3629685d40bc5966bb3cdd7ca613a29f7e
/packages/providers/CalendarProvider/src/com/android/providers/calendar/CalendarDatabaseHelper.java
1599ceb270bc70f81dcaf8ecf4568453d7dddd9e 08-Apr-2010 Fabrice Di Meglio <fdimeglio@google.com> Fix bug #2556677 (pre-froyo->froyo calendar schema upgrade mangles CalendarMetaData schema,
...causing strange instance expansion issues)

- force recreation of CalendarMetaData table for versions 59 (start of the problem) to 66 included
- clean Instance table (we need to have it recomputed)
- update schema version to 67
- moved code of upgradeToVersion56() and upgradeResync() to their correct location

Change-Id: Ie95b11cc75ec2200ce32deaee49e0a7c6114acf7
/packages/providers/CalendarProvider/src/com/android/providers/calendar/CalendarDatabaseHelper.java
d5aa3cc17ecda3d72882d9a2e6c48577892df903 29-Mar-2010 Ken Shirriff <kens@google.com> Upgrade sync state database for calendar if necessary.

bug 2549250

Change-Id: I9957cc5385363aeac93f2bea20453bab3e8446a8
/packages/providers/CalendarProvider/src/com/android/providers/calendar/CalendarDatabaseHelper.java
2c32ee7d6feec2b6823dbaa3778e8f4b10102214 12-Mar-2010 Erik <roboerik@android.com> Looks like db version wasn't updated with the last change

Upped the DATABASE_VERSION to 66.

Change-Id: I6431eeee24560925ea9774a79bc89faeae19d826
/packages/providers/CalendarProvider/src/com/android/providers/calendar/CalendarDatabaseHelper.java
a6357118c223d00ed722ecd40ecdda92d705d211 12-Mar-2010 Erik <roboerik@android.com> b/2497120 Added method for rebuilding db in upgrade failure

We're getting crashes from experimental testers that look like the user
downgraded then upgraded their phone without doing a data wipe. Added a
catch for this that will wipe and rebuild the db if the upgrade fails like
this.

Change-Id: I8d2f28dd7a4a312f56573e3fffd2d8e3a2539350
/packages/providers/CalendarProvider/src/com/android/providers/calendar/CalendarDatabaseHelper.java
bf897b03effb752368a98cfb89e6b90cfdde50fc 12-Mar-2010 Marc Blank <mblank@google.com> Add an organizerCanRespond column to Calendar table (with default 1)

* Partially addresses the referenced bug
* Exchange calendars will have this column set to 0
* When set to zero, the UI should not display the organizer's attendee status

Bug: 2507842
Change-Id: I1181a6eb3575a70b4587a94de35fc4abf6fb00c8
/packages/providers/CalendarProvider/src/com/android/providers/calendar/CalendarDatabaseHelper.java
cf9dc6b9bd031b1f6f811a32326ee85429c94deb 10-Mar-2010 Marc Blank <mblank@google.com> Update database version and add upgracde code for previous change

Change-Id: Iec862424c552a30622a49f2b3eed81a714bcb503
/packages/providers/CalendarProvider/src/com/android/providers/calendar/CalendarDatabaseHelper.java
a450a5220c7aa7a2693cd23d8d21a0dfe5614067 10-Mar-2010 Marc Blank <mblank@google.com> Add _sync_mark to view_events view

Change-Id: I86d30f538a4c8e60136a244133cb9c7aec2353b4
/packages/providers/CalendarProvider/src/com/android/providers/calendar/CalendarDatabaseHelper.java
26d0bf3c34f170f9398ac32bf04b87d4957a4441 04-Mar-2010 Ken Shirriff <kens@google.com> Move calendar wipeData to the test.

This method is only used by the test, so it doesn't make sense to have
it in the CalendarDatabaseHelper. This also caused test failures when
Proguard filtered out this method.

bug 2487351
/packages/providers/CalendarProvider/src/com/android/providers/calendar/CalendarDatabaseHelper.java
c12fe4704e12519756b8da1a3f9199f2013e48f0 02-Mar-2010 Marc Blank <mblank@google.com> Handle rename of _SYNC_LOCAL_ID to _SYNC_DATA in Calendar

* This is being used as a discretionary column by Exchange calendar
sync, so rename to avoid association with old usage

Change-Id: Ifdcc0be10d45d261760ebd36bb6bc270c3f70699
/packages/providers/CalendarProvider/src/com/android/providers/calendar/CalendarDatabaseHelper.java
162c7c9bbd53b623fbe913b376e7f7f42915bb59 25-Feb-2010 Marc Blank <mblank@google.com> Add lastSyncedAttendeeStatus to CalendarProvider2 database

* This column is intended to be used by those sync adapters that need to
recognize a change in the user's attendee status; it is uninitialized,
so its value, until modified, will be retrieved as zero (no status)
* This column is not used directly by the provider, so that its semantics
are not defined outside of a particular sync adapter

Change-Id: Ibddc6cf3bf7df04e79c8ce919b54f1af5310b4ab
/packages/providers/CalendarProvider/src/com/android/providers/calendar/CalendarDatabaseHelper.java
2d1b3d70a6ebce8194932f8a8355d97a89da113f 19-Feb-2010 Fabrice Di Meglio <fdimeglio@google.com> Fix bug #2438401 (Froyo calendar is missing many entries)

We want to keep unsynced calendars from being visible in the UI:

- filter events by sync_event state when doing Instance expansion thru getEntries()
- keep events in the Events table (better than erasing them when a calendar is not syncable)
- change events_view View to be able to get the sync_event state
- add database schema upgrade for the Events view
- clean some comments

Change-Id: I9382fe572db371dfa33b200b6dfd870265c6ffcc
/packages/providers/CalendarProvider/src/com/android/providers/calendar/CalendarDatabaseHelper.java
c874ed5c6cc0fcc6ac06ae7d20db0eab7d749608 11-Feb-2010 Ken Shirriff <kens@google.com> Fix instance expansion.

Was getting a constraint violation due to using insert instead of replace.
bug 2439297
/packages/providers/CalendarProvider/src/com/android/providers/calendar/CalendarDatabaseHelper.java
dbaad88527665d5144a8a178fa822f58d2bc7d05 11-Feb-2010 Erik <roboerik@android.com> Quick fix for databases where events are missing a timezone.

Added a check to see if a timezone was returned for an event. If one wasn't it uses
UTC as a default timezone.
/packages/providers/CalendarProvider/src/com/android/providers/calendar/CalendarDatabaseHelper.java
be0733e7f38cabc7eedcb2ee0ed9ab7005439a2f 10-Feb-2010 Erik <roboerik@android.com> b/2434881 Dropped not null requirement for dtstart2,dtend2

Calendar was crashing for certain events that contained a null entry in dtend.
Removed the requirement that dtend2 be non-null.
/packages/providers/CalendarProvider/src/com/android/providers/calendar/CalendarDatabaseHelper.java
ae4f20e120d3107cef20be860a612c9c23816295 08-Feb-2010 Erik <roboerik@android.com> b/1522903 First step in converting allday events to local timezone

This is the first change for converting allDay events to use the local
timezone instead of being in UTC timezones. This will make dealing with
alarms on allDay events easier to manage and allow us to remove a large
number of checks throughout the code to deal with allDay events
differently.
/packages/providers/CalendarProvider/src/com/android/providers/calendar/CalendarDatabaseHelper.java
754b6d0e96c7df4cb649a48cde21b72c3dcedf4a 09-Feb-2010 Erik <roboerik@android.com> Quick fix for missing version number.

In the db update from vs 60 to 61 the version number didn't get changed, this fixes any
issues this could create.
/packages/providers/CalendarProvider/src/com/android/providers/calendar/CalendarDatabaseHelper.java
ae270e35e14b5c7a756050cb8dcccf5771743850 03-Feb-2010 Fabrice Di Meglio <fdimeglio@google.com> Fix bug 1025931 (need to reprocess events table when timezone db changes)

Change-Id: I4a196c2bf03fcae6cb53807940b7b59345fd4fb8
/packages/providers/CalendarProvider/src/com/android/providers/calendar/CalendarDatabaseHelper.java
d39cfe09aa7e752cdc7512ae58d90d49d4b5ef9e 26-Jan-2010 Ken Shirriff <kens@google.com> Unbundling: copy calendarEmailAddressFromFeedUrl method
/packages/providers/CalendarProvider/src/com/android/providers/calendar/CalendarDatabaseHelper.java
ad37c99d051aa4e2508b940c8dec91ee87f53056 15-Jan-2010 Ken Shirriff <kens@google.com> Add calendar database upgrade code.

This switches the CalendarProvider2 code to use the calendar.db database
and upgrade it in place. The upgrade code from versions 57 and 58 is
copied from CalendarProvider.
/packages/providers/CalendarProvider/src/com/android/providers/calendar/CalendarDatabaseHelper.java
83c55844974ca611a553e704663ed845d84c7930 06-Jan-2010 Ken Shirriff <kens@google.com> Add trigger to keep event account correct.

When an event is inserted, the _sync_account and _sync_account_type will
be updated from the Calendars table.
/packages/providers/CalendarProvider/src/com/android/providers/calendar/CalendarDatabaseHelper.java
348f0a5b9ef74356c32562ec4136e875fdb6811e 08-Jan-2010 Ken Shirriff <kens@google.com> Fix SQL broken by busybits change.
/packages/providers/CalendarProvider/src/com/android/providers/calendar/CalendarDatabaseHelper.java
dbd797d59294d72d7ea9226d10128674b634aaad 08-Jan-2010 Erik <roboerik@android.com> b/2293263 Finished removing busyBits.

Removed the rest of the references to busyBits and refactored writeLocked to drop unused
fields (were previously part of busybits). Added revision update code for the db and
removed busybit db code from CalendarDatabaseHelper.
/packages/providers/CalendarProvider/src/com/android/providers/calendar/CalendarDatabaseHelper.java
1ae4c22f15c107cd9f9cd8babaa11005e45e4647 05-Jan-2010 Ken Shirriff <kens@google.com> CalendarProvider2 fixes.

Add support for deleting a selection. Use the event view where appropriate.
Fix problems with conflicting column names. Add unittests. Add some missing
columns to projections. Remove unneeded Calendar joins.
/packages/providers/CalendarProvider/src/com/android/providers/calendar/CalendarDatabaseHelper.java
595242cb01dc0d2d90b01613ff195b2be7b2559e 12-Dec-2009 Ken Shirriff <kens@google.com> Add multiple account support to CalendarProvider2.

This appends the account information to the appropriate query
/packages/providers/CalendarProvider/src/com/android/providers/calendar/CalendarDatabaseHelper.java
7e3ec5f2025164fca508f81a5a01940bc912e064 02-Nov-2009 Ken Shirriff <kens@google.com> New calendar sync framework: code review changes, support delete, support multiple calendars, remove triggers.
/packages/providers/CalendarProvider/src/com/android/providers/calendar/CalendarDatabaseHelper.java
9f005e4843925efe4fa8434361c4ad4ad384ed4c 27-Oct-2009 Ken Shirriff <kens@google.com> Add new CalendarProvider2 for new sync framework.

This provider operates directly, rather than through a TempProviderSyncAdapter.
/packages/providers/CalendarProvider/src/com/android/providers/calendar/CalendarDatabaseHelper.java