SQL整形スクリプト

format_sql.php

#!/usr/bin/php
<?php
if (empty($argv[1])) {
	echo "ファイル名が指定されていません\n";
	exit;
}
$filePath = $argv[1];
$sql = file_get_contents($filePath);
$url = 'http://sqlformat.org/api/v1/format';

$query = [
    'sql' => $sql,
    //'reindent' => 1,
    'keyword_case' => 'upper'
];
$queryStr = http_build_query($query);

$headers = [
    "Content-Type: application/x-www-form-urlencoded",
    "Content-Length: " . strlen($queryStr)
];
$options = [
    'http' => [
        'method' => 'POST',
        'header' => implode("\r\n", $headers),
        'content' => $queryStr
    ]
];
$context = stream_context_create($options);
$contents = file_get_contents($url, false, $context);
$results = json_decode($contents);
$formatSql = $results->result;

// カラムの型を小文字から大文字に変換
$formatSql = preg_replace_callback(
    '/ (tinyint|int|datetime|date|varchar|char|text)/',
    function ($matches) {
        return strtoupper($matches[0]);
    },
    $formatSql
);
file_put_contents($filePath, $formatSql);