diff options
| author | Damian Dlugosz <bigfootdd@gmail.com> | 2017-01-27 01:21:15 +0100 |
|---|---|---|
| committer | Damian Dlugosz <bigfootdd@gmail.com> | 2017-02-01 23:33:23 +0100 |
| commit | 74d4450635ee56dd9ac4b5524a1b26159605cb5d (patch) | |
| tree | 9215972207b73add5b4d3d548dbf9dc1295be0ca /tests/Utils/FormatterTest.php | |
| parent | ce5781cfafd249f06d36b7a938bdef8f7a7c765f (diff) | |
| download | sql-parser-74d4450635ee56dd9ac4b5524a1b26159605cb5d.zip sql-parser-74d4450635ee56dd9ac4b5524a1b26159605cb5d.tar.gz sql-parser-74d4450635ee56dd9ac4b5524a1b26159605cb5d.tar.bz2 | |
Testing typical
Diffstat (limited to 'tests/Utils/FormatterTest.php')
| -rw-r--r-- | tests/Utils/FormatterTest.php | 47 |
1 files changed, 46 insertions, 1 deletions
diff --git a/tests/Utils/FormatterTest.php b/tests/Utils/FormatterTest.php index 827c258..5f94aca 100644 --- a/tests/Utils/FormatterTest.php +++ b/tests/Utils/FormatterTest.php @@ -289,6 +289,51 @@ class FormatTest extends TestCase '<span class="sql-reserved">WHERE</span>' . '<br/>' . ' <span class="sql-number">1</span>', ), + 'typical' => array( + 'query' => 'SELECT id, if(id=1,"Si","No") from `tbl` where id = 0 or id = 1 group by id order by id desc limit 1 offset 0', + 'text' => + 'SELECT' . "\n" . + ' id,' . "\n" . + ' IF(id = 1, "Si", "No")' . "\n" . + 'FROM' . "\n" . + ' `tbl`' . "\n" . + 'WHERE' . "\n" . + ' id = 0 OR id = 1' . "\n" . + 'GROUP BY' . "\n" . + ' id' . "\n" . + 'ORDER BY' . "\n" . + ' id' . "\n" . + 'DESC' . "\n" . + 'LIMIT 1 OFFSET 0', + 'cli' => + "\x1b[35mSELECT" . "\n" . + " \x1b[39mid\x1b[39m," . "\n" . + " \x1b[35mIF\x1b[39m(\x1b[39mid \x1b[39m= \x1b[92m1\x1b[39m, \x1b[91m\"Si\"\x1b[39m, \x1b[91m\"No\"\x1b[39m)" . "\n" . + "\x1b[35mFROM" . "\n" . + " \x1b[36m`tbl`" . "\n" . + "\x1b[35mWHERE" . "\n" . + " \x1b[39mid \x1b[39m= \x1b[92m0 \x1b[35mOR \x1b[39mid \x1b[39m= \x1b[92m1" . "\n" . + "\x1b[35mGROUP BY" . "\n" . + " \x1b[39mid" . "\n" . + "\x1b[35mORDER BY" . "\n" . + " \x1b[39mid" . "\n" . + "\x1b[35mDESC" . "\n" . + "\x1b[35mLIMIT \x1b[92m1 \x1b[95mOFFSET \x1b[92m0" . "\x1b[0m", + 'html' => + '<span class="sql-reserved">SELECT</span>' . '<br/>' . + ' id,' . '<br/>' . + ' <span class="sql-reserved">IF</span>(id = <span class="sql-number">1</span>, <span class="sql-string">"Si"</span>, <span class="sql-string">"No"</span>)' . '<br/>' . + '<span class="sql-reserved">FROM</span>' . '<br/>' . + ' <span class="sql-variable">`tbl`</span>' . '<br/>' . + '<span class="sql-reserved">WHERE</span>' . '<br/>' . + ' id = <span class="sql-number">0</span> <span class="sql-reserved">OR</span> id = <span class="sql-number">1</span>' . '<br/>' . + '<span class="sql-reserved">GROUP BY</span>' . '<br/>' . + ' id' . '<br/>' . + '<span class="sql-reserved">ORDER BY</span>' . '<br/>' . + ' id' . '<br/>' . + '<span class="sql-reserved">DESC</span>' . '<br/>' . + '<span class="sql-reserved">LIMIT</span> <span class="sql-number">1</span> <span class="sql-keyword">OFFSET</span> <span class="sql-number">0</span>', + ), 'comments' => array( 'query' => 'select /* Comment */ *' . "\n" . @@ -591,7 +636,7 @@ class FormatTest extends TestCase "\x1b[35mSELECT\n \x1b[91m\"Text\" \x1b[35mAS \x1b[39mBAR\x1b[0m", array('type' => 'cli'), ), - array( + array( # Covered by 'typical' and 'string as alias' 'SELECT coditm AS Item, descripcion AS Descripcion, contenedores AS Contenedores, IF(suspendido = 1, Si, NO) AS Suspendido FROM `DW_articulos` WHERE superado = 0', '<span class="sql-reserved">SELECT</span>' . '<br/>' . ' coditm <span class="sql-reserved">AS</span> Item,' . '<br/>' . |