doctrine / orm

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

<?php

declare(strict_types=1);

namespace Doctrine\Tests\ORM\Functional\Ticket;

use Doctrine\DBAL\Logging\DebugStack;
use Doctrine\ORM\Annotation as ORM;
use Doctrine\Tests\OrmFunctionalTestCase;
use function count;

/**
 * @group DDC-1595
 * @group DDC-1596
 * @group non-cacheable
 */
class DDC1595Test extends OrmFunctionalTestCase
{
    public function setUp() : void
    {
        parent::setUp();

        $this->em->getConnection()->getConfiguration()->setSQLLogger(new DebugStack());

        $this->schemaTool->createSchema(
            [
            $this->em->getClassMetadata(DDC1595BaseInheritance::class),
            $this->em->getClassMetadata(DDC1595InheritedEntity1::class),
            $this->em->getClassMetadata(DDC1595InheritedEntity2::class),
            ]
        );
    }

    public function testIssue() : void
    {
        $e1 = new DDC1595InheritedEntity1();

        $this->em->persist($e1);
        $this->em->flush();
        $this->em->clear();

        $sqlLogger  = $this->em->getConnection()->getConfiguration()->getSQLLogger();
        $repository = $this->em->getRepository(DDC1595InheritedEntity1::class);

        $entity1 = $repository->find($e1->id);

        // DDC-1596
        self::assertSQLEquals(
            'SELECT t0."id" AS c1, t0."type" FROM "base" t0 WHERE t0."id" = ? AND t0."type" IN (\'Entity1\')',
            $sqlLogger->queries[count($sqlLogger->queries)]['sql']

The property queries does not seem to exist on Doctrine\DBAL\Logging\NullLogger.

        );

        $entities = $entity1->getEntities()->getValues();

        self::assertSQLEquals(
            'SELECT t0."id" AS c1, t0."type" FROM "base" t0 INNER JOIN "entity1_entity2" ON t0."id" = "entity1_entity2"."item" WHERE "entity1_entity2"."parent" = ? AND t0."type" IN (\'Entity2\')',
            $sqlLogger->queries[count($sqlLogger->queries)]['sql']
        );

        $this->em->clear();

        $entity1 = $repository->find($e1->id);

        $entity1->getEntities()->count();

        self::assertSQLEquals(
            'SELECT COUNT(*) FROM "entity1_entity2" t WHERE t."parent" = ?',
            $sqlLogger->queries[count($sqlLogger->queries)]['sql']
        );
    }
}

/**
 * @ORM\Entity
 * @ORM\Table(name="base")
 *
 * @ORM\InheritanceType("SINGLE_TABLE")
 * @ORM\DiscriminatorColumn(name="type", type="string")
 * @ORM\DiscriminatorMap({
 *     "Entity1" = DDC1595InheritedEntity1::class,
 *     "Entity2" = DDC1595InheritedEntity2::class
 * })
 */
abstract class DDC1595BaseInheritance
{
    /**
     * @ORM\Id @ORM\GeneratedValue
     * @ORM\Column(type="integer")
     *
     * @var int
     */
    public $id;
}

/**
 * @ORM\Entity
 */
class DDC1595InheritedEntity1 extends DDC1595BaseInheritance
{
    /**
     * @ORM\ManyToMany(targetEntity=DDC1595InheritedEntity2::class, fetch="EXTRA_LAZY")
     * @ORM\JoinTable(name="entity1_entity2",
     *     joinColumns={@ORM\JoinColumn(name="parent", referencedColumnName="id")},
     *     inverseJoinColumns={@ORM\JoinColumn(name="item", referencedColumnName="id")}
     * )
     */
    protected $entities;

    public function getEntities()
    {
        return $this->entities;
    }
}

/**
 * @ORM\Entity
 */
class DDC1595InheritedEntity2 extends DDC1595BaseInheritance
{
}