summaryrefslogtreecommitdiffstats
path: root/tests/Utils/FormatterTest.php
diff options
context:
space:
mode:
authorMichal Čihař <michal@cihar.com>2016-02-19 14:53:03 +0100
committerMichal Čihař <michal@cihar.com>2016-02-19 14:53:03 +0100
commitf20f41c2bdfdde3da342399769ecb9b544d6783e (patch)
tree83b0e46cfe0f6fc71925e3c7f7fdb7028edcc67a /tests/Utils/FormatterTest.php
parent9ab1488b5d0c70eef07c1a1561f869f2597056e4 (diff)
downloadsql-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.php19
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'
),
);
}