/** * Loads the width of all columns in the MySQL schema into $columns. */ private function getColumns() { $rows = DataLayer::getAllTableColumns(); foreach ($rows as $row) { $row['length'] = DataTypeHelper::deriveFieldLength($row); $this->columns[$row['table_name']][$row['column_name']] = $row; } }
/** * Selects schema, table, column names and the column type from MySQL and saves them as replace pairs. */ private function getColumnTypes() { $rows = DataLayer::getAllTableColumns(); foreach ($rows as $row) { $key = '@' . $row['table_name'] . '.' . $row['column_name'] . '%type@'; $key = strtoupper($key); $value = $row['column_type']; if (isset($row['character_set_name'])) { $value .= ' character set ' . $row['character_set_name']; } $this->myReplacePairs[$key] = $value; } $this->io->text(sprintf('Selected %d column types for substitution', sizeof($rows))); }