Add codes to sql-script removing require_once.

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 \\&quot;testing\\&quot;);\"</code></pre>";
+    echo "<pre><code>echo \"SELECT * FROM MyTable WHERE (id>5 AND \\`name\\` LIKE \\&quot;testing\\&quot;);\" | 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);