diff options
| author | Michal Čihař <michal@cihar.com> | 2016-04-07 10:52:25 +0200 |
|---|---|---|
| committer | Michal Čihař <michal@cihar.com> | 2016-04-07 10:52:25 +0200 |
| commit | d8547b8f711a084a4d1f1ee3c79b0c7c15198fad (patch) | |
| tree | 10ef9d7489e0094351545593981ffb4c23d5ebd3 /tests/Utils | |
| parent | 5e69cdaadb855bd692e02032c78d10e8906f19b0 (diff) | |
| download | sql-parser-d8547b8f711a084a4d1f1ee3c79b0c7c15198fad.zip sql-parser-d8547b8f711a084a4d1f1ee3c79b0c7c15198fad.tar.gz sql-parser-d8547b8f711a084a4d1f1ee3c79b0c7c15198fad.tar.bz2 | |
Improve formatting of non indented groupsv3.4.2
We don't want to insert newlines insite non indented groups.
Fixes #20
Signed-off-by: Michal Čihař <michal@cihar.com>
Diffstat (limited to 'tests/Utils')
| -rw-r--r-- | tests/Utils/FormatterTest.php | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/tests/Utils/FormatterTest.php b/tests/Utils/FormatterTest.php index 4940016..49fc912 100644 --- a/tests/Utils/FormatterTest.php +++ b/tests/Utils/FormatterTest.php @@ -78,6 +78,19 @@ class FormatTest extends TestCase "\x1b[35mSELECT\n \x1b[92m1\e[0m", 'cli' ), + array( + '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>' . "\n" . + ' coditm <span class="sql-reserved">AS</span> Item,' . "\n" . + ' descripcion <span class="sql-reserved">AS</span> Descripcion,' . "\n" . + ' contenedores <span class="sql-reserved">AS</span> Contenedores,' . "\n" . + ' <span class="sql-reserved">IF</span>(suspendido = <span class="sql-number">1</span>, Si, <span class="sql-keyword">NO</span>) <span class="sql-reserved">AS</span> Suspendido' . "\n" . + '<span class="sql-reserved">FROM</span>' . "\n" . + ' <span class="sql-variable">`DW_articulos`</span>' . "\n" . + '<span class="sql-reserved">WHERE</span>' . "\n" . + ' superado = <span class="sql-number">0</span>', + 'html', + ), ); } } |