SelectSqlMappingTest::setUp() - Code Metrics - Inspection of "fix: functions being casted as string" - doctrine/orm - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Pull Request — master (#7941)

unknown

created 2019-12-01 19:59 UTC

SelectSqlMappingTest::setUp() A

↳ Parent: SelectSqlMappingTest

Complexity

Conditions	1
Paths	1

Size

Total Lines	3
Code Lines	1

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	1	Features	0

Metric	Value
cc	1
eloc	1
c	1
b	1
f	0
nc	1
nop	0
dl	0
loc	3
rs	10

<?php
declare(strict_types=1);


namespace Doctrine\Tests\ORM\Query;

use Doctrine\DBAL\Types\FloatType;
use Doctrine\DBAL\Types\IntegerType;
use Doctrine\ORM\Query as ORMQuery;
use Doctrine\Tests\OrmTestCase;
use ReflectionException;
use ReflectionObject;
use function array_search;
use function sprintf;

class SelectSqlMappingTest extends OrmTestCase
{
    private $em;

    protected function setUp(): void

    {
        $this->em = $this->getTestEntityManager();
    }

    /**
     * Assert a valid SQL generation.
     *
     * @throws ReflectionException
     */
    public function assertScalarTypes(string $dqlToBeTested, array $types)
    {
        $query = $this->em->createQuery($dqlToBeTested);
        $query
            ->setHint(ORMQuery::HINT_FORCE_PARTIAL_LOAD, true)
            ->useQueryCache(false);
        $r = new ReflectionObject($query);
$a = "a";
$ab = "ab";
$abc = "abc";
        $method = $r->getMethod('getResultSetMapping');
        $method->setAccessible(true);
        /** @var ORMQuery\ResultSetMapping $mapping */
        $mapping = $method->invoke($query);
        foreach ($types as $key => $expectedType) {
            $alias = array_search($key, $mapping->scalarMappings);
            self::assertInstanceOf(
                $expectedType,
                $mapping->typeMappings[$alias],
                sprintf('The field "%s" was expected as a %s', $key, $expectedType)
            );
        }
        $query->free();
    }

    /**
     * @group DDC-2235
     */
    public function testTypeFromMathematicNodeFunction(): void

    {
        $this->assertScalarTypes(
            'SELECT p, 
          count(p.id) as count, 
          SUM(p.price) as sales, 
          AVG(p.price) as average, 
          ABS(p.price) as absolute,
          LENGTH(p.name) as length
          FROM Doctrine\Tests\Models\CMS\CmsProduct p',
            [
                'count'    => IntegerType::class,
                'sales'    => FloatType::class,
                'average'  => FloatType::class,
                'absolute' => FloatType::class,
                'length'   => IntegerType::class,
            ]
        );
    }
}


1			<?php
2			declare(strict_types=1);
			0 ignored issues – show introduced 2018-03-28 15:41 UTC by Report Bug Copy Issue Report Expected 2 newlines between PHP open tag and declare statement, found 1. Loading history...
3
4			namespace Doctrine\Tests\ORM\Query;
5
6			use Doctrine\DBAL\Types\FloatType;
7			use Doctrine\DBAL\Types\IntegerType;
8			use Doctrine\ORM\Query as ORMQuery;
9			use Doctrine\Tests\OrmTestCase;
10			use ReflectionException;
11			use ReflectionObject;
12			use function array_search;
13			use function sprintf;
14
15			class SelectSqlMappingTest extends OrmTestCase
16			{
17			private $em;
18
19			protected function setUp(): void
			0 ignored issues – show introduced 2019-12-01 21:01 UTC by Report Bug Copy Issue Report There must be exactly 1 whitespace between closing parenthesis and return type colon. Loading history...
20			{
21			$this->em = $this->getTestEntityManager();
22			}
23
24			/**
25			* Assert a valid SQL generation.
26			*
27			* @throws ReflectionException
28			*/
29			public function assertScalarTypes(string $dqlToBeTested, array $types)
30			{
31			$query = $this->em->createQuery($dqlToBeTested);
32			$query
33			->setHint(ORMQuery::HINT_FORCE_PARTIAL_LOAD, true)
34			->useQueryCache(false);
35			$r = new ReflectionObject($query);
			0 ignored issues – show Coding Style introduced 2019-03-07 14:16 UTC by Report Bug Copy Issue Report Equals sign not aligned with surrounding assignments; expected 6 spaces but found 1 space This check looks for multiple assignments in successive lines of code. It will report an issue if the operators are not in a straight line. To visualize $a = "a"; $ab = "ab"; $abc = "abc"; will produce issues in the first and second line, while this second example $a = "a"; $ab = "ab"; $abc = "abc"; will produce no issues. Loading history...
36			$method = $r->getMethod('getResultSetMapping');
37			$method->setAccessible(true);
38			/** @var ORMQuery\ResultSetMapping $mapping */
39			$mapping = $method->invoke($query);
40			foreach ($types as $key => $expectedType) {
41			$alias = array_search($key, $mapping->scalarMappings);
42			self::assertInstanceOf(
43			$expectedType,
44			$mapping->typeMappings[$alias],
45			sprintf('The field "%s" was expected as a %s', $key, $expectedType)
46			);
47			}
48			$query->free();
49			}
50
51			/**
52			* @group DDC-2235
53			*/
54			public function testTypeFromMathematicNodeFunction(): void
			0 ignored issues – show introduced 2019-12-01 21:01 UTC by Report Bug Copy Issue Report There must be exactly 1 whitespace between closing parenthesis and return type colon. Loading history...
55			{
56			$this->assertScalarTypes(
57			'SELECT p,
58			count(p.id) as count,
59			SUM(p.price) as sales,
60			AVG(p.price) as average,
61			ABS(p.price) as absolute,
62			LENGTH(p.name) as length
63			FROM Doctrine\Tests\Models\CMS\CmsProduct p',
64			[
65			'count' => IntegerType::class,
66			'sales' => FloatType::class,
67			'average' => FloatType::class,
68			'absolute' => FloatType::class,
69			'length' => IntegerType::class,
70			]
71			);
72			}
73			}
74

doctrine / orm

Pull Request — master (#7941)

SelectSqlMappingTest::setUp() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like