1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126
|
<?php
declare(strict_types=1);
namespace Doctrine\Tests\ORM\Functional\Ticket;
use Doctrine\Common\Collections\Collection;
use Doctrine\ORM\Mapping\Column;
use Doctrine\ORM\Mapping\DiscriminatorColumn;
use Doctrine\ORM\Mapping\DiscriminatorMap;
use Doctrine\ORM\Mapping\Entity;
use Doctrine\ORM\Mapping\GeneratedValue;
use Doctrine\ORM\Mapping\Id;
use Doctrine\ORM\Mapping\InheritanceType;
use Doctrine\ORM\Mapping\JoinColumn;
use Doctrine\ORM\Mapping\JoinTable;
use Doctrine\ORM\Mapping\ManyToMany;
use Doctrine\ORM\Mapping\Table;
use Doctrine\Tests\OrmFunctionalTestCase;
/**
* @group DDC-1595
* @group DDC-1596
* @group non-cacheable
*/
class DDC1595Test extends OrmFunctionalTestCase
{
protected function setUp(): void
{
parent::setUp();
$this->createSchemaForModels(
DDC1595BaseInheritance::class,
DDC1595InheritedEntity1::class,
DDC1595InheritedEntity2::class
);
}
public function testIssue(): void
{
$e1 = new DDC1595InheritedEntity1();
$this->_em->persist($e1);
$this->_em->flush();
$this->_em->clear();
$repository = $this->_em->getRepository(DDC1595InheritedEntity1::class);
$entity1 = $repository->find($e1->id);
// DDC-1596
$this->assertSQLEquals(
"SELECT t0.id AS id_1, t0.type FROM base t0 WHERE t0.id = ? AND t0.type IN ('Entity1')",
$this->getLastLoggedQuery()['sql']
);
$entities = $entity1->getEntities()->getValues();
self::assertEquals(
"SELECT t0.id AS id_1, t0.type FROM base t0 INNER JOIN entity1_entity2 ON t0.id = entity1_entity2.item WHERE entity1_entity2.parent = ? AND t0.type IN ('Entity2')",
$this->getLastLoggedQuery()['sql']
);
$this->_em->clear();
$entity1 = $repository->find($e1->id);
$entities = $entity1->getEntities()->count();
$this->assertSQLEquals(
'SELECT COUNT(*) FROM entity1_entity2 t WHERE t.parent = ?',
$this->getLastLoggedQuery()['sql']
);
}
}
/**
* @Entity
* @Table(name="base")
* @InheritanceType("SINGLE_TABLE")
* @DiscriminatorColumn(name="type", type="string")
* @DiscriminatorMap({
* "Entity1" = "DDC1595InheritedEntity1",
* "Entity2" = "DDC1595InheritedEntity2"
* })
*/
abstract class DDC1595BaseInheritance
{
/**
* @Id
* @GeneratedValue
* @Column(type="integer")
* @var int
*/
public $id;
}
/**
* @Entity
* @Table(name="entity1")
*/
class DDC1595InheritedEntity1 extends DDC1595BaseInheritance
{
/**
* @psalm-var Collection<int, DDC1595InheritedEntity2>
* @ManyToMany(targetEntity="DDC1595InheritedEntity2", fetch="EXTRA_LAZY")
* @JoinTable(name="entity1_entity2",
* joinColumns={@JoinColumn(name="parent", referencedColumnName="id")},
* inverseJoinColumns={@JoinColumn(name="item", referencedColumnName="id")}
* )
*/
protected $entities;
/** @psalm-return Collection<int, DDC1595InheritedEntity2> */
public function getEntities(): Collection
{
return $this->entities;
}
}
/**
* @Entity
* @Table(name="entity2")
*/
class DDC1595InheritedEntity2 extends DDC1595BaseInheritance
{
}
|