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
|
<?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\Entity;
use Doctrine\ORM\Mapping\GeneratedValue;
use Doctrine\ORM\Mapping\Id;
use Doctrine\ORM\Mapping\InverseJoinColumn;
use Doctrine\ORM\Mapping\JoinColumn;
use Doctrine\ORM\Mapping\JoinTable;
use Doctrine\ORM\Mapping\ManyToMany;
use Doctrine\ORM\Mapping\Table;
use Doctrine\Tests\OrmFunctionalTestCase;
use function strtolower;
class DDC698Test extends OrmFunctionalTestCase
{
protected function setUp(): void
{
parent::setUp();
$this->createSchemaForModels(DDC698Role::class, DDC698Privilege::class);
}
public function testTicket(): void
{
$qb = $this->_em->createQueryBuilder();
$qb->select('p', 'r')
->from(__NAMESPACE__ . '\DDC698Privilege', 'p')
->leftJoin('p.roles', 'r');
$sql = $qb->getQuery()->getSQL();
self::assertEquals(
strtolower('SELECT p0_.privilegeID AS privilegeID_0, p0_.name AS name_1, r1_.roleID AS roleID_2, r1_.name AS name_3, r1_.shortName AS shortName_4 FROM Privileges p0_ LEFT JOIN RolePrivileges r2_ ON p0_.privilegeID = r2_.privilegeID LEFT JOIN Roles r1_ ON r1_.roleID = r2_.roleID'),
strtolower($sql),
);
}
}
#[Table(name: 'Roles')]
#[Entity]
class DDC698Role
{
/** @var int */
#[Id]
#[Column(name: 'roleID', type: 'integer')]
#[GeneratedValue(strategy: 'AUTO')]
protected $roleID;
/** @var string */
#[Column(name: 'name', type: 'string', length: 45)]
protected $name;
/** @var string */
#[Column(name: 'shortName', type: 'string', length: 45)]
protected $shortName;
/** @var Collection<int, DDC698Privilege> */
#[JoinTable(name: 'RolePrivileges')]
#[JoinColumn(name: 'roleID', referencedColumnName: 'roleID')]
#[InverseJoinColumn(name: 'privilegeID', referencedColumnName: 'privilegeID')]
#[ManyToMany(targetEntity: 'DDC698Privilege', inversedBy: 'roles')]
protected $privilege;
}
#[Table(name: 'Privileges')]
#[Entity]
class DDC698Privilege
{
/** @var int */
#[Id]
#[Column(name: 'privilegeID', type: 'integer')]
#[GeneratedValue(strategy: 'AUTO')]
protected $privilegeID;
/** @var string */
#[Column(name: 'name', type: 'string', length: 45)]
protected $name;
/** @phpstan-var Collection<int, DDC698Role> */
#[ManyToMany(targetEntity: 'DDC698Role', mappedBy: 'privilege')]
protected $roles;
}
|