public function getTables($schemaName)
{
$sql = "SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = :schema ORDER BY TABLE_NAME ASC";
$statement = $this->pdo->prepare($sql);
$statement->bindValue(':schema', $schemaName, PDO::PARAM_STR);
$statement->execute();
$result = [];
foreach ($statement->fetchAll(PDO::FETCH_ASSOC) as $data) {
$tableObject = new TableObject($data['TABLE_NAME']);
$tableObject->setType($data['TABLE_TYPE']);
$tableObject->setEngine($data['ENGINE']);
$tableObject->setCollation($data['TABLE_COLLATION']);
$tableObject->setComment($data['TABLE_COMMENT']);
$result[] = $tableObject;
}
return $result;
}
