|
1
|
|
|
<?php |
|
2
|
|
|
|
|
3
|
|
|
declare(strict_types=1); |
|
4
|
|
|
|
|
5
|
|
|
namespace Cycle\Schema\Relation\Traits; |
|
6
|
|
|
|
|
7
|
|
|
use Cycle\ORM\Relation; |
|
8
|
|
|
use Cycle\Schema\Definition\Entity; |
|
9
|
|
|
use Cycle\Schema\Definition\Field; |
|
10
|
|
|
use Cycle\Schema\Definition\Map\FieldMap; |
|
11
|
|
|
use Cycle\Schema\Exception\FieldException; |
|
12
|
|
|
use Cycle\Schema\Exception\RegistryException; |
|
13
|
|
|
use Cycle\Schema\Exception\RelationException; |
|
14
|
|
|
use Cycle\Schema\Relation\OptionSchema; |
|
15
|
|
|
use Cycle\Schema\Table\Column; |
|
16
|
|
|
|
|
17
|
|
|
trait FieldTrait |
|
18
|
|
|
{ |
|
19
|
4 |
|
protected function getField(Entity $entity, int $field): Field |
|
20
|
|
|
{ |
|
21
|
|
|
try { |
|
22
|
4 |
|
return $entity->getFields()->get($this->getOptions()->get($field)); |
|
23
|
2 |
|
} catch (FieldException $e) { |
|
24
|
2 |
|
throw new RelationException( |
|
25
|
2 |
|
sprintf( |
|
26
|
2 |
|
'Field `%s`.`%s` does not exists, referenced by `%s`', |
|
27
|
2 |
|
$entity->getRole() ?? 'unknown', |
|
28
|
2 |
|
$this->getOptions()->get($field), |
|
29
|
2 |
|
$this->source, |
|
30
|
|
|
), |
|
31
|
2 |
|
$e->getCode(), |
|
32
|
|
|
$e, |
|
33
|
|
|
); |
|
34
|
|
|
} |
|
35
|
|
|
} |
|
36
|
|
|
|
|
37
|
902 |
|
protected function getFields(Entity $entity, int $option): FieldMap |
|
38
|
|
|
{ |
|
39
|
902 |
|
$fields = new FieldMap(); |
|
40
|
902 |
|
$keys = (array) $this->getOptions()->get($option); |
|
41
|
|
|
|
|
42
|
902 |
|
foreach ($keys as $key) { |
|
43
|
|
|
try { |
|
44
|
902 |
|
$fields->set($key, $entity->getFields()->get($key)); |
|
45
|
2 |
|
} catch (FieldException $e) { |
|
46
|
2 |
|
throw new RelationException( |
|
47
|
2 |
|
sprintf( |
|
48
|
2 |
|
'Field `%s`.`%s` does not exists, referenced by `%s`.', |
|
49
|
2 |
|
$entity->getRole() ?? 'unknown', |
|
50
|
|
|
$key, |
|
51
|
2 |
|
$this->source, |
|
52
|
|
|
), |
|
53
|
2 |
|
$e->getCode(), |
|
54
|
|
|
$e, |
|
55
|
|
|
); |
|
56
|
|
|
} |
|
57
|
|
|
} |
|
58
|
|
|
|
|
59
|
900 |
|
return $fields; |
|
60
|
|
|
} |
|
61
|
|
|
|
|
62
|
880 |
|
protected function createRelatedFields( |
|
63
|
|
|
Entity $source, |
|
64
|
|
|
int $sourceKey, |
|
65
|
|
|
Entity $target, |
|
66
|
|
|
int $targetKey, |
|
67
|
|
|
): void { |
|
68
|
880 |
|
$sourceFields = $this->getFields($source, $sourceKey); |
|
69
|
880 |
|
$targetColumns = (array) $this->options->get($targetKey); |
|
70
|
|
|
|
|
71
|
880 |
|
$sourceFieldNames = $sourceFields->getNames(); |
|
72
|
|
|
|
|
73
|
880 |
|
if (count($targetColumns) !== count($sourceFieldNames)) { |
|
74
|
32 |
|
throw new RegistryException( |
|
75
|
32 |
|
sprintf( |
|
76
|
|
|
'Inconsistent amount of related fields. ' |
|
77
|
32 |
|
. 'Source entity: `%s`; keys: `%s`. Target entity: `%s`; keys: `%s`.', |
|
78
|
32 |
|
$source->getRole() ?? 'unknown', |
|
79
|
32 |
|
implode('`, `', $this->getFields($source, $sourceKey)->getColumnNames()), |
|
80
|
32 |
|
$target->getRole() ?? 'unknown', |
|
81
|
32 |
|
implode('`, `', $targetColumns), |
|
82
|
|
|
), |
|
83
|
|
|
); |
|
84
|
|
|
} |
|
85
|
|
|
|
|
86
|
848 |
|
$fields = array_combine($targetColumns, $sourceFieldNames); |
|
87
|
|
|
|
|
88
|
848 |
|
foreach ($fields as $targetColumn => $sourceFieldName) { |
|
89
|
848 |
|
$sourceField = $sourceFields->get($sourceFieldName); |
|
90
|
848 |
|
$this->ensureField( |
|
91
|
|
|
$target, |
|
92
|
|
|
$targetColumn, |
|
93
|
|
|
$sourceField, |
|
94
|
848 |
|
$this->options->get(Relation::NULLABLE), |
|
95
|
|
|
); |
|
96
|
|
|
} |
|
97
|
848 |
|
} |
|
98
|
|
|
|
|
99
|
|
|
/** |
|
100
|
|
|
* This method tries to replace column names with property names in relations |
|
101
|
|
|
*/ |
|
102
|
784 |
|
protected function normalizeContextFields( |
|
103
|
|
|
Entity $source, |
|
104
|
|
|
Entity $target, |
|
105
|
|
|
array $keys = ['innerKey', 'outerKey'], |
|
106
|
|
|
): void { |
|
107
|
784 |
|
foreach ($keys as $key) { |
|
108
|
784 |
|
$options = $this->options->getOptions(); |
|
109
|
|
|
|
|
110
|
784 |
|
if (!isset($options[$key])) { |
|
111
|
784 |
|
continue; |
|
112
|
|
|
} |
|
113
|
|
|
|
|
114
|
160 |
|
$columns = (array) $options[$key]; |
|
115
|
|
|
|
|
116
|
160 |
|
foreach ($columns as $i => $column) { |
|
117
|
160 |
|
$entity = $key === 'innerKey' ? $source : $target; |
|
118
|
|
|
|
|
119
|
160 |
|
if ($entity->getFields()->hasColumn($column)) { |
|
120
|
|
|
$columns[$i] = $entity->getFields()->getKeyByColumnName($column); |
|
121
|
|
|
} |
|
122
|
|
|
} |
|
123
|
|
|
|
|
124
|
160 |
|
$this->options = $this->options->withOptions([ |
|
|
|
|
|
|
125
|
160 |
|
$key => $columns, |
|
126
|
|
|
]); |
|
127
|
|
|
} |
|
128
|
784 |
|
} |
|
129
|
|
|
|
|
130
|
952 |
|
/** |
|
131
|
|
|
* @param non-empty-string $fieldName |
|
|
|
|
|
|
132
|
|
|
*/ |
|
133
|
952 |
|
protected function ensureField(Entity $target, string $fieldName, Field $outerField, bool $nullable = false): void |
|
134
|
|
|
{ |
|
135
|
952 |
|
// ensure that field will be indexed in memory for fast references |
|
136
|
|
|
$outerField->setReferenced(true); |
|
137
|
58 |
|
|
|
138
|
|
|
if ($target->getFields()->has($fieldName)) { |
|
139
|
|
|
// field already exists and defined by the user |
|
140
|
950 |
|
return; |
|
141
|
950 |
|
} |
|
142
|
950 |
|
|
|
143
|
950 |
|
$field = new Field(); |
|
144
|
|
|
$field->setEntityClass($target->getClass()); |
|
145
|
950 |
|
$field->setColumn($fieldName); |
|
146
|
950 |
|
$field->setTypecast($outerField->getTypecast()); |
|
147
|
946 |
|
// Copy attributes from outer to target |
|
148
|
946 |
|
foreach ($outerField->getAttributes() as $k => $v) { |
|
149
|
452 |
|
$field->getAttributes()->set($k, $v); |
|
150
|
130 |
|
} |
|
151
|
130 |
|
|
|
152
|
|
|
switch ($outerField->getType()) { |
|
153
|
362 |
|
case 'primary': |
|
154
|
|
|
$field->setType('int'); |
|
155
|
|
|
break; |
|
156
|
950 |
|
case 'bigPrimary': |
|
157
|
260 |
|
$field->setType('bigint'); |
|
158
|
|
|
break; |
|
159
|
|
|
case 'smallPrimary': |
|
160
|
950 |
|
$field->setType('smallint'); |
|
161
|
950 |
|
break; |
|
162
|
|
|
default: |
|
163
|
|
|
$field->setType($outerField->getType()); |
|
164
|
|
|
} |
|
165
|
|
|
|
|
166
|
|
|
if ($nullable) { |
|
167
|
|
|
$field->getOptions()->set(Column::OPT_NULLABLE, true); |
|
168
|
|
|
} |
|
169
|
|
|
|
|
170
|
|
|
$target->getFields()->set($fieldName, $field); |
|
171
|
|
|
} |
|
172
|
|
|
|
|
173
|
|
|
abstract protected function getOptions(): OptionSchema; |
|
174
|
|
|
} |
|
175
|
|
|
|