diff options
author | Michal Čihař <michal@cihar.com> | 2016-02-19 14:53:03 +0100 |
---|---|---|
committer | Michal Čihař <michal@cihar.com> | 2016-02-19 14:53:03 +0100 |
commit | f20f41c2bdfdde3da342399769ecb9b544d6783e (patch) | |
tree | 83b0e46cfe0f6fc71925e3c7f7fdb7028edcc67a /tests/Utils/FormatterTest.php | |
parent | 9ab1488b5d0c70eef07c1a1561f869f2597056e4 (diff) | |
download | sql-parser-f20f41c2bdfdde3da342399769ecb9b544d6783e.zip sql-parser-f20f41c2bdfdde3da342399769ecb9b544d6783e.tar.gz sql-parser-f20f41c2bdfdde3da342399769ecb9b544d6783e.tar.bz2 |
Allow to specify output type to format test
Signed-off-by: Michal Čihař <michal@cihar.com>
Diffstat (limited to 'tests/Utils/FormatterTest.php')
-rw-r--r-- | tests/Utils/FormatterTest.php | 19 |
1 files changed, 12 insertions, 7 deletions
diff --git a/tests/Utils/FormatterTest.php b/tests/Utils/FormatterTest.php index 81b9b28..b638eec 100644 --- a/tests/Utils/FormatterTest.php +++ b/tests/Utils/FormatterTest.php @@ -11,11 +11,11 @@ class FormatTest extends TestCase /** * @dataProvider formatQueries */ - public function testFormat($query, $expected) + public function testFormat($query, $expected, $type) { $this->assertEquals( $expected, - Formatter::format($query, array('type' => 'html')) + Formatter::format($query, array('type' => $type)) ); } @@ -25,18 +25,21 @@ class FormatTest extends TestCase array( 'SELECT 1', '<span class="sql-reserved">SELECT</span>' . "\n" . - ' <span class="sql-number">1</span>' + ' <span class="sql-number">1</span>', + 'html' ), array( 'SELECT 1 # Comment', '<span class="sql-reserved">SELECT</span>' . "\n" . ' <span class="sql-number">1</span> <span class="sql-comment"># Comment' . "\n" . - '</span>' + '</span>', + 'html' ), array( 'SELECT HEX("1")', '<span class="sql-reserved">SELECT</span>' . "\n" . - ' <span class="sql-keyword">HEX</span>(<span class="sql-string">"1"</span>)' + ' <span class="sql-keyword">HEX</span>(<span class="sql-string">"1"</span>)', + 'html' ), array( 'SELECT * FROM foo WHERE bar=1', @@ -45,7 +48,8 @@ class FormatTest extends TestCase '<span class="sql-reserved">FROM</span>' . "\n" . ' foo' . "\n" . '<span class="sql-reserved">WHERE</span>' . "\n" . - ' bar = <span class="sql-number">1</span>' + ' bar = <span class="sql-number">1</span>', + 'html' ), array( 'CREATE PROCEDURE SPTEST() BEGIN FROM a SELECT *; END', @@ -56,7 +60,8 @@ class FormatTest extends TestCase ' a' . "\n" . '<span class="sql-reserved">SELECT</span>' . "\n" . ' *;' . "\n" . - '<span class="sql-keyword">END</span>' + '<span class="sql-keyword">END</span>', + 'html' ), ); } |