@@ -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); |
@@ -102,7 +102,7 @@ discard block |
||
102 | 102 | |
103 | 103 | public function testFunctionLocate() : void |
104 | 104 | { |
105 | - $dql = "SELECT m, LOCATE('e', LOWER(m.name)) AS loc, LOCATE('e', LOWER(m.name), 7) AS loc2 " . |
|
105 | + $dql = "SELECT m, LOCATE('e', LOWER(m.name)) AS loc, LOCATE('e', LOWER(m.name), 7) AS loc2 ". |
|
106 | 106 | 'FROM Doctrine\Tests\Models\Company\CompanyManager m ORDER BY m.salary ASC'; |
107 | 107 | |
108 | 108 | $result = $this->em->createQuery($dql) |
@@ -169,7 +169,7 @@ discard block |
||
169 | 169 | |
170 | 170 | public function testFunctionSubstring() : void |
171 | 171 | { |
172 | - $dql = 'SELECT m, SUBSTRING(m.name, 1, 3) AS str1, SUBSTRING(m.name, 5) AS str2 ' . |
|
172 | + $dql = 'SELECT m, SUBSTRING(m.name, 1, 3) AS str1, SUBSTRING(m.name, 5) AS str2 '. |
|
173 | 173 | 'FROM Doctrine\Tests\Models\Company\CompanyManager m ORDER BY m.name'; |
174 | 174 | |
175 | 175 | $result = $this->em->createQuery($dql) |
@@ -189,8 +189,8 @@ discard block |
||
189 | 189 | |
190 | 190 | public function testFunctionTrim() : void |
191 | 191 | { |
192 | - $dql = "SELECT m, TRIM(TRAILING '.' FROM m.name) AS str1, " . |
|
193 | - " TRIM(LEADING '.' FROM m.name) AS str2, TRIM(CONCAT(' ', CONCAT(m.name, ' '))) AS str3 " . |
|
192 | + $dql = "SELECT m, TRIM(TRAILING '.' FROM m.name) AS str1, ". |
|
193 | + " TRIM(LEADING '.' FROM m.name) AS str2, TRIM(CONCAT(' ', CONCAT(m.name, ' '))) AS str3 ". |
|
194 | 194 | 'FROM Doctrine\Tests\Models\Company\CompanyManager m ORDER BY m.salary ASC'; |
195 | 195 | |
196 | 196 | $result = $this->em->createQuery($dql)->getArrayResult(); |
@@ -369,11 +369,11 @@ discard block |
||
369 | 369 | */ |
370 | 370 | public function testBitOrComparison() : void |
371 | 371 | { |
372 | - $dql = 'SELECT m, ' . |
|
373 | - 'BIT_OR(4, 2) AS bit_or,' . |
|
374 | - 'BIT_OR( (m.salary/100000) , 2 ) AS salary_bit_or ' . |
|
375 | - 'FROM Doctrine\Tests\Models\Company\CompanyManager m ' . |
|
376 | - 'ORDER BY ' . |
|
372 | + $dql = 'SELECT m, '. |
|
373 | + 'BIT_OR(4, 2) AS bit_or,'. |
|
374 | + 'BIT_OR( (m.salary/100000) , 2 ) AS salary_bit_or '. |
|
375 | + 'FROM Doctrine\Tests\Models\Company\CompanyManager m '. |
|
376 | + 'ORDER BY '. |
|
377 | 377 | 'm.id '; |
378 | 378 | $result = $this->em->createQuery($dql)->getArrayResult(); |
379 | 379 | |
@@ -382,10 +382,10 @@ discard block |
||
382 | 382 | self::assertEquals(4 | 2, $result[2]['bit_or']); |
383 | 383 | self::assertEquals(4 | 2, $result[3]['bit_or']); |
384 | 384 | |
385 | - self::assertEquals(($result[0][0]['salary']/100000) | 2, $result[0]['salary_bit_or']); |
|
386 | - self::assertEquals(($result[1][0]['salary']/100000) | 2, $result[1]['salary_bit_or']); |
|
387 | - self::assertEquals(($result[2][0]['salary']/100000) | 2, $result[2]['salary_bit_or']); |
|
388 | - self::assertEquals(($result[3][0]['salary']/100000) | 2, $result[3]['salary_bit_or']); |
|
385 | + self::assertEquals(($result[0][0]['salary'] / 100000) | 2, $result[0]['salary_bit_or']); |
|
386 | + self::assertEquals(($result[1][0]['salary'] / 100000) | 2, $result[1]['salary_bit_or']); |
|
387 | + self::assertEquals(($result[2][0]['salary'] / 100000) | 2, $result[2]['salary_bit_or']); |
|
388 | + self::assertEquals(($result[3][0]['salary'] / 100000) | 2, $result[3]['salary_bit_or']); |
|
389 | 389 | } |
390 | 390 | |
391 | 391 | /** |
@@ -393,11 +393,11 @@ discard block |
||
393 | 393 | */ |
394 | 394 | public function testBitAndComparison() : void |
395 | 395 | { |
396 | - $dql = 'SELECT m, ' . |
|
397 | - 'BIT_AND(4, 2) AS bit_and,' . |
|
398 | - 'BIT_AND( (m.salary/100000) , 2 ) AS salary_bit_and ' . |
|
399 | - 'FROM Doctrine\Tests\Models\Company\CompanyManager m ' . |
|
400 | - 'ORDER BY ' . |
|
396 | + $dql = 'SELECT m, '. |
|
397 | + 'BIT_AND(4, 2) AS bit_and,'. |
|
398 | + 'BIT_AND( (m.salary/100000) , 2 ) AS salary_bit_and '. |
|
399 | + 'FROM Doctrine\Tests\Models\Company\CompanyManager m '. |
|
400 | + 'ORDER BY '. |
|
401 | 401 | 'm.id '; |
402 | 402 | $result = $this->em->createQuery($dql)->getArrayResult(); |
403 | 403 | |
@@ -406,10 +406,10 @@ discard block |
||
406 | 406 | self::assertEquals(4 & 2, $result[2]['bit_and']); |
407 | 407 | self::assertEquals(4 & 2, $result[3]['bit_and']); |
408 | 408 | |
409 | - self::assertEquals(($result[0][0]['salary']/100000) & 2, $result[0]['salary_bit_and']); |
|
410 | - self::assertEquals(($result[1][0]['salary']/100000) & 2, $result[1]['salary_bit_and']); |
|
411 | - self::assertEquals(($result[2][0]['salary']/100000) & 2, $result[2]['salary_bit_and']); |
|
412 | - self::assertEquals(($result[3][0]['salary']/100000) & 2, $result[3]['salary_bit_and']); |
|
409 | + self::assertEquals(($result[0][0]['salary'] / 100000) & 2, $result[0]['salary_bit_and']); |
|
410 | + self::assertEquals(($result[1][0]['salary'] / 100000) & 2, $result[1]['salary_bit_and']); |
|
411 | + self::assertEquals(($result[2][0]['salary'] / 100000) & 2, $result[2]['salary_bit_and']); |
|
412 | + self::assertEquals(($result[3][0]['salary'] / 100000) & 2, $result[3]['salary_bit_and']); |
|
413 | 413 | } |
414 | 414 | |
415 | 415 | protected function generateFixture() |
@@ -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 |
@@ -76,7 +76,7 @@ discard block |
||
76 | 76 | */ |
77 | 77 | public function testIndexByJoin() : void |
78 | 78 | { |
79 | - $dql = 'SELECT A, B FROM Doctrine\Tests\ORM\Functional\Ticket\DDC618Author A ' . |
|
79 | + $dql = 'SELECT A, B FROM Doctrine\Tests\ORM\Functional\Ticket\DDC618Author A '. |
|
80 | 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 | |
@@ -100,14 +100,14 @@ discard block |
||
100 | 100 | */ |
101 | 101 | public function testIndexByToOneJoinSilentlyIgnored() : void |
102 | 102 | { |
103 | - $dql = 'SELECT B, A FROM Doctrine\Tests\ORM\Functional\Ticket\DDC618Book B ' . |
|
103 | + $dql = 'SELECT B, A FROM Doctrine\Tests\ORM\Functional\Ticket\DDC618Book B '. |
|
104 | 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 | - $dql = 'SELECT B, A FROM Doctrine\Tests\ORM\Functional\Ticket\DDC618Book B ' . |
|
110 | + $dql = 'SELECT B, A FROM Doctrine\Tests\ORM\Functional\Ticket\DDC618Book B '. |
|
111 | 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 | |
@@ -119,7 +119,7 @@ discard block |
||
119 | 119 | */ |
120 | 120 | public function testCombineIndexBy() : void |
121 | 121 | { |
122 | - $dql = 'SELECT A, B FROM Doctrine\Tests\ORM\Functional\Ticket\DDC618Author A INDEX BY A.id ' . |
|
122 | + $dql = 'SELECT A, B FROM Doctrine\Tests\ORM\Functional\Ticket\DDC618Author A INDEX BY A.id '. |
|
123 | 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 |
@@ -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 |
@@ -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(); |
@@ -1043,7 +1043,7 @@ |
||
1043 | 1043 | { |
1044 | 1044 | $qb = $this->em->createQueryBuilder() |
1045 | 1045 | ->add('select', 'u') |
1046 | - ->add('from', CmsUser::class . ' u'); |
|
1046 | + ->add('from', CmsUser::class.' u'); |
|
1047 | 1047 | |
1048 | 1048 | self::assertEquals('SELECT u FROM Doctrine\Tests\Models\CMS\CmsUser u', $qb->getDQL()); |
1049 | 1049 | } |
@@ -92,7 +92,7 @@ |
||
92 | 92 | public function testCreateQueryBuilderAliasValid() : void |
93 | 93 | { |
94 | 94 | $q = $this->em->createQueryBuilder() |
95 | - ->select('u')->from(CmsUser::class, 'u'); |
|
95 | + ->select('u')->from(CmsUser::class, 'u'); |
|
96 | 96 | $q2 = clone $q; |
97 | 97 | |
98 | 98 | self::assertEquals('SELECT u FROM Doctrine\Tests\Models\CMS\CmsUser u', $q->getQuery()->getDql()); |
@@ -141,7 +141,7 @@ discard block |
||
141 | 141 | public function testThrowsExceptionOnNonObjectValues($methodName) : void |
142 | 142 | { |
143 | 143 | $this->expectException(ORMInvalidArgumentException::class); |
144 | - $this->expectExceptionMessage('EntityManager#' . $methodName . '() expects parameter 1 to be an entity object, NULL given.'); |
|
144 | + $this->expectExceptionMessage('EntityManager#'.$methodName.'() expects parameter 1 to be an entity object, NULL given.'); |
|
145 | 145 | |
146 | 146 | $this->em->{$methodName}(null); |
147 | 147 | } |
@@ -186,7 +186,7 @@ discard block |
||
186 | 186 | { |
187 | 187 | self::assertSame( |
188 | 188 | $value, |
189 | - $this->em->transactional(static function ($em) use ($value) { |
|
189 | + $this->em->transactional(static function($em) use ($value) { |
|
190 | 190 | return $value; |
191 | 191 | }) |
192 | 192 | ); |
@@ -219,8 +219,8 @@ discard block |
||
219 | 219 | public function testTransactionalReThrowsThrowables() : void |
220 | 220 | { |
221 | 221 | try { |
222 | - $this->em->transactional(static function () { |
|
223 | - (static function (array $value) { |
|
222 | + $this->em->transactional(static function() { |
|
223 | + (static function(array $value) { |
|
224 | 224 | // this only serves as an IIFE that throws a `TypeError` |
225 | 225 | })(null); |
226 | 226 | }); |
@@ -45,12 +45,12 @@ |
||
45 | 45 | |
46 | 46 | /** @var InverseSide $fetchedInverse */ |
47 | 47 | $fetchedInverse = $this->em->createQueryBuilder() |
48 | - ->select('inverse') |
|
49 | - ->from(InverseSide::class, 'inverse') |
|
50 | - ->andWhere('inverse.id = :id') |
|
51 | - ->setParameter('id', 'inverse') |
|
52 | - ->getQuery() |
|
53 | - ->getSingleResult(); |
|
48 | + ->select('inverse') |
|
49 | + ->from(InverseSide::class, 'inverse') |
|
50 | + ->andWhere('inverse.id = :id') |
|
51 | + ->setParameter('id', 'inverse') |
|
52 | + ->getQuery() |
|
53 | + ->getSingleResult(); |
|
54 | 54 | |
55 | 55 | self::assertInstanceOf(InverseSide::class, $fetchedInverse); |
56 | 56 | self::assertInstanceOf(OwningSide::class, $fetchedInverse->owning); |
@@ -29,8 +29,8 @@ |
||
29 | 29 | $user = new CmsUser(); |
30 | 30 | $user->id = $i; |
31 | 31 | $user->status = 'user'; |
32 | - $user->username = 'user' . $i; |
|
33 | - $user->name = 'Mr.Smith-' . $i; |
|
32 | + $user->username = 'user'.$i; |
|
33 | + $user->name = 'Mr.Smith-'.$i; |
|
34 | 34 | $this->users[] = $user; |
35 | 35 | |
36 | 36 | $this->unitOfWork->registerManaged( |
@@ -48,7 +48,7 @@ |
||
48 | 48 | 'u__status' => 'developer', |
49 | 49 | 'u__username' => 'jwage', |
50 | 50 | 'u__name' => 'Jonathan', |
51 | - 'sclr0' => 'JWAGE' . $i, |
|
51 | + 'sclr0' => 'JWAGE'.$i, |
|
52 | 52 | 'p__phonenumber' => '91', |
53 | 53 | 'a__id' => $i, |
54 | 54 | ]; |
@@ -39,8 +39,8 @@ discard block |
||
39 | 39 | for ($i = 1; $i <= 10000; ++$i) { |
40 | 40 | $user = new CMS\CmsUser(); |
41 | 41 | $user->status = 'user'; |
42 | - $user->username = 'user' . $i; |
|
43 | - $user->name = 'Mr.Smith-' . $i; |
|
42 | + $user->username = 'user'.$i; |
|
43 | + $user->name = 'Mr.Smith-'.$i; |
|
44 | 44 | |
45 | 45 | $this->users[$i] = $user; |
46 | 46 | } |
@@ -53,12 +53,12 @@ discard block |
||
53 | 53 | // Yes, this is a lot of overhead, but I have no better solution other than |
54 | 54 | // completely mocking out the DB, which would be silly (query impact is |
55 | 55 | // necessarily part of our benchmarks) |
56 | - $this->entityManager->getConnection()->executeQuery('DELETE FROM ' . $this->tableName)->execute(); |
|
56 | + $this->entityManager->getConnection()->executeQuery('DELETE FROM '.$this->tableName)->execute(); |
|
57 | 57 | |
58 | 58 | foreach ($this->users as $key => $user) { |
59 | 59 | $this->entityManager->persist($user); |
60 | 60 | |
61 | - if (! ($key % 20)) { |
|
61 | + if ( ! ($key % 20)) { |
|
62 | 62 | $this->entityManager->flush(); |
63 | 63 | $this->entityManager->clear(); |
64 | 64 | } |