1
|
|
|
<?php |
2
|
|
|
|
3
|
|
|
namespace Doctrine\Tests\Models\CMSCustomId; |
4
|
|
|
|
5
|
|
|
/** |
6
|
|
|
* CmsAddress |
7
|
|
|
* |
8
|
|
|
* @author Roman S. Borschel |
9
|
|
|
* @Entity |
10
|
|
|
* @Table(name="cms_addresses_customid") |
11
|
|
|
* |
12
|
|
|
* @NamedNativeQueries({ |
13
|
|
|
* @NamedNativeQuery( |
14
|
|
|
* name = "find-all", |
15
|
|
|
* resultSetMapping = "mapping-find-all", |
16
|
|
|
* query = "SELECT id, country, city FROM cms_addresses" |
17
|
|
|
* ), |
18
|
|
|
* @NamedNativeQuery( |
19
|
|
|
* name = "find-by-id", |
20
|
|
|
* resultClass = "CmsAddress", |
21
|
|
|
* query = "SELECT * FROM cms_addresses WHERE id = ?" |
22
|
|
|
* ), |
23
|
|
|
* @NamedNativeQuery( |
24
|
|
|
* name = "count", |
25
|
|
|
* resultSetMapping= "mapping-count", |
26
|
|
|
* query = "SELECT COUNT(*) AS count FROM cms_addresses" |
27
|
|
|
* ) |
28
|
|
|
* }) |
29
|
|
|
* |
30
|
|
|
* @SqlResultSetMappings({ |
31
|
|
|
* @SqlResultSetMapping( |
32
|
|
|
* name = "mapping-find-all", |
33
|
|
|
* entities= { |
34
|
|
|
* @EntityResult( |
35
|
|
|
* entityClass = "CmsAddress", |
36
|
|
|
* fields = { |
37
|
|
|
* @FieldResult(name = "id", column="id"), |
38
|
|
|
* @FieldResult(name = "city", column="city"), |
39
|
|
|
* @FieldResult(name = "country", column="country") |
40
|
|
|
* } |
41
|
|
|
* ) |
42
|
|
|
* } |
43
|
|
|
* ), |
44
|
|
|
* @SqlResultSetMapping( |
45
|
|
|
* name = "mapping-without-fields", |
46
|
|
|
* entities= { |
47
|
|
|
* @EntityResult( |
48
|
|
|
* entityClass = "__CLASS__" |
49
|
|
|
* ) |
50
|
|
|
* } |
51
|
|
|
* ), |
52
|
|
|
* @SqlResultSetMapping( |
53
|
|
|
* name = "mapping-count", |
54
|
|
|
* columns = { |
55
|
|
|
* @ColumnResult( |
56
|
|
|
* name = "count" |
57
|
|
|
* ) |
58
|
|
|
* } |
59
|
|
|
* ) |
60
|
|
|
* }) |
61
|
|
|
* |
62
|
|
|
* @EntityListeners({"CmsAddressListener"}) |
63
|
|
|
*/ |
64
|
|
|
class CmsAddress |
65
|
|
|
{ |
66
|
|
|
/** |
67
|
|
|
* @Id |
68
|
|
|
* @Column(type="CustomIdObject") |
69
|
|
|
* @GeneratedValue(strategy="NONE") |
70
|
|
|
*/ |
71
|
|
|
public $id; |
72
|
|
|
|
73
|
|
|
/** |
74
|
|
|
* @Column(length=50) |
75
|
|
|
*/ |
76
|
|
|
public $country; |
77
|
|
|
|
78
|
|
|
/** |
79
|
|
|
* @Column(length=50) |
80
|
|
|
*/ |
81
|
|
|
public $zip; |
82
|
|
|
|
83
|
|
|
/** |
84
|
|
|
* @Column(length=50) |
85
|
|
|
*/ |
86
|
|
|
public $city; |
87
|
|
|
|
88
|
|
|
/** |
89
|
|
|
* Testfield for Schema Updating Tests. |
90
|
|
|
*/ |
91
|
|
|
public $street; |
92
|
|
|
|
93
|
|
|
/** |
94
|
|
|
* @OneToOne(targetEntity="CmsUser", inversedBy="address") |
95
|
|
|
* @JoinColumn(referencedColumnName="id") |
96
|
|
|
*/ |
97
|
|
|
public $user; |
98
|
|
|
|
99
|
|
|
public function getId() { |
100
|
|
|
return $this->id; |
101
|
|
|
} |
102
|
|
|
|
103
|
|
|
public function getUser() { |
104
|
|
|
return $this->user; |
105
|
|
|
} |
106
|
|
|
|
107
|
|
|
public function getCountry() { |
108
|
|
|
return $this->country; |
109
|
|
|
} |
110
|
|
|
|
111
|
|
|
public function getZipCode() { |
112
|
|
|
return $this->zip; |
113
|
|
|
} |
114
|
|
|
|
115
|
|
|
public function getCity() { |
116
|
|
|
return $this->city; |
117
|
|
|
} |
118
|
|
|
|
119
|
|
|
public function setUser(CmsUser $user) { |
120
|
|
|
if ($this->user !== $user) { |
121
|
|
|
$this->user = $user; |
122
|
|
|
$user->setAddress($this); |
123
|
|
|
} |
124
|
|
|
} |
125
|
|
|
|
126
|
|
|
public static function loadMetadata(\Doctrine\ORM\Mapping\ClassMetadataInfo $metadata) |
127
|
|
|
{ |
128
|
|
|
$metadata->setPrimaryTable( |
129
|
|
|
[ |
130
|
|
|
'name' => 'company_person', |
131
|
|
|
] |
132
|
|
|
); |
133
|
|
|
|
134
|
|
|
$metadata->mapField( |
135
|
|
|
[ |
136
|
|
|
'id' => true, |
137
|
|
|
'fieldName' => 'id', |
138
|
|
|
'type' => 'integer', |
139
|
|
|
] |
140
|
|
|
); |
141
|
|
|
|
142
|
|
|
$metadata->mapField( |
143
|
|
|
[ |
144
|
|
|
'fieldName' => 'zip', |
145
|
|
|
'length' => 50, |
146
|
|
|
] |
147
|
|
|
); |
148
|
|
|
|
149
|
|
|
$metadata->mapField( |
150
|
|
|
[ |
151
|
|
|
'fieldName' => 'city', |
152
|
|
|
'length' => 50, |
153
|
|
|
] |
154
|
|
|
); |
155
|
|
|
|
156
|
|
|
$metadata->mapOneToOne( |
157
|
|
|
[ |
158
|
|
|
'fieldName' => 'user', |
159
|
|
|
'targetEntity' => 'CmsUser', |
160
|
|
|
'joinColumns' => [['referencedColumnName' => 'id']] |
161
|
|
|
] |
162
|
|
|
); |
163
|
|
|
|
164
|
|
|
$metadata->addNamedNativeQuery( |
165
|
|
|
[ |
166
|
|
|
'name' => 'find-all', |
167
|
|
|
'query' => 'SELECT id, country, city FROM cms_addresses_customid', |
168
|
|
|
'resultSetMapping' => 'mapping-find-all', |
169
|
|
|
] |
170
|
|
|
); |
171
|
|
|
|
172
|
|
|
$metadata->addNamedNativeQuery( |
173
|
|
|
[ |
174
|
|
|
'name' => 'find-by-id', |
175
|
|
|
'query' => 'SELECT * FROM cms_addresses_customid WHERE id = ?', |
176
|
|
|
'resultClass' => CmsAddress::class, |
177
|
|
|
] |
178
|
|
|
); |
179
|
|
|
|
180
|
|
|
$metadata->addNamedNativeQuery( |
181
|
|
|
[ |
182
|
|
|
'name' => 'count', |
183
|
|
|
'query' => 'SELECT COUNT(*) AS count FROM cms_addresses_customid', |
184
|
|
|
'resultSetMapping' => 'mapping-count', |
185
|
|
|
] |
186
|
|
|
); |
187
|
|
|
|
188
|
|
|
$metadata->addSqlResultSetMapping( |
189
|
|
|
[ |
190
|
|
|
'name' => 'mapping-find-all', |
191
|
|
|
'columns' => [], |
192
|
|
|
'entities' => [ |
193
|
|
|
[ |
194
|
|
|
'fields' => [ |
195
|
|
|
[ |
196
|
|
|
'name' => 'id', |
197
|
|
|
'column' => 'id', |
198
|
|
|
], |
199
|
|
|
[ |
200
|
|
|
'name' => 'city', |
201
|
|
|
'column' => 'city', |
202
|
|
|
], |
203
|
|
|
[ |
204
|
|
|
'name' => 'country', |
205
|
|
|
'column' => 'country', |
206
|
|
|
], |
207
|
|
|
], |
208
|
|
|
'entityClass' => CmsAddress::class, |
209
|
|
|
], |
210
|
|
|
], |
211
|
|
|
] |
212
|
|
|
); |
213
|
|
|
|
214
|
|
|
$metadata->addSqlResultSetMapping( |
215
|
|
|
[ |
216
|
|
|
'name' => 'mapping-without-fields', |
217
|
|
|
'columns' => [], |
218
|
|
|
'entities' => [ |
219
|
|
|
[ |
220
|
|
|
'entityClass' => CmsAddress::class, |
221
|
|
|
'fields' => [] |
222
|
|
|
] |
223
|
|
|
] |
224
|
|
|
] |
225
|
|
|
); |
226
|
|
|
|
227
|
|
|
$metadata->addSqlResultSetMapping( |
228
|
|
|
[ |
229
|
|
|
'name' => 'mapping-count', |
230
|
|
|
'columns' => [ |
231
|
|
|
[ |
232
|
|
|
'name' => 'count', |
233
|
|
|
], |
234
|
|
|
] |
235
|
|
|
] |
236
|
|
|
); |
237
|
|
|
|
238
|
|
|
$metadata->addEntityListener(\Doctrine\ORM\Events::postPersist, 'CmsAddressListener', 'postPersist'); |
239
|
|
|
$metadata->addEntityListener(\Doctrine\ORM\Events::prePersist, 'CmsAddressListener', 'prePersist'); |
240
|
|
|
|
241
|
|
|
$metadata->addEntityListener(\Doctrine\ORM\Events::postUpdate, 'CmsAddressListener', 'postUpdate'); |
242
|
|
|
$metadata->addEntityListener(\Doctrine\ORM\Events::preUpdate, 'CmsAddressListener', 'preUpdate'); |
243
|
|
|
|
244
|
|
|
$metadata->addEntityListener(\Doctrine\ORM\Events::postRemove, 'CmsAddressListener', 'postRemove'); |
245
|
|
|
$metadata->addEntityListener(\Doctrine\ORM\Events::preRemove, 'CmsAddressListener', 'preRemove'); |
246
|
|
|
|
247
|
|
|
$metadata->addEntityListener(\Doctrine\ORM\Events::preFlush, 'CmsAddressListener', 'preFlush'); |
248
|
|
|
$metadata->addEntityListener(\Doctrine\ORM\Events::postLoad, 'CmsAddressListener', 'postLoad'); |
249
|
|
|
} |
250
|
|
|
} |
251
|
|
|
|