@@ -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 | /** |
@@ -1,6 +1,6 @@ discard block |
||
| 1 | 1 | <?php |
| 2 | 2 | |
| 3 | -declare(strict_types=1); |
|
| 3 | +declare(strict_types = 1); |
|
| 4 | 4 | |
| 5 | 5 | namespace Doctrine\Tests\ORM\Functional; |
| 6 | 6 | |
@@ -612,7 +612,7 @@ discard block |
||
| 612 | 612 | public function testCanRetrieveRepositoryFromClassNameWithLeadingBackslash() : void |
| 613 | 613 | { |
| 614 | 614 | self::assertSame( |
| 615 | - $this->em->getRepository('\\' . CmsUser::class), |
|
| 615 | + $this->em->getRepository('\\'.CmsUser::class), |
|
| 616 | 616 | $this->em->getRepository(CmsUser::class) |
| 617 | 617 | ); |
| 618 | 618 | } |
@@ -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); |
@@ -1,6 +1,6 @@ discard block |
||
| 1 | 1 | <?php |
| 2 | 2 | |
| 3 | -declare(strict_types=1); |
|
| 3 | +declare(strict_types = 1); |
|
| 4 | 4 | |
| 5 | 5 | namespace Doctrine\Tests\ORM\Functional; |
| 6 | 6 | |
@@ -25,8 +25,8 @@ discard block |
||
| 25 | 25 | |
| 26 | 26 | public function testAggregateWithHavingClause() : void |
| 27 | 27 | { |
| 28 | - $dql = 'SELECT p.department, AVG(p.salary) AS avgSalary ' . |
|
| 29 | - 'FROM Doctrine\Tests\Models\Company\CompanyEmployee p ' . |
|
| 28 | + $dql = 'SELECT p.department, AVG(p.salary) AS avgSalary '. |
|
| 29 | + 'FROM Doctrine\Tests\Models\Company\CompanyEmployee p '. |
|
| 30 | 30 | 'GROUP BY p.department HAVING SUM(p.salary) > 200000 ORDER BY p.department'; |
| 31 | 31 | |
| 32 | 32 | $result = $this->em->createQuery($dql)->getScalarResult(); |
@@ -40,8 +40,8 @@ discard block |
||
| 40 | 40 | |
| 41 | 41 | public function testUnnamedScalarResultsAreOneBased() : void |
| 42 | 42 | { |
| 43 | - $dql = 'SELECT p.department, AVG(p.salary) ' . |
|
| 44 | - 'FROM Doctrine\Tests\Models\Company\CompanyEmployee p ' . |
|
| 43 | + $dql = 'SELECT p.department, AVG(p.salary) '. |
|
| 44 | + 'FROM Doctrine\Tests\Models\Company\CompanyEmployee p '. |
|
| 45 | 45 | 'GROUP BY p.department HAVING SUM(p.salary) > 200000 ORDER BY p.department'; |
| 46 | 46 | |
| 47 | 47 | $result = $this->em->createQuery($dql)->getScalarResult(); |
@@ -53,9 +53,9 @@ discard block |
||
| 53 | 53 | |
| 54 | 54 | public function testOrderByResultVariableCollectionSize() : void |
| 55 | 55 | { |
| 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 ' . |
|
| 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 | 59 | 'ORDER BY friends DESC, p.name DESC'; |
| 60 | 60 | |
| 61 | 61 | $result = $this->em->createQuery($dql)->getScalarResult(); |
@@ -77,7 +77,7 @@ discard block |
||
| 77 | 77 | |
| 78 | 78 | public function testIsNullAssociation() : void |
| 79 | 79 | { |
| 80 | - $dql = 'SELECT p FROM Doctrine\Tests\Models\Company\CompanyPerson p ' . |
|
| 80 | + $dql = 'SELECT p FROM Doctrine\Tests\Models\Company\CompanyPerson p '. |
|
| 81 | 81 | 'WHERE p.spouse IS NULL'; |
| 82 | 82 | $result = $this->em->createQuery($dql)->getResult(); |
| 83 | 83 | |
@@ -91,7 +91,7 @@ discard block |
||
| 91 | 91 | |
| 92 | 92 | public function testSelectSubselect() : void |
| 93 | 93 | { |
| 94 | - $dql = 'SELECT p, (SELECT c.brand FROM Doctrine\Tests\Models\Company\CompanyCar c WHERE p.car = c) brandName ' . |
|
| 94 | + $dql = 'SELECT p, (SELECT c.brand FROM Doctrine\Tests\Models\Company\CompanyCar c WHERE p.car = c) brandName '. |
|
| 95 | 95 | 'FROM Doctrine\Tests\Models\Company\CompanyManager p'; |
| 96 | 96 | $result = $this->em->createQuery($dql)->getArrayResult(); |
| 97 | 97 | |
@@ -101,7 +101,7 @@ discard block |
||
| 101 | 101 | |
| 102 | 102 | public function testInSubselect() : void |
| 103 | 103 | { |
| 104 | - $dql = 'SELECT p.name FROM Doctrine\Tests\Models\Company\CompanyPerson p ' . |
|
| 104 | + $dql = 'SELECT p.name FROM Doctrine\Tests\Models\Company\CompanyPerson p '. |
|
| 105 | 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 | |
@@ -111,7 +111,7 @@ discard block |
||
| 111 | 111 | |
| 112 | 112 | public function testGroupByMultipleFields() : void |
| 113 | 113 | { |
| 114 | - $dql = 'SELECT p.department, p.name, count(p.id) FROM Doctrine\Tests\Models\Company\CompanyEmployee p ' . |
|
| 114 | + $dql = 'SELECT p.department, p.name, count(p.id) FROM Doctrine\Tests\Models\Company\CompanyEmployee p '. |
|
| 115 | 115 | 'GROUP BY p.department, p.name'; |
| 116 | 116 | $result = $this->em->createQuery($dql)->getResult(); |
| 117 | 117 | |
@@ -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(); |
@@ -1,6 +1,6 @@ discard block |
||
| 1 | 1 | <?php |
| 2 | 2 | |
| 3 | -declare(strict_types=1); |
|
| 3 | +declare(strict_types = 1); |
|
| 4 | 4 | |
| 5 | 5 | namespace Doctrine\Tests\ORM\Functional; |
| 6 | 6 | |
@@ -29,7 +29,7 @@ discard block |
||
| 29 | 29 | */ |
| 30 | 30 | public function testIssue2059() : void |
| 31 | 31 | { |
| 32 | - if (! $this->em->getConnection()->getDatabasePlatform()->supportsForeignKeyConstraints()) { |
|
| 32 | + if ( ! $this->em->getConnection()->getDatabasePlatform()->supportsForeignKeyConstraints()) { |
|
| 33 | 33 | $this->markTestSkipped('Platform does not support foreign keys.'); |
| 34 | 34 | } |
| 35 | 35 | |
@@ -51,7 +51,7 @@ discard block |
||
| 51 | 51 | |
| 52 | 52 | public function testLoadMetadataFromDatabase() : void |
| 53 | 53 | { |
| 54 | - if (! $this->em->getConnection()->getDatabasePlatform()->supportsForeignKeyConstraints()) { |
|
| 54 | + if ( ! $this->em->getConnection()->getDatabasePlatform()->supportsForeignKeyConstraints()) { |
|
| 55 | 55 | $this->markTestSkipped('Platform does not support foreign keys.'); |
| 56 | 56 | } |
| 57 | 57 | |
@@ -89,7 +89,7 @@ discard block |
||
| 89 | 89 | |
| 90 | 90 | public function testLoadMetadataWithForeignKeyFromDatabase() : void |
| 91 | 91 | { |
| 92 | - if (! $this->em->getConnection()->getDatabasePlatform()->supportsForeignKeyConstraints()) { |
|
| 92 | + if ( ! $this->em->getConnection()->getDatabasePlatform()->supportsForeignKeyConstraints()) { |
|
| 93 | 93 | $this->markTestSkipped('Platform does not support foreign keys.'); |
| 94 | 94 | } |
| 95 | 95 | |
@@ -122,7 +122,7 @@ discard block |
||
| 122 | 122 | |
| 123 | 123 | public function testDetectManyToManyTables() : void |
| 124 | 124 | { |
| 125 | - if (! $this->em->getConnection()->getDatabasePlatform()->supportsForeignKeyConstraints()) { |
|
| 125 | + if ( ! $this->em->getConnection()->getDatabasePlatform()->supportsForeignKeyConstraints()) { |
|
| 126 | 126 | $this->markTestSkipped('Platform does not support foreign keys.'); |
| 127 | 127 | } |
| 128 | 128 | |
@@ -162,7 +162,7 @@ discard block |
||
| 162 | 162 | |
| 163 | 163 | public function testLoadMetadataFromDatabaseDetail() : void |
| 164 | 164 | { |
| 165 | - if (! $this->em->getConnection()->getDatabasePlatform()->supportsForeignKeyConstraints()) { |
|
| 165 | + if ( ! $this->em->getConnection()->getDatabasePlatform()->supportsForeignKeyConstraints()) { |
|
| 166 | 166 | $this->markTestSkipped('Platform does not support foreign keys.'); |
| 167 | 167 | } |
| 168 | 168 | |
@@ -201,7 +201,7 @@ discard block |
||
| 201 | 201 | |
| 202 | 202 | // FIXME: Condition here is fugly. |
| 203 | 203 | // NOTE: PostgreSQL and SQL SERVER do not support UNSIGNED integer |
| 204 | - if (! $this->em->getConnection()->getDatabasePlatform() instanceof PostgreSqlPlatform && |
|
| 204 | + if ( ! $this->em->getConnection()->getDatabasePlatform() instanceof PostgreSqlPlatform && |
|
| 205 | 205 | ! $this->em->getConnection()->getDatabasePlatform() instanceof SQLServerPlatform) { |
| 206 | 206 | self::assertNotNull($metadata->getProperty('columnUnsigned')); |
| 207 | 207 | |
@@ -243,7 +243,7 @@ discard block |
||
| 243 | 243 | |
| 244 | 244 | self::assertNotEmpty($indexes['index1']['columns']); |
| 245 | 245 | self::assertEquals( |
| 246 | - ['column_index1','column_index2'], |
|
| 246 | + ['column_index1', 'column_index2'], |
|
| 247 | 247 | $indexes['index1']['columns'] |
| 248 | 248 | ); |
| 249 | 249 | |
@@ -1,6 +1,6 @@ discard block |
||
| 1 | 1 | <?php |
| 2 | 2 | |
| 3 | -declare(strict_types=1); |
|
| 3 | +declare(strict_types = 1); |
|
| 4 | 4 | |
| 5 | 5 | namespace Doctrine\Tests\ORM\Functional; |
| 6 | 6 | |
@@ -134,7 +134,7 @@ discard block |
||
| 134 | 134 | $iter = $paginator->getIterator(); |
| 135 | 135 | self::assertCount(9, $iter); |
| 136 | 136 | $result = iterator_to_array($iter); |
| 137 | - self::assertEquals($checkField . '0', $result[0]->{$checkField}); |
|
| 137 | + self::assertEquals($checkField.'0', $result[0]->{$checkField}); |
|
| 138 | 138 | } |
| 139 | 139 | |
| 140 | 140 | private function iterateWithOrderAscWithLimit($useOutputWalkers, $fetchJoinCollection, $baseDql, $checkField) |
@@ -150,7 +150,7 @@ discard block |
||
| 150 | 150 | $iter = $paginator->getIterator(); |
| 151 | 151 | self::assertCount(3, $iter); |
| 152 | 152 | $result = iterator_to_array($iter); |
| 153 | - self::assertEquals($checkField . '0', $result[0]->{$checkField}); |
|
| 153 | + self::assertEquals($checkField.'0', $result[0]->{$checkField}); |
|
| 154 | 154 | } |
| 155 | 155 | |
| 156 | 156 | private function iterateWithOrderAscWithLimitAndOffset($useOutputWalkers, $fetchJoinCollection, $baseDql, $checkField) |
@@ -166,7 +166,7 @@ discard block |
||
| 166 | 166 | $iter = $paginator->getIterator(); |
| 167 | 167 | self::assertCount(3, $iter); |
| 168 | 168 | $result = iterator_to_array($iter); |
| 169 | - self::assertEquals($checkField . '3', $result[0]->{$checkField}); |
|
| 169 | + self::assertEquals($checkField.'3', $result[0]->{$checkField}); |
|
| 170 | 170 | } |
| 171 | 171 | |
| 172 | 172 | private function iterateWithOrderDesc($useOutputWalkers, $fetchJoinCollection, $baseDql, $checkField) |
@@ -179,7 +179,7 @@ discard block |
||
| 179 | 179 | $iter = $paginator->getIterator(); |
| 180 | 180 | self::assertCount(9, $iter); |
| 181 | 181 | $result = iterator_to_array($iter); |
| 182 | - self::assertEquals($checkField . '8', $result[0]->{$checkField}); |
|
| 182 | + self::assertEquals($checkField.'8', $result[0]->{$checkField}); |
|
| 183 | 183 | } |
| 184 | 184 | |
| 185 | 185 | private function iterateWithOrderDescWithLimit($useOutputWalkers, $fetchJoinCollection, $baseDql, $checkField) |
@@ -194,7 +194,7 @@ discard block |
||
| 194 | 194 | $iter = $paginator->getIterator(); |
| 195 | 195 | self::assertCount(3, $iter); |
| 196 | 196 | $result = iterator_to_array($iter); |
| 197 | - self::assertEquals($checkField . '8', $result[0]->{$checkField}); |
|
| 197 | + self::assertEquals($checkField.'8', $result[0]->{$checkField}); |
|
| 198 | 198 | } |
| 199 | 199 | |
| 200 | 200 | private function iterateWithOrderDescWithLimitAndOffset($useOutputWalkers, $fetchJoinCollection, $baseDql, $checkField) |
@@ -209,7 +209,7 @@ discard block |
||
| 209 | 209 | $iter = $paginator->getIterator(); |
| 210 | 210 | self::assertCount(3, $iter); |
| 211 | 211 | $result = iterator_to_array($iter); |
| 212 | - self::assertEquals($checkField . '5', $result[0]->{$checkField}); |
|
| 212 | + self::assertEquals($checkField.'5', $result[0]->{$checkField}); |
|
| 213 | 213 | } |
| 214 | 214 | |
| 215 | 215 | /** |
@@ -482,8 +482,8 @@ discard block |
||
| 482 | 482 | public function testIterateWithFetchJoinOneToManyWithOrderByColumnFromBoth($useOutputWalkers) : void |
| 483 | 483 | { |
| 484 | 484 | $dql = 'SELECT c, d FROM Doctrine\Tests\Models\Pagination\Company c JOIN c.departments d ORDER BY c.name'; |
| 485 | - $dqlAsc = $dql . ' ASC, d.name'; |
|
| 486 | - $dqlDesc = $dql . ' DESC, d.name'; |
|
| 485 | + $dqlAsc = $dql.' ASC, d.name'; |
|
| 486 | + $dqlDesc = $dql.' DESC, d.name'; |
|
| 487 | 487 | $this->iterateWithOrderAsc($useOutputWalkers, true, $dqlAsc, 'name'); |
| 488 | 488 | $this->iterateWithOrderDesc($useOutputWalkers, true, $dqlDesc, 'name'); |
| 489 | 489 | } |
@@ -491,8 +491,8 @@ discard block |
||
| 491 | 491 | public function testIterateWithFetchJoinOneToManyWithOrderByColumnFromBothWithLimitWithOutputWalker() : void |
| 492 | 492 | { |
| 493 | 493 | $dql = 'SELECT c, d FROM Doctrine\Tests\Models\Pagination\Company c JOIN c.departments d ORDER BY c.name'; |
| 494 | - $dqlAsc = $dql . ' ASC, d.name'; |
|
| 495 | - $dqlDesc = $dql . ' DESC, d.name'; |
|
| 494 | + $dqlAsc = $dql.' ASC, d.name'; |
|
| 495 | + $dqlDesc = $dql.' DESC, d.name'; |
|
| 496 | 496 | $this->iterateWithOrderAscWithLimit(true, true, $dqlAsc, 'name'); |
| 497 | 497 | $this->iterateWithOrderDescWithLimit(true, true, $dqlDesc, 'name'); |
| 498 | 498 | } |
@@ -503,8 +503,8 @@ discard block |
||
| 503 | 503 | $this->expectExceptionMessage('Cannot select distinct identifiers from query with LIMIT and ORDER BY on a column from a fetch joined to-many association. Use output walkers.'); |
| 504 | 504 | |
| 505 | 505 | $dql = 'SELECT c, d FROM Doctrine\Tests\Models\Pagination\Company c JOIN c.departments d ORDER BY c.name'; |
| 506 | - $dqlAsc = $dql . ' ASC, d.name'; |
|
| 507 | - $dqlDesc = $dql . ' DESC, d.name'; |
|
| 506 | + $dqlAsc = $dql.' ASC, d.name'; |
|
| 507 | + $dqlDesc = $dql.' DESC, d.name'; |
|
| 508 | 508 | $this->iterateWithOrderAscWithLimit(false, true, $dqlAsc, 'name'); |
| 509 | 509 | $this->iterateWithOrderDescWithLimit(false, true, $dqlDesc, 'name'); |
| 510 | 510 | } |
@@ -588,7 +588,7 @@ discard block |
||
| 588 | 588 | $users = iterator_to_array($paginator->getIterator()); |
| 589 | 589 | self::assertCount(9, $users); |
| 590 | 590 | foreach ($users as $i => $user) { |
| 591 | - self::assertEquals('username' . (8 - $i), $user->username); |
|
| 591 | + self::assertEquals('username'.(8 - $i), $user->username); |
|
| 592 | 592 | } |
| 593 | 593 | } |
| 594 | 594 | |
@@ -738,7 +738,7 @@ discard block |
||
| 738 | 738 | $company->logo->image_width = 100 + $i; |
| 739 | 739 | $company->logo->image_height = 100 + $i; |
| 740 | 740 | $company->logo->company = $company; |
| 741 | - for ($j=0; $j<3; $j++) { |
|
| 741 | + for ($j = 0; $j < 3; $j++) { |
|
| 742 | 742 | $department = new Department(); |
| 743 | 743 | $department->name = sprintf('name%d%d', $i, $j); |
| 744 | 744 | $department->company = $company; |
@@ -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); |
@@ -1,6 +1,6 @@ discard block |
||
| 1 | 1 | <?php |
| 2 | 2 | |
| 3 | -declare(strict_types=1); |
|
| 3 | +declare(strict_types = 1); |
|
| 4 | 4 | |
| 5 | 5 | namespace Doctrine\Tests\ORM\Functional; |
| 6 | 6 | |
@@ -101,7 +101,7 @@ discard block |
||
| 101 | 101 | |
| 102 | 102 | public function testFunctionLocate() : void |
| 103 | 103 | { |
| 104 | - $dql = "SELECT m, LOCATE('e', LOWER(m.name)) AS loc, LOCATE('e', LOWER(m.name), 7) AS loc2 " . |
|
| 104 | + $dql = "SELECT m, LOCATE('e', LOWER(m.name)) AS loc, LOCATE('e', LOWER(m.name), 7) AS loc2 ". |
|
| 105 | 105 | 'FROM Doctrine\Tests\Models\Company\CompanyManager m ORDER BY m.salary ASC'; |
| 106 | 106 | |
| 107 | 107 | $result = $this->em->createQuery($dql) |
@@ -168,7 +168,7 @@ discard block |
||
| 168 | 168 | |
| 169 | 169 | public function testFunctionSubstring() : void |
| 170 | 170 | { |
| 171 | - $dql = 'SELECT m, SUBSTRING(m.name, 1, 3) AS str1, SUBSTRING(m.name, 5) AS str2 ' . |
|
| 171 | + $dql = 'SELECT m, SUBSTRING(m.name, 1, 3) AS str1, SUBSTRING(m.name, 5) AS str2 '. |
|
| 172 | 172 | 'FROM Doctrine\Tests\Models\Company\CompanyManager m ORDER BY m.name'; |
| 173 | 173 | |
| 174 | 174 | $result = $this->em->createQuery($dql) |
@@ -188,8 +188,8 @@ discard block |
||
| 188 | 188 | |
| 189 | 189 | public function testFunctionTrim() : void |
| 190 | 190 | { |
| 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 " . |
|
| 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 | 193 | 'FROM Doctrine\Tests\Models\Company\CompanyManager m ORDER BY m.salary ASC'; |
| 194 | 194 | |
| 195 | 195 | $result = $this->em->createQuery($dql)->getArrayResult(); |
@@ -368,12 +368,12 @@ discard block |
||
| 368 | 368 | */ |
| 369 | 369 | public function testBitOrComparison() : void |
| 370 | 370 | { |
| 371 | - $dql = 'SELECT m, ' . |
|
| 372 | - 'BIT_OR(4, 2) AS bit_or,' . |
|
| 373 | - 'BIT_OR( (m.salary/100000) , 2 ) AS salary_bit_or ' . |
|
| 374 | - 'FROM Doctrine\Tests\Models\Company\CompanyManager m ' . |
|
| 375 | - 'ORDER BY ' . |
|
| 376 | - 'm.id ' ; |
|
| 371 | + $dql = 'SELECT m, '. |
|
| 372 | + 'BIT_OR(4, 2) AS bit_or,'. |
|
| 373 | + 'BIT_OR( (m.salary/100000) , 2 ) AS salary_bit_or '. |
|
| 374 | + 'FROM Doctrine\Tests\Models\Company\CompanyManager m '. |
|
| 375 | + 'ORDER BY '. |
|
| 376 | + 'm.id '; |
|
| 377 | 377 | $result = $this->em->createQuery($dql)->getArrayResult(); |
| 378 | 378 | |
| 379 | 379 | self::assertEquals(4 | 2, $result[0]['bit_or']); |
@@ -381,10 +381,10 @@ discard block |
||
| 381 | 381 | self::assertEquals(4 | 2, $result[2]['bit_or']); |
| 382 | 382 | self::assertEquals(4 | 2, $result[3]['bit_or']); |
| 383 | 383 | |
| 384 | - self::assertEquals(($result[0][0]['salary']/100000) | 2, $result[0]['salary_bit_or']); |
|
| 385 | - self::assertEquals(($result[1][0]['salary']/100000) | 2, $result[1]['salary_bit_or']); |
|
| 386 | - self::assertEquals(($result[2][0]['salary']/100000) | 2, $result[2]['salary_bit_or']); |
|
| 387 | - self::assertEquals(($result[3][0]['salary']/100000) | 2, $result[3]['salary_bit_or']); |
|
| 384 | + self::assertEquals(($result[0][0]['salary'] / 100000) | 2, $result[0]['salary_bit_or']); |
|
| 385 | + self::assertEquals(($result[1][0]['salary'] / 100000) | 2, $result[1]['salary_bit_or']); |
|
| 386 | + self::assertEquals(($result[2][0]['salary'] / 100000) | 2, $result[2]['salary_bit_or']); |
|
| 387 | + self::assertEquals(($result[3][0]['salary'] / 100000) | 2, $result[3]['salary_bit_or']); |
|
| 388 | 388 | } |
| 389 | 389 | |
| 390 | 390 | /** |
@@ -392,12 +392,12 @@ discard block |
||
| 392 | 392 | */ |
| 393 | 393 | public function testBitAndComparison() : void |
| 394 | 394 | { |
| 395 | - $dql = 'SELECT m, ' . |
|
| 396 | - 'BIT_AND(4, 2) AS bit_and,' . |
|
| 397 | - 'BIT_AND( (m.salary/100000) , 2 ) AS salary_bit_and ' . |
|
| 398 | - 'FROM Doctrine\Tests\Models\Company\CompanyManager m ' . |
|
| 399 | - 'ORDER BY ' . |
|
| 400 | - 'm.id ' ; |
|
| 395 | + $dql = 'SELECT m, '. |
|
| 396 | + 'BIT_AND(4, 2) AS bit_and,'. |
|
| 397 | + 'BIT_AND( (m.salary/100000) , 2 ) AS salary_bit_and '. |
|
| 398 | + 'FROM Doctrine\Tests\Models\Company\CompanyManager m '. |
|
| 399 | + 'ORDER BY '. |
|
| 400 | + 'm.id '; |
|
| 401 | 401 | $result = $this->em->createQuery($dql)->getArrayResult(); |
| 402 | 402 | |
| 403 | 403 | self::assertEquals(4 & 2, $result[0]['bit_and']); |
@@ -405,10 +405,10 @@ discard block |
||
| 405 | 405 | self::assertEquals(4 & 2, $result[2]['bit_and']); |
| 406 | 406 | self::assertEquals(4 & 2, $result[3]['bit_and']); |
| 407 | 407 | |
| 408 | - self::assertEquals(($result[0][0]['salary']/100000) & 2, $result[0]['salary_bit_and']); |
|
| 409 | - self::assertEquals(($result[1][0]['salary']/100000) & 2, $result[1]['salary_bit_and']); |
|
| 410 | - self::assertEquals(($result[2][0]['salary']/100000) & 2, $result[2]['salary_bit_and']); |
|
| 411 | - self::assertEquals(($result[3][0]['salary']/100000) & 2, $result[3]['salary_bit_and']); |
|
| 408 | + self::assertEquals(($result[0][0]['salary'] / 100000) & 2, $result[0]['salary_bit_and']); |
|
| 409 | + self::assertEquals(($result[1][0]['salary'] / 100000) & 2, $result[1]['salary_bit_and']); |
|
| 410 | + self::assertEquals(($result[2][0]['salary'] / 100000) & 2, $result[2]['salary_bit_and']); |
|
| 411 | + self::assertEquals(($result[3][0]['salary'] / 100000) & 2, $result[3]['salary_bit_and']); |
|
| 412 | 412 | } |
| 413 | 413 | |
| 414 | 414 | protected function generateFixture() |
@@ -1,6 +1,6 @@ discard block |
||
| 1 | 1 | <?php |
| 2 | 2 | |
| 3 | -declare(strict_types=1); |
|
| 3 | +declare(strict_types = 1); |
|
| 4 | 4 | |
| 5 | 5 | namespace Doctrine\Tests\ORM\Functional; |
| 6 | 6 | |
@@ -47,7 +47,7 @@ discard block |
||
| 47 | 47 | $entity = $this->em->find('\Doctrine\Tests\Models\CustomType\CustomTypeUpperCase', $id); |
| 48 | 48 | |
| 49 | 49 | self::assertEquals('foo', $entity->lowerCaseString, 'Entity holds lowercase string'); |
| 50 | - self::assertEquals('FOO', $this->em->getConnection()->fetchColumn('select lowerCaseString from customtype_uppercases where id=' . $entity->id . ''), 'Database holds uppercase string'); |
|
| 50 | + self::assertEquals('FOO', $this->em->getConnection()->fetchColumn('select lowerCaseString from customtype_uppercases where id='.$entity->id.''), 'Database holds uppercase string'); |
|
| 51 | 51 | } |
| 52 | 52 | |
| 53 | 53 | /** |
@@ -68,7 +68,7 @@ discard block |
||
| 68 | 68 | |
| 69 | 69 | $entity = $this->em->find('\Doctrine\Tests\Models\CustomType\CustomTypeUpperCase', $id); |
| 70 | 70 | self::assertEquals('foo', $entity->namedLowerCaseString, 'Entity holds lowercase string'); |
| 71 | - self::assertEquals('FOO', $this->em->getConnection()->fetchColumn('select named_lower_case_string from customtype_uppercases where id=' . $entity->id . ''), 'Database holds uppercase string'); |
|
| 71 | + self::assertEquals('FOO', $this->em->getConnection()->fetchColumn('select named_lower_case_string from customtype_uppercases where id='.$entity->id.''), 'Database holds uppercase string'); |
|
| 72 | 72 | |
| 73 | 73 | $entity->namedLowerCaseString = 'bar'; |
| 74 | 74 | |
@@ -81,7 +81,7 @@ discard block |
||
| 81 | 81 | |
| 82 | 82 | $entity = $this->em->find('\Doctrine\Tests\Models\CustomType\CustomTypeUpperCase', $id); |
| 83 | 83 | self::assertEquals('bar', $entity->namedLowerCaseString, 'Entity holds lowercase string'); |
| 84 | - self::assertEquals('BAR', $this->em->getConnection()->fetchColumn('select named_lower_case_string from customtype_uppercases where id=' . $entity->id . ''), 'Database holds uppercase string'); |
|
| 84 | + self::assertEquals('BAR', $this->em->getConnection()->fetchColumn('select named_lower_case_string from customtype_uppercases where id='.$entity->id.''), 'Database holds uppercase string'); |
|
| 85 | 85 | } |
| 86 | 86 | |
| 87 | 87 | public function testTypeValueSqlWithAssociations() : void |
@@ -108,7 +108,7 @@ discard block |
||
| 108 | 108 | $entity = $this->em->find(CustomTypeParent::class, $parentId); |
| 109 | 109 | |
| 110 | 110 | self::assertTrue($entity->customInteger < 0, 'Fetched customInteger negative'); |
| 111 | - self::assertEquals(1, $this->em->getConnection()->fetchColumn('select customInteger from customtype_parents where id=' . $entity->id . ''), 'Database has stored customInteger positive'); |
|
| 111 | + self::assertEquals(1, $this->em->getConnection()->fetchColumn('select customInteger from customtype_parents where id='.$entity->id.''), 'Database has stored customInteger positive'); |
|
| 112 | 112 | |
| 113 | 113 | self::assertNotNull($parent->child, 'Child attached'); |
| 114 | 114 | self::assertCount(2, $entity->getMyFriends(), '2 friends attached'); |
@@ -127,7 +127,7 @@ discard block |
||
| 127 | 127 | |
| 128 | 128 | $this->em->clear(); |
| 129 | 129 | |
| 130 | - $query = $this->em->createQuery('SELECT p, p.customInteger, c from Doctrine\Tests\Models\CustomType\CustomTypeParent p JOIN p.child c where p.id = ' . $parentId); |
|
| 130 | + $query = $this->em->createQuery('SELECT p, p.customInteger, c from Doctrine\Tests\Models\CustomType\CustomTypeParent p JOIN p.child c where p.id = '.$parentId); |
|
| 131 | 131 | |
| 132 | 132 | $result = $query->getResult(); |
| 133 | 133 | |
@@ -1,6 +1,6 @@ discard block |
||
| 1 | 1 | <?php |
| 2 | 2 | |
| 3 | -declare(strict_types=1); |
|
| 3 | +declare(strict_types = 1); |
|
| 4 | 4 | |
| 5 | 5 | namespace Doctrine\Tests\ORM\Functional\SchemaTool; |
| 6 | 6 | |
@@ -55,7 +55,7 @@ discard block |
||
| 55 | 55 | */ |
| 56 | 56 | public function testDropPartSchemaWithForeignKeys() : void |
| 57 | 57 | { |
| 58 | - if (! $this->em->getConnection()->getDatabasePlatform()->supportsForeignKeyConstraints()) { |
|
| 58 | + if ( ! $this->em->getConnection()->getDatabasePlatform()->supportsForeignKeyConstraints()) { |
|
| 59 | 59 | $this->markTestSkipped('Foreign Key test'); |
| 60 | 60 | } |
| 61 | 61 | |
@@ -1,6 +1,6 @@ discard block |
||
| 1 | 1 | <?php |
| 2 | 2 | |
| 3 | -declare(strict_types=1); |
|
| 3 | +declare(strict_types = 1); |
|
| 4 | 4 | |
| 5 | 5 | namespace Doctrine\Tests\ORM\Functional\Ticket; |
| 6 | 6 | |
@@ -31,7 +31,7 @@ discard block |
||
| 31 | 31 | |
| 32 | 32 | public function testDql() : void |
| 33 | 33 | { |
| 34 | - $dql = 'SELECT u FROM ' . __NAMESPACE__ . '\DDC1335User u INDEX BY u.id'; |
|
| 34 | + $dql = 'SELECT u FROM '.__NAMESPACE__.'\DDC1335User u INDEX BY u.id'; |
|
| 35 | 35 | $query = $this->em->createQuery($dql); |
| 36 | 36 | $result = $query->getResult(); |
| 37 | 37 | |
@@ -40,7 +40,7 @@ discard block |
||
| 40 | 40 | self::assertArrayHasKey(2, $result); |
| 41 | 41 | self::assertArrayHasKey(3, $result); |
| 42 | 42 | |
| 43 | - $dql = 'SELECT u, p FROM ' . __NAMESPACE__ . '\DDC1335User u INDEX BY u.email INNER JOIN u.phones p INDEX BY p.id'; |
|
| 43 | + $dql = 'SELECT u, p FROM '.__NAMESPACE__.'\DDC1335User u INDEX BY u.email INNER JOIN u.phones p INDEX BY p.id'; |
|
| 44 | 44 | $query = $this->em->createQuery($dql); |
| 45 | 45 | $result = $query->getResult(); |
| 46 | 46 | |
@@ -82,7 +82,7 @@ discard block |
||
| 82 | 82 | self::assertArrayHasKey(1, $result); |
| 83 | 83 | self::assertArrayHasKey(2, $result); |
| 84 | 84 | self::assertArrayHasKey(3, $result); |
| 85 | - self::assertEquals('SELECT u FROM ' . __NAMESPACE__ . '\DDC1335User u INDEX BY u.id', $dql); |
|
| 85 | + self::assertEquals('SELECT u FROM '.__NAMESPACE__.'\DDC1335User u INDEX BY u.id', $dql); |
|
| 86 | 86 | } |
| 87 | 87 | |
| 88 | 88 | public function testIndexByUnique() : void |
@@ -97,7 +97,7 @@ discard block |
||
| 97 | 97 | self::assertArrayHasKey('[email protected]', $result); |
| 98 | 98 | self::assertArrayHasKey('[email protected]', $result); |
| 99 | 99 | self::assertArrayHasKey('[email protected]', $result); |
| 100 | - self::assertEquals('SELECT u FROM ' . __NAMESPACE__ . '\DDC1335User u INDEX BY u.email', $dql); |
|
| 100 | + self::assertEquals('SELECT u FROM '.__NAMESPACE__.'\DDC1335User u INDEX BY u.email', $dql); |
|
| 101 | 101 | } |
| 102 | 102 | |
| 103 | 103 | public function testIndexWithJoin() : void |
@@ -131,14 +131,14 @@ discard block |
||
| 131 | 131 | self::assertArrayHasKey(8, $result['[email protected]']->phones->toArray()); |
| 132 | 132 | self::assertArrayHasKey(9, $result['[email protected]']->phones->toArray()); |
| 133 | 133 | |
| 134 | - self::assertEquals('SELECT u, p FROM ' . __NAMESPACE__ . '\DDC1335User u INDEX BY u.email INNER JOIN u.phones p INDEX BY p.id', $dql); |
|
| 134 | + self::assertEquals('SELECT u, p FROM '.__NAMESPACE__.'\DDC1335User u INDEX BY u.email INNER JOIN u.phones p INDEX BY p.id', $dql); |
|
| 135 | 135 | } |
| 136 | 136 | |
| 137 | 137 | private function loadFixture() |
| 138 | 138 | { |
| 139 | - $p1 = ['11 xxxx-xxxx','11 yyyy-yyyy','11 zzzz-zzzz']; |
|
| 140 | - $p2 = ['22 xxxx-xxxx','22 yyyy-yyyy','22 zzzz-zzzz']; |
|
| 141 | - $p3 = ['33 xxxx-xxxx','33 yyyy-yyyy','33 zzzz-zzzz']; |
|
| 139 | + $p1 = ['11 xxxx-xxxx', '11 yyyy-yyyy', '11 zzzz-zzzz']; |
|
| 140 | + $p2 = ['22 xxxx-xxxx', '22 yyyy-yyyy', '22 zzzz-zzzz']; |
|
| 141 | + $p3 = ['33 xxxx-xxxx', '33 yyyy-yyyy', '33 zzzz-zzzz']; |
|
| 142 | 142 | |
| 143 | 143 | $u1 = new DDC1335User('[email protected]', 'Foo', $p1); |
| 144 | 144 | $u2 = new DDC1335User('[email protected]', 'Bar', $p2); |