Page Menu
Home
Phorge
Search
Configure Global Search
Log In
Files
F2892225
20161004.cal.01.noepoch.php
No One
Temporary
Actions
Download File
Edit File
Delete File
View Transforms
Subscribe
Award Token
Flag For Later
Advanced/Developer...
View Handle
View Hovercard
Size
3 KB
Referenced Files
None
Subscribers
None
20161004.cal.01.noepoch.php
View Options
<?php
$table
=
new
PhabricatorCalendarEvent
(
)
;
$conn
=
$table
->
establishConnection
(
'w'
)
;
$table_name
=
'calendar_event'
;
// Long ago, "All Day" events were stored with a start and end date set to
// the earliest possible start and end seconds for the corresponding days. We
// then moved to store all day events with their "date" epochs as UTC, separate
// from individual event times. Both systems were later replaced with use of
// CalendarDateTime.
$zone_min
=
new
DateTimeZone
(
'Pacific/Midway'
)
;
$zone_max
=
new
DateTimeZone
(
'Pacific/Kiritimati'
)
;
$zone_utc
=
new
DateTimeZone
(
'UTC'
)
;
foreach
(
new
LiskRawMigrationIterator
(
$conn
,
$table_name
)
as
$row
)
{
$parameters
=
phutil_json_decode
(
$row
[
'parameters'
]
)
;
if
(
isset
(
$parameters
[
'startDateTime'
]
)
)
{
// This event has already been migrated.
continue
;
}
$is_all_day
=
$row
[
'isAllDay'
]
;
if
(
empty
(
$row
[
'allDayDateFrom'
]
)
)
{
// No "allDayDateFrom" means this is an old event which was never migrated
// by the earlier "20160715.event.03.allday.php" migration. The dateFrom
// and dateTo will be minimum and maximum earthly seconds for the event. We
// convert them to UTC if they were in extreme timezones.
$epoch_min
=
$row
[
'dateFrom'
]
;
$epoch_max
=
$row
[
'dateTo'
]
;
if
(
$is_all_day
)
{
$date_min
=
new
DateTime
(
'@'
.
$epoch_min
)
;
$date_max
=
new
DateTime
(
'@'
.
$epoch_max
)
;
$date_min
->
setTimeZone
(
$zone_min
)
;
$date_min
->
modify
(
'+2 days'
)
;
$date_max
->
setTimeZone
(
$zone_max
)
;
$date_max
->
modify
(
'-2 days'
)
;
$string_min
=
$date_min
->
format
(
'Y-m-d'
)
;
$string_max
=
$date_max
->
format
(
'Y-m-d 23:59:00'
)
;
$utc_min
=
id
(
new
DateTime
(
$string_min
,
$zone_utc
)
)
->
format
(
'U'
)
;
$utc_max
=
id
(
new
DateTime
(
$string_max
,
$zone_utc
)
)
->
format
(
'U'
)
;
}
else
{
$utc_min
=
$epoch_min
;
$utc_max
=
$epoch_max
;
}
}
else
{
// This is an event which was migrated already. We can pick the correct
// epoch timestamps based on the "isAllDay" flag.
if
(
$is_all_day
)
{
$utc_min
=
$row
[
'allDayDateFrom'
]
;
$utc_max
=
$row
[
'allDayDateTo'
]
;
}
else
{
$utc_min
=
$row
[
'dateFrom'
]
;
$utc_max
=
$row
[
'dateTo'
]
;
}
}
$utc_until
=
$row
[
'recurrenceEndDate'
]
;
$start_datetime
=
PhutilCalendarAbsoluteDateTime
::
newFromEpoch
(
$utc_min
)
;
if
(
$is_all_day
)
{
$start_datetime
->
setIsAllDay
(
true
)
;
}
$end_datetime
=
PhutilCalendarAbsoluteDateTime
::
newFromEpoch
(
$utc_max
)
;
if
(
$is_all_day
)
{
$end_datetime
->
setIsAllDay
(
true
)
;
}
if
(
$utc_until
)
{
$until_datetime
=
PhutilCalendarAbsoluteDateTime
::
newFromEpoch
(
$utc_until
)
;
}
else
{
$until_datetime
=
null
;
}
$parameters
[
'startDateTime'
]
=
$start_datetime
->
toDictionary
(
)
;
$parameters
[
'endDateTime'
]
=
$end_datetime
->
toDictionary
(
)
;
if
(
$until_datetime
)
{
$parameters
[
'untilDateTime'
]
=
$until_datetime
->
toDictionary
(
)
;
}
queryfx
(
$conn
,
'UPDATE %T SET parameters = %s WHERE id = %d'
,
$table_name
,
phutil_json_encode
(
$parameters
)
,
$row
[
'id'
]
)
;
}
// Generate UTC epochs for all events. We can't readily do this one at a
// time because instance UTC epochs rely on having the parent event.
$viewer
=
PhabricatorUser
::
getOmnipotentUser
(
)
;
$all_events
=
id
(
new
PhabricatorCalendarEventQuery
(
)
)
->
setViewer
(
$viewer
)
->
execute
(
)
;
foreach
(
$all_events
as
$event
)
{
if
(
$event
->
getUTCInitialEpoch
(
)
)
{
// Already migrated.
continue
;
}
try
{
$event
->
updateUTCEpochs
(
)
;
}
catch
(
Exception
$ex
)
{
continue
;
}
queryfx
(
$conn
,
'UPDATE %T SET
utcInitialEpoch = %d,
utcUntilEpoch = %nd,
utcInstanceEpoch = %nd WHERE id = %d'
,
$table_name
,
$event
->
getUTCInitialEpoch
(
)
,
$event
->
getUTCUntilEpoch
(
)
,
$event
->
getUTCInstanceEpoch
(
)
,
$event
->
getID
(
)
)
;
}
File Metadata
Details
Attached
Mime Type
text/x-php
Expires
Sun, Jan 19, 16:27 (2 w, 6 d ago)
Storage Engine
blob
Storage Format
Raw Data
Storage Handle
1126472
Default Alt Text
20161004.cal.01.noepoch.php (3 KB)
Attached To
Mode
rP Phorge
Attached
Detach File
Event Timeline
Log In to Comment