SelectStatementTest::selectProvider() - Code Metrics - Inspection of "366c169c53272926f629490c8e5a20dcfebee2a7" - phpmyadmin/sql-parser - Measure and Improve Code Quality continuously with Scrutinizer

Passed

Branch — master (366c16)

by William

created 2020-08-16 13:39 UTC

SelectStatementTest::selectProvider() B

↳ Parent: SelectStatementTest

Complexity

Conditions	1
Paths	1

Size

Total Lines	62
Code Lines	60

Duplication

Lines	0
Ratio	0 %

Importance

Changes

Metric	Value
cc	1
eloc	60
c	0
b	0
f	0
nc	1
nop	0
dl	0
loc	62
rs	8.8727

How to fix Long Method

<?php

declare(strict_types=1);

namespace PhpMyAdmin\SqlParser\Tests\Parser;

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

class SelectStatementTest extends TestCase
{
    public function testSelectOptions()
    {
        $data = $this->getData('parser/parseSelect');
        $parser = new Parser($data['query']);
        $stmt = $parser->statements[0];
        $this->assertEquals(10, $stmt->options->has('MAX_STATEMENT_TIME'));
    }

    /**
     * @param mixed $test
     *
     * @dataProvider selectProvider
     */
    public function testSelect($test)
    {
        $this->runParserTest($test);
    }

    public function selectProvider()
    {
        return [
            ['parser/parseSelect2'],
            ['parser/parseSelect3'],
            ['parser/parseSelect4'],
            ['parser/parseSelect5'],
            ['parser/parseSelect6'],
            ['parser/parseSelect7'],
            ['parser/parseSelect8'],
            ['parser/parseSelect9'],
            ['parser/parseSelect10'],
            ['parser/parseSelect11'],
            ['parser/parseSelectErr1'],
            ['parser/parseSelectErr2'],
            ['parser/parseSelectNested'],
            ['parser/parseSelectCase1'],
            ['parser/parseSelectCase2'],
            ['parser/parseSelectCase3'],
            ['parser/parseSelectCase4'],
            ['parser/parseSelectCase5'],
            ['parser/parseSelectCaseErr1'],
            ['parser/parseSelectCaseErr2'],
            ['parser/parseSelectCaseErr3'],
            ['parser/parseSelectCaseErr4'],
            ['parser/parseSelectCaseErr5'],
            ['parser/parseSelectCaseAlias1'],
            ['parser/parseSelectCaseAlias2'],
            ['parser/parseSelectCaseAlias3'],
            ['parser/parseSelectCaseAlias4'],
            ['parser/parseSelectCaseAlias5'],
            ['parser/parseSelectCaseAlias6'],
            ['parser/parseSelectCaseAliasErr1'],
            ['parser/parseSelectCaseAliasErr2'],
            ['parser/parseSelectCaseAliasErr3'],
            ['parser/parseSelectCaseAliasErr4'],
            ['parser/parseSelectExists'],
            ['parser/parseSelectIntoOptions1'],
            ['parser/parseSelectIntoOptions2'],
            ['parser/parseSelectIntoOptions3'],
            ['parser/parseSelectJoinCross'],
            ['parser/parseSelectJoinNatural'],
            ['parser/parseSelectJoinNaturalLeft'],
            ['parser/parseSelectJoinNaturalRight'],
            ['parser/parseSelectJoinNaturalLeftOuter'],
            ['parser/parseSelectJoinNaturalRightOuter'],
            ['parser/parseSelectJoinMultiple'],
            ['parser/parseSelectJoinMultiple2'],
            ['parser/parseSelectWrongOrder'],
            ['parser/parseSelectWrongOrder2'],
            ['parser/parseSelectEndOptions1'],
            ['parser/parseSelectEndOptions2'],
            ['parser/parseSelectEndOptionsErr'],
            ['parser/parseSelectUnion'],
            ['parser/parseSelectUnion2'],
            ['parser/parseSelectIndexHint1'],
            ['parser/parseSelectIndexHint2'],
            ['parser/parseSelectIndexHintErr1'],
            ['parser/parseSelectIndexHintErr2'],
            ['parser/parseSelectIndexHintErr3'],
            ['parser/parseSelectIndexHintErr4'],
            ['parser/parseSelectWithParenthesis'],
        ];
    }
}


1			<?php
2
3			declare(strict_types=1);
4
5			namespace PhpMyAdmin\SqlParser\Tests\Parser;
6
7			use PhpMyAdmin\SqlParser\Parser;
8			use PhpMyAdmin\SqlParser\Tests\TestCase;
9
10			class SelectStatementTest extends TestCase
11			{
12			public function testSelectOptions()
13			{
14			$data = $this->getData('parser/parseSelect');
15			$parser = new Parser($data['query']);
16			$stmt = $parser->statements[0];
17			$this->assertEquals(10, $stmt->options->has('MAX_STATEMENT_TIME'));
18			}
19
20			/**
21			* @param mixed $test
22			*
23			* @dataProvider selectProvider
24			*/
25			public function testSelect($test)
26			{
27			$this->runParserTest($test);
28			}
29
30			public function selectProvider()
31			{
32			return [
33			['parser/parseSelect2'],
34			['parser/parseSelect3'],
35			['parser/parseSelect4'],
36			['parser/parseSelect5'],
37			['parser/parseSelect6'],
38			['parser/parseSelect7'],
39			['parser/parseSelect8'],
40			['parser/parseSelect9'],
41			['parser/parseSelect10'],
42			['parser/parseSelect11'],
43			['parser/parseSelectErr1'],
44			['parser/parseSelectErr2'],
45			['parser/parseSelectNested'],
46			['parser/parseSelectCase1'],
47			['parser/parseSelectCase2'],
48			['parser/parseSelectCase3'],
49			['parser/parseSelectCase4'],
50			['parser/parseSelectCase5'],
51			['parser/parseSelectCaseErr1'],
52			['parser/parseSelectCaseErr2'],
53			['parser/parseSelectCaseErr3'],
54			['parser/parseSelectCaseErr4'],
55			['parser/parseSelectCaseErr5'],
56			['parser/parseSelectCaseAlias1'],
57			['parser/parseSelectCaseAlias2'],
58			['parser/parseSelectCaseAlias3'],
59			['parser/parseSelectCaseAlias4'],
60			['parser/parseSelectCaseAlias5'],
61			['parser/parseSelectCaseAlias6'],
62			['parser/parseSelectCaseAliasErr1'],
63			['parser/parseSelectCaseAliasErr2'],
64			['parser/parseSelectCaseAliasErr3'],
65			['parser/parseSelectCaseAliasErr4'],
66			['parser/parseSelectExists'],
67			['parser/parseSelectIntoOptions1'],
68			['parser/parseSelectIntoOptions2'],
69			['parser/parseSelectIntoOptions3'],
70			['parser/parseSelectJoinCross'],
71			['parser/parseSelectJoinNatural'],
72			['parser/parseSelectJoinNaturalLeft'],
73			['parser/parseSelectJoinNaturalRight'],
74			['parser/parseSelectJoinNaturalLeftOuter'],
75			['parser/parseSelectJoinNaturalRightOuter'],
76			['parser/parseSelectJoinMultiple'],
77			['parser/parseSelectJoinMultiple2'],
78			['parser/parseSelectWrongOrder'],
79			['parser/parseSelectWrongOrder2'],
80			['parser/parseSelectEndOptions1'],
81			['parser/parseSelectEndOptions2'],
82			['parser/parseSelectEndOptionsErr'],
83			['parser/parseSelectUnion'],
84			['parser/parseSelectUnion2'],
85			['parser/parseSelectIndexHint1'],
86			['parser/parseSelectIndexHint2'],
87			['parser/parseSelectIndexHintErr1'],
88			['parser/parseSelectIndexHintErr2'],
89			['parser/parseSelectIndexHintErr3'],
90			['parser/parseSelectIndexHintErr4'],
91			['parser/parseSelectWithParenthesis'],
92			];
93			}
94			}
95

phpmyadmin / sql-parser

Branch — master (366c16)

SelectStatementTest::selectProvider() B

Complexity

Size

Duplication

Importance

How to fix Long Method

Long Method

Duplication Side-by-Side

Filter issues like