private function migrate_existing_columns() { /** @var wpdb $wpdb */ global $wpdb; foreach (psi_tables() as $ID => $table) { if (!isset($table['column'])) { continue; } $column = str_replace('tbl', '', $ID); if (self::column_exists('articles', $column)) { // Get all rows from the column $results = $wpdb->get_col("\n\t\t\t\t\tSELECT articles.{$column}\n\t\t\t\t\tFROM articles\n\t\t\t\t\t"); if (empty($results)) { continue; } $new_column = $table['column']; $results = array_unique($results); foreach ($results as $result) { if (!$result) { continue; } $wpdb->insert($ID, array($new_column => $result)); } } } }
private function setup() { /** @var wpdb $wpdb */ global $wpdb; $migrated_tables = array(); foreach (psi_tables() as $ID => $table) { if (PSI_Migrate::table_exists($ID)) { $migrated_tables[] = $ID; } } if (count($migrated_tables) === 0) { $this->migrated = 'none'; } elseif (count($migrated_tables) < count(psi_tables())) { $this->migrated = 'partial'; } else { $this->migrated = 'complete'; } }