diff options
| -rwxr-xr-x | bin/sql-formatter | 16 |
1 files changed, 15 insertions, 1 deletions
diff --git a/bin/sql-formatter b/bin/sql-formatter index f8b7f51..4466306 100755 --- a/bin/sql-formatter +++ b/bin/sql-formatter @@ -1,4 +1,18 @@ #!/usr/bin/env php <?php +if("cli" !== php_sapi_name()) { + echo "<p>Run this php script from the command line to see CLI syntax highlighting and formatting. It support Unix pipes or command line argument style.</p>"; + echo "<pre><code>php examples/cli.php \"SELECT * FROM MyTable WHERE (id>5 AND \\`name\\` LIKE \\"testing\\");\"</code></pre>"; + echo "<pre><code>echo \"SELECT * FROM MyTable WHERE (id>5 AND \\`name\\` LIKE \\"testing\\");\" | php examples/cli.php</code></pre>"; +} -require_once __DIR__.'/../examples/cli.php'; +if(isset($argv[1])) { + $sql = $argv[1]; +} +else { + $sql = stream_get_contents(fopen("php://stdin", "r")); +} + +require_once(__DIR__.'/../lib/SqlFormatter.php'); + +echo SqlFormatter::format($sql); |