@@ -270,10 +270,10 @@ discard block |
||
| 270 | 270 | */ |
| 271 | 271 | public function getSQLTableAlias($tableName, $dqlAlias = '') |
| 272 | 272 | { |
| 273 | - $tableName .= $dqlAlias ? '@[' . $dqlAlias . ']' : ''; |
|
| 273 | + $tableName .= $dqlAlias ? '@['.$dqlAlias.']' : ''; |
|
| 274 | 274 | |
| 275 | - if (! isset($this->tableAliasMap[$tableName])) { |
|
| 276 | - $this->tableAliasMap[$tableName] = 't' . $this->tableAliasCounter++; |
|
| 275 | + if ( ! isset($this->tableAliasMap[$tableName])) { |
|
| 276 | + $this->tableAliasMap[$tableName] = 't'.$this->tableAliasCounter++; |
|
| 277 | 277 | } |
| 278 | 278 | |
| 279 | 279 | return $this->tableAliasMap[$tableName]; |
@@ -291,7 +291,7 @@ discard block |
||
| 291 | 291 | */ |
| 292 | 292 | public function setSQLTableAlias($tableName, $alias, $dqlAlias = '') |
| 293 | 293 | { |
| 294 | - $tableName .= $dqlAlias ? '@[' . $dqlAlias . ']' : ''; |
|
| 294 | + $tableName .= $dqlAlias ? '@['.$dqlAlias.']' : ''; |
|
| 295 | 295 | |
| 296 | 296 | $this->tableAliasMap[$tableName] = $alias; |
| 297 | 297 | |
@@ -305,7 +305,7 @@ discard block |
||
| 305 | 305 | */ |
| 306 | 306 | public function getSQLColumnAlias() |
| 307 | 307 | { |
| 308 | - return $this->platform->getSQLResultCasing('c' . $this->aliasCounter++); |
|
| 308 | + return $this->platform->getSQLResultCasing('c'.$this->aliasCounter++); |
|
| 309 | 309 | } |
| 310 | 310 | |
| 311 | 311 | /** |
@@ -332,14 +332,14 @@ discard block |
||
| 332 | 332 | |
| 333 | 333 | // If this is a joined association we must use left joins to preserve the correct result. |
| 334 | 334 | $sql .= isset($this->queryComponents[$dqlAlias]['relation']) ? ' LEFT ' : ' INNER '; |
| 335 | - $sql .= 'JOIN ' . $tableName . ' ' . $tableAlias . ' ON '; |
|
| 335 | + $sql .= 'JOIN '.$tableName.' '.$tableAlias.' ON '; |
|
| 336 | 336 | |
| 337 | 337 | $sqlParts = []; |
| 338 | 338 | |
| 339 | 339 | foreach ($class->getIdentifierColumns($this->em) as $column) { |
| 340 | 340 | $quotedColumnName = $this->platform->quoteIdentifier($column->getColumnName()); |
| 341 | 341 | |
| 342 | - $sqlParts[] = $baseTableAlias . '.' . $quotedColumnName . ' = ' . $tableAlias . '.' . $quotedColumnName; |
|
| 342 | + $sqlParts[] = $baseTableAlias.'.'.$quotedColumnName.' = '.$tableAlias.'.'.$quotedColumnName; |
|
| 343 | 343 | } |
| 344 | 344 | |
| 345 | 345 | $filterSql = $this->generateFilterConditionSQL($parentClass, $tableAlias); |
@@ -363,14 +363,14 @@ discard block |
||
| 363 | 363 | $tableName = $subClass->table->getQuotedQualifiedName($this->platform); |
| 364 | 364 | $tableAlias = $this->getSQLTableAlias($subClass->getTableName(), $dqlAlias); |
| 365 | 365 | |
| 366 | - $sql .= ' LEFT JOIN ' . $tableName . ' ' . $tableAlias . ' ON '; |
|
| 366 | + $sql .= ' LEFT JOIN '.$tableName.' '.$tableAlias.' ON '; |
|
| 367 | 367 | |
| 368 | 368 | $sqlParts = []; |
| 369 | 369 | |
| 370 | 370 | foreach ($subClass->getIdentifierColumns($this->em) as $column) { |
| 371 | 371 | $quotedColumnName = $this->platform->quoteIdentifier($column->getColumnName()); |
| 372 | 372 | |
| 373 | - $sqlParts[] = $baseTableAlias . '.' . $quotedColumnName . ' = ' . $tableAlias . '.' . $quotedColumnName; |
|
| 373 | + $sqlParts[] = $baseTableAlias.'.'.$quotedColumnName.' = '.$tableAlias.'.'.$quotedColumnName; |
|
| 374 | 374 | } |
| 375 | 375 | |
| 376 | 376 | $sql .= implode(' AND ', $sqlParts); |
@@ -391,7 +391,7 @@ discard block |
||
| 391 | 391 | $qComp = $this->queryComponents[$dqlAlias]; |
| 392 | 392 | $association = $qComp['relation']; |
| 393 | 393 | |
| 394 | - if (! ($association instanceof ToManyAssociationMetadata)) { |
|
| 394 | + if ( ! ($association instanceof ToManyAssociationMetadata)) { |
|
| 395 | 395 | continue; |
| 396 | 396 | } |
| 397 | 397 | |
@@ -399,7 +399,7 @@ discard block |
||
| 399 | 399 | $property = $qComp['metadata']->getProperty($fieldName); |
| 400 | 400 | $tableName = $property->getTableName(); |
| 401 | 401 | $columnName = $this->platform->quoteIdentifier($property->getColumnName()); |
| 402 | - $orderedColumn = $this->getSQLTableAlias($tableName, $dqlAlias) . '.' . $columnName; |
|
| 402 | + $orderedColumn = $this->getSQLTableAlias($tableName, $dqlAlias).'.'.$columnName; |
|
| 403 | 403 | |
| 404 | 404 | // OrderByClause should replace an ordered relation. see - DDC-2475 |
| 405 | 405 | if (isset($this->orderedColumnsMap[$orderedColumn])) { |
@@ -407,7 +407,7 @@ discard block |
||
| 407 | 407 | } |
| 408 | 408 | |
| 409 | 409 | $this->orderedColumnsMap[$orderedColumn] = $orientation; |
| 410 | - $orderedColumns[] = $orderedColumn . ' ' . $orientation; |
|
| 410 | + $orderedColumns[] = $orderedColumn.' '.$orientation; |
|
| 411 | 411 | } |
| 412 | 412 | } |
| 413 | 413 | |
@@ -447,19 +447,19 @@ discard block |
||
| 447 | 447 | $discrColumnType = $discrColumn->getType(); |
| 448 | 448 | $quotedColumnName = $this->platform->quoteIdentifier($discrColumn->getColumnName()); |
| 449 | 449 | $sqlTableAlias = $this->useSqlTableAliases |
| 450 | - ? $this->getSQLTableAlias($discrColumn->getTableName(), $dqlAlias) . '.' |
|
| 450 | + ? $this->getSQLTableAlias($discrColumn->getTableName(), $dqlAlias).'.' |
|
| 451 | 451 | : ''; |
| 452 | 452 | |
| 453 | 453 | $sqlParts[] = sprintf( |
| 454 | 454 | '%s IN (%s)', |
| 455 | - $discrColumnType->convertToDatabaseValueSQL($sqlTableAlias . $quotedColumnName, $this->platform), |
|
| 455 | + $discrColumnType->convertToDatabaseValueSQL($sqlTableAlias.$quotedColumnName, $this->platform), |
|
| 456 | 456 | implode(', ', $values) |
| 457 | 457 | ); |
| 458 | 458 | } |
| 459 | 459 | |
| 460 | 460 | $sql = implode(' AND ', $sqlParts); |
| 461 | 461 | |
| 462 | - return isset($sqlParts[1]) ? '(' . $sql . ')' : $sql; |
|
| 462 | + return isset($sqlParts[1]) ? '('.$sql.')' : $sql; |
|
| 463 | 463 | } |
| 464 | 464 | |
| 465 | 465 | /** |
@@ -472,7 +472,7 @@ discard block |
||
| 472 | 472 | */ |
| 473 | 473 | private function generateFilterConditionSQL(ClassMetadata $targetEntity, $targetTableAlias) |
| 474 | 474 | { |
| 475 | - if (! $this->em->hasFilters()) { |
|
| 475 | + if ( ! $this->em->hasFilters()) { |
|
| 476 | 476 | return ''; |
| 477 | 477 | } |
| 478 | 478 | |
@@ -505,7 +505,7 @@ discard block |
||
| 505 | 505 | $filterExpr = $filter->addFilterConstraint($targetEntity, $targetTableAlias); |
| 506 | 506 | |
| 507 | 507 | if ($filterExpr !== '') { |
| 508 | - $filterClauses[] = '(' . $filterExpr . ')'; |
|
| 508 | + $filterClauses[] = '('.$filterExpr.')'; |
|
| 509 | 509 | } |
| 510 | 510 | } |
| 511 | 511 | |
@@ -536,11 +536,11 @@ discard block |
||
| 536 | 536 | $sql .= $this->walkOrderByClause($AST->orderByClause); |
| 537 | 537 | } |
| 538 | 538 | |
| 539 | - if (! $AST->orderByClause) { |
|
| 539 | + if ( ! $AST->orderByClause) { |
|
| 540 | 540 | $orderBySql = $this->generateOrderedCollectionOrderByItems(); |
| 541 | 541 | |
| 542 | 542 | if ($orderBySql) { |
| 543 | - $sql .= ' ORDER BY ' . $orderBySql; |
|
| 543 | + $sql .= ' ORDER BY '.$orderBySql; |
|
| 544 | 544 | } |
| 545 | 545 | } |
| 546 | 546 | |
@@ -553,11 +553,11 @@ discard block |
||
| 553 | 553 | } |
| 554 | 554 | |
| 555 | 555 | if ($lockMode === LockMode::PESSIMISTIC_READ) { |
| 556 | - return $sql . ' ' . $this->platform->getReadLockSQL(); |
|
| 556 | + return $sql.' '.$this->platform->getReadLockSQL(); |
|
| 557 | 557 | } |
| 558 | 558 | |
| 559 | 559 | if ($lockMode === LockMode::PESSIMISTIC_WRITE) { |
| 560 | - return $sql . ' ' . $this->platform->getWriteLockSQL(); |
|
| 560 | + return $sql.' '.$this->platform->getWriteLockSQL(); |
|
| 561 | 561 | } |
| 562 | 562 | |
| 563 | 563 | if ($lockMode !== LockMode::OPTIMISTIC) { |
@@ -565,7 +565,7 @@ discard block |
||
| 565 | 565 | } |
| 566 | 566 | |
| 567 | 567 | foreach ($this->selectedClasses as $selectedClass) { |
| 568 | - if (! $selectedClass['class']->isVersioned()) { |
|
| 568 | + if ( ! $selectedClass['class']->isVersioned()) { |
|
| 569 | 569 | throw OptimisticLockException::lockFailed($selectedClass['class']->getClassName()); |
| 570 | 570 | } |
| 571 | 571 | } |
@@ -614,7 +614,7 @@ discard block |
||
| 614 | 614 | foreach ($class->getIdentifierColumns($this->em) as $column) { |
| 615 | 615 | $quotedColumnName = $this->platform->quoteIdentifier($column->getColumnName()); |
| 616 | 616 | |
| 617 | - $sqlParts[] = $tableAlias . '.' . $quotedColumnName; |
|
| 617 | + $sqlParts[] = $tableAlias.'.'.$quotedColumnName; |
|
| 618 | 618 | } |
| 619 | 619 | |
| 620 | 620 | return implode(', ', $sqlParts); |
@@ -632,7 +632,7 @@ discard block |
||
| 632 | 632 | { |
| 633 | 633 | $class = $this->queryComponents[$identificationVariable]['metadata']; |
| 634 | 634 | |
| 635 | - if (! $fieldName) { |
|
| 635 | + if ( ! $fieldName) { |
|
| 636 | 636 | return $this->getSQLTableAlias($class->getTableName(), $identificationVariable); |
| 637 | 637 | } |
| 638 | 638 | |
@@ -661,7 +661,7 @@ discard block |
||
| 661 | 661 | $property = $class->getProperty($fieldName); |
| 662 | 662 | |
| 663 | 663 | if ($this->useSqlTableAliases) { |
| 664 | - $sql .= $this->walkIdentificationVariable($dqlAlias, $fieldName) . '.'; |
|
| 664 | + $sql .= $this->walkIdentificationVariable($dqlAlias, $fieldName).'.'; |
|
| 665 | 665 | } |
| 666 | 666 | |
| 667 | 667 | $sql .= $this->platform->quoteIdentifier($property->getColumnName()); |
@@ -675,7 +675,7 @@ discard block |
||
| 675 | 675 | $class = $this->queryComponents[$dqlAlias]['metadata']; |
| 676 | 676 | $association = $class->getProperty($fieldName); |
| 677 | 677 | |
| 678 | - if (! $association->isOwningSide()) { |
|
| 678 | + if ( ! $association->isOwningSide()) { |
|
| 679 | 679 | throw QueryException::associationPathInverseSideNotSupported($pathExpr); |
| 680 | 680 | } |
| 681 | 681 | |
@@ -689,7 +689,7 @@ discard block |
||
| 689 | 689 | $joinColumn = reset($joinColumns); |
| 690 | 690 | |
| 691 | 691 | if ($this->useSqlTableAliases) { |
| 692 | - $sql .= $this->getSQLTableAlias($joinColumn->getTableName(), $dqlAlias) . '.'; |
|
| 692 | + $sql .= $this->getSQLTableAlias($joinColumn->getTableName(), $dqlAlias).'.'; |
|
| 693 | 693 | } |
| 694 | 694 | |
| 695 | 695 | $sql .= $this->platform->quoteIdentifier($joinColumn->getColumnName()); |
@@ -707,7 +707,7 @@ discard block |
||
| 707 | 707 | */ |
| 708 | 708 | public function walkSelectClause($selectClause) |
| 709 | 709 | { |
| 710 | - $sql = 'SELECT ' . ($selectClause->isDistinct ? 'DISTINCT ' : ''); |
|
| 710 | + $sql = 'SELECT '.($selectClause->isDistinct ? 'DISTINCT ' : ''); |
|
| 711 | 711 | $sqlSelectExpressions = array_filter(array_map([$this, 'walkSelectExpression'], $selectClause->selectExpressions)); |
| 712 | 712 | |
| 713 | 713 | if ($this->query->getHint(Query::HINT_INTERNAL_ITERATION) === true && $selectClause->isDistinct) { |
@@ -750,7 +750,7 @@ discard block |
||
| 750 | 750 | |
| 751 | 751 | $sqlSelectExpressions[] = sprintf( |
| 752 | 752 | '%s AS %s', |
| 753 | - $discrColumnType->convertToDatabaseValueSQL($sqlTableAlias . '.' . $quotedColumnName, $this->platform), |
|
| 753 | + $discrColumnType->convertToDatabaseValueSQL($sqlTableAlias.'.'.$quotedColumnName, $this->platform), |
|
| 754 | 754 | $sqlColumnAlias |
| 755 | 755 | ); |
| 756 | 756 | |
@@ -760,7 +760,7 @@ discard block |
||
| 760 | 760 | |
| 761 | 761 | // Add foreign key columns of class and also parent classes |
| 762 | 762 | foreach ($class->getPropertiesIterator() as $association) { |
| 763 | - if (! ($association instanceof ToOneAssociationMetadata && $association->isOwningSide()) |
|
| 763 | + if ( ! ($association instanceof ToOneAssociationMetadata && $association->isOwningSide()) |
|
| 764 | 764 | || ( ! $addMetaColumns && ! $association->isPrimaryKey())) { |
| 765 | 765 | continue; |
| 766 | 766 | } |
@@ -775,7 +775,7 @@ discard block |
||
| 775 | 775 | $columnAlias = $this->getSQLColumnAlias(); |
| 776 | 776 | $sqlTableAlias = $this->getSQLTableAlias($joinColumn->getTableName(), $dqlAlias); |
| 777 | 777 | |
| 778 | - if (! $joinColumn->getType()) { |
|
| 778 | + if ( ! $joinColumn->getType()) { |
|
| 779 | 779 | $joinColumn->setType(PersisterHelper::getTypeOfColumn($referencedColumnName, $targetClass, $this->em)); |
| 780 | 780 | } |
| 781 | 781 | |
@@ -791,7 +791,7 @@ discard block |
||
| 791 | 791 | } |
| 792 | 792 | |
| 793 | 793 | // Add foreign key columns to SQL, if necessary |
| 794 | - if (! $addMetaColumns) { |
|
| 794 | + if ( ! $addMetaColumns) { |
|
| 795 | 795 | continue; |
| 796 | 796 | } |
| 797 | 797 | |
@@ -805,7 +805,7 @@ discard block |
||
| 805 | 805 | continue; |
| 806 | 806 | } |
| 807 | 807 | |
| 808 | - if (! ($association instanceof ToOneAssociationMetadata && $association->isOwningSide())) { |
|
| 808 | + if ( ! ($association instanceof ToOneAssociationMetadata && $association->isOwningSide())) { |
|
| 809 | 809 | continue; |
| 810 | 810 | } |
| 811 | 811 | |
@@ -819,7 +819,7 @@ discard block |
||
| 819 | 819 | $columnAlias = $this->getSQLColumnAlias(); |
| 820 | 820 | $sqlTableAlias = $this->getSQLTableAlias($joinColumn->getTableName(), $dqlAlias); |
| 821 | 821 | |
| 822 | - if (! $joinColumn->getType()) { |
|
| 822 | + if ( ! $joinColumn->getType()) { |
|
| 823 | 823 | $joinColumn->setType(PersisterHelper::getTypeOfColumn($referencedColumnName, $targetClass, $this->em)); |
| 824 | 824 | } |
| 825 | 825 | |
@@ -836,7 +836,7 @@ discard block |
||
| 836 | 836 | } |
| 837 | 837 | } |
| 838 | 838 | |
| 839 | - return $sql . implode(', ', $sqlSelectExpressions); |
|
| 839 | + return $sql.implode(', ', $sqlSelectExpressions); |
|
| 840 | 840 | } |
| 841 | 841 | |
| 842 | 842 | /** |
@@ -851,7 +851,7 @@ discard block |
||
| 851 | 851 | $sqlParts[] = $this->walkIdentificationVariableDeclaration($identificationVariableDecl); |
| 852 | 852 | } |
| 853 | 853 | |
| 854 | - return ' FROM ' . implode(', ', $sqlParts); |
|
| 854 | + return ' FROM '.implode(', ', $sqlParts); |
|
| 855 | 855 | } |
| 856 | 856 | |
| 857 | 857 | /** |
@@ -926,7 +926,7 @@ discard block |
||
| 926 | 926 | $tableAlias = $this->getSQLTableAlias($class->getTableName(), $dqlAlias); |
| 927 | 927 | |
| 928 | 928 | $sql = $this->platform->appendLockHint( |
| 929 | - $tableName . ' ' . $tableAlias, |
|
| 929 | + $tableName.' '.$tableAlias, |
|
| 930 | 930 | $this->query->getHint(Query::HINT_LOCK_MODE) |
| 931 | 931 | ); |
| 932 | 932 | |
@@ -936,11 +936,11 @@ discard block |
||
| 936 | 936 | |
| 937 | 937 | $classTableInheritanceJoins = $this->generateClassTableInheritanceJoins($class, $dqlAlias); |
| 938 | 938 | |
| 939 | - if (! $buildNestedJoins) { |
|
| 940 | - return $sql . $classTableInheritanceJoins; |
|
| 939 | + if ( ! $buildNestedJoins) { |
|
| 940 | + return $sql.$classTableInheritanceJoins; |
|
| 941 | 941 | } |
| 942 | 942 | |
| 943 | - return $classTableInheritanceJoins === '' ? $sql : '(' . $sql . $classTableInheritanceJoins . ')'; |
|
| 943 | + return $classTableInheritanceJoins === '' ? $sql : '('.$sql.$classTableInheritanceJoins.')'; |
|
| 944 | 944 | } |
| 945 | 945 | |
| 946 | 946 | /** |
@@ -1030,7 +1030,7 @@ discard block |
||
| 1030 | 1030 | } |
| 1031 | 1031 | |
| 1032 | 1032 | $targetTableJoin = [ |
| 1033 | - 'table' => $targetTableName . ' ' . $targetTableAlias, |
|
| 1033 | + 'table' => $targetTableName.' '.$targetTableAlias, |
|
| 1034 | 1034 | 'condition' => implode(' AND ', $conditions), |
| 1035 | 1035 | ]; |
| 1036 | 1036 | } elseif ($owningAssociation instanceof ManyToManyAssociationMetadata) { |
@@ -1057,7 +1057,7 @@ discard block |
||
| 1057 | 1057 | ); |
| 1058 | 1058 | } |
| 1059 | 1059 | |
| 1060 | - $sql .= $joinTableName . ' ' . $joinTableAlias . ' ON ' . implode(' AND ', $conditions); |
|
| 1060 | + $sql .= $joinTableName.' '.$joinTableAlias.' ON '.implode(' AND ', $conditions); |
|
| 1061 | 1061 | |
| 1062 | 1062 | // Join target table |
| 1063 | 1063 | $sql .= $joinType === AST\Join::JOIN_TYPE_LEFT || $joinType === AST\Join::JOIN_TYPE_LEFTOUTER ? ' LEFT JOIN ' : ' INNER JOIN '; |
@@ -1095,7 +1095,7 @@ discard block |
||
| 1095 | 1095 | } |
| 1096 | 1096 | |
| 1097 | 1097 | $targetTableJoin = [ |
| 1098 | - 'table' => $targetTableName . ' ' . $targetTableAlias, |
|
| 1098 | + 'table' => $targetTableName.' '.$targetTableAlias, |
|
| 1099 | 1099 | 'condition' => implode(' AND ', $conditions), |
| 1100 | 1100 | ]; |
| 1101 | 1101 | } else { |
@@ -1103,23 +1103,23 @@ discard block |
||
| 1103 | 1103 | } |
| 1104 | 1104 | |
| 1105 | 1105 | // Handle WITH clause |
| 1106 | - $withCondition = $condExpr === null ? '' : ('(' . $this->walkConditionalExpression($condExpr) . ')'); |
|
| 1106 | + $withCondition = $condExpr === null ? '' : ('('.$this->walkConditionalExpression($condExpr).')'); |
|
| 1107 | 1107 | |
| 1108 | 1108 | if ($targetClass->inheritanceType === InheritanceType::JOINED) { |
| 1109 | 1109 | $ctiJoins = $this->generateClassTableInheritanceJoins($targetClass, $joinedDqlAlias); |
| 1110 | 1110 | |
| 1111 | 1111 | // If we have WITH condition, we need to build nested joins for target class table and cti joins |
| 1112 | 1112 | if ($withCondition) { |
| 1113 | - $sql .= '(' . $targetTableJoin['table'] . $ctiJoins . ') ON ' . $targetTableJoin['condition']; |
|
| 1113 | + $sql .= '('.$targetTableJoin['table'].$ctiJoins.') ON '.$targetTableJoin['condition']; |
|
| 1114 | 1114 | } else { |
| 1115 | - $sql .= $targetTableJoin['table'] . ' ON ' . $targetTableJoin['condition'] . $ctiJoins; |
|
| 1115 | + $sql .= $targetTableJoin['table'].' ON '.$targetTableJoin['condition'].$ctiJoins; |
|
| 1116 | 1116 | } |
| 1117 | 1117 | } else { |
| 1118 | - $sql .= $targetTableJoin['table'] . ' ON ' . $targetTableJoin['condition']; |
|
| 1118 | + $sql .= $targetTableJoin['table'].' ON '.$targetTableJoin['condition']; |
|
| 1119 | 1119 | } |
| 1120 | 1120 | |
| 1121 | 1121 | if ($withCondition) { |
| 1122 | - $sql .= ' AND ' . $withCondition; |
|
| 1122 | + $sql .= ' AND '.$withCondition; |
|
| 1123 | 1123 | } |
| 1124 | 1124 | |
| 1125 | 1125 | // Apply the indexes |
@@ -1153,7 +1153,7 @@ discard block |
||
| 1153 | 1153 | $orderByItems = array_merge($orderByItems, (array) $collectionOrderByItems); |
| 1154 | 1154 | } |
| 1155 | 1155 | |
| 1156 | - return ' ORDER BY ' . implode(', ', $orderByItems); |
|
| 1156 | + return ' ORDER BY '.implode(', ', $orderByItems); |
|
| 1157 | 1157 | } |
| 1158 | 1158 | |
| 1159 | 1159 | /** |
@@ -1170,10 +1170,10 @@ discard block |
||
| 1170 | 1170 | $this->orderedColumnsMap[$sql] = $type; |
| 1171 | 1171 | |
| 1172 | 1172 | if ($expr instanceof AST\Subselect) { |
| 1173 | - return '(' . $sql . ') ' . $type; |
|
| 1173 | + return '('.$sql.') '.$type; |
|
| 1174 | 1174 | } |
| 1175 | 1175 | |
| 1176 | - return $sql . ' ' . $type; |
|
| 1176 | + return $sql.' '.$type; |
|
| 1177 | 1177 | } |
| 1178 | 1178 | |
| 1179 | 1179 | /** |
@@ -1181,7 +1181,7 @@ discard block |
||
| 1181 | 1181 | */ |
| 1182 | 1182 | public function walkHavingClause($havingClause) |
| 1183 | 1183 | { |
| 1184 | - return ' HAVING ' . $this->walkConditionalExpression($havingClause->conditionalExpression); |
|
| 1184 | + return ' HAVING '.$this->walkConditionalExpression($havingClause->conditionalExpression); |
|
| 1185 | 1185 | } |
| 1186 | 1186 | |
| 1187 | 1187 | /** |
@@ -1204,7 +1204,7 @@ discard block |
||
| 1204 | 1204 | $conditions = []; |
| 1205 | 1205 | |
| 1206 | 1206 | if ($join->conditionalExpression) { |
| 1207 | - $conditions[] = '(' . $this->walkConditionalExpression($join->conditionalExpression) . ')'; |
|
| 1207 | + $conditions[] = '('.$this->walkConditionalExpression($join->conditionalExpression).')'; |
|
| 1208 | 1208 | } |
| 1209 | 1209 | |
| 1210 | 1210 | $isUnconditionalJoin = empty($conditions); |
@@ -1229,7 +1229,7 @@ discard block |
||
| 1229 | 1229 | } |
| 1230 | 1230 | |
| 1231 | 1231 | if ($conditions) { |
| 1232 | - $sql .= $condExprConjunction . implode(' AND ', $conditions); |
|
| 1232 | + $sql .= $condExprConjunction.implode(' AND ', $conditions); |
|
| 1233 | 1233 | } |
| 1234 | 1234 | |
| 1235 | 1235 | break; |
@@ -1259,7 +1259,7 @@ discard block |
||
| 1259 | 1259 | $scalarExpressions[] = $this->walkSimpleArithmeticExpression($scalarExpression); |
| 1260 | 1260 | } |
| 1261 | 1261 | |
| 1262 | - return $sql . implode(', ', $scalarExpressions) . ')'; |
|
| 1262 | + return $sql.implode(', ', $scalarExpressions).')'; |
|
| 1263 | 1263 | } |
| 1264 | 1264 | |
| 1265 | 1265 | /** |
@@ -1279,7 +1279,7 @@ discard block |
||
| 1279 | 1279 | ? $this->conn->quote($nullIfExpression->secondExpression) |
| 1280 | 1280 | : $this->walkSimpleArithmeticExpression($nullIfExpression->secondExpression); |
| 1281 | 1281 | |
| 1282 | - return 'NULLIF(' . $firstExpression . ', ' . $secondExpression . ')'; |
|
| 1282 | + return 'NULLIF('.$firstExpression.', '.$secondExpression.')'; |
|
| 1283 | 1283 | } |
| 1284 | 1284 | |
| 1285 | 1285 | /** |
@@ -1292,11 +1292,11 @@ discard block |
||
| 1292 | 1292 | $sql = 'CASE'; |
| 1293 | 1293 | |
| 1294 | 1294 | foreach ($generalCaseExpression->whenClauses as $whenClause) { |
| 1295 | - $sql .= ' WHEN ' . $this->walkConditionalExpression($whenClause->caseConditionExpression); |
|
| 1296 | - $sql .= ' THEN ' . $this->walkSimpleArithmeticExpression($whenClause->thenScalarExpression); |
|
| 1295 | + $sql .= ' WHEN '.$this->walkConditionalExpression($whenClause->caseConditionExpression); |
|
| 1296 | + $sql .= ' THEN '.$this->walkSimpleArithmeticExpression($whenClause->thenScalarExpression); |
|
| 1297 | 1297 | } |
| 1298 | 1298 | |
| 1299 | - $sql .= ' ELSE ' . $this->walkSimpleArithmeticExpression($generalCaseExpression->elseScalarExpression) . ' END'; |
|
| 1299 | + $sql .= ' ELSE '.$this->walkSimpleArithmeticExpression($generalCaseExpression->elseScalarExpression).' END'; |
|
| 1300 | 1300 | |
| 1301 | 1301 | return $sql; |
| 1302 | 1302 | } |
@@ -1310,14 +1310,14 @@ discard block |
||
| 1310 | 1310 | */ |
| 1311 | 1311 | public function walkSimpleCaseExpression($simpleCaseExpression) |
| 1312 | 1312 | { |
| 1313 | - $sql = 'CASE ' . $this->walkStateFieldPathExpression($simpleCaseExpression->caseOperand); |
|
| 1313 | + $sql = 'CASE '.$this->walkStateFieldPathExpression($simpleCaseExpression->caseOperand); |
|
| 1314 | 1314 | |
| 1315 | 1315 | foreach ($simpleCaseExpression->simpleWhenClauses as $simpleWhenClause) { |
| 1316 | - $sql .= ' WHEN ' . $this->walkSimpleArithmeticExpression($simpleWhenClause->caseScalarExpression); |
|
| 1317 | - $sql .= ' THEN ' . $this->walkSimpleArithmeticExpression($simpleWhenClause->thenScalarExpression); |
|
| 1316 | + $sql .= ' WHEN '.$this->walkSimpleArithmeticExpression($simpleWhenClause->caseScalarExpression); |
|
| 1317 | + $sql .= ' THEN '.$this->walkSimpleArithmeticExpression($simpleWhenClause->thenScalarExpression); |
|
| 1318 | 1318 | } |
| 1319 | 1319 | |
| 1320 | - $sql .= ' ELSE ' . $this->walkSimpleArithmeticExpression($simpleCaseExpression->elseScalarExpression) . ' END'; |
|
| 1320 | + $sql .= ' ELSE '.$this->walkSimpleArithmeticExpression($simpleCaseExpression->elseScalarExpression).' END'; |
|
| 1321 | 1321 | |
| 1322 | 1322 | return $sql; |
| 1323 | 1323 | } |
@@ -1358,7 +1358,7 @@ discard block |
||
| 1358 | 1358 | |
| 1359 | 1359 | $this->scalarResultAliasMap[$resultAlias] = $columnAlias; |
| 1360 | 1360 | |
| 1361 | - if (! $hidden) { |
|
| 1361 | + if ( ! $hidden) { |
|
| 1362 | 1362 | $this->rsm->addScalarResult($columnAlias, $resultAlias, $property->getType()); |
| 1363 | 1363 | $this->scalarFields[$dqlAlias][$fieldName] = $columnAlias; |
| 1364 | 1364 | } |
@@ -1379,11 +1379,11 @@ discard block |
||
| 1379 | 1379 | $columnAlias = $this->getSQLColumnAlias(); |
| 1380 | 1380 | $resultAlias = $selectExpression->fieldIdentificationVariable ?: $this->scalarResultCounter++; |
| 1381 | 1381 | |
| 1382 | - $sql .= $expr->dispatch($this) . ' AS ' . $columnAlias; |
|
| 1382 | + $sql .= $expr->dispatch($this).' AS '.$columnAlias; |
|
| 1383 | 1383 | |
| 1384 | 1384 | $this->scalarResultAliasMap[$resultAlias] = $columnAlias; |
| 1385 | 1385 | |
| 1386 | - if (! $hidden) { |
|
| 1386 | + if ( ! $hidden) { |
|
| 1387 | 1387 | // Conceptually we could resolve field type here by traverse through AST to retrieve field type, |
| 1388 | 1388 | // but this is not a feasible solution; assume 'string'. |
| 1389 | 1389 | $this->rsm->addScalarResult($columnAlias, $resultAlias, Type::getType('string')); |
@@ -1394,11 +1394,11 @@ discard block |
||
| 1394 | 1394 | $columnAlias = $this->getSQLColumnAlias(); |
| 1395 | 1395 | $resultAlias = $selectExpression->fieldIdentificationVariable ?: $this->scalarResultCounter++; |
| 1396 | 1396 | |
| 1397 | - $sql .= '(' . $this->walkSubselect($expr) . ') AS ' . $columnAlias; |
|
| 1397 | + $sql .= '('.$this->walkSubselect($expr).') AS '.$columnAlias; |
|
| 1398 | 1398 | |
| 1399 | 1399 | $this->scalarResultAliasMap[$resultAlias] = $columnAlias; |
| 1400 | 1400 | |
| 1401 | - if (! $hidden) { |
|
| 1401 | + if ( ! $hidden) { |
|
| 1402 | 1402 | // We cannot resolve field type here; assume 'string'. |
| 1403 | 1403 | $this->rsm->addScalarResult($columnAlias, $resultAlias, Type::getType('string')); |
| 1404 | 1404 | } |
@@ -1422,7 +1422,7 @@ discard block |
||
| 1422 | 1422 | $class = $queryComp['metadata']; |
| 1423 | 1423 | $resultAlias = $selectExpression->fieldIdentificationVariable ?: null; |
| 1424 | 1424 | |
| 1425 | - if (! isset($this->selectedClasses[$dqlAlias])) { |
|
| 1425 | + if ( ! isset($this->selectedClasses[$dqlAlias])) { |
|
| 1426 | 1426 | $this->selectedClasses[$dqlAlias] = [ |
| 1427 | 1427 | 'class' => $class, |
| 1428 | 1428 | 'dqlAlias' => $dqlAlias, |
@@ -1434,7 +1434,7 @@ discard block |
||
| 1434 | 1434 | |
| 1435 | 1435 | // Select all fields from the queried class |
| 1436 | 1436 | foreach ($class->getPropertiesIterator() as $fieldName => $property) { |
| 1437 | - if (! ($property instanceof FieldMetadata)) { |
|
| 1437 | + if ( ! ($property instanceof FieldMetadata)) { |
|
| 1438 | 1438 | continue; |
| 1439 | 1439 | } |
| 1440 | 1440 | |
@@ -1469,7 +1469,7 @@ discard block |
||
| 1469 | 1469 | $subClass = $this->em->getClassMetadata($subClassName); |
| 1470 | 1470 | |
| 1471 | 1471 | foreach ($subClass->getPropertiesIterator() as $fieldName => $property) { |
| 1472 | - if (! ($property instanceof FieldMetadata)) { |
|
| 1472 | + if ( ! ($property instanceof FieldMetadata)) { |
|
| 1473 | 1473 | continue; |
| 1474 | 1474 | } |
| 1475 | 1475 | |
@@ -1508,7 +1508,7 @@ discard block |
||
| 1508 | 1508 | */ |
| 1509 | 1509 | public function walkQuantifiedExpression($qExpr) |
| 1510 | 1510 | { |
| 1511 | - return ' ' . strtoupper($qExpr->type) . '(' . $this->walkSubselect($qExpr->subselect) . ')'; |
|
| 1511 | + return ' '.strtoupper($qExpr->type).'('.$this->walkSubselect($qExpr->subselect).')'; |
|
| 1512 | 1512 | } |
| 1513 | 1513 | |
| 1514 | 1514 | /** |
@@ -1548,7 +1548,7 @@ discard block |
||
| 1548 | 1548 | $sqlParts[] = $this->walkIdentificationVariableDeclaration($subselectIdVarDecl); |
| 1549 | 1549 | } |
| 1550 | 1550 | |
| 1551 | - return ' FROM ' . implode(', ', $sqlParts); |
|
| 1551 | + return ' FROM '.implode(', ', $sqlParts); |
|
| 1552 | 1552 | } |
| 1553 | 1553 | |
| 1554 | 1554 | /** |
@@ -1556,7 +1556,7 @@ discard block |
||
| 1556 | 1556 | */ |
| 1557 | 1557 | public function walkSimpleSelectClause($simpleSelectClause) |
| 1558 | 1558 | { |
| 1559 | - return 'SELECT' . ($simpleSelectClause->isDistinct ? ' DISTINCT' : '') |
|
| 1559 | + return 'SELECT'.($simpleSelectClause->isDistinct ? ' DISTINCT' : '') |
|
| 1560 | 1560 | . $this->walkSimpleSelectExpression($simpleSelectClause->simpleSelectExpression); |
| 1561 | 1561 | } |
| 1562 | 1562 | |
@@ -1590,7 +1590,7 @@ discard block |
||
| 1590 | 1590 | break; |
| 1591 | 1591 | |
| 1592 | 1592 | case $e instanceof AST\Subselect: |
| 1593 | - $sqlSelectExpressions[] = '(' . $e->dispatch($this) . ') AS ' . $columnAlias; |
|
| 1593 | + $sqlSelectExpressions[] = '('.$e->dispatch($this).') AS '.$columnAlias; |
|
| 1594 | 1594 | break; |
| 1595 | 1595 | |
| 1596 | 1596 | case $e instanceof AST\PathExpression: |
@@ -1599,7 +1599,7 @@ discard block |
||
| 1599 | 1599 | $class = $qComp['metadata']; |
| 1600 | 1600 | $fieldType = $class->getProperty($e->field)->getType(); |
| 1601 | 1601 | |
| 1602 | - $sqlSelectExpressions[] = trim((string) $e->dispatch($this)) . ' AS ' . $columnAlias; |
|
| 1602 | + $sqlSelectExpressions[] = trim((string) $e->dispatch($this)).' AS '.$columnAlias; |
|
| 1603 | 1603 | break; |
| 1604 | 1604 | |
| 1605 | 1605 | case $e instanceof AST\Literal: |
@@ -1613,11 +1613,11 @@ discard block |
||
| 1613 | 1613 | break; |
| 1614 | 1614 | } |
| 1615 | 1615 | |
| 1616 | - $sqlSelectExpressions[] = trim((string) $e->dispatch($this)) . ' AS ' . $columnAlias; |
|
| 1616 | + $sqlSelectExpressions[] = trim((string) $e->dispatch($this)).' AS '.$columnAlias; |
|
| 1617 | 1617 | break; |
| 1618 | 1618 | |
| 1619 | 1619 | default: |
| 1620 | - $sqlSelectExpressions[] = trim((string) $e->dispatch($this)) . ' AS ' . $columnAlias; |
|
| 1620 | + $sqlSelectExpressions[] = trim((string) $e->dispatch($this)).' AS '.$columnAlias; |
|
| 1621 | 1621 | break; |
| 1622 | 1622 | } |
| 1623 | 1623 | |
@@ -1650,10 +1650,10 @@ discard block |
||
| 1650 | 1650 | case $expr instanceof AST\Subselect: |
| 1651 | 1651 | $alias = $simpleSelectExpression->fieldIdentificationVariable ?: $this->scalarResultCounter++; |
| 1652 | 1652 | |
| 1653 | - $columnAlias = 'sclr' . $this->aliasCounter++; |
|
| 1653 | + $columnAlias = 'sclr'.$this->aliasCounter++; |
|
| 1654 | 1654 | $this->scalarResultAliasMap[$alias] = $columnAlias; |
| 1655 | 1655 | |
| 1656 | - $sql .= '(' . $this->walkSubselect($expr) . ') AS ' . $columnAlias; |
|
| 1656 | + $sql .= '('.$this->walkSubselect($expr).') AS '.$columnAlias; |
|
| 1657 | 1657 | break; |
| 1658 | 1658 | |
| 1659 | 1659 | case $expr instanceof AST\Functions\FunctionNode: |
@@ -1670,7 +1670,7 @@ discard block |
||
| 1670 | 1670 | $columnAlias = $this->getSQLColumnAlias(); |
| 1671 | 1671 | $this->scalarResultAliasMap[$alias] = $columnAlias; |
| 1672 | 1672 | |
| 1673 | - $sql .= $expr->dispatch($this) . ' AS ' . $columnAlias; |
|
| 1673 | + $sql .= $expr->dispatch($this).' AS '.$columnAlias; |
|
| 1674 | 1674 | break; |
| 1675 | 1675 | |
| 1676 | 1676 | case $expr instanceof AST\ParenthesisExpression: |
@@ -1690,8 +1690,8 @@ discard block |
||
| 1690 | 1690 | */ |
| 1691 | 1691 | public function walkAggregateExpression($aggExpression) |
| 1692 | 1692 | { |
| 1693 | - return $aggExpression->functionName . '(' . ($aggExpression->isDistinct ? 'DISTINCT ' : '') |
|
| 1694 | - . $this->walkSimpleArithmeticExpression($aggExpression->pathExpression) . ')'; |
|
| 1693 | + return $aggExpression->functionName.'('.($aggExpression->isDistinct ? 'DISTINCT ' : '') |
|
| 1694 | + . $this->walkSimpleArithmeticExpression($aggExpression->pathExpression).')'; |
|
| 1695 | 1695 | } |
| 1696 | 1696 | |
| 1697 | 1697 | /** |
@@ -1705,7 +1705,7 @@ discard block |
||
| 1705 | 1705 | $sqlParts[] = $this->walkGroupByItem($groupByItem); |
| 1706 | 1706 | } |
| 1707 | 1707 | |
| 1708 | - return ' GROUP BY ' . implode(', ', $sqlParts); |
|
| 1708 | + return ' GROUP BY '.implode(', ', $sqlParts); |
|
| 1709 | 1709 | } |
| 1710 | 1710 | |
| 1711 | 1711 | /** |
@@ -1714,7 +1714,7 @@ discard block |
||
| 1714 | 1714 | public function walkGroupByItem($groupByItem) |
| 1715 | 1715 | { |
| 1716 | 1716 | // StateFieldPathExpression |
| 1717 | - if (! is_string($groupByItem)) { |
|
| 1717 | + if ( ! is_string($groupByItem)) { |
|
| 1718 | 1718 | return $this->walkPathExpression($groupByItem); |
| 1719 | 1719 | } |
| 1720 | 1720 | |
@@ -1768,7 +1768,7 @@ discard block |
||
| 1768 | 1768 | { |
| 1769 | 1769 | $class = $this->em->getClassMetadata($deleteClause->abstractSchemaName); |
| 1770 | 1770 | $tableName = $class->getTableName(); |
| 1771 | - $sql = 'DELETE FROM ' . $class->table->getQuotedQualifiedName($this->platform); |
|
| 1771 | + $sql = 'DELETE FROM '.$class->table->getQuotedQualifiedName($this->platform); |
|
| 1772 | 1772 | |
| 1773 | 1773 | $this->setSQLTableAlias($tableName, $tableName, $deleteClause->aliasIdentificationVariable); |
| 1774 | 1774 | |
@@ -1784,12 +1784,12 @@ discard block |
||
| 1784 | 1784 | { |
| 1785 | 1785 | $class = $this->em->getClassMetadata($updateClause->abstractSchemaName); |
| 1786 | 1786 | $tableName = $class->getTableName(); |
| 1787 | - $sql = 'UPDATE ' . $class->table->getQuotedQualifiedName($this->platform); |
|
| 1787 | + $sql = 'UPDATE '.$class->table->getQuotedQualifiedName($this->platform); |
|
| 1788 | 1788 | |
| 1789 | 1789 | $this->setSQLTableAlias($tableName, $tableName, $updateClause->aliasIdentificationVariable); |
| 1790 | 1790 | $this->rootAliases[] = $updateClause->aliasIdentificationVariable; |
| 1791 | 1791 | |
| 1792 | - return $sql . ' SET ' . implode(', ', array_map([$this, 'walkUpdateItem'], $updateClause->updateItems)); |
|
| 1792 | + return $sql.' SET '.implode(', ', array_map([$this, 'walkUpdateItem'], $updateClause->updateItems)); |
|
| 1793 | 1793 | } |
| 1794 | 1794 | |
| 1795 | 1795 | /** |
@@ -1800,7 +1800,7 @@ discard block |
||
| 1800 | 1800 | $useTableAliasesBefore = $this->useSqlTableAliases; |
| 1801 | 1801 | $this->useSqlTableAliases = false; |
| 1802 | 1802 | |
| 1803 | - $sql = $this->walkPathExpression($updateItem->pathExpression) . ' = '; |
|
| 1803 | + $sql = $this->walkPathExpression($updateItem->pathExpression).' = '; |
|
| 1804 | 1804 | $newValue = $updateItem->newValue; |
| 1805 | 1805 | |
| 1806 | 1806 | switch (true) { |
@@ -1844,7 +1844,7 @@ discard block |
||
| 1844 | 1844 | |
| 1845 | 1845 | if ($filterClauses) { |
| 1846 | 1846 | if ($condSql) { |
| 1847 | - $condSql = '(' . $condSql . ') AND '; |
|
| 1847 | + $condSql = '('.$condSql.') AND '; |
|
| 1848 | 1848 | } |
| 1849 | 1849 | |
| 1850 | 1850 | $condSql .= implode(' AND ', $filterClauses); |
@@ -1852,11 +1852,11 @@ discard block |
||
| 1852 | 1852 | } |
| 1853 | 1853 | |
| 1854 | 1854 | if ($condSql) { |
| 1855 | - return ' WHERE ' . (! $discrSql ? $condSql : '(' . $condSql . ') AND ' . $discrSql); |
|
| 1855 | + return ' WHERE '.( ! $discrSql ? $condSql : '('.$condSql.') AND '.$discrSql); |
|
| 1856 | 1856 | } |
| 1857 | 1857 | |
| 1858 | 1858 | if ($discrSql) { |
| 1859 | - return ' WHERE ' . $discrSql; |
|
| 1859 | + return ' WHERE '.$discrSql; |
|
| 1860 | 1860 | } |
| 1861 | 1861 | |
| 1862 | 1862 | return ''; |
@@ -1869,7 +1869,7 @@ discard block |
||
| 1869 | 1869 | { |
| 1870 | 1870 | // Phase 2 AST optimization: Skip processing of ConditionalExpression |
| 1871 | 1871 | // if only one ConditionalTerm is defined |
| 1872 | - if (! ($condExpr instanceof AST\ConditionalExpression)) { |
|
| 1872 | + if ( ! ($condExpr instanceof AST\ConditionalExpression)) { |
|
| 1873 | 1873 | return $this->walkConditionalTerm($condExpr); |
| 1874 | 1874 | } |
| 1875 | 1875 | |
@@ -1883,7 +1883,7 @@ discard block |
||
| 1883 | 1883 | { |
| 1884 | 1884 | // Phase 2 AST optimization: Skip processing of ConditionalTerm |
| 1885 | 1885 | // if only one ConditionalFactor is defined |
| 1886 | - if (! ($condTerm instanceof AST\ConditionalTerm)) { |
|
| 1886 | + if ( ! ($condTerm instanceof AST\ConditionalTerm)) { |
|
| 1887 | 1887 | return $this->walkConditionalFactor($condTerm); |
| 1888 | 1888 | } |
| 1889 | 1889 | |
@@ -1899,7 +1899,7 @@ discard block |
||
| 1899 | 1899 | // if only one ConditionalPrimary is defined |
| 1900 | 1900 | return ! ($factor instanceof AST\ConditionalFactor) |
| 1901 | 1901 | ? $this->walkConditionalPrimary($factor) |
| 1902 | - : ($factor->not ? 'NOT ' : '') . $this->walkConditionalPrimary($factor->conditionalPrimary); |
|
| 1902 | + : ($factor->not ? 'NOT ' : '').$this->walkConditionalPrimary($factor->conditionalPrimary); |
|
| 1903 | 1903 | } |
| 1904 | 1904 | |
| 1905 | 1905 | /** |
@@ -1914,7 +1914,7 @@ discard block |
||
| 1914 | 1914 | if ($primary->isConditionalExpression()) { |
| 1915 | 1915 | $condExpr = $primary->conditionalExpression; |
| 1916 | 1916 | |
| 1917 | - return '(' . $this->walkConditionalExpression($condExpr) . ')'; |
|
| 1917 | + return '('.$this->walkConditionalExpression($condExpr).')'; |
|
| 1918 | 1918 | } |
| 1919 | 1919 | |
| 1920 | 1920 | return ''; |
@@ -1927,7 +1927,7 @@ discard block |
||
| 1927 | 1927 | { |
| 1928 | 1928 | $sql = $existsExpr->not ? 'NOT ' : ''; |
| 1929 | 1929 | |
| 1930 | - $sql .= 'EXISTS (' . $this->walkSubselect($existsExpr->subselect) . ')'; |
|
| 1930 | + $sql .= 'EXISTS ('.$this->walkSubselect($existsExpr->subselect).')'; |
|
| 1931 | 1931 | |
| 1932 | 1932 | return $sql; |
| 1933 | 1933 | } |
@@ -1975,7 +1975,7 @@ discard block |
||
| 1975 | 1975 | $targetTableAlias = $this->getSQLTableAlias($targetClass->getTableName()); |
| 1976 | 1976 | $sourceTableAlias = $this->getSQLTableAlias($class->getTableName(), $dqlAlias); |
| 1977 | 1977 | |
| 1978 | - $sql .= $targetTableName . ' ' . $targetTableAlias . ' WHERE '; |
|
| 1978 | + $sql .= $targetTableName.' '.$targetTableAlias.' WHERE '; |
|
| 1979 | 1979 | |
| 1980 | 1980 | $sqlParts = []; |
| 1981 | 1981 | |
@@ -1996,7 +1996,7 @@ discard block |
||
| 1996 | 1996 | $this->parserResult->addParameterMapping($dqlParamKey, $this->sqlParamIndex++); |
| 1997 | 1997 | } |
| 1998 | 1998 | |
| 1999 | - $sqlParts[] = $targetTableAlias . '.' . $quotedTargetColumnName . ' = ' . $entitySql; |
|
| 1999 | + $sqlParts[] = $targetTableAlias.'.'.$quotedTargetColumnName.' = '.$entitySql; |
|
| 2000 | 2000 | } |
| 2001 | 2001 | |
| 2002 | 2002 | $sql .= implode(' AND ', $sqlParts); |
@@ -2010,7 +2010,7 @@ discard block |
||
| 2010 | 2010 | $sourceTableAlias = $this->getSQLTableAlias($class->getTableName(), $dqlAlias); |
| 2011 | 2011 | |
| 2012 | 2012 | // join to target table |
| 2013 | - $sql .= $joinTableName . ' ' . $joinTableAlias . ' INNER JOIN ' . $targetTableName . ' ' . $targetTableAlias . ' ON '; |
|
| 2013 | + $sql .= $joinTableName.' '.$joinTableAlias.' INNER JOIN '.$targetTableName.' '.$targetTableAlias.' ON '; |
|
| 2014 | 2014 | |
| 2015 | 2015 | // join conditions |
| 2016 | 2016 | $joinSqlParts = []; |
@@ -2059,13 +2059,13 @@ discard block |
||
| 2059 | 2059 | $this->parserResult->addParameterMapping($dqlParamKey, $this->sqlParamIndex++); |
| 2060 | 2060 | } |
| 2061 | 2061 | |
| 2062 | - $sqlParts[] = $targetTableAlias . '.' . $quotedTargetColumnName . ' = ' . $entitySql; |
|
| 2062 | + $sqlParts[] = $targetTableAlias.'.'.$quotedTargetColumnName.' = '.$entitySql; |
|
| 2063 | 2063 | } |
| 2064 | 2064 | |
| 2065 | 2065 | $sql .= implode(' AND ', $sqlParts); |
| 2066 | 2066 | } |
| 2067 | 2067 | |
| 2068 | - return $sql . ')'; |
|
| 2068 | + return $sql.')'; |
|
| 2069 | 2069 | } |
| 2070 | 2070 | |
| 2071 | 2071 | /** |
@@ -2076,7 +2076,7 @@ discard block |
||
| 2076 | 2076 | $sizeFunc = new AST\Functions\SizeFunction('size'); |
| 2077 | 2077 | $sizeFunc->collectionPathExpression = $emptyCollCompExpr->expression; |
| 2078 | 2078 | |
| 2079 | - return $sizeFunc->getSql($this) . ($emptyCollCompExpr->not ? ' > 0' : ' = 0'); |
|
| 2079 | + return $sizeFunc->getSql($this).($emptyCollCompExpr->not ? ' > 0' : ' = 0'); |
|
| 2080 | 2080 | } |
| 2081 | 2081 | |
| 2082 | 2082 | /** |
@@ -2085,19 +2085,19 @@ discard block |
||
| 2085 | 2085 | public function walkNullComparisonExpression($nullCompExpr) |
| 2086 | 2086 | { |
| 2087 | 2087 | $expression = $nullCompExpr->expression; |
| 2088 | - $comparison = ' IS' . ($nullCompExpr->not ? ' NOT' : '') . ' NULL'; |
|
| 2088 | + $comparison = ' IS'.($nullCompExpr->not ? ' NOT' : '').' NULL'; |
|
| 2089 | 2089 | |
| 2090 | 2090 | // Handle ResultVariable |
| 2091 | 2091 | if (is_string($expression) && isset($this->queryComponents[$expression]['resultVariable'])) { |
| 2092 | - return $this->walkResultVariable($expression) . $comparison; |
|
| 2092 | + return $this->walkResultVariable($expression).$comparison; |
|
| 2093 | 2093 | } |
| 2094 | 2094 | |
| 2095 | 2095 | // Handle InputParameter mapping inclusion to ParserResult |
| 2096 | 2096 | if ($expression instanceof AST\InputParameter) { |
| 2097 | - return $this->walkInputParameter($expression) . $comparison; |
|
| 2097 | + return $this->walkInputParameter($expression).$comparison; |
|
| 2098 | 2098 | } |
| 2099 | 2099 | |
| 2100 | - return $expression->dispatch($this) . $comparison; |
|
| 2100 | + return $expression->dispatch($this).$comparison; |
|
| 2101 | 2101 | } |
| 2102 | 2102 | |
| 2103 | 2103 | /** |
@@ -2105,7 +2105,7 @@ discard block |
||
| 2105 | 2105 | */ |
| 2106 | 2106 | public function walkInExpression($inExpr) |
| 2107 | 2107 | { |
| 2108 | - $sql = $this->walkArithmeticExpression($inExpr->expression) . ($inExpr->not ? ' NOT' : '') . ' IN ('; |
|
| 2108 | + $sql = $this->walkArithmeticExpression($inExpr->expression).($inExpr->not ? ' NOT' : '').' IN ('; |
|
| 2109 | 2109 | |
| 2110 | 2110 | $sql .= $inExpr->subselect |
| 2111 | 2111 | ? $this->walkSubselect($inExpr->subselect) |
@@ -2130,12 +2130,12 @@ discard block |
||
| 2130 | 2130 | $discrColumnType = $discrColumn->getType(); |
| 2131 | 2131 | $quotedColumnName = $this->platform->quoteIdentifier($discrColumn->getColumnName()); |
| 2132 | 2132 | $sqlTableAlias = $this->useSqlTableAliases |
| 2133 | - ? $this->getSQLTableAlias($discrColumn->getTableName(), $dqlAlias) . '.' |
|
| 2133 | + ? $this->getSQLTableAlias($discrColumn->getTableName(), $dqlAlias).'.' |
|
| 2134 | 2134 | : ''; |
| 2135 | 2135 | |
| 2136 | 2136 | return sprintf( |
| 2137 | 2137 | '%s %sIN %s', |
| 2138 | - $discrColumnType->convertToDatabaseValueSQL($sqlTableAlias . $quotedColumnName, $this->platform), |
|
| 2138 | + $discrColumnType->convertToDatabaseValueSQL($sqlTableAlias.$quotedColumnName, $this->platform), |
|
| 2139 | 2139 | ($instanceOfExpr->not ? 'NOT ' : ''), |
| 2140 | 2140 | $this->getChildDiscriminatorsFromClassMetadata($discrClass, $instanceOfExpr) |
| 2141 | 2141 | ); |
@@ -2179,8 +2179,8 @@ discard block |
||
| 2179 | 2179 | $sql .= ' NOT'; |
| 2180 | 2180 | } |
| 2181 | 2181 | |
| 2182 | - $sql .= ' BETWEEN ' . $this->walkArithmeticExpression($betweenExpr->leftBetweenExpression) |
|
| 2183 | - . ' AND ' . $this->walkArithmeticExpression($betweenExpr->rightBetweenExpression); |
|
| 2182 | + $sql .= ' BETWEEN '.$this->walkArithmeticExpression($betweenExpr->leftBetweenExpression) |
|
| 2183 | + . ' AND '.$this->walkArithmeticExpression($betweenExpr->rightBetweenExpression); |
|
| 2184 | 2184 | |
| 2185 | 2185 | return $sql; |
| 2186 | 2186 | } |
@@ -2195,7 +2195,7 @@ discard block |
||
| 2195 | 2195 | ? $this->walkResultVariable($stringExpr) |
| 2196 | 2196 | : $stringExpr->dispatch($this); |
| 2197 | 2197 | |
| 2198 | - $sql = $leftExpr . ($likeExpr->not ? ' NOT' : '') . ' LIKE '; |
|
| 2198 | + $sql = $leftExpr.($likeExpr->not ? ' NOT' : '').' LIKE '; |
|
| 2199 | 2199 | |
| 2200 | 2200 | if ($likeExpr->stringPattern instanceof AST\InputParameter) { |
| 2201 | 2201 | $sql .= $this->walkInputParameter($likeExpr->stringPattern); |
@@ -2208,7 +2208,7 @@ discard block |
||
| 2208 | 2208 | } |
| 2209 | 2209 | |
| 2210 | 2210 | if ($likeExpr->escapeChar) { |
| 2211 | - $sql .= ' ESCAPE ' . $this->walkLiteral($likeExpr->escapeChar); |
|
| 2211 | + $sql .= ' ESCAPE '.$this->walkLiteral($likeExpr->escapeChar); |
|
| 2212 | 2212 | } |
| 2213 | 2213 | |
| 2214 | 2214 | return $sql; |
@@ -2235,7 +2235,7 @@ discard block |
||
| 2235 | 2235 | ? $leftExpr->dispatch($this) |
| 2236 | 2236 | : (is_numeric($leftExpr) ? $leftExpr : $this->conn->quote($leftExpr)); |
| 2237 | 2237 | |
| 2238 | - $sql .= ' ' . $compExpr->operator . ' '; |
|
| 2238 | + $sql .= ' '.$compExpr->operator.' '; |
|
| 2239 | 2239 | |
| 2240 | 2240 | $sql .= $rightExpr instanceof AST\Node |
| 2241 | 2241 | ? $rightExpr->dispatch($this) |
@@ -2271,7 +2271,7 @@ discard block |
||
| 2271 | 2271 | { |
| 2272 | 2272 | return $arithmeticExpr->isSimpleArithmeticExpression() |
| 2273 | 2273 | ? $this->walkSimpleArithmeticExpression($arithmeticExpr->simpleArithmeticExpression) |
| 2274 | - : '(' . $this->walkSubselect($arithmeticExpr->subselect) . ')'; |
|
| 2274 | + : '('.$this->walkSubselect($arithmeticExpr->subselect).')'; |
|
| 2275 | 2275 | } |
| 2276 | 2276 | |
| 2277 | 2277 | /** |
@@ -2279,7 +2279,7 @@ discard block |
||
| 2279 | 2279 | */ |
| 2280 | 2280 | public function walkSimpleArithmeticExpression($simpleArithmeticExpr) |
| 2281 | 2281 | { |
| 2282 | - if (! ($simpleArithmeticExpr instanceof AST\SimpleArithmeticExpression)) { |
|
| 2282 | + if ( ! ($simpleArithmeticExpr instanceof AST\SimpleArithmeticExpression)) { |
|
| 2283 | 2283 | return $this->walkArithmeticTerm($simpleArithmeticExpr); |
| 2284 | 2284 | } |
| 2285 | 2285 | |
@@ -2299,7 +2299,7 @@ discard block |
||
| 2299 | 2299 | |
| 2300 | 2300 | // Phase 2 AST optimization: Skip processing of ArithmeticTerm |
| 2301 | 2301 | // if only one ArithmeticFactor is defined |
| 2302 | - if (! ($term instanceof AST\ArithmeticTerm)) { |
|
| 2302 | + if ( ! ($term instanceof AST\ArithmeticTerm)) { |
|
| 2303 | 2303 | return $this->walkArithmeticFactor($term); |
| 2304 | 2304 | } |
| 2305 | 2305 | |
@@ -2319,13 +2319,13 @@ discard block |
||
| 2319 | 2319 | |
| 2320 | 2320 | // Phase 2 AST optimization: Skip processing of ArithmeticFactor |
| 2321 | 2321 | // if only one ArithmeticPrimary is defined |
| 2322 | - if (! ($factor instanceof AST\ArithmeticFactor)) { |
|
| 2322 | + if ( ! ($factor instanceof AST\ArithmeticFactor)) { |
|
| 2323 | 2323 | return $this->walkArithmeticPrimary($factor); |
| 2324 | 2324 | } |
| 2325 | 2325 | |
| 2326 | 2326 | $sign = $factor->isNegativeSigned() ? '-' : ($factor->isPositiveSigned() ? '+' : ''); |
| 2327 | 2327 | |
| 2328 | - return $sign . $this->walkArithmeticPrimary($factor->arithmeticPrimary); |
|
| 2328 | + return $sign.$this->walkArithmeticPrimary($factor->arithmeticPrimary); |
|
| 2329 | 2329 | } |
| 2330 | 2330 | |
| 2331 | 2331 | /** |
@@ -2338,7 +2338,7 @@ discard block |
||
| 2338 | 2338 | public function walkArithmeticPrimary($primary) |
| 2339 | 2339 | { |
| 2340 | 2340 | if ($primary instanceof AST\SimpleArithmeticExpression) { |
| 2341 | - return '(' . $this->walkSimpleArithmeticExpression($primary) . ')'; |
|
| 2341 | + return '('.$this->walkSimpleArithmeticExpression($primary).')'; |
|
| 2342 | 2342 | } |
| 2343 | 2343 | |
| 2344 | 2344 | if ($primary instanceof AST\Node) { |
@@ -2396,7 +2396,7 @@ discard block |
||
| 2396 | 2396 | $entityClassName = $entityClass->getClassName(); |
| 2397 | 2397 | |
| 2398 | 2398 | if ($entityClassName !== $rootClass->getClassName()) { |
| 2399 | - if (! $entityClass->getReflectionClass()->isSubclassOf($rootClass->getClassName())) { |
|
| 2399 | + if ( ! $entityClass->getReflectionClass()->isSubclassOf($rootClass->getClassName())) { |
|
| 2400 | 2400 | throw QueryException::instanceOfUnrelatedClass($entityClassName, $rootClass->getClassName()); |
| 2401 | 2401 | } |
| 2402 | 2402 | } |
@@ -2408,6 +2408,6 @@ discard block |
||
| 2408 | 2408 | $sqlParameterList[] = $this->conn->quote($discriminator); |
| 2409 | 2409 | } |
| 2410 | 2410 | |
| 2411 | - return '(' . implode(', ', $sqlParameterList) . ')'; |
|
| 2411 | + return '('.implode(', ', $sqlParameterList).')'; |
|
| 2412 | 2412 | } |
| 2413 | 2413 | } |