Completed
Push — 4.0 ( 984e8a...f02fa4 )
by David
08:59 queued 18s
created
src/Mouf/Database/TDBM/Utils/BeanDescriptor.php 2 patches
Indentation   +440 added lines, -440 removed lines patch added patch discarded remove patch
@@ -15,214 +15,214 @@  discard block
 block discarded – undo
15 15
  */
16 16
 class BeanDescriptor
17 17
 {
18
-    /**
19
-     * @var Table
20
-     */
21
-    private $table;
22
-
23
-    /**
24
-     * @var SchemaAnalyzer
25
-     */
26
-    private $schemaAnalyzer;
27
-
28
-    /**
29
-     * @var Schema
30
-     */
31
-    private $schema;
32
-
33
-    /**
34
-     * @var AbstractBeanPropertyDescriptor[]
35
-     */
36
-    private $beanPropertyDescriptors = [];
37
-
38
-    /**
39
-     * @var TDBMSchemaAnalyzer
40
-     */
41
-    private $tdbmSchemaAnalyzer;
42
-
43
-    public function __construct(Table $table, SchemaAnalyzer $schemaAnalyzer, Schema $schema, TDBMSchemaAnalyzer $tdbmSchemaAnalyzer)
44
-    {
45
-        $this->table = $table;
46
-        $this->schemaAnalyzer = $schemaAnalyzer;
47
-        $this->schema = $schema;
48
-        $this->tdbmSchemaAnalyzer = $tdbmSchemaAnalyzer;
49
-        $this->initBeanPropertyDescriptors();
50
-    }
51
-
52
-    private function initBeanPropertyDescriptors()
53
-    {
54
-        $this->beanPropertyDescriptors = $this->getProperties($this->table);
55
-    }
56
-
57
-    /**
58
-     * Returns the foreignkey the column is part of, if any. null otherwise.
59
-     *
60
-     * @param Table  $table
61
-     * @param Column $column
62
-     *
63
-     * @return ForeignKeyConstraint|null
64
-     */
65
-    private function isPartOfForeignKey(Table $table, Column $column)
66
-    {
67
-        $localColumnName = $column->getName();
68
-        foreach ($table->getForeignKeys() as $foreignKey) {
69
-            foreach ($foreignKey->getColumns() as $columnName) {
70
-                if ($columnName === $localColumnName) {
71
-                    return $foreignKey;
72
-                }
73
-            }
74
-        }
75
-
76
-        return;
77
-    }
78
-
79
-    /**
80
-     * @return AbstractBeanPropertyDescriptor[]
81
-     */
82
-    public function getBeanPropertyDescriptors()
83
-    {
84
-        return $this->beanPropertyDescriptors;
85
-    }
86
-
87
-    /**
88
-     * Returns the list of columns that are not nullable and not autogenerated for a given table and its parent.
89
-     *
90
-     * @return AbstractBeanPropertyDescriptor[]
91
-     */
92
-    public function getConstructorProperties()
93
-    {
94
-        $constructorProperties = array_filter($this->beanPropertyDescriptors, function (AbstractBeanPropertyDescriptor $property) {
95
-           return $property->isCompulsory();
96
-        });
97
-
98
-        return $constructorProperties;
99
-    }
100
-
101
-    /**
102
-     * Returns the list of properties exposed as getters and setters in this class.
103
-     *
104
-     * @return AbstractBeanPropertyDescriptor[]
105
-     */
106
-    public function getExposedProperties()
107
-    {
108
-        $exposedProperties = array_filter($this->beanPropertyDescriptors, function (AbstractBeanPropertyDescriptor $property) {
109
-            return $property->getTable()->getName() == $this->table->getName();
110
-        });
111
-
112
-        return $exposedProperties;
113
-    }
114
-
115
-    /**
116
-     * Returns the list of properties for this table (including parent tables).
117
-     *
118
-     * @param Table $table
119
-     *
120
-     * @return AbstractBeanPropertyDescriptor[]
121
-     */
122
-    private function getProperties(Table $table)
123
-    {
124
-        $parentRelationship = $this->schemaAnalyzer->getParentRelationship($table->getName());
125
-        if ($parentRelationship) {
126
-            $parentTable = $this->schema->getTable($parentRelationship->getForeignTableName());
127
-            $properties = $this->getProperties($parentTable);
128
-            // we merge properties by overriding property names.
129
-            $localProperties = $this->getPropertiesForTable($table);
130
-            foreach ($localProperties as $name => $property) {
131
-                // We do not override properties if this is a primary key!
132
-                if ($property->isPrimaryKey()) {
133
-                    continue;
134
-                }
135
-                $properties[$name] = $property;
136
-            }
137
-            //$properties = array_merge($properties, $localProperties);
138
-        } else {
139
-            $properties = $this->getPropertiesForTable($table);
140
-        }
141
-
142
-        return $properties;
143
-    }
144
-
145
-    /**
146
-     * Returns the list of properties for this table (ignoring parent tables).
147
-     *
148
-     * @param Table $table
149
-     *
150
-     * @return AbstractBeanPropertyDescriptor[]
151
-     */
152
-    private function getPropertiesForTable(Table $table)
153
-    {
154
-        $parentRelationship = $this->schemaAnalyzer->getParentRelationship($table->getName());
155
-        if ($parentRelationship) {
156
-            $ignoreColumns = $parentRelationship->getLocalColumns();
157
-        } else {
158
-            $ignoreColumns = [];
159
-        }
160
-
161
-        $beanPropertyDescriptors = [];
162
-
163
-        foreach ($table->getColumns() as $column) {
164
-            if (array_search($column->getName(), $ignoreColumns) !== false) {
165
-                continue;
166
-            }
167
-
168
-            $fk = $this->isPartOfForeignKey($table, $column);
169
-            if ($fk !== null) {
170
-                // Check that previously added descriptors are not added on same FK (can happen with multi key FK).
171
-                foreach ($beanPropertyDescriptors as $beanDescriptor) {
172
-                    if ($beanDescriptor instanceof ObjectBeanPropertyDescriptor && $beanDescriptor->getForeignKey() === $fk) {
173
-                        continue 2;
174
-                    }
175
-                }
176
-                // Check that this property is not an inheritance relationship
177
-                $parentRelationship = $this->schemaAnalyzer->getParentRelationship($table->getName());
178
-                if ($parentRelationship === $fk) {
179
-                    continue;
180
-                }
181
-
182
-                $beanPropertyDescriptors[] = new ObjectBeanPropertyDescriptor($table, $fk, $this->schemaAnalyzer);
183
-            } else {
184
-                $beanPropertyDescriptors[] = new ScalarBeanPropertyDescriptor($table, $column);
185
-            }
186
-        }
187
-
188
-        // Now, let's get the name of all properties and let's check there is no duplicate.
189
-        /** @var $names AbstractBeanPropertyDescriptor[] */
190
-        $names = [];
191
-        foreach ($beanPropertyDescriptors as $beanDescriptor) {
192
-            $name = $beanDescriptor->getUpperCamelCaseName();
193
-            if (isset($names[$name])) {
194
-                $names[$name]->useAlternativeName();
195
-                $beanDescriptor->useAlternativeName();
196
-            } else {
197
-                $names[$name] = $beanDescriptor;
198
-            }
199
-        }
200
-
201
-        // Final check (throw exceptions if problem arises)
202
-        $names = [];
203
-        foreach ($beanPropertyDescriptors as $beanDescriptor) {
204
-            $name = $beanDescriptor->getUpperCamelCaseName();
205
-            if (isset($names[$name])) {
206
-                throw new TDBMException('Unsolvable name conflict while generating method name');
207
-            } else {
208
-                $names[$name] = $beanDescriptor;
209
-            }
210
-        }
211
-
212
-        // Last step, let's rebuild the list with a map:
213
-        $beanPropertyDescriptorsMap = [];
214
-        foreach ($beanPropertyDescriptors as $beanDescriptor) {
215
-            $beanPropertyDescriptorsMap[$beanDescriptor->getLowerCamelCaseName()] = $beanDescriptor;
216
-        }
217
-
218
-        return $beanPropertyDescriptorsMap;
219
-    }
220
-
221
-    public function generateBeanConstructor()
222
-    {
223
-        $constructorProperties = $this->getConstructorProperties();
224
-
225
-        $constructorCode = '    /**
18
+	/**
19
+	 * @var Table
20
+	 */
21
+	private $table;
22
+
23
+	/**
24
+	 * @var SchemaAnalyzer
25
+	 */
26
+	private $schemaAnalyzer;
27
+
28
+	/**
29
+	 * @var Schema
30
+	 */
31
+	private $schema;
32
+
33
+	/**
34
+	 * @var AbstractBeanPropertyDescriptor[]
35
+	 */
36
+	private $beanPropertyDescriptors = [];
37
+
38
+	/**
39
+	 * @var TDBMSchemaAnalyzer
40
+	 */
41
+	private $tdbmSchemaAnalyzer;
42
+
43
+	public function __construct(Table $table, SchemaAnalyzer $schemaAnalyzer, Schema $schema, TDBMSchemaAnalyzer $tdbmSchemaAnalyzer)
44
+	{
45
+		$this->table = $table;
46
+		$this->schemaAnalyzer = $schemaAnalyzer;
47
+		$this->schema = $schema;
48
+		$this->tdbmSchemaAnalyzer = $tdbmSchemaAnalyzer;
49
+		$this->initBeanPropertyDescriptors();
50
+	}
51
+
52
+	private function initBeanPropertyDescriptors()
53
+	{
54
+		$this->beanPropertyDescriptors = $this->getProperties($this->table);
55
+	}
56
+
57
+	/**
58
+	 * Returns the foreignkey the column is part of, if any. null otherwise.
59
+	 *
60
+	 * @param Table  $table
61
+	 * @param Column $column
62
+	 *
63
+	 * @return ForeignKeyConstraint|null
64
+	 */
65
+	private function isPartOfForeignKey(Table $table, Column $column)
66
+	{
67
+		$localColumnName = $column->getName();
68
+		foreach ($table->getForeignKeys() as $foreignKey) {
69
+			foreach ($foreignKey->getColumns() as $columnName) {
70
+				if ($columnName === $localColumnName) {
71
+					return $foreignKey;
72
+				}
73
+			}
74
+		}
75
+
76
+		return;
77
+	}
78
+
79
+	/**
80
+	 * @return AbstractBeanPropertyDescriptor[]
81
+	 */
82
+	public function getBeanPropertyDescriptors()
83
+	{
84
+		return $this->beanPropertyDescriptors;
85
+	}
86
+
87
+	/**
88
+	 * Returns the list of columns that are not nullable and not autogenerated for a given table and its parent.
89
+	 *
90
+	 * @return AbstractBeanPropertyDescriptor[]
91
+	 */
92
+	public function getConstructorProperties()
93
+	{
94
+		$constructorProperties = array_filter($this->beanPropertyDescriptors, function (AbstractBeanPropertyDescriptor $property) {
95
+		   return $property->isCompulsory();
96
+		});
97
+
98
+		return $constructorProperties;
99
+	}
100
+
101
+	/**
102
+	 * Returns the list of properties exposed as getters and setters in this class.
103
+	 *
104
+	 * @return AbstractBeanPropertyDescriptor[]
105
+	 */
106
+	public function getExposedProperties()
107
+	{
108
+		$exposedProperties = array_filter($this->beanPropertyDescriptors, function (AbstractBeanPropertyDescriptor $property) {
109
+			return $property->getTable()->getName() == $this->table->getName();
110
+		});
111
+
112
+		return $exposedProperties;
113
+	}
114
+
115
+	/**
116
+	 * Returns the list of properties for this table (including parent tables).
117
+	 *
118
+	 * @param Table $table
119
+	 *
120
+	 * @return AbstractBeanPropertyDescriptor[]
121
+	 */
122
+	private function getProperties(Table $table)
123
+	{
124
+		$parentRelationship = $this->schemaAnalyzer->getParentRelationship($table->getName());
125
+		if ($parentRelationship) {
126
+			$parentTable = $this->schema->getTable($parentRelationship->getForeignTableName());
127
+			$properties = $this->getProperties($parentTable);
128
+			// we merge properties by overriding property names.
129
+			$localProperties = $this->getPropertiesForTable($table);
130
+			foreach ($localProperties as $name => $property) {
131
+				// We do not override properties if this is a primary key!
132
+				if ($property->isPrimaryKey()) {
133
+					continue;
134
+				}
135
+				$properties[$name] = $property;
136
+			}
137
+			//$properties = array_merge($properties, $localProperties);
138
+		} else {
139
+			$properties = $this->getPropertiesForTable($table);
140
+		}
141
+
142
+		return $properties;
143
+	}
144
+
145
+	/**
146
+	 * Returns the list of properties for this table (ignoring parent tables).
147
+	 *
148
+	 * @param Table $table
149
+	 *
150
+	 * @return AbstractBeanPropertyDescriptor[]
151
+	 */
152
+	private function getPropertiesForTable(Table $table)
153
+	{
154
+		$parentRelationship = $this->schemaAnalyzer->getParentRelationship($table->getName());
155
+		if ($parentRelationship) {
156
+			$ignoreColumns = $parentRelationship->getLocalColumns();
157
+		} else {
158
+			$ignoreColumns = [];
159
+		}
160
+
161
+		$beanPropertyDescriptors = [];
162
+
163
+		foreach ($table->getColumns() as $column) {
164
+			if (array_search($column->getName(), $ignoreColumns) !== false) {
165
+				continue;
166
+			}
167
+
168
+			$fk = $this->isPartOfForeignKey($table, $column);
169
+			if ($fk !== null) {
170
+				// Check that previously added descriptors are not added on same FK (can happen with multi key FK).
171
+				foreach ($beanPropertyDescriptors as $beanDescriptor) {
172
+					if ($beanDescriptor instanceof ObjectBeanPropertyDescriptor && $beanDescriptor->getForeignKey() === $fk) {
173
+						continue 2;
174
+					}
175
+				}
176
+				// Check that this property is not an inheritance relationship
177
+				$parentRelationship = $this->schemaAnalyzer->getParentRelationship($table->getName());
178
+				if ($parentRelationship === $fk) {
179
+					continue;
180
+				}
181
+
182
+				$beanPropertyDescriptors[] = new ObjectBeanPropertyDescriptor($table, $fk, $this->schemaAnalyzer);
183
+			} else {
184
+				$beanPropertyDescriptors[] = new ScalarBeanPropertyDescriptor($table, $column);
185
+			}
186
+		}
187
+
188
+		// Now, let's get the name of all properties and let's check there is no duplicate.
189
+		/** @var $names AbstractBeanPropertyDescriptor[] */
190
+		$names = [];
191
+		foreach ($beanPropertyDescriptors as $beanDescriptor) {
192
+			$name = $beanDescriptor->getUpperCamelCaseName();
193
+			if (isset($names[$name])) {
194
+				$names[$name]->useAlternativeName();
195
+				$beanDescriptor->useAlternativeName();
196
+			} else {
197
+				$names[$name] = $beanDescriptor;
198
+			}
199
+		}
200
+
201
+		// Final check (throw exceptions if problem arises)
202
+		$names = [];
203
+		foreach ($beanPropertyDescriptors as $beanDescriptor) {
204
+			$name = $beanDescriptor->getUpperCamelCaseName();
205
+			if (isset($names[$name])) {
206
+				throw new TDBMException('Unsolvable name conflict while generating method name');
207
+			} else {
208
+				$names[$name] = $beanDescriptor;
209
+			}
210
+		}
211
+
212
+		// Last step, let's rebuild the list with a map:
213
+		$beanPropertyDescriptorsMap = [];
214
+		foreach ($beanPropertyDescriptors as $beanDescriptor) {
215
+			$beanPropertyDescriptorsMap[$beanDescriptor->getLowerCamelCaseName()] = $beanDescriptor;
216
+		}
217
+
218
+		return $beanPropertyDescriptorsMap;
219
+	}
220
+
221
+	public function generateBeanConstructor()
222
+	{
223
+		$constructorProperties = $this->getConstructorProperties();
224
+
225
+		$constructorCode = '    /**
226 226
      * The constructor takes all compulsory arguments.
227 227
      *
228 228
 %s
@@ -232,65 +232,65 @@  discard block
 block discarded – undo
232 232
     }
233 233
     ';
234 234
 
235
-        $paramAnnotations = [];
236
-        $arguments = [];
237
-        $assigns = [];
238
-        $parentConstructorArguments = [];
239
-
240
-        foreach ($constructorProperties as $property) {
241
-            $className = $property->getClassName();
242
-            if ($className) {
243
-                $arguments[] = $className.' '.$property->getVariableName();
244
-            } else {
245
-                $arguments[] = $property->getVariableName();
246
-            }
247
-            $paramAnnotations[] = $property->getParamAnnotation();
248
-            if ($property->getTable()->getName() === $this->table->getName()) {
249
-                $assigns[] = $property->getConstructorAssignCode();
250
-            } else {
251
-                $parentConstructorArguments[] = $property->getVariableName();
252
-            }
253
-        }
254
-
255
-        $parentConstrutorCode = sprintf("        parent::__construct(%s);\n", implode(', ', $parentConstructorArguments));
256
-
257
-        return sprintf($constructorCode, implode("\n", $paramAnnotations), implode(', ', $arguments), $parentConstrutorCode, implode("\n", $assigns));
258
-    }
259
-
260
-    public function generateDirectForeignKeysCode()
261
-    {
262
-        $fks = $this->tdbmSchemaAnalyzer->getIncomingForeignKeys($this->table->getName());
263
-
264
-        $fksByTable = [];
265
-
266
-        foreach ($fks as $fk) {
267
-            $fksByTable[$fk->getLocalTableName()][] = $fk;
268
-        }
269
-
270
-        /* @var $fksByMethodName ForeignKeyConstraint[] */
271
-        $fksByMethodName = [];
272
-
273
-        foreach ($fksByTable as $tableName => $fksForTable) {
274
-            if (count($fksForTable) > 1) {
275
-                foreach ($fksForTable as $fk) {
276
-                    $methodName = 'get'.TDBMDaoGenerator::toCamelCase($fk->getLocalTableName()).'By';
277
-
278
-                    $camelizedColumns = array_map(['Mouf\\Database\\TDBM\\Utils\\TDBMDaoGenerator', 'toCamelCase'], $fk->getLocalColumns());
279
-
280
-                    $methodName .= implode('And', $camelizedColumns);
281
-
282
-                    $fksByMethodName[$methodName] = $fk;
283
-                }
284
-            } else {
285
-                $methodName = 'get'.TDBMDaoGenerator::toCamelCase($fksForTable[0]->getLocalTableName());
286
-                $fksByMethodName[$methodName] = $fk;
287
-            }
288
-        }
289
-
290
-        $code = '';
291
-
292
-        foreach ($fksByMethodName as $methodName => $fk) {
293
-            $getterCode = '    /**
235
+		$paramAnnotations = [];
236
+		$arguments = [];
237
+		$assigns = [];
238
+		$parentConstructorArguments = [];
239
+
240
+		foreach ($constructorProperties as $property) {
241
+			$className = $property->getClassName();
242
+			if ($className) {
243
+				$arguments[] = $className.' '.$property->getVariableName();
244
+			} else {
245
+				$arguments[] = $property->getVariableName();
246
+			}
247
+			$paramAnnotations[] = $property->getParamAnnotation();
248
+			if ($property->getTable()->getName() === $this->table->getName()) {
249
+				$assigns[] = $property->getConstructorAssignCode();
250
+			} else {
251
+				$parentConstructorArguments[] = $property->getVariableName();
252
+			}
253
+		}
254
+
255
+		$parentConstrutorCode = sprintf("        parent::__construct(%s);\n", implode(', ', $parentConstructorArguments));
256
+
257
+		return sprintf($constructorCode, implode("\n", $paramAnnotations), implode(', ', $arguments), $parentConstrutorCode, implode("\n", $assigns));
258
+	}
259
+
260
+	public function generateDirectForeignKeysCode()
261
+	{
262
+		$fks = $this->tdbmSchemaAnalyzer->getIncomingForeignKeys($this->table->getName());
263
+
264
+		$fksByTable = [];
265
+
266
+		foreach ($fks as $fk) {
267
+			$fksByTable[$fk->getLocalTableName()][] = $fk;
268
+		}
269
+
270
+		/* @var $fksByMethodName ForeignKeyConstraint[] */
271
+		$fksByMethodName = [];
272
+
273
+		foreach ($fksByTable as $tableName => $fksForTable) {
274
+			if (count($fksForTable) > 1) {
275
+				foreach ($fksForTable as $fk) {
276
+					$methodName = 'get'.TDBMDaoGenerator::toCamelCase($fk->getLocalTableName()).'By';
277
+
278
+					$camelizedColumns = array_map(['Mouf\\Database\\TDBM\\Utils\\TDBMDaoGenerator', 'toCamelCase'], $fk->getLocalColumns());
279
+
280
+					$methodName .= implode('And', $camelizedColumns);
281
+
282
+					$fksByMethodName[$methodName] = $fk;
283
+				}
284
+			} else {
285
+				$methodName = 'get'.TDBMDaoGenerator::toCamelCase($fksForTable[0]->getLocalTableName());
286
+				$fksByMethodName[$methodName] = $fk;
287
+			}
288
+		}
289
+
290
+		$code = '';
291
+
292
+		foreach ($fksByMethodName as $methodName => $fk) {
293
+			$getterCode = '    /**
294 294
      * Returns the list of %s pointing to this bean via the %s column.
295 295
      *
296 296
      * @return %s[]|ResultIterator
@@ -302,111 +302,111 @@  discard block
 block discarded – undo
302 302
 
303 303
 ';
304 304
 
305
-            list($sql, $parametersCode) = $this->getFilters($fk);
306
-
307
-            $beanClass = TDBMDaoGenerator::getBeanNameFromTableName($fk->getLocalTableName());
308
-            $code .= sprintf($getterCode,
309
-                $beanClass,
310
-                implode(', ', $fk->getColumns()),
311
-                $beanClass,
312
-                $methodName,
313
-                var_export($fk->getLocalTableName(), true),
314
-                $sql,
315
-                $parametersCode
316
-            );
317
-        }
318
-
319
-        return $code;
320
-    }
321
-
322
-    private function getFilters(ForeignKeyConstraint $fk)
323
-    {
324
-        $sqlParts = [];
325
-        $counter = 0;
326
-        $parameters = [];
327
-
328
-        $pkColumns = $this->table->getPrimaryKeyColumns();
329
-
330
-        foreach ($fk->getLocalColumns() as $columnName) {
331
-            $paramName = 'tdbmparam'.$counter;
332
-            $sqlParts[] = $fk->getLocalTableName().'.'.$columnName.' = :'.$paramName;
333
-
334
-            $pkColumn = $pkColumns[$counter];
335
-            $parameters[] = sprintf('%s => $this->get(%s, %s)', var_export($paramName, true), var_export($pkColumn, true), var_export($this->table->getName(), true));
336
-            ++$counter;
337
-        }
338
-        $sql = "'".implode(' AND ', $sqlParts)."'";
339
-        $parametersCode = '[ '.implode(', ', $parameters).' ]';
340
-
341
-        return [$sql, $parametersCode];
342
-    }
343
-
344
-    /**
345
-     * Generate code section about pivot tables.
346
-     *
347
-     * @return string;
348
-     */
349
-    public function generatePivotTableCode()
350
-    {
351
-        $finalDescs = $this->getPivotTableDescriptors();
352
-
353
-        $code = '';
354
-
355
-        foreach ($finalDescs as $desc) {
356
-            $code .= $this->getPivotTableCode($desc['name'], $desc['table'], $desc['localFK'], $desc['remoteFK']);
357
-        }
358
-
359
-        return $code;
360
-    }
361
-
362
-    private function getPivotTableDescriptors()
363
-    {
364
-        $descs = [];
365
-        foreach ($this->schemaAnalyzer->detectJunctionTables() as $table) {
366
-            // There are exactly 2 FKs since this is a pivot table.
367
-            $fks = array_values($table->getForeignKeys());
368
-
369
-            if ($fks[0]->getForeignTableName() === $this->table->getName()) {
370
-                $localFK = $fks[0];
371
-                $remoteFK = $fks[1];
372
-            } elseif ($fks[1]->getForeignTableName() === $this->table->getName()) {
373
-                $localFK = $fks[1];
374
-                $remoteFK = $fks[0];
375
-            } else {
376
-                continue;
377
-            }
378
-
379
-            $descs[$remoteFK->getForeignTableName()][] = [
380
-                'table' => $table,
381
-                'localFK' => $localFK,
382
-                'remoteFK' => $remoteFK,
383
-            ];
384
-        }
385
-
386
-        $finalDescs = [];
387
-        foreach ($descs as $descArray) {
388
-            if (count($descArray) > 1) {
389
-                foreach ($descArray as $desc) {
390
-                    $desc['name'] = TDBMDaoGenerator::toCamelCase($desc['remoteFK']->getForeignTableName()).'By'.TDBMDaoGenerator::toCamelCase($desc['table']->getName());
391
-                    $finalDescs[] = $desc;
392
-                }
393
-            } else {
394
-                $desc = $descArray[0];
395
-                $desc['name'] = TDBMDaoGenerator::toCamelCase($desc['remoteFK']->getForeignTableName());
396
-                $finalDescs[] = $desc;
397
-            }
398
-        }
399
-
400
-        return $finalDescs;
401
-    }
402
-
403
-    public function getPivotTableCode($name, Table $table, ForeignKeyConstraint $localFK, ForeignKeyConstraint $remoteFK)
404
-    {
405
-        $singularName = TDBMDaoGenerator::toSingular($name);
406
-        $remoteBeanName = TDBMDaoGenerator::getBeanNameFromTableName($remoteFK->getForeignTableName());
407
-        $variableName = '$'.TDBMDaoGenerator::toVariableName($remoteBeanName);
408
-
409
-        $str = '    /**
305
+			list($sql, $parametersCode) = $this->getFilters($fk);
306
+
307
+			$beanClass = TDBMDaoGenerator::getBeanNameFromTableName($fk->getLocalTableName());
308
+			$code .= sprintf($getterCode,
309
+				$beanClass,
310
+				implode(', ', $fk->getColumns()),
311
+				$beanClass,
312
+				$methodName,
313
+				var_export($fk->getLocalTableName(), true),
314
+				$sql,
315
+				$parametersCode
316
+			);
317
+		}
318
+
319
+		return $code;
320
+	}
321
+
322
+	private function getFilters(ForeignKeyConstraint $fk)
323
+	{
324
+		$sqlParts = [];
325
+		$counter = 0;
326
+		$parameters = [];
327
+
328
+		$pkColumns = $this->table->getPrimaryKeyColumns();
329
+
330
+		foreach ($fk->getLocalColumns() as $columnName) {
331
+			$paramName = 'tdbmparam'.$counter;
332
+			$sqlParts[] = $fk->getLocalTableName().'.'.$columnName.' = :'.$paramName;
333
+
334
+			$pkColumn = $pkColumns[$counter];
335
+			$parameters[] = sprintf('%s => $this->get(%s, %s)', var_export($paramName, true), var_export($pkColumn, true), var_export($this->table->getName(), true));
336
+			++$counter;
337
+		}
338
+		$sql = "'".implode(' AND ', $sqlParts)."'";
339
+		$parametersCode = '[ '.implode(', ', $parameters).' ]';
340
+
341
+		return [$sql, $parametersCode];
342
+	}
343
+
344
+	/**
345
+	 * Generate code section about pivot tables.
346
+	 *
347
+	 * @return string;
348
+	 */
349
+	public function generatePivotTableCode()
350
+	{
351
+		$finalDescs = $this->getPivotTableDescriptors();
352
+
353
+		$code = '';
354
+
355
+		foreach ($finalDescs as $desc) {
356
+			$code .= $this->getPivotTableCode($desc['name'], $desc['table'], $desc['localFK'], $desc['remoteFK']);
357
+		}
358
+
359
+		return $code;
360
+	}
361
+
362
+	private function getPivotTableDescriptors()
363
+	{
364
+		$descs = [];
365
+		foreach ($this->schemaAnalyzer->detectJunctionTables() as $table) {
366
+			// There are exactly 2 FKs since this is a pivot table.
367
+			$fks = array_values($table->getForeignKeys());
368
+
369
+			if ($fks[0]->getForeignTableName() === $this->table->getName()) {
370
+				$localFK = $fks[0];
371
+				$remoteFK = $fks[1];
372
+			} elseif ($fks[1]->getForeignTableName() === $this->table->getName()) {
373
+				$localFK = $fks[1];
374
+				$remoteFK = $fks[0];
375
+			} else {
376
+				continue;
377
+			}
378
+
379
+			$descs[$remoteFK->getForeignTableName()][] = [
380
+				'table' => $table,
381
+				'localFK' => $localFK,
382
+				'remoteFK' => $remoteFK,
383
+			];
384
+		}
385
+
386
+		$finalDescs = [];
387
+		foreach ($descs as $descArray) {
388
+			if (count($descArray) > 1) {
389
+				foreach ($descArray as $desc) {
390
+					$desc['name'] = TDBMDaoGenerator::toCamelCase($desc['remoteFK']->getForeignTableName()).'By'.TDBMDaoGenerator::toCamelCase($desc['table']->getName());
391
+					$finalDescs[] = $desc;
392
+				}
393
+			} else {
394
+				$desc = $descArray[0];
395
+				$desc['name'] = TDBMDaoGenerator::toCamelCase($desc['remoteFK']->getForeignTableName());
396
+				$finalDescs[] = $desc;
397
+			}
398
+		}
399
+
400
+		return $finalDescs;
401
+	}
402
+
403
+	public function getPivotTableCode($name, Table $table, ForeignKeyConstraint $localFK, ForeignKeyConstraint $remoteFK)
404
+	{
405
+		$singularName = TDBMDaoGenerator::toSingular($name);
406
+		$remoteBeanName = TDBMDaoGenerator::getBeanNameFromTableName($remoteFK->getForeignTableName());
407
+		$variableName = '$'.TDBMDaoGenerator::toVariableName($remoteBeanName);
408
+
409
+		$str = '    /**
410 410
      * Returns the list of %s associated to this bean via the %s pivot table.
411 411
      *
412 412
      * @return %s[]
@@ -416,9 +416,9 @@  discard block
 block discarded – undo
416 416
     }
417 417
 ';
418 418
 
419
-        $getterCode = sprintf($str, $remoteBeanName, $table->getName(), $remoteBeanName, $name, var_export($remoteFK->getLocalTableName(), true));
419
+		$getterCode = sprintf($str, $remoteBeanName, $table->getName(), $remoteBeanName, $name, var_export($remoteFK->getLocalTableName(), true));
420 420
 
421
-        $str = '    /**
421
+		$str = '    /**
422 422
      * Adds a relationship with %s associated to this bean via the %s pivot table.
423 423
      *
424 424
      * @param %s %s
@@ -428,9 +428,9 @@  discard block
 block discarded – undo
428 428
     }
429 429
 ';
430 430
 
431
-        $adderCode = sprintf($str, $remoteBeanName, $table->getName(), $remoteBeanName, $variableName, $singularName, $remoteBeanName, $variableName, var_export($remoteFK->getLocalTableName(), true), $variableName);
431
+		$adderCode = sprintf($str, $remoteBeanName, $table->getName(), $remoteBeanName, $variableName, $singularName, $remoteBeanName, $variableName, var_export($remoteFK->getLocalTableName(), true), $variableName);
432 432
 
433
-        $str = '    /**
433
+		$str = '    /**
434 434
      * Deletes the relationship with %s associated to this bean via the %s pivot table.
435 435
      *
436 436
      * @param %s %s
@@ -440,9 +440,9 @@  discard block
 block discarded – undo
440 440
     }
441 441
 ';
442 442
 
443
-        $removerCode = sprintf($str, $remoteBeanName, $table->getName(), $remoteBeanName, $variableName, $singularName, $remoteBeanName, $variableName, var_export($remoteFK->getLocalTableName(), true), $variableName);
443
+		$removerCode = sprintf($str, $remoteBeanName, $table->getName(), $remoteBeanName, $variableName, $singularName, $remoteBeanName, $variableName, var_export($remoteFK->getLocalTableName(), true), $variableName);
444 444
 
445
-        $str = '    /**
445
+		$str = '    /**
446 446
      * Returns whether this bean is associated with %s via the %s pivot table.
447 447
      *
448 448
      * @param %s %s
@@ -453,24 +453,24 @@  discard block
 block discarded – undo
453 453
     }
454 454
 ';
455 455
 
456
-        $hasCode = sprintf($str, $remoteBeanName, $table->getName(), $remoteBeanName, $variableName, $singularName, $remoteBeanName, $variableName, var_export($remoteFK->getLocalTableName(), true), $variableName);
456
+		$hasCode = sprintf($str, $remoteBeanName, $table->getName(), $remoteBeanName, $variableName, $singularName, $remoteBeanName, $variableName, var_export($remoteFK->getLocalTableName(), true), $variableName);
457 457
 
458
-        $code = $getterCode.$adderCode.$removerCode.$hasCode;
458
+		$code = $getterCode.$adderCode.$removerCode.$hasCode;
459 459
 
460
-        return $code;
461
-    }
460
+		return $code;
461
+	}
462 462
 
463
-    public function generateJsonSerialize()
464
-    {
465
-        $tableName = $this->table->getName();
466
-        $parentFk = $this->schemaAnalyzer->getParentRelationship($tableName);
467
-        if ($parentFk !== null) {
468
-            $initializer = '$array = parent::jsonSerialize();';
469
-        } else {
470
-            $initializer = '$array = [];';
471
-        }
463
+	public function generateJsonSerialize()
464
+	{
465
+		$tableName = $this->table->getName();
466
+		$parentFk = $this->schemaAnalyzer->getParentRelationship($tableName);
467
+		if ($parentFk !== null) {
468
+			$initializer = '$array = parent::jsonSerialize();';
469
+		} else {
470
+			$initializer = '$array = [];';
471
+		}
472 472
 
473
-        $str = '
473
+		$str = '
474 474
     /**
475 475
      * Serializes the object for JSON encoding
476 476
      *
@@ -486,54 +486,54 @@  discard block
 block discarded – undo
486 486
     }
487 487
 ';
488 488
 
489
-        $propertiesCode = '';
490
-        foreach ($this->beanPropertyDescriptors as $beanPropertyDescriptor) {
491
-            $propertiesCode .= $beanPropertyDescriptor->getJsonSerializeCode();
492
-        }
489
+		$propertiesCode = '';
490
+		foreach ($this->beanPropertyDescriptors as $beanPropertyDescriptor) {
491
+			$propertiesCode .= $beanPropertyDescriptor->getJsonSerializeCode();
492
+		}
493 493
 
494
-        // Many to many relationships:
494
+		// Many to many relationships:
495 495
 
496
-        $descs = $this->getPivotTableDescriptors();
496
+		$descs = $this->getPivotTableDescriptors();
497 497
 
498
-        $many2manyCode = '';
498
+		$many2manyCode = '';
499 499
 
500
-        foreach ($descs as $desc) {
501
-            $remoteFK = $desc['remoteFK'];
502
-            $remoteBeanName = TDBMDaoGenerator::getBeanNameFromTableName($remoteFK->getForeignTableName());
503
-            $variableName = '$'.TDBMDaoGenerator::toVariableName($remoteBeanName);
500
+		foreach ($descs as $desc) {
501
+			$remoteFK = $desc['remoteFK'];
502
+			$remoteBeanName = TDBMDaoGenerator::getBeanNameFromTableName($remoteFK->getForeignTableName());
503
+			$variableName = '$'.TDBMDaoGenerator::toVariableName($remoteBeanName);
504 504
 
505
-            $many2manyCode .= '        if (!$stopRecursion) {
505
+			$many2manyCode .= '        if (!$stopRecursion) {
506 506
             $array[\''.lcfirst($desc['name']).'\'] = array_map(function('.$remoteBeanName.' '.$variableName.') {
507 507
                 return '.$variableName.'->jsonSerialize(true);
508 508
             }, $this->get'.$desc['name'].'());
509 509
         }
510 510
         ';
511
-        }
512
-
513
-        return sprintf($str, $initializer, $propertiesCode, $many2manyCode);
514
-    }
515
-
516
-    /**
517
-     * Writes the PHP bean file with all getters and setters from the table passed in parameter.
518
-     *
519
-     * @param string $beannamespace The namespace of the bean
520
-     */
521
-    public function generatePhpCode($beannamespace)
522
-    {
523
-        $baseClassName = TDBMDaoGenerator::getBaseBeanNameFromTableName($this->table->getName());
524
-        $className = TDBMDaoGenerator::getBeanNameFromTableName($this->table->getName());
525
-        $tableName = $this->table->getName();
526
-
527
-        $parentFk = $this->schemaAnalyzer->getParentRelationship($tableName);
528
-        if ($parentFk !== null) {
529
-            $extends = TDBMDaoGenerator::getBeanNameFromTableName($parentFk->getForeignTableName());
530
-            $use = '';
531
-        } else {
532
-            $extends = 'AbstractTDBMObject';
533
-            $use = "use Mouf\\Database\\TDBM\\AbstractTDBMObject;\n\n";
534
-        }
535
-
536
-        $str = "<?php
511
+		}
512
+
513
+		return sprintf($str, $initializer, $propertiesCode, $many2manyCode);
514
+	}
515
+
516
+	/**
517
+	 * Writes the PHP bean file with all getters and setters from the table passed in parameter.
518
+	 *
519
+	 * @param string $beannamespace The namespace of the bean
520
+	 */
521
+	public function generatePhpCode($beannamespace)
522
+	{
523
+		$baseClassName = TDBMDaoGenerator::getBaseBeanNameFromTableName($this->table->getName());
524
+		$className = TDBMDaoGenerator::getBeanNameFromTableName($this->table->getName());
525
+		$tableName = $this->table->getName();
526
+
527
+		$parentFk = $this->schemaAnalyzer->getParentRelationship($tableName);
528
+		if ($parentFk !== null) {
529
+			$extends = TDBMDaoGenerator::getBeanNameFromTableName($parentFk->getForeignTableName());
530
+			$use = '';
531
+		} else {
532
+			$extends = 'AbstractTDBMObject';
533
+			$use = "use Mouf\\Database\\TDBM\\AbstractTDBMObject;\n\n";
534
+		}
535
+
536
+		$str = "<?php
537 537
 namespace {$beannamespace};
538 538
 
539 539
 use Mouf\\Database\\TDBM\\ResultIterator;
@@ -551,19 +551,19 @@  discard block
 block discarded – undo
551 551
 {
552 552
 ";
553 553
 
554
-        $str .= $this->generateBeanConstructor();
554
+		$str .= $this->generateBeanConstructor();
555 555
 
556
-        foreach ($this->getExposedProperties() as $property) {
557
-            $str .= $property->getGetterSetterCode();
558
-        }
556
+		foreach ($this->getExposedProperties() as $property) {
557
+			$str .= $property->getGetterSetterCode();
558
+		}
559 559
 
560
-        $str .= $this->generateDirectForeignKeysCode();
561
-        $str .= $this->generatePivotTableCode();
562
-        $str .= $this->generateJsonSerialize();
560
+		$str .= $this->generateDirectForeignKeysCode();
561
+		$str .= $this->generatePivotTableCode();
562
+		$str .= $this->generateJsonSerialize();
563 563
 
564
-        $str .= '}
564
+		$str .= '}
565 565
 ';
566 566
 
567
-        return $str;
568
-    }
567
+		return $str;
568
+	}
569 569
 }
Please login to merge, or discard this patch.
Spacing   +4 added lines, -4 removed lines patch added patch discarded remove patch
@@ -91,7 +91,7 @@  discard block
 block discarded – undo
91 91
      */
92 92
     public function getConstructorProperties()
93 93
     {
94
-        $constructorProperties = array_filter($this->beanPropertyDescriptors, function (AbstractBeanPropertyDescriptor $property) {
94
+        $constructorProperties = array_filter($this->beanPropertyDescriptors, function(AbstractBeanPropertyDescriptor $property) {
95 95
            return $property->isCompulsory();
96 96
         });
97 97
 
@@ -105,7 +105,7 @@  discard block
 block discarded – undo
105 105
      */
106 106
     public function getExposedProperties()
107 107
     {
108
-        $exposedProperties = array_filter($this->beanPropertyDescriptors, function (AbstractBeanPropertyDescriptor $property) {
108
+        $exposedProperties = array_filter($this->beanPropertyDescriptors, function(AbstractBeanPropertyDescriptor $property) {
109 109
             return $property->getTable()->getName() == $this->table->getName();
110 110
         });
111 111
 
@@ -271,7 +271,7 @@  discard block
 block discarded – undo
271 271
         $fksByMethodName = [];
272 272
 
273 273
         foreach ($fksByTable as $tableName => $fksForTable) {
274
-            if (count($fksForTable) > 1) {
274
+            if (count($fksForTable)>1) {
275 275
                 foreach ($fksForTable as $fk) {
276 276
                     $methodName = 'get'.TDBMDaoGenerator::toCamelCase($fk->getLocalTableName()).'By';
277 277
 
@@ -385,7 +385,7 @@  discard block
 block discarded – undo
385 385
 
386 386
         $finalDescs = [];
387 387
         foreach ($descs as $descArray) {
388
-            if (count($descArray) > 1) {
388
+            if (count($descArray)>1) {
389 389
                 foreach ($descArray as $desc) {
390 390
                     $desc['name'] = TDBMDaoGenerator::toCamelCase($desc['remoteFK']->getForeignTableName()).'By'.TDBMDaoGenerator::toCamelCase($desc['table']->getName());
391 391
                     $finalDescs[] = $desc;
Please login to merge, or discard this patch.
src/Mouf/Database/TDBM/Utils/ObjectBeanPropertyDescriptor.php 2 patches
Indentation   +140 added lines, -140 removed lines patch added patch discarded remove patch
@@ -12,134 +12,134 @@  discard block
 block discarded – undo
12 12
  */
13 13
 class ObjectBeanPropertyDescriptor extends AbstractBeanPropertyDescriptor
14 14
 {
15
-    /**
16
-     * @var ForeignKeyConstraint
17
-     */
18
-    private $foreignKey;
19
-
20
-    /**
21
-     * @var SchemaAnalyzer
22
-     */
23
-    private $schemaAnalyzer;
24
-
25
-    public function __construct(Table $table, ForeignKeyConstraint $foreignKey, SchemaAnalyzer $schemaAnalyzer)
26
-    {
27
-        parent::__construct($table);
28
-        $this->foreignKey = $foreignKey;
29
-        $this->schemaAnalyzer = $schemaAnalyzer;
30
-    }
31
-
32
-    /**
33
-     * Returns the foreignkey the column is part of, if any. null otherwise.
34
-     *
35
-     * @return ForeignKeyConstraint|null
36
-     */
37
-    public function getForeignKey()
38
-    {
39
-        return $this->foreignKey;
40
-    }
41
-
42
-    /**
43
-     * Returns the name of the class linked to this property or null if this is not a foreign key.
44
-     *
45
-     * @return null|string
46
-     */
47
-    public function getClassName()
48
-    {
49
-        return TDBMDaoGenerator::getBeanNameFromTableName($this->foreignKey->getForeignTableName());
50
-    }
51
-
52
-    /**
53
-     * Returns the param annotation for this property (useful for constructor).
54
-     *
55
-     * @return string
56
-     */
57
-    public function getParamAnnotation()
58
-    {
59
-        $str = '     * @param %s %s';
60
-
61
-        return sprintf($str, $this->getClassName(), $this->getVariableName());
62
-    }
63
-
64
-    public function getUpperCamelCaseName()
65
-    {
66
-        // First, are there many column or only one?
67
-        // If one column, we name the setter after it. Otherwise, we name the setter after the table name
68
-        if (count($this->foreignKey->getLocalColumns()) > 1) {
69
-            $name = TDBMDaoGenerator::toSingular(TDBMDaoGenerator::toCamelCase($this->foreignKey->getForeignTableName()));
70
-            if ($this->alternativeName) {
71
-                $camelizedColumns = array_map(['Mouf\\Database\\TDBM\\Utils\\TDBMDaoGenerator', 'toCamelCase'], $this->foreignKey->getLocalColumns());
72
-
73
-                $name .= 'By'.implode('And', $camelizedColumns);
74
-            }
75
-        } else {
76
-            $column = $this->foreignKey->getLocalColumns()[0];
77
-            // Let's remove any _id or id_.
78
-            if (strpos(strtolower($column), 'id_') === 0) {
79
-                $column = substr($column, 3);
80
-            }
81
-            if (strrpos(strtolower($column), '_id') === strlen($column) - 3) {
82
-                $column = substr($column, 0, strlen($column) - 3);
83
-            }
84
-            $name = TDBMDaoGenerator::toCamelCase($column);
85
-            if ($this->alternativeName) {
86
-                $name .= 'Object';
87
-            }
88
-        }
89
-
90
-        return $name;
91
-    }
92
-
93
-    /**
94
-     * Returns true if the property is compulsory (and therefore should be fetched in the constructor).
95
-     *
96
-     * @return bool
97
-     */
98
-    public function isCompulsory()
99
-    {
100
-        // Are all columns nullable?
101
-        $localColumnNames = $this->foreignKey->getLocalColumns();
102
-
103
-        foreach ($localColumnNames as $name) {
104
-            $column = $this->table->getColumn($name);
105
-            if ($column->getNotnull()) {
106
-                return true;
107
-            }
108
-        }
109
-
110
-        return false;
111
-    }
112
-
113
-    /**
114
-     * Returns true if the property is the primary key.
115
-     *
116
-     * @return bool
117
-     */
118
-    public function isPrimaryKey()
119
-    {
120
-        $fkColumns = $this->foreignKey->getLocalColumns();
121
-        sort($fkColumns);
122
-
123
-        $pkColumns = $this->table->getPrimaryKeyColumns();
124
-        sort($pkColumns);
125
-
126
-        return $fkColumns == $pkColumns;
127
-    }
128
-
129
-    /**
130
-     * Returns the PHP code for getters and setters.
131
-     *
132
-     * @return string
133
-     */
134
-    public function getGetterSetterCode()
135
-    {
136
-        $tableName = $this->table->getName();
137
-        $getterName = $this->getGetterName();
138
-        $setterName = $this->getSetterName();
139
-
140
-        $referencedBeanName = TDBMDaoGenerator::getBeanNameFromTableName($this->foreignKey->getForeignTableName());
141
-
142
-        $str = '    /**
15
+	/**
16
+	 * @var ForeignKeyConstraint
17
+	 */
18
+	private $foreignKey;
19
+
20
+	/**
21
+	 * @var SchemaAnalyzer
22
+	 */
23
+	private $schemaAnalyzer;
24
+
25
+	public function __construct(Table $table, ForeignKeyConstraint $foreignKey, SchemaAnalyzer $schemaAnalyzer)
26
+	{
27
+		parent::__construct($table);
28
+		$this->foreignKey = $foreignKey;
29
+		$this->schemaAnalyzer = $schemaAnalyzer;
30
+	}
31
+
32
+	/**
33
+	 * Returns the foreignkey the column is part of, if any. null otherwise.
34
+	 *
35
+	 * @return ForeignKeyConstraint|null
36
+	 */
37
+	public function getForeignKey()
38
+	{
39
+		return $this->foreignKey;
40
+	}
41
+
42
+	/**
43
+	 * Returns the name of the class linked to this property or null if this is not a foreign key.
44
+	 *
45
+	 * @return null|string
46
+	 */
47
+	public function getClassName()
48
+	{
49
+		return TDBMDaoGenerator::getBeanNameFromTableName($this->foreignKey->getForeignTableName());
50
+	}
51
+
52
+	/**
53
+	 * Returns the param annotation for this property (useful for constructor).
54
+	 *
55
+	 * @return string
56
+	 */
57
+	public function getParamAnnotation()
58
+	{
59
+		$str = '     * @param %s %s';
60
+
61
+		return sprintf($str, $this->getClassName(), $this->getVariableName());
62
+	}
63
+
64
+	public function getUpperCamelCaseName()
65
+	{
66
+		// First, are there many column or only one?
67
+		// If one column, we name the setter after it. Otherwise, we name the setter after the table name
68
+		if (count($this->foreignKey->getLocalColumns()) > 1) {
69
+			$name = TDBMDaoGenerator::toSingular(TDBMDaoGenerator::toCamelCase($this->foreignKey->getForeignTableName()));
70
+			if ($this->alternativeName) {
71
+				$camelizedColumns = array_map(['Mouf\\Database\\TDBM\\Utils\\TDBMDaoGenerator', 'toCamelCase'], $this->foreignKey->getLocalColumns());
72
+
73
+				$name .= 'By'.implode('And', $camelizedColumns);
74
+			}
75
+		} else {
76
+			$column = $this->foreignKey->getLocalColumns()[0];
77
+			// Let's remove any _id or id_.
78
+			if (strpos(strtolower($column), 'id_') === 0) {
79
+				$column = substr($column, 3);
80
+			}
81
+			if (strrpos(strtolower($column), '_id') === strlen($column) - 3) {
82
+				$column = substr($column, 0, strlen($column) - 3);
83
+			}
84
+			$name = TDBMDaoGenerator::toCamelCase($column);
85
+			if ($this->alternativeName) {
86
+				$name .= 'Object';
87
+			}
88
+		}
89
+
90
+		return $name;
91
+	}
92
+
93
+	/**
94
+	 * Returns true if the property is compulsory (and therefore should be fetched in the constructor).
95
+	 *
96
+	 * @return bool
97
+	 */
98
+	public function isCompulsory()
99
+	{
100
+		// Are all columns nullable?
101
+		$localColumnNames = $this->foreignKey->getLocalColumns();
102
+
103
+		foreach ($localColumnNames as $name) {
104
+			$column = $this->table->getColumn($name);
105
+			if ($column->getNotnull()) {
106
+				return true;
107
+			}
108
+		}
109
+
110
+		return false;
111
+	}
112
+
113
+	/**
114
+	 * Returns true if the property is the primary key.
115
+	 *
116
+	 * @return bool
117
+	 */
118
+	public function isPrimaryKey()
119
+	{
120
+		$fkColumns = $this->foreignKey->getLocalColumns();
121
+		sort($fkColumns);
122
+
123
+		$pkColumns = $this->table->getPrimaryKeyColumns();
124
+		sort($pkColumns);
125
+
126
+		return $fkColumns == $pkColumns;
127
+	}
128
+
129
+	/**
130
+	 * Returns the PHP code for getters and setters.
131
+	 *
132
+	 * @return string
133
+	 */
134
+	public function getGetterSetterCode()
135
+	{
136
+		$tableName = $this->table->getName();
137
+		$getterName = $this->getGetterName();
138
+		$setterName = $this->getSetterName();
139
+
140
+		$referencedBeanName = TDBMDaoGenerator::getBeanNameFromTableName($this->foreignKey->getForeignTableName());
141
+
142
+		$str = '    /**
143 143
      * Returns the '.$referencedBeanName.' object bound to this object via the '.implode(' and ', $this->foreignKey->getLocalColumns()).' column.
144 144
      *
145 145
      * @return '.$referencedBeanName.'
@@ -159,19 +159,19 @@  discard block
 block discarded – undo
159 159
 
160 160
 ';
161 161
 
162
-        return $str;
163
-    }
164
-
165
-    /**
166
-     * Returns the part of code useful when doing json serialization.
167
-     *
168
-     * @return string
169
-     */
170
-    public function getJsonSerializeCode()
171
-    {
172
-        return '        if (!$stopRecursion) {
162
+		return $str;
163
+	}
164
+
165
+	/**
166
+	 * Returns the part of code useful when doing json serialization.
167
+	 *
168
+	 * @return string
169
+	 */
170
+	public function getJsonSerializeCode()
171
+	{
172
+		return '        if (!$stopRecursion) {
173 173
             $array['.var_export($this->getLowerCamelCaseName(), true).'] = $this->'.$this->getGetterName().'()->jsonSerialize(true);
174 174
         }
175 175
 ';
176
-    }
176
+	}
177 177
 }
Please login to merge, or discard this patch.
Spacing   +3 added lines, -3 removed lines patch added patch discarded remove patch
@@ -65,7 +65,7 @@  discard block
 block discarded – undo
65 65
     {
66 66
         // First, are there many column or only one?
67 67
         // If one column, we name the setter after it. Otherwise, we name the setter after the table name
68
-        if (count($this->foreignKey->getLocalColumns()) > 1) {
68
+        if (count($this->foreignKey->getLocalColumns())>1) {
69 69
             $name = TDBMDaoGenerator::toSingular(TDBMDaoGenerator::toCamelCase($this->foreignKey->getForeignTableName()));
70 70
             if ($this->alternativeName) {
71 71
                 $camelizedColumns = array_map(['Mouf\\Database\\TDBM\\Utils\\TDBMDaoGenerator', 'toCamelCase'], $this->foreignKey->getLocalColumns());
@@ -78,8 +78,8 @@  discard block
 block discarded – undo
78 78
             if (strpos(strtolower($column), 'id_') === 0) {
79 79
                 $column = substr($column, 3);
80 80
             }
81
-            if (strrpos(strtolower($column), '_id') === strlen($column) - 3) {
82
-                $column = substr($column, 0, strlen($column) - 3);
81
+            if (strrpos(strtolower($column), '_id') === strlen($column)-3) {
82
+                $column = substr($column, 0, strlen($column)-3);
83 83
             }
84 84
             $name = TDBMDaoGenerator::toCamelCase($column);
85 85
             if ($this->alternativeName) {
Please login to merge, or discard this patch.
src/Mouf/Database/TDBM/InnerResultArray.php 2 patches
Indentation   +89 added lines, -89 removed lines patch added patch discarded remove patch
@@ -27,100 +27,100 @@
 block discarded – undo
27 27
  */
28 28
 class InnerResultArray extends InnerResultIterator
29 29
 {
30
-    /**
31
-     * The list of results already fetched.
32
-     *
33
-     * @var AbstractTDBMObject[]
34
-     */
35
-    private $results = [];
30
+	/**
31
+	 * The list of results already fetched.
32
+	 *
33
+	 * @var AbstractTDBMObject[]
34
+	 */
35
+	private $results = [];
36 36
 
37
-    /**
38
-     * Whether a offset exists.
39
-     *
40
-     * @link http://php.net/manual/en/arrayaccess.offsetexists.php
41
-     *
42
-     * @param mixed $offset <p>
43
-     *                      An offset to check for.
44
-     *                      </p>
45
-     *
46
-     * @return bool true on success or false on failure.
47
-     *              </p>
48
-     *              <p>
49
-     *              The return value will be casted to boolean if non-boolean was returned.
50
-     *
51
-     * @since 5.0.0
52
-     */
53
-    public function offsetExists($offset)
54
-    {
55
-        try {
56
-            $this->toIndex($offset);
57
-        } catch (TDBMInvalidOffsetException $e) {
58
-            return false;
59
-        }
37
+	/**
38
+	 * Whether a offset exists.
39
+	 *
40
+	 * @link http://php.net/manual/en/arrayaccess.offsetexists.php
41
+	 *
42
+	 * @param mixed $offset <p>
43
+	 *                      An offset to check for.
44
+	 *                      </p>
45
+	 *
46
+	 * @return bool true on success or false on failure.
47
+	 *              </p>
48
+	 *              <p>
49
+	 *              The return value will be casted to boolean if non-boolean was returned.
50
+	 *
51
+	 * @since 5.0.0
52
+	 */
53
+	public function offsetExists($offset)
54
+	{
55
+		try {
56
+			$this->toIndex($offset);
57
+		} catch (TDBMInvalidOffsetException $e) {
58
+			return false;
59
+		}
60 60
 
61
-        return true;
62
-    }
61
+		return true;
62
+	}
63 63
 
64
-    /**
65
-     * Offset to retrieve.
66
-     *
67
-     * @link http://php.net/manual/en/arrayaccess.offsetget.php
68
-     *
69
-     * @param mixed $offset <p>
70
-     *                      The offset to retrieve.
71
-     *                      </p>
72
-     *
73
-     * @return mixed Can return all value types.
74
-     *
75
-     * @since 5.0.0
76
-     */
77
-    public function offsetGet($offset)
78
-    {
79
-        $this->toIndex($offset);
64
+	/**
65
+	 * Offset to retrieve.
66
+	 *
67
+	 * @link http://php.net/manual/en/arrayaccess.offsetget.php
68
+	 *
69
+	 * @param mixed $offset <p>
70
+	 *                      The offset to retrieve.
71
+	 *                      </p>
72
+	 *
73
+	 * @return mixed Can return all value types.
74
+	 *
75
+	 * @since 5.0.0
76
+	 */
77
+	public function offsetGet($offset)
78
+	{
79
+		$this->toIndex($offset);
80 80
 
81
-        return $this->results[$offset];
82
-    }
81
+		return $this->results[$offset];
82
+	}
83 83
 
84
-    private function toIndex($offset)
85
-    {
86
-        if ($offset < 0 || filter_var($offset, FILTER_VALIDATE_INT) === false) {
87
-            throw new TDBMInvalidOffsetException('Trying to access result set using offset "'.$offset.'". An offset must be a positive integer.');
88
-        }
89
-        if ($this->statement === null) {
90
-            $this->executeQuery();
91
-        }
92
-        while (!isset($this->results[$offset])) {
93
-            $this->next();
94
-            if ($this->current === null) {
95
-                throw new TDBMInvalidOffsetException('Offset "'.$offset.'" does not exist in result set.');
96
-            }
97
-        }
98
-    }
84
+	private function toIndex($offset)
85
+	{
86
+		if ($offset < 0 || filter_var($offset, FILTER_VALIDATE_INT) === false) {
87
+			throw new TDBMInvalidOffsetException('Trying to access result set using offset "'.$offset.'". An offset must be a positive integer.');
88
+		}
89
+		if ($this->statement === null) {
90
+			$this->executeQuery();
91
+		}
92
+		while (!isset($this->results[$offset])) {
93
+			$this->next();
94
+			if ($this->current === null) {
95
+				throw new TDBMInvalidOffsetException('Offset "'.$offset.'" does not exist in result set.');
96
+			}
97
+		}
98
+	}
99 99
 
100
-    public function next()
101
-    {
102
-        // Let's overload the next() method to store the result.
103
-        if (isset($this->results[$this->key + 1])) {
104
-            ++$this->key;
105
-            $this->current = $this->results[$this->key];
106
-        } else {
107
-            parent::next();
108
-            if ($this->current !== null) {
109
-                $this->results[$this->key] = $this->current;
110
-            }
111
-        }
112
-    }
100
+	public function next()
101
+	{
102
+		// Let's overload the next() method to store the result.
103
+		if (isset($this->results[$this->key + 1])) {
104
+			++$this->key;
105
+			$this->current = $this->results[$this->key];
106
+		} else {
107
+			parent::next();
108
+			if ($this->current !== null) {
109
+				$this->results[$this->key] = $this->current;
110
+			}
111
+		}
112
+	}
113 113
 
114
-    /**
115
-     * Overloads the rewind implementation.
116
-     * Do not reexecute the query.
117
-     */
118
-    public function rewind()
119
-    {
120
-        if (!$this->fetchStarted) {
121
-            $this->executeQuery();
122
-        }
123
-        $this->key = -1;
124
-        $this->next();
125
-    }
114
+	/**
115
+	 * Overloads the rewind implementation.
116
+	 * Do not reexecute the query.
117
+	 */
118
+	public function rewind()
119
+	{
120
+		if (!$this->fetchStarted) {
121
+			$this->executeQuery();
122
+		}
123
+		$this->key = -1;
124
+		$this->next();
125
+	}
126 126
 }
Please login to merge, or discard this patch.
Spacing   +2 added lines, -2 removed lines patch added patch discarded remove patch
@@ -83,7 +83,7 @@  discard block
 block discarded – undo
83 83
 
84 84
     private function toIndex($offset)
85 85
     {
86
-        if ($offset < 0 || filter_var($offset, FILTER_VALIDATE_INT) === false) {
86
+        if ($offset<0 || filter_var($offset, FILTER_VALIDATE_INT) === false) {
87 87
             throw new TDBMInvalidOffsetException('Trying to access result set using offset "'.$offset.'". An offset must be a positive integer.');
88 88
         }
89 89
         if ($this->statement === null) {
@@ -100,7 +100,7 @@  discard block
 block discarded – undo
100 100
     public function next()
101 101
     {
102 102
         // Let's overload the next() method to store the result.
103
-        if (isset($this->results[$this->key + 1])) {
103
+        if (isset($this->results[$this->key+1])) {
104 104
             ++$this->key;
105 105
             $this->current = $this->results[$this->key];
106 106
         } else {
Please login to merge, or discard this patch.
src/Mouf/Database/TDBM/TDBMObjectStateEnum.php 1 patch
Indentation   +6 added lines, -6 removed lines patch added patch discarded remove patch
@@ -27,10 +27,10 @@
 block discarded – undo
27 27
  */
28 28
 final class TDBMObjectStateEnum extends AbstractTDBMObject
29 29
 {
30
-    const STATE_DETACHED = 'detached';
31
-    const STATE_NEW = 'new';
32
-    const STATE_NOT_LOADED = 'not loaded';
33
-    const STATE_LOADED = 'loaded';
34
-    const STATE_DIRTY = 'dirty';
35
-    const STATE_DELETED = 'deleted';
30
+	const STATE_DETACHED = 'detached';
31
+	const STATE_NEW = 'new';
32
+	const STATE_NOT_LOADED = 'not loaded';
33
+	const STATE_LOADED = 'loaded';
34
+	const STATE_DIRTY = 'dirty';
35
+	const STATE_DELETED = 'deleted';
36 36
 }
Please login to merge, or discard this patch.
src/Mouf/Database/TDBM/DbRow.php 2 patches
Spacing   +1 added lines, -1 removed lines patch added patch discarded remove patch
@@ -353,7 +353,7 @@
 block discarded – undo
353 353
             $pkValues = array_values($firstRefDbRow->_getPrimaryKeys());
354 354
             $localColumns = $fk->getLocalColumns();
355 355
 
356
-            for ($i = 0, $count = count($localColumns); $i < $count; ++$i) {
356
+            for ($i = 0, $count = count($localColumns); $i<$count; ++$i) {
357 357
                 $dbRow[$localColumns[$i]] = $pkValues[$i];
358 358
             }
359 359
         }
Please login to merge, or discard this patch.
Indentation   +343 added lines, -343 removed lines patch added patch discarded remove patch
@@ -27,163 +27,163 @@  discard block
 block discarded – undo
27 27
  */
28 28
 class DbRow
29 29
 {
30
-    /**
31
-     * The service this object is bound to.
32
-     *
33
-     * @var TDBMService
34
-     */
35
-    protected $tdbmService;
36
-
37
-    /**
38
-     * The object containing this db row.
39
-     *
40
-     * @var AbstractTDBMObject
41
-     */
42
-    private $object;
43
-
44
-    /**
45
-     * The name of the table the object if issued from.
46
-     *
47
-     * @var string
48
-     */
49
-    private $dbTableName;
50
-
51
-    /**
52
-     * The array of columns returned from database.
53
-     *
54
-     * @var array
55
-     */
56
-    private $dbRow = array();
57
-
58
-    /**
59
-     * @var AbstractTDBMObject[]
60
-     */
61
-    private $references = array();
62
-
63
-    /**
64
-     * One of TDBMObjectStateEnum::STATE_NEW, TDBMObjectStateEnum::STATE_NOT_LOADED, TDBMObjectStateEnum::STATE_LOADED, TDBMObjectStateEnum::STATE_DELETED.
65
-     * $status = TDBMObjectStateEnum::STATE_NEW when a new object is created with DBMObject:getNewObject.
66
-     * $status = TDBMObjectStateEnum::STATE_NOT_LOADED when the object has been retrieved with getObject but when no data has been accessed in it yet.
67
-     * $status = TDBMObjectStateEnum::STATE_LOADED when the object is cached in memory.
68
-     *
69
-     * @var string
70
-     */
71
-    private $status;
72
-
73
-    /**
74
-     * The values of the primary key.
75
-     * This is set when the object is in "loaded" state.
76
-     *
77
-     * @var array An array of column => value
78
-     */
79
-    private $primaryKeys;
80
-
81
-    /**
82
-     * You should never call the constructor directly. Instead, you should use the
83
-     * TDBMService class that will create TDBMObjects for you.
84
-     *
85
-     * Used with id!=false when we want to retrieve an existing object
86
-     * and id==false if we want a new object
87
-     *
88
-     * @param AbstractTDBMObject $object      The object containing this db row.
89
-     * @param string             $table_name
90
-     * @param array              $primaryKeys
91
-     * @param TDBMService        $tdbmService
92
-     *
93
-     * @throws TDBMException
94
-     * @throws TDBMInvalidOperationException
95
-     */
96
-    public function __construct(AbstractTDBMObject $object, $table_name, array $primaryKeys = array(), TDBMService $tdbmService = null, array $dbRow = array())
97
-    {
98
-        $this->object = $object;
99
-        $this->dbTableName = $table_name;
100
-
101
-        $this->status = TDBMObjectStateEnum::STATE_DETACHED;
102
-
103
-        if ($tdbmService === null) {
104
-            if (!empty($primaryKeys)) {
105
-                throw new TDBMException('You cannot pass an id to the DbRow constructor without passing also a TDBMService.');
106
-            }
107
-        } else {
108
-            $this->tdbmService = $tdbmService;
109
-
110
-            if (!empty($primaryKeys)) {
111
-                $this->_setPrimaryKeys($primaryKeys);
112
-                if (!empty($dbRow)) {
113
-                    $this->dbRow = $dbRow;
114
-                    $this->status = TDBMObjectStateEnum::STATE_LOADED;
115
-                } else {
116
-                    $this->status = TDBMObjectStateEnum::STATE_NOT_LOADED;
117
-                }
118
-                $tdbmService->_addToCache($this);
119
-            } else {
120
-                $this->status = TDBMObjectStateEnum::STATE_NEW;
121
-                $this->tdbmService->_addToToSaveObjectList($this);
122
-            }
123
-        }
124
-    }
125
-
126
-    public function _attach(TDBMService $tdbmService)
127
-    {
128
-        if ($this->status !== TDBMObjectStateEnum::STATE_DETACHED) {
129
-            throw new TDBMInvalidOperationException('Cannot attach an object that is already attached to TDBM.');
130
-        }
131
-        $this->tdbmService = $tdbmService;
132
-        $this->status = TDBMObjectStateEnum::STATE_NEW;
133
-        $this->tdbmService->_addToToSaveObjectList($this);
134
-    }
135
-
136
-    /**
137
-     * Sets the state of the TDBM Object
138
-     * One of TDBMObjectStateEnum::STATE_NEW, TDBMObjectStateEnum::STATE_NOT_LOADED, TDBMObjectStateEnum::STATE_LOADED, TDBMObjectStateEnum::STATE_DELETED.
139
-     * $status = TDBMObjectStateEnum::STATE_NEW when a new object is created with DBMObject:getNewObject.
140
-     * $status = TDBMObjectStateEnum::STATE_NOT_LOADED when the object has been retrieved with getObject but when no data has been accessed in it yet.
141
-     * $status = TDBMObjectStateEnum::STATE_LOADED when the object is cached in memory.
142
-     *
143
-     * @param string $state
144
-     */
145
-    public function _setStatus($state)
146
-    {
147
-        $this->status = $state;
148
-    }
149
-
150
-    /**
151
-     * This is an internal method. You should not call this method yourself. The TDBM library will do it for you.
152
-     * If the object is in state 'not loaded', this method performs a query in database to load the object.
153
-     *
154
-     * A TDBMException is thrown is no object can be retrieved (for instance, if the primary key specified
155
-     * cannot be found).
156
-     */
157
-    public function _dbLoadIfNotLoaded()
158
-    {
159
-        if ($this->status == TDBMObjectStateEnum::STATE_NOT_LOADED) {
160
-            $connection = $this->tdbmService->getConnection();
161
-
162
-            /// buildFilterFromFilterBag($filter_bag)
163
-            list($sql_where, $parameters) = $this->tdbmService->buildFilterFromFilterBag($this->primaryKeys);
164
-
165
-            $sql = 'SELECT * FROM '.$connection->quoteIdentifier($this->dbTableName).' WHERE '.$sql_where;
166
-            $result = $connection->executeQuery($sql, $parameters);
167
-
168
-            if ($result->rowCount() === 0) {
169
-                throw new TDBMException("Could not retrieve object from table \"$this->dbTableName\" using filter \"\".");
170
-            }
171
-
172
-            $this->dbRow = $result->fetch(\PDO::FETCH_ASSOC);
173
-
174
-            $result->closeCursor();
175
-
176
-            $this->status = TDBMObjectStateEnum::STATE_LOADED;
177
-        }
178
-    }
179
-
180
-    public function get($var)
181
-    {
182
-        $this->_dbLoadIfNotLoaded();
183
-
184
-        // Let's first check if the key exist.
185
-        if (!isset($this->dbRow[$var])) {
186
-            /*
30
+	/**
31
+	 * The service this object is bound to.
32
+	 *
33
+	 * @var TDBMService
34
+	 */
35
+	protected $tdbmService;
36
+
37
+	/**
38
+	 * The object containing this db row.
39
+	 *
40
+	 * @var AbstractTDBMObject
41
+	 */
42
+	private $object;
43
+
44
+	/**
45
+	 * The name of the table the object if issued from.
46
+	 *
47
+	 * @var string
48
+	 */
49
+	private $dbTableName;
50
+
51
+	/**
52
+	 * The array of columns returned from database.
53
+	 *
54
+	 * @var array
55
+	 */
56
+	private $dbRow = array();
57
+
58
+	/**
59
+	 * @var AbstractTDBMObject[]
60
+	 */
61
+	private $references = array();
62
+
63
+	/**
64
+	 * One of TDBMObjectStateEnum::STATE_NEW, TDBMObjectStateEnum::STATE_NOT_LOADED, TDBMObjectStateEnum::STATE_LOADED, TDBMObjectStateEnum::STATE_DELETED.
65
+	 * $status = TDBMObjectStateEnum::STATE_NEW when a new object is created with DBMObject:getNewObject.
66
+	 * $status = TDBMObjectStateEnum::STATE_NOT_LOADED when the object has been retrieved with getObject but when no data has been accessed in it yet.
67
+	 * $status = TDBMObjectStateEnum::STATE_LOADED when the object is cached in memory.
68
+	 *
69
+	 * @var string
70
+	 */
71
+	private $status;
72
+
73
+	/**
74
+	 * The values of the primary key.
75
+	 * This is set when the object is in "loaded" state.
76
+	 *
77
+	 * @var array An array of column => value
78
+	 */
79
+	private $primaryKeys;
80
+
81
+	/**
82
+	 * You should never call the constructor directly. Instead, you should use the
83
+	 * TDBMService class that will create TDBMObjects for you.
84
+	 *
85
+	 * Used with id!=false when we want to retrieve an existing object
86
+	 * and id==false if we want a new object
87
+	 *
88
+	 * @param AbstractTDBMObject $object      The object containing this db row.
89
+	 * @param string             $table_name
90
+	 * @param array              $primaryKeys
91
+	 * @param TDBMService        $tdbmService
92
+	 *
93
+	 * @throws TDBMException
94
+	 * @throws TDBMInvalidOperationException
95
+	 */
96
+	public function __construct(AbstractTDBMObject $object, $table_name, array $primaryKeys = array(), TDBMService $tdbmService = null, array $dbRow = array())
97
+	{
98
+		$this->object = $object;
99
+		$this->dbTableName = $table_name;
100
+
101
+		$this->status = TDBMObjectStateEnum::STATE_DETACHED;
102
+
103
+		if ($tdbmService === null) {
104
+			if (!empty($primaryKeys)) {
105
+				throw new TDBMException('You cannot pass an id to the DbRow constructor without passing also a TDBMService.');
106
+			}
107
+		} else {
108
+			$this->tdbmService = $tdbmService;
109
+
110
+			if (!empty($primaryKeys)) {
111
+				$this->_setPrimaryKeys($primaryKeys);
112
+				if (!empty($dbRow)) {
113
+					$this->dbRow = $dbRow;
114
+					$this->status = TDBMObjectStateEnum::STATE_LOADED;
115
+				} else {
116
+					$this->status = TDBMObjectStateEnum::STATE_NOT_LOADED;
117
+				}
118
+				$tdbmService->_addToCache($this);
119
+			} else {
120
+				$this->status = TDBMObjectStateEnum::STATE_NEW;
121
+				$this->tdbmService->_addToToSaveObjectList($this);
122
+			}
123
+		}
124
+	}
125
+
126
+	public function _attach(TDBMService $tdbmService)
127
+	{
128
+		if ($this->status !== TDBMObjectStateEnum::STATE_DETACHED) {
129
+			throw new TDBMInvalidOperationException('Cannot attach an object that is already attached to TDBM.');
130
+		}
131
+		$this->tdbmService = $tdbmService;
132
+		$this->status = TDBMObjectStateEnum::STATE_NEW;
133
+		$this->tdbmService->_addToToSaveObjectList($this);
134
+	}
135
+
136
+	/**
137
+	 * Sets the state of the TDBM Object
138
+	 * One of TDBMObjectStateEnum::STATE_NEW, TDBMObjectStateEnum::STATE_NOT_LOADED, TDBMObjectStateEnum::STATE_LOADED, TDBMObjectStateEnum::STATE_DELETED.
139
+	 * $status = TDBMObjectStateEnum::STATE_NEW when a new object is created with DBMObject:getNewObject.
140
+	 * $status = TDBMObjectStateEnum::STATE_NOT_LOADED when the object has been retrieved with getObject but when no data has been accessed in it yet.
141
+	 * $status = TDBMObjectStateEnum::STATE_LOADED when the object is cached in memory.
142
+	 *
143
+	 * @param string $state
144
+	 */
145
+	public function _setStatus($state)
146
+	{
147
+		$this->status = $state;
148
+	}
149
+
150
+	/**
151
+	 * This is an internal method. You should not call this method yourself. The TDBM library will do it for you.
152
+	 * If the object is in state 'not loaded', this method performs a query in database to load the object.
153
+	 *
154
+	 * A TDBMException is thrown is no object can be retrieved (for instance, if the primary key specified
155
+	 * cannot be found).
156
+	 */
157
+	public function _dbLoadIfNotLoaded()
158
+	{
159
+		if ($this->status == TDBMObjectStateEnum::STATE_NOT_LOADED) {
160
+			$connection = $this->tdbmService->getConnection();
161
+
162
+			/// buildFilterFromFilterBag($filter_bag)
163
+			list($sql_where, $parameters) = $this->tdbmService->buildFilterFromFilterBag($this->primaryKeys);
164
+
165
+			$sql = 'SELECT * FROM '.$connection->quoteIdentifier($this->dbTableName).' WHERE '.$sql_where;
166
+			$result = $connection->executeQuery($sql, $parameters);
167
+
168
+			if ($result->rowCount() === 0) {
169
+				throw new TDBMException("Could not retrieve object from table \"$this->dbTableName\" using filter \"\".");
170
+			}
171
+
172
+			$this->dbRow = $result->fetch(\PDO::FETCH_ASSOC);
173
+
174
+			$result->closeCursor();
175
+
176
+			$this->status = TDBMObjectStateEnum::STATE_LOADED;
177
+		}
178
+	}
179
+
180
+	public function get($var)
181
+	{
182
+		$this->_dbLoadIfNotLoaded();
183
+
184
+		// Let's first check if the key exist.
185
+		if (!isset($this->dbRow[$var])) {
186
+			/*
187 187
             // Unable to find column.... this is an error if the object has been retrieved from database.
188 188
             // If it's a new object, well, that may not be an error after all!
189 189
             // Let's check if the column does exist in the table
@@ -203,30 +203,30 @@  discard block
 block discarded – undo
203 203
             $str = "Could not find column \"$var\" in table \"$this->dbTableName\". Maybe you meant one of those columns: '".implode("', '",$result_array)."'";
204 204
 
205 205
             throw new TDBMException($str);*/
206
-            return;
207
-        }
208
-
209
-        return $this->dbRow[$var];
210
-    }
211
-
212
-    /**
213
-     * Returns true if a column is set, false otherwise.
214
-     *
215
-     * @param string $var
216
-     *
217
-     * @return bool
218
-     */
219
-    /*public function has($var) {
206
+			return;
207
+		}
208
+
209
+		return $this->dbRow[$var];
210
+	}
211
+
212
+	/**
213
+	 * Returns true if a column is set, false otherwise.
214
+	 *
215
+	 * @param string $var
216
+	 *
217
+	 * @return bool
218
+	 */
219
+	/*public function has($var) {
220 220
         $this->_dbLoadIfNotLoaded();
221 221
 
222 222
         return isset($this->dbRow[$var]);
223 223
     }*/
224 224
 
225
-    public function set($var, $value)
226
-    {
227
-        $this->_dbLoadIfNotLoaded();
225
+	public function set($var, $value)
226
+	{
227
+		$this->_dbLoadIfNotLoaded();
228 228
 
229
-        /*
229
+		/*
230 230
         // Ok, let's start by checking the column type
231 231
         $type = $this->db_connection->getColumnType($this->dbTableName, $var);
232 232
 
@@ -236,173 +236,173 @@  discard block
 block discarded – undo
236 236
         }
237 237
         */
238 238
 
239
-        /*if ($var == $this->getPrimaryKey() && isset($this->dbRow[$var]))
239
+		/*if ($var == $this->getPrimaryKey() && isset($this->dbRow[$var]))
240 240
             throw new TDBMException("Error! Changing primary key value is forbidden.");*/
241
-        $this->dbRow[$var] = $value;
242
-        if ($this->tdbmService !== null && $this->status === TDBMObjectStateEnum::STATE_LOADED) {
243
-            $this->status = TDBMObjectStateEnum::STATE_DIRTY;
244
-            $this->tdbmService->_addToToSaveObjectList($this);
245
-        }
246
-    }
247
-
248
-    /**
249
-     * @param string             $foreignKeyName
250
-     * @param AbstractTDBMObject $bean
251
-     */
252
-    public function setRef($foreignKeyName, AbstractTDBMObject $bean = null)
253
-    {
254
-        $this->references[$foreignKeyName] = $bean;
255
-
256
-        if ($this->tdbmService !== null && $this->status === TDBMObjectStateEnum::STATE_LOADED) {
257
-            $this->status = TDBMObjectStateEnum::STATE_DIRTY;
258
-            $this->tdbmService->_addToToSaveObjectList($this);
259
-        }
260
-    }
261
-
262
-    /**
263
-     * @param string $foreignKeyName A unique name for this reference
264
-     *
265
-     * @return AbstractTDBMObject|null
266
-     */
267
-    public function getRef($foreignKeyName)
268
-    {
269
-        if (isset($this->references[$foreignKeyName])) {
270
-            return $this->references[$foreignKeyName];
271
-        } elseif ($this->status === TDBMObjectStateEnum::STATE_NEW) {
272
-            // If the object is new and has no property, then it has to be empty.
273
-            return;
274
-        } else {
275
-            $this->_dbLoadIfNotLoaded();
276
-
277
-            // Let's match the name of the columns to the primary key values
278
-            $fk = $this->tdbmService->_getForeignKeyByName($this->dbTableName, $foreignKeyName);
279
-
280
-            $values = [];
281
-            foreach ($fk->getLocalColumns() as $column) {
282
-                $values[] = $this->dbRow[$column];
283
-            }
284
-
285
-            $filter = array_combine($this->tdbmService->getPrimaryKeyColumns($fk->getForeignTableName()), $values);
286
-
287
-            return $this->tdbmService->findObjectByPk($fk->getForeignTableName(), $filter, [], true);
288
-        }
289
-    }
290
-
291
-    /**
292
-     * Returns the name of the table this object comes from.
293
-     *
294
-     * @return string
295
-     */
296
-    public function _getDbTableName()
297
-    {
298
-        return $this->dbTableName;
299
-    }
300
-
301
-    /**
302
-     * Method used internally by TDBM. You should not use it directly.
303
-     * This method returns the status of the TDBMObject.
304
-     * This is one of TDBMObjectStateEnum::STATE_NEW, TDBMObjectStateEnum::STATE_NOT_LOADED, TDBMObjectStateEnum::STATE_LOADED, TDBMObjectStateEnum::STATE_DELETED.
305
-     * $status = TDBMObjectStateEnum::STATE_NEW when a new object is created with DBMObject:getNewObject.
306
-     * $status = TDBMObjectStateEnum::STATE_NOT_LOADED when the object has been retrieved with getObject but when no data has been accessed in it yet.
307
-     * $status = TDBMObjectStateEnum::STATE_LOADED when the object is cached in memory.
308
-     *
309
-     * @return string
310
-     */
311
-    public function _getStatus()
312
-    {
313
-        return $this->status;
314
-    }
315
-
316
-    /**
317
-     * Override the native php clone function for TDBMObjects.
318
-     */
319
-    public function __clone()
320
-    {
321
-        // Let's load the row (before we lose the ID!)
322
-        $this->_dbLoadIfNotLoaded();
323
-
324
-        //Let's set the status to detached
325
-        $this->status = TDBMObjectStateEnum::STATE_DETACHED;
326
-
327
-        $this->primaryKeys = [];
328
-
329
-        //Now unset the PK from the row
330
-        if ($this->tdbmService) {
331
-            $pk_array = $this->tdbmService->getPrimaryKeyColumns($this->dbTableName);
332
-            foreach ($pk_array as $pk) {
333
-                $this->dbRow[$pk] = null;
334
-            }
335
-        }
336
-    }
337
-
338
-    /**
339
-     * Returns raw database row.
340
-     *
341
-     * @return array
342
-     */
343
-    public function _getDbRow()
344
-    {
345
-        // Let's merge $dbRow and $references
346
-        $dbRow = $this->dbRow;
347
-
348
-        foreach ($this->references as $foreignKeyName => $reference) {
349
-            // Let's match the name of the columns to the primary key values
350
-            $fk = $this->tdbmService->_getForeignKeyByName($this->dbTableName, $foreignKeyName);
351
-            $refDbRows = $reference->_getDbRows();
352
-            $firstRefDbRow = reset($refDbRows);
353
-            $pkValues = array_values($firstRefDbRow->_getPrimaryKeys());
354
-            $localColumns = $fk->getLocalColumns();
355
-
356
-            for ($i = 0, $count = count($localColumns); $i < $count; ++$i) {
357
-                $dbRow[$localColumns[$i]] = $pkValues[$i];
358
-            }
359
-        }
360
-
361
-        return $dbRow;
362
-    }
363
-
364
-    /**
365
-     * Returns references array.
366
-     *
367
-     * @return AbstractTDBMObject[]
368
-     */
369
-    public function _getReferences()
370
-    {
371
-        return $this->references;
372
-    }
373
-
374
-    /**
375
-     * Returns the values of the primary key.
376
-     * This is set when the object is in "loaded" state.
377
-     *
378
-     * @return array
379
-     */
380
-    public function _getPrimaryKeys()
381
-    {
382
-        return $this->primaryKeys;
383
-    }
384
-
385
-    /**
386
-     * Sets the values of the primary key.
387
-     * This is set when the object is in "loaded" state.
388
-     *
389
-     * @param array $primaryKeys
390
-     */
391
-    public function _setPrimaryKeys(array $primaryKeys)
392
-    {
393
-        $this->primaryKeys = $primaryKeys;
394
-        foreach ($this->primaryKeys as $column => $value) {
395
-            $this->dbRow[$column] = $value;
396
-        }
397
-    }
398
-
399
-    /**
400
-     * Returns the TDBMObject this bean is associated to.
401
-     *
402
-     * @return AbstractTDBMObject
403
-     */
404
-    public function getTDBMObject()
405
-    {
406
-        return $this->object;
407
-    }
241
+		$this->dbRow[$var] = $value;
242
+		if ($this->tdbmService !== null && $this->status === TDBMObjectStateEnum::STATE_LOADED) {
243
+			$this->status = TDBMObjectStateEnum::STATE_DIRTY;
244
+			$this->tdbmService->_addToToSaveObjectList($this);
245
+		}
246
+	}
247
+
248
+	/**
249
+	 * @param string             $foreignKeyName
250
+	 * @param AbstractTDBMObject $bean
251
+	 */
252
+	public function setRef($foreignKeyName, AbstractTDBMObject $bean = null)
253
+	{
254
+		$this->references[$foreignKeyName] = $bean;
255
+
256
+		if ($this->tdbmService !== null && $this->status === TDBMObjectStateEnum::STATE_LOADED) {
257
+			$this->status = TDBMObjectStateEnum::STATE_DIRTY;
258
+			$this->tdbmService->_addToToSaveObjectList($this);
259
+		}
260
+	}
261
+
262
+	/**
263
+	 * @param string $foreignKeyName A unique name for this reference
264
+	 *
265
+	 * @return AbstractTDBMObject|null
266
+	 */
267
+	public function getRef($foreignKeyName)
268
+	{
269
+		if (isset($this->references[$foreignKeyName])) {
270
+			return $this->references[$foreignKeyName];
271
+		} elseif ($this->status === TDBMObjectStateEnum::STATE_NEW) {
272
+			// If the object is new and has no property, then it has to be empty.
273
+			return;
274
+		} else {
275
+			$this->_dbLoadIfNotLoaded();
276
+
277
+			// Let's match the name of the columns to the primary key values
278
+			$fk = $this->tdbmService->_getForeignKeyByName($this->dbTableName, $foreignKeyName);
279
+
280
+			$values = [];
281
+			foreach ($fk->getLocalColumns() as $column) {
282
+				$values[] = $this->dbRow[$column];
283
+			}
284
+
285
+			$filter = array_combine($this->tdbmService->getPrimaryKeyColumns($fk->getForeignTableName()), $values);
286
+
287
+			return $this->tdbmService->findObjectByPk($fk->getForeignTableName(), $filter, [], true);
288
+		}
289
+	}
290
+
291
+	/**
292
+	 * Returns the name of the table this object comes from.
293
+	 *
294
+	 * @return string
295
+	 */
296
+	public function _getDbTableName()
297
+	{
298
+		return $this->dbTableName;
299
+	}
300
+
301
+	/**
302
+	 * Method used internally by TDBM. You should not use it directly.
303
+	 * This method returns the status of the TDBMObject.
304
+	 * This is one of TDBMObjectStateEnum::STATE_NEW, TDBMObjectStateEnum::STATE_NOT_LOADED, TDBMObjectStateEnum::STATE_LOADED, TDBMObjectStateEnum::STATE_DELETED.
305
+	 * $status = TDBMObjectStateEnum::STATE_NEW when a new object is created with DBMObject:getNewObject.
306
+	 * $status = TDBMObjectStateEnum::STATE_NOT_LOADED when the object has been retrieved with getObject but when no data has been accessed in it yet.
307
+	 * $status = TDBMObjectStateEnum::STATE_LOADED when the object is cached in memory.
308
+	 *
309
+	 * @return string
310
+	 */
311
+	public function _getStatus()
312
+	{
313
+		return $this->status;
314
+	}
315
+
316
+	/**
317
+	 * Override the native php clone function for TDBMObjects.
318
+	 */
319
+	public function __clone()
320
+	{
321
+		// Let's load the row (before we lose the ID!)
322
+		$this->_dbLoadIfNotLoaded();
323
+
324
+		//Let's set the status to detached
325
+		$this->status = TDBMObjectStateEnum::STATE_DETACHED;
326
+
327
+		$this->primaryKeys = [];
328
+
329
+		//Now unset the PK from the row
330
+		if ($this->tdbmService) {
331
+			$pk_array = $this->tdbmService->getPrimaryKeyColumns($this->dbTableName);
332
+			foreach ($pk_array as $pk) {
333
+				$this->dbRow[$pk] = null;
334
+			}
335
+		}
336
+	}
337
+
338
+	/**
339
+	 * Returns raw database row.
340
+	 *
341
+	 * @return array
342
+	 */
343
+	public function _getDbRow()
344
+	{
345
+		// Let's merge $dbRow and $references
346
+		$dbRow = $this->dbRow;
347
+
348
+		foreach ($this->references as $foreignKeyName => $reference) {
349
+			// Let's match the name of the columns to the primary key values
350
+			$fk = $this->tdbmService->_getForeignKeyByName($this->dbTableName, $foreignKeyName);
351
+			$refDbRows = $reference->_getDbRows();
352
+			$firstRefDbRow = reset($refDbRows);
353
+			$pkValues = array_values($firstRefDbRow->_getPrimaryKeys());
354
+			$localColumns = $fk->getLocalColumns();
355
+
356
+			for ($i = 0, $count = count($localColumns); $i < $count; ++$i) {
357
+				$dbRow[$localColumns[$i]] = $pkValues[$i];
358
+			}
359
+		}
360
+
361
+		return $dbRow;
362
+	}
363
+
364
+	/**
365
+	 * Returns references array.
366
+	 *
367
+	 * @return AbstractTDBMObject[]
368
+	 */
369
+	public function _getReferences()
370
+	{
371
+		return $this->references;
372
+	}
373
+
374
+	/**
375
+	 * Returns the values of the primary key.
376
+	 * This is set when the object is in "loaded" state.
377
+	 *
378
+	 * @return array
379
+	 */
380
+	public function _getPrimaryKeys()
381
+	{
382
+		return $this->primaryKeys;
383
+	}
384
+
385
+	/**
386
+	 * Sets the values of the primary key.
387
+	 * This is set when the object is in "loaded" state.
388
+	 *
389
+	 * @param array $primaryKeys
390
+	 */
391
+	public function _setPrimaryKeys(array $primaryKeys)
392
+	{
393
+		$this->primaryKeys = $primaryKeys;
394
+		foreach ($this->primaryKeys as $column => $value) {
395
+			$this->dbRow[$column] = $value;
396
+		}
397
+	}
398
+
399
+	/**
400
+	 * Returns the TDBMObject this bean is associated to.
401
+	 *
402
+	 * @return AbstractTDBMObject
403
+	 */
404
+	public function getTDBMObject()
405
+	{
406
+		return $this->object;
407
+	}
408 408
 }
Please login to merge, or discard this patch.
src/Mouf/Database/TDBM/MapIterator.php 1 patch
Indentation   +71 added lines, -71 removed lines patch added patch discarded remove patch
@@ -9,86 +9,86 @@
 block discarded – undo
9 9
  */
10 10
 class MapIterator implements Iterator
11 11
 {
12
-    /**
13
-     * @var Iterator
14
-     */
15
-    protected $iterator;
12
+	/**
13
+	 * @var Iterator
14
+	 */
15
+	protected $iterator;
16 16
 
17
-    /**
18
-     * @var callable Modifies the current item in iterator
19
-     */
20
-    protected $callable;
17
+	/**
18
+	 * @var callable Modifies the current item in iterator
19
+	 */
20
+	protected $callable;
21 21
 
22
-    /**
23
-     * @param $iterator Iterator|array
24
-     * @param $callable callable This can have two parameters
25
-     *
26
-     * @throws TDBMException
27
-     */
28
-    public function __construct($iterator, callable $callable)
29
-    {
30
-        if (is_array($iterator)) {
31
-            $this->iterator = new \ArrayIterator($iterator);
32
-        } elseif (!($iterator instanceof Iterator)) {
33
-            throw new TDBMException("\$iterator parameter must be an instance of Iterator");
34
-        } else {
35
-            $this->iterator = $iterator;
36
-        }
22
+	/**
23
+	 * @param $iterator Iterator|array
24
+	 * @param $callable callable This can have two parameters
25
+	 *
26
+	 * @throws TDBMException
27
+	 */
28
+	public function __construct($iterator, callable $callable)
29
+	{
30
+		if (is_array($iterator)) {
31
+			$this->iterator = new \ArrayIterator($iterator);
32
+		} elseif (!($iterator instanceof Iterator)) {
33
+			throw new TDBMException("\$iterator parameter must be an instance of Iterator");
34
+		} else {
35
+			$this->iterator = $iterator;
36
+		}
37 37
 
38
-        if ($callable instanceof \Closure) {
39
-            // make sure there's one argument
40
-            $reflection = new \ReflectionObject($callable);
41
-            if ($reflection->hasMethod('__invoke')) {
42
-                $method = $reflection->getMethod('__invoke');
43
-                if ($method->getNumberOfParameters() !== 1) {
44
-                    throw new TDBMException("\$callable must accept one and only one parameter.");
45
-                }
46
-            }
47
-        }
38
+		if ($callable instanceof \Closure) {
39
+			// make sure there's one argument
40
+			$reflection = new \ReflectionObject($callable);
41
+			if ($reflection->hasMethod('__invoke')) {
42
+				$method = $reflection->getMethod('__invoke');
43
+				if ($method->getNumberOfParameters() !== 1) {
44
+					throw new TDBMException("\$callable must accept one and only one parameter.");
45
+				}
46
+			}
47
+		}
48 48
 
49
-        $this->callable = $callable;
50
-    }
49
+		$this->callable = $callable;
50
+	}
51 51
 
52
-    /**
53
-     * Alters the current item with $this->callable and returns a new item.
54
-     * Be careful with your types as we can't do static type checking here!
55
-     *
56
-     * @return mixed
57
-     */
58
-    public function current()
59
-    {
60
-        $callable = $this->callable;
52
+	/**
53
+	 * Alters the current item with $this->callable and returns a new item.
54
+	 * Be careful with your types as we can't do static type checking here!
55
+	 *
56
+	 * @return mixed
57
+	 */
58
+	public function current()
59
+	{
60
+		$callable = $this->callable;
61 61
 
62
-        return $callable($this->iterator->current());
63
-    }
62
+		return $callable($this->iterator->current());
63
+	}
64 64
 
65
-    public function next()
66
-    {
67
-        $this->iterator->next();
68
-    }
65
+	public function next()
66
+	{
67
+		$this->iterator->next();
68
+	}
69 69
 
70
-    public function key()
71
-    {
72
-        return $this->iterator->key();
73
-    }
70
+	public function key()
71
+	{
72
+		return $this->iterator->key();
73
+	}
74 74
 
75
-    public function valid()
76
-    {
77
-        return $this->iterator->valid();
78
-    }
75
+	public function valid()
76
+	{
77
+		return $this->iterator->valid();
78
+	}
79 79
 
80
-    public function rewind()
81
-    {
82
-        $this->iterator->rewind();
83
-    }
80
+	public function rewind()
81
+	{
82
+		$this->iterator->rewind();
83
+	}
84 84
 
85
-    /**
86
-     * Casts the iterator to a PHP array.
87
-     *
88
-     * @return array
89
-     */
90
-    public function toArray()
91
-    {
92
-        return iterator_to_array($this);
93
-    }
85
+	/**
86
+	 * Casts the iterator to a PHP array.
87
+	 *
88
+	 * @return array
89
+	 */
90
+	public function toArray()
91
+	{
92
+		return iterator_to_array($this);
93
+	}
94 94
 }
Please login to merge, or discard this patch.
src/Mouf/Database/TDBM/StandardObjectStorage.php 1 patch
Indentation   +69 added lines, -69 removed lines patch added patch discarded remove patch
@@ -30,78 +30,78 @@
 block discarded – undo
30 30
  */
31 31
 class StandardObjectStorage
32 32
 {
33
-    /**
34
-     * An array of fetched object, accessible via table name and primary key.
35
-     * If the primary key is split on several columns, access is done by an array of columns, serialized.
36
-     *
37
-     * @var array<string, array<string, TDBMObject>>
38
-     */
39
-    private $objects = array();
33
+	/**
34
+	 * An array of fetched object, accessible via table name and primary key.
35
+	 * If the primary key is split on several columns, access is done by an array of columns, serialized.
36
+	 *
37
+	 * @var array<string, array<string, TDBMObject>>
38
+	 */
39
+	private $objects = array();
40 40
 
41
-    /**
42
-     * Sets an object in the storage.
43
-     *
44
-     * @param string     $tableName
45
-     * @param string     $id
46
-     * @param TDBMObject $dbRow
47
-     */
48
-    public function set($tableName, $id, DbRow $dbRow)
49
-    {
50
-        $this->objects[$tableName][$id] = $dbRow;
51
-    }
41
+	/**
42
+	 * Sets an object in the storage.
43
+	 *
44
+	 * @param string     $tableName
45
+	 * @param string     $id
46
+	 * @param TDBMObject $dbRow
47
+	 */
48
+	public function set($tableName, $id, DbRow $dbRow)
49
+	{
50
+		$this->objects[$tableName][$id] = $dbRow;
51
+	}
52 52
 
53
-    /**
54
-     * Checks if an object is in the storage.
55
-     *
56
-     * @param string $tableName
57
-     * @param string $id
58
-     *
59
-     * @return bool
60
-     */
61
-    public function has($tableName, $id)
62
-    {
63
-        return isset($this->objects[$tableName][$id]);
64
-    }
53
+	/**
54
+	 * Checks if an object is in the storage.
55
+	 *
56
+	 * @param string $tableName
57
+	 * @param string $id
58
+	 *
59
+	 * @return bool
60
+	 */
61
+	public function has($tableName, $id)
62
+	{
63
+		return isset($this->objects[$tableName][$id]);
64
+	}
65 65
 
66
-    /**
67
-     * Returns an object from the storage (or null if no object is set).
68
-     *
69
-     * @param string $tableName
70
-     * @param string $id
71
-     *
72
-     * @return DbRow
73
-     */
74
-    public function get($tableName, $id)
75
-    {
76
-        if (isset($this->objects[$tableName][$id])) {
77
-            return $this->objects[$tableName][$id];
78
-        } else {
79
-            return;
80
-        }
81
-    }
66
+	/**
67
+	 * Returns an object from the storage (or null if no object is set).
68
+	 *
69
+	 * @param string $tableName
70
+	 * @param string $id
71
+	 *
72
+	 * @return DbRow
73
+	 */
74
+	public function get($tableName, $id)
75
+	{
76
+		if (isset($this->objects[$tableName][$id])) {
77
+			return $this->objects[$tableName][$id];
78
+		} else {
79
+			return;
80
+		}
81
+	}
82 82
 
83
-    /**
84
-     * Removes an object from the storage.
85
-     *
86
-     * @param string $tableName
87
-     * @param string $id
88
-     */
89
-    public function remove($tableName, $id)
90
-    {
91
-        unset($this->objects[$tableName][$id]);
92
-    }
83
+	/**
84
+	 * Removes an object from the storage.
85
+	 *
86
+	 * @param string $tableName
87
+	 * @param string $id
88
+	 */
89
+	public function remove($tableName, $id)
90
+	{
91
+		unset($this->objects[$tableName][$id]);
92
+	}
93 93
 
94
-    /**
95
-     * Applies the callback to all objects.
96
-     *
97
-     * @param callable $callback
98
-     */
99
-    public function apply(callable $callback)
100
-    {
101
-        foreach ($this->objects as $tableName => $table) {
102
-            foreach ($table as $id => $obj) {
103
-                $callback($obj, $tableName, $id);
104
-            }
105
-        }
106
-    }
94
+	/**
95
+	 * Applies the callback to all objects.
96
+	 *
97
+	 * @param callable $callback
98
+	 */
99
+	public function apply(callable $callback)
100
+	{
101
+		foreach ($this->objects as $tableName => $table) {
102
+			foreach ($table as $id => $obj) {
103
+				$callback($obj, $tableName, $id);
104
+			}
105
+		}
106
+	}
107 107
 }
Please login to merge, or discard this patch.
src/Mouf/Database/TDBM/TDBMObjectArray.php 2 patches
Indentation   +65 added lines, -65 removed lines patch added patch discarded remove patch
@@ -26,77 +26,77 @@
 block discarded – undo
26 26
  */
27 27
 class TDBMObjectArray extends \ArrayObject implements \JsonSerializable
28 28
 {
29
-    public function __get($var)
30
-    {
31
-        $cnt = count($this);
32
-        if ($cnt == 1) {
33
-            return $this[0]->__get($var);
34
-        } elseif ($cnt > 1) {
35
-            throw new TDBMException('Array contains many objects! Use getarray_'.$var.' to retrieve an array of '.$var);
36
-        } else {
37
-            throw new TDBMException('Array contains no objects');
38
-        }
39
-    }
29
+	public function __get($var)
30
+	{
31
+		$cnt = count($this);
32
+		if ($cnt == 1) {
33
+			return $this[0]->__get($var);
34
+		} elseif ($cnt > 1) {
35
+			throw new TDBMException('Array contains many objects! Use getarray_'.$var.' to retrieve an array of '.$var);
36
+		} else {
37
+			throw new TDBMException('Array contains no objects');
38
+		}
39
+	}
40 40
 
41
-    public function __set($var, $value)
42
-    {
43
-        $cnt = count($this);
44
-        if ($cnt == 1) {
45
-            return $this[0]->__set($var, $value);
46
-        } elseif ($cnt > 1) {
47
-            throw new TDBMException('Array contains many objects! Use setarray_'.$var.' to set the array of '.$var);
48
-        } else {
49
-            throw new TDBMException('Array contains no objects');
50
-        }
51
-    }
41
+	public function __set($var, $value)
42
+	{
43
+		$cnt = count($this);
44
+		if ($cnt == 1) {
45
+			return $this[0]->__set($var, $value);
46
+		} elseif ($cnt > 1) {
47
+			throw new TDBMException('Array contains many objects! Use setarray_'.$var.' to set the array of '.$var);
48
+		} else {
49
+			throw new TDBMException('Array contains no objects');
50
+		}
51
+	}
52 52
 
53
-    /**
54
-     * getarray_column_name returns an array containing the values of the column of the given objects.
55
-     * setarray_column_name sets the value of the given column for all the objects.
56
-     *
57
-     * @param string $func_name
58
-     * @param $values
59
-     *
60
-     * @return array|void
61
-     *
62
-     * @throws TDBMException
63
-     */
64
-    public function __call($func_name, $values)
65
-    {
66
-        if (strpos($func_name, 'getarray_') === 0) {
67
-            $column = substr($func_name, 9);
53
+	/**
54
+	 * getarray_column_name returns an array containing the values of the column of the given objects.
55
+	 * setarray_column_name sets the value of the given column for all the objects.
56
+	 *
57
+	 * @param string $func_name
58
+	 * @param $values
59
+	 *
60
+	 * @return array|void
61
+	 *
62
+	 * @throws TDBMException
63
+	 */
64
+	public function __call($func_name, $values)
65
+	{
66
+		if (strpos($func_name, 'getarray_') === 0) {
67
+			$column = substr($func_name, 9);
68 68
 
69
-            return $this->getarray($column);
70
-        } elseif (strpos($func_name, 'setarray_') === 0) {
71
-            $column = substr($func_name, 9);
69
+			return $this->getarray($column);
70
+		} elseif (strpos($func_name, 'setarray_') === 0) {
71
+			$column = substr($func_name, 9);
72 72
 
73
-            return $this->setarray($column, $values[0]);
74
-        } elseif (count($this) == 1) {
75
-            $this[0]->__call($func_name, $values);
76
-        } else {
77
-            throw new TDBMException('Method '.$func_name.' not found');
78
-        }
79
-    }
73
+			return $this->setarray($column, $values[0]);
74
+		} elseif (count($this) == 1) {
75
+			$this[0]->__call($func_name, $values);
76
+		} else {
77
+			throw new TDBMException('Method '.$func_name.' not found');
78
+		}
79
+	}
80 80
 
81
-    private function getarray($column)
82
-    {
83
-        $arr = array();
84
-        foreach ($this as $object) {
85
-            $arr[] = $object->__get($column);
86
-        }
81
+	private function getarray($column)
82
+	{
83
+		$arr = array();
84
+		foreach ($this as $object) {
85
+			$arr[] = $object->__get($column);
86
+		}
87 87
 
88
-        return $arr;
89
-    }
88
+		return $arr;
89
+	}
90 90
 
91
-    private function setarray($column, $value)
92
-    {
93
-        foreach ($this as $object) {
94
-            $object->__set($column, $value);
95
-        }
96
-    }
91
+	private function setarray($column, $value)
92
+	{
93
+		foreach ($this as $object) {
94
+			$object->__set($column, $value);
95
+		}
96
+	}
97 97
 
98
-    public function jsonSerialize()
99
-    {
100
-        return (array) $this;
101
-    }
98
+	public function jsonSerialize()
99
+	{
100
+		return (array) $this;
101
+	}
102 102
 }
Please login to merge, or discard this patch.
Spacing   +2 added lines, -2 removed lines patch added patch discarded remove patch
@@ -31,7 +31,7 @@  discard block
 block discarded – undo
31 31
         $cnt = count($this);
32 32
         if ($cnt == 1) {
33 33
             return $this[0]->__get($var);
34
-        } elseif ($cnt > 1) {
34
+        } elseif ($cnt>1) {
35 35
             throw new TDBMException('Array contains many objects! Use getarray_'.$var.' to retrieve an array of '.$var);
36 36
         } else {
37 37
             throw new TDBMException('Array contains no objects');
@@ -43,7 +43,7 @@  discard block
 block discarded – undo
43 43
         $cnt = count($this);
44 44
         if ($cnt == 1) {
45 45
             return $this[0]->__set($var, $value);
46
-        } elseif ($cnt > 1) {
46
+        } elseif ($cnt>1) {
47 47
             throw new TDBMException('Array contains many objects! Use setarray_'.$var.' to set the array of '.$var);
48 48
         } else {
49 49
             throw new TDBMException('Array contains no objects');
Please login to merge, or discard this patch.
src/Mouf/Database/TDBM/PageIterator.php 2 patches
Spacing   +2 added lines, -2 removed lines patch added patch discarded remove patch
@@ -112,7 +112,7 @@  discard block
 block discarded – undo
112 112
      */
113 113
     public function getCurrentPage()
114 114
     {
115
-        return floor($this->offset / $this->limit) + 1;
115
+        return floor($this->offset/$this->limit)+1;
116 116
     }
117 117
 
118 118
     /**
@@ -251,7 +251,7 @@  discard block
 block discarded – undo
251 251
      */
252 252
     public function jsonSerialize()
253 253
     {
254
-        return array_map(function (AbstractTDBMObject $item) {
254
+        return array_map(function(AbstractTDBMObject $item) {
255 255
             return $item->jsonSerialize();
256 256
         }, $this->toArray());
257 257
     }
Please login to merge, or discard this patch.
Indentation   +206 added lines, -206 removed lines patch added patch discarded remove patch
@@ -29,232 +29,232 @@
 block discarded – undo
29 29
  */
30 30
 class PageIterator implements Page, \ArrayAccess, \JsonSerializable
31 31
 {
32
-    /**
33
-     * @var Statement
34
-     */
35
-    protected $statement;
32
+	/**
33
+	 * @var Statement
34
+	 */
35
+	protected $statement;
36 36
 
37
-    protected $fetchStarted = false;
38
-    private $objectStorage;
39
-    private $className;
37
+	protected $fetchStarted = false;
38
+	private $objectStorage;
39
+	private $className;
40 40
 
41
-    private $parentResult;
42
-    private $tdbmService;
43
-    private $magicSql;
44
-    private $parameters;
45
-    private $limit;
46
-    private $offset;
47
-    private $columnDescriptors;
48
-    private $magicQuery;
41
+	private $parentResult;
42
+	private $tdbmService;
43
+	private $magicSql;
44
+	private $parameters;
45
+	private $limit;
46
+	private $offset;
47
+	private $columnDescriptors;
48
+	private $magicQuery;
49 49
 
50
-    /**
51
-     * The key of the current retrieved object.
52
-     *
53
-     * @var int
54
-     */
55
-    protected $key = -1;
50
+	/**
51
+	 * The key of the current retrieved object.
52
+	 *
53
+	 * @var int
54
+	 */
55
+	protected $key = -1;
56 56
 
57
-    protected $current = null;
57
+	protected $current = null;
58 58
 
59
-    private $databasePlatform;
59
+	private $databasePlatform;
60 60
 
61
-    private $innerResultIterator;
61
+	private $innerResultIterator;
62 62
 
63
-    private $mode;
63
+	private $mode;
64 64
 
65
-    public function __construct(ResultIterator $parentResult, $magicSql, array $parameters, $limit, $offset, array $columnDescriptors, $objectStorage, $className, TDBMService $tdbmService, MagicQuery $magicQuery, $mode)
66
-    {
67
-        $this->parentResult = $parentResult;
68
-        $this->magicSql = $magicSql;
69
-        $this->objectStorage = $objectStorage;
70
-        $this->className = $className;
71
-        $this->tdbmService = $tdbmService;
72
-        $this->parameters = $parameters;
73
-        $this->limit = $limit;
74
-        $this->offset = $offset;
75
-        $this->columnDescriptors = $columnDescriptors;
76
-        $this->magicQuery = $magicQuery;
77
-        $this->databasePlatform = $this->tdbmService->getConnection()->getDatabasePlatform();
78
-        $this->mode = $mode;
79
-    }
65
+	public function __construct(ResultIterator $parentResult, $magicSql, array $parameters, $limit, $offset, array $columnDescriptors, $objectStorage, $className, TDBMService $tdbmService, MagicQuery $magicQuery, $mode)
66
+	{
67
+		$this->parentResult = $parentResult;
68
+		$this->magicSql = $magicSql;
69
+		$this->objectStorage = $objectStorage;
70
+		$this->className = $className;
71
+		$this->tdbmService = $tdbmService;
72
+		$this->parameters = $parameters;
73
+		$this->limit = $limit;
74
+		$this->offset = $offset;
75
+		$this->columnDescriptors = $columnDescriptors;
76
+		$this->magicQuery = $magicQuery;
77
+		$this->databasePlatform = $this->tdbmService->getConnection()->getDatabasePlatform();
78
+		$this->mode = $mode;
79
+	}
80 80
 
81
-    /**
82
-     * Retrieve an external iterator.
83
-     *
84
-     * @link http://php.net/manual/en/iteratoraggregate.getiterator.php
85
-     *
86
-     * @return InnerResultIterator An instance of an object implementing <b>Iterator</b> or
87
-     *                             <b>Traversable</b>
88
-     *
89
-     * @since 5.0.0
90
-     */
91
-    public function getIterator()
92
-    {
93
-        if ($this->innerResultIterator === null) {
94
-            if ($this->mode === TDBMService::MODE_CURSOR) {
95
-                $this->innerResultIterator = new InnerResultIterator($this->magicSql, $this->parameters, $this->limit, $this->offset, $this->columnDescriptors, $this->objectStorage, $this->className, $this->tdbmService, $this->magicQuery);
96
-            } else {
97
-                $this->innerResultIterator = new InnerResultArray($this->magicSql, $this->parameters, $this->limit, $this->offset, $this->columnDescriptors, $this->objectStorage, $this->className, $this->tdbmService, $this->magicQuery);
98
-            }
99
-        }
81
+	/**
82
+	 * Retrieve an external iterator.
83
+	 *
84
+	 * @link http://php.net/manual/en/iteratoraggregate.getiterator.php
85
+	 *
86
+	 * @return InnerResultIterator An instance of an object implementing <b>Iterator</b> or
87
+	 *                             <b>Traversable</b>
88
+	 *
89
+	 * @since 5.0.0
90
+	 */
91
+	public function getIterator()
92
+	{
93
+		if ($this->innerResultIterator === null) {
94
+			if ($this->mode === TDBMService::MODE_CURSOR) {
95
+				$this->innerResultIterator = new InnerResultIterator($this->magicSql, $this->parameters, $this->limit, $this->offset, $this->columnDescriptors, $this->objectStorage, $this->className, $this->tdbmService, $this->magicQuery);
96
+			} else {
97
+				$this->innerResultIterator = new InnerResultArray($this->magicSql, $this->parameters, $this->limit, $this->offset, $this->columnDescriptors, $this->objectStorage, $this->className, $this->tdbmService, $this->magicQuery);
98
+			}
99
+		}
100 100
 
101
-        return $this->innerResultIterator;
102
-    }
101
+		return $this->innerResultIterator;
102
+	}
103 103
 
104
-    /**
105
-     * @return int
106
-     */
107
-    public function getCurrentOffset()
108
-    {
109
-        return $this->offset;
110
-    }
104
+	/**
105
+	 * @return int
106
+	 */
107
+	public function getCurrentOffset()
108
+	{
109
+		return $this->offset;
110
+	}
111 111
 
112
-    /**
113
-     * @return int
114
-     */
115
-    public function getCurrentPage()
116
-    {
117
-        return floor($this->offset / $this->limit) + 1;
118
-    }
112
+	/**
113
+	 * @return int
114
+	 */
115
+	public function getCurrentPage()
116
+	{
117
+		return floor($this->offset / $this->limit) + 1;
118
+	}
119 119
 
120
-    /**
121
-     * @return int
122
-     */
123
-    public function getCurrentLimit()
124
-    {
125
-        return $this->limit;
126
-    }
120
+	/**
121
+	 * @return int
122
+	 */
123
+	public function getCurrentLimit()
124
+	{
125
+		return $this->limit;
126
+	}
127 127
 
128
-    /**
129
-     * Return the number of results on the current page of the {@link Result}.
130
-     *
131
-     * @return int
132
-     */
133
-    public function count()
134
-    {
135
-        return $this->getIterator()->count();
136
-    }
128
+	/**
129
+	 * Return the number of results on the current page of the {@link Result}.
130
+	 *
131
+	 * @return int
132
+	 */
133
+	public function count()
134
+	{
135
+		return $this->getIterator()->count();
136
+	}
137 137
 
138
-    /**
139
-     * Return the number of ALL results in the paginatable of {@link Result}.
140
-     *
141
-     * @return int
142
-     */
143
-    public function totalCount()
144
-    {
145
-        return $this->parentResult->count();
146
-    }
138
+	/**
139
+	 * Return the number of ALL results in the paginatable of {@link Result}.
140
+	 *
141
+	 * @return int
142
+	 */
143
+	public function totalCount()
144
+	{
145
+		return $this->parentResult->count();
146
+	}
147 147
 
148
-    /**
149
-     * Casts the result set to a PHP array.
150
-     *
151
-     * @return array
152
-     */
153
-    public function toArray()
154
-    {
155
-        return iterator_to_array($this->getIterator());
156
-    }
148
+	/**
149
+	 * Casts the result set to a PHP array.
150
+	 *
151
+	 * @return array
152
+	 */
153
+	public function toArray()
154
+	{
155
+		return iterator_to_array($this->getIterator());
156
+	}
157 157
 
158
-    /**
159
-     * Returns a new iterator mapping any call using the $callable function.
160
-     *
161
-     * @param callable $callable
162
-     *
163
-     * @return MapIterator
164
-     */
165
-    public function map(callable $callable)
166
-    {
167
-        return new MapIterator($this->getIterator(), $callable);
168
-    }
158
+	/**
159
+	 * Returns a new iterator mapping any call using the $callable function.
160
+	 *
161
+	 * @param callable $callable
162
+	 *
163
+	 * @return MapIterator
164
+	 */
165
+	public function map(callable $callable)
166
+	{
167
+		return new MapIterator($this->getIterator(), $callable);
168
+	}
169 169
 
170
-    /**
171
-     * Whether a offset exists.
172
-     *
173
-     * @link http://php.net/manual/en/arrayaccess.offsetexists.php
174
-     *
175
-     * @param mixed $offset <p>
176
-     *                      An offset to check for.
177
-     *                      </p>
178
-     *
179
-     * @return bool true on success or false on failure.
180
-     *              </p>
181
-     *              <p>
182
-     *              The return value will be casted to boolean if non-boolean was returned.
183
-     *
184
-     * @since 5.0.0
185
-     */
186
-    public function offsetExists($offset)
187
-    {
188
-        return $this->getIterator()->offsetExists($offset);
189
-    }
170
+	/**
171
+	 * Whether a offset exists.
172
+	 *
173
+	 * @link http://php.net/manual/en/arrayaccess.offsetexists.php
174
+	 *
175
+	 * @param mixed $offset <p>
176
+	 *                      An offset to check for.
177
+	 *                      </p>
178
+	 *
179
+	 * @return bool true on success or false on failure.
180
+	 *              </p>
181
+	 *              <p>
182
+	 *              The return value will be casted to boolean if non-boolean was returned.
183
+	 *
184
+	 * @since 5.0.0
185
+	 */
186
+	public function offsetExists($offset)
187
+	{
188
+		return $this->getIterator()->offsetExists($offset);
189
+	}
190 190
 
191
-    /**
192
-     * Offset to retrieve.
193
-     *
194
-     * @link http://php.net/manual/en/arrayaccess.offsetget.php
195
-     *
196
-     * @param mixed $offset <p>
197
-     *                      The offset to retrieve.
198
-     *                      </p>
199
-     *
200
-     * @return mixed Can return all value types.
201
-     *
202
-     * @since 5.0.0
203
-     */
204
-    public function offsetGet($offset)
205
-    {
206
-        return $this->getIterator()->offsetGet($offset);
207
-    }
191
+	/**
192
+	 * Offset to retrieve.
193
+	 *
194
+	 * @link http://php.net/manual/en/arrayaccess.offsetget.php
195
+	 *
196
+	 * @param mixed $offset <p>
197
+	 *                      The offset to retrieve.
198
+	 *                      </p>
199
+	 *
200
+	 * @return mixed Can return all value types.
201
+	 *
202
+	 * @since 5.0.0
203
+	 */
204
+	public function offsetGet($offset)
205
+	{
206
+		return $this->getIterator()->offsetGet($offset);
207
+	}
208 208
 
209
-    /**
210
-     * Offset to set.
211
-     *
212
-     * @link http://php.net/manual/en/arrayaccess.offsetset.php
213
-     *
214
-     * @param mixed $offset <p>
215
-     *                      The offset to assign the value to.
216
-     *                      </p>
217
-     * @param mixed $value  <p>
218
-     *                      The value to set.
219
-     *                      </p>
220
-     *
221
-     * @since 5.0.0
222
-     */
223
-    public function offsetSet($offset, $value)
224
-    {
225
-        return $this->getIterator()->offsetSet($offset, $value);
226
-    }
209
+	/**
210
+	 * Offset to set.
211
+	 *
212
+	 * @link http://php.net/manual/en/arrayaccess.offsetset.php
213
+	 *
214
+	 * @param mixed $offset <p>
215
+	 *                      The offset to assign the value to.
216
+	 *                      </p>
217
+	 * @param mixed $value  <p>
218
+	 *                      The value to set.
219
+	 *                      </p>
220
+	 *
221
+	 * @since 5.0.0
222
+	 */
223
+	public function offsetSet($offset, $value)
224
+	{
225
+		return $this->getIterator()->offsetSet($offset, $value);
226
+	}
227 227
 
228
-    /**
229
-     * Offset to unset.
230
-     *
231
-     * @link http://php.net/manual/en/arrayaccess.offsetunset.php
232
-     *
233
-     * @param mixed $offset <p>
234
-     *                      The offset to unset.
235
-     *                      </p>
236
-     *
237
-     * @since 5.0.0
238
-     */
239
-    public function offsetUnset($offset)
240
-    {
241
-        return $this->getIterator()->offsetUnset($offset);
242
-    }
228
+	/**
229
+	 * Offset to unset.
230
+	 *
231
+	 * @link http://php.net/manual/en/arrayaccess.offsetunset.php
232
+	 *
233
+	 * @param mixed $offset <p>
234
+	 *                      The offset to unset.
235
+	 *                      </p>
236
+	 *
237
+	 * @since 5.0.0
238
+	 */
239
+	public function offsetUnset($offset)
240
+	{
241
+		return $this->getIterator()->offsetUnset($offset);
242
+	}
243 243
 
244
-    /**
245
-     * Specify data which should be serialized to JSON.
246
-     *
247
-     * @link http://php.net/manual/en/jsonserializable.jsonserialize.php
248
-     *
249
-     * @return mixed data which can be serialized by <b>json_encode</b>,
250
-     *               which is a value of any type other than a resource.
251
-     *
252
-     * @since 5.4.0
253
-     */
254
-    public function jsonSerialize()
255
-    {
256
-        return array_map(function (AbstractTDBMObject $item) {
257
-            return $item->jsonSerialize();
258
-        }, $this->toArray());
259
-    }
244
+	/**
245
+	 * Specify data which should be serialized to JSON.
246
+	 *
247
+	 * @link http://php.net/manual/en/jsonserializable.jsonserialize.php
248
+	 *
249
+	 * @return mixed data which can be serialized by <b>json_encode</b>,
250
+	 *               which is a value of any type other than a resource.
251
+	 *
252
+	 * @since 5.4.0
253
+	 */
254
+	public function jsonSerialize()
255
+	{
256
+		return array_map(function (AbstractTDBMObject $item) {
257
+			return $item->jsonSerialize();
258
+		}, $this->toArray());
259
+	}
260 260
 }
Please login to merge, or discard this patch.