opIndex();
case 'database':
return $this->opDatabase(I('dbKey'), I('tables', []));
default:
error('无效的网址');
}
}
public function opIndex(): string
{
$html = [];
$html[] = "Database Key
";
$html[] = "";
$dbKeys = array_keys(MVC::$cfg['database']);
foreach ($dbKeys as $dbKey) {
$url = url('self', ['op' => 'database', 'dbKey' => $dbKey]);
$html[] = "- {$dbKey}
";
}
$html[] = "
";
return implode("\n", $html);
}
public function opDatabase(string $dbKey, array $selectTables = []): string
{
$db = new DB($dbKey);
$databaseName = $db->getDatabaseName();
if ($selectTables) {
foreach ($selectTables as $selectTableName) {
$this->createMetadata($db, $selectTableName);
}
header('Location: ' . url('self'));
exit();
}
$sql = "SHOW TABLES FROM `{$databaseName}`";
$tables = $db->query($sql)->all();
$url = url('self');
$csrfToken = getCsrfToken();
$html = [];
$html[] = "{$dbKey} - {$databaseName}
";
$html[] = "";
return implode("\n", $html);
}
public function createMetadata(DB $db, string $tableName)
{
$ddl = $this->getDDL($db, $tableName);
$table = $this->parseDDL($ddl);
dd($ddl, $table);
}
public function getDDL(DB $db, string $tableName)
{
$sql = "SHOW CREATE TABLE `{$tableName}`";
$row = $db->query($sql)->row();
return $row['Create Table'];
}
public function parseDDL(string $ddl): array
{
try {
$parser = new Parser($ddl);
$statements = (array)$parser->statements;
$result = (array)$statements[0];
return $result ?? [];
} catch (ParserException $e) {
error($e->getMessage());
}
}
}
$metadata = new metadata();
$html = $metadata->execute(I('op', ''));
?>
元数据