Code Duplication - doctrine/orm - Measure and Improve Code Quality continuously with Scrutinizer

Code Duplication Length = 15-18 lines in 4 locations

tests/Doctrine/Tests/ORM/Functional/Ticket/GH6699Test.php 2 locations


        parent::setUp();
    }

    public function testMixedParametersWithZeroNumber() : void
    {
        $query = $this->_em->createQueryBuilder()
                           ->select('u')
                           ->from(CmsUser::class, 'u')
                           ->andWhere('u.username = :username')
                           ->andWhere('u.id = ?0')
                           ->getQuery();

        $query->setParameter('username', 'bar');
        $query->setParameter(0, 0);

        $query->execute();

        self::assertCount(2, $query->getParameters());
        self::assertSame(0, $query->getParameter(0)->getValue());
        self::assertSame('bar', $query->getParameter('username')->getValue());
    }

    public function testMixedParametersWithZeroNumberOnQueryBuilder() : void
    {

        self::assertSame('bar', $query->getParameter('username')->getValue());
    }

    public function testMixedParametersWithZeroNumberOnQueryBuilder() : void
    {
        $query = $this->_em->createQueryBuilder()
                           ->select('u')
                           ->from(CmsUser::class, 'u')
                           ->andWhere('u.username = :username')
                           ->andWhere('u.id = ?0')
                           ->setParameter('username', 'bar')
                           ->setParameter(0, 0)
                           ->getQuery();

        $query->execute();

        self::assertCount(2, $query->getParameters());
        self::assertSame(0, $query->getParameter(0)->getValue());
        self::assertSame('bar', $query->getParameter('username')->getValue());
    }
}


tests/Doctrine/Tests/ORM/QueryBuilderTest.php 2 locations


    /**
     * @group 6699
     */
    public function testSetParameterWithNameZeroIsNotOverridden() : void
    {
        $builder = $this->_em->createQueryBuilder()
                             ->select('u')
                             ->from(CmsUser::class, 'u')
                             ->where('u.id != ?0')
                             ->andWhere('u.username = :name');

        $builder->setParameter(0, 0);
        $builder->setParameter('name', 'Doctrine');

        self::assertCount(2, $builder->getParameters());
        self::assertSame(0, $builder->getParameter('0')->getValue());
        self::assertSame('Doctrine', $builder->getParameter('name')->getValue());
    }

    /**
     * @group 6699

    /**
     * @group 6699
     */
    public function testSetParameterWithNameZeroDoesNotOverrideAnotherParameter() : void
    {
        $builder = $this->_em->createQueryBuilder()
                             ->select('u')
                             ->from(CmsUser::class, 'u')
                             ->where('u.id != ?0')
                             ->andWhere('u.username = :name');

        $builder->setParameter('name', 'Doctrine');
        $builder->setParameter(0, 0);

        self::assertCount(2, $builder->getParameters());
        self::assertSame(0, $builder->getParameter(0)->getValue());
        self::assertSame('Doctrine', $builder->getParameter('name')->getValue());
    }

    /**
     * @group 6699

		@@ 20-37 (lines=18) @@
17		parent::setUp();
18		}
19
20		public function testMixedParametersWithZeroNumber() : void
21		{
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();
28
29		$query->setParameter('username', 'bar');
30		$query->setParameter(0, 0);
31
32		$query->execute();
33
34		self::assertCount(2, $query->getParameters());
35		self::assertSame(0, $query->getParameter(0)->getValue());
36		self::assertSame('bar', $query->getParameter('username')->getValue());
37		}
38
39		public function testMixedParametersWithZeroNumberOnQueryBuilder() : void
40		{
		@@ 39-55 (lines=17) @@
36		self::assertSame('bar', $query->getParameter('username')->getValue());
37		}
38
39		public function testMixedParametersWithZeroNumberOnQueryBuilder() : void
40		{
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();
49
50		$query->execute();
51
52		self::assertCount(2, $query->getParameters());
53		self::assertSame(0, $query->getParameter(0)->getValue());
54		self::assertSame('bar', $query->getParameter('username')->getValue());
55		}
56		}
57

		@@ 1184-1198 (lines=15) @@
1181		/**
1182		* @group 6699
1183		*/
1184		public function testSetParameterWithNameZeroIsNotOverridden() : void
1185		{
1186		$builder = $this->_em->createQueryBuilder()
1187		->select('u')
1188		->from(CmsUser::class, 'u')
1189		->where('u.id != ?0')
1190		->andWhere('u.username = :name');
1191
1192		$builder->setParameter(0, 0);
1193		$builder->setParameter('name', 'Doctrine');
1194
1195		self::assertCount(2, $builder->getParameters());
1196		self::assertSame(0, $builder->getParameter('0')->getValue());
1197		self::assertSame('Doctrine', $builder->getParameter('name')->getValue());
1198		}
1199
1200		/**
1201		* @group 6699
		@@ 1203-1217 (lines=15) @@
1200		/**
1201		* @group 6699
1202		*/
1203		public function testSetParameterWithNameZeroDoesNotOverrideAnotherParameter() : void
1204		{
1205		$builder = $this->_em->createQueryBuilder()
1206		->select('u')
1207		->from(CmsUser::class, 'u')
1208		->where('u.id != ?0')
1209		->andWhere('u.username = :name');
1210
1211		$builder->setParameter('name', 'Doctrine');
1212		$builder->setParameter(0, 0);
1213
1214		self::assertCount(2, $builder->getParameters());
1215		self::assertSame(0, $builder->getParameter(0)->getValue());
1216		self::assertSame('Doctrine', $builder->getParameter('name')->getValue());
1217		}
1218
1219		/**
1220		* @group 6699

doctrine / orm

Code Duplication Length = 15-18 lines in 4 locations

tests/Doctrine/Tests/ORM/Functional/Ticket/GH6699Test.php 2 locations

tests/Doctrine/Tests/ORM/QueryBuilderTest.php 2 locations