Completed
Push — master ( f4c848...d31188 )
by Jonathan
24s queued 17s
created
tests/Doctrine/Tests/ORM/Mapping/ClassMetadataFactoryTest.php 2 patches
Indentation   +6 added lines, -6 removed lines patch added patch discarded remove patch
@@ -135,13 +135,13 @@
 block discarded – undo
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
 
Please login to merge, or discard this patch.
Spacing   +11 added lines, -11 removed lines patch added patch discarded remove patch
@@ -114,9 +114,9 @@  discard block
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 
Please login to merge, or discard this patch.
tests/Doctrine/Tests/ORM/Functional/QueryCacheTest.php 1 patch
Indentation   +10 added lines, -10 removed lines patch added patch discarded remove patch
@@ -136,24 +136,24 @@
 block discarded – undo
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
 
Please login to merge, or discard this patch.
tests/Doctrine/Tests/ORM/Functional/Ticket/DDC1225Test.php 1 patch
Indentation   +3 added lines, -3 removed lines patch added patch discarded remove patch
@@ -27,9 +27,9 @@
 block discarded – undo
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" = ?',
Please login to merge, or discard this patch.
tests/Doctrine/Tests/ORM/Tools/SchemaValidatorTest.php 2 patches
Indentation   +2 added lines, -2 removed lines patch added patch discarded remove patch
@@ -30,8 +30,8 @@
 block discarded – undo
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
     }
Please login to merge, or discard this patch.
Spacing   +6 added lines, -6 removed lines patch added patch discarded remove patch
@@ -39,12 +39,12 @@
 block discarded – undo
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
 
Please login to merge, or discard this patch.
tests/Doctrine/Tests/ORM/Functional/EntityRepositoryTest.php 2 patches
Indentation   +5 added lines, -5 removed lines patch added patch discarded remove patch
@@ -283,7 +283,7 @@  discard block
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
     /**
Please login to merge, or discard this patch.
Spacing   +1 added lines, -1 removed lines patch added patch discarded remove patch
@@ -616,7 +616,7 @@
 block discarded – undo
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
     }
Please login to merge, or discard this patch.
tests/Doctrine/Tests/ORM/Functional/AdvancedDqlQueryTest.php 2 patches
Indentation   +11 added lines, -11 removed lines patch added patch discarded remove patch
@@ -26,8 +26,8 @@  discard block
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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);
Please login to merge, or discard this patch.
Spacing   +11 added lines, -11 removed lines patch added patch discarded remove patch
@@ -25,8 +25,8 @@  discard block
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 
Please login to merge, or discard this patch.
tests/Doctrine/Tests/ORM/Functional/QueryTest.php 2 patches
Indentation   +22 added lines, -22 removed lines patch added patch discarded remove patch
@@ -150,7 +150,7 @@  discard block
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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();
Please login to merge, or discard this patch.
Spacing   +19 added lines, -19 removed lines patch added patch discarded remove patch
@@ -95,7 +95,7 @@  discard block
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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);
Please login to merge, or discard this patch.
tests/Doctrine/Tests/ORM/Functional/QueryDqlFunctionTest.php 2 patches
Indentation   +19 added lines, -19 removed lines patch added patch discarded remove patch
@@ -26,7 +26,7 @@  discard block
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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);
Please login to merge, or discard this patch.
Spacing   +24 added lines, -24 removed lines patch added patch discarded remove patch
@@ -101,7 +101,7 @@  discard block
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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()
Please login to merge, or discard this patch.
tests/Doctrine/Tests/ORM/Functional/Ticket/DDC618Test.php 2 patches
Indentation   +4 added lines, -4 removed lines patch added patch discarded remove patch
@@ -77,7 +77,7 @@  discard block
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
Please login to merge, or discard this patch.
Spacing   +4 added lines, -4 removed lines patch added patch discarded remove patch
@@ -76,7 +76,7 @@  discard block
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 
Please login to merge, or discard this patch.