Code Coverage
 
Lines
Functions and Methods
Classes and Traits
Total
0.00%
0 / 160
0.00%
0 / 5
 CRAP
0.00%
0 / 1
Topic
0.00%
0 / 160
0.00%
0 / 5
 156
0.00%
0 / 1
 setupMapping
0.00%
0 / 131
0.00%
0 / 1
 2
 deleteReferencesFn
0.00%
0 / 9
0.00%
0 / 1
 20
 preSetup
0.00%
0 / 10
0.00%
0 / 1
 12
 deleteEntity
0.00%
0 / 5
0.00%
0 / 1
 6
 clearEntity
0.00%
0 / 5
0.00%
0 / 1
 6
1<?php
2
3namespace BO\Zmsdldb\Importer\MySQL\Entity;
4
5class Topic extends Base
6{
7    protected $fieldMapping = [
8        'id' => 'id',
9        'name' => 'name',
10        'meta.locale' => 'locale',
11        'path' => 'path',
12        'relation.navi' => 'navi',
13        'relation.root' => 'root',
14        'relation.rank' => 'rank',
15        '__RAW__' => 'data_json'
16    ];
17
18    /**
19     * @SuppressWarnings(PHPMD.ExcessiveMethodLength)
20     */
21    #[\Override]
22    protected function setupMapping()
23    {
24        $this->referanceMapping = [
25            'meta' => [
26                'class' => 'BO\\Zmsdldb\\Importer\\MySQL\\Entity\\Meta',
27                'neededFields' => [
28                    'id' => 'object_id',
29                    'meta.locale' => 'locale'
30                ],
31                'addFields' => [
32                    'type' => static::getTableName()
33                ],
34                'deleteFields' => [
35                    'object_id' => $this->get('id'),
36                    'locale' => $this->get('meta.locale'),
37                    'type' => static::getTableName()
38                ],
39                'multiple' => false,
40                'clearFields' => [
41                    'type' => static::getTableName(),
42                    'locale' => $this->get('meta.locale')
43                ],
44            ],
45            'name' => [
46                'class' => 'BO\\Zmsdldb\\Importer\\MySQL\\Entity\\Search',
47                'neededFields' => [
48                    'id' => 'object_id',
49                    'meta.locale' => 'locale',
50                    'name' => 'search_value'
51                ],
52                'addFields' => [
53                    'entity_type' => static::getTableName(),
54                    'search_type' => 'name'
55                ],
56                'multiple' => false,
57                'clearFields' => [
58                    'entity_type' => static::getTableName(),
59                    'locale' => $this->get('meta.locale')
60                ],
61                'deleteFields' => [
62                    'object_id' => $this->get('id'),
63                    'locale' => $this->get('meta.locale'),
64                    'entity_type' => static::getTableName()
65                ],
66                'selfAsArray' => true
67            ],
68            'meta.keywords' => [
69                'class' => 'BO\\Zmsdldb\\Importer\\MySQL\\Entity\\Search',
70                'neededFields' => [
71                    'id' => 'object_id',
72                    'meta.locale' => 'locale',
73                    'meta.keywords' => 'search_value',
74                ],
75                'addFields' => [
76                    'entity_type' => static::getTableName(),
77                    'search_type' => 'keywords'
78                ],
79                'deleteFields' => [
80                    'object_id' => $this->get('id'),
81                    'locale' => $this->get('meta.locale'),
82                    'entity_type' => static::getTableName()
83                ],
84                'multiple' => false,
85                'clearFields' => [
86                    'entity_type' => static::getTableName(),
87                    'locale' => $this->get('meta.locale')
88                ],
89                'selfAsArray' => true
90            ],
91            'meta.titles' => [
92                'class' => 'BO\\Zmsdldb\\Importer\\MySQL\\Entity\\Search',
93                'neededFields' => [
94                    'id' => 'object_id',
95                    'meta.locale' => 'locale',
96                    'meta.titles' => 'search_value'
97                ],
98                'addFields' => [
99                    'entity_type' => static::getTableName(),
100                    'search_type' => 'titles'
101                ],
102                'deleteFields' => [
103                    'object_id' => $this->get('id'),
104                    'locale' => $this->get('locale'),
105                    'entity_type' => static::getTableName()
106                ],
107                'multiple' => false,
108                'clearFields' => [
109                    'entity_type' => static::getTableName(),
110                    'locale' => $this->get('locale')
111                ],
112                'selfAsArray' => true
113            ],
114            'links' => [
115                'class' => 'BO\\Zmsdldb\\Importer\\MySQL\\Entity\\TopicLinks',
116                'neededFields' => ['id' => 'topic_id', 'meta.locale' => 'locale'],
117                'addFields' => ['locale' => $this->get('meta.locale')],
118                'delete' => false,
119                'deleteFunction' => function (\BO\Zmsdldb\Importer\MySQL\Entity\Topic $topic) {
120                    return static::deleteReferencesFn(
121                        $topic,
122                        \BO\Zmsdldb\Importer\MySQL\Entity\TopicLinks::getTableName(),
123                        'topic_id'
124                    );
125                },
126                'clearFields' => [
127                    'locale' => $this->get('meta.locale')
128                ]
129            ],
130            'relation.services' => [
131                'class' => 'BO\\Zmsdldb\\Importer\\MySQL\\Entity\\TopicService',
132                'neededFields' => ['id' => 'topic_id'],
133                'addFields' => [],
134                'deleteFunction' => function (\BO\Zmsdldb\Importer\MySQL\Entity\Topic $topic) {
135                    return static::deleteReferencesFn(
136                        $topic,
137                        \BO\Zmsdldb\Importer\MySQL\Entity\TopicService::getTableName(),
138                        'topic_id'
139                    );
140                }
141            ],
142            'relation.childs' => [
143                'class' => 'BO\\Zmsdldb\\Importer\\MySQL\\Entity\\TopicCluster',
144                'neededFields' => ['id' => 'parent_id'],
145                'addFields' => [],
146                'deleteFunction' => function (\BO\Zmsdldb\Importer\MySQL\Entity\Topic $topic) {
147                    return static::deleteReferencesFn(
148                        $topic,
149                        \BO\Zmsdldb\Importer\MySQL\Entity\TopicCluster::getTableName(),
150                        'parent_id'
151                    );
152                }
153            ]
154        ];
155    }
156
157    protected static function deleteReferencesFn(
158        \BO\Zmsdldb\Importer\MySQL\Entity\Topic $topic,
159        string $tableName,
160        string $whereField
161    ) {
162        $topicId = $topic->get('id');
163        try {
164            $sql = "DELETE FROM " . $tableName . " WHERE " . $whereField . " = ?";
165            $stm = $topic->getPDOAccess()->prepare($sql);
166
167            $stm->execute([$topicId]);
168            if ($stm && 0 < $stm->rowCount()) {
169                return true;
170            }
171            return false;
172        } catch (\Exception $e) {
173            throw $e;
174        }
175    }
176
177    #[\Override]
178    public function preSetup()
179    {
180        try {
181            $fields = $this->get(['id', 'meta.locale', 'meta.hash']);
182            $fields[] = static::getTableName();
183            $this->setStatus(static::STATUS_OLD);
184            if ($this->itemNeedsUpdate(...array_values($fields))) {
185                $this->setStatus(static::STATUS_NEW);
186                $this->setupFields();
187                $this->deleteEntity();
188                $this->deleteReferences();
189            }
190        } catch (\Exception $e) {
191            throw $e;
192        }
193    }
194
195    #[\Override]
196    public function deleteEntity(): bool
197    {
198        try {
199            return $this->deleteWith(
200                array_combine(['id', 'locale'], array_values($this->get(['id', 'meta.locale'])))
201            );
202        } catch (\Exception $e) {
203            throw $e;
204        }
205    }
206
207    #[\Override]
208    public function clearEntity(array $addWhere = []): bool
209    {
210        try {
211            return $this->deleteWith(
212                ['locale' => $this->get('meta.locale')]
213            );
214        } catch (\Exception $e) {
215            throw $e;
216        }
217    }
218}