@@ -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() : void |
| 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'); |