Code Coverage for /Users/gregor/PhpstormProjects/siesta/src/Siesta/Migration/IndexListMigrator.php

	Code Coverage
	Classes and Traits			Functions and Methods				Lines
Total	0.00% covered (danger)	0.00%	0 / 1	91.67% covered (success)	91.67%	11 / 12	CRAP	97.01% covered (success)	97.01%	65 / 67
IndexListMigrator	0.00% covered (danger)	0.00%	0 / 1	91.67% covered (success)	91.67%	11 / 12	31	97.01% covered (success)	97.01%	65 / 67
__construct				100.00% covered (success)	100.00%	1 / 1	1	100.00% covered (success)	100.00%	6 / 6
createAlterStatementList				100.00% covered (success)	100.00%	1 / 1	5	100.00% covered (success)	100.00%	11 / 11
createAlterStatement				100.00% covered (success)	100.00%	1 / 1	3	100.00% covered (success)	100.00%	8 / 8
compareIndex				0.00% covered (danger)	0.00%	0 / 1	5.07	85.71% covered (success)	85.71%	12 / 14
needsRecreationOfIndex				100.00% covered (success)	100.00%	1 / 1	6	100.00% covered (success)	100.00%	9 / 9
getIndexPartByColumnName				100.00% covered (success)	100.00%	1 / 1	3	100.00% covered (success)	100.00%	4 / 4
recreateIndex				100.00% covered (success)	100.00%	1 / 1	1	100.00% covered (success)	100.00%	3 / 3
createDropIndex				100.00% covered (success)	100.00%	1 / 1	1	100.00% covered (success)	100.00%	3 / 3
createAddIndex				100.00% covered (success)	100.00%	1 / 1	1	100.00% covered (success)	100.00%	3 / 3
getAddIndexStatementList				100.00% covered (success)	100.00%	1 / 1	1	100.00% covered (success)	100.00%	1 / 1
getDropIndexStatementList				100.00% covered (success)	100.00%	1 / 1	1	100.00% covered (success)	100.00%	1 / 1
getIndexMetaDataByIndex				100.00% covered (success)	100.00%	1 / 1	3	100.00% covered (success)	100.00%	4 / 4

1	<?php
2	declare(strict_types = 1);
3
4	namespace Siesta\Migration;
5
6	use Siesta\Database\MetaData\IndexMetaData;
7	use Siesta\Database\MetaData\IndexPartMetaData;
8	use Siesta\Database\MigrationStatementFactory;
9	use Siesta\Model\Index;
10	use Siesta\Model\IndexPart;
11
12	/**
13	* @author Gregor Müller
14	*/
15	class IndexListMigrator
16	{
17
18	/**
19	* @var MigrationStatementFactory
20	*/
21	protected $migrationStatementFactory;
22
23	/**
24	* @var IndexMetaData[]
25	*/
26	protected $indexMetaDataList;
27
28	/**
29	* @var Index[]
30	*/
31	protected $indexList;
32
33	/**
34	* @var string[]
35	*/
36	protected $addIndexStatementList;
37
38	/**
39	* @var string[]
40	*/
41	protected $dropIndexStatementList;
42
43	/**
44	* IndexListMigrator constructor.
45	*
46	* @param MigrationStatementFactory $migrationStatementFactory
47	* @param IndexMetaData[] $indexMetaDataList
48	* @param Index[] $indexList
49	*/
50	public function __construct(MigrationStatementFactory $migrationStatementFactory, array $indexMetaDataList, array $indexList)
51	{
52	$this->migrationStatementFactory = $migrationStatementFactory;
53	$this->indexMetaDataList = $indexMetaDataList;
54	$this->indexList = $indexList;
55
56	$this->addIndexStatementList = [];
57	$this->dropIndexStatementList = [];
58	}
59
60	/**
61	* compares both attribute list and request the needed alter statements
62	* @return void
63	*/
64	public function createAlterStatementList()
65	{
66	$processedIndexList = [];
67
68	foreach ($this->indexList as $index) {
69
70	$indexMetaData = $this->getIndexMetaDataByIndex($index);
71
72	$this->createAlterStatement($indexMetaData, $index);
73
74	if ($indexMetaData) {
75	$processedIndexList[] = $indexMetaData->getName();
76	}
77	}
78
79	foreach ($this->indexMetaDataList as $indexMetaData) {
80
81	if (in_array($indexMetaData->getName(), $processedIndexList)) {
82	continue;
83	}
84
85	$this->createAlterStatement($indexMetaData, null);
86	}
87
88	}
89
90	/**
91	* @param IndexMetaData\|null $indexMetaData
92	* @param Index\|null $index
93	*/
94	private function createAlterStatement(IndexMetaData $indexMetaData = null, Index $index = null)
95	{
96
97	// nothing in db create the index
98	if ($indexMetaData === null) {
99	$this->createAddIndex($index);
100	return;
101	}
102
103	// nothing in model, drop the index
104	if ($index === null) {
105	$this->createDropIndex($indexMetaData);
106	return;
107	}
108
109	$this->compareIndex($indexMetaData, $index);
110
111	}
112
113	/**
114	* @param IndexMetaData $indexMetaData
115	* @param Index $index
116	*/
117	private function compareIndex(IndexMetaData $indexMetaData, Index $index)
118	{
119	if (strtoupper($indexMetaData->getType()) !== strtoupper($index->getIndexType())) {
120	$this->recreateIndex($indexMetaData, $index);
121	return;
122	}
123
124	if ($indexMetaData->getIsUnique() !== $index->getIsUnique()) {
125	$this->recreateIndex($indexMetaData, $index);
126	return;
127	}
128
129	$databasePartList = $indexMetaData->getIndexPartList();
130	$modelPartList = $index->getIndexPartList();
131
132	if (sizeof($databasePartList) !== sizeof($modelPartList)) {
133	$this->recreateIndex($indexMetaData, $index);
134	return;
135	}
136
137	if ($this->needsRecreationOfIndex($databasePartList, $modelPartList)) {
138	$this->recreateIndex($indexMetaData, $index);
139	}
140
141	}
142
143	/**
144	* @param IndexPartMetaData[] $databaseIndexPart
145	* @param IndexPart[] $modelIndexPartList
146	*
147	* @return bool
148	*/
149	private function needsRecreationOfIndex($databaseIndexPart, $modelIndexPartList)
150	{
151	foreach ($modelIndexPartList as $modelIndexPart) {
152	$databaseIndex = $this->getIndexPartByColumnName($databaseIndexPart, $modelIndexPart->getColumnName());
153	if ($databaseIndex === null) {
154	return true;
155	}
156
157	$dbLength = $databaseIndex->getLength() ? $databaseIndex->getLength() : null;
158	$modelLength = $modelIndexPart->getLength() ? $modelIndexPart->getLength() : null;
159	if ($dbLength !== $modelLength) {
160	return true;
161	}
162	}
163	return false;
164	}
165
166	/**
167	* @param IndexPartMetaData[] $databaseIndexPartList
168	* @param string $columnName
169	*
170	* @return IndexPartMetaData\|null
171	*/
172	private function getIndexPartByColumnName(array $databaseIndexPartList, string $columnName)
173	{
174	foreach ($databaseIndexPartList as $databaseIndexPart) {
175	if ($databaseIndexPart->getColumnName() === $columnName) {
176	return $databaseIndexPart;
177	}
178	}
179	return null;
180	}
181
182	/**
183	* @param IndexMetaData $indexMetaData
184	* @param Index $index
185	*/
186	private function recreateIndex(IndexMetaData $indexMetaData, Index $index)
187	{
188	$this->createDropIndex($indexMetaData);
189	$this->createAddIndex($index);
190	}
191
192	/**
193	* @param IndexMetaData $indexMetaData
194	*/
195	private function createDropIndex(IndexMetaData $indexMetaData)
196	{
197	$dropList = $this->migrationStatementFactory->createDropIndexStatement($indexMetaData);
198	$this->dropIndexStatementList = array_merge($this->dropIndexStatementList, $dropList);
199	}
200
201	/**
202	* @param Index $index
203	*/
204	private function createAddIndex(Index $index)
205	{
206	$addList = $this->migrationStatementFactory->createAddIndexStatement($index);
207	$this->addIndexStatementList = array_merge($this->addIndexStatementList, $addList);
208	}
209
210	/**
211	* @return string[]
212	*/
213	public function getAddIndexStatementList()
214	{
215	return $this->addIndexStatementList;
216	}
217
218	/**
219	* @return string[]
220	*/
221	public function getDropIndexStatementList()
222	{
223	return $this->dropIndexStatementList;
224	}
225
226	/**
227	* @param Index $index
228	*
229	* @return null\|IndexMetaData
230	*/
231	private function getIndexMetaDataByIndex(Index $index)
232	{
233	foreach ($this->indexMetaDataList as $indexMetaData) {
234	if ($indexMetaData->getName() === $index->getName()) {
235	return $indexMetaData;
236	}
237	}
238	return null;
239	}
240
241	}