@@ -133,14 +133,14 @@ |
||
133 | 133 | $work_table = explode("'", $work_str); |
134 | 134 | |
135 | 135 | if (count($work_table) == 0) |
136 | - return ''; |
|
136 | + return ''; |
|
137 | 137 | |
138 | 138 | // if we start with a ', let's remove the first text |
139 | 139 | if (strstr($work_str,"'") === 0) |
140 | - array_shift($work_table); |
|
140 | + array_shift($work_table); |
|
141 | 141 | |
142 | 142 | if (count($work_table) == 0) |
143 | - return ''; |
|
143 | + return ''; |
|
144 | 144 | |
145 | 145 | // Now, let's take only the stuff outside the quotes. |
146 | 146 | $work_str2 = ''; |
@@ -9,14 +9,14 @@ |
||
9 | 9 | */ |
10 | 10 | class FilterUtils |
11 | 11 | { |
12 | - /** |
|
13 | - * @param string|null|DateTimeInterface $value |
|
14 | - */ |
|
15 | - public static function valueToSql($value, Connection $dbConnection) { |
|
16 | - if ($value instanceof DateTimeInterface) { |
|
17 | - return "'".$value->format('Y-m-d H:i:s')."'"; |
|
18 | - } else { |
|
19 | - return $dbConnection->quote($value); |
|
20 | - } |
|
21 | - } |
|
12 | + /** |
|
13 | + * @param string|null|DateTimeInterface $value |
|
14 | + */ |
|
15 | + public static function valueToSql($value, Connection $dbConnection) { |
|
16 | + if ($value instanceof DateTimeInterface) { |
|
17 | + return "'".$value->format('Y-m-d H:i:s')."'"; |
|
18 | + } else { |
|
19 | + return $dbConnection->quote($value); |
|
20 | + } |
|
21 | + } |
|
22 | 22 | } |
@@ -98,8 +98,8 @@ discard block |
||
98 | 98 | * |
99 | 99 | * @param string $tableName |
100 | 100 | * @param string $columnName |
101 | - * @param string $value1 |
|
102 | - * @param string $value2 |
|
101 | + * @param string $value1 |
|
102 | + * @param string $value2 |
|
103 | 103 | */ |
104 | 104 | public function __construct($tableName=null, $columnName=null, $value1=null, $value2=null) { |
105 | 105 | $this->tableName = $tableName; |
@@ -113,9 +113,9 @@ discard block |
||
113 | 113 | * |
114 | 114 | * @param Connection $dbConnection |
115 | 115 | * @return string |
116 | - * @throws \Mouf\Database\TDBM\TDBMException |
|
116 | + * @throws \Mouf\Database\TDBM\TDBMException |
|
117 | 117 | */ |
118 | - public function toSql(Connection $dbConnection) { |
|
118 | + public function toSql(Connection $dbConnection) { |
|
119 | 119 | if ($this->enableCondition != null && !$this->enableCondition->isOk()) { |
120 | 120 | return ""; |
121 | 121 | } |
@@ -68,9 +68,9 @@ discard block |
||
68 | 68 | * |
69 | 69 | * @param Connection $dbConnection |
70 | 70 | * @return string |
71 | - * @throws TDBMException |
|
71 | + * @throws TDBMException |
|
72 | 72 | */ |
73 | - public function toSql(Connection $dbConnection) { |
|
73 | + public function toSql(Connection $dbConnection) { |
|
74 | 74 | if ($this->enableCondition != null && !$this->enableCondition->isOk()) { |
75 | 75 | return ""; |
76 | 76 | } |
@@ -102,22 +102,22 @@ discard block |
||
102 | 102 | * |
103 | 103 | * @return array<string> |
104 | 104 | */ |
105 | - public function getUsedTables() { |
|
106 | - if ($this->enableCondition != null && !$this->enableCondition->isOk()) { |
|
107 | - return array(); |
|
108 | - } |
|
109 | - |
|
110 | - $tables = array(); |
|
111 | - foreach ($this->filters as $filter) { |
|
112 | - |
|
113 | - if (!$filter instanceof FilterInterface) { |
|
114 | - throw new TDBMException("Error in OrFilter: One of the parameters is not a filter."); |
|
115 | - } |
|
116 | - |
|
117 | - $tables = array_merge($tables,$filter->getUsedTables()); |
|
118 | - } |
|
119 | - // Remove tables in double. |
|
120 | - $tables = array_flip(array_flip($tables)); |
|
121 | - return $tables; |
|
122 | - } |
|
105 | + public function getUsedTables() { |
|
106 | + if ($this->enableCondition != null && !$this->enableCondition->isOk()) { |
|
107 | + return array(); |
|
108 | + } |
|
109 | + |
|
110 | + $tables = array(); |
|
111 | + foreach ($this->filters as $filter) { |
|
112 | + |
|
113 | + if (!$filter instanceof FilterInterface) { |
|
114 | + throw new TDBMException("Error in OrFilter: One of the parameters is not a filter."); |
|
115 | + } |
|
116 | + |
|
117 | + $tables = array_merge($tables,$filter->getUsedTables()); |
|
118 | + } |
|
119 | + // Remove tables in double. |
|
120 | + $tables = array_flip(array_flip($tables)); |
|
121 | + return $tables; |
|
122 | + } |
|
123 | 123 | } |
@@ -547,23 +547,23 @@ |
||
547 | 547 | return $sql_where; |
548 | 548 | } |
549 | 549 | |
550 | - /** |
|
551 | - * Override the native php clone function for TDBMObjects |
|
552 | - */ |
|
553 | - public function __clone(){ |
|
554 | - $this->_dbLoadIfNotLoaded(); |
|
555 | - //First lets set the status to new (to enter the save function) |
|
556 | - $this->status = TDBMObjectStateEnum::STATE_NEW; |
|
557 | - |
|
558 | - // Add the current TDBMObject to the save object list |
|
559 | - $this->tdbmService->_addToToSaveObjectList($this); |
|
560 | - |
|
561 | - //Now unset the PK from the row |
|
562 | - $pk_array = $this->tdbmService->getPrimaryKeyColumns($this->dbTableName); |
|
563 | - foreach ($pk_array as $pk) { |
|
564 | - $this->dbRow[$pk] = null; |
|
565 | - } |
|
566 | - } |
|
550 | + /** |
|
551 | + * Override the native php clone function for TDBMObjects |
|
552 | + */ |
|
553 | + public function __clone(){ |
|
554 | + $this->_dbLoadIfNotLoaded(); |
|
555 | + //First lets set the status to new (to enter the save function) |
|
556 | + $this->status = TDBMObjectStateEnum::STATE_NEW; |
|
557 | + |
|
558 | + // Add the current TDBMObject to the save object list |
|
559 | + $this->tdbmService->_addToToSaveObjectList($this); |
|
560 | + |
|
561 | + //Now unset the PK from the row |
|
562 | + $pk_array = $this->tdbmService->getPrimaryKeyColumns($this->dbTableName); |
|
563 | + foreach ($pk_array as $pk) { |
|
564 | + $this->dbRow[$pk] = null; |
|
565 | + } |
|
566 | + } |
|
567 | 567 | |
568 | 568 | /** |
569 | 569 | * Returns raw database rows. |
@@ -510,7 +510,7 @@ discard block |
||
510 | 510 | case TDBMObjectStateEnum::STATE_DETACHED: |
511 | 511 | throw new TDBMInvalidOperationException('Cannot delete a detached object'); |
512 | 512 | case TDBMObjectStateEnum::STATE_NEW: |
513 | - $this->deleteManyToManyRelationships($object); |
|
513 | + $this->deleteManyToManyRelationships($object); |
|
514 | 514 | foreach ($object->_getDbRows() as $dbRow) { |
515 | 515 | $this->removeFromToSaveObjectList($dbRow); |
516 | 516 | } |
@@ -521,7 +521,7 @@ discard block |
||
521 | 521 | } |
522 | 522 | case TDBMObjectStateEnum::STATE_NOT_LOADED: |
523 | 523 | case TDBMObjectStateEnum::STATE_LOADED: |
524 | - $this->deleteManyToManyRelationships($object); |
|
524 | + $this->deleteManyToManyRelationships($object); |
|
525 | 525 | // Let's delete db rows, in reverse order. |
526 | 526 | foreach (array_reverse($object->_getDbRows()) as $dbRow) { |
527 | 527 | $tableName = $dbRow->_getDbTableName(); |
@@ -541,63 +541,63 @@ discard block |
||
541 | 541 | $object->_setStatus(TDBMObjectStateEnum::STATE_DELETED); |
542 | 542 | } |
543 | 543 | |
544 | - /** |
|
545 | - * Removes all many to many relationships for this object. |
|
546 | - * @param AbstractTDBMObject $object |
|
547 | - */ |
|
548 | - private function deleteManyToManyRelationships(AbstractTDBMObject $object) { |
|
549 | - foreach ($object->_getDbRows() as $tableName => $dbRow) { |
|
550 | - $pivotTables = $this->tdbmSchemaAnalyzer->getPivotTableLinkedToTable($tableName); |
|
551 | - foreach ($pivotTables as $pivotTable) { |
|
552 | - $remoteBeans = $object->_getRelationships($pivotTable); |
|
553 | - foreach ($remoteBeans as $remoteBean) { |
|
554 | - $object->_removeRelationship($pivotTable, $remoteBean); |
|
555 | - } |
|
556 | - } |
|
557 | - } |
|
558 | - $this->persistManyToManyRelationships($object); |
|
559 | - } |
|
560 | - |
|
561 | - |
|
562 | - /** |
|
563 | - * This function removes the given object from the database. It will also remove all objects relied to the one given |
|
564 | - * by parameter before all. |
|
565 | - * |
|
566 | - * Notice: if the object has a multiple primary key, the function will not work. |
|
567 | - * |
|
568 | - * @param AbstractTDBMObject $objToDelete |
|
569 | - */ |
|
570 | - public function deleteCascade(AbstractTDBMObject $objToDelete) { |
|
571 | - $this->deleteAllConstraintWithThisObject($objToDelete); |
|
572 | - $this->delete($objToDelete); |
|
573 | - } |
|
574 | - |
|
575 | - /** |
|
576 | - * This function is used only in TDBMService (private function) |
|
577 | - * It will call deleteCascade function foreach object relied with a foreign key to the object given by parameter |
|
578 | - * |
|
579 | - * @param TDBMObject $obj |
|
580 | - * @return TDBMObjectArray |
|
581 | - */ |
|
582 | - private function deleteAllConstraintWithThisObject(TDBMObject $obj) { |
|
583 | - $tableFrom = $this->connection->escapeDBItem($obj->_getDbTableName()); |
|
584 | - $constraints = $this->connection->getConstraintsFromTable($tableFrom); |
|
585 | - foreach ($constraints as $constraint) { |
|
586 | - $tableTo = $this->connection->escapeDBItem($constraint["table1"]); |
|
587 | - $colFrom = $this->connection->escapeDBItem($constraint["col2"]); |
|
588 | - $colTo = $this->connection->escapeDBItem($constraint["col1"]); |
|
589 | - $idVarName = $this->connection->escapeDBItem($obj->getPrimaryKey()[0]); |
|
590 | - $idValue = $this->connection->quoteSmart($obj->TDBMObject_id); |
|
591 | - $sql = "SELECT DISTINCT ".$tableTo.".*" |
|
592 | - ." FROM ".$tableFrom |
|
593 | - ." LEFT JOIN ".$tableTo." ON ".$tableFrom.".".$colFrom." = ".$tableTo.".".$colTo |
|
594 | - ." WHERE ".$tableFrom.".".$idVarName."=".$idValue; |
|
595 | - $result = $this->getObjectsFromSQL($constraint["table1"], $sql); |
|
596 | - foreach ($result as $tdbmObj) { |
|
597 | - $this->deleteCascade($tdbmObj); |
|
598 | - } |
|
599 | - } |
|
600 | - } |
|
544 | + /** |
|
545 | + * Removes all many to many relationships for this object. |
|
546 | + * @param AbstractTDBMObject $object |
|
547 | + */ |
|
548 | + private function deleteManyToManyRelationships(AbstractTDBMObject $object) { |
|
549 | + foreach ($object->_getDbRows() as $tableName => $dbRow) { |
|
550 | + $pivotTables = $this->tdbmSchemaAnalyzer->getPivotTableLinkedToTable($tableName); |
|
551 | + foreach ($pivotTables as $pivotTable) { |
|
552 | + $remoteBeans = $object->_getRelationships($pivotTable); |
|
553 | + foreach ($remoteBeans as $remoteBean) { |
|
554 | + $object->_removeRelationship($pivotTable, $remoteBean); |
|
555 | + } |
|
556 | + } |
|
557 | + } |
|
558 | + $this->persistManyToManyRelationships($object); |
|
559 | + } |
|
560 | + |
|
561 | + |
|
562 | + /** |
|
563 | + * This function removes the given object from the database. It will also remove all objects relied to the one given |
|
564 | + * by parameter before all. |
|
565 | + * |
|
566 | + * Notice: if the object has a multiple primary key, the function will not work. |
|
567 | + * |
|
568 | + * @param AbstractTDBMObject $objToDelete |
|
569 | + */ |
|
570 | + public function deleteCascade(AbstractTDBMObject $objToDelete) { |
|
571 | + $this->deleteAllConstraintWithThisObject($objToDelete); |
|
572 | + $this->delete($objToDelete); |
|
573 | + } |
|
574 | + |
|
575 | + /** |
|
576 | + * This function is used only in TDBMService (private function) |
|
577 | + * It will call deleteCascade function foreach object relied with a foreign key to the object given by parameter |
|
578 | + * |
|
579 | + * @param TDBMObject $obj |
|
580 | + * @return TDBMObjectArray |
|
581 | + */ |
|
582 | + private function deleteAllConstraintWithThisObject(TDBMObject $obj) { |
|
583 | + $tableFrom = $this->connection->escapeDBItem($obj->_getDbTableName()); |
|
584 | + $constraints = $this->connection->getConstraintsFromTable($tableFrom); |
|
585 | + foreach ($constraints as $constraint) { |
|
586 | + $tableTo = $this->connection->escapeDBItem($constraint["table1"]); |
|
587 | + $colFrom = $this->connection->escapeDBItem($constraint["col2"]); |
|
588 | + $colTo = $this->connection->escapeDBItem($constraint["col1"]); |
|
589 | + $idVarName = $this->connection->escapeDBItem($obj->getPrimaryKey()[0]); |
|
590 | + $idValue = $this->connection->quoteSmart($obj->TDBMObject_id); |
|
591 | + $sql = "SELECT DISTINCT ".$tableTo.".*" |
|
592 | + ." FROM ".$tableFrom |
|
593 | + ." LEFT JOIN ".$tableTo." ON ".$tableFrom.".".$colFrom." = ".$tableTo.".".$colTo |
|
594 | + ." WHERE ".$tableFrom.".".$idVarName."=".$idValue; |
|
595 | + $result = $this->getObjectsFromSQL($constraint["table1"], $sql); |
|
596 | + foreach ($result as $tdbmObj) { |
|
597 | + $this->deleteCascade($tdbmObj); |
|
598 | + } |
|
599 | + } |
|
600 | + } |
|
601 | 601 | |
602 | 602 | /** |
603 | 603 | * This function performs a save() of all the objects that have been modified. |
@@ -997,8 +997,8 @@ discard block |
||
997 | 997 | } |
998 | 998 | |
999 | 999 | /** |
1000 | - * @param array<string, string> $tableToBeanMap |
|
1001 | - */ |
|
1000 | + * @param array<string, string> $tableToBeanMap |
|
1001 | + */ |
|
1002 | 1002 | public function setTableToBeanMap(array $tableToBeanMap) { |
1003 | 1003 | $this->tableToBeanMap = $tableToBeanMap; |
1004 | 1004 | } |
@@ -1045,7 +1045,7 @@ discard block |
||
1045 | 1045 | |
1046 | 1046 | // Let's save all references in NEW or DETACHED state (we need their primary key) |
1047 | 1047 | foreach ($references as $fkName => $reference) { |
1048 | - $refStatus = $reference->_getStatus(); |
|
1048 | + $refStatus = $reference->_getStatus(); |
|
1049 | 1049 | if ($refStatus === TDBMObjectStateEnum::STATE_NEW || $refStatus === TDBMObjectStateEnum::STATE_DETACHED) { |
1050 | 1050 | $this->save($reference); |
1051 | 1051 | } |
@@ -1204,94 +1204,94 @@ discard block |
||
1204 | 1204 | throw new TDBMInvalidOperationException("This object has been deleted. It cannot be saved."); |
1205 | 1205 | } |
1206 | 1206 | |
1207 | - // Finally, let's save all the many to many relationships to this bean. |
|
1208 | - $this->persistManyToManyRelationships($object); |
|
1207 | + // Finally, let's save all the many to many relationships to this bean. |
|
1208 | + $this->persistManyToManyRelationships($object); |
|
1209 | 1209 | } |
1210 | 1210 | |
1211 | - private function persistManyToManyRelationships(AbstractTDBMObject $object) { |
|
1212 | - foreach ($object->_getCachedRelationships() as $pivotTableName => $storage) { |
|
1213 | - $tableDescriptor = $this->tdbmSchemaAnalyzer->getSchema()->getTable($pivotTableName); |
|
1214 | - list($localFk, $remoteFk) = $this->getPivotTableForeignKeys($pivotTableName, $object); |
|
1215 | - |
|
1216 | - foreach ($storage as $remoteBean) { |
|
1217 | - /* @var $remoteBean AbstractTDBMObject */ |
|
1218 | - $statusArr = $storage[$remoteBean]; |
|
1219 | - $status = $statusArr['status']; |
|
1220 | - $reverse = $statusArr['reverse']; |
|
1221 | - if ($reverse) { |
|
1222 | - continue; |
|
1223 | - } |
|
1224 | - |
|
1225 | - if ($status === 'new') { |
|
1226 | - $remoteBeanStatus = $remoteBean->_getStatus(); |
|
1227 | - if ($remoteBeanStatus === TDBMObjectStateEnum::STATE_NEW || $remoteBeanStatus === TDBMObjectStateEnum::STATE_DETACHED) { |
|
1228 | - // Let's save remote bean if needed. |
|
1229 | - $this->save($remoteBean); |
|
1230 | - } |
|
1211 | + private function persistManyToManyRelationships(AbstractTDBMObject $object) { |
|
1212 | + foreach ($object->_getCachedRelationships() as $pivotTableName => $storage) { |
|
1213 | + $tableDescriptor = $this->tdbmSchemaAnalyzer->getSchema()->getTable($pivotTableName); |
|
1214 | + list($localFk, $remoteFk) = $this->getPivotTableForeignKeys($pivotTableName, $object); |
|
1215 | + |
|
1216 | + foreach ($storage as $remoteBean) { |
|
1217 | + /* @var $remoteBean AbstractTDBMObject */ |
|
1218 | + $statusArr = $storage[$remoteBean]; |
|
1219 | + $status = $statusArr['status']; |
|
1220 | + $reverse = $statusArr['reverse']; |
|
1221 | + if ($reverse) { |
|
1222 | + continue; |
|
1223 | + } |
|
1231 | 1224 | |
1232 | - $filters = $this->getPivotFilters($object, $remoteBean, $localFk, $remoteFk); |
|
1225 | + if ($status === 'new') { |
|
1226 | + $remoteBeanStatus = $remoteBean->_getStatus(); |
|
1227 | + if ($remoteBeanStatus === TDBMObjectStateEnum::STATE_NEW || $remoteBeanStatus === TDBMObjectStateEnum::STATE_DETACHED) { |
|
1228 | + // Let's save remote bean if needed. |
|
1229 | + $this->save($remoteBean); |
|
1230 | + } |
|
1233 | 1231 | |
1234 | - $types = []; |
|
1232 | + $filters = $this->getPivotFilters($object, $remoteBean, $localFk, $remoteFk); |
|
1235 | 1233 | |
1236 | - foreach ($filters as $columnName => $value) { |
|
1237 | - $columnDescriptor = $tableDescriptor->getColumn($columnName); |
|
1238 | - $types[] = $columnDescriptor->getType(); |
|
1239 | - } |
|
1234 | + $types = []; |
|
1235 | + |
|
1236 | + foreach ($filters as $columnName => $value) { |
|
1237 | + $columnDescriptor = $tableDescriptor->getColumn($columnName); |
|
1238 | + $types[] = $columnDescriptor->getType(); |
|
1239 | + } |
|
1240 | 1240 | |
1241 | - $this->connection->insert($pivotTableName, $filters, $types); |
|
1241 | + $this->connection->insert($pivotTableName, $filters, $types); |
|
1242 | 1242 | |
1243 | - // Finally, let's mark relationships as saved. |
|
1244 | - $statusArr['status'] = 'loaded'; |
|
1245 | - $storage[$remoteBean] = $statusArr; |
|
1246 | - $remoteStorage = $remoteBean->_getCachedRelationships()[$pivotTableName]; |
|
1247 | - $remoteStatusArr = $remoteStorage[$object]; |
|
1248 | - $remoteStatusArr['status'] = 'loaded'; |
|
1249 | - $remoteStorage[$object] = $remoteStatusArr; |
|
1243 | + // Finally, let's mark relationships as saved. |
|
1244 | + $statusArr['status'] = 'loaded'; |
|
1245 | + $storage[$remoteBean] = $statusArr; |
|
1246 | + $remoteStorage = $remoteBean->_getCachedRelationships()[$pivotTableName]; |
|
1247 | + $remoteStatusArr = $remoteStorage[$object]; |
|
1248 | + $remoteStatusArr['status'] = 'loaded'; |
|
1249 | + $remoteStorage[$object] = $remoteStatusArr; |
|
1250 | 1250 | |
1251 | - } elseif ($status === 'delete') { |
|
1252 | - $filters = $this->getPivotFilters($object, $remoteBean, $localFk, $remoteFk); |
|
1251 | + } elseif ($status === 'delete') { |
|
1252 | + $filters = $this->getPivotFilters($object, $remoteBean, $localFk, $remoteFk); |
|
1253 | 1253 | |
1254 | - $types = []; |
|
1254 | + $types = []; |
|
1255 | 1255 | |
1256 | - foreach ($filters as $columnName => $value) { |
|
1257 | - $columnDescriptor = $tableDescriptor->getColumn($columnName); |
|
1258 | - $types[] = $columnDescriptor->getType(); |
|
1259 | - } |
|
1256 | + foreach ($filters as $columnName => $value) { |
|
1257 | + $columnDescriptor = $tableDescriptor->getColumn($columnName); |
|
1258 | + $types[] = $columnDescriptor->getType(); |
|
1259 | + } |
|
1260 | + |
|
1261 | + $this->connection->delete($pivotTableName, $filters, $types); |
|
1262 | + |
|
1263 | + // Finally, let's remove relationships completely from bean. |
|
1264 | + $storage->detach($remoteBean); |
|
1265 | + $remoteBean->_getCachedRelationships()[$pivotTableName]->detach($object); |
|
1266 | + } |
|
1267 | + } |
|
1268 | + } |
|
1269 | + } |
|
1260 | 1270 | |
1261 | - $this->connection->delete($pivotTableName, $filters, $types); |
|
1262 | - |
|
1263 | - // Finally, let's remove relationships completely from bean. |
|
1264 | - $storage->detach($remoteBean); |
|
1265 | - $remoteBean->_getCachedRelationships()[$pivotTableName]->detach($object); |
|
1266 | - } |
|
1267 | - } |
|
1268 | - } |
|
1269 | - } |
|
1270 | - |
|
1271 | - private function getPivotFilters(AbstractTDBMObject $localBean, AbstractTDBMObject $remoteBean, ForeignKeyConstraint $localFk, ForeignKeyConstraint $remoteFk) { |
|
1272 | - $localBeanPk = $this->getPrimaryKeyValues($localBean); |
|
1273 | - $remoteBeanPk = $this->getPrimaryKeyValues($remoteBean); |
|
1274 | - $localColumns = $localFk->getLocalColumns(); |
|
1275 | - $remoteColumns = $remoteFk->getLocalColumns(); |
|
1276 | - |
|
1277 | - $localFilters = array_combine($localColumns, $localBeanPk); |
|
1278 | - $remoteFilters = array_combine($remoteColumns, $remoteBeanPk); |
|
1279 | - |
|
1280 | - return array_merge($localFilters, $remoteFilters); |
|
1281 | - } |
|
1282 | - |
|
1283 | - /** |
|
1284 | - * Returns the "values" of the primary key. |
|
1285 | - * This returns the primary key from the $primaryKey attribute, not the one stored in the columns. |
|
1286 | - * |
|
1287 | - * @param AbstractTDBMObject $bean |
|
1288 | - * @return array numerically indexed array of values. |
|
1289 | - */ |
|
1290 | - private function getPrimaryKeyValues(AbstractTDBMObject $bean) { |
|
1291 | - $dbRows = $bean->_getDbRows(); |
|
1292 | - $dbRow = reset($dbRows); |
|
1293 | - return array_values($dbRow->_getPrimaryKeys()); |
|
1294 | - } |
|
1271 | + private function getPivotFilters(AbstractTDBMObject $localBean, AbstractTDBMObject $remoteBean, ForeignKeyConstraint $localFk, ForeignKeyConstraint $remoteFk) { |
|
1272 | + $localBeanPk = $this->getPrimaryKeyValues($localBean); |
|
1273 | + $remoteBeanPk = $this->getPrimaryKeyValues($remoteBean); |
|
1274 | + $localColumns = $localFk->getLocalColumns(); |
|
1275 | + $remoteColumns = $remoteFk->getLocalColumns(); |
|
1276 | + |
|
1277 | + $localFilters = array_combine($localColumns, $localBeanPk); |
|
1278 | + $remoteFilters = array_combine($remoteColumns, $remoteBeanPk); |
|
1279 | + |
|
1280 | + return array_merge($localFilters, $remoteFilters); |
|
1281 | + } |
|
1282 | + |
|
1283 | + /** |
|
1284 | + * Returns the "values" of the primary key. |
|
1285 | + * This returns the primary key from the $primaryKey attribute, not the one stored in the columns. |
|
1286 | + * |
|
1287 | + * @param AbstractTDBMObject $bean |
|
1288 | + * @return array numerically indexed array of values. |
|
1289 | + */ |
|
1290 | + private function getPrimaryKeyValues(AbstractTDBMObject $bean) { |
|
1291 | + $dbRows = $bean->_getDbRows(); |
|
1292 | + $dbRow = reset($dbRows); |
|
1293 | + return array_values($dbRow->_getPrimaryKeys()); |
|
1294 | + } |
|
1295 | 1295 | |
1296 | 1296 | /** |
1297 | 1297 | * Returns a unique hash used to store the object based on its primary key. |
@@ -1774,39 +1774,39 @@ discard block |
||
1774 | 1774 | */ |
1775 | 1775 | public function _getRelatedBeans($pivotTableName, AbstractTDBMObject $bean) { |
1776 | 1776 | |
1777 | - list($localFk, $remoteFk) = $this->getPivotTableForeignKeys($pivotTableName, $bean); |
|
1778 | - /* @var $localFk ForeignKeyConstraint */ |
|
1779 | - /* @var $remoteFk ForeignKeyConstraint */ |
|
1780 | - $remoteTable = $remoteFk->getForeignTableName(); |
|
1777 | + list($localFk, $remoteFk) = $this->getPivotTableForeignKeys($pivotTableName, $bean); |
|
1778 | + /* @var $localFk ForeignKeyConstraint */ |
|
1779 | + /* @var $remoteFk ForeignKeyConstraint */ |
|
1780 | + $remoteTable = $remoteFk->getForeignTableName(); |
|
1781 | 1781 | |
1782 | 1782 | |
1783 | - $primaryKeys = $this->getPrimaryKeyValues($bean); |
|
1784 | - $columnNames = array_map(function($name) use ($pivotTableName) { return $pivotTableName.'.'.$name; }, $localFk->getLocalColumns()); |
|
1783 | + $primaryKeys = $this->getPrimaryKeyValues($bean); |
|
1784 | + $columnNames = array_map(function($name) use ($pivotTableName) { return $pivotTableName.'.'.$name; }, $localFk->getLocalColumns()); |
|
1785 | 1785 | |
1786 | - $filter = array_combine($columnNames, $primaryKeys); |
|
1786 | + $filter = array_combine($columnNames, $primaryKeys); |
|
1787 | 1787 | |
1788 | - return $this->findObjects($remoteTable, $filter); |
|
1788 | + return $this->findObjects($remoteTable, $filter); |
|
1789 | 1789 | } |
1790 | 1790 | |
1791 | - /** |
|
1792 | - * @param $pivotTableName |
|
1793 | - * @param AbstractTDBMObject $bean The LOCAL bean |
|
1794 | - * @return ForeignKeyConstraint[] First item: the LOCAL bean, second item: the REMOTE bean. |
|
1795 | - * @throws TDBMException |
|
1796 | - */ |
|
1797 | - private function getPivotTableForeignKeys($pivotTableName, AbstractTDBMObject $bean) { |
|
1798 | - $fks = array_values($this->tdbmSchemaAnalyzer->getSchema()->getTable($pivotTableName)->getForeignKeys()); |
|
1799 | - $table1 = $fks[0]->getForeignTableName(); |
|
1800 | - $table2 = $fks[1]->getForeignTableName(); |
|
1801 | - |
|
1802 | - $beanTables = array_map(function(DbRow $dbRow) { return $dbRow->_getDbTableName(); }, $bean->_getDbRows()); |
|
1803 | - |
|
1804 | - if (in_array($table1, $beanTables)) { |
|
1805 | - return [$fks[0], $fks[1]]; |
|
1806 | - } elseif (in_array($table2, $beanTables)) { |
|
1807 | - return [$fks[1], $fks[0]]; |
|
1808 | - } else { |
|
1809 | - throw new TDBMException("Unexpected bean type in getPivotTableForeignKeys. Awaiting beans from table {$table1} and {$table2}"); |
|
1810 | - } |
|
1811 | - } |
|
1791 | + /** |
|
1792 | + * @param $pivotTableName |
|
1793 | + * @param AbstractTDBMObject $bean The LOCAL bean |
|
1794 | + * @return ForeignKeyConstraint[] First item: the LOCAL bean, second item: the REMOTE bean. |
|
1795 | + * @throws TDBMException |
|
1796 | + */ |
|
1797 | + private function getPivotTableForeignKeys($pivotTableName, AbstractTDBMObject $bean) { |
|
1798 | + $fks = array_values($this->tdbmSchemaAnalyzer->getSchema()->getTable($pivotTableName)->getForeignKeys()); |
|
1799 | + $table1 = $fks[0]->getForeignTableName(); |
|
1800 | + $table2 = $fks[1]->getForeignTableName(); |
|
1801 | + |
|
1802 | + $beanTables = array_map(function(DbRow $dbRow) { return $dbRow->_getDbTableName(); }, $bean->_getDbRows()); |
|
1803 | + |
|
1804 | + if (in_array($table1, $beanTables)) { |
|
1805 | + return [$fks[0], $fks[1]]; |
|
1806 | + } elseif (in_array($table2, $beanTables)) { |
|
1807 | + return [$fks[1], $fks[0]]; |
|
1808 | + } else { |
|
1809 | + throw new TDBMException("Unexpected bean type in getPivotTableForeignKeys. Awaiting beans from table {$table1} and {$table2}"); |
|
1810 | + } |
|
1811 | + } |
|
1812 | 1812 | } |
@@ -35,117 +35,117 @@ |
||
35 | 35 | class TDBMObject extends AbstractTDBMObject implements \ArrayAccess, \Iterator |
36 | 36 | { |
37 | 37 | |
38 | - public function __get($var) |
|
39 | - { |
|
40 | - return $this->get($var); |
|
41 | - } |
|
42 | - |
|
43 | - /** |
|
44 | - * Returns true if a column is set, false otherwise. |
|
45 | - * |
|
46 | - * @param string $var |
|
47 | - * @return boolean |
|
48 | - */ |
|
49 | - public function __isset($var) |
|
50 | - { |
|
51 | - return $this->has($var); |
|
52 | - } |
|
53 | - |
|
54 | - public function __set($var, $value) |
|
55 | - { |
|
56 | - $this->set($var, $value); |
|
57 | - } |
|
58 | - |
|
59 | - /** |
|
60 | - * Implements array behaviour for our object. |
|
61 | - * |
|
62 | - * @param string $offset |
|
63 | - * @param string $value |
|
64 | - */ |
|
65 | - public function offsetSet($offset, $value) |
|
66 | - { |
|
67 | - $this->__set($offset, $value); |
|
68 | - } |
|
69 | - |
|
70 | - /** |
|
71 | - * Implements array behaviour for our object. |
|
72 | - * |
|
73 | - * @param string $offset |
|
74 | - * @return bool |
|
75 | - */ |
|
76 | - public function offsetExists($offset) |
|
77 | - { |
|
78 | - $this->_dbLoadIfNotLoaded(); |
|
79 | - return isset($this->dbRow[$offset]); |
|
80 | - } |
|
81 | - |
|
82 | - /** |
|
83 | - * Implements array behaviour for our object. |
|
84 | - * |
|
85 | - * @param string $offset |
|
86 | - */ |
|
87 | - public function offsetUnset($offset) |
|
88 | - { |
|
89 | - $this->__set($offset, null); |
|
90 | - } |
|
91 | - |
|
92 | - /** |
|
93 | - * Implements array behaviour for our object. |
|
94 | - * |
|
95 | - * @param string $offset |
|
96 | - * @return mixed|null |
|
97 | - */ |
|
98 | - public function offsetGet($offset) |
|
99 | - { |
|
100 | - return $this->__get($offset); |
|
101 | - } |
|
102 | - |
|
103 | - private $_validIterator = false; |
|
104 | - |
|
105 | - /** |
|
106 | - * Implements iterator behaviour for our object (so we can each column). |
|
107 | - */ |
|
108 | - public function rewind() |
|
109 | - { |
|
110 | - $this->_dbLoadIfNotLoaded(); |
|
111 | - if (count($this->dbRow) > 0) { |
|
112 | - $this->_validIterator = true; |
|
113 | - } else { |
|
114 | - $this->_validIterator = false; |
|
115 | - } |
|
116 | - reset($this->dbRow); |
|
117 | - } |
|
118 | - |
|
119 | - /** |
|
120 | - * Implements iterator behaviour for our object (so we can each column). |
|
121 | - */ |
|
122 | - public function next() |
|
123 | - { |
|
124 | - $val = next($this->dbRow); |
|
125 | - $this->_validIterator = !($val === false); |
|
126 | - } |
|
127 | - |
|
128 | - /** |
|
129 | - * Implements iterator behaviour for our object (so we can each column). |
|
130 | - */ |
|
131 | - public function key() |
|
132 | - { |
|
133 | - return key($this->dbRow); |
|
134 | - } |
|
135 | - |
|
136 | - /** |
|
137 | - * Implements iterator behaviour for our object (so we can each column). |
|
138 | - */ |
|
139 | - public function current() |
|
140 | - { |
|
141 | - return current($this->dbRow); |
|
142 | - } |
|
143 | - |
|
144 | - /** |
|
145 | - * Implements iterator behaviour for our object (so we can each column). |
|
146 | - */ |
|
147 | - public function valid() |
|
148 | - { |
|
149 | - return $this->_validIterator; |
|
150 | - } |
|
38 | + public function __get($var) |
|
39 | + { |
|
40 | + return $this->get($var); |
|
41 | + } |
|
42 | + |
|
43 | + /** |
|
44 | + * Returns true if a column is set, false otherwise. |
|
45 | + * |
|
46 | + * @param string $var |
|
47 | + * @return boolean |
|
48 | + */ |
|
49 | + public function __isset($var) |
|
50 | + { |
|
51 | + return $this->has($var); |
|
52 | + } |
|
53 | + |
|
54 | + public function __set($var, $value) |
|
55 | + { |
|
56 | + $this->set($var, $value); |
|
57 | + } |
|
58 | + |
|
59 | + /** |
|
60 | + * Implements array behaviour for our object. |
|
61 | + * |
|
62 | + * @param string $offset |
|
63 | + * @param string $value |
|
64 | + */ |
|
65 | + public function offsetSet($offset, $value) |
|
66 | + { |
|
67 | + $this->__set($offset, $value); |
|
68 | + } |
|
69 | + |
|
70 | + /** |
|
71 | + * Implements array behaviour for our object. |
|
72 | + * |
|
73 | + * @param string $offset |
|
74 | + * @return bool |
|
75 | + */ |
|
76 | + public function offsetExists($offset) |
|
77 | + { |
|
78 | + $this->_dbLoadIfNotLoaded(); |
|
79 | + return isset($this->dbRow[$offset]); |
|
80 | + } |
|
81 | + |
|
82 | + /** |
|
83 | + * Implements array behaviour for our object. |
|
84 | + * |
|
85 | + * @param string $offset |
|
86 | + */ |
|
87 | + public function offsetUnset($offset) |
|
88 | + { |
|
89 | + $this->__set($offset, null); |
|
90 | + } |
|
91 | + |
|
92 | + /** |
|
93 | + * Implements array behaviour for our object. |
|
94 | + * |
|
95 | + * @param string $offset |
|
96 | + * @return mixed|null |
|
97 | + */ |
|
98 | + public function offsetGet($offset) |
|
99 | + { |
|
100 | + return $this->__get($offset); |
|
101 | + } |
|
102 | + |
|
103 | + private $_validIterator = false; |
|
104 | + |
|
105 | + /** |
|
106 | + * Implements iterator behaviour for our object (so we can each column). |
|
107 | + */ |
|
108 | + public function rewind() |
|
109 | + { |
|
110 | + $this->_dbLoadIfNotLoaded(); |
|
111 | + if (count($this->dbRow) > 0) { |
|
112 | + $this->_validIterator = true; |
|
113 | + } else { |
|
114 | + $this->_validIterator = false; |
|
115 | + } |
|
116 | + reset($this->dbRow); |
|
117 | + } |
|
118 | + |
|
119 | + /** |
|
120 | + * Implements iterator behaviour for our object (so we can each column). |
|
121 | + */ |
|
122 | + public function next() |
|
123 | + { |
|
124 | + $val = next($this->dbRow); |
|
125 | + $this->_validIterator = !($val === false); |
|
126 | + } |
|
127 | + |
|
128 | + /** |
|
129 | + * Implements iterator behaviour for our object (so we can each column). |
|
130 | + */ |
|
131 | + public function key() |
|
132 | + { |
|
133 | + return key($this->dbRow); |
|
134 | + } |
|
135 | + |
|
136 | + /** |
|
137 | + * Implements iterator behaviour for our object (so we can each column). |
|
138 | + */ |
|
139 | + public function current() |
|
140 | + { |
|
141 | + return current($this->dbRow); |
|
142 | + } |
|
143 | + |
|
144 | + /** |
|
145 | + * Implements iterator behaviour for our object (so we can each column). |
|
146 | + */ |
|
147 | + public function valid() |
|
148 | + { |
|
149 | + return $this->_validIterator; |
|
150 | + } |
|
151 | 151 | } |
152 | 152 | \ No newline at end of file |
@@ -15,96 +15,96 @@ |
||
15 | 15 | class TDBMSchemaAnalyzer |
16 | 16 | { |
17 | 17 | |
18 | - private $connection; |
|
18 | + private $connection; |
|
19 | 19 | |
20 | - /** |
|
21 | - * @var Schema |
|
22 | - */ |
|
23 | - private $schema; |
|
20 | + /** |
|
21 | + * @var Schema |
|
22 | + */ |
|
23 | + private $schema; |
|
24 | 24 | |
25 | - /** |
|
26 | - * @var string |
|
27 | - */ |
|
28 | - private $cachePrefix; |
|
25 | + /** |
|
26 | + * @var string |
|
27 | + */ |
|
28 | + private $cachePrefix; |
|
29 | 29 | |
30 | - /** |
|
31 | - * @var Cache |
|
32 | - */ |
|
33 | - private $cache; |
|
30 | + /** |
|
31 | + * @var Cache |
|
32 | + */ |
|
33 | + private $cache; |
|
34 | 34 | |
35 | - /** |
|
36 | - * @var SchemaAnalyzer |
|
37 | - */ |
|
38 | - private $schemaAnalyzer; |
|
35 | + /** |
|
36 | + * @var SchemaAnalyzer |
|
37 | + */ |
|
38 | + private $schemaAnalyzer; |
|
39 | 39 | |
40 | - /** |
|
41 | - * @param Connection $connection The DBAL DB connection to use |
|
42 | - * @param Cache $cache A cache service to be used |
|
43 | - * @param SchemaAnalyzer $schemaAnalyzer The schema analyzer that will be used to find shortest paths... |
|
44 | - * Will be automatically created if not passed. |
|
45 | - */ |
|
46 | - public function __construct(Connection $connection, Cache $cache, SchemaAnalyzer $schemaAnalyzer) { |
|
47 | - $this->connection = $connection; |
|
48 | - $this->cache = $cache; |
|
49 | - $this->schemaAnalyzer = $schemaAnalyzer; |
|
50 | - } |
|
40 | + /** |
|
41 | + * @param Connection $connection The DBAL DB connection to use |
|
42 | + * @param Cache $cache A cache service to be used |
|
43 | + * @param SchemaAnalyzer $schemaAnalyzer The schema analyzer that will be used to find shortest paths... |
|
44 | + * Will be automatically created if not passed. |
|
45 | + */ |
|
46 | + public function __construct(Connection $connection, Cache $cache, SchemaAnalyzer $schemaAnalyzer) { |
|
47 | + $this->connection = $connection; |
|
48 | + $this->cache = $cache; |
|
49 | + $this->schemaAnalyzer = $schemaAnalyzer; |
|
50 | + } |
|
51 | 51 | |
52 | - /** |
|
53 | - * Returns a unique ID for the current connection. Useful for namespacing cache entries in the current connection. |
|
54 | - * @return string |
|
55 | - */ |
|
56 | - public function getCachePrefix() { |
|
57 | - if ($this->cachePrefix === null) { |
|
58 | - $this->cachePrefix = hash('md4', $this->connection->getHost()."-".$this->connection->getPort()."-".$this->connection->getDatabase()."-".$this->connection->getDriver()->getName()); |
|
59 | - } |
|
60 | - return $this->cachePrefix; |
|
61 | - } |
|
52 | + /** |
|
53 | + * Returns a unique ID for the current connection. Useful for namespacing cache entries in the current connection. |
|
54 | + * @return string |
|
55 | + */ |
|
56 | + public function getCachePrefix() { |
|
57 | + if ($this->cachePrefix === null) { |
|
58 | + $this->cachePrefix = hash('md4', $this->connection->getHost()."-".$this->connection->getPort()."-".$this->connection->getDatabase()."-".$this->connection->getDriver()->getName()); |
|
59 | + } |
|
60 | + return $this->cachePrefix; |
|
61 | + } |
|
62 | 62 | |
63 | - /** |
|
64 | - * Returns the (cached) schema. |
|
65 | - * |
|
66 | - * @return Schema |
|
67 | - */ |
|
68 | - public function getSchema() { |
|
69 | - if ($this->schema === null) { |
|
70 | - $cacheKey = $this->getCachePrefix().'_schema'; |
|
71 | - if ($this->cache->contains($cacheKey)) { |
|
72 | - $this->schema = $this->cache->fetch($cacheKey); |
|
73 | - } else { |
|
74 | - $this->schema = $this->connection->getSchemaManager()->createSchema(); |
|
75 | - $this->cache->save($cacheKey, $this->schema); |
|
76 | - } |
|
77 | - } |
|
78 | - return $this->schema; |
|
79 | - } |
|
63 | + /** |
|
64 | + * Returns the (cached) schema. |
|
65 | + * |
|
66 | + * @return Schema |
|
67 | + */ |
|
68 | + public function getSchema() { |
|
69 | + if ($this->schema === null) { |
|
70 | + $cacheKey = $this->getCachePrefix().'_schema'; |
|
71 | + if ($this->cache->contains($cacheKey)) { |
|
72 | + $this->schema = $this->cache->fetch($cacheKey); |
|
73 | + } else { |
|
74 | + $this->schema = $this->connection->getSchemaManager()->createSchema(); |
|
75 | + $this->cache->save($cacheKey, $this->schema); |
|
76 | + } |
|
77 | + } |
|
78 | + return $this->schema; |
|
79 | + } |
|
80 | 80 | |
81 | - /** |
|
82 | - * Returns the list of pivot tables linked to table $tableName |
|
83 | - * @param string $tableName |
|
84 | - * @return array|string[] |
|
85 | - */ |
|
86 | - public function getPivotTableLinkedToTable($tableName) { |
|
87 | - $cacheKey = $this->getCachePrefix().'_pivottables_link'; |
|
88 | - if ($this->cache->contains($cacheKey)) { |
|
89 | - return $this->cache->fetch($cacheKey); |
|
90 | - } |
|
81 | + /** |
|
82 | + * Returns the list of pivot tables linked to table $tableName |
|
83 | + * @param string $tableName |
|
84 | + * @return array|string[] |
|
85 | + */ |
|
86 | + public function getPivotTableLinkedToTable($tableName) { |
|
87 | + $cacheKey = $this->getCachePrefix().'_pivottables_link'; |
|
88 | + if ($this->cache->contains($cacheKey)) { |
|
89 | + return $this->cache->fetch($cacheKey); |
|
90 | + } |
|
91 | 91 | |
92 | - $pivotTables = []; |
|
92 | + $pivotTables = []; |
|
93 | 93 | |
94 | - $junctionTables = $this->schemaAnalyzer->detectJunctionTables(); |
|
95 | - foreach ($junctionTables as $table) { |
|
96 | - $fks = $table->getForeignKeys(); |
|
97 | - foreach ($fks as $fk) { |
|
98 | - if ($fk->getForeignTableName() == $tableName) { |
|
99 | - $pivotTables[] = $table->getName(); |
|
100 | - break; |
|
101 | - } |
|
102 | - } |
|
103 | - } |
|
94 | + $junctionTables = $this->schemaAnalyzer->detectJunctionTables(); |
|
95 | + foreach ($junctionTables as $table) { |
|
96 | + $fks = $table->getForeignKeys(); |
|
97 | + foreach ($fks as $fk) { |
|
98 | + if ($fk->getForeignTableName() == $tableName) { |
|
99 | + $pivotTables[] = $table->getName(); |
|
100 | + break; |
|
101 | + } |
|
102 | + } |
|
103 | + } |
|
104 | 104 | |
105 | - $this->cache->save($cacheKey, $pivotTables); |
|
106 | - return $pivotTables; |
|
107 | - } |
|
105 | + $this->cache->save($cacheKey, $pivotTables); |
|
106 | + return $pivotTables; |
|
107 | + } |
|
108 | 108 | |
109 | 109 | |
110 | 110 | } |
@@ -14,122 +14,122 @@ discard block |
||
14 | 14 | class ObjectBeanPropertyDescriptor extends AbstractBeanPropertyDescriptor |
15 | 15 | { |
16 | 16 | |
17 | - /** |
|
18 | - * @var ForeignKeyConstraint |
|
19 | - */ |
|
20 | - private $foreignKey; |
|
21 | - |
|
22 | - /** |
|
23 | - * @var SchemaAnalyzer |
|
24 | - */ |
|
25 | - private $schemaAnalyzer; |
|
26 | - |
|
27 | - public function __construct(Table $table, ForeignKeyConstraint $foreignKey, SchemaAnalyzer $schemaAnalyzer) { |
|
28 | - parent::__construct($table); |
|
29 | - $this->foreignKey = $foreignKey; |
|
30 | - $this->schemaAnalyzer = $schemaAnalyzer; |
|
31 | - } |
|
32 | - |
|
33 | - |
|
34 | - |
|
35 | - /** |
|
36 | - * Returns the foreignkey the column is part of, if any. null otherwise. |
|
37 | - * |
|
38 | - * @return ForeignKeyConstraint|null |
|
39 | - */ |
|
40 | - public function getForeignKey() { |
|
41 | - return $this->foreignKey; |
|
42 | - } |
|
43 | - |
|
44 | - /** |
|
45 | - * Returns the name of the class linked to this property or null if this is not a foreign key |
|
46 | - * @return null|string |
|
47 | - */ |
|
48 | - public function getClassName() { |
|
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 | - $str = " * @param %s %s"; |
|
59 | - return sprintf($str, $this->getClassName(), $this->getVariableName()); |
|
60 | - } |
|
61 | - |
|
62 | - public function getUpperCamelCaseName() { |
|
63 | - // First, are there many column or only one? |
|
64 | - // If one column, we name the setter after it. Otherwise, we name the setter after the table name |
|
65 | - if (count($this->foreignKey->getLocalColumns()) > 1) { |
|
66 | - $name = TDBMDaoGenerator::toSingular(TDBMDaoGenerator::toCamelCase($this->foreignKey->getForeignTableName())); |
|
67 | - if ($this->alternativeName) { |
|
68 | - $camelizedColumns = array_map(['Mouf\\Database\\TDBM\\Utils\\TDBMDaoGenerator', 'toCamelCase'], $this->foreignKey->getLocalColumns()); |
|
69 | - |
|
70 | - $name .= 'By'.implode('And', $camelizedColumns); |
|
71 | - } |
|
72 | - } else { |
|
73 | - $column = $this->foreignKey->getLocalColumns()[0]; |
|
74 | - // Let's remove any _id or id_. |
|
75 | - if (strpos(strtolower($column), "id_") === 0) { |
|
76 | - $column = substr($column, 3); |
|
77 | - } |
|
78 | - if (strrpos(strtolower($column), "_id") === strlen($column)-3) { |
|
79 | - $column = substr($column, 0, strlen($column)-3); |
|
80 | - } |
|
81 | - $name = TDBMDaoGenerator::toCamelCase($column); |
|
82 | - if ($this->alternativeName) { |
|
83 | - $name .= 'Object'; |
|
84 | - } |
|
85 | - } |
|
86 | - return $name; |
|
87 | - } |
|
88 | - |
|
89 | - /** |
|
90 | - * Returns true if the property is compulsory (and therefore should be fetched in the constructor). |
|
91 | - * @return bool |
|
92 | - */ |
|
93 | - public function isCompulsory() { |
|
94 | - // Are all columns nullable? |
|
95 | - $localColumnNames = $this->foreignKey->getLocalColumns(); |
|
96 | - |
|
97 | - foreach ($localColumnNames as $name) { |
|
98 | - $column = $this->table->getColumn($name); |
|
99 | - if ($column->getNotnull()) { |
|
100 | - return true; |
|
101 | - } |
|
102 | - } |
|
103 | - |
|
104 | - return false; |
|
105 | - } |
|
106 | - |
|
107 | - /** |
|
108 | - * Returns true if the property is the primary key |
|
109 | - * @return bool |
|
110 | - */ |
|
111 | - public function isPrimaryKey() { |
|
112 | - $fkColumns = $this->foreignKey->getLocalColumns(); |
|
113 | - sort($fkColumns); |
|
114 | - |
|
115 | - $pkColumns = $this->table->getPrimaryKeyColumns(); |
|
116 | - sort($pkColumns); |
|
117 | - |
|
118 | - return $fkColumns == $pkColumns; |
|
119 | - } |
|
120 | - |
|
121 | - /** |
|
122 | - * Returns the PHP code for getters and setters |
|
123 | - * @return string |
|
124 | - */ |
|
125 | - public function getGetterSetterCode() { |
|
126 | - $tableName = $this->table->getName(); |
|
127 | - $getterName = $this->getGetterName(); |
|
128 | - $setterName = $this->getSetterName(); |
|
129 | - |
|
130 | - $referencedBeanName = TDBMDaoGenerator::getBeanNameFromTableName($this->foreignKey->getForeignTableName()); |
|
131 | - |
|
132 | - $str = ' /** |
|
17 | + /** |
|
18 | + * @var ForeignKeyConstraint |
|
19 | + */ |
|
20 | + private $foreignKey; |
|
21 | + |
|
22 | + /** |
|
23 | + * @var SchemaAnalyzer |
|
24 | + */ |
|
25 | + private $schemaAnalyzer; |
|
26 | + |
|
27 | + public function __construct(Table $table, ForeignKeyConstraint $foreignKey, SchemaAnalyzer $schemaAnalyzer) { |
|
28 | + parent::__construct($table); |
|
29 | + $this->foreignKey = $foreignKey; |
|
30 | + $this->schemaAnalyzer = $schemaAnalyzer; |
|
31 | + } |
|
32 | + |
|
33 | + |
|
34 | + |
|
35 | + /** |
|
36 | + * Returns the foreignkey the column is part of, if any. null otherwise. |
|
37 | + * |
|
38 | + * @return ForeignKeyConstraint|null |
|
39 | + */ |
|
40 | + public function getForeignKey() { |
|
41 | + return $this->foreignKey; |
|
42 | + } |
|
43 | + |
|
44 | + /** |
|
45 | + * Returns the name of the class linked to this property or null if this is not a foreign key |
|
46 | + * @return null|string |
|
47 | + */ |
|
48 | + public function getClassName() { |
|
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 | + $str = " * @param %s %s"; |
|
59 | + return sprintf($str, $this->getClassName(), $this->getVariableName()); |
|
60 | + } |
|
61 | + |
|
62 | + public function getUpperCamelCaseName() { |
|
63 | + // First, are there many column or only one? |
|
64 | + // If one column, we name the setter after it. Otherwise, we name the setter after the table name |
|
65 | + if (count($this->foreignKey->getLocalColumns()) > 1) { |
|
66 | + $name = TDBMDaoGenerator::toSingular(TDBMDaoGenerator::toCamelCase($this->foreignKey->getForeignTableName())); |
|
67 | + if ($this->alternativeName) { |
|
68 | + $camelizedColumns = array_map(['Mouf\\Database\\TDBM\\Utils\\TDBMDaoGenerator', 'toCamelCase'], $this->foreignKey->getLocalColumns()); |
|
69 | + |
|
70 | + $name .= 'By'.implode('And', $camelizedColumns); |
|
71 | + } |
|
72 | + } else { |
|
73 | + $column = $this->foreignKey->getLocalColumns()[0]; |
|
74 | + // Let's remove any _id or id_. |
|
75 | + if (strpos(strtolower($column), "id_") === 0) { |
|
76 | + $column = substr($column, 3); |
|
77 | + } |
|
78 | + if (strrpos(strtolower($column), "_id") === strlen($column)-3) { |
|
79 | + $column = substr($column, 0, strlen($column)-3); |
|
80 | + } |
|
81 | + $name = TDBMDaoGenerator::toCamelCase($column); |
|
82 | + if ($this->alternativeName) { |
|
83 | + $name .= 'Object'; |
|
84 | + } |
|
85 | + } |
|
86 | + return $name; |
|
87 | + } |
|
88 | + |
|
89 | + /** |
|
90 | + * Returns true if the property is compulsory (and therefore should be fetched in the constructor). |
|
91 | + * @return bool |
|
92 | + */ |
|
93 | + public function isCompulsory() { |
|
94 | + // Are all columns nullable? |
|
95 | + $localColumnNames = $this->foreignKey->getLocalColumns(); |
|
96 | + |
|
97 | + foreach ($localColumnNames as $name) { |
|
98 | + $column = $this->table->getColumn($name); |
|
99 | + if ($column->getNotnull()) { |
|
100 | + return true; |
|
101 | + } |
|
102 | + } |
|
103 | + |
|
104 | + return false; |
|
105 | + } |
|
106 | + |
|
107 | + /** |
|
108 | + * Returns true if the property is the primary key |
|
109 | + * @return bool |
|
110 | + */ |
|
111 | + public function isPrimaryKey() { |
|
112 | + $fkColumns = $this->foreignKey->getLocalColumns(); |
|
113 | + sort($fkColumns); |
|
114 | + |
|
115 | + $pkColumns = $this->table->getPrimaryKeyColumns(); |
|
116 | + sort($pkColumns); |
|
117 | + |
|
118 | + return $fkColumns == $pkColumns; |
|
119 | + } |
|
120 | + |
|
121 | + /** |
|
122 | + * Returns the PHP code for getters and setters |
|
123 | + * @return string |
|
124 | + */ |
|
125 | + public function getGetterSetterCode() { |
|
126 | + $tableName = $this->table->getName(); |
|
127 | + $getterName = $this->getGetterName(); |
|
128 | + $setterName = $this->getSetterName(); |
|
129 | + |
|
130 | + $referencedBeanName = TDBMDaoGenerator::getBeanNameFromTableName($this->foreignKey->getForeignTableName()); |
|
131 | + |
|
132 | + $str = ' /** |
|
133 | 133 | * Returns the '.$referencedBeanName.' object bound to this object via the '.implode(" and ", $this->foreignKey->getLocalColumns()).' column. |
134 | 134 | * |
135 | 135 | * @return '.$referencedBeanName.' |
@@ -148,6 +148,6 @@ discard block |
||
148 | 148 | } |
149 | 149 | |
150 | 150 | '; |
151 | - return $str; |
|
152 | - } |
|
151 | + return $str; |
|
152 | + } |
|
153 | 153 | } |