@@ -30,7 +30,7 @@ discard block |
||
30 | 30 | */ |
31 | 31 | public function convertToDatabaseValueSQL($sqlExpr, AbstractPlatform $platform) |
32 | 32 | { |
33 | - return 'UPPER(' . $sqlExpr . ')'; |
|
33 | + return 'UPPER('.$sqlExpr.')'; |
|
34 | 34 | } |
35 | 35 | |
36 | 36 | /** |
@@ -38,6 +38,6 @@ discard block |
||
38 | 38 | */ |
39 | 39 | public function convertToPHPValueSQL($sqlExpr, $platform) |
40 | 40 | { |
41 | - return 'LOWER(' . $sqlExpr . ')'; |
|
41 | + return 'LOWER('.$sqlExpr.')'; |
|
42 | 42 | } |
43 | 43 | } |
@@ -38,7 +38,7 @@ discard block |
||
38 | 38 | */ |
39 | 39 | public function convertToDatabaseValueSQL($sqlExpr, AbstractPlatform $platform) |
40 | 40 | { |
41 | - return 'ABS(' . $sqlExpr . ')'; |
|
41 | + return 'ABS('.$sqlExpr.')'; |
|
42 | 42 | } |
43 | 43 | |
44 | 44 | /** |
@@ -46,6 +46,6 @@ discard block |
||
46 | 46 | */ |
47 | 47 | public function convertToPHPValueSQL($sqlExpr, $platform) |
48 | 48 | { |
49 | - return '-(' . $sqlExpr . ')'; |
|
49 | + return '-('.$sqlExpr.')'; |
|
50 | 50 | } |
51 | 51 | } |
@@ -39,7 +39,7 @@ |
||
39 | 39 | $user = new CMS\CmsUser(); |
40 | 40 | |
41 | 41 | $user->status = 'developer'; |
42 | - $user->username = 'jwage' . $i; |
|
42 | + $user->username = 'jwage'.$i; |
|
43 | 43 | $user->name = 'Jonathan'; |
44 | 44 | |
45 | 45 | $this->entityManager->persist($user); |
@@ -30,7 +30,7 @@ |
||
30 | 30 | try { |
31 | 31 | $query = $this->em->createQuery($dqlToBeTested); |
32 | 32 | $query->setHint(Query::HINT_CUSTOM_TREE_WALKERS, [CustomTreeWalkerJoin::class]) |
33 | - ->useQueryCache(false); |
|
33 | + ->useQueryCache(false); |
|
34 | 34 | |
35 | 35 | $sqlGenerated = $query->getSql(); |
36 | 36 |
@@ -34,7 +34,7 @@ discard block |
||
34 | 34 | |
35 | 35 | $query->free(); |
36 | 36 | } catch (\Exception $e) { |
37 | - $this->fail($e->getMessage() . ' at "' . $e->getFile() . '" on line ' . $e->getLine()); |
|
37 | + $this->fail($e->getMessage().' at "'.$e->getFile().'" on line '.$e->getLine()); |
|
38 | 38 | } |
39 | 39 | |
40 | 40 | self::assertEquals($sqlToBeConfirmed, $sqlGenerated); |
@@ -76,9 +76,9 @@ discard block |
||
76 | 76 | { |
77 | 77 | $rangeVariableDecl = $identificationVariableDecl->rangeVariableDeclaration; |
78 | 78 | $joinAssocPathExpression = new Query\AST\JoinAssociationPathExpression($rangeVariableDecl->aliasIdentificationVariable, 'address'); |
79 | - $joinAssocDeclaration = new Query\AST\JoinAssociationDeclaration($joinAssocPathExpression, $rangeVariableDecl->aliasIdentificationVariable . 'a', null); |
|
79 | + $joinAssocDeclaration = new Query\AST\JoinAssociationDeclaration($joinAssocPathExpression, $rangeVariableDecl->aliasIdentificationVariable.'a', null); |
|
80 | 80 | $join = new Query\AST\Join(Query\AST\Join::JOIN_TYPE_LEFT, $joinAssocDeclaration); |
81 | - $selectExpression = new Query\AST\SelectExpression($rangeVariableDecl->aliasIdentificationVariable . 'a', null, false); |
|
81 | + $selectExpression = new Query\AST\SelectExpression($rangeVariableDecl->aliasIdentificationVariable.'a', null, false); |
|
82 | 82 | |
83 | 83 | $identificationVariableDecl->joins[] = $join; |
84 | 84 | $selectStatement->selectClause->selectExpressions[] = $selectExpression; |
@@ -88,7 +88,7 @@ discard block |
||
88 | 88 | $addressMetadata = $entityManager->getClassMetadata(CmsAddress::class); |
89 | 89 | |
90 | 90 | $this->setQueryComponent( |
91 | - $rangeVariableDecl->aliasIdentificationVariable . 'a', |
|
91 | + $rangeVariableDecl->aliasIdentificationVariable.'a', |
|
92 | 92 | [ |
93 | 93 | 'metadata' => $addressMetadata, |
94 | 94 | 'parent' => $rangeVariableDecl->aliasIdentificationVariable, |
@@ -212,7 +212,7 @@ |
||
212 | 212 | $this->expectExceptionMessage('The optimistic lock on an entity failed.'); |
213 | 213 | |
214 | 214 | $this->em->createQuery($dql) |
215 | - ->setHint(Query::HINT_LOCK_MODE, LockMode::OPTIMISTIC) |
|
216 | - ->getSQL(); |
|
215 | + ->setHint(Query::HINT_LOCK_MODE, LockMode::OPTIMISTIC) |
|
216 | + ->getSQL(); |
|
217 | 217 | } |
218 | 218 | } |
@@ -90,7 +90,7 @@ discard block |
||
90 | 90 | $article = new CmsArticle(); |
91 | 91 | |
92 | 92 | $this->expectException(\InvalidArgumentException::class); |
93 | - $this->expectExceptionMessage('Entity ' . CmsArticle::class); |
|
93 | + $this->expectExceptionMessage('Entity '.CmsArticle::class); |
|
94 | 94 | |
95 | 95 | $this->em->lock($article, LockMode::OPTIMISTIC, $article->version + 1); |
96 | 96 | } |
@@ -139,7 +139,7 @@ discard block |
||
139 | 139 | { |
140 | 140 | $writeLockSql = $this->em->getConnection()->getDatabasePlatform()->getWriteLockSQL(); |
141 | 141 | |
142 | - if (! $writeLockSql) { |
|
142 | + if ( ! $writeLockSql) { |
|
143 | 143 | $this->markTestSkipped('Database Driver has no Write Lock support.'); |
144 | 144 | } |
145 | 145 | |
@@ -174,7 +174,7 @@ discard block |
||
174 | 174 | { |
175 | 175 | $readLockSql = $this->em->getConnection()->getDatabasePlatform()->getReadLockSQL(); |
176 | 176 | |
177 | - if (! $readLockSql) { |
|
177 | + if ( ! $readLockSql) { |
|
178 | 178 | $this->markTestSkipped('Database Driver has no Write Lock support.'); |
179 | 179 | } |
180 | 180 | |
@@ -207,7 +207,7 @@ discard block |
||
207 | 207 | */ |
208 | 208 | public function testLockOptimisticNonVersionedThrowsExceptionInDQL() : void |
209 | 209 | { |
210 | - $dql = 'SELECT u FROM ' . CmsUser::class . " u WHERE u.username = 'gblanco'"; |
|
210 | + $dql = 'SELECT u FROM '.CmsUser::class." u WHERE u.username = 'gblanco'"; |
|
211 | 211 | |
212 | 212 | $this->expectException(OptimisticLockException::class); |
213 | 213 | $this->expectExceptionMessage('The optimistic lock on an entity failed.'); |
@@ -167,12 +167,12 @@ |
||
167 | 167 | $this->em->clear(); |
168 | 168 | |
169 | 169 | $dateTimeDb = $this->em->createQueryBuilder() |
170 | - ->select('d') |
|
171 | - ->from(DateTimeModel::class, 'd') |
|
172 | - ->where('d.datetime = ?1') |
|
173 | - ->setParameter(1, $date, DBALType::DATETIME) |
|
174 | - ->getQuery() |
|
175 | - ->getSingleResult(); |
|
170 | + ->select('d') |
|
171 | + ->from(DateTimeModel::class, 'd') |
|
172 | + ->where('d.datetime = ?1') |
|
173 | + ->setParameter(1, $date, DBALType::DATETIME) |
|
174 | + ->getQuery() |
|
175 | + ->getSingleResult(); |
|
176 | 176 | |
177 | 177 | self::assertInstanceOf(\DateTime::class, $dateTimeDb->datetime); |
178 | 178 | self::assertSame('2009-10-02 20:10:52', $dateTimeDb->datetime->format('Y-m-d H:i:s')); |
@@ -30,7 +30,7 @@ discard block |
||
30 | 30 | $this->em->flush(); |
31 | 31 | $this->em->clear(); |
32 | 32 | |
33 | - $dql = 'SELECT d FROM ' . DecimalModel::class . ' d'; |
|
33 | + $dql = 'SELECT d FROM '.DecimalModel::class.' d'; |
|
34 | 34 | $decimal = $this->em->createQuery($dql)->getSingleResult(); |
35 | 35 | |
36 | 36 | self::assertSame('0.15', $decimal->decimal); |
@@ -49,7 +49,7 @@ discard block |
||
49 | 49 | $this->em->flush(); |
50 | 50 | $this->em->clear(); |
51 | 51 | |
52 | - $dql = 'SELECT b FROM ' . BooleanModel::class . ' b WHERE b.booleanField = true'; |
|
52 | + $dql = 'SELECT b FROM '.BooleanModel::class.' b WHERE b.booleanField = true'; |
|
53 | 53 | $bool = $this->em->createQuery($dql)->getSingleResult(); |
54 | 54 | |
55 | 55 | self::assertTrue($bool->booleanField); |
@@ -59,7 +59,7 @@ discard block |
||
59 | 59 | $this->em->flush(); |
60 | 60 | $this->em->clear(); |
61 | 61 | |
62 | - $dql = 'SELECT b FROM ' . BooleanModel::class . ' b WHERE b.booleanField = false'; |
|
62 | + $dql = 'SELECT b FROM '.BooleanModel::class.' b WHERE b.booleanField = false'; |
|
63 | 63 | $bool = $this->em->createQuery($dql)->getSingleResult(); |
64 | 64 | |
65 | 65 | self::assertFalse($bool->booleanField); |
@@ -75,7 +75,7 @@ discard block |
||
75 | 75 | $this->em->flush(); |
76 | 76 | $this->em->clear(); |
77 | 77 | |
78 | - $dql = 'SELECT s FROM ' . SerializationModel::class . ' s'; |
|
78 | + $dql = 'SELECT s FROM '.SerializationModel::class.' s'; |
|
79 | 79 | $serialize = $this->em->createQuery($dql)->getSingleResult(); |
80 | 80 | |
81 | 81 | self::assertSame(['foo' => 'bar', 'bar' => 'baz'], $serialize->array); |
@@ -90,7 +90,7 @@ discard block |
||
90 | 90 | $this->em->flush(); |
91 | 91 | $this->em->clear(); |
92 | 92 | |
93 | - $dql = 'SELECT s FROM ' . SerializationModel::class . ' s'; |
|
93 | + $dql = 'SELECT s FROM '.SerializationModel::class.' s'; |
|
94 | 94 | $serialize = $this->em->createQuery($dql)->getSingleResult(); |
95 | 95 | |
96 | 96 | self::assertInstanceOf('stdClass', $serialize->object); |
@@ -112,9 +112,9 @@ discard block |
||
112 | 112 | $this->putTripAroundEurope(); |
113 | 113 | |
114 | 114 | $dql = 'SELECT t, p, c ' |
115 | - . 'FROM Doctrine\Tests\Models\Navigation\NavTour t ' |
|
116 | - . 'INNER JOIN t.pois p ' |
|
117 | - . 'INNER JOIN p.country c' |
|
115 | + . 'FROM Doctrine\Tests\Models\Navigation\NavTour t ' |
|
116 | + . 'INNER JOIN t.pois p ' |
|
117 | + . 'INNER JOIN p.country c' |
|
118 | 118 | ; |
119 | 119 | |
120 | 120 | $tours = $this->em->createQuery($dql)->getResult(); |
@@ -134,9 +134,9 @@ discard block |
||
134 | 134 | $this->putTripAroundEurope(); |
135 | 135 | |
136 | 136 | $dql = 'SELECT t ' |
137 | - . 'FROM Doctrine\Tests\Models\Navigation\NavTour t ' |
|
138 | - . ', Doctrine\Tests\Models\Navigation\NavPointOfInterest p ' |
|
139 | - . 'WHERE p MEMBER OF t.pois' |
|
137 | + . 'FROM Doctrine\Tests\Models\Navigation\NavTour t ' |
|
138 | + . ', Doctrine\Tests\Models\Navigation\NavPointOfInterest p ' |
|
139 | + . 'WHERE p MEMBER OF t.pois' |
|
140 | 140 | ; |
141 | 141 | |
142 | 142 | $query = $this->em->createQuery($dql); |
@@ -51,10 +51,10 @@ discard block |
||
51 | 51 | private function createQuery() |
52 | 52 | { |
53 | 53 | return $this->em->createQueryBuilder() |
54 | - ->select('car') |
|
55 | - ->from(GH2947Car::class, 'car') |
|
56 | - ->getQuery() |
|
57 | - ->useResultCache(true, 3600, 'foo-cache-id'); |
|
54 | + ->select('car') |
|
55 | + ->from(GH2947Car::class, 'car') |
|
56 | + ->getQuery() |
|
57 | + ->useResultCache(true, 3600, 'foo-cache-id'); |
|
58 | 58 | } |
59 | 59 | |
60 | 60 | private function createData() |
@@ -67,13 +67,13 @@ discard block |
||
67 | 67 | private function updateData() |
68 | 68 | { |
69 | 69 | $this->em->createQueryBuilder() |
70 | - ->update(GH2947Car::class, 'car') |
|
71 | - ->set('car.brand', ':newBrand') |
|
72 | - ->where('car.brand = :oldBrand') |
|
73 | - ->setParameter('newBrand', 'Dacia') |
|
74 | - ->setParameter('oldBrand', 'BMW') |
|
75 | - ->getQuery() |
|
76 | - ->execute(); |
|
70 | + ->update(GH2947Car::class, 'car') |
|
71 | + ->set('car.brand', ':newBrand') |
|
72 | + ->where('car.brand = :oldBrand') |
|
73 | + ->setParameter('newBrand', 'Dacia') |
|
74 | + ->setParameter('oldBrand', 'BMW') |
|
75 | + ->getQuery() |
|
76 | + ->execute(); |
|
77 | 77 | } |
78 | 78 | } |
79 | 79 |
@@ -50,19 +50,19 @@ |
||
50 | 50 | $this->em->clear(); |
51 | 51 | |
52 | 52 | $result = $this->em->createQueryBuilder() |
53 | - ->select('p') |
|
54 | - ->from(DDC3170ProductJoined::class, 'p') |
|
55 | - ->getQuery() |
|
56 | - ->getResult(AbstractQuery::HYDRATE_SIMPLEOBJECT); |
|
53 | + ->select('p') |
|
54 | + ->from(DDC3170ProductJoined::class, 'p') |
|
55 | + ->getQuery() |
|
56 | + ->getResult(AbstractQuery::HYDRATE_SIMPLEOBJECT); |
|
57 | 57 | |
58 | 58 | self::assertCount(1, $result); |
59 | 59 | self::assertContainsOnly(DDC3170ProductJoined::class, $result); |
60 | 60 | |
61 | 61 | $result = $this->em->createQueryBuilder() |
62 | - ->select('p') |
|
63 | - ->from(DDC3170ProductSingleTable::class, 'p') |
|
64 | - ->getQuery() |
|
65 | - ->getResult(AbstractQuery::HYDRATE_SIMPLEOBJECT); |
|
62 | + ->select('p') |
|
63 | + ->from(DDC3170ProductSingleTable::class, 'p') |
|
64 | + ->getQuery() |
|
65 | + ->getResult(AbstractQuery::HYDRATE_SIMPLEOBJECT); |
|
66 | 66 | |
67 | 67 | self::assertCount(1, $result); |
68 | 68 | self::assertContainsOnly(DDC3170ProductSingleTable::class, $result); |