summaryrefslogtreecommitdiffstats
path: root/tests/Components/OptionsArrayTest.php
blob: 0c453daea6324a702fd9d2a9a5780cab3468058f (plain)
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
<?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 = (test) C'),
            array(
                'A' => 1,
                'B' => array(2, 'var'),
                'C' => 3,
            )
        );
        $this->assertEquals(
            array(
                1 => 'A',
                2 => array(
                    'name' => 'B',
                    'value' => 'test',
                    'value_' => 'test',
                    'equal' => false,
                ),
                3 => 'C',
            ),
            $component->options
        );
    }

    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',
                    'value_' => '42',
                    'equal' => true,
                ),
            )
        );
        $this->assertEquals(
            OptionsArray::build($component),
            'ALL SQL_CALC_FOUND_ROWS MAX_STATEMENT_TIME=42'
        );
    }
}