@@ -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 | } |