doctrine / orm

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

Indentation +12 added lines, -12 removed lines

@@ -36,37 +36,37 @@
         $dql = "SELECT u FROM Doctrine\Tests\Models\Cms\CmsUser u";
 
         $users = $this->em->createQuery($dql)
-                      ->setHydrationCacheProfile(new QueryCacheProfile(null, null, $cache))
-                      ->getResult();
+                        ->setHydrationCacheProfile(new QueryCacheProfile(null, null, $cache))
+                        ->getResult();
 
         $c = $this->getCurrentQueryCount();
         $users = $this->em->createQuery($dql)
-                      ->setHydrationCacheProfile(new QueryCacheProfile(null, null, $cache))
-                      ->getResult();
+                        ->setHydrationCacheProfile(new QueryCacheProfile(null, null, $cache))
+                        ->getResult();
 
         self::assertEquals($c, $this->getCurrentQueryCount(), 'Should not execute query. Its cached!');
 
         $users = $this->em->createQuery($dql)
-                      ->setHydrationCacheProfile(new QueryCacheProfile(null, null, $cache))
-                      ->getArrayResult();
+                        ->setHydrationCacheProfile(new QueryCacheProfile(null, null, $cache))
+                        ->getArrayResult();
 
         self::assertEquals($c + 1, $this->getCurrentQueryCount(), 'Hydration is part of cache key.');
 
         $users = $this->em->createQuery($dql)
-                      ->setHydrationCacheProfile(new QueryCacheProfile(null, null, $cache))
-                      ->getArrayResult();
+                        ->setHydrationCacheProfile(new QueryCacheProfile(null, null, $cache))
+                        ->getArrayResult();
 
         self::assertEquals($c + 1, $this->getCurrentQueryCount(), 'Hydration now cached');
 
         $users = $this->em->createQuery($dql)
-                      ->setHydrationCacheProfile(new QueryCacheProfile(null, 'cachekey', $cache))
-                      ->getArrayResult();
+                        ->setHydrationCacheProfile(new QueryCacheProfile(null, 'cachekey', $cache))
+                        ->getArrayResult();
 
         self::assertTrue($cache->contains('cachekey'), 'Explicit cache key');
 
         $users = $this->em->createQuery($dql)
-                      ->setHydrationCacheProfile(new QueryCacheProfile(null, 'cachekey', $cache))
-                      ->getArrayResult();
+                        ->setHydrationCacheProfile(new QueryCacheProfile(null, 'cachekey', $cache))
+                        ->getArrayResult();
         self::assertEquals($c + 2, $this->getCurrentQueryCount(), 'Hydration now cached');
     }
 

tests/Doctrine/Tests/ORM/Functional/Ticket/DDC618Test.php

Indentation +4 added lines, -4 removed lines

@@ -74,7 +74,7 @@ 
     public function testIndexByJoin()
     {
         $dql = 'SELECT A, B FROM Doctrine\Tests\ORM\Functional\Ticket\DDC618Author A ' .
-               'INNER JOIN A.books B INDEX BY B.title ORDER BY A.name ASC';
+                'INNER JOIN A.books B INDEX BY B.title ORDER BY A.name ASC';
         $result = $this->em->createQuery($dql)->getResult(\Doctrine\ORM\Query::HYDRATE_OBJECT);
 
         self::assertCount(3, $result[0]->books); // Alice, Joe doesn't appear because he has no books.
@@ -98,14 +98,14 @@ 
     public function testIndexByToOneJoinSilentlyIgnored()
     {
         $dql = 'SELECT B, A FROM Doctrine\Tests\ORM\Functional\Ticket\DDC618Book B ' .
-               'INNER JOIN B.author A INDEX BY A.name ORDER BY A.name ASC';
+                'INNER JOIN B.author A INDEX BY A.name ORDER BY A.name ASC';
         $result = $this->em->createQuery($dql)->getResult(\Doctrine\ORM\Query::HYDRATE_OBJECT);
 
         self::assertInstanceOf(DDC618Book::class, $result[0]);
         self::assertInstanceOf(DDC618Author::class, $result[0]->author);
 
         $dql = 'SELECT B, A FROM Doctrine\Tests\ORM\Functional\Ticket\DDC618Book B ' .
-               'INNER JOIN B.author A INDEX BY A.name ORDER BY A.name ASC';
+                'INNER JOIN B.author A INDEX BY A.name ORDER BY A.name ASC';
         $result = $this->em->createQuery($dql)->getResult(\Doctrine\ORM\Query::HYDRATE_ARRAY);
 
         self::assertEquals('Alice', $result[0]['author']['name']);
@@ -117,7 +117,7 @@ 
     public function testCombineIndexBy()
     {
         $dql = 'SELECT A, B FROM Doctrine\Tests\ORM\Functional\Ticket\DDC618Author A INDEX BY A.id ' .
-               'INNER JOIN A.books B INDEX BY B.title ORDER BY A.name ASC';
+                'INNER JOIN A.books B INDEX BY B.title ORDER BY A.name ASC';
         $result = $this->em->createQuery($dql)->getResult(\Doctrine\ORM\Query::HYDRATE_OBJECT);
 
         self::assertArrayHasKey(11, $result); // Alice

tests/Doctrine/Tests/ORM/Functional/Ticket/DDC117Test.php

Indentation +10 added lines, -10 removed lines

@@ -150,9 +150,9 @@ 
 
         $dql = "DELETE Doctrine\Tests\Models\DDC117\DDC117Reference r WHERE r.source = ?1 AND r.target = ?2";
         $this->em->createQuery($dql)
-                  ->setParameter(1, $this->article1->id())
-                  ->setParameter(2, $this->article2->id())
-                  ->execute();
+                    ->setParameter(1, $this->article1->id())
+                    ->setParameter(2, $this->article2->id())
+                    ->execute();
 
         self::assertNull($this->em->find(DDC117Reference::class, $idCriteria));
     }
@@ -202,9 +202,9 @@ 
 
         $dql = 'SELECT t, a FROM Doctrine\Tests\Models\DDC117\DDC117Translation t JOIN t.article a WHERE t.article = ?1 AND t.language = ?2';
         $dqlTrans = $this->em->createQuery($dql)
-                              ->setParameter(1, $this->article1->id())
-                              ->setParameter(2, 'en')
-                              ->getSingleResult();
+                                ->setParameter(1, $this->article1->id())
+                                ->setParameter(2, 'en')
+                                ->getSingleResult();
 
         self::assertInstanceOf(DDC117Translation::class, $this->translation);
     }
@@ -369,11 +369,11 @@ 
         $this->em->clear();
 
         $dql = "SELECT t, e FROM Doctrine\Tests\Models\DDC117\DDC117Translation t " .
-               'JOIN t.reviewedByEditors e WHERE t.article = ?1 AND t.language = ?2';
+                'JOIN t.reviewedByEditors e WHERE t.article = ?1 AND t.language = ?2';
         $trans = $this->em->createQuery($dql)
-                           ->setParameter(1, $this->translation->getArticleId())
-                           ->setParameter(2, $this->translation->getLanguage())
-                           ->getSingleResult();
+                            ->setParameter(1, $this->translation->getArticleId())
+                            ->setParameter(2, $this->translation->getLanguage())
+                            ->getSingleResult();
 
         self::assertInstanceOf(DDC117Translation::class, $trans);
         self::assertContainsOnly(DDC117Editor::class, $trans->reviewedByEditors);

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

Indentation +2 added lines, -2 removed lines

@@ -104,8 +104,8 @@
         $routeId = $this->createPersistedRouteWithLegs();
 
         $route = $this->em->createQuery("SELECT r, l FROM Doctrine\Tests\Models\Routing\RoutingRoute r JOIN r.legs l WHERE r.id = ?1")
-                           ->setParameter(1, $routeId)
-                           ->getSingleResult();
+                            ->setParameter(1, $routeId)
+                            ->getSingleResult();
 
         self::assertCount(2, $route->legs);
         self::assertEquals('Berlin', $route->legs[0]->fromLocation->getName());

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

Indentation +11 added lines, -11 removed lines

@@ -27,8 +27,8 @@ 
     public function testAggregateWithHavingClause()
     {
         $dql = 'SELECT p.department, AVG(p.salary) AS avgSalary ' .
-               'FROM Doctrine\Tests\Models\Company\CompanyEmployee p ' .
-               'GROUP BY p.department HAVING SUM(p.salary) > 200000 ORDER BY p.department';
+                'FROM Doctrine\Tests\Models\Company\CompanyEmployee p ' .
+                'GROUP BY p.department HAVING SUM(p.salary) > 200000 ORDER BY p.department';
 
         $result = $this->em->createQuery($dql)->getScalarResult();
 
@@ -42,8 +42,8 @@ 
     public function testUnnamedScalarResultsAreOneBased()
     {
         $dql = 'SELECT p.department, AVG(p.salary) ' .
-               'FROM Doctrine\Tests\Models\Company\CompanyEmployee p ' .
-               'GROUP BY p.department HAVING SUM(p.salary) > 200000 ORDER BY p.department';
+                'FROM Doctrine\Tests\Models\Company\CompanyEmployee p ' .
+                'GROUP BY p.department HAVING SUM(p.salary) > 200000 ORDER BY p.department';
 
         $result = $this->em->createQuery($dql)->getScalarResult();
 
@@ -55,9 +55,9 @@ 
     public function testOrderByResultVariableCollectionSize()
     {
         $dql = 'SELECT p.name, size(p.friends) AS friends ' .
-               'FROM Doctrine\Tests\Models\Company\CompanyPerson p ' .
-               'WHERE p.friends IS NOT EMPTY ' .
-               'ORDER BY friends DESC, p.name DESC';
+                'FROM Doctrine\Tests\Models\Company\CompanyPerson p ' .
+                'WHERE p.friends IS NOT EMPTY ' .
+                'ORDER BY friends DESC, p.name DESC';
 
         $result = $this->em->createQuery($dql)->getScalarResult();
 
@@ -79,7 +79,7 @@ 
     public function testIsNullAssociation()
     {
         $dql = 'SELECT p FROM Doctrine\Tests\Models\Company\CompanyPerson p ' .
-               'WHERE p.spouse IS NULL';
+                'WHERE p.spouse IS NULL';
         $result = $this->em->createQuery($dql)->getResult();
 
         self::assertCount(2, $result);
@@ -93,7 +93,7 @@ 
     public function testSelectSubselect()
     {
         $dql = 'SELECT p, (SELECT c.brand FROM Doctrine\Tests\Models\Company\CompanyCar c WHERE p.car = c) brandName ' .
-               'FROM Doctrine\Tests\Models\Company\CompanyManager p';
+                'FROM Doctrine\Tests\Models\Company\CompanyManager p';
         $result = $this->em->createQuery($dql)->getArrayResult();
 
         self::assertCount(1, $result);
@@ -103,7 +103,7 @@ 
     public function testInSubselect()
     {
         $dql = "SELECT p.name FROM Doctrine\Tests\Models\Company\CompanyPerson p " .
-               "WHERE p.name IN (SELECT n.name FROM Doctrine\Tests\Models\Company\CompanyPerson n WHERE n.name = 'Roman B.')";
+                "WHERE p.name IN (SELECT n.name FROM Doctrine\Tests\Models\Company\CompanyPerson n WHERE n.name = 'Roman B.')";
         $result = $this->em->createQuery($dql)->getScalarResult();
 
         self::assertCount(1, $result);
@@ -113,7 +113,7 @@ 
     public function testGroupByMultipleFields()
     {
         $dql = 'SELECT p.department, p.name, count(p.id) FROM Doctrine\Tests\Models\Company\CompanyEmployee p ' .
-               'GROUP BY p.department, p.name';
+                'GROUP BY p.department, p.name';
         $result = $this->em->createQuery($dql)->getResult();
 
         self::assertCount(4, $result);

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

Indentation +19 added lines, -19 removed lines

@@ -25,7 +25,7 @@ 
     public function testAggregateSum()
     {
         $salarySum = $this->em->createQuery('SELECT SUM(m.salary) AS salary FROM Doctrine\Tests\Models\Company\CompanyManager m')
-                               ->getSingleResult();
+                                ->getSingleResult();
 
         self::assertEquals(1500000, $salarySum['salary']);
     }
@@ -33,7 +33,7 @@ 
     public function testAggregateAvg()
     {
         $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));
     }
@@ -41,7 +41,7 @@ 
     public function testAggregateMin()
     {
         $salary = $this->em->createQuery('SELECT MIN(m.salary) AS salary FROM Doctrine\Tests\Models\Company\CompanyManager m')
-                               ->getSingleResult();
+                                ->getSingleResult();
 
         self::assertEquals(100000, $salary['salary']);
     }
@@ -49,7 +49,7 @@ 
     public function testAggregateMax()
     {
         $salary = $this->em->createQuery('SELECT MAX(m.salary) AS salary FROM Doctrine\Tests\Models\Company\CompanyManager m')
-                               ->getSingleResult();
+                                ->getSingleResult();
 
         self::assertEquals(800000, $salary['salary']);
     }
@@ -57,7 +57,7 @@ 
     public function testAggregateCount()
     {
         $managerCount = $this->em->createQuery('SELECT COUNT(m.id) AS managers FROM Doctrine\Tests\Models\Company\CompanyManager m')
-                               ->getSingleResult();
+                                ->getSingleResult();
 
         self::assertEquals(4, $managerCount['managers']);
     }
@@ -65,7 +65,7 @@ 
     public function testFunctionAbs()
     {
         $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']);
@@ -77,7 +77,7 @@ 
     public function testFunctionConcat()
     {
         $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']);
@@ -89,7 +89,7 @@ 
     public function testFunctionLength()
     {
         $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']);
@@ -101,10 +101,10 @@ 
     public function testFunctionLocate()
     {
         $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']);
@@ -120,7 +120,7 @@ 
     public function testFunctionLower()
     {
         $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']);
@@ -132,7 +132,7 @@ 
     public function testFunctionMod()
     {
         $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']);
@@ -144,7 +144,7 @@ 
     public function testFunctionSqrt()
     {
         $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']));
@@ -156,7 +156,7 @@ 
     public function testFunctionUpper()
     {
         $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']);
@@ -171,7 +171,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']);
@@ -188,8 +188,8 @@ 
     public function testFunctionTrim()
     {
         $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();
 
@@ -330,8 +330,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);

tests/Doctrine/Tests/ORM/Hydration/ObjectHydratorTest.php

Indentation +15 added lines, -15 removed lines

@@ -1918,10 +1918,10 @@ 
         $rsm->setDiscriminatorColumn('c', 'c_discr');
 
         $resultSet = [
-              [
-                  'c__id'   => '1',
-                  'c_discr' => 'fix',
-              ],
+                [
+                    'c__id'   => '1',
+                    'c_discr' => 'fix',
+                ],
         ];
 
         $stmt     = new HydratorMockStatement($resultSet);
@@ -1950,12 +1950,12 @@ 
         $rsm->setDiscriminatorColumn('e', 'e_discr');
 
         $resultSet = [
-              [
-                  'c__id'   => '1',
-                  'c_discr' => 'fix',
-                  'e__id'   => '1',
-                  'e__name' => 'Fabio B. Silva',
-              ],
+                [
+                    'c__id'   => '1',
+                    'c_discr' => 'fix',
+                    'e__id'   => '1',
+                    'e__name' => 'Fabio B. Silva',
+                ],
         ];
 
         $stmt     = new HydratorMockStatement($resultSet);
@@ -1980,11 +1980,11 @@ 
         $rsm->setDiscriminatorColumn('p', 'discr');
 
         $resultSet = [
-              [
-                  'p__id'   => '1',
-                  'p__name' => 'Fabio B. Silva',
-                  'discr'   => 'subworker',
-              ],
+                [
+                    'p__id'   => '1',
+                    'p__name' => 'Fabio B. Silva',
+                    'discr'   => 'subworker',
+                ],
         ];
 
         $stmt       = new HydratorMockStatement($resultSet);

tests/Doctrine/Tests/ORM/Hydration/SimpleObjectHydratorTest.php

Indentation +9 added lines, -9 removed lines

@@ -33,10 +33,10 @@ 
         $rsm->setDiscriminatorColumn('p', 'discr');
 
         $resultSet = [
-              [
-                  'u__id'   => '1',
-                  'u__name' => 'Fabio B. Silva',
-              ],
+                [
+                    'u__id'   => '1',
+                    'u__name' => 'Fabio B. Silva',
+                ],
         ];
 
         $stmt     = new HydratorMockStatement($resultSet);
@@ -89,11 +89,11 @@ 
         $rsm->setDiscriminatorColumn('p', 'discr');
 
         $resultSet = [
-              [
-                  'p__id'   => '1',
-                  'p__name' => 'Fabio B. Silva',
-                  'discr'   => 'subworker',
-              ],
+                [
+                    'p__id'   => '1',
+                    'p__name' => 'Fabio B. Silva',
+                    'discr'   => 'subworker',
+                ],
         ];
 
         $stmt     = new HydratorMockStatement($resultSet);

tests/Doctrine/Tests/ORM/Functional/Ticket/DDC698Test.php

Indentation +2 added lines, -2 removed lines

@@ -26,8 +26,8 @@
     {
         $qb = $this->em->createQueryBuilder();
         $qb->select('p', 'r')
-           ->from(__NAMESPACE__ . '\DDC698Privilege', 'p')
-           ->leftJoin('p.roles', 'r');
+            ->from(__NAMESPACE__ . '\DDC698Privilege', 'p')
+            ->leftJoin('p.roles', 'r');
 
         self::assertSQLEquals(
             'SELECT t0."privilegeID" AS c0, t0."name" AS c1, t1."roleID" AS c2, t1."name" AS c3, t1."shortName" AS c4 FROM "Privileges" t0 LEFT JOIN "RolePrivileges" t2 ON t0."privilegeID" = t2."privilegeID" LEFT JOIN "Roles" t1 ON t1."roleID" = t2."roleID"',