function doUp() { global $database; if (DBSchema::existsTable($database, "JobPage")) { $res = DB::query("SELECT * FROM JobPage;"); foreach ($res as $record) { $new_job = new Job(); $new_job->ID = (int) $record['ID']; $new_job->Title = $record['Title']; $new_job->Description = $record['Content']; $new_job->Created = $record['Created']; $new_job->LastEdited = $record['LastEdited']; $new_job->PostedDate = $record['JobPostedDate']; $new_job->ExpirationDate = $record['ExpirationDate']; // company name logic $company_name = $record['JobCompany']; $company = Company::get()->filter('Name', $company_name)->first(); $new_job->CompanyID = is_null($company) ? 0 : $company->ID; if ($new_job->CompanyID == 0) { $new_job->CompanyName = $company_name; } $new_job->MoreInfoLink = $record['JobMoreInfoLink']; $new_job->Location = $record['JobLocation']; $new_job->IsFoundationJob = $record['FoundationJob']; $new_job->IsActive = $record['Active']; $new_job->Instructions2Apply = $record['JobInstructions2Apply']; $new_job->LocationType = $record['LocationType']; $new_job->IsCOANeeded = 0; $new_job->TypeID = 0; //registration request $registration_request = JobRegistrationRequest::get()->filter('Title', $new_job->Title)->first(); if (!is_null($registration_request)) { $new_job->RegistrationRequestID = $registration_request->ID; } $new_job->write(); } DBSchema::dropTable($database, "JobPage"); } }