/** * Loads all migrations and their application state from the database. * * @return array */ public function get_schema() { if (!empty($this->tables)) { return $this->tables; } $migrations = $this->class_names; $tree = array(); $check_dependencies = true; while (!empty($migrations)) { foreach ($migrations as $key => $migration_class) { // Unset classes that are not a valid migration if (\phpbb\db\migrator::is_migration($migration_class) === false) { unset($migrations[$key]); continue; } $open_dependencies = array_diff($migration_class::depends_on(), $tree); if (empty($open_dependencies)) { $migration = new $migration_class($this->config, $this->db, $this->db_tools, $this->phpbb_root_path, $this->php_ext, $this->table_prefix); $tree[] = $migration_class; $migration_key = array_search($migration_class, $migrations); foreach ($migration->update_schema() as $change_type => $data) { if ($change_type === 'add_tables') { foreach ($data as $table => $table_data) { $this->tables[$table] = $table_data; } } else { if ($change_type === 'drop_tables') { foreach ($data as $table) { unset($this->tables[$table]); } } else { if ($change_type === 'add_columns') { foreach ($data as $table => $add_columns) { foreach ($add_columns as $column => $column_data) { if (isset($column_data['after'])) { $columns = $this->tables[$table]['COLUMNS']; $offset = array_search($column_data['after'], array_keys($columns)); unset($column_data['after']); if ($offset === false) { $this->tables[$table]['COLUMNS'][$column] = array_values($column_data); } else { $this->tables[$table]['COLUMNS'] = array_merge(array_slice($columns, 0, $offset + 1, true), array($column => array_values($column_data)), array_slice($columns, $offset)); } } else { $this->tables[$table]['COLUMNS'][$column] = $column_data; } } } } else { if ($change_type === 'change_columns') { foreach ($data as $table => $change_columns) { foreach ($change_columns as $column => $column_data) { $this->tables[$table]['COLUMNS'][$column] = $column_data; } } } else { if ($change_type === 'drop_columns') { foreach ($data as $table => $drop_columns) { if (is_array($drop_columns)) { foreach ($drop_columns as $column) { unset($this->tables[$table]['COLUMNS'][$column]); } } else { unset($this->tables[$table]['COLUMNS'][$drop_columns]); } } } else { if ($change_type === 'add_unique_index') { foreach ($data as $table => $add_index) { foreach ($add_index as $key => $index_data) { $this->tables[$table]['KEYS'][$key] = array('UNIQUE', $index_data); } } } else { if ($change_type === 'add_index') { foreach ($data as $table => $add_index) { foreach ($add_index as $key => $index_data) { $this->tables[$table]['KEYS'][$key] = array('INDEX', $index_data); } } } else { if ($change_type === 'drop_keys') { foreach ($data as $table => $drop_keys) { foreach ($drop_keys as $key) { unset($this->tables[$table]['KEYS'][$key]); } } } else { var_dump($change_type); } } } } } } } } } unset($migrations[$migration_key]); } else { if ($check_dependencies) { $this->dependencies = array_merge($this->dependencies, $open_dependencies); } } } // Only run this check after the first run if ($check_dependencies) { $this->check_dependencies(); $check_dependencies = false; } } ksort($this->tables); return $this->tables; }