function doUp()
{
global $database;
if (DBSchema::existsColumn($database, 'PresentationSpeaker', 'OnSitePhoneNumber')) {
$speakers_info_query = <<<SQL
SELECT ID, OnSitePhoneNumber, ConfirmedDate, RegisteredForSummit
FROM PresentationSpeaker where OnSitePhoneNumber IS NOT NULL;
SQL;
$res = DB::query($speakers_info_query);
foreach ($res as $row) {
$speaker_id = intval($row['ID']);
$on_site_phone = intval($row['OnSitePhoneNumber']);
$confirmed_date = $row['ConfirmedDate'];
$registered = (bool) $row['RegisteredForSummit'];
$speaker = PresentationSpeaker::get()->byID($speaker_id);
if (is_null($speaker)) {
continue;
}
if (PresentationSpeakerSummitAssistanceConfirmationRequest::get()->filter(array('SummitID' => 5, 'SpeakerID' => $speaker_id))->count() > 0) {
continue;
}
$assistance = PresentationSpeakerSummitAssistanceConfirmationRequest::create();
$assistance->SpeakerID = $speaker_id;
$assistance->SummitID = 5;
$assistance->OnSitePhoneNumber = $on_site_phone;
$assistance->ConfirmationDate = $confirmed_date;
$assistance->RegisteredForSummit = $registered;
$assistance->IsConfirmed = true;
$assistance->write();
}
DBSchema::dropColumn($database, 'PresentationSpeaker', 'OnSitePhoneNumber');
DBSchema::dropColumn($database, 'PresentationSpeaker', 'ConfirmedDate');
DBSchema::dropColumn($database, 'PresentationSpeaker', 'RegisteredForSummit');
}
}
function doUp()
{
global $database;
if (DBSchema::existsColumn($database, 'SummitRegistrationPromoCode', 'OwnerID')) {
DBSchema::dropColumn($database, 'SummitRegistrationPromoCode', 'OwnerID');
}
}
/**
* Run the migration
*/
public function doUp()
{
global $database;
if (DBSchema::existsColumn($database, 'GerritChangeInfo', 'MemberID')) {
DBSchema::dropColumn($database, 'GerritChangeInfo', 'MemberID');
}
}
function doUp()
{
global $database;
if (DBSchema::existsColumn($database, "EventbriteEvent", "ExternalOrderId")) {
DBSchema::dropColumn($database, "EventbriteEvent", "ExternalOrderId");
}
}
/**
* Run the migration
*/
public function doUp()
{
global $database;
if (DBSchema::existsColumn($database, 'Member', 'CLASigned')) {
DBSchema::dropColumn($database, 'Member', 'CLASigned');
}
if (DBSchema::existsColumn($database, 'Member', 'GerritID')) {
DBSchema::dropColumn($database, 'Member', 'GerritID');
}
if (DBSchema::existsColumn($database, 'Member', 'LastCodeCommit')) {
DBSchema::dropColumn($database, 'Member', 'LastCodeCommit');
}
}
function doUp()
{
global $database;
if (DBSchema::existsColumn($database, 'PresentationSpeaker', 'SummitID')) {
DBSchema::dropColumn($database, 'PresentationSpeaker', 'SummitID');
}
if (DBSchema::existsColumn($database, 'PresentationSpeaker', 'AnnouncementEmailTypeSent')) {
DBSchema::dropColumn($database, 'PresentationSpeaker', 'AnnouncementEmailTypeSent');
}
if (DBSchema::existsColumn($database, 'PresentationSpeaker', 'AnnouncementEmailSentDate')) {
DBSchema::dropColumn($database, 'PresentationSpeaker', 'AnnouncementEmailSentDate');
}
if (DBSchema::existsColumn($database, 'PresentationSpeaker', 'SummitRegistrationPromoCodeID')) {
DBSchema::dropColumn($database, 'PresentationSpeaker', 'SummitRegistrationPromoCodeID');
}
if (DBSchema::existsColumn($database, 'PresentationSpeaker', 'TwitterHandle')) {
DB::query('UPDATE PresentationSpeaker SET TwitterName = TwitterHandle;');
DBSchema::dropColumn($database, 'PresentationSpeaker', 'TwitterHandle');
}
}
