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
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
|
<?php
namespace SqlParser\Tests\Components;
use SqlParser\Parser;
use SqlParser\Components\OptionsArray;
use SqlParser\Tests\TestCase;
class OptionsArrayTest extends TestCase
{
public function testParse()
{
$component = OptionsArray::parse(
new Parser(),
$this->getTokensList('A B = /*comment*/ (test) C'),
array(
'A' => 1,
'B' => array(2, 'var'),
'C' => 3,
)
);
$this->assertEquals(
array(
1 => 'A',
2 => array(
'name' => 'B',
'expr' => '(test)',
'value' => 'test',
'equals' => true,
),
3 => 'C',
),
$component->options
);
}
public function testParseExpr()
{
$component = OptionsArray::parse(
new Parser(),
$this->getTokensList('SUM = (3 + 5) RESULT = 8'),
array(
'SUM' => array(1, 'expr', array('parenthesesDelimited' => true)),
'RESULT' => array(2, 'var'),
)
);
$this->assertEquals('(3 + 5)', (string) $component->has('SUM', true));
$this->assertEquals('8', $component->has('RESULT'));
}
public function testHas()
{
$component = OptionsArray::parse(
new Parser(),
$this->getTokensList('A B = /*comment*/ (test) C'),
array(
'A' => 1,
'B' => array(2, 'var'),
'C' => 3,
)
);
$this->assertTrue($component->has('A'));
$this->assertEquals('test', $component->has('B'));
$this->assertTrue($component->has('C'));
$this->assertFalse($component->has('D'));
}
public function testRemove()
{
/* Assertion 1 */
$component = new OptionsArray(array('a', 'b', 'c'));
$this->assertTrue($component->remove('b'));
$this->assertFalse($component->remove('d'));
$this->assertEquals($component->options, array(0 => 'a', 2 => 'c'));
/* Assertion 2 */
$component = OptionsArray::parse(
new Parser(),
$this->getTokensList('A B = /*comment*/ (test) C'),
array(
'A' => 1,
'B' => array(2, 'var'),
'C' => 3,
)
);
$this->assertEquals('test', $component->has('B'));
$component->remove('B');
$this->assertFalse($component->has('B'));
}
public function testMerge()
{
$component = new OptionsArray(array('a'));
$component->merge(array('b', 'c'));
$this->assertEquals($component->options, array('a', 'b', 'c'));
}
public function testBuild()
{
$component = new OptionsArray(
array(
'ALL',
'SQL_CALC_FOUND_ROWS',
array(
'name' => 'MAX_STATEMENT_TIME',
'value' => '42',
'equals' => true,
),
)
);
$this->assertEquals(
OptionsArray::build($component),
'ALL SQL_CALC_FOUND_ROWS MAX_STATEMENT_TIME=42'
);
}
}
|
