@@ -30,8 +30,8 @@ |
||
| 30 | 30 | public function testCmsModelSet(string $path) : void |
| 31 | 31 | { |
| 32 | 32 | $this->em->getConfiguration() |
| 33 | - ->getMetadataDriverImpl() |
|
| 34 | - ->addPaths([$path]); |
|
| 33 | + ->getMetadataDriverImpl() |
|
| 34 | + ->addPaths([$path]); |
|
| 35 | 35 | |
| 36 | 36 | self::assertEmpty($this->validator->validateMapping()); |
| 37 | 37 | } |
@@ -283,7 +283,7 @@ discard block |
||
| 283 | 283 | public function testExceptionIsThrownWhenCallingFindByWithoutParameter() : void |
| 284 | 284 | { |
| 285 | 285 | $this->em->getRepository(CmsUser::class) |
| 286 | - ->findByStatus(); |
|
| 286 | + ->findByStatus(); |
|
| 287 | 287 | } |
| 288 | 288 | |
| 289 | 289 | /** |
@@ -292,7 +292,7 @@ discard block |
||
| 292 | 292 | public function testExceptionIsThrownWhenUsingInvalidFieldName() : void |
| 293 | 293 | { |
| 294 | 294 | $this->em->getRepository(CmsUser::class) |
| 295 | - ->findByThisFieldDoesNotExist('testvalue'); |
|
| 295 | + ->findByThisFieldDoesNotExist('testvalue'); |
|
| 296 | 296 | } |
| 297 | 297 | |
| 298 | 298 | /** |
@@ -304,7 +304,7 @@ discard block |
||
| 304 | 304 | $this->expectException(TransactionRequiredException::class); |
| 305 | 305 | |
| 306 | 306 | $this->em->getRepository(CmsUser::class) |
| 307 | - ->find(1, LockMode::PESSIMISTIC_READ); |
|
| 307 | + ->find(1, LockMode::PESSIMISTIC_READ); |
|
| 308 | 308 | } |
| 309 | 309 | |
| 310 | 310 | /** |
@@ -316,7 +316,7 @@ discard block |
||
| 316 | 316 | $this->expectException(TransactionRequiredException::class); |
| 317 | 317 | |
| 318 | 318 | $this->em->getRepository(CmsUser::class) |
| 319 | - ->find(1, LockMode::PESSIMISTIC_WRITE); |
|
| 319 | + ->find(1, LockMode::PESSIMISTIC_WRITE); |
|
| 320 | 320 | } |
| 321 | 321 | |
| 322 | 322 | /** |
@@ -328,7 +328,7 @@ discard block |
||
| 328 | 328 | $this->expectException(OptimisticLockException::class); |
| 329 | 329 | |
| 330 | 330 | $this->em->getRepository(CmsUser::class) |
| 331 | - ->find(1, LockMode::OPTIMISTIC); |
|
| 331 | + ->find(1, LockMode::OPTIMISTIC); |
|
| 332 | 332 | } |
| 333 | 333 | |
| 334 | 334 | /** |
@@ -26,8 +26,8 @@ discard block |
||
| 26 | 26 | public function testAggregateWithHavingClause() : void |
| 27 | 27 | { |
| 28 | 28 | $dql = 'SELECT p.department, AVG(p.salary) AS avgSalary ' . |
| 29 | - 'FROM Doctrine\Tests\Models\Company\CompanyEmployee p ' . |
|
| 30 | - 'GROUP BY p.department HAVING SUM(p.salary) > 200000 ORDER BY p.department'; |
|
| 29 | + 'FROM Doctrine\Tests\Models\Company\CompanyEmployee p ' . |
|
| 30 | + 'GROUP BY p.department HAVING SUM(p.salary) > 200000 ORDER BY p.department'; |
|
| 31 | 31 | |
| 32 | 32 | $result = $this->em->createQuery($dql)->getScalarResult(); |
| 33 | 33 | |
@@ -41,8 +41,8 @@ discard block |
||
| 41 | 41 | public function testUnnamedScalarResultsAreOneBased() : void |
| 42 | 42 | { |
| 43 | 43 | $dql = 'SELECT p.department, AVG(p.salary) ' . |
| 44 | - 'FROM Doctrine\Tests\Models\Company\CompanyEmployee p ' . |
|
| 45 | - 'GROUP BY p.department HAVING SUM(p.salary) > 200000 ORDER BY p.department'; |
|
| 44 | + 'FROM Doctrine\Tests\Models\Company\CompanyEmployee p ' . |
|
| 45 | + 'GROUP BY p.department HAVING SUM(p.salary) > 200000 ORDER BY p.department'; |
|
| 46 | 46 | |
| 47 | 47 | $result = $this->em->createQuery($dql)->getScalarResult(); |
| 48 | 48 | |
@@ -54,9 +54,9 @@ discard block |
||
| 54 | 54 | public function testOrderByResultVariableCollectionSize() : void |
| 55 | 55 | { |
| 56 | 56 | $dql = 'SELECT p.name, size(p.friends) AS friends ' . |
| 57 | - 'FROM Doctrine\Tests\Models\Company\CompanyPerson p ' . |
|
| 58 | - 'WHERE p.friends IS NOT EMPTY ' . |
|
| 59 | - 'ORDER BY friends DESC, p.name DESC'; |
|
| 57 | + 'FROM Doctrine\Tests\Models\Company\CompanyPerson p ' . |
|
| 58 | + 'WHERE p.friends IS NOT EMPTY ' . |
|
| 59 | + 'ORDER BY friends DESC, p.name DESC'; |
|
| 60 | 60 | |
| 61 | 61 | $result = $this->em->createQuery($dql)->getScalarResult(); |
| 62 | 62 | |
@@ -78,7 +78,7 @@ discard block |
||
| 78 | 78 | public function testIsNullAssociation() : void |
| 79 | 79 | { |
| 80 | 80 | $dql = 'SELECT p FROM Doctrine\Tests\Models\Company\CompanyPerson p ' . |
| 81 | - 'WHERE p.spouse IS NULL'; |
|
| 81 | + 'WHERE p.spouse IS NULL'; |
|
| 82 | 82 | $result = $this->em->createQuery($dql)->getResult(); |
| 83 | 83 | |
| 84 | 84 | self::assertCount(2, $result); |
@@ -92,7 +92,7 @@ discard block |
||
| 92 | 92 | public function testSelectSubselect() : void |
| 93 | 93 | { |
| 94 | 94 | $dql = 'SELECT p, (SELECT c.brand FROM Doctrine\Tests\Models\Company\CompanyCar c WHERE p.car = c) brandName ' . |
| 95 | - 'FROM Doctrine\Tests\Models\Company\CompanyManager p'; |
|
| 95 | + 'FROM Doctrine\Tests\Models\Company\CompanyManager p'; |
|
| 96 | 96 | $result = $this->em->createQuery($dql)->getArrayResult(); |
| 97 | 97 | |
| 98 | 98 | self::assertCount(1, $result); |
@@ -102,7 +102,7 @@ discard block |
||
| 102 | 102 | public function testInSubselect() : void |
| 103 | 103 | { |
| 104 | 104 | $dql = 'SELECT p.name FROM Doctrine\Tests\Models\Company\CompanyPerson p ' . |
| 105 | - "WHERE p.name IN (SELECT n.name FROM Doctrine\Tests\Models\Company\CompanyPerson n WHERE n.name = 'Roman B.')"; |
|
| 105 | + "WHERE p.name IN (SELECT n.name FROM Doctrine\Tests\Models\Company\CompanyPerson n WHERE n.name = 'Roman B.')"; |
|
| 106 | 106 | $result = $this->em->createQuery($dql)->getScalarResult(); |
| 107 | 107 | |
| 108 | 108 | self::assertCount(1, $result); |
@@ -112,7 +112,7 @@ discard block |
||
| 112 | 112 | public function testGroupByMultipleFields() : void |
| 113 | 113 | { |
| 114 | 114 | $dql = 'SELECT p.department, p.name, count(p.id) FROM Doctrine\Tests\Models\Company\CompanyEmployee p ' . |
| 115 | - 'GROUP BY p.department, p.name'; |
|
| 115 | + 'GROUP BY p.department, p.name'; |
|
| 116 | 116 | $result = $this->em->createQuery($dql)->getResult(); |
| 117 | 117 | |
| 118 | 118 | self::assertCount(4, $result); |
@@ -150,7 +150,7 @@ discard block |
||
| 150 | 150 | $this->expectExceptionMessage('Too few parameters: the query defines 1 parameters but you only bound 0'); |
| 151 | 151 | |
| 152 | 152 | $this->em->createQuery('SELECT u FROM ' . CmsUser::class . ' u WHERE u.name = ?1') |
| 153 | - ->getSingleResult(); |
|
| 153 | + ->getSingleResult(); |
|
| 154 | 154 | } |
| 155 | 155 | |
| 156 | 156 | public function testInvalidInputParameterThrowsException() : void |
@@ -158,8 +158,8 @@ discard block |
||
| 158 | 158 | $this->expectException(QueryException::class); |
| 159 | 159 | |
| 160 | 160 | $this->em->createQuery('SELECT u FROM ' . CmsUser::class . ' u WHERE u.name = ?') |
| 161 | - ->setParameter(1, 'jwage') |
|
| 162 | - ->getSingleResult(); |
|
| 161 | + ->setParameter(1, 'jwage') |
|
| 162 | + ->getSingleResult(); |
|
| 163 | 163 | } |
| 164 | 164 | |
| 165 | 165 | public function testSetParameters() : void |
@@ -169,8 +169,8 @@ discard block |
||
| 169 | 169 | $parameters->add(new Parameter(2, 'active')); |
| 170 | 170 | |
| 171 | 171 | $this->em->createQuery('SELECT u FROM ' . CmsUser::class . ' u WHERE u.name = ?1 AND u.status = ?2') |
| 172 | - ->setParameters($parameters) |
|
| 173 | - ->getResult(); |
|
| 172 | + ->setParameters($parameters) |
|
| 173 | + ->getResult(); |
|
| 174 | 174 | |
| 175 | 175 | $extractValue = function (Parameter $parameter) { |
| 176 | 176 | return $parameter->getValue(); |
@@ -187,8 +187,8 @@ discard block |
||
| 187 | 187 | $parameters = [1 => 'jwage', 2 => 'active']; |
| 188 | 188 | |
| 189 | 189 | $this->em->createQuery('SELECT u FROM ' . CmsUser::class . ' u WHERE u.name = ?1 AND u.status = ?2') |
| 190 | - ->setParameters($parameters) |
|
| 191 | - ->getResult(); |
|
| 190 | + ->setParameters($parameters) |
|
| 191 | + ->getResult(); |
|
| 192 | 192 | |
| 193 | 193 | self::assertSame( |
| 194 | 194 | array_values($parameters), |
@@ -332,7 +332,7 @@ discard block |
||
| 332 | 332 | public function testGetSingleResultThrowsExceptionOnNoResult() : void |
| 333 | 333 | { |
| 334 | 334 | $this->em->createQuery('select a from Doctrine\Tests\Models\CMS\CmsArticle a') |
| 335 | - ->getSingleResult(); |
|
| 335 | + ->getSingleResult(); |
|
| 336 | 336 | } |
| 337 | 337 | |
| 338 | 338 | /** |
@@ -341,7 +341,7 @@ discard block |
||
| 341 | 341 | public function testGetSingleScalarResultThrowsExceptionOnNoResult() : void |
| 342 | 342 | { |
| 343 | 343 | $this->em->createQuery('select a from Doctrine\Tests\Models\CMS\CmsArticle a') |
| 344 | - ->getSingleScalarResult(); |
|
| 344 | + ->getSingleScalarResult(); |
|
| 345 | 345 | } |
| 346 | 346 | |
| 347 | 347 | /** |
@@ -372,7 +372,7 @@ discard block |
||
| 372 | 372 | $this->em->clear(); |
| 373 | 373 | |
| 374 | 374 | $this->em->createQuery('select a from Doctrine\Tests\Models\CMS\CmsArticle a') |
| 375 | - ->getSingleScalarResult(); |
|
| 375 | + ->getSingleScalarResult(); |
|
| 376 | 376 | } |
| 377 | 377 | |
| 378 | 378 | public function testModifiedLimitQuery() : void |
@@ -389,27 +389,27 @@ discard block |
||
| 389 | 389 | $this->em->clear(); |
| 390 | 390 | |
| 391 | 391 | $data = $this->em->createQuery('SELECT u FROM ' . CmsUser::class . ' u') |
| 392 | - ->setFirstResult(1) |
|
| 393 | - ->setMaxResults(2) |
|
| 394 | - ->getResult(); |
|
| 392 | + ->setFirstResult(1) |
|
| 393 | + ->setMaxResults(2) |
|
| 394 | + ->getResult(); |
|
| 395 | 395 | |
| 396 | 396 | self::assertCount(2, $data); |
| 397 | 397 | self::assertEquals('gblanco1', $data[0]->username); |
| 398 | 398 | self::assertEquals('gblanco2', $data[1]->username); |
| 399 | 399 | |
| 400 | 400 | $data = $this->em->createQuery('SELECT u FROM ' . CmsUser::class . ' u') |
| 401 | - ->setFirstResult(3) |
|
| 402 | - ->setMaxResults(2) |
|
| 403 | - ->getResult(); |
|
| 401 | + ->setFirstResult(3) |
|
| 402 | + ->setMaxResults(2) |
|
| 403 | + ->getResult(); |
|
| 404 | 404 | |
| 405 | 405 | self::assertCount(2, $data); |
| 406 | 406 | self::assertEquals('gblanco3', $data[0]->username); |
| 407 | 407 | self::assertEquals('gblanco4', $data[1]->username); |
| 408 | 408 | |
| 409 | 409 | $data = $this->em->createQuery('SELECT u FROM ' . CmsUser::class . ' u') |
| 410 | - ->setFirstResult(3) |
|
| 411 | - ->setMaxResults(2) |
|
| 412 | - ->getScalarResult(); |
|
| 410 | + ->setFirstResult(3) |
|
| 411 | + ->setMaxResults(2) |
|
| 412 | + ->getScalarResult(); |
|
| 413 | 413 | } |
| 414 | 414 | |
| 415 | 415 | /** |
@@ -620,9 +620,9 @@ discard block |
||
| 620 | 620 | { |
| 621 | 621 | $qb = $this->em->createQueryBuilder(); |
| 622 | 622 | $qb->select('u') |
| 623 | - ->from(CmsUser::class, 'u') |
|
| 624 | - ->innerJoin('u.articles', 'a') |
|
| 625 | - ->where('(u.id = 0) OR (u.id IS NULL)'); |
|
| 623 | + ->from(CmsUser::class, 'u') |
|
| 624 | + ->innerJoin('u.articles', 'a') |
|
| 625 | + ->where('(u.id = 0) OR (u.id IS NULL)'); |
|
| 626 | 626 | |
| 627 | 627 | $query = $qb->getQuery(); |
| 628 | 628 | $users = $query->execute(); |
@@ -26,7 +26,7 @@ discard block |
||
| 26 | 26 | public function testAggregateSum() : void |
| 27 | 27 | { |
| 28 | 28 | $salarySum = $this->em->createQuery('SELECT SUM(m.salary) AS salary FROM Doctrine\Tests\Models\Company\CompanyManager m') |
| 29 | - ->getSingleResult(); |
|
| 29 | + ->getSingleResult(); |
|
| 30 | 30 | |
| 31 | 31 | self::assertEquals(1500000, $salarySum['salary']); |
| 32 | 32 | } |
@@ -34,7 +34,7 @@ discard block |
||
| 34 | 34 | public function testAggregateAvg() : void |
| 35 | 35 | { |
| 36 | 36 | $salaryAvg = $this->em->createQuery('SELECT AVG(m.salary) AS salary FROM Doctrine\Tests\Models\Company\CompanyManager m') |
| 37 | - ->getSingleResult(); |
|
| 37 | + ->getSingleResult(); |
|
| 38 | 38 | |
| 39 | 39 | self::assertEquals(375000, round($salaryAvg['salary'], 0)); |
| 40 | 40 | } |
@@ -42,7 +42,7 @@ discard block |
||
| 42 | 42 | public function testAggregateMin() : void |
| 43 | 43 | { |
| 44 | 44 | $salary = $this->em->createQuery('SELECT MIN(m.salary) AS salary FROM Doctrine\Tests\Models\Company\CompanyManager m') |
| 45 | - ->getSingleResult(); |
|
| 45 | + ->getSingleResult(); |
|
| 46 | 46 | |
| 47 | 47 | self::assertEquals(100000, $salary['salary']); |
| 48 | 48 | } |
@@ -50,7 +50,7 @@ discard block |
||
| 50 | 50 | public function testAggregateMax() : void |
| 51 | 51 | { |
| 52 | 52 | $salary = $this->em->createQuery('SELECT MAX(m.salary) AS salary FROM Doctrine\Tests\Models\Company\CompanyManager m') |
| 53 | - ->getSingleResult(); |
|
| 53 | + ->getSingleResult(); |
|
| 54 | 54 | |
| 55 | 55 | self::assertEquals(800000, $salary['salary']); |
| 56 | 56 | } |
@@ -58,7 +58,7 @@ discard block |
||
| 58 | 58 | public function testAggregateCount() : void |
| 59 | 59 | { |
| 60 | 60 | $managerCount = $this->em->createQuery('SELECT COUNT(m.id) AS managers FROM Doctrine\Tests\Models\Company\CompanyManager m') |
| 61 | - ->getSingleResult(); |
|
| 61 | + ->getSingleResult(); |
|
| 62 | 62 | |
| 63 | 63 | self::assertEquals(4, $managerCount['managers']); |
| 64 | 64 | } |
@@ -66,7 +66,7 @@ discard block |
||
| 66 | 66 | public function testFunctionAbs() : void |
| 67 | 67 | { |
| 68 | 68 | $result = $this->em->createQuery('SELECT m, ABS(m.salary * -1) AS abs FROM Doctrine\Tests\Models\Company\CompanyManager m ORDER BY m.salary ASC') |
| 69 | - ->getResult(); |
|
| 69 | + ->getResult(); |
|
| 70 | 70 | |
| 71 | 71 | self::assertCount(4, $result); |
| 72 | 72 | self::assertEquals(100000, $result[0]['abs']); |
@@ -78,7 +78,7 @@ discard block |
||
| 78 | 78 | public function testFunctionConcat() : void |
| 79 | 79 | { |
| 80 | 80 | $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') |
| 81 | - ->getArrayResult(); |
|
| 81 | + ->getArrayResult(); |
|
| 82 | 82 | |
| 83 | 83 | self::assertCount(4, $arg); |
| 84 | 84 | self::assertEquals('Roman B.IT', $arg[0]['namedep']); |
@@ -90,7 +90,7 @@ discard block |
||
| 90 | 90 | public function testFunctionLength() : void |
| 91 | 91 | { |
| 92 | 92 | $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') |
| 93 | - ->getArrayResult(); |
|
| 93 | + ->getArrayResult(); |
|
| 94 | 94 | |
| 95 | 95 | self::assertCount(4, $result); |
| 96 | 96 | self::assertEquals(10, $result[0]['namedeplength']); |
@@ -102,10 +102,10 @@ discard block |
||
| 102 | 102 | public function testFunctionLocate() : void |
| 103 | 103 | { |
| 104 | 104 | $dql = "SELECT m, LOCATE('e', LOWER(m.name)) AS loc, LOCATE('e', LOWER(m.name), 7) AS loc2 " . |
| 105 | - 'FROM Doctrine\Tests\Models\Company\CompanyManager m ORDER BY m.salary ASC'; |
|
| 105 | + 'FROM Doctrine\Tests\Models\Company\CompanyManager m ORDER BY m.salary ASC'; |
|
| 106 | 106 | |
| 107 | 107 | $result = $this->em->createQuery($dql) |
| 108 | - ->getArrayResult(); |
|
| 108 | + ->getArrayResult(); |
|
| 109 | 109 | |
| 110 | 110 | self::assertCount(4, $result); |
| 111 | 111 | self::assertEquals(0, $result[0]['loc']); |
@@ -121,7 +121,7 @@ discard block |
||
| 121 | 121 | public function testFunctionLower() : void |
| 122 | 122 | { |
| 123 | 123 | $result = $this->em->createQuery('SELECT m, LOWER(m.name) AS lowername FROM Doctrine\Tests\Models\Company\CompanyManager m ORDER BY m.salary ASC') |
| 124 | - ->getArrayResult(); |
|
| 124 | + ->getArrayResult(); |
|
| 125 | 125 | |
| 126 | 126 | self::assertCount(4, $result); |
| 127 | 127 | self::assertEquals('roman b.', $result[0]['lowername']); |
@@ -133,7 +133,7 @@ discard block |
||
| 133 | 133 | public function testFunctionMod() : void |
| 134 | 134 | { |
| 135 | 135 | $result = $this->em->createQuery('SELECT m, MOD(m.salary, 3500) AS amod FROM Doctrine\Tests\Models\Company\CompanyManager m ORDER BY m.salary ASC') |
| 136 | - ->getArrayResult(); |
|
| 136 | + ->getArrayResult(); |
|
| 137 | 137 | |
| 138 | 138 | self::assertCount(4, $result); |
| 139 | 139 | self::assertEquals(2000, $result[0]['amod']); |
@@ -145,7 +145,7 @@ discard block |
||
| 145 | 145 | public function testFunctionSqrt() : void |
| 146 | 146 | { |
| 147 | 147 | $result = $this->em->createQuery('SELECT m, SQRT(m.salary) AS sqrtsalary FROM Doctrine\Tests\Models\Company\CompanyManager m ORDER BY m.salary ASC') |
| 148 | - ->getArrayResult(); |
|
| 148 | + ->getArrayResult(); |
|
| 149 | 149 | |
| 150 | 150 | self::assertCount(4, $result); |
| 151 | 151 | self::assertEquals(316, round($result[0]['sqrtsalary'])); |
@@ -157,7 +157,7 @@ discard block |
||
| 157 | 157 | public function testFunctionUpper() : void |
| 158 | 158 | { |
| 159 | 159 | $result = $this->em->createQuery('SELECT m, UPPER(m.name) AS uppername FROM Doctrine\Tests\Models\Company\CompanyManager m ORDER BY m.salary ASC') |
| 160 | - ->getArrayResult(); |
|
| 160 | + ->getArrayResult(); |
|
| 161 | 161 | |
| 162 | 162 | self::assertCount(4, $result); |
| 163 | 163 | self::assertEquals('ROMAN B.', $result[0]['uppername']); |
@@ -172,7 +172,7 @@ discard block |
||
| 172 | 172 | 'FROM Doctrine\Tests\Models\Company\CompanyManager m ORDER BY m.name'; |
| 173 | 173 | |
| 174 | 174 | $result = $this->em->createQuery($dql) |
| 175 | - ->getArrayResult(); |
|
| 175 | + ->getArrayResult(); |
|
| 176 | 176 | |
| 177 | 177 | self::assertCount(4, $result); |
| 178 | 178 | self::assertEquals('Ben', $result[0]['str1']); |
@@ -189,8 +189,8 @@ discard block |
||
| 189 | 189 | public function testFunctionTrim() : void |
| 190 | 190 | { |
| 191 | 191 | $dql = "SELECT m, TRIM(TRAILING '.' FROM m.name) AS str1, " . |
| 192 | - " TRIM(LEADING '.' FROM m.name) AS str2, TRIM(CONCAT(' ', CONCAT(m.name, ' '))) AS str3 " . |
|
| 193 | - 'FROM Doctrine\Tests\Models\Company\CompanyManager m ORDER BY m.salary ASC'; |
|
| 192 | + " TRIM(LEADING '.' FROM m.name) AS str2, TRIM(CONCAT(' ', CONCAT(m.name, ' '))) AS str3 " . |
|
| 193 | + 'FROM Doctrine\Tests\Models\Company\CompanyManager m ORDER BY m.salary ASC'; |
|
| 194 | 194 | |
| 195 | 195 | $result = $this->em->createQuery($dql)->getArrayResult(); |
| 196 | 196 | |
@@ -334,8 +334,8 @@ discard block |
||
| 334 | 334 | ); |
| 335 | 335 | |
| 336 | 336 | $result = $this->em->createQuery($query) |
| 337 | - ->setMaxResults(1) |
|
| 338 | - ->getSingleResult(AbstractQuery::HYDRATE_ARRAY); |
|
| 337 | + ->setMaxResults(1) |
|
| 338 | + ->getSingleResult(AbstractQuery::HYDRATE_ARRAY); |
|
| 339 | 339 | |
| 340 | 340 | self::assertArrayHasKey('now', $result); |
| 341 | 341 | self::assertArrayHasKey('sub', $result); |
@@ -77,7 +77,7 @@ discard block |
||
| 77 | 77 | public function testIndexByJoin() : void |
| 78 | 78 | { |
| 79 | 79 | $dql = 'SELECT A, B FROM Doctrine\Tests\ORM\Functional\Ticket\DDC618Author A ' . |
| 80 | - 'INNER JOIN A.books B INDEX BY B.title ORDER BY A.name ASC'; |
|
| 80 | + 'INNER JOIN A.books B INDEX BY B.title ORDER BY A.name ASC'; |
|
| 81 | 81 | $result = $this->em->createQuery($dql)->getResult(Query::HYDRATE_OBJECT); |
| 82 | 82 | |
| 83 | 83 | self::assertCount(3, $result[0]->books); // Alice, Joe doesn't appear because he has no books. |
@@ -101,14 +101,14 @@ discard block |
||
| 101 | 101 | public function testIndexByToOneJoinSilentlyIgnored() : void |
| 102 | 102 | { |
| 103 | 103 | $dql = 'SELECT B, A FROM Doctrine\Tests\ORM\Functional\Ticket\DDC618Book B ' . |
| 104 | - 'INNER JOIN B.author A INDEX BY A.name ORDER BY A.name ASC'; |
|
| 104 | + 'INNER JOIN B.author A INDEX BY A.name ORDER BY A.name ASC'; |
|
| 105 | 105 | $result = $this->em->createQuery($dql)->getResult(Query::HYDRATE_OBJECT); |
| 106 | 106 | |
| 107 | 107 | self::assertInstanceOf(DDC618Book::class, $result[0]); |
| 108 | 108 | self::assertInstanceOf(DDC618Author::class, $result[0]->author); |
| 109 | 109 | |
| 110 | 110 | $dql = 'SELECT B, A FROM Doctrine\Tests\ORM\Functional\Ticket\DDC618Book B ' . |
| 111 | - 'INNER JOIN B.author A INDEX BY A.name ORDER BY A.name ASC'; |
|
| 111 | + 'INNER JOIN B.author A INDEX BY A.name ORDER BY A.name ASC'; |
|
| 112 | 112 | $result = $this->em->createQuery($dql)->getResult(Query::HYDRATE_ARRAY); |
| 113 | 113 | |
| 114 | 114 | self::assertEquals('Alice', $result[0]['author']['name']); |
@@ -120,7 +120,7 @@ discard block |
||
| 120 | 120 | public function testCombineIndexBy() : void |
| 121 | 121 | { |
| 122 | 122 | $dql = 'SELECT A, B FROM Doctrine\Tests\ORM\Functional\Ticket\DDC618Author A INDEX BY A.id ' . |
| 123 | - 'INNER JOIN A.books B INDEX BY B.title ORDER BY A.name ASC'; |
|
| 123 | + 'INNER JOIN A.books B INDEX BY B.title ORDER BY A.name ASC'; |
|
| 124 | 124 | $result = $this->em->createQuery($dql)->getResult(Query::HYDRATE_OBJECT); |
| 125 | 125 | |
| 126 | 126 | self::assertArrayHasKey(11, $result); // Alice |
@@ -37,8 +37,8 @@ |
||
| 37 | 37 | public function testIsListenerCalledOnlyOnceOnPreFlush() : void |
| 38 | 38 | { |
| 39 | 39 | $listener = $this->getMockBuilder(DDC2692Listener::class) |
| 40 | - ->setMethods(['preFlush']) |
|
| 41 | - ->getMock(); |
|
| 40 | + ->setMethods(['preFlush']) |
|
| 41 | + ->getMock(); |
|
| 42 | 42 | |
| 43 | 43 | $listener->expects($this->once())->method('preFlush'); |
| 44 | 44 | |
@@ -300,7 +300,7 @@ discard block |
||
| 300 | 300 | public function testBulkUpdateIssueDDC368() : void |
| 301 | 301 | { |
| 302 | 302 | $this->em->createQuery('UPDATE ' . CompanyEmployee::class . ' AS p SET p.salary = 1') |
| 303 | - ->execute(); |
|
| 303 | + ->execute(); |
|
| 304 | 304 | |
| 305 | 305 | $result = $this->em->createQuery('SELECT count(p.id) FROM ' . CompanyEmployee::class . ' p WHERE p.salary = 1') |
| 306 | 306 | ->getResult(); |
@@ -314,9 +314,9 @@ discard block |
||
| 314 | 314 | public function testBulkUpdateNonScalarParameterDDC1341() : void |
| 315 | 315 | { |
| 316 | 316 | $this->em->createQuery('UPDATE ' . CompanyEmployee::class . ' AS p SET p.startDate = ?0 WHERE p.department = ?1') |
| 317 | - ->setParameter(0, new \DateTime()) |
|
| 318 | - ->setParameter(1, 'IT') |
|
| 319 | - ->execute(); |
|
| 317 | + ->setParameter(0, new \DateTime()) |
|
| 318 | + ->setParameter(1, 'IT') |
|
| 319 | + ->execute(); |
|
| 320 | 320 | |
| 321 | 321 | self::addToAssertionCount(1); |
| 322 | 322 | } |
@@ -272,12 +272,12 @@ discard block |
||
| 272 | 272 | { |
| 273 | 273 | $qb = $this->em->createQueryBuilder(); |
| 274 | 274 | $qb->select('u') |
| 275 | - ->from(CmsUser::class, 'u') |
|
| 276 | - ->where('u.id = :uid') |
|
| 277 | - ->orWhere('u.id = :uid2') |
|
| 278 | - ->andWhere('u.id = :uid3') |
|
| 279 | - ->orWhere('u.name = :name1', 'u.name = :name2') |
|
| 280 | - ->andWhere('u.name <> :noname'); |
|
| 275 | + ->from(CmsUser::class, 'u') |
|
| 276 | + ->where('u.id = :uid') |
|
| 277 | + ->orWhere('u.id = :uid2') |
|
| 278 | + ->andWhere('u.id = :uid3') |
|
| 279 | + ->orWhere('u.name = :name1', 'u.name = :name2') |
|
| 280 | + ->andWhere('u.name <> :noname'); |
|
| 281 | 281 | |
| 282 | 282 | self::assertValidQueryBuilder($qb, 'SELECT u FROM Doctrine\Tests\Models\CMS\CmsUser u WHERE (((u.id = :uid OR u.id = :uid2) AND u.id = :uid3) OR u.name = :name1 OR u.name = :name2) AND u.name <> :noname'); |
| 283 | 283 | } |
@@ -286,9 +286,9 @@ discard block |
||
| 286 | 286 | { |
| 287 | 287 | $qb = $this->em->createQueryBuilder(); |
| 288 | 288 | $qb->select('u') |
| 289 | - ->from(CmsUser::class, 'u') |
|
| 290 | - ->where('u.id = :uid') |
|
| 291 | - ->andWhere($qb->expr()->in('u.id', [1, 2, 3])); |
|
| 289 | + ->from(CmsUser::class, 'u') |
|
| 290 | + ->where('u.id = :uid') |
|
| 291 | + ->andWhere($qb->expr()->in('u.id', [1, 2, 3])); |
|
| 292 | 292 | |
| 293 | 293 | self::assertValidQueryBuilder($qb, 'SELECT u FROM Doctrine\Tests\Models\CMS\CmsUser u WHERE u.id = :uid AND u.id IN(1, 2, 3)'); |
| 294 | 294 | } |
@@ -297,9 +297,9 @@ discard block |
||
| 297 | 297 | { |
| 298 | 298 | $qb = $this->em->createQueryBuilder(); |
| 299 | 299 | $qb->select('u') |
| 300 | - ->from(CmsUser::class, 'u') |
|
| 301 | - ->where('u.id = :uid') |
|
| 302 | - ->orWhere($qb->expr()->in('u.id', [1, 2, 3])); |
|
| 300 | + ->from(CmsUser::class, 'u') |
|
| 301 | + ->where('u.id = :uid') |
|
| 302 | + ->orWhere($qb->expr()->in('u.id', [1, 2, 3])); |
|
| 303 | 303 | |
| 304 | 304 | self::assertValidQueryBuilder($qb, 'SELECT u FROM Doctrine\Tests\Models\CMS\CmsUser u WHERE u.id = :uid OR u.id IN(1, 2, 3)'); |
| 305 | 305 | } |
@@ -308,9 +308,9 @@ discard block |
||
| 308 | 308 | { |
| 309 | 309 | $qb = $this->em->createQueryBuilder(); |
| 310 | 310 | $qb->select('u') |
| 311 | - ->from(CmsUser::class, 'u') |
|
| 312 | - ->where('u.id = :uid') |
|
| 313 | - ->andWhere($qb->expr()->notIn('u.id', [1, 2, 3])); |
|
| 311 | + ->from(CmsUser::class, 'u') |
|
| 312 | + ->where('u.id = :uid') |
|
| 313 | + ->andWhere($qb->expr()->notIn('u.id', [1, 2, 3])); |
|
| 314 | 314 | |
| 315 | 315 | self::assertValidQueryBuilder($qb, 'SELECT u FROM Doctrine\Tests\Models\CMS\CmsUser u WHERE u.id = :uid AND u.id NOT IN(1, 2, 3)'); |
| 316 | 316 | } |
@@ -319,9 +319,9 @@ discard block |
||
| 319 | 319 | { |
| 320 | 320 | $qb = $this->em->createQueryBuilder(); |
| 321 | 321 | $qb->select('u') |
| 322 | - ->from(CmsUser::class, 'u') |
|
| 323 | - ->where('u.id = :uid') |
|
| 324 | - ->orWhere($qb->expr()->notIn('u.id', [1, 2, 3])); |
|
| 322 | + ->from(CmsUser::class, 'u') |
|
| 323 | + ->where('u.id = :uid') |
|
| 324 | + ->orWhere($qb->expr()->notIn('u.id', [1, 2, 3])); |
|
| 325 | 325 | |
| 326 | 326 | self::assertValidQueryBuilder($qb, 'SELECT u FROM Doctrine\Tests\Models\CMS\CmsUser u WHERE u.id = :uid OR u.id NOT IN(1, 2, 3)'); |
| 327 | 327 | } |
@@ -617,8 +617,8 @@ discard block |
||
| 617 | 617 | { |
| 618 | 618 | $qb = $this->em->createQueryBuilder(); |
| 619 | 619 | $qb->select('u') |
| 620 | - ->from(CmsUser::class, 'u') |
|
| 621 | - ->where($qb->expr()->orX('u.username = :username', 'u.username = :username2')); |
|
| 620 | + ->from(CmsUser::class, 'u') |
|
| 621 | + ->where($qb->expr()->orX('u.username = :username', 'u.username = :username2')); |
|
| 622 | 622 | |
| 623 | 623 | $parameters = new ArrayCollection(); |
| 624 | 624 | $parameters->add(new Parameter('username', 'jwage')); |
@@ -634,8 +634,8 @@ discard block |
||
| 634 | 634 | { |
| 635 | 635 | $qb = $this->em->createQueryBuilder(); |
| 636 | 636 | $qb->select('u') |
| 637 | - ->from(CmsUser::class, 'u') |
|
| 638 | - ->where('u.id = :id'); |
|
| 637 | + ->from(CmsUser::class, 'u') |
|
| 638 | + ->where('u.id = :id'); |
|
| 639 | 639 | |
| 640 | 640 | $parameters = new ArrayCollection(); |
| 641 | 641 | $parameters->add(new Parameter('id', 1)); |
@@ -684,8 +684,8 @@ discard block |
||
| 684 | 684 | { |
| 685 | 685 | $qb = $this->em->createQueryBuilder(); |
| 686 | 686 | $qb->select('u') |
| 687 | - ->from(CmsUser::class, 'u') |
|
| 688 | - ->orWhere('u.id = :uid', $qb->expr()->eq('u.id', ':uid2')); |
|
| 687 | + ->from(CmsUser::class, 'u') |
|
| 688 | + ->orWhere('u.id = :uid', $qb->expr()->eq('u.id', ':uid2')); |
|
| 689 | 689 | |
| 690 | 690 | self::assertValidQueryBuilder($qb, 'SELECT u FROM Doctrine\Tests\Models\CMS\CmsUser u WHERE u.id = :uid OR u.id = :uid2'); |
| 691 | 691 | } |
@@ -698,8 +698,8 @@ discard block |
||
| 698 | 698 | $orExpr->add($qb->expr()->in('u.id', [1])); |
| 699 | 699 | |
| 700 | 700 | $qb->select('u') |
| 701 | - ->from(CmsUser::class, 'u') |
|
| 702 | - ->where($orExpr); |
|
| 701 | + ->from(CmsUser::class, 'u') |
|
| 702 | + ->where($orExpr); |
|
| 703 | 703 | |
| 704 | 704 | self::assertValidQueryBuilder($qb, 'SELECT u FROM Doctrine\Tests\Models\CMS\CmsUser u WHERE u.id = :uid3 OR u.id IN(1)'); |
| 705 | 705 | } |
@@ -708,8 +708,8 @@ discard block |
||
| 708 | 708 | { |
| 709 | 709 | $qb = $this->em->createQueryBuilder(); |
| 710 | 710 | $qb->select('u') |
| 711 | - ->from(CmsUser::class, 'u') |
|
| 712 | - ->where($qb->expr()->in('u.name', ['one', 'two', 'three'])); |
|
| 711 | + ->from(CmsUser::class, 'u') |
|
| 712 | + ->where($qb->expr()->in('u.name', ['one', 'two', 'three'])); |
|
| 713 | 713 | |
| 714 | 714 | self::assertValidQueryBuilder($qb, "SELECT u FROM Doctrine\Tests\Models\CMS\CmsUser u WHERE u.name IN('one', 'two', 'three')"); |
| 715 | 715 | |
@@ -723,8 +723,8 @@ discard block |
||
| 723 | 723 | $qb = $this->em->createQueryBuilder(); |
| 724 | 724 | $expr = $this->em->getExpressionBuilder(); |
| 725 | 725 | $qb->select('u') |
| 726 | - ->from(CmsUser::class, 'u') |
|
| 727 | - ->where($expr->in('u.name', [$expr->literal('one'), $expr->literal('two'), $expr->literal('three')])); |
|
| 726 | + ->from(CmsUser::class, 'u') |
|
| 727 | + ->where($expr->in('u.name', [$expr->literal('one'), $expr->literal('two'), $expr->literal('three')])); |
|
| 728 | 728 | |
| 729 | 729 | self::assertValidQueryBuilder($qb, "SELECT u FROM Doctrine\Tests\Models\CMS\CmsUser u WHERE u.name IN('one', 'two', 'three')"); |
| 730 | 730 | |
@@ -742,8 +742,8 @@ discard block |
||
| 742 | 742 | |
| 743 | 743 | $qb = $this->em->createQueryBuilder(); |
| 744 | 744 | $qb->select('u') |
| 745 | - ->from(CmsUser::class, 'u') |
|
| 746 | - ->where($orExpr); |
|
| 745 | + ->from(CmsUser::class, 'u') |
|
| 746 | + ->where($orExpr); |
|
| 747 | 747 | |
| 748 | 748 | self::assertValidQueryBuilder($qb, 'SELECT u FROM Doctrine\Tests\Models\CMS\CmsUser u WHERE u.id = :uid3 OR NOT(u.id IN(1))'); |
| 749 | 749 | } |
@@ -754,8 +754,8 @@ discard block |
||
| 754 | 754 | $expr = $this->em->getExpressionBuilder(); |
| 755 | 755 | |
| 756 | 756 | $qb->select('u') |
| 757 | - ->from(CmsUser::class, 'u') |
|
| 758 | - ->where($expr->gt('u.id', $expr->all('select a.id from Doctrine\Tests\Models\CMS\CmsArticle a'))); |
|
| 757 | + ->from(CmsUser::class, 'u') |
|
| 758 | + ->where($expr->gt('u.id', $expr->all('select a.id from Doctrine\Tests\Models\CMS\CmsArticle a'))); |
|
| 759 | 759 | |
| 760 | 760 | self::assertValidQueryBuilder($qb, 'SELECT u FROM Doctrine\Tests\Models\CMS\CmsUser u WHERE u.id > ALL(select a.id from Doctrine\Tests\Models\CMS\CmsArticle a)'); |
| 761 | 761 | } |
@@ -1120,9 +1120,9 @@ discard block |
||
| 1120 | 1120 | public function testRebuildsFromParts() : void |
| 1121 | 1121 | { |
| 1122 | 1122 | $qb = $this->em->createQueryBuilder() |
| 1123 | - ->select('u') |
|
| 1124 | - ->from(CmsUser::class, 'u') |
|
| 1125 | - ->join('u.article', 'a'); |
|
| 1123 | + ->select('u') |
|
| 1124 | + ->from(CmsUser::class, 'u') |
|
| 1125 | + ->join('u.article', 'a'); |
|
| 1126 | 1126 | |
| 1127 | 1127 | $dqlParts = $qb->getDQLParts(); |
| 1128 | 1128 | $dql = $qb->getDQL(); |