View GitHub Repository orm

Schedule Inspection
Subscribe
Passed
Pull Request — master (#7648)
by Ahmed M.
09:27
created
Status
Category
Toggle Patches
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/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   +22 added lines, -22 removed lines patch added patch discarded remove patch 
@@ -102,7 +102,7 @@  discard block
 
 block discarded – undo
102 102
103 103 
     public function testFunctionLocate() : void
104 104 
     {
105 
-        $dql = "SELECT m, LOCATE('e', LOWER(m.name)) AS loc, LOCATE('e', LOWER(m.name), 7) AS loc2 " .
105 
+        $dql = "SELECT m, LOCATE('e', LOWER(m.name)) AS loc, LOCATE('e', LOWER(m.name), 7) AS loc2 ".
106 106 
                'FROM Doctrine\Tests\Models\Company\CompanyManager m ORDER BY m.salary ASC';
107 107
108 108 
         $result = $this->em->createQuery($dql)
 
@@ -169,7 +169,7 @@  discard block
 
 block discarded – undo
169 169
170 170 
     public function testFunctionSubstring() : void
171 171 
     {
172 
-        $dql = 'SELECT m, SUBSTRING(m.name, 1, 3) AS str1, SUBSTRING(m.name, 5) AS str2 ' .
172 
+        $dql = 'SELECT m, SUBSTRING(m.name, 1, 3) AS str1, SUBSTRING(m.name, 5) AS str2 '.
173 173 
                 'FROM Doctrine\Tests\Models\Company\CompanyManager m ORDER BY m.name';
174 174
175 175 
         $result = $this->em->createQuery($dql)
 
@@ -189,8 +189,8 @@  discard block
 
 block discarded – undo
189 189
190 190 
     public function testFunctionTrim() : void
191 191 
     {
192 
-        $dql = "SELECT m, TRIM(TRAILING '.' FROM m.name) AS str1, " .
193 
-               " TRIM(LEADING '.' FROM m.name) AS str2, TRIM(CONCAT(' ', CONCAT(m.name, ' '))) AS str3 " .
192 
+        $dql = "SELECT m, TRIM(TRAILING '.' FROM m.name) AS str1, ".
193 
+               " TRIM(LEADING '.' FROM m.name) AS str2, TRIM(CONCAT(' ', CONCAT(m.name, ' '))) AS str3 ".
194 194 
                'FROM Doctrine\Tests\Models\Company\CompanyManager m ORDER BY m.salary ASC';
195 195
196 196 
         $result = $this->em->createQuery($dql)->getArrayResult();
 
@@ -369,11 +369,11 @@  discard block
 
 block discarded – undo
369 369 
      */
370 370 
     public function testBitOrComparison() : void
371 371 
     {
372 
-        $dql    = 'SELECT m, ' .
373 
-                    'BIT_OR(4, 2) AS bit_or,' .
374 
-                    'BIT_OR( (m.salary/100000) , 2 ) AS salary_bit_or ' .
375 
-                    'FROM Doctrine\Tests\Models\Company\CompanyManager m ' .
376 
-                'ORDER BY ' .
372 
+        $dql = 'SELECT m, '.
373 
+                    'BIT_OR(4, 2) AS bit_or,'.
374 
+                    'BIT_OR( (m.salary/100000) , 2 ) AS salary_bit_or '.
375 
+                    'FROM Doctrine\Tests\Models\Company\CompanyManager m '.
376 
+                'ORDER BY '.
377 377 
                     'm.id ';
378 378 
         $result = $this->em->createQuery($dql)->getArrayResult();
379 379 
 
@@ -382,10 +382,10 @@  discard block
 
 block discarded – undo
382 382 
         self::assertEquals(4 | 2, $result[2]['bit_or']);
383 383 
         self::assertEquals(4 | 2, $result[3]['bit_or']);
384 384
385 
-        self::assertEquals(($result[0][0]['salary']/100000) | 2, $result[0]['salary_bit_or']);
386 
-        self::assertEquals(($result[1][0]['salary']/100000) | 2, $result[1]['salary_bit_or']);
387 
-        self::assertEquals(($result[2][0]['salary']/100000) | 2, $result[2]['salary_bit_or']);
388 
-        self::assertEquals(($result[3][0]['salary']/100000) | 2, $result[3]['salary_bit_or']);
385 
+        self::assertEquals(($result[0][0]['salary'] / 100000) | 2, $result[0]['salary_bit_or']);
386 
+        self::assertEquals(($result[1][0]['salary'] / 100000) | 2, $result[1]['salary_bit_or']);
387 
+        self::assertEquals(($result[2][0]['salary'] / 100000) | 2, $result[2]['salary_bit_or']);
388 
+        self::assertEquals(($result[3][0]['salary'] / 100000) | 2, $result[3]['salary_bit_or']);
389 389 
     }
390 390
391 391 
     /**
 
@@ -393,11 +393,11 @@  discard block
 
 block discarded – undo
393 393 
      */
394 394 
     public function testBitAndComparison() : void
395 395 
     {
396 
-        $dql    = 'SELECT m, ' .
397 
-                    'BIT_AND(4, 2) AS bit_and,' .
398 
-                    'BIT_AND( (m.salary/100000) , 2 ) AS salary_bit_and ' .
399 
-                    'FROM Doctrine\Tests\Models\Company\CompanyManager m ' .
400 
-                'ORDER BY ' .
396 
+        $dql = 'SELECT m, '.
397 
+                    'BIT_AND(4, 2) AS bit_and,'.
398 
+                    'BIT_AND( (m.salary/100000) , 2 ) AS salary_bit_and '.
399 
+                    'FROM Doctrine\Tests\Models\Company\CompanyManager m '.
400 
+                'ORDER BY '.
401 401 
                     'm.id ';
402 402 
         $result = $this->em->createQuery($dql)->getArrayResult();
403 403 
 
@@ -406,10 +406,10 @@  discard block
 
 block discarded – undo
406 406 
         self::assertEquals(4 & 2, $result[2]['bit_and']);
407 407 
         self::assertEquals(4 & 2, $result[3]['bit_and']);
408 408
409 
-        self::assertEquals(($result[0][0]['salary']/100000) & 2, $result[0]['salary_bit_and']);
410 
-        self::assertEquals(($result[1][0]['salary']/100000) & 2, $result[1]['salary_bit_and']);
411 
-        self::assertEquals(($result[2][0]['salary']/100000) & 2, $result[2]['salary_bit_and']);
412 
-        self::assertEquals(($result[3][0]['salary']/100000) & 2, $result[3]['salary_bit_and']);
409 
+        self::assertEquals(($result[0][0]['salary'] / 100000) & 2, $result[0]['salary_bit_and']);
410 
+        self::assertEquals(($result[1][0]['salary'] / 100000) & 2, $result[1]['salary_bit_and']);
411 
+        self::assertEquals(($result[2][0]['salary'] / 100000) & 2, $result[2]['salary_bit_and']);
412 
+        self::assertEquals(($result[3][0]['salary'] / 100000) & 2, $result[3]['salary_bit_and']);
413 413 
     }
414 414
415 415 
     protected function generateFixture()
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.
tests/Doctrine/Tests/ORM/Functional/Ticket/DDC2692Test.php 1 patch
Indentation   +2 added lines, -2 removed lines patch added patch discarded remove patch 
@@ -37,8 +37,8 @@
 
 block discarded – undo
37 37 
     public function testIsListenerCalledOnlyOnceOnPreFlush() : void
38 38 
     {
39 39 
         $listener = $this->getMockBuilder(DDC2692Listener::class)
40 
-                         ->setMethods(['preFlush'])
41 
-                         ->getMock();
40 
+                            ->setMethods(['preFlush'])
41 
+                            ->getMock();
42 42
43 43 
         $listener->expects($this->once())->method('preFlush');
44 44
Please login to merge, or discard this patch.
tests/Doctrine/Tests/ORM/QueryBuilderTest.php 2 patches
Indentation   +37 added lines, -37 removed lines patch added patch discarded remove patch 
@@ -272,12 +272,12 @@  discard block
 
 block discarded – undo
272 272 
     {
273 273 
         $qb = $this->em->createQueryBuilder();
274 274 
         $qb->select('u')
275 
-           ->from(CmsUser::class, 'u')
276 
-           ->where('u.id = :uid')
277 
-           ->orWhere('u.id = :uid2')
278 
-           ->andWhere('u.id = :uid3')
279 
-           ->orWhere('u.name = :name1', 'u.name = :name2')
280 
-           ->andWhere('u.name <> :noname');
275 
+            ->from(CmsUser::class, 'u')
276 
+            ->where('u.id = :uid')
277 
+            ->orWhere('u.id = :uid2')
278 
+            ->andWhere('u.id = :uid3')
279 
+            ->orWhere('u.name = :name1', 'u.name = :name2')
280 
+            ->andWhere('u.name <> :noname');
281 281
282 282 
         self::assertValidQueryBuilder($qb, 'SELECT u FROM Doctrine\Tests\Models\CMS\CmsUser u WHERE (((u.id = :uid OR u.id = :uid2) AND u.id = :uid3) OR u.name = :name1 OR u.name = :name2) AND u.name <> :noname');
283 283 
     }
 
@@ -286,9 +286,9 @@  discard block
 
 block discarded – undo
286 286 
     {
287 287 
         $qb = $this->em->createQueryBuilder();
288 288 
         $qb->select('u')
289 
-           ->from(CmsUser::class, 'u')
290 
-           ->where('u.id = :uid')
291 
-           ->andWhere($qb->expr()->in('u.id', [1, 2, 3]));
289 
+            ->from(CmsUser::class, 'u')
290 
+            ->where('u.id = :uid')
291 
+            ->andWhere($qb->expr()->in('u.id', [1, 2, 3]));
292 292
293 293 
         self::assertValidQueryBuilder($qb, 'SELECT u FROM Doctrine\Tests\Models\CMS\CmsUser u WHERE u.id = :uid AND u.id IN(1, 2, 3)');
294 294 
     }
 
@@ -297,9 +297,9 @@  discard block
 
 block discarded – undo
297 297 
     {
298 298 
         $qb = $this->em->createQueryBuilder();
299 299 
         $qb->select('u')
300 
-           ->from(CmsUser::class, 'u')
301 
-           ->where('u.id = :uid')
302 
-           ->orWhere($qb->expr()->in('u.id', [1, 2, 3]));
300 
+            ->from(CmsUser::class, 'u')
301 
+            ->where('u.id = :uid')
302 
+            ->orWhere($qb->expr()->in('u.id', [1, 2, 3]));
303 303
304 304 
         self::assertValidQueryBuilder($qb, 'SELECT u FROM Doctrine\Tests\Models\CMS\CmsUser u WHERE u.id = :uid OR u.id IN(1, 2, 3)');
305 305 
     }
 
@@ -308,9 +308,9 @@  discard block
 
 block discarded – undo
308 308 
     {
309 309 
         $qb = $this->em->createQueryBuilder();
310 310 
         $qb->select('u')
311 
-           ->from(CmsUser::class, 'u')
312 
-           ->where('u.id = :uid')
313 
-           ->andWhere($qb->expr()->notIn('u.id', [1, 2, 3]));
311 
+            ->from(CmsUser::class, 'u')
312 
+            ->where('u.id = :uid')
313 
+            ->andWhere($qb->expr()->notIn('u.id', [1, 2, 3]));
314 314
315 315 
         self::assertValidQueryBuilder($qb, 'SELECT u FROM Doctrine\Tests\Models\CMS\CmsUser u WHERE u.id = :uid AND u.id NOT IN(1, 2, 3)');
316 316 
     }
 
@@ -319,9 +319,9 @@  discard block
 
 block discarded – undo
319 319 
     {
320 320 
         $qb = $this->em->createQueryBuilder();
321 321 
         $qb->select('u')
322 
-           ->from(CmsUser::class, 'u')
323 
-           ->where('u.id = :uid')
324 
-           ->orWhere($qb->expr()->notIn('u.id', [1, 2, 3]));
322 
+            ->from(CmsUser::class, 'u')
323 
+            ->where('u.id = :uid')
324 
+            ->orWhere($qb->expr()->notIn('u.id', [1, 2, 3]));
325 325
326 326 
         self::assertValidQueryBuilder($qb, 'SELECT u FROM Doctrine\Tests\Models\CMS\CmsUser u WHERE u.id = :uid OR u.id NOT IN(1, 2, 3)');
327 327 
     }
 
@@ -617,8 +617,8 @@  discard block
 
 block discarded – undo
617 617 
     {
618 618 
         $qb = $this->em->createQueryBuilder();
619 619 
         $qb->select('u')
620 
-           ->from(CmsUser::class, 'u')
621 
-           ->where($qb->expr()->orX('u.username = :username', 'u.username = :username2'));
620 
+            ->from(CmsUser::class, 'u')
621 
+            ->where($qb->expr()->orX('u.username = :username', 'u.username = :username2'));
622 622
623 623 
         $parameters = new ArrayCollection();
624 624 
         $parameters->add(new Parameter('username', 'jwage'));
 
@@ -634,8 +634,8 @@  discard block
 
 block discarded – undo
634 634 
     {
635 635 
         $qb = $this->em->createQueryBuilder();
636 636 
         $qb->select('u')
637 
-           ->from(CmsUser::class, 'u')
638 
-           ->where('u.id = :id');
637 
+            ->from(CmsUser::class, 'u')
638 
+            ->where('u.id = :id');
639 639
640 640 
         $parameters = new ArrayCollection();
641 641 
         $parameters->add(new Parameter('id', 1));
 
@@ -684,8 +684,8 @@  discard block
 
 block discarded – undo
684 684 
     {
685 685 
         $qb = $this->em->createQueryBuilder();
686 686 
         $qb->select('u')
687 
-           ->from(CmsUser::class, 'u')
688 
-           ->orWhere('u.id = :uid', $qb->expr()->eq('u.id', ':uid2'));
687 
+            ->from(CmsUser::class, 'u')
688 
+            ->orWhere('u.id = :uid', $qb->expr()->eq('u.id', ':uid2'));
689 689
690 690 
         self::assertValidQueryBuilder($qb, 'SELECT u FROM Doctrine\Tests\Models\CMS\CmsUser u WHERE u.id = :uid OR u.id = :uid2');
691 691 
     }
 
@@ -698,8 +698,8 @@  discard block
 
 block discarded – undo
698 698 
         $orExpr->add($qb->expr()->in('u.id', [1]));
699 699
700 700 
         $qb->select('u')
701 
-           ->from(CmsUser::class, 'u')
702 
-           ->where($orExpr);
701 
+            ->from(CmsUser::class, 'u')
702 
+            ->where($orExpr);
703 703
704 704 
         self::assertValidQueryBuilder($qb, 'SELECT u FROM Doctrine\Tests\Models\CMS\CmsUser u WHERE u.id = :uid3 OR u.id IN(1)');
705 705 
     }
 
@@ -708,8 +708,8 @@  discard block
 
 block discarded – undo
708 708 
     {
709 709 
         $qb = $this->em->createQueryBuilder();
710 710 
         $qb->select('u')
711 
-           ->from(CmsUser::class, 'u')
712 
-           ->where($qb->expr()->in('u.name', ['one', 'two', 'three']));
711 
+            ->from(CmsUser::class, 'u')
712 
+            ->where($qb->expr()->in('u.name', ['one', 'two', 'three']));
713 713
714 714 
         self::assertValidQueryBuilder($qb, "SELECT u FROM Doctrine\Tests\Models\CMS\CmsUser u WHERE u.name IN('one', 'two', 'three')");
715 715 
 
@@ -723,8 +723,8 @@  discard block
 
 block discarded – undo
723 723 
         $qb   = $this->em->createQueryBuilder();
724 724 
         $expr = $this->em->getExpressionBuilder();
725 725 
         $qb->select('u')
726 
-           ->from(CmsUser::class, 'u')
727 
-           ->where($expr->in('u.name', [$expr->literal('one'), $expr->literal('two'), $expr->literal('three')]));
726 
+            ->from(CmsUser::class, 'u')
727 
+            ->where($expr->in('u.name', [$expr->literal('one'), $expr->literal('two'), $expr->literal('three')]));
728 728
729 729 
         self::assertValidQueryBuilder($qb, "SELECT u FROM Doctrine\Tests\Models\CMS\CmsUser u WHERE u.name IN('one', 'two', 'three')");
730 730 
 
@@ -742,8 +742,8 @@  discard block
 
 block discarded – undo
742 742
743 743 
         $qb = $this->em->createQueryBuilder();
744 744 
         $qb->select('u')
745 
-           ->from(CmsUser::class, 'u')
746 
-           ->where($orExpr);
745 
+            ->from(CmsUser::class, 'u')
746 
+            ->where($orExpr);
747 747
748 748 
         self::assertValidQueryBuilder($qb, 'SELECT u FROM Doctrine\Tests\Models\CMS\CmsUser u WHERE u.id = :uid3 OR NOT(u.id IN(1))');
749 749 
     }
 
@@ -754,8 +754,8 @@  discard block
 
 block discarded – undo
754 754 
         $expr = $this->em->getExpressionBuilder();
755 755
756 756 
         $qb->select('u')
757 
-           ->from(CmsUser::class, 'u')
758 
-           ->where($expr->gt('u.id', $expr->all('select a.id from Doctrine\Tests\Models\CMS\CmsArticle a')));
757 
+            ->from(CmsUser::class, 'u')
758 
+            ->where($expr->gt('u.id', $expr->all('select a.id from Doctrine\Tests\Models\CMS\CmsArticle a')));
759 759
760 760 
         self::assertValidQueryBuilder($qb, 'SELECT u FROM Doctrine\Tests\Models\CMS\CmsUser u WHERE u.id > ALL(select a.id from Doctrine\Tests\Models\CMS\CmsArticle a)');
761 761 
     }
 
@@ -1120,9 +1120,9 @@  discard block
 
 block discarded – undo
1120 1120 
     public function testRebuildsFromParts() : void
1121 1121 
     {
1122 1122 
         $qb = $this->em->createQueryBuilder()
1123 
-          ->select('u')
1124 
-          ->from(CmsUser::class, 'u')
1125 
-          ->join('u.article', 'a');
1123 
+            ->select('u')
1124 
+            ->from(CmsUser::class, 'u')
1125 
+            ->join('u.article', 'a');
1126 1126
1127 1127 
         $dqlParts = $qb->getDQLParts();
1128 1128 
         $dql      = $qb->getDQL();
Please login to merge, or discard this patch.
Spacing   +1 added lines, -1 removed lines patch added patch discarded remove patch 
@@ -1043,7 +1043,7 @@
 
 block discarded – undo
1043 1043 
     {
1044 1044 
         $qb = $this->em->createQueryBuilder()
1045 1045 
             ->add('select', 'u')
1046 
-            ->add('from', CmsUser::class . ' u');
1046 
+            ->add('from', CmsUser::class.' u');
1047 1047
1048 1048 
         self::assertEquals('SELECT u FROM Doctrine\Tests\Models\CMS\CmsUser u', $qb->getDQL());
1049 1049 
     }
Please login to merge, or discard this patch.
tests/Doctrine/Tests/ORM/EntityManagerTest.php 2 patches
Indentation   +1 added lines, -1 removed lines patch added patch discarded remove patch 
@@ -92,7 +92,7 @@
 
 block discarded – undo
92 92 
     public function testCreateQueryBuilderAliasValid() : void
93 93 
     {
94 94 
         $q  = $this->em->createQueryBuilder()
95 
-             ->select('u')->from(CmsUser::class, 'u');
95 
+                ->select('u')->from(CmsUser::class, 'u');
96 96 
         $q2 = clone $q;
97 97
98 98 
         self::assertEquals('SELECT u FROM Doctrine\Tests\Models\CMS\CmsUser u', $q->getQuery()->getDql());
Please login to merge, or discard this patch.
Spacing   +4 added lines, -4 removed lines patch added patch discarded remove patch 
@@ -141,7 +141,7 @@  discard block
 
 block discarded – undo
141 141 
     public function testThrowsExceptionOnNonObjectValues($methodName) : void
142 142 
     {
143 143 
         $this->expectException(ORMInvalidArgumentException::class);
144 
-        $this->expectExceptionMessage('EntityManager#' . $methodName . '() expects parameter 1 to be an entity object, NULL given.');
144 
+        $this->expectExceptionMessage('EntityManager#'.$methodName.'() expects parameter 1 to be an entity object, NULL given.');
145 145
146 146 
         $this->em->{$methodName}(null);
147 147 
     }
 
@@ -186,7 +186,7 @@  discard block
 
 block discarded – undo
186 186 
     {
187 187 
         self::assertSame(
188 188 
             $value,
189 
-            $this->em->transactional(static function ($em) use ($value) {
189 
+            $this->em->transactional(static function($em) use ($value) {
190 190 
                 return $value;
191 191 
             })
192 192 
         );
 
@@ -219,8 +219,8 @@  discard block
 
 block discarded – undo
219 219 
     public function testTransactionalReThrowsThrowables() : void
220 220 
     {
221 221 
         try {
222 
-            $this->em->transactional(static function () {
223 
-                (static function (array $value) {
222 
+            $this->em->transactional(static function() {
223 
+                (static function(array $value) {
224 224 
                     // this only serves as an IIFE that throws a `TypeError`
225 225 
                 })(null);
226 226 
             });
Please login to merge, or discard this patch.
Doctrine/Tests/ORM/Functional/OneToOneInverseSideLoadAfterDqlQueryTest.php 1 patch
Indentation   +6 added lines, -6 removed lines patch added patch discarded remove patch 
@@ -45,12 +45,12 @@
 
 block discarded – undo
45 45
46 46 
         /** @var InverseSide $fetchedInverse */
47 47 
         $fetchedInverse = $this->em->createQueryBuilder()
48 
-                                   ->select('inverse')
49 
-                                   ->from(InverseSide::class, 'inverse')
50 
-                                   ->andWhere('inverse.id = :id')
51 
-                                   ->setParameter('id', 'inverse')
52 
-                                   ->getQuery()
53 
-                                   ->getSingleResult();
48 
+                                    ->select('inverse')
49 
+                                    ->from(InverseSide::class, 'inverse')
50 
+                                    ->andWhere('inverse.id = :id')
51 
+                                    ->setParameter('id', 'inverse')
52 
+                                    ->getQuery()
53 
+                                    ->getSingleResult();
54 54
55 55 
         self::assertInstanceOf(InverseSide::class, $fetchedInverse);
56 56 
         self::assertInstanceOf(OwningSide::class, $fetchedInverse->owning);
Please login to merge, or discard this patch.
tests/Doctrine/Performance/EntityManagerFactory.php 1 patch
Spacing   +3 added lines, -3 removed lines patch added patch discarded remove patch 
@@ -19,13 +19,13 @@
 
 block discarded – undo
19 19 
     {
20 20 
         $config = new Configuration();
21 21
22 
-        $config->setProxyDir(__DIR__ . '/../Tests/Proxies');
22 
+        $config->setProxyDir(__DIR__.'/../Tests/Proxies');
23 23 
         $config->setProxyNamespace('Doctrine\Tests\Proxies');
24 24 
         $config->setAutoGenerateProxyClasses(StaticProxyFactory::AUTOGENERATE_EVAL);
25 25 
         $config->setMetadataDriverImpl(
26 26 
             $config->newDefaultAnnotationDriver([
27 
-                realpath(__DIR__ . '/Models/Cache'),
28 
-                realpath(__DIR__ . '/Models/GeoNames'),
27 
+                realpath(__DIR__.'/Models/Cache'),
28 
+                realpath(__DIR__.'/Models/GeoNames'),
29 29 
             ])
30 30 
         );
31 31
Please login to merge, or discard this patch.
tests/Doctrine/Performance/ChangeSet/UnitOfWorkComputeChangesBench.php 1 patch
Spacing   +2 added lines, -2 removed lines patch added patch discarded remove patch 
@@ -29,8 +29,8 @@
 
 block discarded – undo
29 29 
             $user           = new CmsUser();
30 30 
             $user->id       = $i;
31 31 
             $user->status   = 'user';
32 
-            $user->username = 'user' . $i;
33 
-            $user->name     = 'Mr.Smith-' . $i;
32 
+            $user->username = 'user'.$i;
33 
+            $user->name     = 'Mr.Smith-'.$i;
34 34 
             $this->users[]  = $user;
35 35
36 36 
             $this->unitOfWork->registerManaged(
Please login to merge, or discard this patch.