1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
|
<?php
namespace SqlParser\Tests\Utils;
use SqlParser\Utils\Formatter;
use SqlParser\Tests\TestCase;
class FormatTest extends TestCase
{
/**
* @dataProvider formatQueries
*/
public function testFormat($query, $expected, $type)
{
$this->assertEquals(
$expected,
Formatter::format($query, array('type' => $type))
);
}
public function formatQueries()
{
return array(
array(
'SELECT 1',
'<span class="sql-reserved">SELECT</span>' . "\n" .
' <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>',
'html'
),
array(
'SELECT HEX("1")',
'<span class="sql-reserved">SELECT</span>' . "\n" .
' <span class="sql-keyword">HEX</span>(<span class="sql-string">"1"</span>)',
'html'
),
array(
'SELECT * FROM foo WHERE bar=1',
'<span class="sql-reserved">SELECT</span>' . "\n" .
' *' . "\n" .
'<span class="sql-reserved">FROM</span>' . "\n" .
' foo' . "\n" .
'<span class="sql-reserved">WHERE</span>' . "\n" .
' bar = <span class="sql-number">1</span>',
'html'
),
array(
'CREATE PROCEDURE SPTEST() BEGIN FROM a SELECT *; END',
'<span class="sql-reserved">CREATE</span>' . "\n" .
'<span class="sql-reserved">PROCEDURE</span> SPTEST()' . "\n" .
'<span class="sql-keyword">BEGIN</span>' . "\n" .
'<span class="sql-reserved">FROM</span>' . "\n" .
' a' . "\n" .
'<span class="sql-reserved">SELECT</span>' . "\n" .
' *;' . "\n" .
'<span class="sql-keyword">END</span>',
'html'
),
array(
'INSERT INTO foo VALUES (0, 0, 0), (1, 1, 1)',
'<span class="sql-reserved">INSERT</span>' . "\n" .
'<span class="sql-reserved">INTO</span>' . "\n" .
' foo' . "\n" .
'<span class="sql-reserved">VALUES</span>' .
'(<span class="sql-number">0</span>, <span class="sql-number">0</span>, <span class="sql-number">0</span>),' .
'(<span class="sql-number">1</span>, <span class="sql-number">1</span>, <span class="sql-number">1</span>)',
'html'
),
array(
'SELECT 1',
"\x1b[35mSELECT\n \x1b[92m1\e[0m",
'cli'
),
);
}
}
|
