SetStatementTest::testBuilderView() - Code Metrics - Inspection of "GH-310: Adds select validation to create view" - phpmyadmin/sql-parser - Measure and Improve Code Quality continuously with Scrutinizer

Passed

Pull Request — master (#311)

by William

created 2020-08-27 08:25 UTC

SetStatementTest::testBuilderView() B

↳ Parent: SetStatementTest

Complexity

Conditions	1
Paths	1

Size

Total Lines	165
Code Lines	90

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

Metric	Value
cc	1
eloc	90
c	1
b	0
f	0
nc	1
nop	0
dl	0
loc	165
rs	8.2181

How to fix Long Method

<?php

namespace PhpMyAdmin\SqlParser\Tests\Builder;

use PhpMyAdmin\SqlParser\Parser;
use PhpMyAdmin\SqlParser\Tests\TestCase;

class SetStatementTest extends TestCase
{
    public function testBuilderView()
    {
        /* Assertion 1 */
        $query = 'SET CHARACTER SET \'utf8\'';

        $parser = new Parser($query);
        $stmt = $parser->statements[0];

        $this->assertEquals(
            $query,
            $stmt->build()
        );

        /* Assertion 2 */
        $query = 'SET CHARSET \'utf8\'';

        $parser = new Parser($query);
        $stmt = $parser->statements[0];

        $this->assertEquals(
            $query,
            $stmt->build()
        );

        /* Assertion 3 */
        $query = 'SET NAMES \'utf8\'';

        $parser = new Parser($query);
        $stmt = $parser->statements[0];

        $this->assertEquals(
            $query,
            $stmt->build()
        );

        /* Assertion 4 */
        $query = 'SET NAMES \'utf8\' COLLATE \'utf8_general_ci\'';

        $parser = new Parser($query);
        $stmt = $parser->statements[0];

        $this->assertEquals(
            'SET NAMES \'utf8\'  COLLATE \'utf8_general_ci\'',
            $stmt->build()
        );

        /* Assertion 5 */
        $query = 'SET NAMES \'utf8\' DEFAULT';

        $parser = new Parser($query);
        $stmt = $parser->statements[0];

        $this->assertEquals(
            'SET NAMES \'utf8\'  DEFAULT',
            $stmt->build()
        );

        /* Assertion 6 */
        $query = 'SET sql_mode = \'TRADITIONAL\'';

        $parser = new Parser($query);
        $stmt = $parser->statements[0];

        $this->assertEquals(
            'SET  sql_mode = \'TRADITIONAL\'',
            $stmt->build()
        );

        /* Assertion 7 */
        $query = 'SET SESSION   sql_mode = \'TRADITIONAL\'';

        $parser = new Parser($query);
        $stmt = $parser->statements[0];

        $this->assertEquals(
            'SET SESSION sql_mode = \'TRADITIONAL\'',
            $stmt->build()
        );

        /* Assertion 8 */
        $query = 'SET GLOBAL   sql_mode = \'TRADITIONAL\'';

        $parser = new Parser($query);
        $stmt = $parser->statements[0];

        $this->assertEquals(
            'SET GLOBAL sql_mode = \'TRADITIONAL\'',
            $stmt->build()
        );

        /* Assertion 9 */
        $query = 'SET @@SESSION   sql_mode = \'TRADITIONAL\'';

        $parser = new Parser($query);
        $stmt = $parser->statements[0];

        $this->assertEquals(
            'SET SESSION sql_mode = \'TRADITIONAL\'',
            $stmt->build()
        );

        /* Assertion 10 */
        $query = 'SET @@GLOBAL   sql_mode = \'TRADITIONAL\'';

        $parser = new Parser($query);
        $stmt = $parser->statements[0];

        $this->assertEquals(
            'SET GLOBAL sql_mode = \'TRADITIONAL\'',
            $stmt->build()
        );

        /* Assertion 11 */
        $query = 'SET @@sql_mode = \'TRADITIONAL\'';

        $parser = new Parser($query);
        $stmt = $parser->statements[0];

        $this->assertEquals(
            'SET  @@sql_mode = \'TRADITIONAL\'',
            $stmt->build()
        );

        /* Assertion 12 */
        $query = 'SET PERSIST sql_mode = \'TRADITIONAL\'';

        $parser = new Parser($query);
        $stmt = $parser->statements[0];

        $this->assertEquals(
            'SET PERSIST sql_mode = \'TRADITIONAL\'',
            $stmt->build()
        );

        /* Assertion 13 */
        $query = 'SET PERSIST_ONLY sql_mode = \'TRADITIONAL\'';

        $parser = new Parser($query);
        $stmt = $parser->statements[0];

        $this->assertEquals(
            'SET PERSIST_ONLY sql_mode = \'TRADITIONAL\'',
            $stmt->build()
        );

        /* Assertion 14 */
        $query = 'SET @@PERSIST sql_mode = \'TRADITIONAL\'';

        $parser = new Parser($query);
        $stmt = $parser->statements[0];

        $this->assertEquals(
            'SET PERSIST sql_mode = \'TRADITIONAL\'',
            $stmt->build()
        );

        /* Assertion 15 */
        $query = 'SET @@PERSIST_ONLY sql_mode = \'TRADITIONAL\'';

        $parser = new Parser($query);
        $stmt = $parser->statements[0];

        $this->assertEquals(
            'SET PERSIST_ONLY sql_mode = \'TRADITIONAL\'',
            $stmt->build()
        );
    }
}


1			<?php
2
3			namespace PhpMyAdmin\SqlParser\Tests\Builder;
4
5			use PhpMyAdmin\SqlParser\Parser;
6			use PhpMyAdmin\SqlParser\Tests\TestCase;
7
8			class SetStatementTest extends TestCase
9			{
10			public function testBuilderView()
11			{
12			/* Assertion 1 */
13			$query = 'SET CHARACTER SET \'utf8\'';
14
15			$parser = new Parser($query);
16			$stmt = $parser->statements[0];
17
18			$this->assertEquals(
19			$query,
20			$stmt->build()
21			);
22
23			/* Assertion 2 */
24			$query = 'SET CHARSET \'utf8\'';
25
26			$parser = new Parser($query);
27			$stmt = $parser->statements[0];
28
29			$this->assertEquals(
30			$query,
31			$stmt->build()
32			);
33
34			/* Assertion 3 */
35			$query = 'SET NAMES \'utf8\'';
36
37			$parser = new Parser($query);
38			$stmt = $parser->statements[0];
39
40			$this->assertEquals(
41			$query,
42			$stmt->build()
43			);
44
45			/* Assertion 4 */
46			$query = 'SET NAMES \'utf8\' COLLATE \'utf8_general_ci\'';
47
48			$parser = new Parser($query);
49			$stmt = $parser->statements[0];
50
51			$this->assertEquals(
52			'SET NAMES \'utf8\' COLLATE \'utf8_general_ci\'',
53			$stmt->build()
54			);
55
56			/* Assertion 5 */
57			$query = 'SET NAMES \'utf8\' DEFAULT';
58
59			$parser = new Parser($query);
60			$stmt = $parser->statements[0];
61
62			$this->assertEquals(
63			'SET NAMES \'utf8\' DEFAULT',
64			$stmt->build()
65			);
66
67			/* Assertion 6 */
68			$query = 'SET sql_mode = \'TRADITIONAL\'';
69
70			$parser = new Parser($query);
71			$stmt = $parser->statements[0];
72
73			$this->assertEquals(
74			'SET sql_mode = \'TRADITIONAL\'',
75			$stmt->build()
76			);
77
78			/* Assertion 7 */
79			$query = 'SET SESSION sql_mode = \'TRADITIONAL\'';
80
81			$parser = new Parser($query);
82			$stmt = $parser->statements[0];
83
84			$this->assertEquals(
85			'SET SESSION sql_mode = \'TRADITIONAL\'',
86			$stmt->build()
87			);
88
89			/* Assertion 8 */
90			$query = 'SET GLOBAL sql_mode = \'TRADITIONAL\'';
91
92			$parser = new Parser($query);
93			$stmt = $parser->statements[0];
94
95			$this->assertEquals(
96			'SET GLOBAL sql_mode = \'TRADITIONAL\'',
97			$stmt->build()
98			);
99
100			/* Assertion 9 */
101			$query = 'SET @@SESSION sql_mode = \'TRADITIONAL\'';
102
103			$parser = new Parser($query);
104			$stmt = $parser->statements[0];
105
106			$this->assertEquals(
107			'SET SESSION sql_mode = \'TRADITIONAL\'',
108			$stmt->build()
109			);
110
111			/* Assertion 10 */
112			$query = 'SET @@GLOBAL sql_mode = \'TRADITIONAL\'';
113
114			$parser = new Parser($query);
115			$stmt = $parser->statements[0];
116
117			$this->assertEquals(
118			'SET GLOBAL sql_mode = \'TRADITIONAL\'',
119			$stmt->build()
120			);
121
122			/* Assertion 11 */
123			$query = 'SET @@sql_mode = \'TRADITIONAL\'';
124
125			$parser = new Parser($query);
126			$stmt = $parser->statements[0];
127
128			$this->assertEquals(
129			'SET @@sql_mode = \'TRADITIONAL\'',
130			$stmt->build()
131			);
132
133			/* Assertion 12 */
134			$query = 'SET PERSIST sql_mode = \'TRADITIONAL\'';
135
136			$parser = new Parser($query);
137			$stmt = $parser->statements[0];
138
139			$this->assertEquals(
140			'SET PERSIST sql_mode = \'TRADITIONAL\'',
141			$stmt->build()
142			);
143
144			/* Assertion 13 */
145			$query = 'SET PERSIST_ONLY sql_mode = \'TRADITIONAL\'';
146
147			$parser = new Parser($query);
148			$stmt = $parser->statements[0];
149
150			$this->assertEquals(
151			'SET PERSIST_ONLY sql_mode = \'TRADITIONAL\'',
152			$stmt->build()
153			);
154
155			/* Assertion 14 */
156			$query = 'SET @@PERSIST sql_mode = \'TRADITIONAL\'';
157
158			$parser = new Parser($query);
159			$stmt = $parser->statements[0];
160
161			$this->assertEquals(
162			'SET PERSIST sql_mode = \'TRADITIONAL\'',
163			$stmt->build()
164			);
165
166			/* Assertion 15 */
167			$query = 'SET @@PERSIST_ONLY sql_mode = \'TRADITIONAL\'';
168
169			$parser = new Parser($query);
170			$stmt = $parser->statements[0];
171
172			$this->assertEquals(
173			'SET PERSIST_ONLY sql_mode = \'TRADITIONAL\'',
174			$stmt->build()
175			);
176			}
177			}
178

phpmyadmin / sql-parser

Pull Request — master (#311)

SetStatementTest::testBuilderView() B

Complexity

Size

Duplication

Importance

How to fix Long Method

Long Method

Duplication Side-by-Side

Filter issues like