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
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
|
<?php
declare(strict_types=1);
namespace Doctrine\Tests\ORM\Functional\Ticket;
use Doctrine\Common\Collections\ArrayCollection;
use Doctrine\Common\Collections\Collection;
use Doctrine\Common\Persistence\PersistentObject;
use Doctrine\Deprecations\PHPUnit\VerifyDeprecations;
use Doctrine\ORM\Mapping\Column;
use Doctrine\ORM\Mapping\Entity;
use Doctrine\ORM\Mapping\GeneratedValue;
use Doctrine\ORM\Mapping\Id;
use Doctrine\ORM\Mapping\JoinColumn;
use Doctrine\ORM\Mapping\ManyToOne;
use Doctrine\ORM\Mapping\OneToMany;
use Doctrine\ORM\Mapping\Table;
use Doctrine\ORM\Query\ResultSetMapping;
use Doctrine\ORM\Query\ResultSetMappingBuilder;
use Doctrine\Tests\OrmFunctionalTestCase;
use function class_exists;
/** @group DDC-2256 */
class DDC2256Test extends OrmFunctionalTestCase
{
use VerifyDeprecations;
protected function setUp(): void
{
parent::setUp();
$this->createSchemaForModels(
DDC2256User::class,
DDC2256Group::class
);
}
public function testIssue(): void
{
if (! class_exists(PersistentObject::class)) {
$this->markTestSkipped('This test requires doctrine/persistence 2');
}
$this->expectDeprecationWithIdentifier('https://github.com/doctrine/orm/issues/8818');
$config = $this->_em->getConfiguration();
$config->addEntityNamespace('MyNamespace', __NAMESPACE__);
$user = new DDC2256User();
$user->name = 'user';
$group = new DDC2256Group();
$group->name = 'group';
$user->group = $group;
$this->_em->persist($user);
$this->_em->persist($group);
$this->_em->flush();
$this->_em->clear();
$sql = 'SELECT u.id, u.name, g.id as group_id, g.name as group_name FROM ddc2256_users u LEFT JOIN ddc2256_groups g ON u.group_id = g.id';
// Test ResultSetMapping.
$rsm = new ResultSetMapping();
$rsm->addEntityResult('MyNamespace:DDC2256User', 'u');
$rsm->addFieldResult('u', 'id', 'id');
$rsm->addFieldResult('u', 'name', 'name');
$rsm->addJoinedEntityResult('MyNamespace:DDC2256Group', 'g', 'u', 'group');
$rsm->addFieldResult('g', 'group_id', 'id');
$rsm->addFieldResult('g', 'group_name', 'name');
self::assertCount(1, $this->_em->createNativeQuery($sql, $rsm)->getResult());
// Test ResultSetMappingBuilder.
$rsm = new ResultSetMappingBuilder($this->_em);
$rsm->addRootEntityFromClassMetadata('MyNamespace:DDC2256User', 'u');
$rsm->addJoinedEntityFromClassMetadata('MyNamespace:DDC2256Group', 'g', 'u', 'group', ['id' => 'group_id', 'name' => 'group_name']);
self::assertCount(1, $this->_em->createNativeQuery($sql, $rsm)->getResult());
}
}
/**
* @Entity
* @Table(name="ddc2256_users")
*/
class DDC2256User
{
/**
* @var int
* @Id
* @Column(type="integer")
* @GeneratedValue(strategy="AUTO")
*/
public $id;
/**
* @var string
* @Column(type="string")
*/
public $name;
/**
* @var DDC2256Group
* @ManyToOne(targetEntity="DDC2256Group", inversedBy="users")A
* @JoinColumn(name="group_id")
*/
public $group;
}
/**
* @Entity
* @Table(name="ddc2256_groups")
*/
class DDC2256Group
{
/**
* @var int
* @Id
* @Column(type="integer")
* @GeneratedValue(strategy="AUTO")
*/
public $id;
/**
* @var string
* @Column(type="string")
*/
public $name;
/**
* @psalm-var Collection<int, DDC2256User>
* @OneToMany(targetEntity="DDC2256User", mappedBy="group")
*/
public $users;
public function __construct()
{
$this->users = new ArrayCollection();
}
}
|
