summaryrefslogtreecommitdiffstats
path: root/tests/Utils/FormatterTest.php
diff options
context:
space:
mode:
authorMichal Čihař <michal@cihar.com>2017-02-06 12:03:24 +0100
committerMichal Čihař <michal@cihar.com>2017-02-06 12:03:24 +0100
commit65fb611e091ef7d0b28039126733848bd20edb9d (patch)
tree628c54c160fe8fdfa55f621cc8021ef1d8b441b9 /tests/Utils/FormatterTest.php
parent108927f28df40bb9feb35e6c5501b2513b21bc63 (diff)
downloadsql-parser-65fb611e091ef7d0b28039126733848bd20edb9d.zip
sql-parser-65fb611e091ef7d0b28039126733848bd20edb9d.tar.gz
sql-parser-65fb611e091ef7d0b28039126733848bd20edb9d.tar.bz2
Fix expected format for BEGIN/END
Issue #120 Signed-off-by: Michal Čihař <michal@cihar.com>
Diffstat (limited to 'tests/Utils/FormatterTest.php')
-rw-r--r--tests/Utils/FormatterTest.php18
1 files changed, 12 insertions, 6 deletions
diff --git a/tests/Utils/FormatterTest.php b/tests/Utils/FormatterTest.php
index f66ca4a..f21c024 100644
--- a/tests/Utils/FormatterTest.php
+++ b/tests/Utils/FormatterTest.php
@@ -419,25 +419,31 @@ class FormatTest extends TestCase
'query' => 'create procedure test_procedure() begin from tbl select *; end',
'text' =>
'CREATE' . "\n" .
- 'PROCEDURE test_procedure() BEGIN' . "\n" .
+ 'PROCEDURE test_procedure()' . "\n" .
+ 'BEGIN' . "\n" .
'FROM' . "\n" .
' tbl' . "\n" .
'SELECT' . "\n" .
- ' *; END',
+ ' *;' . "\n" .
+ 'END',
'cli' =>
"\x1b[35mCREATE" . "\n" .
- "\x1b[35mPROCEDURE \x1b[39mtest_procedure\x1b[39m(\x1b[39m) \x1b[95mBEGIN" . "\n" .
+ "\x1b[35mPROCEDURE \x1b[39mtest_procedure\x1b[39m(\x1b[39m)\n" .
+ "\x1b[95mBEGIN" . "\n" .
"\x1b[35mFROM" . "\n" .
" \x1b[39mtbl" . "\n" .
"\x1b[35mSELECT" . "\n" .
- " \x1b[39m*\x1b[39m; \x1b[95mEND" . "\x1b[0m",
+ " \x1b[39m*\x1b[39m;\n" .
+ "\x1b[95mEND" . "\x1b[0m",
'html' =>
'<span class="sql-reserved">CREATE</span>' . '<br/>' .
- '<span class="sql-reserved">PROCEDURE</span> test_procedure() <span class="sql-keyword">BEGIN</span>' . '<br/>' .
+ '<span class="sql-reserved">PROCEDURE</span> test_procedure()' . '<br/>' .
+ '<span class="sql-keyword">BEGIN</span>' . '<br/>' .
'<span class="sql-reserved">FROM</span>' . '<br/>' .
'&nbsp;&nbsp;&nbsp;&nbsp;tbl' . '<br/>' .
'<span class="sql-reserved">SELECT</span>' . '<br/>' .
- '&nbsp;&nbsp;&nbsp;&nbsp;*; <span class="sql-keyword">END</span>',
+ '&nbsp;&nbsp;&nbsp;&nbsp;*;' . '<br/>' .
+ '<span class="sql-keyword">END</span>',
),
'insert' => array(
'query' => 'insert into foo values (0, 0, 0), (1, 1, 1)',