doctrine / orm

tests/Doctrine/Tests/ORM/Functional/QueryTest.php

Indentation +22 added lines, -22 removed lines

@@ -150,7 +150,7 @@ 
         $this->expectExceptionMessage('Too few parameters: the query defines 1 parameters but you only bound 0');
 
         $this->em->createQuery('SELECT u FROM ' . CmsUser::class . ' u WHERE u.name = ?1')
-                  ->getSingleResult();
+                    ->getSingleResult();
     }
 
     public function testInvalidInputParameterThrowsException() : void
@@ -158,8 +158,8 @@ 
         $this->expectException(QueryException::class);
 
         $this->em->createQuery('SELECT u FROM ' . CmsUser::class . ' u WHERE u.name = ?')
-                  ->setParameter(1, 'jwage')
-                  ->getSingleResult();
+                    ->setParameter(1, 'jwage')
+                    ->getSingleResult();
     }
 
     public function testSetParameters() : void
@@ -169,8 +169,8 @@ 
         $parameters->add(new Parameter(2, 'active'));
 
         $this->em->createQuery('SELECT u FROM ' . CmsUser::class . ' u WHERE u.name = ?1 AND u.status = ?2')
-                  ->setParameters($parameters)
-                  ->getResult();
+                    ->setParameters($parameters)
+                    ->getResult();
 
         $extractValue = static function (Parameter $parameter) {
             return $parameter->getValue();
@@ -187,8 +187,8 @@ 
         $parameters = [1 => 'jwage', 2 => 'active'];
 
         $this->em->createQuery('SELECT u FROM ' . CmsUser::class . ' u WHERE u.name = ?1 AND u.status = ?2')
-                  ->setParameters($parameters)
-                  ->getResult();
+                    ->setParameters($parameters)
+                    ->getResult();
 
         self::assertSame(
             \array_values($parameters),
@@ -332,7 +332,7 @@ 
     public function testGetSingleResultThrowsExceptionOnNoResult() : void
     {
         $this->em->createQuery('select a from Doctrine\Tests\Models\CMS\CmsArticle a')
-             ->getSingleResult();
+                ->getSingleResult();
     }
 
     /**
@@ -341,7 +341,7 @@ 
     public function testGetSingleScalarResultThrowsExceptionOnNoResult() : void
     {
         $this->em->createQuery('select a from Doctrine\Tests\Models\CMS\CmsArticle a')
-             ->getSingleScalarResult();
+                ->getSingleScalarResult();
     }
 
     /**
@@ -372,7 +372,7 @@ 
         $this->em->clear();
 
         $this->em->createQuery('select a from Doctrine\Tests\Models\CMS\CmsArticle a')
-             ->getSingleScalarResult();
+                ->getSingleScalarResult();
     }
 
     public function testModifiedLimitQuery() : void
@@ -389,27 +389,27 @@ 
         $this->em->clear();
 
         $data = $this->em->createQuery('SELECT u FROM ' . CmsUser::class . ' u')
-                  ->setFirstResult(1)
-                  ->setMaxResults(2)
-                  ->getResult();
+                    ->setFirstResult(1)
+                    ->setMaxResults(2)
+                    ->getResult();
 
         self::assertCount(2, $data);
         self::assertEquals('gblanco1', $data[0]->username);
         self::assertEquals('gblanco2', $data[1]->username);
 
         $data = $this->em->createQuery('SELECT u FROM ' . CmsUser::class . ' u')
-                  ->setFirstResult(3)
-                  ->setMaxResults(2)
-                  ->getResult();
+                    ->setFirstResult(3)
+                    ->setMaxResults(2)
+                    ->getResult();
 
         self::assertCount(2, $data);
         self::assertEquals('gblanco3', $data[0]->username);
         self::assertEquals('gblanco4', $data[1]->username);
 
         $data = $this->em->createQuery('SELECT u FROM ' . CmsUser::class . ' u')
-                  ->setFirstResult(3)
-                  ->setMaxResults(2)
-                  ->getScalarResult();
+                    ->setFirstResult(3)
+                    ->setMaxResults(2)
+                    ->getScalarResult();
     }
 
     /**
@@ -620,9 +620,9 @@ 
     {
         $qb = $this->em->createQueryBuilder();
         $qb->select('u')
-           ->from(CmsUser::class, 'u')
-           ->innerJoin('u.articles', 'a')
-           ->where('(u.id = 0) OR (u.id IS NULL)');
+            ->from(CmsUser::class, 'u')
+            ->innerJoin('u.articles', 'a')
+            ->where('(u.id = 0) OR (u.id IS NULL)');
 
         $query = $qb->getQuery();
         $users = $query->execute();

tests/Doctrine/Tests/ORM/Functional/QueryDqlFunctionTest.php

Indentation +19 added lines, -19 removed lines

@@ -27,7 +27,7 @@ 
     public function testAggregateSum() : void
     {
         $salarySum = $this->em->createQuery('SELECT SUM(m.salary) AS salary FROM Doctrine\Tests\Models\Company\CompanyManager m')
-                               ->getSingleResult();
+                                ->getSingleResult();
 
         self::assertEquals(1500000, $salarySum['salary']);
     }
@@ -35,7 +35,7 @@ 
     public function testAggregateAvg() : void
     {
         $salaryAvg = $this->em->createQuery('SELECT AVG(m.salary) AS salary FROM Doctrine\Tests\Models\Company\CompanyManager m')
-                               ->getSingleResult();
+                                ->getSingleResult();
 
         self::assertEquals(375000, \round($salaryAvg['salary'], 0));
     }
@@ -43,7 +43,7 @@ 
     public function testAggregateMin() : void
     {
         $salary = $this->em->createQuery('SELECT MIN(m.salary) AS salary FROM Doctrine\Tests\Models\Company\CompanyManager m')
-                               ->getSingleResult();
+                                ->getSingleResult();
 
         self::assertEquals(100000, $salary['salary']);
     }
@@ -51,7 +51,7 @@ 
     public function testAggregateMax() : void
     {
         $salary = $this->em->createQuery('SELECT MAX(m.salary) AS salary FROM Doctrine\Tests\Models\Company\CompanyManager m')
-                               ->getSingleResult();
+                                ->getSingleResult();
 
         self::assertEquals(800000, $salary['salary']);
     }
@@ -59,7 +59,7 @@ 
     public function testAggregateCount() : void
     {
         $managerCount = $this->em->createQuery('SELECT COUNT(m.id) AS managers FROM Doctrine\Tests\Models\Company\CompanyManager m')
-                               ->getSingleResult();
+                                ->getSingleResult();
 
         self::assertEquals(4, $managerCount['managers']);
     }
@@ -67,7 +67,7 @@ 
     public function testFunctionAbs() : void
     {
         $result = $this->em->createQuery('SELECT m, ABS(m.salary * -1) AS abs FROM Doctrine\Tests\Models\Company\CompanyManager m ORDER BY m.salary ASC')
-                         ->getResult();
+                            ->getResult();
 
         self::assertCount(4, $result);
         self::assertEquals(100000, $result[0]['abs']);
@@ -79,7 +79,7 @@ 
     public function testFunctionConcat() : void
     {
         $arg = $this->em->createQuery('SELECT m, CONCAT(m.name, m.department) AS namedep FROM Doctrine\Tests\Models\Company\CompanyManager m ORDER BY m.salary ASC')
-                         ->getArrayResult();
+                            ->getArrayResult();
 
         self::assertCount(4, $arg);
         self::assertEquals('Roman B.IT', $arg[0]['namedep']);
@@ -91,7 +91,7 @@ 
     public function testFunctionLength() : void
     {
         $result = $this->em->createQuery('SELECT m, LENGTH(CONCAT(m.name, m.department)) AS namedeplength FROM Doctrine\Tests\Models\Company\CompanyManager m ORDER BY m.salary ASC')
-                         ->getArrayResult();
+                            ->getArrayResult();
 
         self::assertCount(4, $result);
         self::assertEquals(10, $result[0]['namedeplength']);
@@ -103,10 +103,10 @@ 
     public function testFunctionLocate() : void
     {
         $dql = "SELECT m, LOCATE('e', LOWER(m.name)) AS loc, LOCATE('e', LOWER(m.name), 7) AS loc2 " .
-               'FROM Doctrine\Tests\Models\Company\CompanyManager m ORDER BY m.salary ASC';
+                'FROM Doctrine\Tests\Models\Company\CompanyManager m ORDER BY m.salary ASC';
 
         $result = $this->em->createQuery($dql)
-                         ->getArrayResult();
+                            ->getArrayResult();
 
         self::assertCount(4, $result);
         self::assertEquals(0, $result[0]['loc']);
@@ -122,7 +122,7 @@ 
     public function testFunctionLower() : void
     {
         $result = $this->em->createQuery('SELECT m, LOWER(m.name) AS lowername FROM Doctrine\Tests\Models\Company\CompanyManager m ORDER BY m.salary ASC')
-                         ->getArrayResult();
+                            ->getArrayResult();
 
         self::assertCount(4, $result);
         self::assertEquals('roman b.', $result[0]['lowername']);
@@ -134,7 +134,7 @@ 
     public function testFunctionMod() : void
     {
         $result = $this->em->createQuery('SELECT m, MOD(m.salary, 3500) AS amod FROM Doctrine\Tests\Models\Company\CompanyManager m ORDER BY m.salary ASC')
-                         ->getArrayResult();
+                            ->getArrayResult();
 
         self::assertCount(4, $result);
         self::assertEquals(2000, $result[0]['amod']);
@@ -146,7 +146,7 @@ 
     public function testFunctionSqrt() : void
     {
         $result = $this->em->createQuery('SELECT m, SQRT(m.salary) AS sqrtsalary FROM Doctrine\Tests\Models\Company\CompanyManager m ORDER BY m.salary ASC')
-                         ->getArrayResult();
+                            ->getArrayResult();
 
         self::assertCount(4, $result);
         self::assertEquals(316, \round($result[0]['sqrtsalary']));
@@ -158,7 +158,7 @@ 
     public function testFunctionUpper() : void
     {
         $result = $this->em->createQuery('SELECT m, UPPER(m.name) AS uppername FROM Doctrine\Tests\Models\Company\CompanyManager m ORDER BY m.salary ASC')
-                         ->getArrayResult();
+                            ->getArrayResult();
 
         self::assertCount(4, $result);
         self::assertEquals('ROMAN B.', $result[0]['uppername']);
@@ -173,7 +173,7 @@ 
                 'FROM Doctrine\Tests\Models\Company\CompanyManager m ORDER BY m.name';
 
         $result = $this->em->createQuery($dql)
-                         ->getArrayResult();
+                            ->getArrayResult();
 
         self::assertCount(4, $result);
         self::assertEquals('Ben', $result[0]['str1']);
@@ -190,8 +190,8 @@ 
     public function testFunctionTrim() : void
     {
         $dql = "SELECT m, TRIM(TRAILING '.' FROM m.name) AS str1, " .
-               " TRIM(LEADING '.' FROM m.name) AS str2, TRIM(CONCAT(' ', CONCAT(m.name, ' '))) AS str3 " .
-               'FROM Doctrine\Tests\Models\Company\CompanyManager m ORDER BY m.salary ASC';
+                " TRIM(LEADING '.' FROM m.name) AS str2, TRIM(CONCAT(' ', CONCAT(m.name, ' '))) AS str3 " .
+                'FROM Doctrine\Tests\Models\Company\CompanyManager m ORDER BY m.salary ASC';
 
         $result = $this->em->createQuery($dql)->getArrayResult();
 
@@ -333,8 +333,8 @@ 
         );
 
         $result = $this->em->createQuery($query)
-                           ->setMaxResults(1)
-                           ->getSingleResult(AbstractQuery::HYDRATE_ARRAY);
+                            ->setMaxResults(1)
+                            ->getSingleResult(AbstractQuery::HYDRATE_ARRAY);
 
         self::assertArrayHasKey('now', $result);
         self::assertArrayHasKey('sub', $result);

lib/Doctrine/ORM/Query/AST/Node.php

Indentation +2 added lines, -2 removed lines

@@ -60,7 +60,7 @@ 
             foreach ($props as $name => $prop) {
                 $ident += 4;
                 $str   .= \str_repeat(' ', $ident) . '"' . $name . '": '
-                      . $this->dump($prop) . ',' . PHP_EOL;
+                        . $this->dump($prop) . ',' . PHP_EOL;
                 $ident -= 4;
             }
 
@@ -72,7 +72,7 @@ 
 
             foreach ($obj as $k => $v) {
                 $str .= PHP_EOL . \str_repeat(' ', $ident) . '"'
-                      . $k . '" => ' . $this->dump($v) . ',';
+                        . $k . '" => ' . $this->dump($v) . ',';
                 $some = true;
             }
 

lib/Doctrine/ORM/Query/Expr/Join.php

Indentation +3 added lines, -3 removed lines

@@ -107,8 +107,8 @@
     public function __toString()
     {
         return \strtoupper($this->joinType) . ' JOIN ' . $this->join
-             . ($this->alias ? ' ' . $this->alias : '')
-             . ($this->indexBy ? ' INDEX BY ' . $this->indexBy : '')
-             . ($this->condition ? ' ' . \strtoupper($this->conditionType) . ' ' . $this->condition : '');
+                . ($this->alias ? ' ' . $this->alias : '')
+                . ($this->indexBy ? ' INDEX BY ' . $this->indexBy : '')
+                . ($this->condition ? ' ' . \strtoupper($this->conditionType) . ' ' . $this->condition : '');
     }
 }

lib/Doctrine/ORM/Persisters/Collection/OneToManyPersister.php

Indentation +1 added lines, -1 removed lines

@@ -247,7 +247,7 @@
 
         // 2) Build insert table records into temporary table
         $dql   = ' SELECT t0.' . \implode(', t0.', $rootClass->getIdentifierFieldNames())
-               . ' FROM ' . $targetClass->getClassName() . ' t0 WHERE t0.' . $association->getMappedBy() . ' = :owner';
+                . ' FROM ' . $targetClass->getClassName() . ' t0 WHERE t0.' . $association->getMappedBy() . ' = :owner';
         $query = $this->em->createQuery($dql)->setParameter('owner', $collection->getOwner());
 
         $statement  = 'INSERT INTO ' . $tempTable . ' (' . $idColumnNameList . ') ' . $query->getSQL();

lib/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php

Indentation +9 added lines, -9 removed lines

@@ -303,8 +303,8 @@ 
 
         // FIXME: Order with composite keys might not be correct
         $sql = 'SELECT ' . $columnName
-             . ' FROM ' . $tableName
-             . ' WHERE ' . \implode(' = ? AND ', $identifier) . ' = ?';
+                . ' FROM ' . $tableName
+                . ' WHERE ' . \implode(' = ? AND ', $identifier) . ' = ?';
 
         $flattenedId = $this->em->getIdentifierFlattener()->flattenIdentifier($versionedClass, $id);
         $versionType = $versionProperty->getType();
@@ -517,8 +517,8 @@ 
         }
 
         $sql = 'UPDATE ' . $quotedTableName
-             . ' SET ' . \implode(', ', $set)
-             . ' WHERE ' . \implode(' = ? AND ', $where) . ' = ?';
+                . ' SET ' . \implode(', ', $set)
+                . ' WHERE ' . \implode(' = ? AND ', $where) . ' = ?';
 
         $result = $this->conn->executeUpdate($sql, $params, $types);
 
@@ -1637,9 +1637,9 @@ 
         $lock  = $this->getLockTablesSql($lockMode);
         $where = ($conditionSql ? ' WHERE ' . $conditionSql : '') . ' ';
         $sql   = 'SELECT 1 '
-             . $lock
-             . $where
-             . $lockSql;
+                . $lock
+                . $where
+                . $lockSql;
 
         [$params, $types] = $this->expandParameters($criteria);
 
@@ -2107,8 +2107,8 @@ 
         $alias = $this->getSQLTableAlias($this->class->getTableName());
 
         $sql = 'SELECT 1 '
-             . $this->getLockTablesSql(null)
-             . ' WHERE ' . $this->getSelectConditionSQL($criteria);
+                . $this->getLockTablesSql(null)
+                . ' WHERE ' . $this->getSelectConditionSQL($criteria);
 
         [$params, $types] = $this->expandParameters($criteria);
 

lib/Doctrine/ORM/QueryBuilder.php

Indentation +15 added lines, -15 removed lines

@@ -1353,9 +1353,9 @@ 
     private function getDQLForDelete()
     {
         return 'DELETE'
-              . $this->getReducedDQLQueryPart('from', ['pre' => ' ', 'separator' => ', '])
-              . $this->getReducedDQLQueryPart('where', ['pre' => ' WHERE '])
-              . $this->getReducedDQLQueryPart('orderBy', ['pre' => ' ORDER BY ', 'separator' => ', ']);
+                . $this->getReducedDQLQueryPart('from', ['pre' => ' ', 'separator' => ', '])
+                . $this->getReducedDQLQueryPart('where', ['pre' => ' WHERE '])
+                . $this->getReducedDQLQueryPart('orderBy', ['pre' => ' ORDER BY ', 'separator' => ', ']);
     }
 
     /**
@@ -1364,10 +1364,10 @@ 
     private function getDQLForUpdate()
     {
         return 'UPDATE'
-              . $this->getReducedDQLQueryPart('from', ['pre' => ' ', 'separator' => ', '])
-              . $this->getReducedDQLQueryPart('set', ['pre' => ' SET ', 'separator' => ', '])
-              . $this->getReducedDQLQueryPart('where', ['pre' => ' WHERE '])
-              . $this->getReducedDQLQueryPart('orderBy', ['pre' => ' ORDER BY ', 'separator' => ', ']);
+                . $this->getReducedDQLQueryPart('from', ['pre' => ' ', 'separator' => ', '])
+                . $this->getReducedDQLQueryPart('set', ['pre' => ' SET ', 'separator' => ', '])
+                . $this->getReducedDQLQueryPart('where', ['pre' => ' WHERE '])
+                . $this->getReducedDQLQueryPart('orderBy', ['pre' => ' ORDER BY ', 'separator' => ', ']);
     }
 
     /**
@@ -1376,8 +1376,8 @@ 
     private function getDQLForSelect()
     {
         $dql = 'SELECT'
-             . ($this->dqlParts['distinct']===true ? ' DISTINCT' : '')
-             . $this->getReducedDQLQueryPart('select', ['pre' => ' ', 'separator' => ', ']);
+                . ($this->dqlParts['distinct']===true ? ' DISTINCT' : '')
+                . $this->getReducedDQLQueryPart('select', ['pre' => ' ', 'separator' => ', ']);
 
         $fromParts   = $this->getDQLPart('from');
         $joinParts   = $this->getDQLPart('join');
@@ -1401,10 +1401,10 @@ 
         }
 
         $dql .= \implode(', ', $fromClauses)
-              . $this->getReducedDQLQueryPart('where', ['pre' => ' WHERE '])
-              . $this->getReducedDQLQueryPart('groupBy', ['pre' => ' GROUP BY ', 'separator' => ', '])
-              . $this->getReducedDQLQueryPart('having', ['pre' => ' HAVING '])
-              . $this->getReducedDQLQueryPart('orderBy', ['pre' => ' ORDER BY ', 'separator' => ', ']);
+                . $this->getReducedDQLQueryPart('where', ['pre' => ' WHERE '])
+                . $this->getReducedDQLQueryPart('groupBy', ['pre' => ' GROUP BY ', 'separator' => ', '])
+                . $this->getReducedDQLQueryPart('having', ['pre' => ' HAVING '])
+                . $this->getReducedDQLQueryPart('orderBy', ['pre' => ' ORDER BY ', 'separator' => ', ']);
 
         return $dql;
     }
@@ -1424,8 +1424,8 @@ 
         }
 
         return ($options['pre'] ?? '')
-             . (\is_array($queryPart) ? \implode($options['separator'], $queryPart) : $queryPart)
-             . ($options['post'] ?? '');
+                . (\is_array($queryPart) ? \implode($options['separator'], $queryPart) : $queryPart)
+                . ($options['post'] ?? '');
     }
 
     /**