@@ -135,13 +135,13 @@ |
||
135 | 135 | $cmf = new ClassMetadataFactory(); |
136 | 136 | $driver = $this->createMock(MappingDriver::class); |
137 | 137 | $driver->expects($this->at(0)) |
138 | - ->method('isTransient') |
|
139 | - ->with($this->equalTo(CmsUser::class)) |
|
140 | - ->will($this->returnValue(true)); |
|
138 | + ->method('isTransient') |
|
139 | + ->with($this->equalTo(CmsUser::class)) |
|
140 | + ->will($this->returnValue(true)); |
|
141 | 141 | $driver->expects($this->at(1)) |
142 | - ->method('isTransient') |
|
143 | - ->with($this->equalTo(CmsArticle::class)) |
|
144 | - ->will($this->returnValue(false)); |
|
142 | + ->method('isTransient') |
|
143 | + ->with($this->equalTo(CmsArticle::class)) |
|
144 | + ->will($this->returnValue(false)); |
|
145 | 145 | |
146 | 146 | $em = $this->createEntityManager($driver); |
147 | 147 |
@@ -114,9 +114,9 @@ discard block |
||
114 | 114 | |
115 | 115 | public function testHasGetMetadataNamespaceSeparatorIsNotNormalized() : void |
116 | 116 | { |
117 | - require_once __DIR__ . '/../../Models/Global/GlobalNamespaceModel.php'; |
|
117 | + require_once __DIR__.'/../../Models/Global/GlobalNamespaceModel.php'; |
|
118 | 118 | |
119 | - $metadataDriver = $this->createAnnotationDriver([__DIR__ . '/../../Models/Global/']); |
|
119 | + $metadataDriver = $this->createAnnotationDriver([__DIR__.'/../../Models/Global/']); |
|
120 | 120 | |
121 | 121 | $entityManager = $this->createEntityManager($metadataDriver); |
122 | 122 | |
@@ -124,10 +124,10 @@ discard block |
||
124 | 124 | |
125 | 125 | self::assertSame( |
126 | 126 | $mf->getMetadataFor(DoctrineGlobalArticle::class), |
127 | - $mf->getMetadataFor('\\' . DoctrineGlobalArticle::class) |
|
127 | + $mf->getMetadataFor('\\'.DoctrineGlobalArticle::class) |
|
128 | 128 | ); |
129 | 129 | self::assertTrue($mf->hasMetadataFor(DoctrineGlobalArticle::class)); |
130 | - self::assertTrue($mf->hasMetadataFor('\\' . DoctrineGlobalArticle::class)); |
|
130 | + self::assertTrue($mf->hasMetadataFor('\\'.DoctrineGlobalArticle::class)); |
|
131 | 131 | } |
132 | 132 | |
133 | 133 | /** |
@@ -155,7 +155,7 @@ discard block |
||
155 | 155 | public function testAddDefaultDiscriminatorMap() : void |
156 | 156 | { |
157 | 157 | $cmf = new ClassMetadataFactory(); |
158 | - $driver = $this->createAnnotationDriver([__DIR__ . '/../../Models/JoinedInheritanceType/']); |
|
158 | + $driver = $this->createAnnotationDriver([__DIR__.'/../../Models/JoinedInheritanceType/']); |
|
159 | 159 | $em = $this->createEntityManager($driver); |
160 | 160 | $cmf->setEntityManager($em); |
161 | 161 | |
@@ -219,10 +219,10 @@ discard block |
||
219 | 219 | $driverMock = new DriverMock(); |
220 | 220 | $config = new Configuration(); |
221 | 221 | |
222 | - $config->setProxyDir(__DIR__ . '/../../Proxies'); |
|
222 | + $config->setProxyDir(__DIR__.'/../../Proxies'); |
|
223 | 223 | $config->setProxyNamespace('Doctrine\Tests\Proxies'); |
224 | 224 | |
225 | - if (! $conn) { |
|
225 | + if ( ! $conn) { |
|
226 | 226 | $conn = new ConnectionMock([], $driverMock, $config, new EventManager()); |
227 | 227 | } |
228 | 228 | $eventManager = $conn->getEventManager(); |
@@ -312,7 +312,7 @@ discard block |
||
312 | 312 | public function testQuoteMetadata() : void |
313 | 313 | { |
314 | 314 | $cmf = new ClassMetadataFactory(); |
315 | - $driver = $this->createAnnotationDriver([__DIR__ . '/../../Models/Quote/']); |
|
315 | + $driver = $this->createAnnotationDriver([__DIR__.'/../../Models/Quote/']); |
|
316 | 316 | $em = $this->createEntityManager($driver); |
317 | 317 | $cmf->setEntityManager($em); |
318 | 318 | |
@@ -394,7 +394,7 @@ discard block |
||
394 | 394 | $listener |
395 | 395 | ->expects($this->any()) |
396 | 396 | ->method('onClassMetadataNotFound') |
397 | - ->will($this->returnCallback(function (OnClassMetadataNotFoundEventArgs $args) use ($metadata, $em, $test) { |
|
397 | + ->will($this->returnCallback(function(OnClassMetadataNotFoundEventArgs $args) use ($metadata, $em, $test) { |
|
398 | 398 | $test->assertNull($args->getFoundMetadata()); |
399 | 399 | $test->assertSame('Foo', $args->getClassName()); |
400 | 400 | $test->assertSame($em, $args->getObjectManager()); |
@@ -456,7 +456,7 @@ discard block |
||
456 | 456 | public function testInheritsIdGeneratorMappingFromEmbeddable() : void |
457 | 457 | { |
458 | 458 | $cmf = new ClassMetadataFactory(); |
459 | - $driver = $this->createAnnotationDriver([__DIR__ . '/../../Models/DDC4006/']); |
|
459 | + $driver = $this->createAnnotationDriver([__DIR__.'/../../Models/DDC4006/']); |
|
460 | 460 | $em = $this->createEntityManager($driver); |
461 | 461 | $cmf->setEntityManager($em); |
462 | 462 | |
@@ -479,7 +479,7 @@ discard block |
||
479 | 479 | ) : ClassMetadata { |
480 | 480 | $this->requestedClasses[] = $className; |
481 | 481 | |
482 | - if (! isset($this->mockMetadata[$className])) { |
|
482 | + if ( ! isset($this->mockMetadata[$className])) { |
|
483 | 483 | throw new \InvalidArgumentException(sprintf('No mock metadata found for class %s.', $className)); |
484 | 484 | } |
485 | 485 |
@@ -136,24 +136,24 @@ |
||
136 | 136 | ->will($this->returnValue(10)); |
137 | 137 | |
138 | 138 | $parserResultMock = $this->getMockBuilder(ParserResult::class) |
139 | - ->setMethods(['getSqlExecutor']) |
|
140 | - ->getMock(); |
|
139 | + ->setMethods(['getSqlExecutor']) |
|
140 | + ->getMock(); |
|
141 | 141 | $parserResultMock->expects($this->once()) |
142 | - ->method('getSqlExecutor') |
|
143 | - ->will($this->returnValue($sqlExecMock)); |
|
142 | + ->method('getSqlExecutor') |
|
143 | + ->will($this->returnValue($sqlExecMock)); |
|
144 | 144 | |
145 | 145 | $cache = $this->getMockBuilder(CacheProvider::class) |
146 | - ->setMethods(['doFetch', 'doContains', 'doSave', 'doDelete', 'doFlush', 'doGetStats']) |
|
147 | - ->getMock(); |
|
146 | + ->setMethods(['doFetch', 'doContains', 'doSave', 'doDelete', 'doFlush', 'doGetStats']) |
|
147 | + ->getMock(); |
|
148 | 148 | |
149 | 149 | $cache->expects($this->at(0))->method('doFetch')->will($this->returnValue(1)); |
150 | 150 | $cache->expects($this->at(1)) |
151 | - ->method('doFetch') |
|
152 | - ->with($this->isType('string')) |
|
153 | - ->will($this->returnValue($parserResultMock)); |
|
151 | + ->method('doFetch') |
|
152 | + ->with($this->isType('string')) |
|
153 | + ->will($this->returnValue($parserResultMock)); |
|
154 | 154 | |
155 | 155 | $cache->expects($this->never()) |
156 | - ->method('doSave'); |
|
156 | + ->method('doSave'); |
|
157 | 157 | |
158 | 158 | $query->setQueryCacheDriver($cache); |
159 | 159 |
@@ -27,9 +27,9 @@ |
||
27 | 27 | { |
28 | 28 | $qb = $this->em->createQueryBuilder(); |
29 | 29 | $qb->from(DDC1225TestEntity1::class, 'te1') |
30 | - ->select('te1') |
|
31 | - ->where('te1.testEntity2 = ?1') |
|
32 | - ->setParameter(1, 0); |
|
30 | + ->select('te1') |
|
31 | + ->where('te1.testEntity2 = ?1') |
|
32 | + ->setParameter(1, 0); |
|
33 | 33 | |
34 | 34 | self::assertSQLEquals( |
35 | 35 | 'SELECT t0."testentity2_id" AS c0 FROM "te1" t0 WHERE t0."testentity2_id" = ?', |
@@ -30,8 +30,8 @@ |
||
30 | 30 | public function testCmsModelSet(string $path) : void |
31 | 31 | { |
32 | 32 | $this->em->getConfiguration() |
33 | - ->getMetadataDriverImpl() |
|
34 | - ->addPaths([$path]); |
|
33 | + ->getMetadataDriverImpl() |
|
34 | + ->addPaths([$path]); |
|
35 | 35 | |
36 | 36 | self::assertEmpty($this->validator->validateMapping()); |
37 | 37 | } |
@@ -39,12 +39,12 @@ |
||
39 | 39 | public function modelSetProvider() : array |
40 | 40 | { |
41 | 41 | return [ |
42 | - 'cms' => [__DIR__ . '/../../Models/CMS'], |
|
43 | - 'company' => [__DIR__ . '/../../Models/Company'], |
|
44 | - 'ecommerce' => [__DIR__ . '/../../Models/ECommerce'], |
|
45 | - 'forum' => [__DIR__ . '/../../Models/Forum'], |
|
46 | - 'navigation' => [__DIR__ . '/../../Models/Navigation'], |
|
47 | - 'routing' => [__DIR__ . '/../../Models/Routing'], |
|
42 | + 'cms' => [__DIR__.'/../../Models/CMS'], |
|
43 | + 'company' => [__DIR__.'/../../Models/Company'], |
|
44 | + 'ecommerce' => [__DIR__.'/../../Models/ECommerce'], |
|
45 | + 'forum' => [__DIR__.'/../../Models/Forum'], |
|
46 | + 'navigation' => [__DIR__.'/../../Models/Navigation'], |
|
47 | + 'routing' => [__DIR__.'/../../Models/Routing'], |
|
48 | 48 | ]; |
49 | 49 | } |
50 | 50 |
@@ -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 | /** |
@@ -616,7 +616,7 @@ |
||
616 | 616 | public function testCanRetrieveRepositoryFromClassNameWithLeadingBackslash() : void |
617 | 617 | { |
618 | 618 | self::assertSame( |
619 | - $this->em->getRepository('\\' . CmsUser::class), |
|
619 | + $this->em->getRepository('\\'.CmsUser::class), |
|
620 | 620 | $this->em->getRepository(CmsUser::class) |
621 | 621 | ); |
622 | 622 | } |
@@ -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); |
@@ -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(); |
@@ -95,7 +95,7 @@ discard block |
||
95 | 95 | $this->em->flush(); |
96 | 96 | $this->em->clear(); |
97 | 97 | |
98 | - $query = $this->em->createQuery('select u, a from ' . CmsUser::class . ' u join u.articles a ORDER BY a.topic'); |
|
98 | + $query = $this->em->createQuery('select u, a from '.CmsUser::class.' u join u.articles a ORDER BY a.topic'); |
|
99 | 99 | $users = $query->getResult(); |
100 | 100 | |
101 | 101 | self::assertCount(1, $users); |
@@ -115,7 +115,7 @@ discard block |
||
115 | 115 | $this->em->flush(); |
116 | 116 | $this->em->clear(); |
117 | 117 | |
118 | - $q = $this->em->createQuery('SELECT u FROM ' . CmsUser::class . ' u WHERE u.username = ?0'); |
|
118 | + $q = $this->em->createQuery('SELECT u FROM '.CmsUser::class.' u WHERE u.username = ?0'); |
|
119 | 119 | $q->setParameter(0, 'jwage'); |
120 | 120 | $user = $q->getSingleResult(); |
121 | 121 | |
@@ -127,7 +127,7 @@ discard block |
||
127 | 127 | $this->expectException(QueryException::class); |
128 | 128 | $this->expectExceptionMessage('Invalid parameter: token 2 is not defined in the query.'); |
129 | 129 | |
130 | - $q = $this->em->createQuery('SELECT u FROM ' . CmsUser::class . ' u WHERE u.name = ?1'); |
|
130 | + $q = $this->em->createQuery('SELECT u FROM '.CmsUser::class.' u WHERE u.name = ?1'); |
|
131 | 131 | $q->setParameter(2, 'jwage'); |
132 | 132 | $user = $q->getSingleResult(); |
133 | 133 | } |
@@ -137,7 +137,7 @@ discard block |
||
137 | 137 | $this->expectException(QueryException::class); |
138 | 138 | $this->expectExceptionMessage('Too many parameters: the query defines 1 parameters and you bound 2'); |
139 | 139 | |
140 | - $q = $this->em->createQuery('SELECT u FROM ' . CmsUser::class . ' u WHERE u.name = ?1'); |
|
140 | + $q = $this->em->createQuery('SELECT u FROM '.CmsUser::class.' u WHERE u.name = ?1'); |
|
141 | 141 | $q->setParameter(1, 'jwage'); |
142 | 142 | $q->setParameter(2, 'jwage'); |
143 | 143 | |
@@ -149,7 +149,7 @@ discard block |
||
149 | 149 | $this->expectException(QueryException::class); |
150 | 150 | $this->expectExceptionMessage('Too few parameters: the query defines 1 parameters but you only bound 0'); |
151 | 151 | |
152 | - $this->em->createQuery('SELECT u FROM ' . CmsUser::class . ' u WHERE u.name = ?1') |
|
152 | + $this->em->createQuery('SELECT u FROM '.CmsUser::class.' u WHERE u.name = ?1') |
|
153 | 153 | ->getSingleResult(); |
154 | 154 | } |
155 | 155 | |
@@ -157,7 +157,7 @@ discard block |
||
157 | 157 | { |
158 | 158 | $this->expectException(QueryException::class); |
159 | 159 | |
160 | - $this->em->createQuery('SELECT u FROM ' . CmsUser::class . ' u WHERE u.name = ?') |
|
160 | + $this->em->createQuery('SELECT u FROM '.CmsUser::class.' u WHERE u.name = ?') |
|
161 | 161 | ->setParameter(1, 'jwage') |
162 | 162 | ->getSingleResult(); |
163 | 163 | } |
@@ -168,11 +168,11 @@ discard block |
||
168 | 168 | $parameters->add(new Parameter(1, 'jwage')); |
169 | 169 | $parameters->add(new Parameter(2, 'active')); |
170 | 170 | |
171 | - $this->em->createQuery('SELECT u FROM ' . CmsUser::class . ' u WHERE u.name = ?1 AND u.status = ?2') |
|
171 | + $this->em->createQuery('SELECT u FROM '.CmsUser::class.' u WHERE u.name = ?1 AND u.status = ?2') |
|
172 | 172 | ->setParameters($parameters) |
173 | 173 | ->getResult(); |
174 | 174 | |
175 | - $extractValue = function (Parameter $parameter) { |
|
175 | + $extractValue = function(Parameter $parameter) { |
|
176 | 176 | return $parameter->getValue(); |
177 | 177 | }; |
178 | 178 | |
@@ -186,7 +186,7 @@ discard block |
||
186 | 186 | { |
187 | 187 | $parameters = [1 => 'jwage', 2 => 'active']; |
188 | 188 | |
189 | - $this->em->createQuery('SELECT u FROM ' . CmsUser::class . ' u WHERE u.name = ?1 AND u.status = ?2') |
|
189 | + $this->em->createQuery('SELECT u FROM '.CmsUser::class.' u WHERE u.name = ?1 AND u.status = ?2') |
|
190 | 190 | ->setParameters($parameters) |
191 | 191 | ->getResult(); |
192 | 192 | |
@@ -216,7 +216,7 @@ discard block |
||
216 | 216 | $this->em->clear(); |
217 | 217 | $articleId = $article1->id; |
218 | 218 | |
219 | - $query = $this->em->createQuery('select a from ' . CmsArticle::class . ' a WHERE a.topic = ?1'); |
|
219 | + $query = $this->em->createQuery('select a from '.CmsArticle::class.' a WHERE a.topic = ?1'); |
|
220 | 220 | $articles = $query->iterate(new ArrayCollection([new Parameter(1, 'Doctrine 2')]), Query::HYDRATE_ARRAY); |
221 | 221 | |
222 | 222 | $found = []; |
@@ -257,7 +257,7 @@ discard block |
||
257 | 257 | $this->em->flush(); |
258 | 258 | $this->em->clear(); |
259 | 259 | |
260 | - $query = $this->em->createQuery('select a from ' . CmsArticle::class . ' a'); |
|
260 | + $query = $this->em->createQuery('select a from '.CmsArticle::class.' a'); |
|
261 | 261 | $articles = $query->iterate(); |
262 | 262 | |
263 | 263 | $iteratedCount = 0; |
@@ -379,8 +379,8 @@ discard block |
||
379 | 379 | { |
380 | 380 | for ($i = 0; $i < 5; $i++) { |
381 | 381 | $user = new CmsUser(); |
382 | - $user->name = 'Guilherme' . $i; |
|
383 | - $user->username = 'gblanco' . $i; |
|
382 | + $user->name = 'Guilherme'.$i; |
|
383 | + $user->username = 'gblanco'.$i; |
|
384 | 384 | $user->status = 'developer'; |
385 | 385 | $this->em->persist($user); |
386 | 386 | } |
@@ -388,7 +388,7 @@ discard block |
||
388 | 388 | $this->em->flush(); |
389 | 389 | $this->em->clear(); |
390 | 390 | |
391 | - $data = $this->em->createQuery('SELECT u FROM ' . CmsUser::class . ' u') |
|
391 | + $data = $this->em->createQuery('SELECT u FROM '.CmsUser::class.' u') |
|
392 | 392 | ->setFirstResult(1) |
393 | 393 | ->setMaxResults(2) |
394 | 394 | ->getResult(); |
@@ -397,7 +397,7 @@ discard block |
||
397 | 397 | self::assertEquals('gblanco1', $data[0]->username); |
398 | 398 | self::assertEquals('gblanco2', $data[1]->username); |
399 | 399 | |
400 | - $data = $this->em->createQuery('SELECT u FROM ' . CmsUser::class . ' u') |
|
400 | + $data = $this->em->createQuery('SELECT u FROM '.CmsUser::class.' u') |
|
401 | 401 | ->setFirstResult(3) |
402 | 402 | ->setMaxResults(2) |
403 | 403 | ->getResult(); |
@@ -406,7 +406,7 @@ discard block |
||
406 | 406 | self::assertEquals('gblanco3', $data[0]->username); |
407 | 407 | self::assertEquals('gblanco4', $data[1]->username); |
408 | 408 | |
409 | - $data = $this->em->createQuery('SELECT u FROM ' . CmsUser::class . ' u') |
|
409 | + $data = $this->em->createQuery('SELECT u FROM '.CmsUser::class.' u') |
|
410 | 410 | ->setFirstResult(3) |
411 | 411 | ->setMaxResults(2) |
412 | 412 | ->getScalarResult(); |
@@ -462,7 +462,7 @@ discard block |
||
462 | 462 | $author = new CmsUser(); |
463 | 463 | |
464 | 464 | $author->name = 'anonymous'; |
465 | - $author->username = 'anon' . $i; |
|
465 | + $author->username = 'anon'.$i; |
|
466 | 466 | $author->status = 'here'; |
467 | 467 | $article->user = $author; |
468 | 468 | |
@@ -498,13 +498,13 @@ discard block |
||
498 | 498 | $this->em->flush(); |
499 | 499 | $this->em->clear(); |
500 | 500 | |
501 | - $query = $this->em->createQuery('select u from ' . CmsUser::class . " u where u.username = 'gblanco'"); |
|
501 | + $query = $this->em->createQuery('select u from '.CmsUser::class." u where u.username = 'gblanco'"); |
|
502 | 502 | $fetchedUser = $query->getOneOrNullResult(); |
503 | 503 | |
504 | 504 | self::assertInstanceOf(CmsUser::class, $fetchedUser); |
505 | 505 | self::assertEquals('gblanco', $fetchedUser->username); |
506 | 506 | |
507 | - $query = $this->em->createQuery('select u.username from ' . CmsUser::class . " u where u.username = 'gblanco'"); |
|
507 | + $query = $this->em->createQuery('select u.username from '.CmsUser::class." u where u.username = 'gblanco'"); |
|
508 | 508 | $fetchedUsername = $query->getOneOrNullResult(Query::HYDRATE_SINGLE_SCALAR); |
509 | 509 | |
510 | 510 | self::assertEquals('gblanco', $fetchedUsername); |
@@ -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); |
@@ -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() |
@@ -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 |