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()];
}
