@@ -148,9 +148,9 @@ discard block |
||
148 | 148 | |
149 | 149 | $dql = "DELETE Doctrine\Tests\Models\DDC117\DDC117Reference r WHERE r.source = ?1 AND r.target = ?2"; |
150 | 150 | $this->_em->createQuery($dql) |
151 | - ->setParameter(1, $this->article1->id()) |
|
152 | - ->setParameter(2, $this->article2->id()) |
|
153 | - ->execute(); |
|
151 | + ->setParameter(1, $this->article1->id()) |
|
152 | + ->setParameter(2, $this->article2->id()) |
|
153 | + ->execute(); |
|
154 | 154 | |
155 | 155 | self::assertNull($this->_em->find(DDC117Reference::class, $idCriteria)); |
156 | 156 | } |
@@ -200,9 +200,9 @@ discard block |
||
200 | 200 | |
201 | 201 | $dql = 'SELECT t, a FROM Doctrine\Tests\Models\DDC117\DDC117Translation t JOIN t.article a WHERE t.article = ?1 AND t.language = ?2'; |
202 | 202 | $dqlTrans = $this->_em->createQuery($dql) |
203 | - ->setParameter(1, $this->article1->id()) |
|
204 | - ->setParameter(2, 'en') |
|
205 | - ->getSingleResult(); |
|
203 | + ->setParameter(1, $this->article1->id()) |
|
204 | + ->setParameter(2, 'en') |
|
205 | + ->getSingleResult(); |
|
206 | 206 | |
207 | 207 | self::assertInstanceOf(DDC117Translation::class, $this->translation); |
208 | 208 | } |
@@ -367,11 +367,11 @@ discard block |
||
367 | 367 | $this->_em->clear(); |
368 | 368 | |
369 | 369 | $dql = "SELECT t, e FROM Doctrine\Tests\Models\DDC117\DDC117Translation t ". |
370 | - "JOIN t.reviewedByEditors e WHERE t.article = ?1 AND t.language = ?2"; |
|
370 | + "JOIN t.reviewedByEditors e WHERE t.article = ?1 AND t.language = ?2"; |
|
371 | 371 | $trans = $this->_em->createQuery($dql) |
372 | - ->setParameter(1, $this->translation->getArticleId()) |
|
373 | - ->setParameter(2, $this->translation->getLanguage()) |
|
374 | - ->getSingleResult(); |
|
372 | + ->setParameter(1, $this->translation->getArticleId()) |
|
373 | + ->setParameter(2, $this->translation->getLanguage()) |
|
374 | + ->getSingleResult(); |
|
375 | 375 | |
376 | 376 | self::assertInstanceOf(DDC117Translation::class, $trans); |
377 | 377 | self::assertContainsOnly(DDC117Editor::class, $trans->reviewedByEditors); |
@@ -64,7 +64,7 @@ discard block |
||
64 | 64 | |
65 | 65 | $this->_em->clear(); |
66 | 66 | |
67 | - $dql = 'SELECT r, s FROM ' . DDC117Reference::class . ' r JOIN r.source s WHERE r.source = ?1'; |
|
67 | + $dql = 'SELECT r, s FROM '.DDC117Reference::class.' r JOIN r.source s WHERE r.source = ?1'; |
|
68 | 68 | $dqlRef = $this->_em->createQuery($dql)->setParameter(1, 1)->getSingleResult(); |
69 | 69 | |
70 | 70 | self::assertInstanceOf(DDC117Reference::class, $mapRef); |
@@ -74,7 +74,7 @@ discard block |
||
74 | 74 | |
75 | 75 | $this->_em->clear(); |
76 | 76 | |
77 | - $dql = 'SELECT r, s FROM ' . DDC117Reference::class . ' r JOIN r.source s WHERE s.title = ?1'; |
|
77 | + $dql = 'SELECT r, s FROM '.DDC117Reference::class.' r JOIN r.source s WHERE s.title = ?1'; |
|
78 | 78 | $dqlRef = $this->_em->createQuery($dql)->setParameter(1, 'Foo')->getSingleResult(); |
79 | 79 | |
80 | 80 | self::assertInstanceOf(DDC117Reference::class, $dqlRef); |
@@ -82,7 +82,7 @@ discard block |
||
82 | 82 | self::assertInstanceOf(DDC117Article::class, $dqlRef->source()); |
83 | 83 | self::assertSame($dqlRef, $this->_em->find(DDC117Reference::class, $idCriteria)); |
84 | 84 | |
85 | - $dql = 'SELECT r, s FROM ' . DDC117Reference::class . ' r JOIN r.source s WHERE s.title = ?1'; |
|
85 | + $dql = 'SELECT r, s FROM '.DDC117Reference::class.' r JOIN r.source s WHERE s.title = ?1'; |
|
86 | 86 | $dqlRef = $this->_em->createQuery($dql)->setParameter(1, 'Foo')->getSingleResult(); |
87 | 87 | |
88 | 88 | $this->_em->contains($dqlRef); |
@@ -220,7 +220,7 @@ discard block |
||
220 | 220 | try { |
221 | 221 | // exception depending on the underlying Database Driver |
222 | 222 | $this->_em->flush(); |
223 | - } catch(\Exception $e) { |
|
223 | + } catch (\Exception $e) { |
|
224 | 224 | $exceptionThrown = true; |
225 | 225 | } |
226 | 226 |
@@ -53,7 +53,7 @@ |
||
53 | 53 | $this->_em->flush(); |
54 | 54 | $this->_em->clear(); |
55 | 55 | |
56 | - $dql = "SELECT a, b, ba, c FROM " . __NAMESPACE__ . "\DDC1514EntityA AS a LEFT JOIN a.entitiesB AS b LEFT JOIN b.entityATo AS ba LEFT JOIN a.entityC AS c ORDER BY a.title"; |
|
56 | + $dql = "SELECT a, b, ba, c FROM ".__NAMESPACE__."\DDC1514EntityA AS a LEFT JOIN a.entitiesB AS b LEFT JOIN b.entityATo AS ba LEFT JOIN a.entityC AS c ORDER BY a.title"; |
|
57 | 57 | $results = $this->_em->createQuery($dql)->getResult(); |
58 | 58 | |
59 | 59 | self::assertEquals($a1->id, $results[0]->id); |
@@ -27,7 +27,7 @@ discard block |
||
27 | 27 | $this->_em->getClassMetadata(DDC3027Dog::class), |
28 | 28 | ] |
29 | 29 | ); |
30 | - } catch(\Exception $e) { |
|
30 | + } catch (\Exception $e) { |
|
31 | 31 | } |
32 | 32 | } |
33 | 33 | |
@@ -82,7 +82,7 @@ discard block |
||
82 | 82 | self::assertEquals('United States of America', $person->address->country->name); |
83 | 83 | |
84 | 84 | // 4. check deleting works |
85 | - $personId = $person->id;; |
|
85 | + $personId = $person->id; ; |
|
86 | 86 | $this->_em->remove($person); |
87 | 87 | $this->_em->flush(); |
88 | 88 | |
@@ -106,7 +106,7 @@ discard block |
||
106 | 106 | $this->_em->flush(); |
107 | 107 | $this->_em->clear(); |
108 | 108 | |
109 | - $dql = "SELECT p FROM " . __NAMESPACE__ . "\DDC93Person p"; |
|
109 | + $dql = "SELECT p FROM ".__NAMESPACE__."\DDC93Person p"; |
|
110 | 110 | $persons = $this->_em->createQuery($dql)->getResult(); |
111 | 111 | |
112 | 112 | self::assertCount(3, $persons); |
@@ -119,7 +119,7 @@ discard block |
||
119 | 119 | self::assertEquals('United States of America', $person->address->country->name); |
120 | 120 | } |
121 | 121 | |
122 | - $dql = "SELECT p FROM " . __NAMESPACE__ . "\DDC93Person p"; |
|
122 | + $dql = "SELECT p FROM ".__NAMESPACE__."\DDC93Person p"; |
|
123 | 123 | $persons = $this->_em->createQuery($dql)->getArrayResult(); |
124 | 124 | |
125 | 125 | foreach ($persons as $person) { |
@@ -144,7 +144,7 @@ discard block |
||
144 | 144 | $this->_em->flush($person); |
145 | 145 | |
146 | 146 | // SELECT |
147 | - $selectDql = "SELECT p FROM " . __NAMESPACE__ ."\\DDC93Person p WHERE p.address.city = :city AND p.address.country.name = :country"; |
|
147 | + $selectDql = "SELECT p FROM ".__NAMESPACE__."\\DDC93Person p WHERE p.address.city = :city AND p.address.country.name = :country"; |
|
148 | 148 | $loadedPerson = $this->_em->createQuery($selectDql) |
149 | 149 | ->setParameter('city', 'Karlsruhe') |
150 | 150 | ->setParameter('country', 'Germany') |
@@ -159,7 +159,7 @@ discard block |
||
159 | 159 | ); |
160 | 160 | |
161 | 161 | // UPDATE |
162 | - $updateDql = "UPDATE " . __NAMESPACE__ . "\\DDC93Person p SET p.address.street = :street, p.address.country.name = :country WHERE p.address.city = :city"; |
|
162 | + $updateDql = "UPDATE ".__NAMESPACE__."\\DDC93Person p SET p.address.street = :street, p.address.country.name = :country WHERE p.address.city = :city"; |
|
163 | 163 | $this->_em->createQuery($updateDql) |
164 | 164 | ->setParameter('street', 'Boo') |
165 | 165 | ->setParameter('country', 'DE') |
@@ -171,7 +171,7 @@ discard block |
||
171 | 171 | self::assertEquals('DE', $person->address->country->name); |
172 | 172 | |
173 | 173 | // DELETE |
174 | - $this->_em->createQuery("DELETE " . __NAMESPACE__ . "\\DDC93Person p WHERE p.address.city = :city AND p.address.country.name = :country") |
|
174 | + $this->_em->createQuery("DELETE ".__NAMESPACE__."\\DDC93Person p WHERE p.address.city = :city AND p.address.country.name = :country") |
|
175 | 175 | ->setParameter('city', 'Karlsruhe') |
176 | 176 | ->setParameter('country', 'DE') |
177 | 177 | ->execute(); |
@@ -188,7 +188,7 @@ discard block |
||
188 | 188 | $this->_em->clear(); |
189 | 189 | |
190 | 190 | // Prove that the entity was persisted correctly. |
191 | - $dql = "SELECT p FROM " . __NAMESPACE__ ."\\DDC93Person p WHERE p.name = :name"; |
|
191 | + $dql = "SELECT p FROM ".__NAMESPACE__."\\DDC93Person p WHERE p.name = :name"; |
|
192 | 192 | |
193 | 193 | $person = $this->_em->createQuery($dql) |
194 | 194 | ->setParameter('name', 'Karl') |
@@ -202,7 +202,7 @@ discard block |
||
202 | 202 | // Clear the EM and prove that the embeddable can be the subject of a partial query. |
203 | 203 | $this->_em->clear(); |
204 | 204 | |
205 | - $dql = "SELECT PARTIAL p.{id,address.city} FROM " . __NAMESPACE__ ."\\DDC93Person p WHERE p.name = :name"; |
|
205 | + $dql = "SELECT PARTIAL p.{id,address.city} FROM ".__NAMESPACE__."\\DDC93Person p WHERE p.name = :name"; |
|
206 | 206 | |
207 | 207 | $person = $this->_em->createQuery($dql) |
208 | 208 | ->setParameter('name', 'Karl') |
@@ -218,7 +218,7 @@ discard block |
||
218 | 218 | // Clear the EM and prove that the embeddable can be the subject of a partial query regardless of attributes positions. |
219 | 219 | $this->_em->clear(); |
220 | 220 | |
221 | - $dql = "SELECT PARTIAL p.{address.city, id} FROM " . __NAMESPACE__ ."\\DDC93Person p WHERE p.name = :name"; |
|
221 | + $dql = "SELECT PARTIAL p.{address.city, id} FROM ".__NAMESPACE__."\\DDC93Person p WHERE p.name = :name"; |
|
222 | 222 | |
223 | 223 | $person = $this->_em->createQuery($dql) |
224 | 224 | ->setParameter('name', 'Karl') |
@@ -237,7 +237,7 @@ discard block |
||
237 | 237 | $this->expectException(QueryException::class); |
238 | 238 | $this->expectExceptionMessage('no field or association named address.asdfasdf'); |
239 | 239 | |
240 | - $this->_em->createQuery("SELECT p FROM " . __NAMESPACE__ . "\\DDC93Person p WHERE p.address.asdfasdf IS NULL") |
|
240 | + $this->_em->createQuery("SELECT p FROM ".__NAMESPACE__."\\DDC93Person p WHERE p.address.asdfasdf IS NULL") |
|
241 | 241 | ->execute(); |
242 | 242 | } |
243 | 243 | |
@@ -246,7 +246,7 @@ discard block |
||
246 | 246 | $this->expectException(QueryException::class); |
247 | 247 | $this->expectExceptionMessage("no mapped field named 'address.asdfasdf'"); |
248 | 248 | |
249 | - $this->_em->createQuery("SELECT PARTIAL p.{id,address.asdfasdf} FROM " . __NAMESPACE__ . "\\DDC93Person p") |
|
249 | + $this->_em->createQuery("SELECT PARTIAL p.{id,address.asdfasdf} FROM ".__NAMESPACE__."\\DDC93Person p") |
|
250 | 250 | ->execute(); |
251 | 251 | } |
252 | 252 | |
@@ -308,15 +308,15 @@ discard block |
||
308 | 308 | $this->expectException(MappingException::class); |
309 | 309 | $this->expectExceptionMessage( |
310 | 310 | sprintf( |
311 | - 'Infinite nesting detected for embedded property %s::nested. ' . |
|
311 | + 'Infinite nesting detected for embedded property %s::nested. '. |
|
312 | 312 | 'You cannot embed an embeddable from the same type inside an embeddable.', |
313 | - __NAMESPACE__ . '\\' . $declaredEmbeddableClassName |
|
313 | + __NAMESPACE__.'\\'.$declaredEmbeddableClassName |
|
314 | 314 | ) |
315 | 315 | ); |
316 | 316 | |
317 | 317 | $this->_schemaTool->createSchema( |
318 | 318 | [ |
319 | - $this->_em->getClassMetadata(__NAMESPACE__ . '\\' . $embeddableClassName), |
|
319 | + $this->_em->getClassMetadata(__NAMESPACE__.'\\'.$embeddableClassName), |
|
320 | 320 | ] |
321 | 321 | ); |
322 | 322 | } |
@@ -34,7 +34,7 @@ discard block |
||
34 | 34 | */ |
35 | 35 | private function registerType(string $className) |
36 | 36 | { |
37 | - $type = constant($className . '::NAME'); |
|
37 | + $type = constant($className.'::NAME'); |
|
38 | 38 | |
39 | 39 | if (DBALType::hasType($type)) { |
40 | 40 | DBALType::overrideType($type, $className); |
@@ -70,7 +70,7 @@ discard block |
||
70 | 70 | foreach ($classes as $class) { |
71 | 71 | $ce = $validator->validateClass($class); |
72 | 72 | |
73 | - self::assertEmpty($ce, "Invalid Modelset: " . $modelSet . " class " . $class->name . ": ". implode("\n", $ce)); |
|
73 | + self::assertEmpty($ce, "Invalid Modelset: ".$modelSet." class ".$class->name.": ".implode("\n", $ce)); |
|
74 | 74 | } |
75 | 75 | } |
76 | 76 | } |
@@ -214,7 +214,7 @@ |
||
214 | 214 | self::assertNull($this->cache->getEntityCacheRegion(ComplexAction::class)); |
215 | 215 | self::assertInstanceOf(Region::class, $this->cache->getEntityCacheRegion(Token::class)); |
216 | 216 | |
217 | - $token = new Token('token-hash'); |
|
217 | + $token = new Token('token-hash'); |
|
218 | 218 | |
219 | 219 | $action1 = new Action('login'); |
220 | 220 | $action2 = new Action('logout'); |
@@ -102,8 +102,8 @@ |
||
102 | 102 | $routeId = $this->createPersistedRouteWithLegs(); |
103 | 103 | |
104 | 104 | $route = $this->_em->createQuery("SELECT r, l FROM Doctrine\Tests\Models\Routing\RoutingRoute r JOIN r.legs l WHERE r.id = ?1") |
105 | - ->setParameter(1, $routeId) |
|
106 | - ->getSingleResult(); |
|
105 | + ->setParameter(1, $routeId) |
|
106 | + ->getSingleResult(); |
|
107 | 107 | |
108 | 108 | self::assertEquals(2, count($route->legs)); |
109 | 109 | self::assertEquals("Berlin", $route->legs[0]->fromLocation->getName()); |
@@ -232,8 +232,8 @@ discard block |
||
232 | 232 | $eventManager->addEventListener([Events::postLoad], $listener); |
233 | 233 | |
234 | 234 | $this->_em->find(CmsUser::class, $this->userId); |
235 | - self::assertSame(1, $listener->countHandledEvents(CmsUser::class), CmsUser::class . ' should be handled once!'); |
|
236 | - self::assertSame(1, $listener->countHandledEvents(CmsEmail::class), CmsEmail::class . ' should be handled once!'); |
|
235 | + self::assertSame(1, $listener->countHandledEvents(CmsUser::class), CmsUser::class.' should be handled once!'); |
|
236 | + self::assertSame(1, $listener->countHandledEvents(CmsEmail::class), CmsEmail::class.' should be handled once!'); |
|
237 | 237 | } |
238 | 238 | |
239 | 239 | private function loadFixture() |
@@ -309,7 +309,7 @@ discard block |
||
309 | 309 | { |
310 | 310 | $object = $event->getObject(); |
311 | 311 | $class = ClassUtils::getClass($object); |
312 | - if (!isset($this->firedByClasses[$class])) { |
|
312 | + if ( ! isset($this->firedByClasses[$class])) { |
|
313 | 313 | $this->firedByClasses[$class] = 1; |
314 | 314 | } else { |
315 | 315 | $this->firedByClasses[$class]++; |
@@ -23,7 +23,7 @@ discard block |
||
23 | 23 | public function testAggregateSum() |
24 | 24 | { |
25 | 25 | $salarySum = $this->_em->createQuery('SELECT SUM(m.salary) AS salary FROM Doctrine\Tests\Models\Company\CompanyManager m') |
26 | - ->getSingleResult(); |
|
26 | + ->getSingleResult(); |
|
27 | 27 | |
28 | 28 | self::assertEquals(1500000, $salarySum['salary']); |
29 | 29 | } |
@@ -31,7 +31,7 @@ discard block |
||
31 | 31 | public function testAggregateAvg() |
32 | 32 | { |
33 | 33 | $salaryAvg = $this->_em->createQuery('SELECT AVG(m.salary) AS salary FROM Doctrine\Tests\Models\Company\CompanyManager m') |
34 | - ->getSingleResult(); |
|
34 | + ->getSingleResult(); |
|
35 | 35 | |
36 | 36 | self::assertEquals(375000, round($salaryAvg['salary'], 0)); |
37 | 37 | } |
@@ -39,7 +39,7 @@ discard block |
||
39 | 39 | public function testAggregateMin() |
40 | 40 | { |
41 | 41 | $salary = $this->_em->createQuery('SELECT MIN(m.salary) AS salary FROM Doctrine\Tests\Models\Company\CompanyManager m') |
42 | - ->getSingleResult(); |
|
42 | + ->getSingleResult(); |
|
43 | 43 | |
44 | 44 | self::assertEquals(100000, $salary['salary']); |
45 | 45 | } |
@@ -47,7 +47,7 @@ discard block |
||
47 | 47 | public function testAggregateMax() |
48 | 48 | { |
49 | 49 | $salary = $this->_em->createQuery('SELECT MAX(m.salary) AS salary FROM Doctrine\Tests\Models\Company\CompanyManager m') |
50 | - ->getSingleResult(); |
|
50 | + ->getSingleResult(); |
|
51 | 51 | |
52 | 52 | self::assertEquals(800000, $salary['salary']); |
53 | 53 | } |
@@ -55,7 +55,7 @@ discard block |
||
55 | 55 | public function testAggregateCount() |
56 | 56 | { |
57 | 57 | $managerCount = $this->_em->createQuery('SELECT COUNT(m.id) AS managers FROM Doctrine\Tests\Models\Company\CompanyManager m') |
58 | - ->getSingleResult(); |
|
58 | + ->getSingleResult(); |
|
59 | 59 | |
60 | 60 | self::assertEquals(4, $managerCount['managers']); |
61 | 61 | } |
@@ -63,7 +63,7 @@ discard block |
||
63 | 63 | public function testFunctionAbs() |
64 | 64 | { |
65 | 65 | $result = $this->_em->createQuery('SELECT m, ABS(m.salary * -1) AS abs FROM Doctrine\Tests\Models\Company\CompanyManager m ORDER BY m.salary ASC') |
66 | - ->getResult(); |
|
66 | + ->getResult(); |
|
67 | 67 | |
68 | 68 | self::assertEquals(4, count($result)); |
69 | 69 | self::assertEquals(100000, $result[0]['abs']); |
@@ -75,7 +75,7 @@ discard block |
||
75 | 75 | public function testFunctionConcat() |
76 | 76 | { |
77 | 77 | $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') |
78 | - ->getArrayResult(); |
|
78 | + ->getArrayResult(); |
|
79 | 79 | |
80 | 80 | self::assertEquals(4, count($arg)); |
81 | 81 | self::assertEquals('Roman B.IT', $arg[0]['namedep']); |
@@ -87,7 +87,7 @@ discard block |
||
87 | 87 | public function testFunctionLength() |
88 | 88 | { |
89 | 89 | $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') |
90 | - ->getArrayResult(); |
|
90 | + ->getArrayResult(); |
|
91 | 91 | |
92 | 92 | self::assertEquals(4, count($result)); |
93 | 93 | self::assertEquals(10, $result[0]['namedeplength']); |
@@ -99,10 +99,10 @@ discard block |
||
99 | 99 | public function testFunctionLocate() |
100 | 100 | { |
101 | 101 | $dql = "SELECT m, LOCATE('e', LOWER(m.name)) AS loc, LOCATE('e', LOWER(m.name), 7) AS loc2 ". |
102 | - "FROM Doctrine\Tests\Models\Company\CompanyManager m ORDER BY m.salary ASC"; |
|
102 | + "FROM Doctrine\Tests\Models\Company\CompanyManager m ORDER BY m.salary ASC"; |
|
103 | 103 | |
104 | 104 | $result = $this->_em->createQuery($dql) |
105 | - ->getArrayResult(); |
|
105 | + ->getArrayResult(); |
|
106 | 106 | |
107 | 107 | self::assertEquals(4, count($result)); |
108 | 108 | self::assertEquals(0, $result[0]['loc']); |
@@ -118,7 +118,7 @@ discard block |
||
118 | 118 | public function testFunctionLower() |
119 | 119 | { |
120 | 120 | $result = $this->_em->createQuery("SELECT m, LOWER(m.name) AS lowername FROM Doctrine\Tests\Models\Company\CompanyManager m ORDER BY m.salary ASC") |
121 | - ->getArrayResult(); |
|
121 | + ->getArrayResult(); |
|
122 | 122 | |
123 | 123 | self::assertEquals(4, count($result)); |
124 | 124 | self::assertEquals('roman b.', $result[0]['lowername']); |
@@ -130,7 +130,7 @@ discard block |
||
130 | 130 | public function testFunctionMod() |
131 | 131 | { |
132 | 132 | $result = $this->_em->createQuery("SELECT m, MOD(m.salary, 3500) AS amod FROM Doctrine\Tests\Models\Company\CompanyManager m ORDER BY m.salary ASC") |
133 | - ->getArrayResult(); |
|
133 | + ->getArrayResult(); |
|
134 | 134 | |
135 | 135 | self::assertEquals(4, count($result)); |
136 | 136 | self::assertEquals(2000, $result[0]['amod']); |
@@ -142,7 +142,7 @@ discard block |
||
142 | 142 | public function testFunctionSqrt() |
143 | 143 | { |
144 | 144 | $result = $this->_em->createQuery("SELECT m, SQRT(m.salary) AS sqrtsalary FROM Doctrine\Tests\Models\Company\CompanyManager m ORDER BY m.salary ASC") |
145 | - ->getArrayResult(); |
|
145 | + ->getArrayResult(); |
|
146 | 146 | |
147 | 147 | self::assertEquals(4, count($result)); |
148 | 148 | self::assertEquals(316, round($result[0]['sqrtsalary'])); |
@@ -154,7 +154,7 @@ discard block |
||
154 | 154 | public function testFunctionUpper() |
155 | 155 | { |
156 | 156 | $result = $this->_em->createQuery("SELECT m, UPPER(m.name) AS uppername FROM Doctrine\Tests\Models\Company\CompanyManager m ORDER BY m.salary ASC") |
157 | - ->getArrayResult(); |
|
157 | + ->getArrayResult(); |
|
158 | 158 | |
159 | 159 | self::assertEquals(4, count($result)); |
160 | 160 | self::assertEquals('ROMAN B.', $result[0]['uppername']); |
@@ -169,7 +169,7 @@ discard block |
||
169 | 169 | "FROM Doctrine\Tests\Models\Company\CompanyManager m ORDER BY m.name"; |
170 | 170 | |
171 | 171 | $result = $this->_em->createQuery($dql) |
172 | - ->getArrayResult(); |
|
172 | + ->getArrayResult(); |
|
173 | 173 | |
174 | 174 | self::assertEquals(4, count($result)); |
175 | 175 | self::assertEquals('Ben', $result[0]['str1']); |
@@ -186,8 +186,8 @@ discard block |
||
186 | 186 | public function testFunctionTrim() |
187 | 187 | { |
188 | 188 | $dql = "SELECT m, TRIM(TRAILING '.' FROM m.name) AS str1, ". |
189 | - " TRIM(LEADING '.' FROM m.name) AS str2, TRIM(CONCAT(' ', CONCAT(m.name, ' '))) AS str3 ". |
|
190 | - "FROM Doctrine\Tests\Models\Company\CompanyManager m ORDER BY m.salary ASC"; |
|
189 | + " TRIM(LEADING '.' FROM m.name) AS str2, TRIM(CONCAT(' ', CONCAT(m.name, ' '))) AS str3 ". |
|
190 | + "FROM Doctrine\Tests\Models\Company\CompanyManager m ORDER BY m.salary ASC"; |
|
191 | 191 | |
192 | 192 | $result = $this->_em->createQuery($dql)->getArrayResult(); |
193 | 193 | |
@@ -359,8 +359,8 @@ discard block |
||
359 | 359 | } |
360 | 360 | |
361 | 361 | /** |
362 | - * @group DDC-1213 |
|
363 | - */ |
|
362 | + * @group DDC-1213 |
|
363 | + */ |
|
364 | 364 | public function testBitAndComparison() |
365 | 365 | { |
366 | 366 | $dql = 'SELECT m, ' . |
@@ -146,7 +146,7 @@ discard block |
||
146 | 146 | |
147 | 147 | self::assertEquals(4, count($result)); |
148 | 148 | self::assertEquals(316, round($result[0]['sqrtsalary'])); |
149 | - self::assertEquals(447, round($result[1]['sqrtsalary'])); |
|
149 | + self::assertEquals(447, round($result[1]['sqrtsalary'])); |
|
150 | 150 | self::assertEquals(632, round($result[2]['sqrtsalary'])); |
151 | 151 | self::assertEquals(894, round($result[3]['sqrtsalary'])); |
152 | 152 | } |
@@ -339,12 +339,12 @@ discard block |
||
339 | 339 | */ |
340 | 340 | public function testBitOrComparison() |
341 | 341 | { |
342 | - $dql = 'SELECT m, ' . |
|
343 | - 'BIT_OR(4, 2) AS bit_or,' . |
|
344 | - 'BIT_OR( (m.salary/100000) , 2 ) AS salary_bit_or ' . |
|
345 | - 'FROM Doctrine\Tests\Models\Company\CompanyManager m ' . |
|
346 | - 'ORDER BY ' . |
|
347 | - 'm.id ' ; |
|
342 | + $dql = 'SELECT m, '. |
|
343 | + 'BIT_OR(4, 2) AS bit_or,'. |
|
344 | + 'BIT_OR( (m.salary/100000) , 2 ) AS salary_bit_or '. |
|
345 | + 'FROM Doctrine\Tests\Models\Company\CompanyManager m '. |
|
346 | + 'ORDER BY '. |
|
347 | + 'm.id '; |
|
348 | 348 | $result = $this->_em->createQuery($dql)->getArrayResult(); |
349 | 349 | |
350 | 350 | self::assertEquals(4 | 2, $result[0]['bit_or']); |
@@ -352,10 +352,10 @@ discard block |
||
352 | 352 | self::assertEquals(4 | 2, $result[2]['bit_or']); |
353 | 353 | self::assertEquals(4 | 2, $result[3]['bit_or']); |
354 | 354 | |
355 | - self::assertEquals(($result[0][0]['salary']/100000) | 2, $result[0]['salary_bit_or']); |
|
356 | - self::assertEquals(($result[1][0]['salary']/100000) | 2, $result[1]['salary_bit_or']); |
|
357 | - self::assertEquals(($result[2][0]['salary']/100000) | 2, $result[2]['salary_bit_or']); |
|
358 | - self::assertEquals(($result[3][0]['salary']/100000) | 2, $result[3]['salary_bit_or']); |
|
355 | + self::assertEquals(($result[0][0]['salary'] / 100000) | 2, $result[0]['salary_bit_or']); |
|
356 | + self::assertEquals(($result[1][0]['salary'] / 100000) | 2, $result[1]['salary_bit_or']); |
|
357 | + self::assertEquals(($result[2][0]['salary'] / 100000) | 2, $result[2]['salary_bit_or']); |
|
358 | + self::assertEquals(($result[3][0]['salary'] / 100000) | 2, $result[3]['salary_bit_or']); |
|
359 | 359 | } |
360 | 360 | |
361 | 361 | /** |
@@ -363,12 +363,12 @@ discard block |
||
363 | 363 | */ |
364 | 364 | public function testBitAndComparison() |
365 | 365 | { |
366 | - $dql = 'SELECT m, ' . |
|
367 | - 'BIT_AND(4, 2) AS bit_and,' . |
|
368 | - 'BIT_AND( (m.salary/100000) , 2 ) AS salary_bit_and ' . |
|
369 | - 'FROM Doctrine\Tests\Models\Company\CompanyManager m ' . |
|
370 | - 'ORDER BY ' . |
|
371 | - 'm.id ' ; |
|
366 | + $dql = 'SELECT m, '. |
|
367 | + 'BIT_AND(4, 2) AS bit_and,'. |
|
368 | + 'BIT_AND( (m.salary/100000) , 2 ) AS salary_bit_and '. |
|
369 | + 'FROM Doctrine\Tests\Models\Company\CompanyManager m '. |
|
370 | + 'ORDER BY '. |
|
371 | + 'm.id '; |
|
372 | 372 | $result = $this->_em->createQuery($dql)->getArrayResult(); |
373 | 373 | |
374 | 374 | self::assertEquals(4 & 2, $result[0]['bit_and']); |
@@ -376,10 +376,10 @@ discard block |
||
376 | 376 | self::assertEquals(4 & 2, $result[2]['bit_and']); |
377 | 377 | self::assertEquals(4 & 2, $result[3]['bit_and']); |
378 | 378 | |
379 | - self::assertEquals(($result[0][0]['salary']/100000) & 2, $result[0]['salary_bit_and']); |
|
380 | - self::assertEquals(($result[1][0]['salary']/100000) & 2, $result[1]['salary_bit_and']); |
|
381 | - self::assertEquals(($result[2][0]['salary']/100000) & 2, $result[2]['salary_bit_and']); |
|
382 | - self::assertEquals(($result[3][0]['salary']/100000) & 2, $result[3]['salary_bit_and']); |
|
379 | + self::assertEquals(($result[0][0]['salary'] / 100000) & 2, $result[0]['salary_bit_and']); |
|
380 | + self::assertEquals(($result[1][0]['salary'] / 100000) & 2, $result[1]['salary_bit_and']); |
|
381 | + self::assertEquals(($result[2][0]['salary'] / 100000) & 2, $result[2]['salary_bit_and']); |
|
382 | + self::assertEquals(($result[3][0]['salary'] / 100000) & 2, $result[3]['salary_bit_and']); |
|
383 | 383 | } |
384 | 384 | |
385 | 385 | protected function generateFixture() |
@@ -207,13 +207,13 @@ |
||
207 | 207 | |
208 | 208 | $q = $this->_em->createNativeQuery('SELECT id, name, status, phonenumber FROM cms_users INNER JOIN cms_phonenumbers ON id = user_id WHERE username = ?', $rsm); |
209 | 209 | $q2 = $q->setSQL('foo') |
210 | - ->setResultSetMapping($rsm) |
|
211 | - ->expireResultCache(true) |
|
212 | - ->setHint('foo', 'bar') |
|
213 | - ->setParameter(1, 'foo') |
|
214 | - ->setParameters($parameters) |
|
215 | - ->setResultCacheDriver(null) |
|
216 | - ->setResultCacheLifetime(3500); |
|
210 | + ->setResultSetMapping($rsm) |
|
211 | + ->expireResultCache(true) |
|
212 | + ->setHint('foo', 'bar') |
|
213 | + ->setParameter(1, 'foo') |
|
214 | + ->setParameters($parameters) |
|
215 | + ->setResultCacheDriver(null) |
|
216 | + ->setResultCacheLifetime(3500); |
|
217 | 217 | |
218 | 218 | self::assertSame($q, $q2); |
219 | 219 | } |
@@ -401,8 +401,8 @@ discard block |
||
401 | 401 | |
402 | 402 | self::assertCount(1, $result); |
403 | 403 | self::assertInstanceOf(CmsAddress::class, $result[0]); |
404 | - self::assertEquals($addr->id, $result[0]->id); |
|
405 | - self::assertEquals($addr->city, $result[0]->city); |
|
404 | + self::assertEquals($addr->id, $result[0]->id); |
|
405 | + self::assertEquals($addr->city, $result[0]->city); |
|
406 | 406 | self::assertEquals($addr->country, $result[0]->country); |
407 | 407 | } |
408 | 408 | |
@@ -565,7 +565,7 @@ discard block |
||
565 | 565 | $repository = $this->_em->getRepository(CmsUser::class); |
566 | 566 | |
567 | 567 | $result = $repository->createNativeNamedQuery('fetchUserPhonenumberCount') |
568 | - ->setParameter(1, ['test','FabioBatSilva'])->getResult(); |
|
568 | + ->setParameter(1, ['test', 'FabioBatSilva'])->getResult(); |
|
569 | 569 | |
570 | 570 | self::assertEquals(2, count($result)); |
571 | 571 | self::assertTrue(is_array($result[0])); |
@@ -798,7 +798,7 @@ discard block |
||
798 | 798 | $rsm = new ResultSetMappingBuilder($this->_em, ResultSetMappingBuilder::COLUMN_RENAMING_INCREMENT); |
799 | 799 | $rsm->addRootEntityFromClassMetadata(CmsUser::class, 'u'); |
800 | 800 | |
801 | - self::assertSQLEquals('u.id AS id0, u.status AS status1, u.username AS username2, u.name AS name3, u.email_id AS email_id4', (string)$rsm); |
|
801 | + self::assertSQLEquals('u.id AS id0, u.status AS status1, u.username AS username2, u.name AS name3, u.email_id AS email_id4', (string) $rsm); |
|
802 | 802 | } |
803 | 803 | |
804 | 804 | /** |