@@ -268,8 +268,8 @@ |
||
268 | 268 | $this->em->clear(); |
269 | 269 | |
270 | 270 | $newUser = $this->em->createQuery('SELECT u, g FROM Doctrine\Tests\Models\CMS\CmsUser u LEFT JOIN u.groups g WHERE u.id = ?1') |
271 | - ->setParameter(1, $user->getId()) |
|
272 | - ->getSingleResult(); |
|
271 | + ->setParameter(1, $user->getId()) |
|
272 | + ->getSingleResult(); |
|
273 | 273 | self::assertCount(0, $newUser->groups); |
274 | 274 | self::assertInstanceOf(ManyToManyAssociationMetadata::class, $newUser->groups->getMapping()); |
275 | 275 |
@@ -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 | |
@@ -361,8 +361,8 @@ discard block |
||
361 | 361 | } |
362 | 362 | |
363 | 363 | /** |
364 | - * @group DDC-1213 |
|
365 | - */ |
|
364 | + * @group DDC-1213 |
|
365 | + */ |
|
366 | 366 | public function testBitAndComparison() |
367 | 367 | { |
368 | 368 | $dql = 'SELECT m, ' . |
@@ -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()); |
@@ -75,7 +75,7 @@ discard block |
||
75 | 75 | public function testIndexByJoin() |
76 | 76 | { |
77 | 77 | $dql = 'SELECT A, B FROM Doctrine\Tests\ORM\Functional\Ticket\DDC618Author A '. |
78 | - 'INNER JOIN A.books B INDEX BY B.title ORDER BY A.name ASC'; |
|
78 | + 'INNER JOIN A.books B INDEX BY B.title ORDER BY A.name ASC'; |
|
79 | 79 | $result = $this->em->createQuery($dql)->getResult(\Doctrine\ORM\Query::HYDRATE_OBJECT); |
80 | 80 | |
81 | 81 | self::assertCount(3, $result[0]->books); // Alice, Joe doesn't appear because he has no books. |
@@ -99,14 +99,14 @@ discard block |
||
99 | 99 | public function testIndexByToOneJoinSilentlyIgnored() |
100 | 100 | { |
101 | 101 | $dql = 'SELECT B, A FROM Doctrine\Tests\ORM\Functional\Ticket\DDC618Book B '. |
102 | - 'INNER JOIN B.author A INDEX BY A.name ORDER BY A.name ASC'; |
|
102 | + 'INNER JOIN B.author A INDEX BY A.name ORDER BY A.name ASC'; |
|
103 | 103 | $result = $this->em->createQuery($dql)->getResult(\Doctrine\ORM\Query::HYDRATE_OBJECT); |
104 | 104 | |
105 | 105 | self::assertInstanceOf(DDC618Book::class, $result[0]); |
106 | 106 | self::assertInstanceOf(DDC618Author::class, $result[0]->author); |
107 | 107 | |
108 | 108 | $dql = 'SELECT B, A FROM Doctrine\Tests\ORM\Functional\Ticket\DDC618Book B '. |
109 | - 'INNER JOIN B.author A INDEX BY A.name ORDER BY A.name ASC'; |
|
109 | + 'INNER JOIN B.author A INDEX BY A.name ORDER BY A.name ASC'; |
|
110 | 110 | $result = $this->em->createQuery($dql)->getResult(\Doctrine\ORM\Query::HYDRATE_ARRAY); |
111 | 111 | |
112 | 112 | self::assertEquals("Alice", $result[0]['author']['name']); |
@@ -118,7 +118,7 @@ discard block |
||
118 | 118 | public function testCombineIndexBy() |
119 | 119 | { |
120 | 120 | $dql = 'SELECT A, B FROM Doctrine\Tests\ORM\Functional\Ticket\DDC618Author A INDEX BY A.id '. |
121 | - 'INNER JOIN A.books B INDEX BY B.title ORDER BY A.name ASC'; |
|
121 | + 'INNER JOIN A.books B INDEX BY B.title ORDER BY A.name ASC'; |
|
122 | 122 | $result = $this->em->createQuery($dql)->getResult(\Doctrine\ORM\Query::HYDRATE_OBJECT); |
123 | 123 | |
124 | 124 | self::assertArrayHasKey(11, $result); // Alice |
@@ -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() |
@@ -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() |
@@ -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() |
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() |
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() |
@@ -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 | public function testSupportsQueriesWithEntityNamespaces() |
@@ -637,9 +637,9 @@ discard block |
||
637 | 637 | { |
638 | 638 | $qb = $this->em->createQueryBuilder(); |
639 | 639 | $qb->select('u') |
640 | - ->from(CmsUser::class, 'u') |
|
641 | - ->innerJoin('u.articles', 'a') |
|
642 | - ->where('(u.id = 0) OR (u.id IS NULL)'); |
|
640 | + ->from(CmsUser::class, 'u') |
|
641 | + ->innerJoin('u.articles', 'a') |
|
642 | + ->where('(u.id = 0) OR (u.id IS NULL)'); |
|
643 | 643 | |
644 | 644 | $query = $qb->getQuery(); |
645 | 645 | $users = $query->execute(); |
@@ -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 | } |
@@ -28,8 +28,8 @@ discard block |
||
28 | 28 | public function testAggregateWithHavingClause() |
29 | 29 | { |
30 | 30 | $dql = 'SELECT p.department, AVG(p.salary) AS avgSalary '. |
31 | - 'FROM Doctrine\Tests\Models\Company\CompanyEmployee p '. |
|
32 | - 'GROUP BY p.department HAVING SUM(p.salary) > 200000 ORDER BY p.department'; |
|
31 | + 'FROM Doctrine\Tests\Models\Company\CompanyEmployee p '. |
|
32 | + 'GROUP BY p.department HAVING SUM(p.salary) > 200000 ORDER BY p.department'; |
|
33 | 33 | |
34 | 34 | $result = $this->em->createQuery($dql)->getScalarResult(); |
35 | 35 | |
@@ -43,8 +43,8 @@ discard block |
||
43 | 43 | public function testUnnamedScalarResultsAreOneBased() |
44 | 44 | { |
45 | 45 | $dql = 'SELECT p.department, AVG(p.salary) '. |
46 | - 'FROM Doctrine\Tests\Models\Company\CompanyEmployee p '. |
|
47 | - 'GROUP BY p.department HAVING SUM(p.salary) > 200000 ORDER BY p.department'; |
|
46 | + 'FROM Doctrine\Tests\Models\Company\CompanyEmployee p '. |
|
47 | + 'GROUP BY p.department HAVING SUM(p.salary) > 200000 ORDER BY p.department'; |
|
48 | 48 | |
49 | 49 | $result = $this->em->createQuery($dql)->getScalarResult(); |
50 | 50 | |
@@ -56,9 +56,9 @@ discard block |
||
56 | 56 | public function testOrderByResultVariableCollectionSize() |
57 | 57 | { |
58 | 58 | $dql = 'SELECT p.name, size(p.friends) AS friends ' . |
59 | - 'FROM Doctrine\Tests\Models\Company\CompanyPerson p ' . |
|
60 | - 'WHERE p.friends IS NOT EMPTY ' . |
|
61 | - 'ORDER BY friends DESC, p.name DESC'; |
|
59 | + 'FROM Doctrine\Tests\Models\Company\CompanyPerson p ' . |
|
60 | + 'WHERE p.friends IS NOT EMPTY ' . |
|
61 | + 'ORDER BY friends DESC, p.name DESC'; |
|
62 | 62 | |
63 | 63 | $result = $this->em->createQuery($dql)->getScalarResult(); |
64 | 64 | |
@@ -80,7 +80,7 @@ discard block |
||
80 | 80 | public function testIsNullAssociation() |
81 | 81 | { |
82 | 82 | $dql = 'SELECT p FROM Doctrine\Tests\Models\Company\CompanyPerson p '. |
83 | - 'WHERE p.spouse IS NULL'; |
|
83 | + 'WHERE p.spouse IS NULL'; |
|
84 | 84 | $result = $this->em->createQuery($dql)->getResult(); |
85 | 85 | |
86 | 86 | self::assertCount(2, $result); |
@@ -94,7 +94,7 @@ discard block |
||
94 | 94 | public function testSelectSubselect() |
95 | 95 | { |
96 | 96 | $dql = 'SELECT p, (SELECT c.brand FROM Doctrine\Tests\Models\Company\CompanyCar c WHERE p.car = c) brandName '. |
97 | - 'FROM Doctrine\Tests\Models\Company\CompanyManager p'; |
|
97 | + 'FROM Doctrine\Tests\Models\Company\CompanyManager p'; |
|
98 | 98 | $result = $this->em->createQuery($dql)->getArrayResult(); |
99 | 99 | |
100 | 100 | self::assertCount(1, $result); |
@@ -104,7 +104,7 @@ discard block |
||
104 | 104 | public function testInSubselect() |
105 | 105 | { |
106 | 106 | $dql = "SELECT p.name FROM Doctrine\Tests\Models\Company\CompanyPerson p ". |
107 | - "WHERE p.name IN (SELECT n.name FROM Doctrine\Tests\Models\Company\CompanyPerson n WHERE n.name = 'Roman B.')"; |
|
107 | + "WHERE p.name IN (SELECT n.name FROM Doctrine\Tests\Models\Company\CompanyPerson n WHERE n.name = 'Roman B.')"; |
|
108 | 108 | $result = $this->em->createQuery($dql)->getScalarResult(); |
109 | 109 | |
110 | 110 | self::assertCount(1, $result); |
@@ -114,7 +114,7 @@ discard block |
||
114 | 114 | public function testGroupByMultipleFields() |
115 | 115 | { |
116 | 116 | $dql = 'SELECT p.department, p.name, count(p.id) FROM Doctrine\Tests\Models\Company\CompanyEmployee p '. |
117 | - 'GROUP BY p.department, p.name'; |
|
117 | + 'GROUP BY p.department, p.name'; |
|
118 | 118 | $result = $this->em->createQuery($dql)->getResult(); |
119 | 119 | |
120 | 120 | self::assertCount(4, $result); |