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
|
<?php
declare(strict_types=1);
use Doctrine\ORM\Mapping\ClassMetadata;
use Doctrine\Tests\ORM\Mapping\Address;
use Doctrine\Tests\ORM\Mapping\Group;
use Doctrine\Tests\ORM\Mapping\Phonenumber;
$metadata->setInheritanceType(ClassMetadata::INHERITANCE_TYPE_NONE);
$metadata->setPrimaryTable(
['name' => 'cms_users']
);
$metadata->setChangeTrackingPolicy(ClassMetadata::CHANGETRACKING_DEFERRED_IMPLICIT);
$metadata->addLifecycleCallback('doStuffOnPrePersist', 'prePersist');
$metadata->addLifecycleCallback('doOtherStuffOnPrePersistToo', 'prePersist');
$metadata->addLifecycleCallback('doStuffOnPostPersist', 'postPersist');
$metadata->addNamedQuery(
[
'name' => 'all',
'query' => 'SELECT u FROM __CLASS__ u',
]
);
$metadata->mapField(
[
'id' => true,
'fieldName' => 'id',
'type' => 'integer',
'columnName' => 'id',
'options' => ['foo' => 'bar', 'unsigned' => false],
]
);
$metadata->mapField(
[
'fieldName' => 'name',
'type' => 'string',
'length' => 50,
'unique' => true,
'nullable' => true,
'columnName' => 'name',
'options' => ['foo' => 'bar', 'baz' => ['key' => 'val'], 'fixed' => false],
]
);
$metadata->mapField(
[
'fieldName' => 'email',
'type' => 'string',
'columnName' => 'user_email',
'columnDefinition' => 'CHAR(32) NOT NULL',
]
);
$mapping = ['fieldName' => 'version', 'type' => 'integer'];
$metadata->setVersionMapping($mapping);
$metadata->mapField($mapping);
$metadata->setIdGeneratorType(ClassMetadata::GENERATOR_TYPE_AUTO);
$metadata->mapOneToOne(
[
'fieldName' => 'address',
'targetEntity' => Address::class,
'cascade' =>
[0 => 'remove'],
'mappedBy' => null,
'inversedBy' => 'user',
'joinColumns' =>
[
0 =>
[
'name' => 'address_id',
'referencedColumnName' => 'id',
'onDelete' => 'CASCADE',
],
],
'orphanRemoval' => false,
]
);
$metadata->mapOneToMany(
[
'fieldName' => 'phonenumbers',
'targetEntity' => Phonenumber::class,
'cascade' =>
[1 => 'persist'],
'mappedBy' => 'user',
'orphanRemoval' => true,
'orderBy' =>
['number' => 'ASC'],
]
);
$metadata->mapManyToMany(
[
'fieldName' => 'groups',
'targetEntity' => Group::class,
'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->table['options'] = [
'foo' => 'bar',
'baz' => ['key' => 'val'],
];
$metadata->table['uniqueConstraints'] = [
'search_idx' => ['columns' => ['name', 'user_email'], 'options' => ['where' => 'name IS NOT NULL']],
'phone_idx' => ['fields' => ['name', 'phone']],
];
$metadata->table['indexes'] = [
'name_idx' => ['columns' => ['name']],
0 => ['columns' => ['user_email']],
'fields' => ['fields' => ['name', 'email']],
];
$metadata->setSequenceGeneratorDefinition(
[
'sequenceName' => 'tablename_seq',
'allocationSize' => 100,
'initialValue' => 1,
]
);
|
