Doctrine\Tests\ORM\Query\SelectSqlMappingTest

Complexity

Total Complexity

4

Size/Duplication

Total Lines	55
Duplicated Lines	0 %

Importance

Changes	2
Bugs	2	Features	0

3 Methods

Rating	Name	Duplication	Size	Complexity
A	setUp()	0	3	1
A	assertScalarTypes()	0	20	2
A	testTypeFromMathematicNodeFunction()	0	16	1

<?php
declare(strict_types=1);

Expected 2 newlines between PHP open tag and declare statement, found 1.

namespace Doctrine\Tests\ORM\Query;

use Doctrine\DBAL\Types\IntegerType;
use Doctrine\DBAL\Types\StringType;
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

There must be exactly 1 whitespace between closing parenthesis and return type colon.

    {
        $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);

Equals sign not aligned with surrounding assignments; expected 6 spaces but found 1 space

        $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

There must be exactly 1 whitespace between closing parenthesis and return type colon.

    {
        $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'    => StringType::class,
                'average'  => StringType::class,
                'absolute' => StringType::class,
                'length'   => IntegerType::class,
            ]
        );
    }
}