@@ -20,11 +20,11 @@ discard block |
||
20 | 20 | public function testMixedParametersWithZeroNumber() : void |
21 | 21 | { |
22 | 22 | $query = $this->_em->createQueryBuilder() |
23 | - ->select('u') |
|
24 | - ->from(CmsUser::class, 'u') |
|
25 | - ->andWhere('u.username = :username') |
|
26 | - ->andWhere('u.id = ?0') |
|
27 | - ->getQuery(); |
|
23 | + ->select('u') |
|
24 | + ->from(CmsUser::class, 'u') |
|
25 | + ->andWhere('u.username = :username') |
|
26 | + ->andWhere('u.id = ?0') |
|
27 | + ->getQuery(); |
|
28 | 28 | |
29 | 29 | $query->setParameter('username', 'bar'); |
30 | 30 | $query->setParameter(0, 0); |
@@ -39,13 +39,13 @@ discard block |
||
39 | 39 | public function testMixedParametersWithZeroNumberOnQueryBuilder() : void |
40 | 40 | { |
41 | 41 | $query = $this->_em->createQueryBuilder() |
42 | - ->select('u') |
|
43 | - ->from(CmsUser::class, 'u') |
|
44 | - ->andWhere('u.username = :username') |
|
45 | - ->andWhere('u.id = ?0') |
|
46 | - ->setParameter('username', 'bar') |
|
47 | - ->setParameter(0, 0) |
|
48 | - ->getQuery(); |
|
42 | + ->select('u') |
|
43 | + ->from(CmsUser::class, 'u') |
|
44 | + ->andWhere('u.username = :username') |
|
45 | + ->andWhere('u.id = ?0') |
|
46 | + ->setParameter('username', 'bar') |
|
47 | + ->setParameter(0, 0) |
|
48 | + ->getQuery(); |
|
49 | 49 | |
50 | 50 | $query->execute(); |
51 | 51 |
@@ -272,12 +272,12 @@ discard block |
||
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 | $this->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 |
||
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 | $this->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 |
||
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 | $this->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 |
||
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 | $this->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 |
||
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 | $this->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 |
||
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 |
||
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 |
||
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 | $this->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 |
||
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 | $this->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 |
||
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 | $this->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 |
||
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 | $this->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 |
||
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 | $this->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 |
||
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 | $this->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 | |
@@ -1121,9 +1121,9 @@ discard block |
||
1121 | 1121 | public function testRebuildsFromParts() |
1122 | 1122 | { |
1123 | 1123 | $qb = $this->_em->createQueryBuilder() |
1124 | - ->select('u') |
|
1125 | - ->from(CmsUser::class, 'u') |
|
1126 | - ->join('u.article', 'a'); |
|
1124 | + ->select('u') |
|
1125 | + ->from(CmsUser::class, 'u') |
|
1126 | + ->join('u.article', 'a'); |
|
1127 | 1127 | |
1128 | 1128 | $dqlParts = $qb->getDQLParts(); |
1129 | 1129 | $dql = $qb->getDQL(); |
@@ -1165,9 +1165,9 @@ discard block |
||
1165 | 1165 | public function testGetParameterTypeJuggling() : void |
1166 | 1166 | { |
1167 | 1167 | $builder = $this->_em->createQueryBuilder() |
1168 | - ->select('u') |
|
1169 | - ->from(CmsUser::class, 'u') |
|
1170 | - ->where('u.id = ?0'); |
|
1168 | + ->select('u') |
|
1169 | + ->from(CmsUser::class, 'u') |
|
1170 | + ->where('u.id = ?0'); |
|
1171 | 1171 | |
1172 | 1172 | $builder->setParameter(0, 0); |
1173 | 1173 | |
@@ -1182,10 +1182,10 @@ discard block |
||
1182 | 1182 | public function testSetParameterWithNameZeroIsNotOverridden() : void |
1183 | 1183 | { |
1184 | 1184 | $builder = $this->_em->createQueryBuilder() |
1185 | - ->select('u') |
|
1186 | - ->from(CmsUser::class, 'u') |
|
1187 | - ->where('u.id != ?0') |
|
1188 | - ->andWhere('u.username = :name'); |
|
1185 | + ->select('u') |
|
1186 | + ->from(CmsUser::class, 'u') |
|
1187 | + ->where('u.id != ?0') |
|
1188 | + ->andWhere('u.username = :name'); |
|
1189 | 1189 | |
1190 | 1190 | $builder->setParameter(0, 0); |
1191 | 1191 | $builder->setParameter('name', 'Doctrine'); |
@@ -1201,10 +1201,10 @@ discard block |
||
1201 | 1201 | public function testSetParameterWithNameZeroDoesNotOverrideAnotherParameter() : void |
1202 | 1202 | { |
1203 | 1203 | $builder = $this->_em->createQueryBuilder() |
1204 | - ->select('u') |
|
1205 | - ->from(CmsUser::class, 'u') |
|
1206 | - ->where('u.id != ?0') |
|
1207 | - ->andWhere('u.username = :name'); |
|
1204 | + ->select('u') |
|
1205 | + ->from(CmsUser::class, 'u') |
|
1206 | + ->where('u.id != ?0') |
|
1207 | + ->andWhere('u.username = :name'); |
|
1208 | 1208 | |
1209 | 1209 | $builder->setParameter('name', 'Doctrine'); |
1210 | 1210 | $builder->setParameter(0, 0); |
@@ -1220,10 +1220,10 @@ discard block |
||
1220 | 1220 | public function testSetParameterWithTypeJugglingWorks() |
1221 | 1221 | { |
1222 | 1222 | $builder = $this->_em->createQueryBuilder() |
1223 | - ->select('u') |
|
1224 | - ->from(CmsUser::class, 'u') |
|
1225 | - ->where('u.id != ?0') |
|
1226 | - ->andWhere('u.username = :name'); |
|
1223 | + ->select('u') |
|
1224 | + ->from(CmsUser::class, 'u') |
|
1225 | + ->where('u.id != ?0') |
|
1226 | + ->andWhere('u.username = :name'); |
|
1227 | 1227 | |
1228 | 1228 | $builder->setParameter('0', 1); |
1229 | 1229 | $builder->setParameter('name', 'Doctrine'); |