Day::getSql() - Code Metrics - Inspection of "[Docs] Unify installation sections from Getting St..." - pamil/Sylius - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Push — docs-installation-setup ( 464016 )

by Kamil

created 2020-05-19 13:32 UTC

Day::getSql() A

↳ Parent: Day

Complexity

Conditions	3
Paths	3

Size

Total Lines

Duplication

Lines	0
Ratio	0 %

Importance

Changes

Metric	Value
dl	0
loc	14
rs	9.7998
c	0
b	0
f	0
cc	3
nc	3
nop	1

<?php

/*
 * This file is part of the Sylius package.
 *
 * (c) Paweł Jędrzejewski
 *
 * For the full copyright and license information, please view the LICENSE
 * file that was distributed with this source code.
 */

declare(strict_types=1);

namespace Sylius\Bundle\CoreBundle\Doctrine\DQL;

use Doctrine\ORM\Query\AST\ArithmeticExpression;
use Doctrine\ORM\Query\AST\Functions\FunctionNode;
use Doctrine\ORM\Query\Lexer;
use Doctrine\ORM\Query\Parser;
use Doctrine\ORM\Query\SqlWalker;

final class Day extends FunctionNode
{
    /** @var ArithmeticExpression|null */
    public $date;

    public function parse(Parser $parser): void
    {
        $parser->match(Lexer::T_IDENTIFIER);
        $parser->match(Lexer::T_OPEN_PARENTHESIS);

        $this->date = $parser->ArithmeticPrimary();

        $parser->match(Lexer::T_CLOSE_PARENTHESIS);
    }

    public function getSql(SqlWalker $sqlWalker): string
    {
        $platformName = $sqlWalker->getConnection()->getDatabasePlatform()->getName();

        switch ($platformName) {
            case 'mysql':
                return sprintf('DAY(%s)', $sqlWalker->walkArithmeticPrimary($this->date));

            case 'postgresql':
                return sprintf('EXTRACT(DAY FROM %s)', $sqlWalker->walkArithmeticPrimary($this->date));
        }

        throw new \RuntimeException(sprintf('Platform "%s" is not supported!', $platformName));
    }
}


1			<?php
2
3			/*
4			* This file is part of the Sylius package.
5			*
6			* (c) Paweł Jędrzejewski
7			*
8			* For the full copyright and license information, please view the LICENSE
9			* file that was distributed with this source code.
10			*/
11
12			declare(strict_types=1);
13
14			namespace Sylius\Bundle\CoreBundle\Doctrine\DQL;
15
16			use Doctrine\ORM\Query\AST\ArithmeticExpression;
17			use Doctrine\ORM\Query\AST\Functions\FunctionNode;
18			use Doctrine\ORM\Query\Lexer;
19			use Doctrine\ORM\Query\Parser;
20			use Doctrine\ORM\Query\SqlWalker;
21
22			final class Day extends FunctionNode
23			{
24			/** @var ArithmeticExpression\|null */
25			public $date;
26
27			public function parse(Parser $parser): void
28			{
29			$parser->match(Lexer::T_IDENTIFIER);
30			$parser->match(Lexer::T_OPEN_PARENTHESIS);
31
32			$this->date = $parser->ArithmeticPrimary();
33
34			$parser->match(Lexer::T_CLOSE_PARENTHESIS);
35			}
36
37			public function getSql(SqlWalker $sqlWalker): string
38			{
39			$platformName = $sqlWalker->getConnection()->getDatabasePlatform()->getName();
40
41			switch ($platformName) {
42			case 'mysql':
43			return sprintf('DAY(%s)', $sqlWalker->walkArithmeticPrimary($this->date));
44
45			case 'postgresql':
46			return sprintf('EXTRACT(DAY FROM %s)', $sqlWalker->walkArithmeticPrimary($this->date));
47			}
48
49			throw new \RuntimeException(sprintf('Platform "%s" is not supported!', $platformName));
50			}
51			}
52

pamil / Sylius

Push — docs-installation-setup ( 464016 )

Day::getSql() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like