File: DDC698Test.php

package info (click to toggle)
doctrine 3.5.2%2Bdfsg-1
  • links: PTS, VCS
  • area: main
  • in suites: forky
  • size: 11,556 kB
  • sloc: php: 108,620; xml: 1,340; makefile: 35; sh: 14
file content (90 lines) | stat: -rw-r--r-- 2,567 bytes parent folder | download | duplicates (2)
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;
}