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'); } }