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 127 128
|
<?php
declare(strict_types=1);
namespace Doctrine\Tests\ORM\Functional;
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\InverseJoinColumn;
use Doctrine\ORM\Mapping\JoinColumn;
use Doctrine\ORM\Mapping\JoinTable;
use Doctrine\ORM\Mapping\ManyToMany;
use Doctrine\ORM\Mapping\ManyToOne;
use Doctrine\ORM\Mapping\OneToMany;
use Doctrine\ORM\Mapping\OrderBy;
use Doctrine\Tests\OrmFunctionalTestCase;
/**
* Functional tests for the Single Table Inheritance mapping strategy.
*/
class OrderedJoinedTableInheritanceCollectionTest extends OrmFunctionalTestCase
{
protected function setUp(): void
{
parent::setUp();
$this->createSchemaForModels(
OJTICPet::class,
OJTICCat::class,
OJTICDog::class,
);
$dog = new OJTICDog();
$dog->name = 'Poofy';
$dog1 = new OJTICDog();
$dog1->name = 'Zampa';
$dog2 = new OJTICDog();
$dog2->name = 'Aari';
$dog1->mother = $dog;
$dog2->mother = $dog;
$dog->children[] = $dog1;
$dog->children[] = $dog2;
$this->_em->persist($dog);
$this->_em->persist($dog1);
$this->_em->persist($dog2);
$this->_em->flush();
$this->_em->clear();
}
public function testOrderdOneToManyCollection(): void
{
$poofy = $this->_em->createQuery("SELECT p FROM Doctrine\Tests\ORM\Functional\OJTICPet p WHERE p.name = 'Poofy'")->getSingleResult();
self::assertEquals('Aari', $poofy->children[0]->getName());
self::assertEquals('Zampa', $poofy->children[1]->getName());
$this->_em->clear();
$result = $this->_em->createQuery(
"SELECT p, c FROM Doctrine\Tests\ORM\Functional\OJTICPet p JOIN p.children c WHERE p.name = 'Poofy'",
)
->getResult();
self::assertCount(1, $result);
$poofy = $result[0];
self::assertEquals('Aari', $poofy->children[0]->getName());
self::assertEquals('Zampa', $poofy->children[1]->getName());
}
}
#[Entity]
#[InheritanceType('JOINED')]
#[DiscriminatorColumn(name: 'discr', type: 'string')]
#[DiscriminatorMap(['cat' => 'OJTICCat', 'dog' => 'OJTICDog'])]
abstract class OJTICPet
{
/** @var int */
#[Id]
#[Column(type: 'integer')]
#[GeneratedValue(strategy: 'AUTO')]
public $id;
/** @var string */
#[Column]
public $name;
/** @var OJTICPet */
#[ManyToOne(targetEntity: 'OJTICPet')]
public $mother;
/** @phpstan-var Collection<int, OJTICPet> */
#[OneToMany(targetEntity: 'OJTICPet', mappedBy: 'mother')]
#[OrderBy(['name' => 'ASC'])]
public $children;
/** @phpstan-var Collection<int, OJTICPet> */
#[JoinTable(name: 'OTJIC_Pet_Friends')]
#[JoinColumn(name: 'pet_id', referencedColumnName: 'id')]
#[InverseJoinColumn(name: 'friend_id', referencedColumnName: 'id')]
#[ManyToMany(targetEntity: 'OJTICPet')]
#[OrderBy(['name' => 'ASC'])]
public $friends;
public function getName(): string
{
return $this->name;
}
}
#[Entity]
class OJTICCat extends OJTICPet
{
}
#[Entity]
class OJTICDog extends OJTICPet
{
}
|