@@ -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 | } |
@@ -12,88 +12,88 @@ discard block |
||
12 | 12 | */ |
13 | 13 | class ScalarBeanPropertyDescriptor extends AbstractBeanPropertyDescriptor |
14 | 14 | { |
15 | - /** |
|
16 | - * @var Column |
|
17 | - */ |
|
18 | - private $column; |
|
19 | - |
|
20 | - |
|
21 | - public function __construct(Table $table, Column $column) { |
|
22 | - parent::__construct($table); |
|
23 | - $this->table = $table; |
|
24 | - $this->column = $column; |
|
25 | - } |
|
26 | - |
|
27 | - /** |
|
28 | - * Returns the foreignkey the column is part of, if any. null otherwise. |
|
29 | - * |
|
30 | - * @param Column $column |
|
31 | - * @return ForeignKeyConstraint|null |
|
32 | - */ |
|
33 | - public function getForeignKey() { |
|
34 | - return false; |
|
35 | - } |
|
36 | - |
|
37 | - /** |
|
38 | - * Returns the param annotation for this property (useful for constructor). |
|
39 | - * |
|
40 | - * @return string |
|
41 | - */ |
|
42 | - public function getParamAnnotation() { |
|
43 | - $className = $this->getClassName(); |
|
44 | - $paramType = $className ?: TDBMDaoGenerator::dbalTypeToPhpType($this->column->getType()); |
|
45 | - |
|
46 | - $str = " * @param %s %s"; |
|
47 | - return sprintf($str, $paramType, $this->getVariableName()); |
|
48 | - } |
|
49 | - |
|
50 | - public function getUpperCamelCaseName() { |
|
51 | - return TDBMDaoGenerator::toCamelCase($this->column->getName()); |
|
52 | - } |
|
53 | - |
|
54 | - /** |
|
55 | - * Returns the name of the class linked to this property or null if this is not a foreign key |
|
56 | - * @return null|string |
|
57 | - */ |
|
58 | - public function getClassName() { |
|
59 | - return null; |
|
60 | - } |
|
61 | - |
|
62 | - /** |
|
63 | - * Returns true if the property is compulsory (and therefore should be fetched in the constructor). |
|
64 | - * @return bool |
|
65 | - */ |
|
66 | - public function isCompulsory() { |
|
67 | - return $this->column->getNotnull() && !$this->column->getAutoincrement(); |
|
68 | - } |
|
69 | - |
|
70 | - /** |
|
71 | - * Returns true if the property is the primary key |
|
72 | - * @return bool |
|
73 | - */ |
|
74 | - public function isPrimaryKey() { |
|
75 | - return in_array($this->column->getName(), $this->table->getPrimaryKeyColumns()); |
|
76 | - } |
|
77 | - |
|
78 | - /** |
|
79 | - * Returns the PHP code for getters and setters |
|
80 | - * @return string |
|
81 | - */ |
|
82 | - public function getGetterSetterCode() { |
|
83 | - |
|
84 | - $type = $this->column->getType(); |
|
85 | - $normalizedType = TDBMDaoGenerator::dbalTypeToPhpType($type); |
|
86 | - |
|
87 | - $columnGetterName = $this->getGetterName(); |
|
88 | - $columnSetterName = $this->getSetterName(); |
|
89 | - |
|
90 | - if ($normalizedType == "\\DateTimeInterface") { |
|
91 | - $castTo = "\\DateTimeInterface "; |
|
92 | - } else { |
|
93 | - $castTo = ""; |
|
94 | - } |
|
95 | - |
|
96 | - $getterAndSetterCode = ' /** |
|
15 | + /** |
|
16 | + * @var Column |
|
17 | + */ |
|
18 | + private $column; |
|
19 | + |
|
20 | + |
|
21 | + public function __construct(Table $table, Column $column) { |
|
22 | + parent::__construct($table); |
|
23 | + $this->table = $table; |
|
24 | + $this->column = $column; |
|
25 | + } |
|
26 | + |
|
27 | + /** |
|
28 | + * Returns the foreignkey the column is part of, if any. null otherwise. |
|
29 | + * |
|
30 | + * @param Column $column |
|
31 | + * @return ForeignKeyConstraint|null |
|
32 | + */ |
|
33 | + public function getForeignKey() { |
|
34 | + return false; |
|
35 | + } |
|
36 | + |
|
37 | + /** |
|
38 | + * Returns the param annotation for this property (useful for constructor). |
|
39 | + * |
|
40 | + * @return string |
|
41 | + */ |
|
42 | + public function getParamAnnotation() { |
|
43 | + $className = $this->getClassName(); |
|
44 | + $paramType = $className ?: TDBMDaoGenerator::dbalTypeToPhpType($this->column->getType()); |
|
45 | + |
|
46 | + $str = " * @param %s %s"; |
|
47 | + return sprintf($str, $paramType, $this->getVariableName()); |
|
48 | + } |
|
49 | + |
|
50 | + public function getUpperCamelCaseName() { |
|
51 | + return TDBMDaoGenerator::toCamelCase($this->column->getName()); |
|
52 | + } |
|
53 | + |
|
54 | + /** |
|
55 | + * Returns the name of the class linked to this property or null if this is not a foreign key |
|
56 | + * @return null|string |
|
57 | + */ |
|
58 | + public function getClassName() { |
|
59 | + return null; |
|
60 | + } |
|
61 | + |
|
62 | + /** |
|
63 | + * Returns true if the property is compulsory (and therefore should be fetched in the constructor). |
|
64 | + * @return bool |
|
65 | + */ |
|
66 | + public function isCompulsory() { |
|
67 | + return $this->column->getNotnull() && !$this->column->getAutoincrement(); |
|
68 | + } |
|
69 | + |
|
70 | + /** |
|
71 | + * Returns true if the property is the primary key |
|
72 | + * @return bool |
|
73 | + */ |
|
74 | + public function isPrimaryKey() { |
|
75 | + return in_array($this->column->getName(), $this->table->getPrimaryKeyColumns()); |
|
76 | + } |
|
77 | + |
|
78 | + /** |
|
79 | + * Returns the PHP code for getters and setters |
|
80 | + * @return string |
|
81 | + */ |
|
82 | + public function getGetterSetterCode() { |
|
83 | + |
|
84 | + $type = $this->column->getType(); |
|
85 | + $normalizedType = TDBMDaoGenerator::dbalTypeToPhpType($type); |
|
86 | + |
|
87 | + $columnGetterName = $this->getGetterName(); |
|
88 | + $columnSetterName = $this->getSetterName(); |
|
89 | + |
|
90 | + if ($normalizedType == "\\DateTimeInterface") { |
|
91 | + $castTo = "\\DateTimeInterface "; |
|
92 | + } else { |
|
93 | + $castTo = ""; |
|
94 | + } |
|
95 | + |
|
96 | + $getterAndSetterCode = ' /** |
|
97 | 97 | * The getter for the "%s" column. |
98 | 98 | * |
99 | 99 | * @return %s |
@@ -112,23 +112,23 @@ discard block |
||
112 | 112 | } |
113 | 113 | |
114 | 114 | '; |
115 | - return sprintf($getterAndSetterCode, |
|
116 | - // Getter |
|
117 | - $this->column->getName(), |
|
118 | - $normalizedType, |
|
119 | - $columnGetterName, |
|
120 | - var_export($this->column->getName(), true), |
|
121 | - var_export($this->table->getName(), true), |
|
122 | - // Setter |
|
123 | - $this->column->getName(), |
|
124 | - $normalizedType, |
|
125 | - $this->column->getName(), |
|
126 | - $columnSetterName, |
|
127 | - $castTo, |
|
128 | - $this->column->getName(), |
|
129 | - var_export($this->column->getName(), true), |
|
130 | - $this->column->getName(), |
|
131 | - var_export($this->table->getName(), true) |
|
132 | - ); |
|
133 | - } |
|
115 | + return sprintf($getterAndSetterCode, |
|
116 | + // Getter |
|
117 | + $this->column->getName(), |
|
118 | + $normalizedType, |
|
119 | + $columnGetterName, |
|
120 | + var_export($this->column->getName(), true), |
|
121 | + var_export($this->table->getName(), true), |
|
122 | + // Setter |
|
123 | + $this->column->getName(), |
|
124 | + $normalizedType, |
|
125 | + $this->column->getName(), |
|
126 | + $columnSetterName, |
|
127 | + $castTo, |
|
128 | + $this->column->getName(), |
|
129 | + var_export($this->column->getName(), true), |
|
130 | + $this->column->getName(), |
|
131 | + var_export($this->table->getName(), true) |
|
132 | + ); |
|
133 | + } |
|
134 | 134 | } |
@@ -15,232 +15,232 @@ discard block |
||
15 | 15 | */ |
16 | 16 | class BeanDescriptor |
17 | 17 | { |
18 | - /** |
|
19 | - * @var Table |
|
20 | - */ |
|
21 | - private $table; |
|
22 | - |
|
23 | - /** |
|
24 | - * @var SchemaAnalyzer |
|
25 | - */ |
|
26 | - private $schemaAnalyzer; |
|
27 | - |
|
28 | - /** |
|
29 | - * @var Schema |
|
30 | - */ |
|
31 | - private $schema; |
|
32 | - |
|
33 | - /** |
|
34 | - * @var AbstractBeanPropertyDescriptor[] |
|
35 | - */ |
|
36 | - private $beanPropertyDescriptors = []; |
|
37 | - |
|
38 | - public function __construct(Table $table, SchemaAnalyzer $schemaAnalyzer, Schema $schema) { |
|
39 | - $this->table = $table; |
|
40 | - $this->schemaAnalyzer = $schemaAnalyzer; |
|
41 | - $this->schema = $schema; |
|
42 | - $this->initBeanPropertyDescriptors(); |
|
43 | - } |
|
44 | - |
|
45 | - private function initBeanPropertyDescriptors() { |
|
46 | - $this->beanPropertyDescriptors = $this->getProperties($this->table); |
|
47 | - } |
|
48 | - |
|
49 | - /** |
|
50 | - * Returns the foreignkey the column is part of, if any. null otherwise. |
|
51 | - * |
|
52 | - * @param Table $table |
|
53 | - * @param Column $column |
|
54 | - * @return ForeignKeyConstraint|null |
|
55 | - */ |
|
56 | - private function isPartOfForeignKey(Table $table, Column $column) { |
|
57 | - $localColumnName = $column->getName(); |
|
58 | - foreach ($table->getForeignKeys() as $foreignKey) { |
|
59 | - foreach ($foreignKey->getColumns() as $columnName) { |
|
60 | - if ($columnName === $localColumnName) { |
|
61 | - return $foreignKey; |
|
62 | - } |
|
63 | - } |
|
64 | - } |
|
65 | - return null; |
|
66 | - } |
|
67 | - |
|
68 | - /** |
|
69 | - * @return AbstractBeanPropertyDescriptor[] |
|
70 | - */ |
|
71 | - public function getBeanPropertyDescriptors() |
|
72 | - { |
|
73 | - return $this->beanPropertyDescriptors; |
|
74 | - } |
|
75 | - |
|
76 | - /** |
|
77 | - * Returns the list of columns that are not nullable and not autogenerated for a given table and its parent. |
|
78 | - * |
|
79 | - * @return AbstractBeanPropertyDescriptor[] |
|
80 | - */ |
|
81 | - public function getConstructorProperties() { |
|
82 | - |
|
83 | - $constructorProperties = array_filter($this->beanPropertyDescriptors, function(AbstractBeanPropertyDescriptor $property) { |
|
84 | - return $property->isCompulsory(); |
|
85 | - }); |
|
86 | - |
|
87 | - return $constructorProperties; |
|
88 | - } |
|
89 | - |
|
90 | - /** |
|
91 | - * Returns the list of properties exposed as getters and setters in this class. |
|
92 | - * |
|
93 | - * @return AbstractBeanPropertyDescriptor[] |
|
94 | - */ |
|
95 | - public function getExposedProperties() { |
|
96 | - $exposedProperties = array_filter($this->beanPropertyDescriptors, function(AbstractBeanPropertyDescriptor $property) { |
|
97 | - return $property->getTable()->getName() == $this->table->getName(); |
|
98 | - }); |
|
99 | - |
|
100 | - return $exposedProperties; |
|
101 | - } |
|
102 | - |
|
103 | - /** |
|
104 | - * Returns the list of foreign keys pointing to the table represented by this bean, excluding foreign keys |
|
105 | - * from junction tables and from inheritance. |
|
106 | - * |
|
107 | - * @return ForeignKeyConstraint[] |
|
108 | - */ |
|
109 | - public function getIncomingForeignKeys() { |
|
110 | - |
|
111 | - $junctionTables = $this->schemaAnalyzer->detectJunctionTables(); |
|
112 | - $junctionTableNames = array_map(function(Table $table) { return $table->getName(); }, $junctionTables); |
|
113 | - $childrenRelationships = $this->schemaAnalyzer->getChildrenRelationships($this->table->getName()); |
|
114 | - |
|
115 | - $fks = []; |
|
116 | - foreach ($this->schema->getTables() as $table) { |
|
117 | - foreach ($table->getForeignKeys() as $fk) { |
|
118 | - if ($fk->getForeignTableName() === $this->table->getName()) { |
|
119 | - if (in_array($fk->getLocalTableName(), $junctionTableNames)) { |
|
120 | - continue; |
|
121 | - } |
|
122 | - foreach ($childrenRelationships as $childFk) { |
|
123 | - if ($fk->getLocalTableName() === $childFk->getLocalTableName() && $fk->getLocalColumns() === $childFk->getLocalColumns()) { |
|
124 | - continue 2; |
|
125 | - } |
|
126 | - } |
|
127 | - $fks[] = $fk; |
|
128 | - } |
|
129 | - } |
|
130 | - } |
|
131 | - |
|
132 | - return $fks; |
|
133 | - } |
|
134 | - |
|
135 | - /** |
|
136 | - * Returns the list of properties for this table (including parent tables). |
|
137 | - * |
|
138 | - * @param Table $table |
|
139 | - * @return AbstractBeanPropertyDescriptor[] |
|
140 | - */ |
|
141 | - private function getProperties(Table $table) |
|
142 | - { |
|
143 | - $parentRelationship = $this->schemaAnalyzer->getParentRelationship($table->getName()); |
|
144 | - if ($parentRelationship) { |
|
145 | - $parentTable = $this->schema->getTable($parentRelationship->getForeignTableName()); |
|
146 | - $properties = $this->getProperties($parentTable); |
|
147 | - // we merge properties by overriding property names. |
|
148 | - $localProperties = $this->getPropertiesForTable($table); |
|
149 | - foreach ($localProperties as $name => $property) { |
|
150 | - // We do not override properties if this is a primary key! |
|
151 | - if ($property->isPrimaryKey()) { |
|
152 | - continue; |
|
153 | - } |
|
154 | - $properties[$name] = $property; |
|
155 | - } |
|
156 | - //$properties = array_merge($properties, $localProperties); |
|
157 | - |
|
158 | - } else { |
|
159 | - $properties = $this->getPropertiesForTable($table); |
|
160 | - } |
|
161 | - |
|
162 | - return $properties; |
|
163 | - } |
|
164 | - |
|
165 | - /** |
|
166 | - * Returns the list of properties for this table (ignoring parent tables). |
|
167 | - * |
|
168 | - * @param Table $table |
|
169 | - * @return AbstractBeanPropertyDescriptor[] |
|
170 | - */ |
|
171 | - private function getPropertiesForTable(Table $table) |
|
172 | - { |
|
173 | - $parentRelationship = $this->schemaAnalyzer->getParentRelationship($table->getName()); |
|
174 | - if ($parentRelationship) { |
|
175 | - $ignoreColumns = $parentRelationship->getLocalColumns(); |
|
176 | - } else { |
|
177 | - $ignoreColumns = []; |
|
178 | - } |
|
179 | - |
|
180 | - $beanPropertyDescriptors = []; |
|
181 | - |
|
182 | - foreach ($table->getColumns() as $column) { |
|
183 | - if (array_search($column->getName(), $ignoreColumns) !== false) { |
|
184 | - continue; |
|
185 | - } |
|
186 | - |
|
187 | - $fk = $this->isPartOfForeignKey($table, $column); |
|
188 | - if ($fk !== null) { |
|
189 | - // Check that previously added descriptors are not added on same FK (can happen with multi key FK). |
|
190 | - foreach ($beanPropertyDescriptors as $beanDescriptor) { |
|
191 | - if ($beanDescriptor instanceof ObjectBeanPropertyDescriptor && $beanDescriptor->getForeignKey() === $fk) { |
|
192 | - continue 2; |
|
193 | - } |
|
194 | - } |
|
195 | - // Check that this property is not an inheritance relationship |
|
196 | - $parentRelationship = $this->schemaAnalyzer->getParentRelationship($table->getName()); |
|
197 | - if ($parentRelationship === $fk) { |
|
198 | - continue; |
|
199 | - } |
|
200 | - |
|
201 | - $beanPropertyDescriptors[] = new ObjectBeanPropertyDescriptor($table, $fk, $this->schemaAnalyzer); |
|
202 | - } else { |
|
203 | - $beanPropertyDescriptors[] = new ScalarBeanPropertyDescriptor($table, $column); |
|
204 | - } |
|
205 | - } |
|
206 | - |
|
207 | - // Now, let's get the name of all properties and let's check there is no duplicate. |
|
208 | - /** @var $names AbstractBeanPropertyDescriptor[] */ |
|
209 | - $names = []; |
|
210 | - foreach ($beanPropertyDescriptors as $beanDescriptor) { |
|
211 | - $name = $beanDescriptor->getUpperCamelCaseName(); |
|
212 | - if (isset($names[$name])) { |
|
213 | - $names[$name]->useAlternativeName(); |
|
214 | - $beanDescriptor->useAlternativeName(); |
|
215 | - } else { |
|
216 | - $names[$name] = $beanDescriptor; |
|
217 | - } |
|
218 | - } |
|
219 | - |
|
220 | - // Final check (throw exceptions if problem arises) |
|
221 | - $names = []; |
|
222 | - foreach ($beanPropertyDescriptors as $beanDescriptor) { |
|
223 | - $name = $beanDescriptor->getUpperCamelCaseName(); |
|
224 | - if (isset($names[$name])) { |
|
225 | - throw new TDBMException("Unsolvable name conflict while generating method name"); |
|
226 | - } else { |
|
227 | - $names[$name] = $beanDescriptor; |
|
228 | - } |
|
229 | - } |
|
230 | - |
|
231 | - // Last step, let's rebuild the list with a map: |
|
232 | - $beanPropertyDescriptorsMap = []; |
|
233 | - foreach ($beanPropertyDescriptors as $beanDescriptor) { |
|
234 | - $beanPropertyDescriptorsMap[$beanDescriptor->getLowerCamelCaseName()] = $beanDescriptor; |
|
235 | - } |
|
236 | - |
|
237 | - return $beanPropertyDescriptorsMap; |
|
238 | - } |
|
239 | - |
|
240 | - public function generateBeanConstructor() { |
|
241 | - $constructorProperties = $this->getConstructorProperties(); |
|
242 | - |
|
243 | - $constructorCode = " /** |
|
18 | + /** |
|
19 | + * @var Table |
|
20 | + */ |
|
21 | + private $table; |
|
22 | + |
|
23 | + /** |
|
24 | + * @var SchemaAnalyzer |
|
25 | + */ |
|
26 | + private $schemaAnalyzer; |
|
27 | + |
|
28 | + /** |
|
29 | + * @var Schema |
|
30 | + */ |
|
31 | + private $schema; |
|
32 | + |
|
33 | + /** |
|
34 | + * @var AbstractBeanPropertyDescriptor[] |
|
35 | + */ |
|
36 | + private $beanPropertyDescriptors = []; |
|
37 | + |
|
38 | + public function __construct(Table $table, SchemaAnalyzer $schemaAnalyzer, Schema $schema) { |
|
39 | + $this->table = $table; |
|
40 | + $this->schemaAnalyzer = $schemaAnalyzer; |
|
41 | + $this->schema = $schema; |
|
42 | + $this->initBeanPropertyDescriptors(); |
|
43 | + } |
|
44 | + |
|
45 | + private function initBeanPropertyDescriptors() { |
|
46 | + $this->beanPropertyDescriptors = $this->getProperties($this->table); |
|
47 | + } |
|
48 | + |
|
49 | + /** |
|
50 | + * Returns the foreignkey the column is part of, if any. null otherwise. |
|
51 | + * |
|
52 | + * @param Table $table |
|
53 | + * @param Column $column |
|
54 | + * @return ForeignKeyConstraint|null |
|
55 | + */ |
|
56 | + private function isPartOfForeignKey(Table $table, Column $column) { |
|
57 | + $localColumnName = $column->getName(); |
|
58 | + foreach ($table->getForeignKeys() as $foreignKey) { |
|
59 | + foreach ($foreignKey->getColumns() as $columnName) { |
|
60 | + if ($columnName === $localColumnName) { |
|
61 | + return $foreignKey; |
|
62 | + } |
|
63 | + } |
|
64 | + } |
|
65 | + return null; |
|
66 | + } |
|
67 | + |
|
68 | + /** |
|
69 | + * @return AbstractBeanPropertyDescriptor[] |
|
70 | + */ |
|
71 | + public function getBeanPropertyDescriptors() |
|
72 | + { |
|
73 | + return $this->beanPropertyDescriptors; |
|
74 | + } |
|
75 | + |
|
76 | + /** |
|
77 | + * Returns the list of columns that are not nullable and not autogenerated for a given table and its parent. |
|
78 | + * |
|
79 | + * @return AbstractBeanPropertyDescriptor[] |
|
80 | + */ |
|
81 | + public function getConstructorProperties() { |
|
82 | + |
|
83 | + $constructorProperties = array_filter($this->beanPropertyDescriptors, function(AbstractBeanPropertyDescriptor $property) { |
|
84 | + return $property->isCompulsory(); |
|
85 | + }); |
|
86 | + |
|
87 | + return $constructorProperties; |
|
88 | + } |
|
89 | + |
|
90 | + /** |
|
91 | + * Returns the list of properties exposed as getters and setters in this class. |
|
92 | + * |
|
93 | + * @return AbstractBeanPropertyDescriptor[] |
|
94 | + */ |
|
95 | + public function getExposedProperties() { |
|
96 | + $exposedProperties = array_filter($this->beanPropertyDescriptors, function(AbstractBeanPropertyDescriptor $property) { |
|
97 | + return $property->getTable()->getName() == $this->table->getName(); |
|
98 | + }); |
|
99 | + |
|
100 | + return $exposedProperties; |
|
101 | + } |
|
102 | + |
|
103 | + /** |
|
104 | + * Returns the list of foreign keys pointing to the table represented by this bean, excluding foreign keys |
|
105 | + * from junction tables and from inheritance. |
|
106 | + * |
|
107 | + * @return ForeignKeyConstraint[] |
|
108 | + */ |
|
109 | + public function getIncomingForeignKeys() { |
|
110 | + |
|
111 | + $junctionTables = $this->schemaAnalyzer->detectJunctionTables(); |
|
112 | + $junctionTableNames = array_map(function(Table $table) { return $table->getName(); }, $junctionTables); |
|
113 | + $childrenRelationships = $this->schemaAnalyzer->getChildrenRelationships($this->table->getName()); |
|
114 | + |
|
115 | + $fks = []; |
|
116 | + foreach ($this->schema->getTables() as $table) { |
|
117 | + foreach ($table->getForeignKeys() as $fk) { |
|
118 | + if ($fk->getForeignTableName() === $this->table->getName()) { |
|
119 | + if (in_array($fk->getLocalTableName(), $junctionTableNames)) { |
|
120 | + continue; |
|
121 | + } |
|
122 | + foreach ($childrenRelationships as $childFk) { |
|
123 | + if ($fk->getLocalTableName() === $childFk->getLocalTableName() && $fk->getLocalColumns() === $childFk->getLocalColumns()) { |
|
124 | + continue 2; |
|
125 | + } |
|
126 | + } |
|
127 | + $fks[] = $fk; |
|
128 | + } |
|
129 | + } |
|
130 | + } |
|
131 | + |
|
132 | + return $fks; |
|
133 | + } |
|
134 | + |
|
135 | + /** |
|
136 | + * Returns the list of properties for this table (including parent tables). |
|
137 | + * |
|
138 | + * @param Table $table |
|
139 | + * @return AbstractBeanPropertyDescriptor[] |
|
140 | + */ |
|
141 | + private function getProperties(Table $table) |
|
142 | + { |
|
143 | + $parentRelationship = $this->schemaAnalyzer->getParentRelationship($table->getName()); |
|
144 | + if ($parentRelationship) { |
|
145 | + $parentTable = $this->schema->getTable($parentRelationship->getForeignTableName()); |
|
146 | + $properties = $this->getProperties($parentTable); |
|
147 | + // we merge properties by overriding property names. |
|
148 | + $localProperties = $this->getPropertiesForTable($table); |
|
149 | + foreach ($localProperties as $name => $property) { |
|
150 | + // We do not override properties if this is a primary key! |
|
151 | + if ($property->isPrimaryKey()) { |
|
152 | + continue; |
|
153 | + } |
|
154 | + $properties[$name] = $property; |
|
155 | + } |
|
156 | + //$properties = array_merge($properties, $localProperties); |
|
157 | + |
|
158 | + } else { |
|
159 | + $properties = $this->getPropertiesForTable($table); |
|
160 | + } |
|
161 | + |
|
162 | + return $properties; |
|
163 | + } |
|
164 | + |
|
165 | + /** |
|
166 | + * Returns the list of properties for this table (ignoring parent tables). |
|
167 | + * |
|
168 | + * @param Table $table |
|
169 | + * @return AbstractBeanPropertyDescriptor[] |
|
170 | + */ |
|
171 | + private function getPropertiesForTable(Table $table) |
|
172 | + { |
|
173 | + $parentRelationship = $this->schemaAnalyzer->getParentRelationship($table->getName()); |
|
174 | + if ($parentRelationship) { |
|
175 | + $ignoreColumns = $parentRelationship->getLocalColumns(); |
|
176 | + } else { |
|
177 | + $ignoreColumns = []; |
|
178 | + } |
|
179 | + |
|
180 | + $beanPropertyDescriptors = []; |
|
181 | + |
|
182 | + foreach ($table->getColumns() as $column) { |
|
183 | + if (array_search($column->getName(), $ignoreColumns) !== false) { |
|
184 | + continue; |
|
185 | + } |
|
186 | + |
|
187 | + $fk = $this->isPartOfForeignKey($table, $column); |
|
188 | + if ($fk !== null) { |
|
189 | + // Check that previously added descriptors are not added on same FK (can happen with multi key FK). |
|
190 | + foreach ($beanPropertyDescriptors as $beanDescriptor) { |
|
191 | + if ($beanDescriptor instanceof ObjectBeanPropertyDescriptor && $beanDescriptor->getForeignKey() === $fk) { |
|
192 | + continue 2; |
|
193 | + } |
|
194 | + } |
|
195 | + // Check that this property is not an inheritance relationship |
|
196 | + $parentRelationship = $this->schemaAnalyzer->getParentRelationship($table->getName()); |
|
197 | + if ($parentRelationship === $fk) { |
|
198 | + continue; |
|
199 | + } |
|
200 | + |
|
201 | + $beanPropertyDescriptors[] = new ObjectBeanPropertyDescriptor($table, $fk, $this->schemaAnalyzer); |
|
202 | + } else { |
|
203 | + $beanPropertyDescriptors[] = new ScalarBeanPropertyDescriptor($table, $column); |
|
204 | + } |
|
205 | + } |
|
206 | + |
|
207 | + // Now, let's get the name of all properties and let's check there is no duplicate. |
|
208 | + /** @var $names AbstractBeanPropertyDescriptor[] */ |
|
209 | + $names = []; |
|
210 | + foreach ($beanPropertyDescriptors as $beanDescriptor) { |
|
211 | + $name = $beanDescriptor->getUpperCamelCaseName(); |
|
212 | + if (isset($names[$name])) { |
|
213 | + $names[$name]->useAlternativeName(); |
|
214 | + $beanDescriptor->useAlternativeName(); |
|
215 | + } else { |
|
216 | + $names[$name] = $beanDescriptor; |
|
217 | + } |
|
218 | + } |
|
219 | + |
|
220 | + // Final check (throw exceptions if problem arises) |
|
221 | + $names = []; |
|
222 | + foreach ($beanPropertyDescriptors as $beanDescriptor) { |
|
223 | + $name = $beanDescriptor->getUpperCamelCaseName(); |
|
224 | + if (isset($names[$name])) { |
|
225 | + throw new TDBMException("Unsolvable name conflict while generating method name"); |
|
226 | + } else { |
|
227 | + $names[$name] = $beanDescriptor; |
|
228 | + } |
|
229 | + } |
|
230 | + |
|
231 | + // Last step, let's rebuild the list with a map: |
|
232 | + $beanPropertyDescriptorsMap = []; |
|
233 | + foreach ($beanPropertyDescriptors as $beanDescriptor) { |
|
234 | + $beanPropertyDescriptorsMap[$beanDescriptor->getLowerCamelCaseName()] = $beanDescriptor; |
|
235 | + } |
|
236 | + |
|
237 | + return $beanPropertyDescriptorsMap; |
|
238 | + } |
|
239 | + |
|
240 | + public function generateBeanConstructor() { |
|
241 | + $constructorProperties = $this->getConstructorProperties(); |
|
242 | + |
|
243 | + $constructorCode = " /** |
|
244 | 244 | * The constructor takes all compulsory arguments. |
245 | 245 | * |
246 | 246 | %s |
@@ -250,64 +250,64 @@ discard block |
||
250 | 250 | } |
251 | 251 | "; |
252 | 252 | |
253 | - $paramAnnotations = []; |
|
254 | - $arguments = []; |
|
255 | - $assigns = []; |
|
256 | - $parentConstructorArguments = []; |
|
257 | - |
|
258 | - foreach ($constructorProperties as $property) { |
|
259 | - $className = $property->getClassName(); |
|
260 | - if ($className) { |
|
261 | - $arguments[] = $className.' '.$property->getVariableName(); |
|
262 | - } else { |
|
263 | - $arguments[] = $property->getVariableName(); |
|
264 | - } |
|
265 | - $paramAnnotations[] = $property->getParamAnnotation(); |
|
266 | - if ($property->getTable()->getName() === $this->table->getName()) { |
|
267 | - $assigns[] = $property->getConstructorAssignCode(); |
|
268 | - } else { |
|
269 | - $parentConstructorArguments[] = $property->getVariableName(); |
|
270 | - } |
|
271 | - } |
|
272 | - |
|
273 | - $parentConstrutorCode = sprintf(" parent::__construct(%s);\n", implode(', ', $parentConstructorArguments)); |
|
274 | - |
|
275 | - return sprintf($constructorCode, implode("\n", $paramAnnotations), implode(", ", $arguments), $parentConstrutorCode, implode("\n", $assigns)); |
|
276 | - } |
|
253 | + $paramAnnotations = []; |
|
254 | + $arguments = []; |
|
255 | + $assigns = []; |
|
256 | + $parentConstructorArguments = []; |
|
257 | + |
|
258 | + foreach ($constructorProperties as $property) { |
|
259 | + $className = $property->getClassName(); |
|
260 | + if ($className) { |
|
261 | + $arguments[] = $className.' '.$property->getVariableName(); |
|
262 | + } else { |
|
263 | + $arguments[] = $property->getVariableName(); |
|
264 | + } |
|
265 | + $paramAnnotations[] = $property->getParamAnnotation(); |
|
266 | + if ($property->getTable()->getName() === $this->table->getName()) { |
|
267 | + $assigns[] = $property->getConstructorAssignCode(); |
|
268 | + } else { |
|
269 | + $parentConstructorArguments[] = $property->getVariableName(); |
|
270 | + } |
|
271 | + } |
|
277 | 272 | |
278 | - public function generateDirectForeignKeysCode() { |
|
279 | - $fks = $this->getIncomingForeignKeys(); |
|
273 | + $parentConstrutorCode = sprintf(" parent::__construct(%s);\n", implode(', ', $parentConstructorArguments)); |
|
280 | 274 | |
281 | - $fksByTable = []; |
|
275 | + return sprintf($constructorCode, implode("\n", $paramAnnotations), implode(", ", $arguments), $parentConstrutorCode, implode("\n", $assigns)); |
|
276 | + } |
|
282 | 277 | |
283 | - foreach ($fks as $fk) { |
|
284 | - $fksByTable[$fk->getLocalTableName()][] = $fk; |
|
285 | - } |
|
278 | + public function generateDirectForeignKeysCode() { |
|
279 | + $fks = $this->getIncomingForeignKeys(); |
|
286 | 280 | |
287 | - /* @var $fksByMethodName ForeignKeyConstraint[] */ |
|
288 | - $fksByMethodName = []; |
|
281 | + $fksByTable = []; |
|
289 | 282 | |
290 | - foreach ($fksByTable as $tableName => $fksForTable) { |
|
291 | - if (count($fksForTable) > 1) { |
|
292 | - foreach ($fksForTable as $fk) { |
|
293 | - $methodName = 'get'.TDBMDaoGenerator::toCamelCase($fk->getLocalTableName()).'By'; |
|
283 | + foreach ($fks as $fk) { |
|
284 | + $fksByTable[$fk->getLocalTableName()][] = $fk; |
|
285 | + } |
|
294 | 286 | |
295 | - $camelizedColumns = array_map(['Mouf\\Database\\TDBM\\Utils\\TDBMDaoGenerator', 'toCamelCase'], $fk->getLocalColumns()); |
|
287 | + /* @var $fksByMethodName ForeignKeyConstraint[] */ |
|
288 | + $fksByMethodName = []; |
|
296 | 289 | |
297 | - $methodName .= implode('And', $camelizedColumns); |
|
290 | + foreach ($fksByTable as $tableName => $fksForTable) { |
|
291 | + if (count($fksForTable) > 1) { |
|
292 | + foreach ($fksForTable as $fk) { |
|
293 | + $methodName = 'get'.TDBMDaoGenerator::toCamelCase($fk->getLocalTableName()).'By'; |
|
298 | 294 | |
299 | - $fksByMethodName[$methodName] = $fk; |
|
300 | - } |
|
301 | - } else { |
|
302 | - $methodName = 'get'.TDBMDaoGenerator::toCamelCase($fksForTable[0]->getLocalTableName()); |
|
303 | - $fksByMethodName[$methodName] = $fk; |
|
304 | - } |
|
305 | - } |
|
295 | + $camelizedColumns = array_map(['Mouf\\Database\\TDBM\\Utils\\TDBMDaoGenerator', 'toCamelCase'], $fk->getLocalColumns()); |
|
306 | 296 | |
307 | - $code = ''; |
|
297 | + $methodName .= implode('And', $camelizedColumns); |
|
308 | 298 | |
309 | - foreach ($fksByMethodName as $methodName => $fk) { |
|
310 | - $getterCode = ' /** |
|
299 | + $fksByMethodName[$methodName] = $fk; |
|
300 | + } |
|
301 | + } else { |
|
302 | + $methodName = 'get'.TDBMDaoGenerator::toCamelCase($fksForTable[0]->getLocalTableName()); |
|
303 | + $fksByMethodName[$methodName] = $fk; |
|
304 | + } |
|
305 | + } |
|
306 | + |
|
307 | + $code = ''; |
|
308 | + |
|
309 | + foreach ($fksByMethodName as $methodName => $fk) { |
|
310 | + $getterCode = ' /** |
|
311 | 311 | * Returns the list of %s pointing to this bean via the %s column. |
312 | 312 | * |
313 | 313 | * @return %s[]|Resultiterator |
@@ -319,103 +319,103 @@ discard block |
||
319 | 319 | |
320 | 320 | '; |
321 | 321 | |
322 | - list($sql, $parametersCode) = $this->getFilters($fk); |
|
323 | - |
|
324 | - $beanClass = TDBMDaoGenerator::getBeanNameFromTableName($fk->getLocalTableName()); |
|
325 | - $code .= sprintf($getterCode, |
|
326 | - $beanClass, |
|
327 | - implode(', ', $fk->getColumns()), |
|
328 | - $beanClass, |
|
329 | - $methodName, |
|
330 | - var_export($fk->getLocalTableName(), true), |
|
331 | - $sql, |
|
332 | - $parametersCode |
|
333 | - ); |
|
334 | - } |
|
335 | - |
|
336 | - return $code; |
|
337 | - } |
|
338 | - |
|
339 | - private function getFilters(ForeignKeyConstraint $fk) { |
|
340 | - $sqlParts = []; |
|
341 | - $counter = 0; |
|
342 | - $parameters = []; |
|
343 | - |
|
344 | - $pkColumns = $this->table->getPrimaryKeyColumns(); |
|
345 | - |
|
346 | - foreach ($fk->getLocalColumns() as $columnName) { |
|
347 | - $paramName = "tdbmparam".$counter; |
|
348 | - $sqlParts[] = $fk->getLocalTableName().'.'.$columnName." = :".$paramName; |
|
349 | - |
|
350 | - $pkColumn = $pkColumns[$counter]; |
|
351 | - $parameters[] = sprintf('%s => $this->get(%s, %s)', var_export($paramName, true), var_export($pkColumn, true), var_export($this->table->getName(), true)); |
|
352 | - $counter++; |
|
353 | - } |
|
354 | - $sql = "'".implode(' AND ', $sqlParts)."'"; |
|
355 | - $parametersCode = '[ '.implode(', ', $parameters).' ]'; |
|
356 | - |
|
357 | - return [$sql, $parametersCode]; |
|
358 | - } |
|
359 | - |
|
360 | - /** |
|
361 | - * Generate code section about pivot tables |
|
362 | - * |
|
363 | - * @return string; |
|
364 | - */ |
|
365 | - public function generatePivotTableCode() { |
|
366 | - $descs = []; |
|
367 | - foreach ($this->schemaAnalyzer->detectJunctionTables() as $table) { |
|
368 | - // There are exactly 2 FKs since this is a pivot table. |
|
369 | - $fks = array_values($table->getForeignKeys()); |
|
370 | - |
|
371 | - if ($fks[0]->getForeignTableName() === $this->table->getName()) { |
|
372 | - $localFK = $fks[0]; |
|
373 | - $remoteFK = $fks[1]; |
|
374 | - } elseif ($fks[1]->getForeignTableName() === $this->table->getName()) { |
|
375 | - $localFK = $fks[1]; |
|
376 | - $remoteFK = $fks[0]; |
|
377 | - } else { |
|
378 | - continue; |
|
379 | - } |
|
380 | - |
|
381 | - $descs[$remoteFK->getForeignTableName()][] = [ |
|
382 | - 'table' => $table, |
|
383 | - 'localFK' => $localFK, |
|
384 | - 'remoteFK' => $remoteFK |
|
385 | - ]; |
|
386 | - |
|
387 | - } |
|
388 | - |
|
389 | - $finalDescs = []; |
|
390 | - foreach ($descs as $descArray) { |
|
391 | - if (count($descArray) > 1) { |
|
392 | - foreach ($descArray as $desc) { |
|
393 | - $desc['name'] = TDBMDaoGenerator::toCamelCase($desc['remoteFK']->getForeignTableName())."By".TDBMDaoGenerator::toCamelCase($desc['table']->getName()); |
|
394 | - $finalDescs[] = $desc; |
|
395 | - } |
|
396 | - } else { |
|
397 | - $desc = $descArray[0]; |
|
398 | - $desc['name'] = TDBMDaoGenerator::toCamelCase($desc['remoteFK']->getForeignTableName()); |
|
399 | - $finalDescs[] = $desc; |
|
400 | - } |
|
401 | - } |
|
402 | - |
|
403 | - |
|
404 | - $code = ''; |
|
405 | - |
|
406 | - foreach ($finalDescs as $desc) { |
|
407 | - $code .= $this->getPivotTableCode($desc['name'], $desc['table'], $desc['localFK'], $desc['remoteFK']); |
|
408 | - } |
|
409 | - |
|
410 | - return $code; |
|
411 | - } |
|
412 | - |
|
413 | - public function getPivotTableCode($name, Table $table, ForeignKeyConstraint $localFK, ForeignKeyConstraint $remoteFK) { |
|
414 | - $singularName = TDBMDaoGenerator::toSingular($name); |
|
415 | - $remoteBeanName = TDBMDaoGenerator::getBeanNameFromTableName($remoteFK->getForeignTableName()); |
|
416 | - $variableName = '$'.TDBMDaoGenerator::toVariableName($remoteBeanName); |
|
417 | - |
|
418 | - $str = ' /** |
|
322 | + list($sql, $parametersCode) = $this->getFilters($fk); |
|
323 | + |
|
324 | + $beanClass = TDBMDaoGenerator::getBeanNameFromTableName($fk->getLocalTableName()); |
|
325 | + $code .= sprintf($getterCode, |
|
326 | + $beanClass, |
|
327 | + implode(', ', $fk->getColumns()), |
|
328 | + $beanClass, |
|
329 | + $methodName, |
|
330 | + var_export($fk->getLocalTableName(), true), |
|
331 | + $sql, |
|
332 | + $parametersCode |
|
333 | + ); |
|
334 | + } |
|
335 | + |
|
336 | + return $code; |
|
337 | + } |
|
338 | + |
|
339 | + private function getFilters(ForeignKeyConstraint $fk) { |
|
340 | + $sqlParts = []; |
|
341 | + $counter = 0; |
|
342 | + $parameters = []; |
|
343 | + |
|
344 | + $pkColumns = $this->table->getPrimaryKeyColumns(); |
|
345 | + |
|
346 | + foreach ($fk->getLocalColumns() as $columnName) { |
|
347 | + $paramName = "tdbmparam".$counter; |
|
348 | + $sqlParts[] = $fk->getLocalTableName().'.'.$columnName." = :".$paramName; |
|
349 | + |
|
350 | + $pkColumn = $pkColumns[$counter]; |
|
351 | + $parameters[] = sprintf('%s => $this->get(%s, %s)', var_export($paramName, true), var_export($pkColumn, true), var_export($this->table->getName(), true)); |
|
352 | + $counter++; |
|
353 | + } |
|
354 | + $sql = "'".implode(' AND ', $sqlParts)."'"; |
|
355 | + $parametersCode = '[ '.implode(', ', $parameters).' ]'; |
|
356 | + |
|
357 | + return [$sql, $parametersCode]; |
|
358 | + } |
|
359 | + |
|
360 | + /** |
|
361 | + * Generate code section about pivot tables |
|
362 | + * |
|
363 | + * @return string; |
|
364 | + */ |
|
365 | + public function generatePivotTableCode() { |
|
366 | + $descs = []; |
|
367 | + foreach ($this->schemaAnalyzer->detectJunctionTables() as $table) { |
|
368 | + // There are exactly 2 FKs since this is a pivot table. |
|
369 | + $fks = array_values($table->getForeignKeys()); |
|
370 | + |
|
371 | + if ($fks[0]->getForeignTableName() === $this->table->getName()) { |
|
372 | + $localFK = $fks[0]; |
|
373 | + $remoteFK = $fks[1]; |
|
374 | + } elseif ($fks[1]->getForeignTableName() === $this->table->getName()) { |
|
375 | + $localFK = $fks[1]; |
|
376 | + $remoteFK = $fks[0]; |
|
377 | + } else { |
|
378 | + continue; |
|
379 | + } |
|
380 | + |
|
381 | + $descs[$remoteFK->getForeignTableName()][] = [ |
|
382 | + 'table' => $table, |
|
383 | + 'localFK' => $localFK, |
|
384 | + 'remoteFK' => $remoteFK |
|
385 | + ]; |
|
386 | + |
|
387 | + } |
|
388 | + |
|
389 | + $finalDescs = []; |
|
390 | + foreach ($descs as $descArray) { |
|
391 | + if (count($descArray) > 1) { |
|
392 | + foreach ($descArray as $desc) { |
|
393 | + $desc['name'] = TDBMDaoGenerator::toCamelCase($desc['remoteFK']->getForeignTableName())."By".TDBMDaoGenerator::toCamelCase($desc['table']->getName()); |
|
394 | + $finalDescs[] = $desc; |
|
395 | + } |
|
396 | + } else { |
|
397 | + $desc = $descArray[0]; |
|
398 | + $desc['name'] = TDBMDaoGenerator::toCamelCase($desc['remoteFK']->getForeignTableName()); |
|
399 | + $finalDescs[] = $desc; |
|
400 | + } |
|
401 | + } |
|
402 | + |
|
403 | + |
|
404 | + $code = ''; |
|
405 | + |
|
406 | + foreach ($finalDescs as $desc) { |
|
407 | + $code .= $this->getPivotTableCode($desc['name'], $desc['table'], $desc['localFK'], $desc['remoteFK']); |
|
408 | + } |
|
409 | + |
|
410 | + return $code; |
|
411 | + } |
|
412 | + |
|
413 | + public function getPivotTableCode($name, Table $table, ForeignKeyConstraint $localFK, ForeignKeyConstraint $remoteFK) { |
|
414 | + $singularName = TDBMDaoGenerator::toSingular($name); |
|
415 | + $remoteBeanName = TDBMDaoGenerator::getBeanNameFromTableName($remoteFK->getForeignTableName()); |
|
416 | + $variableName = '$'.TDBMDaoGenerator::toVariableName($remoteBeanName); |
|
417 | + |
|
418 | + $str = ' /** |
|
419 | 419 | * Returns the list of %s associated to this bean via the %s pivot table. |
420 | 420 | * |
421 | 421 | * @return %s[] |
@@ -425,9 +425,9 @@ discard block |
||
425 | 425 | } |
426 | 426 | '; |
427 | 427 | |
428 | - $getterCode = sprintf($str, $remoteBeanName, $table->getName(), $remoteBeanName, $name, var_export($remoteFK->getLocalTableName(), true)); |
|
428 | + $getterCode = sprintf($str, $remoteBeanName, $table->getName(), $remoteBeanName, $name, var_export($remoteFK->getLocalTableName(), true)); |
|
429 | 429 | |
430 | - $str = ' /** |
|
430 | + $str = ' /** |
|
431 | 431 | * Adds a relationship with %s associated to this bean via the %s pivot table. |
432 | 432 | * |
433 | 433 | * @param %s %s |
@@ -437,9 +437,9 @@ discard block |
||
437 | 437 | } |
438 | 438 | '; |
439 | 439 | |
440 | - $adderCode = sprintf($str, $remoteBeanName, $table->getName(), $remoteBeanName, $variableName, $singularName, $remoteBeanName, $variableName, var_export($remoteFK->getLocalTableName(), true), $variableName); |
|
440 | + $adderCode = sprintf($str, $remoteBeanName, $table->getName(), $remoteBeanName, $variableName, $singularName, $remoteBeanName, $variableName, var_export($remoteFK->getLocalTableName(), true), $variableName); |
|
441 | 441 | |
442 | - $str = ' /** |
|
442 | + $str = ' /** |
|
443 | 443 | * Deletes the relationship with %s associated to this bean via the %s pivot table. |
444 | 444 | * |
445 | 445 | * @param %s %s |
@@ -449,9 +449,9 @@ discard block |
||
449 | 449 | } |
450 | 450 | '; |
451 | 451 | |
452 | - $removerCode = sprintf($str, $remoteBeanName, $table->getName(), $remoteBeanName, $variableName, $singularName, $remoteBeanName, $variableName, var_export($remoteFK->getLocalTableName(), true), $variableName); |
|
452 | + $removerCode = sprintf($str, $remoteBeanName, $table->getName(), $remoteBeanName, $variableName, $singularName, $remoteBeanName, $variableName, var_export($remoteFK->getLocalTableName(), true), $variableName); |
|
453 | 453 | |
454 | - $str = ' /** |
|
454 | + $str = ' /** |
|
455 | 455 | * Returns whether this bean is associated with %s via the %s pivot table. |
456 | 456 | * |
457 | 457 | * @param %s %s |
@@ -462,34 +462,34 @@ discard block |
||
462 | 462 | } |
463 | 463 | '; |
464 | 464 | |
465 | - $hasCode = sprintf($str, $remoteBeanName, $table->getName(), $remoteBeanName, $variableName, $singularName, $remoteBeanName, $variableName, var_export($remoteFK->getLocalTableName(), true), $variableName); |
|
465 | + $hasCode = sprintf($str, $remoteBeanName, $table->getName(), $remoteBeanName, $variableName, $singularName, $remoteBeanName, $variableName, var_export($remoteFK->getLocalTableName(), true), $variableName); |
|
466 | 466 | |
467 | 467 | |
468 | - $code = $getterCode.$adderCode.$removerCode.$hasCode; |
|
468 | + $code = $getterCode.$adderCode.$removerCode.$hasCode; |
|
469 | 469 | |
470 | - return $code; |
|
471 | - } |
|
470 | + return $code; |
|
471 | + } |
|
472 | 472 | |
473 | - /** |
|
474 | - * Writes the PHP bean file with all getters and setters from the table passed in parameter. |
|
475 | - * |
|
476 | - * @param string $beannamespace The namespace of the bean |
|
477 | - */ |
|
478 | - public function generatePhpCode($beannamespace) { |
|
479 | - $baseClassName = TDBMDaoGenerator::getBaseBeanNameFromTableName($this->table->getName()); |
|
480 | - $className = TDBMDaoGenerator::getBeanNameFromTableName($this->table->getName()); |
|
481 | - $tableName = $this->table->getName(); |
|
482 | - |
|
483 | - $parentFk = $this->schemaAnalyzer->getParentRelationship($tableName); |
|
484 | - if ($parentFk !== null) { |
|
485 | - $extends = TDBMDaoGenerator::getBeanNameFromTableName($parentFk->getForeignTableName()); |
|
486 | - $use = ""; |
|
487 | - } else { |
|
488 | - $extends = "AbstractTDBMObject"; |
|
489 | - $use = "use Mouf\\Database\\TDBM\\AbstractTDBMObject;\n\n"; |
|
490 | - } |
|
491 | - |
|
492 | - $str = "<?php |
|
473 | + /** |
|
474 | + * Writes the PHP bean file with all getters and setters from the table passed in parameter. |
|
475 | + * |
|
476 | + * @param string $beannamespace The namespace of the bean |
|
477 | + */ |
|
478 | + public function generatePhpCode($beannamespace) { |
|
479 | + $baseClassName = TDBMDaoGenerator::getBaseBeanNameFromTableName($this->table->getName()); |
|
480 | + $className = TDBMDaoGenerator::getBeanNameFromTableName($this->table->getName()); |
|
481 | + $tableName = $this->table->getName(); |
|
482 | + |
|
483 | + $parentFk = $this->schemaAnalyzer->getParentRelationship($tableName); |
|
484 | + if ($parentFk !== null) { |
|
485 | + $extends = TDBMDaoGenerator::getBeanNameFromTableName($parentFk->getForeignTableName()); |
|
486 | + $use = ""; |
|
487 | + } else { |
|
488 | + $extends = "AbstractTDBMObject"; |
|
489 | + $use = "use Mouf\\Database\\TDBM\\AbstractTDBMObject;\n\n"; |
|
490 | + } |
|
491 | + |
|
492 | + $str = "<?php |
|
493 | 493 | namespace {$beannamespace}; |
494 | 494 | |
495 | 495 | use Mouf\\Database\\TDBM\\ResultIterator; |
@@ -507,19 +507,19 @@ discard block |
||
507 | 507 | { |
508 | 508 | "; |
509 | 509 | |
510 | - $str .= $this->generateBeanConstructor(); |
|
510 | + $str .= $this->generateBeanConstructor(); |
|
511 | 511 | |
512 | 512 | |
513 | 513 | |
514 | - foreach ($this->getExposedProperties() as $property) { |
|
515 | - $str .= $property->getGetterSetterCode(); |
|
516 | - } |
|
514 | + foreach ($this->getExposedProperties() as $property) { |
|
515 | + $str .= $property->getGetterSetterCode(); |
|
516 | + } |
|
517 | 517 | |
518 | - $str .= $this->generateDirectForeignKeysCode(); |
|
519 | - $str .= $this->generatePivotTableCode(); |
|
518 | + $str .= $this->generateDirectForeignKeysCode(); |
|
519 | + $str .= $this->generatePivotTableCode(); |
|
520 | 520 | |
521 | - $str .= "} |
|
521 | + $str .= "} |
|
522 | 522 | "; |
523 | - return $str; |
|
524 | - } |
|
523 | + return $str; |
|
524 | + } |
|
525 | 525 | } |
@@ -13,97 +13,97 @@ |
||
13 | 13 | abstract class AbstractBeanPropertyDescriptor |
14 | 14 | { |
15 | 15 | |
16 | - /** |
|
17 | - * @var Table |
|
18 | - */ |
|
19 | - protected $table; |
|
20 | - |
|
21 | - /** |
|
22 | - * Whether to use the more complex name in case of conflict. |
|
23 | - * @var bool |
|
24 | - */ |
|
25 | - protected $alternativeName = false; |
|
26 | - |
|
27 | - /** |
|
28 | - * @param Table $table |
|
29 | - */ |
|
30 | - public function __construct(Table $table) |
|
31 | - { |
|
32 | - $this->table = $table; |
|
33 | - } |
|
34 | - |
|
35 | - |
|
36 | - /** |
|
37 | - * Use the more complex name in case of conflict. |
|
38 | - */ |
|
39 | - public function useAlternativeName() |
|
40 | - { |
|
41 | - $this->alternativeName = true; |
|
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 | - abstract public function getClassName(); |
|
49 | - |
|
50 | - /** |
|
51 | - * Returns the param annotation for this property (useful for constructor). |
|
52 | - * |
|
53 | - * @return string |
|
54 | - */ |
|
55 | - abstract public function getParamAnnotation(); |
|
56 | - |
|
57 | - public function getVariableName() { |
|
58 | - return '$'.$this->getLowerCamelCaseName(); |
|
59 | - } |
|
60 | - |
|
61 | - public function getLowerCamelCaseName() { |
|
62 | - return TDBMDaoGenerator::toVariableName($this->getUpperCamelCaseName()); |
|
63 | - } |
|
64 | - |
|
65 | - abstract public function getUpperCamelCaseName(); |
|
66 | - |
|
67 | - public function getSetterName() { |
|
68 | - return 'set'.$this->getUpperCamelCaseName(); |
|
69 | - } |
|
70 | - |
|
71 | - public function getGetterName() { |
|
72 | - return 'get'.$this->getUpperCamelCaseName(); |
|
73 | - } |
|
74 | - |
|
75 | - /** |
|
76 | - * Returns the PHP code used in the ben constructor for this property. |
|
77 | - * @return string |
|
78 | - */ |
|
79 | - public function getConstructorAssignCode() { |
|
80 | - $str = ' $this->%s(%s);'; |
|
81 | - return sprintf($str, $this->getSetterName(), $this->getVariableName()); |
|
82 | - } |
|
83 | - |
|
84 | - /** |
|
85 | - * Returns true if the property is compulsory (and therefore should be fetched in the constructor). |
|
86 | - * @return bool |
|
87 | - */ |
|
88 | - abstract public function isCompulsory(); |
|
89 | - |
|
90 | - /** |
|
91 | - * Returns true if the property is the primary key |
|
92 | - * @return bool |
|
93 | - */ |
|
94 | - abstract public function isPrimaryKey(); |
|
95 | - |
|
96 | - /** |
|
97 | - * @return Table |
|
98 | - */ |
|
99 | - public function getTable() |
|
100 | - { |
|
101 | - return $this->table; |
|
102 | - } |
|
103 | - |
|
104 | - /** |
|
105 | - * Returns the PHP code for getters and setters |
|
106 | - * @return string |
|
107 | - */ |
|
108 | - abstract public function getGetterSetterCode(); |
|
16 | + /** |
|
17 | + * @var Table |
|
18 | + */ |
|
19 | + protected $table; |
|
20 | + |
|
21 | + /** |
|
22 | + * Whether to use the more complex name in case of conflict. |
|
23 | + * @var bool |
|
24 | + */ |
|
25 | + protected $alternativeName = false; |
|
26 | + |
|
27 | + /** |
|
28 | + * @param Table $table |
|
29 | + */ |
|
30 | + public function __construct(Table $table) |
|
31 | + { |
|
32 | + $this->table = $table; |
|
33 | + } |
|
34 | + |
|
35 | + |
|
36 | + /** |
|
37 | + * Use the more complex name in case of conflict. |
|
38 | + */ |
|
39 | + public function useAlternativeName() |
|
40 | + { |
|
41 | + $this->alternativeName = true; |
|
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 | + abstract public function getClassName(); |
|
49 | + |
|
50 | + /** |
|
51 | + * Returns the param annotation for this property (useful for constructor). |
|
52 | + * |
|
53 | + * @return string |
|
54 | + */ |
|
55 | + abstract public function getParamAnnotation(); |
|
56 | + |
|
57 | + public function getVariableName() { |
|
58 | + return '$'.$this->getLowerCamelCaseName(); |
|
59 | + } |
|
60 | + |
|
61 | + public function getLowerCamelCaseName() { |
|
62 | + return TDBMDaoGenerator::toVariableName($this->getUpperCamelCaseName()); |
|
63 | + } |
|
64 | + |
|
65 | + abstract public function getUpperCamelCaseName(); |
|
66 | + |
|
67 | + public function getSetterName() { |
|
68 | + return 'set'.$this->getUpperCamelCaseName(); |
|
69 | + } |
|
70 | + |
|
71 | + public function getGetterName() { |
|
72 | + return 'get'.$this->getUpperCamelCaseName(); |
|
73 | + } |
|
74 | + |
|
75 | + /** |
|
76 | + * Returns the PHP code used in the ben constructor for this property. |
|
77 | + * @return string |
|
78 | + */ |
|
79 | + public function getConstructorAssignCode() { |
|
80 | + $str = ' $this->%s(%s);'; |
|
81 | + return sprintf($str, $this->getSetterName(), $this->getVariableName()); |
|
82 | + } |
|
83 | + |
|
84 | + /** |
|
85 | + * Returns true if the property is compulsory (and therefore should be fetched in the constructor). |
|
86 | + * @return bool |
|
87 | + */ |
|
88 | + abstract public function isCompulsory(); |
|
89 | + |
|
90 | + /** |
|
91 | + * Returns true if the property is the primary key |
|
92 | + * @return bool |
|
93 | + */ |
|
94 | + abstract public function isPrimaryKey(); |
|
95 | + |
|
96 | + /** |
|
97 | + * @return Table |
|
98 | + */ |
|
99 | + public function getTable() |
|
100 | + { |
|
101 | + return $this->table; |
|
102 | + } |
|
103 | + |
|
104 | + /** |
|
105 | + * Returns the PHP code for getters and setters |
|
106 | + * @return string |
|
107 | + */ |
|
108 | + abstract public function getGetterSetterCode(); |
|
109 | 109 | } |
110 | 110 | \ No newline at end of file |
@@ -59,10 +59,10 @@ discard block |
||
59 | 59 | } |
60 | 60 | |
61 | 61 | if ($this->daoNamespace == null && $this->beanNamespace == null) { |
62 | - $classNameMapper = ClassNameMapper::createFromComposerFile(__DIR__.'/../../../../../../../../composer.json'); |
|
62 | + $classNameMapper = ClassNameMapper::createFromComposerFile(__DIR__.'/../../../../../../../../composer.json'); |
|
63 | 63 | |
64 | 64 | $autoloadNamespaces = $classNameMapper->getManagedNamespaces(); |
65 | - if ($autoloadNamespaces) { |
|
65 | + if ($autoloadNamespaces) { |
|
66 | 66 | $this->autoloadDetected = true; |
67 | 67 | $rootNamespace = $autoloadNamespaces[0]; |
68 | 68 | $this->daoNamespace = $rootNamespace."Dao"; |
@@ -138,7 +138,7 @@ discard block |
||
138 | 138 | |
139 | 139 | $tdbmService = new InstanceProxy($name); |
140 | 140 | /* @var $tdbmService TDBMService */ |
141 | - $tables = $tdbmService->generateAllDaosAndBeans($daofactoryclassname, $daonamespace, $beannamespace, $storeInUtc); |
|
141 | + $tables = $tdbmService->generateAllDaosAndBeans($daofactoryclassname, $daonamespace, $beannamespace, $storeInUtc); |
|
142 | 142 | |
143 | 143 | |
144 | 144 | $moufManager->declareComponent($daofactoryinstancename, $daonamespace."\\".$daofactoryclassname, false, MoufManager::DECLARE_ON_EXIST_KEEP_INCOMING_LINKS); |