public function getSchemas() { $sql = "\n SELECT\n *\n FROM\n INFORMATION_SCHEMA.SCHEMATA\n WHERE\n SCHEMA_NAME != 'INFORMATION_SCHEMA'\n ORDER BY\n SCHEMA_NAME ASC"; $statement = $this->pdo->prepare($sql); $statement->execute(); $result = []; foreach ($statement->fetchAll(PDO::FETCH_ASSOC) as $data) { $schemaObject = new SchemaObject($data['SCHEMA_NAME']); $schemaObject->setDefaultCharacterSetName($data['DEFAULT_CHARACTER_SET_NAME']); $schemaObject->setDefaultCollationName($data['DEFAULT_COLLATION_NAME']); $result[] = $schemaObject; } return $result; }
private function buildData(SchemaObject $schema) { return ['name' => $schema->getName(), 'characterSetName' => $schema->getDefaultCharacterSetName(), 'collationName' => $schema->getDefaultCollationName()]; }