Passed
Pull Request — master (#382)
by
unknown
03:04
created

AlterStatementTest::testBuilderCompressed()   A

Complexity

Conditions 1
Paths 1

Size

Total Lines 6
Code Lines 4

Duplication

Lines 0
Ratio 0 %

Importance

Changes 0
Metric Value
cc 1
eloc 4
c 0
b 0
f 0
nc 1
nop 0
dl 0
loc 6
rs 10
1
<?php
2
3
declare(strict_types=1);
4
5
namespace PhpMyAdmin\SqlParser\Tests\Builder;
6
7
use PhpMyAdmin\SqlParser\Parser;
8
use PhpMyAdmin\SqlParser\Tests\TestCase;
9
10
class AlterStatementTest extends TestCase
11
{
12
    public function testBuilder(): void
13
    {
14
        $query = 'ALTER TABLE `actor` ' .
15
            'ADD PRIMARY KEY (`actor_id`), ' .
16
            'ADD KEY `idx_actor_last_name` (`last_name`)';
17
18
        $parser = new Parser($query);
19
        $stmt = $parser->statements[0];
20
21
        $this->assertEquals($query, $stmt->build());
22
    }
23
24
    public function testBuilderCompressed(): void
25
    {
26
        $query = 'ALTER TABLE `user` CHANGE `message` `message` TEXT COMPRESSED';
27
        $parser = new Parser($query);
28
        $stmt = $parser->statements[0];
29
        $this->assertEquals($query, $stmt->build());
30
    }
31
}
32