diff options
author | Michal Čihař <michal@cihar.com> | 2017-02-06 12:03:24 +0100 |
---|---|---|
committer | Michal Čihař <michal@cihar.com> | 2017-02-06 12:03:24 +0100 |
commit | 65fb611e091ef7d0b28039126733848bd20edb9d (patch) | |
tree | 628c54c160fe8fdfa55f621cc8021ef1d8b441b9 /tests/Utils/FormatterTest.php | |
parent | 108927f28df40bb9feb35e6c5501b2513b21bc63 (diff) | |
download | sql-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.php | 18 |
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/>' . ' tbl' . '<br/>' . '<span class="sql-reserved">SELECT</span>' . '<br/>' . - ' *; <span class="sql-keyword">END</span>', + ' *;' . '<br/>' . + '<span class="sql-keyword">END</span>', ), 'insert' => array( 'query' => 'insert into foo values (0, 0, 0), (1, 1, 1)', |