@@ -27,8 +27,8 @@ discard block |
||
27 | 27 | public function testAggregateWithHavingClause() |
28 | 28 | { |
29 | 29 | $dql = 'SELECT p.department, AVG(p.salary) AS avgSalary ' . |
30 | - 'FROM Doctrine\Tests\Models\Company\CompanyEmployee p ' . |
|
31 | - 'GROUP BY p.department HAVING SUM(p.salary) > 200000 ORDER BY p.department'; |
|
30 | + 'FROM Doctrine\Tests\Models\Company\CompanyEmployee p ' . |
|
31 | + 'GROUP BY p.department HAVING SUM(p.salary) > 200000 ORDER BY p.department'; |
|
32 | 32 | |
33 | 33 | $result = $this->em->createQuery($dql)->getScalarResult(); |
34 | 34 | |
@@ -42,8 +42,8 @@ discard block |
||
42 | 42 | public function testUnnamedScalarResultsAreOneBased() |
43 | 43 | { |
44 | 44 | $dql = 'SELECT p.department, AVG(p.salary) ' . |
45 | - 'FROM Doctrine\Tests\Models\Company\CompanyEmployee p ' . |
|
46 | - 'GROUP BY p.department HAVING SUM(p.salary) > 200000 ORDER BY p.department'; |
|
45 | + 'FROM Doctrine\Tests\Models\Company\CompanyEmployee p ' . |
|
46 | + 'GROUP BY p.department HAVING SUM(p.salary) > 200000 ORDER BY p.department'; |
|
47 | 47 | |
48 | 48 | $result = $this->em->createQuery($dql)->getScalarResult(); |
49 | 49 | |
@@ -55,9 +55,9 @@ discard block |
||
55 | 55 | public function testOrderByResultVariableCollectionSize() |
56 | 56 | { |
57 | 57 | $dql = 'SELECT p.name, size(p.friends) AS friends ' . |
58 | - 'FROM Doctrine\Tests\Models\Company\CompanyPerson p ' . |
|
59 | - 'WHERE p.friends IS NOT EMPTY ' . |
|
60 | - 'ORDER BY friends DESC, p.name DESC'; |
|
58 | + 'FROM Doctrine\Tests\Models\Company\CompanyPerson p ' . |
|
59 | + 'WHERE p.friends IS NOT EMPTY ' . |
|
60 | + 'ORDER BY friends DESC, p.name DESC'; |
|
61 | 61 | |
62 | 62 | $result = $this->em->createQuery($dql)->getScalarResult(); |
63 | 63 | |
@@ -79,7 +79,7 @@ discard block |
||
79 | 79 | public function testIsNullAssociation() |
80 | 80 | { |
81 | 81 | $dql = 'SELECT p FROM Doctrine\Tests\Models\Company\CompanyPerson p ' . |
82 | - 'WHERE p.spouse IS NULL'; |
|
82 | + 'WHERE p.spouse IS NULL'; |
|
83 | 83 | $result = $this->em->createQuery($dql)->getResult(); |
84 | 84 | |
85 | 85 | self::assertCount(2, $result); |
@@ -93,7 +93,7 @@ discard block |
||
93 | 93 | public function testSelectSubselect() |
94 | 94 | { |
95 | 95 | $dql = 'SELECT p, (SELECT c.brand FROM Doctrine\Tests\Models\Company\CompanyCar c WHERE p.car = c) brandName ' . |
96 | - 'FROM Doctrine\Tests\Models\Company\CompanyManager p'; |
|
96 | + 'FROM Doctrine\Tests\Models\Company\CompanyManager p'; |
|
97 | 97 | $result = $this->em->createQuery($dql)->getArrayResult(); |
98 | 98 | |
99 | 99 | self::assertCount(1, $result); |
@@ -103,7 +103,7 @@ discard block |
||
103 | 103 | public function testInSubselect() |
104 | 104 | { |
105 | 105 | $dql = 'SELECT p.name FROM Doctrine\Tests\Models\Company\CompanyPerson p ' . |
106 | - "WHERE p.name IN (SELECT n.name FROM Doctrine\Tests\Models\Company\CompanyPerson n WHERE n.name = 'Roman B.')"; |
|
106 | + "WHERE p.name IN (SELECT n.name FROM Doctrine\Tests\Models\Company\CompanyPerson n WHERE n.name = 'Roman B.')"; |
|
107 | 107 | $result = $this->em->createQuery($dql)->getScalarResult(); |
108 | 108 | |
109 | 109 | self::assertCount(1, $result); |
@@ -113,7 +113,7 @@ discard block |
||
113 | 113 | public function testGroupByMultipleFields() |
114 | 114 | { |
115 | 115 | $dql = 'SELECT p.department, p.name, count(p.id) FROM Doctrine\Tests\Models\Company\CompanyEmployee p ' . |
116 | - 'GROUP BY p.department, p.name'; |
|
116 | + 'GROUP BY p.department, p.name'; |
|
117 | 117 | $result = $this->em->createQuery($dql)->getResult(); |
118 | 118 | |
119 | 119 | 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 | |
@@ -26,8 +26,8 @@ discard block |
||
26 | 26 | |
27 | 27 | public function testAggregateWithHavingClause() |
28 | 28 | { |
29 | - $dql = 'SELECT p.department, AVG(p.salary) AS avgSalary ' . |
|
30 | - 'FROM Doctrine\Tests\Models\Company\CompanyEmployee p ' . |
|
29 | + $dql = 'SELECT p.department, AVG(p.salary) AS avgSalary '. |
|
30 | + 'FROM Doctrine\Tests\Models\Company\CompanyEmployee p '. |
|
31 | 31 | 'GROUP BY p.department HAVING SUM(p.salary) > 200000 ORDER BY p.department'; |
32 | 32 | |
33 | 33 | $result = $this->em->createQuery($dql)->getScalarResult(); |
@@ -41,8 +41,8 @@ discard block |
||
41 | 41 | |
42 | 42 | public function testUnnamedScalarResultsAreOneBased() |
43 | 43 | { |
44 | - $dql = 'SELECT p.department, AVG(p.salary) ' . |
|
45 | - 'FROM Doctrine\Tests\Models\Company\CompanyEmployee p ' . |
|
44 | + $dql = 'SELECT p.department, AVG(p.salary) '. |
|
45 | + 'FROM Doctrine\Tests\Models\Company\CompanyEmployee p '. |
|
46 | 46 | 'GROUP BY p.department HAVING SUM(p.salary) > 200000 ORDER BY p.department'; |
47 | 47 | |
48 | 48 | $result = $this->em->createQuery($dql)->getScalarResult(); |
@@ -54,9 +54,9 @@ discard block |
||
54 | 54 | |
55 | 55 | public function testOrderByResultVariableCollectionSize() |
56 | 56 | { |
57 | - $dql = 'SELECT p.name, size(p.friends) AS friends ' . |
|
58 | - 'FROM Doctrine\Tests\Models\Company\CompanyPerson p ' . |
|
59 | - 'WHERE p.friends IS NOT EMPTY ' . |
|
57 | + $dql = 'SELECT p.name, size(p.friends) AS friends '. |
|
58 | + 'FROM Doctrine\Tests\Models\Company\CompanyPerson p '. |
|
59 | + 'WHERE p.friends IS NOT EMPTY '. |
|
60 | 60 | 'ORDER BY friends DESC, p.name DESC'; |
61 | 61 | |
62 | 62 | $result = $this->em->createQuery($dql)->getScalarResult(); |
@@ -78,7 +78,7 @@ discard block |
||
78 | 78 | |
79 | 79 | public function testIsNullAssociation() |
80 | 80 | { |
81 | - $dql = 'SELECT p FROM Doctrine\Tests\Models\Company\CompanyPerson p ' . |
|
81 | + $dql = 'SELECT p FROM Doctrine\Tests\Models\Company\CompanyPerson p '. |
|
82 | 82 | 'WHERE p.spouse IS NULL'; |
83 | 83 | $result = $this->em->createQuery($dql)->getResult(); |
84 | 84 | |
@@ -92,7 +92,7 @@ discard block |
||
92 | 92 | |
93 | 93 | public function testSelectSubselect() |
94 | 94 | { |
95 | - $dql = 'SELECT p, (SELECT c.brand FROM Doctrine\Tests\Models\Company\CompanyCar c WHERE p.car = c) brandName ' . |
|
95 | + $dql = 'SELECT p, (SELECT c.brand FROM Doctrine\Tests\Models\Company\CompanyCar c WHERE p.car = c) brandName '. |
|
96 | 96 | 'FROM Doctrine\Tests\Models\Company\CompanyManager p'; |
97 | 97 | $result = $this->em->createQuery($dql)->getArrayResult(); |
98 | 98 | |
@@ -102,7 +102,7 @@ discard block |
||
102 | 102 | |
103 | 103 | public function testInSubselect() |
104 | 104 | { |
105 | - $dql = 'SELECT p.name FROM Doctrine\Tests\Models\Company\CompanyPerson p ' . |
|
105 | + $dql = 'SELECT p.name FROM Doctrine\Tests\Models\Company\CompanyPerson p '. |
|
106 | 106 | "WHERE p.name IN (SELECT n.name FROM Doctrine\Tests\Models\Company\CompanyPerson n WHERE n.name = 'Roman B.')"; |
107 | 107 | $result = $this->em->createQuery($dql)->getScalarResult(); |
108 | 108 | |
@@ -112,7 +112,7 @@ discard block |
||
112 | 112 | |
113 | 113 | public function testGroupByMultipleFields() |
114 | 114 | { |
115 | - $dql = 'SELECT p.department, p.name, count(p.id) FROM Doctrine\Tests\Models\Company\CompanyEmployee p ' . |
|
115 | + $dql = 'SELECT p.department, p.name, count(p.id) FROM Doctrine\Tests\Models\Company\CompanyEmployee p '. |
|
116 | 116 | 'GROUP BY p.department, p.name'; |
117 | 117 | $result = $this->em->createQuery($dql)->getResult(); |
118 | 118 |
@@ -104,8 +104,8 @@ |
||
104 | 104 | $routeId = $this->createPersistedRouteWithLegs(); |
105 | 105 | |
106 | 106 | $route = $this->em->createQuery('SELECT r, l FROM Doctrine\Tests\Models\Routing\RoutingRoute r JOIN r.legs l WHERE r.id = ?1') |
107 | - ->setParameter(1, $routeId) |
|
108 | - ->getSingleResult(); |
|
107 | + ->setParameter(1, $routeId) |
|
108 | + ->getSingleResult(); |
|
109 | 109 | |
110 | 110 | self::assertCount(2, $route->legs); |
111 | 111 | self::assertEquals('Berlin', $route->legs[0]->fromLocation->getName()); |
@@ -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 | |
@@ -332,19 +332,19 @@ discard block |
||
332 | 332 | |
333 | 333 | $repos = $this->em->getRepository(CompanyContract::class); |
334 | 334 | $contracts = $repos->findBy(['salesPerson' => $this->salesPerson->getId()]); |
335 | - self::assertCount(3, $contracts, 'There should be 3 entities related to ' . $this->salesPerson->getId() . " for 'Doctrine\Tests\Models\Company\CompanyContract'"); |
|
335 | + self::assertCount(3, $contracts, 'There should be 3 entities related to '.$this->salesPerson->getId()." for 'Doctrine\Tests\Models\Company\CompanyContract'"); |
|
336 | 336 | |
337 | 337 | $repos = $this->em->getRepository(CompanyFixContract::class); |
338 | 338 | $contracts = $repos->findBy(['salesPerson' => $this->salesPerson->getId()]); |
339 | - self::assertCount(1, $contracts, 'There should be 1 entities related to ' . $this->salesPerson->getId() . " for 'Doctrine\Tests\Models\Company\CompanyFixContract'"); |
|
339 | + self::assertCount(1, $contracts, 'There should be 1 entities related to '.$this->salesPerson->getId()." for 'Doctrine\Tests\Models\Company\CompanyFixContract'"); |
|
340 | 340 | |
341 | 341 | $repos = $this->em->getRepository(CompanyFlexContract::class); |
342 | 342 | $contracts = $repos->findBy(['salesPerson' => $this->salesPerson->getId()]); |
343 | - self::assertCount(2, $contracts, 'There should be 2 entities related to ' . $this->salesPerson->getId() . " for 'Doctrine\Tests\Models\Company\CompanyFlexContract'"); |
|
343 | + self::assertCount(2, $contracts, 'There should be 2 entities related to '.$this->salesPerson->getId()." for 'Doctrine\Tests\Models\Company\CompanyFlexContract'"); |
|
344 | 344 | |
345 | 345 | $repos = $this->em->getRepository(CompanyFlexUltraContract::class); |
346 | 346 | $contracts = $repos->findBy(['salesPerson' => $this->salesPerson->getId()]); |
347 | - self::assertCount(1, $contracts, 'There should be 1 entities related to ' . $this->salesPerson->getId() . " for 'Doctrine\Tests\Models\Company\CompanyFlexUltraContract'"); |
|
347 | + self::assertCount(1, $contracts, 'There should be 1 entities related to '.$this->salesPerson->getId()." for 'Doctrine\Tests\Models\Company\CompanyFlexUltraContract'"); |
|
348 | 348 | } |
349 | 349 | |
350 | 350 | /** |
@@ -361,9 +361,9 @@ discard block |
||
361 | 361 | self::assertCount(2, $user->phonenumbers); |
362 | 362 | $dql = 'SELECT u FROM Doctrine\Tests\Models\CMS\CmsUser u WHERE u.id = ?1'; |
363 | 363 | $user = $this->em->createQuery($dql) |
364 | - ->setParameter(1, $user->id) |
|
365 | - ->setHint(Query::HINT_REFRESH, true) |
|
366 | - ->getSingleResult(); |
|
364 | + ->setParameter(1, $user->id) |
|
365 | + ->setHint(Query::HINT_REFRESH, true) |
|
366 | + ->getSingleResult(); |
|
367 | 367 | |
368 | 368 | self::assertCount(1, $user->phonenumbers); |
369 | 369 | } |
@@ -398,8 +398,8 @@ discard block |
||
398 | 398 | |
399 | 399 | $dql = 'SELECT u FROM Doctrine\Tests\Models\CMS\CmsUser u WHERE u.id = ?1'; |
400 | 400 | $user = $this->em->createQuery($dql) |
401 | - ->setParameter(1, $userId) |
|
402 | - ->getSingleResult(); |
|
401 | + ->setParameter(1, $userId) |
|
402 | + ->getSingleResult(); |
|
403 | 403 | |
404 | 404 | self::assertCount(1, $user->phonenumbers); |
405 | 405 | } |
@@ -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 | |
@@ -183,7 +183,7 @@ discard block |
||
183 | 183 | $user->username = 'gblanco'; |
184 | 184 | $user->status = 'developer'; |
185 | 185 | |
186 | - for ($i=0; $i<3; ++$i) { |
|
186 | + for ($i = 0; $i < 3; ++$i) { |
|
187 | 187 | $phone = new CmsPhonenumber; |
188 | 188 | $phone->phonenumber = 100 + $i; |
189 | 189 | $user->addPhonenumber($phone); |
@@ -411,7 +411,7 @@ discard block |
||
411 | 411 | $user->username = 'gblanco'; |
412 | 412 | $user->status = 'developer'; |
413 | 413 | |
414 | - for ($i=0; $i<3; ++$i) { |
|
414 | + for ($i = 0; $i < 3; ++$i) { |
|
415 | 415 | $phone = new CmsPhonenumber; |
416 | 416 | $phone->phonenumber = 100 + $i; |
417 | 417 | $user->addPhonenumber($phone); |
@@ -451,7 +451,7 @@ discard block |
||
451 | 451 | $user->username = 'gblanco'; |
452 | 452 | $user->status = 'developer'; |
453 | 453 | |
454 | - for ($i=0; $i<3; ++$i) { |
|
454 | + for ($i = 0; $i < 3; ++$i) { |
|
455 | 455 | $phone = new CmsPhonenumber; |
456 | 456 | $phone->phonenumber = 100 + $i; |
457 | 457 | $user->addPhonenumber($phone); |
@@ -492,7 +492,7 @@ discard block |
||
492 | 492 | $user->username = 'gblanco'; |
493 | 493 | $user->status = 'developer'; |
494 | 494 | |
495 | - for ($i=0; $i<3; ++$i) { |
|
495 | + for ($i = 0; $i < 3; ++$i) { |
|
496 | 496 | $phone = new CmsPhonenumber; |
497 | 497 | $phone->phonenumber = 100 + $i; |
498 | 498 | $user->addPhonenumber($phone); |
@@ -678,12 +678,12 @@ discard block |
||
678 | 678 | $this->em->persist($user); |
679 | 679 | $this->em->flush(); |
680 | 680 | |
681 | - self::assertEquals(1, $this->em->getConnection()->fetchColumn('select 1 from cms_addresses where user_id = ' . $user->id)); |
|
681 | + self::assertEquals(1, $this->em->getConnection()->fetchColumn('select 1 from cms_addresses where user_id = '.$user->id)); |
|
682 | 682 | |
683 | 683 | $address->user = null; |
684 | 684 | $this->em->flush(); |
685 | 685 | |
686 | - self::assertNotEquals(1, $this->em->getConnection()->fetchColumn('select 1 from cms_addresses where user_id = ' . $user->id)); |
|
686 | + self::assertNotEquals(1, $this->em->getConnection()->fetchColumn('select 1 from cms_addresses where user_id = '.$user->id)); |
|
687 | 687 | } |
688 | 688 | |
689 | 689 | /** |
@@ -877,7 +877,7 @@ discard block |
||
877 | 877 | |
878 | 878 | self::assertInstanceOf(GhostObjectInterface::class, $fetchedUser, 'It IS a proxy, ...'); |
879 | 879 | self::assertTrue($fetchedUser->isProxyInitialized(), '...but its initialized!'); |
880 | - self::assertEquals($qc+2, $this->getCurrentQueryCount()); |
|
880 | + self::assertEquals($qc + 2, $this->getCurrentQueryCount()); |
|
881 | 881 | } |
882 | 882 | |
883 | 883 | /** |
@@ -938,7 +938,7 @@ discard block |
||
938 | 938 | |
939 | 939 | $this->expectException(ORMInvalidArgumentException::class); |
940 | 940 | $this->expectExceptionMessage( |
941 | - 'Expected value of type "Doctrine\Tests\Models\CMS\CmsAddress" for association field ' . |
|
941 | + 'Expected value of type "Doctrine\Tests\Models\CMS\CmsAddress" for association field '. |
|
942 | 942 | '"Doctrine\Tests\Models\CMS\CmsUser#$address", got "Doctrine\Tests\Models\CMS\CmsUser" instead.' |
943 | 943 | ); |
944 | 944 |
@@ -223,13 +223,13 @@ |
||
223 | 223 | |
224 | 224 | $q = $this->em->createNativeQuery('SELECT id, name, status, phonenumber FROM cms_users INNER JOIN cms_phonenumbers ON id = user_id WHERE username = ?', $rsm); |
225 | 225 | $q2 = $q->setSQL('foo') |
226 | - ->setResultSetMapping($rsm) |
|
227 | - ->expireResultCache(true) |
|
228 | - ->setHint('foo', 'bar') |
|
229 | - ->setParameter(1, 'foo') |
|
230 | - ->setParameters($parameters) |
|
231 | - ->setResultCacheDriver(null) |
|
232 | - ->setResultCacheLifetime(3500); |
|
226 | + ->setResultSetMapping($rsm) |
|
227 | + ->expireResultCache(true) |
|
228 | + ->setHint('foo', 'bar') |
|
229 | + ->setParameter(1, 'foo') |
|
230 | + ->setParameters($parameters) |
|
231 | + ->setResultCacheDriver(null) |
|
232 | + ->setResultCacheLifetime(3500); |
|
233 | 233 | |
234 | 234 | self::assertSame($q, $q2); |
235 | 235 | } |
@@ -25,7 +25,7 @@ discard block |
||
25 | 25 | public function testAggregateSum() |
26 | 26 | { |
27 | 27 | $salarySum = $this->em->createQuery('SELECT SUM(m.salary) AS salary FROM Doctrine\Tests\Models\Company\CompanyManager m') |
28 | - ->getSingleResult(); |
|
28 | + ->getSingleResult(); |
|
29 | 29 | |
30 | 30 | self::assertEquals(1500000, $salarySum['salary']); |
31 | 31 | } |
@@ -33,7 +33,7 @@ discard block |
||
33 | 33 | public function testAggregateAvg() |
34 | 34 | { |
35 | 35 | $salaryAvg = $this->em->createQuery('SELECT AVG(m.salary) AS salary FROM Doctrine\Tests\Models\Company\CompanyManager m') |
36 | - ->getSingleResult(); |
|
36 | + ->getSingleResult(); |
|
37 | 37 | |
38 | 38 | self::assertEquals(375000, round($salaryAvg['salary'], 0)); |
39 | 39 | } |
@@ -41,7 +41,7 @@ discard block |
||
41 | 41 | public function testAggregateMin() |
42 | 42 | { |
43 | 43 | $salary = $this->em->createQuery('SELECT MIN(m.salary) AS salary FROM Doctrine\Tests\Models\Company\CompanyManager m') |
44 | - ->getSingleResult(); |
|
44 | + ->getSingleResult(); |
|
45 | 45 | |
46 | 46 | self::assertEquals(100000, $salary['salary']); |
47 | 47 | } |
@@ -49,7 +49,7 @@ discard block |
||
49 | 49 | public function testAggregateMax() |
50 | 50 | { |
51 | 51 | $salary = $this->em->createQuery('SELECT MAX(m.salary) AS salary FROM Doctrine\Tests\Models\Company\CompanyManager m') |
52 | - ->getSingleResult(); |
|
52 | + ->getSingleResult(); |
|
53 | 53 | |
54 | 54 | self::assertEquals(800000, $salary['salary']); |
55 | 55 | } |
@@ -57,7 +57,7 @@ discard block |
||
57 | 57 | public function testAggregateCount() |
58 | 58 | { |
59 | 59 | $managerCount = $this->em->createQuery('SELECT COUNT(m.id) AS managers FROM Doctrine\Tests\Models\Company\CompanyManager m') |
60 | - ->getSingleResult(); |
|
60 | + ->getSingleResult(); |
|
61 | 61 | |
62 | 62 | self::assertEquals(4, $managerCount['managers']); |
63 | 63 | } |
@@ -65,7 +65,7 @@ discard block |
||
65 | 65 | public function testFunctionAbs() |
66 | 66 | { |
67 | 67 | $result = $this->em->createQuery('SELECT m, ABS(m.salary * -1) AS abs FROM Doctrine\Tests\Models\Company\CompanyManager m ORDER BY m.salary ASC') |
68 | - ->getResult(); |
|
68 | + ->getResult(); |
|
69 | 69 | |
70 | 70 | self::assertCount(4, $result); |
71 | 71 | self::assertEquals(100000, $result[0]['abs']); |
@@ -77,7 +77,7 @@ discard block |
||
77 | 77 | public function testFunctionConcat() |
78 | 78 | { |
79 | 79 | $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') |
80 | - ->getArrayResult(); |
|
80 | + ->getArrayResult(); |
|
81 | 81 | |
82 | 82 | self::assertCount(4, $arg); |
83 | 83 | self::assertEquals('Roman B.IT', $arg[0]['namedep']); |
@@ -89,7 +89,7 @@ discard block |
||
89 | 89 | public function testFunctionLength() |
90 | 90 | { |
91 | 91 | $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') |
92 | - ->getArrayResult(); |
|
92 | + ->getArrayResult(); |
|
93 | 93 | |
94 | 94 | self::assertCount(4, $result); |
95 | 95 | self::assertEquals(10, $result[0]['namedeplength']); |
@@ -101,10 +101,10 @@ discard block |
||
101 | 101 | public function testFunctionLocate() |
102 | 102 | { |
103 | 103 | $dql = "SELECT m, LOCATE('e', LOWER(m.name)) AS loc, LOCATE('e', LOWER(m.name), 7) AS loc2 " . |
104 | - 'FROM Doctrine\Tests\Models\Company\CompanyManager m ORDER BY m.salary ASC'; |
|
104 | + 'FROM Doctrine\Tests\Models\Company\CompanyManager m ORDER BY m.salary ASC'; |
|
105 | 105 | |
106 | 106 | $result = $this->em->createQuery($dql) |
107 | - ->getArrayResult(); |
|
107 | + ->getArrayResult(); |
|
108 | 108 | |
109 | 109 | self::assertCount(4, $result); |
110 | 110 | self::assertEquals(0, $result[0]['loc']); |
@@ -120,7 +120,7 @@ discard block |
||
120 | 120 | public function testFunctionLower() |
121 | 121 | { |
122 | 122 | $result = $this->em->createQuery('SELECT m, LOWER(m.name) AS lowername FROM Doctrine\Tests\Models\Company\CompanyManager m ORDER BY m.salary ASC') |
123 | - ->getArrayResult(); |
|
123 | + ->getArrayResult(); |
|
124 | 124 | |
125 | 125 | self::assertCount(4, $result); |
126 | 126 | self::assertEquals('roman b.', $result[0]['lowername']); |
@@ -132,7 +132,7 @@ discard block |
||
132 | 132 | public function testFunctionMod() |
133 | 133 | { |
134 | 134 | $result = $this->em->createQuery('SELECT m, MOD(m.salary, 3500) AS amod FROM Doctrine\Tests\Models\Company\CompanyManager m ORDER BY m.salary ASC') |
135 | - ->getArrayResult(); |
|
135 | + ->getArrayResult(); |
|
136 | 136 | |
137 | 137 | self::assertCount(4, $result); |
138 | 138 | self::assertEquals(2000, $result[0]['amod']); |
@@ -144,7 +144,7 @@ discard block |
||
144 | 144 | public function testFunctionSqrt() |
145 | 145 | { |
146 | 146 | $result = $this->em->createQuery('SELECT m, SQRT(m.salary) AS sqrtsalary FROM Doctrine\Tests\Models\Company\CompanyManager m ORDER BY m.salary ASC') |
147 | - ->getArrayResult(); |
|
147 | + ->getArrayResult(); |
|
148 | 148 | |
149 | 149 | self::assertCount(4, $result); |
150 | 150 | self::assertEquals(316, round($result[0]['sqrtsalary'])); |
@@ -156,7 +156,7 @@ discard block |
||
156 | 156 | public function testFunctionUpper() |
157 | 157 | { |
158 | 158 | $result = $this->em->createQuery('SELECT m, UPPER(m.name) AS uppername FROM Doctrine\Tests\Models\Company\CompanyManager m ORDER BY m.salary ASC') |
159 | - ->getArrayResult(); |
|
159 | + ->getArrayResult(); |
|
160 | 160 | |
161 | 161 | self::assertCount(4, $result); |
162 | 162 | self::assertEquals('ROMAN B.', $result[0]['uppername']); |
@@ -171,7 +171,7 @@ discard block |
||
171 | 171 | 'FROM Doctrine\Tests\Models\Company\CompanyManager m ORDER BY m.name'; |
172 | 172 | |
173 | 173 | $result = $this->em->createQuery($dql) |
174 | - ->getArrayResult(); |
|
174 | + ->getArrayResult(); |
|
175 | 175 | |
176 | 176 | self::assertCount(4, $result); |
177 | 177 | self::assertEquals('Ben', $result[0]['str1']); |
@@ -188,8 +188,8 @@ discard block |
||
188 | 188 | public function testFunctionTrim() |
189 | 189 | { |
190 | 190 | $dql = "SELECT m, TRIM(TRAILING '.' FROM m.name) AS str1, " . |
191 | - " TRIM(LEADING '.' FROM m.name) AS str2, TRIM(CONCAT(' ', CONCAT(m.name, ' '))) AS str3 " . |
|
192 | - 'FROM Doctrine\Tests\Models\Company\CompanyManager m ORDER BY m.salary ASC'; |
|
191 | + " TRIM(LEADING '.' FROM m.name) AS str2, TRIM(CONCAT(' ', CONCAT(m.name, ' '))) AS str3 " . |
|
192 | + 'FROM Doctrine\Tests\Models\Company\CompanyManager m ORDER BY m.salary ASC'; |
|
193 | 193 | |
194 | 194 | $result = $this->em->createQuery($dql)->getArrayResult(); |
195 | 195 | |
@@ -330,8 +330,8 @@ discard block |
||
330 | 330 | ); |
331 | 331 | |
332 | 332 | $result = $this->em->createQuery($query) |
333 | - ->setMaxResults(1) |
|
334 | - ->getSingleResult(AbstractQuery::HYDRATE_ARRAY); |
|
333 | + ->setMaxResults(1) |
|
334 | + ->getSingleResult(AbstractQuery::HYDRATE_ARRAY); |
|
335 | 335 | |
336 | 336 | self::assertArrayHasKey('now', $result); |
337 | 337 | 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 | |
@@ -100,7 +100,7 @@ discard block |
||
100 | 100 | |
101 | 101 | public function testFunctionLocate() |
102 | 102 | { |
103 | - $dql = "SELECT m, LOCATE('e', LOWER(m.name)) AS loc, LOCATE('e', LOWER(m.name), 7) AS loc2 " . |
|
103 | + $dql = "SELECT m, LOCATE('e', LOWER(m.name)) AS loc, LOCATE('e', LOWER(m.name), 7) AS loc2 ". |
|
104 | 104 | 'FROM Doctrine\Tests\Models\Company\CompanyManager m ORDER BY m.salary ASC'; |
105 | 105 | |
106 | 106 | $result = $this->em->createQuery($dql) |
@@ -167,7 +167,7 @@ discard block |
||
167 | 167 | |
168 | 168 | public function testFunctionSubstring() |
169 | 169 | { |
170 | - $dql = 'SELECT m, SUBSTRING(m.name, 1, 3) AS str1, SUBSTRING(m.name, 5) AS str2 ' . |
|
170 | + $dql = 'SELECT m, SUBSTRING(m.name, 1, 3) AS str1, SUBSTRING(m.name, 5) AS str2 '. |
|
171 | 171 | 'FROM Doctrine\Tests\Models\Company\CompanyManager m ORDER BY m.name'; |
172 | 172 | |
173 | 173 | $result = $this->em->createQuery($dql) |
@@ -187,8 +187,8 @@ discard block |
||
187 | 187 | |
188 | 188 | public function testFunctionTrim() |
189 | 189 | { |
190 | - $dql = "SELECT m, TRIM(TRAILING '.' FROM m.name) AS str1, " . |
|
191 | - " TRIM(LEADING '.' FROM m.name) AS str2, TRIM(CONCAT(' ', CONCAT(m.name, ' '))) AS str3 " . |
|
190 | + $dql = "SELECT m, TRIM(TRAILING '.' FROM m.name) AS str1, ". |
|
191 | + " TRIM(LEADING '.' FROM m.name) AS str2, TRIM(CONCAT(' ', CONCAT(m.name, ' '))) AS str3 ". |
|
192 | 192 | 'FROM Doctrine\Tests\Models\Company\CompanyManager m ORDER BY m.salary ASC'; |
193 | 193 | |
194 | 194 | $result = $this->em->createQuery($dql)->getArrayResult(); |
@@ -360,12 +360,12 @@ discard block |
||
360 | 360 | */ |
361 | 361 | public function testBitOrComparison() |
362 | 362 | { |
363 | - $dql = 'SELECT m, ' . |
|
364 | - 'BIT_OR(4, 2) AS bit_or,' . |
|
365 | - 'BIT_OR( (m.salary/100000) , 2 ) AS salary_bit_or ' . |
|
366 | - 'FROM Doctrine\Tests\Models\Company\CompanyManager m ' . |
|
367 | - 'ORDER BY ' . |
|
368 | - 'm.id ' ; |
|
363 | + $dql = 'SELECT m, '. |
|
364 | + 'BIT_OR(4, 2) AS bit_or,'. |
|
365 | + 'BIT_OR( (m.salary/100000) , 2 ) AS salary_bit_or '. |
|
366 | + 'FROM Doctrine\Tests\Models\Company\CompanyManager m '. |
|
367 | + 'ORDER BY '. |
|
368 | + 'm.id '; |
|
369 | 369 | $result = $this->em->createQuery($dql)->getArrayResult(); |
370 | 370 | |
371 | 371 | self::assertEquals(4 | 2, $result[0]['bit_or']); |
@@ -373,10 +373,10 @@ discard block |
||
373 | 373 | self::assertEquals(4 | 2, $result[2]['bit_or']); |
374 | 374 | self::assertEquals(4 | 2, $result[3]['bit_or']); |
375 | 375 | |
376 | - self::assertEquals(($result[0][0]['salary']/100000) | 2, $result[0]['salary_bit_or']); |
|
377 | - self::assertEquals(($result[1][0]['salary']/100000) | 2, $result[1]['salary_bit_or']); |
|
378 | - self::assertEquals(($result[2][0]['salary']/100000) | 2, $result[2]['salary_bit_or']); |
|
379 | - self::assertEquals(($result[3][0]['salary']/100000) | 2, $result[3]['salary_bit_or']); |
|
376 | + self::assertEquals(($result[0][0]['salary'] / 100000) | 2, $result[0]['salary_bit_or']); |
|
377 | + self::assertEquals(($result[1][0]['salary'] / 100000) | 2, $result[1]['salary_bit_or']); |
|
378 | + self::assertEquals(($result[2][0]['salary'] / 100000) | 2, $result[2]['salary_bit_or']); |
|
379 | + self::assertEquals(($result[3][0]['salary'] / 100000) | 2, $result[3]['salary_bit_or']); |
|
380 | 380 | } |
381 | 381 | |
382 | 382 | /** |
@@ -384,12 +384,12 @@ discard block |
||
384 | 384 | */ |
385 | 385 | public function testBitAndComparison() |
386 | 386 | { |
387 | - $dql = 'SELECT m, ' . |
|
388 | - 'BIT_AND(4, 2) AS bit_and,' . |
|
389 | - 'BIT_AND( (m.salary/100000) , 2 ) AS salary_bit_and ' . |
|
390 | - 'FROM Doctrine\Tests\Models\Company\CompanyManager m ' . |
|
391 | - 'ORDER BY ' . |
|
392 | - 'm.id ' ; |
|
387 | + $dql = 'SELECT m, '. |
|
388 | + 'BIT_AND(4, 2) AS bit_and,'. |
|
389 | + 'BIT_AND( (m.salary/100000) , 2 ) AS salary_bit_and '. |
|
390 | + 'FROM Doctrine\Tests\Models\Company\CompanyManager m '. |
|
391 | + 'ORDER BY '. |
|
392 | + 'm.id '; |
|
393 | 393 | $result = $this->em->createQuery($dql)->getArrayResult(); |
394 | 394 | |
395 | 395 | self::assertEquals(4 & 2, $result[0]['bit_and']); |
@@ -397,10 +397,10 @@ discard block |
||
397 | 397 | self::assertEquals(4 & 2, $result[2]['bit_and']); |
398 | 398 | self::assertEquals(4 & 2, $result[3]['bit_and']); |
399 | 399 | |
400 | - self::assertEquals(($result[0][0]['salary']/100000) & 2, $result[0]['salary_bit_and']); |
|
401 | - self::assertEquals(($result[1][0]['salary']/100000) & 2, $result[1]['salary_bit_and']); |
|
402 | - self::assertEquals(($result[2][0]['salary']/100000) & 2, $result[2]['salary_bit_and']); |
|
403 | - self::assertEquals(($result[3][0]['salary']/100000) & 2, $result[3]['salary_bit_and']); |
|
400 | + self::assertEquals(($result[0][0]['salary'] / 100000) & 2, $result[0]['salary_bit_and']); |
|
401 | + self::assertEquals(($result[1][0]['salary'] / 100000) & 2, $result[1]['salary_bit_and']); |
|
402 | + self::assertEquals(($result[2][0]['salary'] / 100000) & 2, $result[2]['salary_bit_and']); |
|
403 | + self::assertEquals(($result[3][0]['salary'] / 100000) & 2, $result[3]['salary_bit_and']); |
|
404 | 404 | } |
405 | 405 | |
406 | 406 | 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 | |
@@ -154,7 +154,7 @@ discard block |
||
154 | 154 | */ |
155 | 155 | private $ownerO; |
156 | 156 | |
157 | - public function __construct(CascadeRemoveOrderEntityO $eO, $position=1) |
|
157 | + public function __construct(CascadeRemoveOrderEntityO $eO, $position = 1) |
|
158 | 158 | { |
159 | 159 | $this->position = $position; |
160 | 160 | $this->ownerO = $eO; |
@@ -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 | |
@@ -30,7 +30,7 @@ discard block |
||
30 | 30 | $this->em->flush(); |
31 | 31 | $this->em->clear(); |
32 | 32 | |
33 | - $dql = 'SELECT d FROM ' . DecimalModel::class . ' d'; |
|
33 | + $dql = 'SELECT d FROM '.DecimalModel::class.' d'; |
|
34 | 34 | $decimal = $this->em->createQuery($dql)->getSingleResult(); |
35 | 35 | |
36 | 36 | self::assertSame('0.15', $decimal->decimal); |
@@ -49,7 +49,7 @@ discard block |
||
49 | 49 | $this->em->flush(); |
50 | 50 | $this->em->clear(); |
51 | 51 | |
52 | - $dql = 'SELECT b FROM ' . BooleanModel::class . ' b WHERE b.booleanField = true'; |
|
52 | + $dql = 'SELECT b FROM '.BooleanModel::class.' b WHERE b.booleanField = true'; |
|
53 | 53 | $bool = $this->em->createQuery($dql)->getSingleResult(); |
54 | 54 | |
55 | 55 | self::assertTrue($bool->booleanField); |
@@ -59,7 +59,7 @@ discard block |
||
59 | 59 | $this->em->flush(); |
60 | 60 | $this->em->clear(); |
61 | 61 | |
62 | - $dql = 'SELECT b FROM ' . BooleanModel::class . ' b WHERE b.booleanField = false'; |
|
62 | + $dql = 'SELECT b FROM '.BooleanModel::class.' b WHERE b.booleanField = false'; |
|
63 | 63 | $bool = $this->em->createQuery($dql)->getSingleResult(); |
64 | 64 | |
65 | 65 | self::assertFalse($bool->booleanField); |
@@ -75,7 +75,7 @@ discard block |
||
75 | 75 | $this->em->flush(); |
76 | 76 | $this->em->clear(); |
77 | 77 | |
78 | - $dql = 'SELECT s FROM ' . SerializationModel::class . ' s'; |
|
78 | + $dql = 'SELECT s FROM '.SerializationModel::class.' s'; |
|
79 | 79 | $serialize = $this->em->createQuery($dql)->getSingleResult(); |
80 | 80 | |
81 | 81 | self::assertSame(['foo' => 'bar', 'bar' => 'baz'], $serialize->array); |
@@ -90,7 +90,7 @@ discard block |
||
90 | 90 | $this->em->flush(); |
91 | 91 | $this->em->clear(); |
92 | 92 | |
93 | - $dql = 'SELECT s FROM ' . SerializationModel::class . ' s'; |
|
93 | + $dql = 'SELECT s FROM '.SerializationModel::class.' s'; |
|
94 | 94 | $serialize = $this->em->createQuery($dql)->getSingleResult(); |
95 | 95 | |
96 | 96 | self::assertInstanceOf('stdClass', $serialize->object); |
@@ -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 | |
@@ -306,7 +306,7 @@ discard block |
||
306 | 306 | |
307 | 307 | $queryCount = $this->getCurrentQueryCount(); |
308 | 308 | self::assertFalse($user->articles->contains($article)); |
309 | - self::assertEquals($queryCount+1, $this->getCurrentQueryCount(), 'Checking for contains of persisted entity should cause one query to be executed.'); |
|
309 | + self::assertEquals($queryCount + 1, $this->getCurrentQueryCount(), 'Checking for contains of persisted entity should cause one query to be executed.'); |
|
310 | 310 | self::assertFalse($user->articles->isInitialized(), 'Post-Condition: Collection is not initialized.'); |
311 | 311 | |
312 | 312 | // Test One to Many existence with state managed |
@@ -473,7 +473,7 @@ discard block |
||
473 | 473 | |
474 | 474 | $queryCount = $this->getCurrentQueryCount(); |
475 | 475 | self::assertTrue($group->users->contains($user)); |
476 | - self::assertEquals($queryCount+1, $this->getCurrentQueryCount(), 'Checking for contains of managed entity should cause one query to be executed.'); |
|
476 | + self::assertEquals($queryCount + 1, $this->getCurrentQueryCount(), 'Checking for contains of managed entity should cause one query to be executed.'); |
|
477 | 477 | self::assertFalse($user->groups->isInitialized(), 'Post-Condition: Collection is not initialized.'); |
478 | 478 | |
479 | 479 | $newUser = new CmsUser(); |