#!/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 supports Unix pipes or command line argument style.</p>";
    echo "<pre><code>php bin/sql-formatter \"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 bin/sql-formatter</code></pre>";
    exit;
}

if(isset($argv[1])) {
    $sql = $argv[1];
}
else {
    $sql = stream_get_contents(fopen('php://stdin', 'r'));
}

require_once(__DIR__.'/../vendor/autoload.php');

echo (new \Doctrine\SqlFormatter\SqlFormatter())->format($sql);