doctrine / orm

tests/Doctrine/Tests/ORM/Functional/Ticket/DDC2214Test.php

<?php

declare(strict_types=1);

namespace Doctrine\Tests\ORM\Functional\Ticket;

use Doctrine\DBAL\Connection;
use Doctrine\ORM\Annotation as ORM;
use Doctrine\Tests\OrmFunctionalTestCase;
use function end;

/**
 * Verifies that the type of parameters being bound to an SQL query is the same
 * of the identifier of the entities used as parameters in the DQL query, even
 * if the bound objects are proxies.
 *
 * @group DDC-2214
 */
class DDC2214Test extends OrmFunctionalTestCase
{
    protected function setUp() : void
    {
        parent::setUp();

        $this->schemaTool->createSchema(
            [
            $this->em->getClassMetadata(DDC2214Foo::class),
            $this->em->getClassMetadata(DDC2214Bar::class),
            ]
        );
    }

    public function testIssue() : void
    {
        $foo = new DDC2214Foo();
        $bar = new DDC2214Bar();

        $foo->bar = $bar;

        $this->em->persist($foo);
        $this->em->persist($bar);
        $this->em->flush();
        $this->em->clear();

        /** @var \Doctrine\Tests\ORM\Functional\Ticket\DDC2214Foo $foo */
        $foo = $this->em->find(DDC2214Foo::class, $foo->id);
        $bar = $foo->bar;

        $logger = $this->em->getConnection()->getConfiguration()->getSQLLogger();

        $related = $this
            ->em
            ->createQuery('SELECT b FROM ' . __NAMESPACE__ . '\DDC2214Bar b WHERE b.id IN(:ids)')
            ->setParameter('ids', [$bar])
            ->getResult();

        $query = end($logger->queries);

Accessing queries on the interface Doctrine\DBAL\Logging\SQLLogger suggest that you code against a concrete implementation. How about adding an instanceof check?

        self::assertEquals(Connection::PARAM_INT_ARRAY, $query['types'][0]);
    }
}

/** @ORM\Entity */
class DDC2214Foo
{
    /** @ORM\Id @ORM\Column(type="integer") @ORM\GeneratedValue(strategy="AUTO") */
    public $id;

    /** @ORM\ManyToOne(targetEntity=DDC2214Bar::class) */
    public $bar;
}

/** @ORM\Entity */
class DDC2214Bar
{
    /** @ORM\Id @ORM\Column(type="integer") @ORM\GeneratedValue(strategy="AUTO") */
    public $id;
}