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
144
145
146
147
148
149
150
151
152
153
154
155
|
<?php
declare(strict_types=1);
use Doctrine\ORM\Events;
use Doctrine\ORM\Mapping\ClassMetadata;
use Doctrine\Tests\ORM\Tools\Export;
use Doctrine\Tests\ORM\Tools\Export\AddressListener;
use Doctrine\Tests\ORM\Tools\Export\GroupListener;
use Doctrine\Tests\ORM\Tools\Export\UserListener;
$metadata->setInheritanceType(ClassMetadata::INHERITANCE_TYPE_NONE);
$metadata->setPrimaryTable(
[
'name' => 'cms_users',
'options' => ['engine' => 'MyISAM', 'foo' => ['bar' => 'baz']],
]
);
$metadata->setChangeTrackingPolicy(ClassMetadata::CHANGETRACKING_DEFERRED_IMPLICIT);
$metadata->addLifecycleCallback('doStuffOnPrePersist', Events::prePersist);
$metadata->addLifecycleCallback('doOtherStuffOnPrePersistToo', Events::prePersist);
$metadata->addLifecycleCallback('doStuffOnPostPersist', Events::postPersist);
$metadata->mapField(
[
'id' => true,
'fieldName' => 'id',
'type' => 'integer',
'columnName' => 'id',
]
);
$metadata->mapField(
[
'fieldName' => 'name',
'type' => 'string',
'length' => 50,
'unique' => true,
'nullable' => true,
'columnName' => 'name',
]
);
$metadata->mapField(
[
'fieldName' => 'email',
'type' => 'string',
'columnName' => 'user_email',
'columnDefinition' => 'CHAR(32) NOT NULL',
]
);
$metadata->mapField(
[
'fieldName' => 'age',
'type' => 'integer',
'options' => ['unsigned' => true],
]
);
$metadata->setIdGeneratorType(ClassMetadata::GENERATOR_TYPE_AUTO);
$metadata->mapManyToOne(
[
'fieldName' => 'mainGroup',
'targetEntity' => Export\Group::class,
]
);
$metadata->mapOneToOne(
[
'fieldName' => 'address',
'targetEntity' => Export\Address::class,
'inversedBy' => 'user',
'cascade' =>
[0 => 'persist'],
'mappedBy' => null,
'joinColumns' =>
[
0 =>
[
'name' => 'address_id',
'referencedColumnName' => 'id',
'onDelete' => 'CASCADE',
],
],
'orphanRemoval' => true,
'fetch' => ClassMetadata::FETCH_EAGER,
]
);
$metadata->mapOneToOne(
[
'fieldName' => 'cart',
'targetEntity' => Export\Cart::class,
'mappedBy' => 'user',
'cascade' =>
[0 => 'persist'],
'inversedBy' => null,
'orphanRemoval' => false,
'fetch' => ClassMetadata::FETCH_EAGER,
]
);
$metadata->mapOneToMany(
[
'fieldName' => 'phonenumbers',
'targetEntity' => Export\Phonenumber::class,
'cascade' =>
[
1 => 'persist',
2 => 'merge',
],
'mappedBy' => 'user',
'orphanRemoval' => true,
'fetch' => ClassMetadata::FETCH_LAZY,
'orderBy' =>
['number' => 'ASC'],
]
);
$metadata->mapManyToMany(
[
'fieldName' => 'groups',
'targetEntity' => Export\Group::class,
'fetch' => ClassMetadata::FETCH_EXTRA_LAZY,
'cascade' =>
[
0 => 'remove',
1 => 'persist',
2 => 'refresh',
3 => 'merge',
4 => 'detach',
],
'mappedBy' => null,
'joinTable' =>
[
'name' => 'cms_users_groups',
'joinColumns' =>
[
0 =>
[
'name' => 'user_id',
'referencedColumnName' => 'id',
'unique' => false,
'nullable' => false,
],
],
'inverseJoinColumns' =>
[
0 =>
[
'name' => 'group_id',
'referencedColumnName' => 'id',
'columnDefinition' => 'INT NULL',
],
],
],
'orderBy' => null,
]
);
$metadata->addEntityListener(Events::prePersist, UserListener::class, 'customPrePersist');
$metadata->addEntityListener(Events::postPersist, UserListener::class, 'customPostPersist');
$metadata->addEntityListener(Events::prePersist, GroupListener::class, 'prePersist');
$metadata->addEntityListener(Events::postPersist, AddressListener::class, 'customPostPersist');
|
