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

Code Duplication Length = 56-56 lines in 3 locations

tests/Doctrine/Tests/ORM/Functional/NewOperatorTest.php 3 locations


        $this->assertEquals($this->fixtures[2]->address->country, $result[2][0]->country);
    }

    public function testShouldSupportMultipleNewOperatorsAndSingleScalar()
    {
        $dql = "
            SELECT
                new CmsUserDTO(
                    u.name,
                    e.email
                ),
                new CmsAddressDTO(
                    a.country,
                    a.city
                ),
                u.status
            FROM
                Doctrine\Tests\Models\CMS\CmsUser u
            JOIN
                u.email e
            JOIN
                u.address a
            ORDER BY
                u.name";

        $query  = $this->_em->createQuery($dql);
        $result = $query->getResult();

        $this->assertCount(3, $result);

        $this->assertInstanceOf(CmsUserDTO::class, $result[0][0]);
        $this->assertInstanceOf(CmsUserDTO::class, $result[1][0]);
        $this->assertInstanceOf(CmsUserDTO::class, $result[2][0]);

        $this->assertInstanceOf(CmsAddressDTO::class, $result[0][1]);
        $this->assertInstanceOf(CmsAddressDTO::class, $result[1][1]);
        $this->assertInstanceOf(CmsAddressDTO::class, $result[2][1]);

        $this->assertEquals($this->fixtures[0]->name, $result[0][0]->name);
        $this->assertEquals($this->fixtures[1]->name, $result[1][0]->name);
        $this->assertEquals($this->fixtures[2]->name, $result[2][0]->name);

        $this->assertEquals($this->fixtures[0]->email->email, $result[0][0]->email);
        $this->assertEquals($this->fixtures[1]->email->email, $result[1][0]->email);
        $this->assertEquals($this->fixtures[2]->email->email, $result[2][0]->email);


        $this->assertEquals($this->fixtures[0]->address->city, $result[0][1]->city);
        $this->assertEquals($this->fixtures[1]->address->city, $result[1][1]->city);
        $this->assertEquals($this->fixtures[2]->address->city, $result[2][1]->city);

        $this->assertEquals($this->fixtures[0]->address->country, $result[0][1]->country);
        $this->assertEquals($this->fixtures[1]->address->country, $result[1][1]->country);
        $this->assertEquals($this->fixtures[2]->address->country, $result[2][1]->country);

        $this->assertEquals($this->fixtures[0]->status,$result[0]['status']);
        $this->assertEquals($this->fixtures[1]->status,$result[1]['status']);
        $this->assertEquals($this->fixtures[2]->status,$result[2]['status']);
    }

    public function testShouldSupportMultipleNewOperatorsAndSingleScalarWithAliases()
    {

        $this->assertEquals($this->fixtures[2]->status,$result[2]['status']);
    }

    public function testShouldSupportMultipleNewOperatorsAndSingleScalarWithAliases()
    {
        $dql = "
            SELECT
                new CmsUserDTO(
                    u.name,
                    e.email
                ) as cmsUser,
                new CmsAddressDTO(
                    a.country,
                    a.city
                ) as cmsAddress,
                u.status as cmsUserStatus
            FROM
                Doctrine\Tests\Models\CMS\CmsUser u
            JOIN
                u.email e
            JOIN
                u.address a
            ORDER BY
                u.name";

        $query  = $this->_em->createQuery($dql);
        $result = $query->getResult();

        $this->assertCount(3, $result);

        $this->assertInstanceOf(CmsUserDTO::class, $result[0]['cmsUser']);
        $this->assertInstanceOf(CmsUserDTO::class, $result[1]['cmsUser']);
        $this->assertInstanceOf(CmsUserDTO::class, $result[2]['cmsUser']);

        $this->assertInstanceOf(CmsAddressDTO::class, $result[0]['cmsAddress']);
        $this->assertInstanceOf(CmsAddressDTO::class, $result[1]['cmsAddress']);
        $this->assertInstanceOf(CmsAddressDTO::class, $result[2]['cmsAddress']);

        $this->assertEquals($this->fixtures[0]->name, $result[0]['cmsUser']->name);
        $this->assertEquals($this->fixtures[1]->name, $result[1]['cmsUser']->name);
        $this->assertEquals($this->fixtures[2]->name, $result[2]['cmsUser']->name);

        $this->assertEquals($this->fixtures[0]->email->email, $result[0]['cmsUser']->email);
        $this->assertEquals($this->fixtures[1]->email->email, $result[1]['cmsUser']->email);
        $this->assertEquals($this->fixtures[2]->email->email, $result[2]['cmsUser']->email);


        $this->assertEquals($this->fixtures[0]->address->city, $result[0]['cmsAddress']->city);
        $this->assertEquals($this->fixtures[1]->address->city, $result[1]['cmsAddress']->city);
        $this->assertEquals($this->fixtures[2]->address->city, $result[2]['cmsAddress']->city);

        $this->assertEquals($this->fixtures[0]->address->country, $result[0]['cmsAddress']->country);
        $this->assertEquals($this->fixtures[1]->address->country, $result[1]['cmsAddress']->country);
        $this->assertEquals($this->fixtures[2]->address->country, $result[2]['cmsAddress']->country);

        $this->assertEquals($this->fixtures[0]->status,$result[0]['cmsUserStatus']);
        $this->assertEquals($this->fixtures[1]->status,$result[1]['cmsUserStatus']);
        $this->assertEquals($this->fixtures[2]->status,$result[2]['cmsUserStatus']);
    }

    public function testShouldSupportMultipleNewOperatorsAndSingleScalarWithAndWithoutAliases()
    {

        $this->assertEquals($this->fixtures[2]->status,$result[2]['cmsUserStatus']);
    }

    public function testShouldSupportMultipleNewOperatorsAndSingleScalarWithAndWithoutAliases()
    {
        $dql = "
            SELECT
                new CmsUserDTO(
                    u.name,
                    e.email
                ) as cmsUser,
                new CmsAddressDTO(
                    a.country,
                    a.city
                ),
                u.status
            FROM
                Doctrine\Tests\Models\CMS\CmsUser u
            JOIN
                u.email e
            JOIN
                u.address a
            ORDER BY
                u.name";

        $query  = $this->_em->createQuery($dql);
        $result = $query->getResult();

        $this->assertCount(3, $result);

        $this->assertInstanceOf(CmsUserDTO::class, $result[0]['cmsUser']);
        $this->assertInstanceOf(CmsUserDTO::class, $result[1]['cmsUser']);
        $this->assertInstanceOf(CmsUserDTO::class, $result[2]['cmsUser']);

        $this->assertInstanceOf(CmsAddressDTO::class, $result[0][0]);
        $this->assertInstanceOf(CmsAddressDTO::class, $result[1][0]);
        $this->assertInstanceOf(CmsAddressDTO::class, $result[2][0]);

        $this->assertEquals($this->fixtures[0]->name, $result[0]['cmsUser']->name);
        $this->assertEquals($this->fixtures[1]->name, $result[1]['cmsUser']->name);
        $this->assertEquals($this->fixtures[2]->name, $result[2]['cmsUser']->name);

        $this->assertEquals($this->fixtures[0]->email->email, $result[0]['cmsUser']->email);
        $this->assertEquals($this->fixtures[1]->email->email, $result[1]['cmsUser']->email);
        $this->assertEquals($this->fixtures[2]->email->email, $result[2]['cmsUser']->email);


        $this->assertEquals($this->fixtures[0]->address->city, $result[0][0]->city);
        $this->assertEquals($this->fixtures[1]->address->city, $result[1][0]->city);
        $this->assertEquals($this->fixtures[2]->address->city, $result[2][0]->city);

        $this->assertEquals($this->fixtures[0]->address->country, $result[0][0]->country);
        $this->assertEquals($this->fixtures[1]->address->country, $result[1][0]->country);
        $this->assertEquals($this->fixtures[2]->address->country, $result[2][0]->country);

        $this->assertEquals($this->fixtures[0]->status,$result[0]['status']);
        $this->assertEquals($this->fixtures[1]->status,$result[1]['status']);
        $this->assertEquals($this->fixtures[2]->status,$result[2]['status']);
    }

    public function testShouldSupportMultipleNewOperatorsAndMultipleScalars()
    {

		@@ 693-748 (lines=56) @@
690		$this->assertEquals($this->fixtures[2]->address->country, $result[2][0]->country);
691		}
692
693		public function testShouldSupportMultipleNewOperatorsAndSingleScalar()
694		{
695		$dql = "
696		SELECT
697		new CmsUserDTO(
698		u.name,
699		e.email
700		),
701		new CmsAddressDTO(
702		a.country,
703		a.city
704		),
705		u.status
706		FROM
707		Doctrine\Tests\Models\CMS\CmsUser u
708		JOIN
709		u.email e
710		JOIN
711		u.address a
712		ORDER BY
713		u.name";
714
715		$query = $this->_em->createQuery($dql);
716		$result = $query->getResult();
717
718		$this->assertCount(3, $result);
719
720		$this->assertInstanceOf(CmsUserDTO::class, $result[0][0]);
721		$this->assertInstanceOf(CmsUserDTO::class, $result[1][0]);
722		$this->assertInstanceOf(CmsUserDTO::class, $result[2][0]);
723
724		$this->assertInstanceOf(CmsAddressDTO::class, $result[0][1]);
725		$this->assertInstanceOf(CmsAddressDTO::class, $result[1][1]);
726		$this->assertInstanceOf(CmsAddressDTO::class, $result[2][1]);
727
728		$this->assertEquals($this->fixtures[0]->name, $result[0][0]->name);
729		$this->assertEquals($this->fixtures[1]->name, $result[1][0]->name);
730		$this->assertEquals($this->fixtures[2]->name, $result[2][0]->name);
731
732		$this->assertEquals($this->fixtures[0]->email->email, $result[0][0]->email);
733		$this->assertEquals($this->fixtures[1]->email->email, $result[1][0]->email);
734		$this->assertEquals($this->fixtures[2]->email->email, $result[2][0]->email);
735
736
737		$this->assertEquals($this->fixtures[0]->address->city, $result[0][1]->city);
738		$this->assertEquals($this->fixtures[1]->address->city, $result[1][1]->city);
739		$this->assertEquals($this->fixtures[2]->address->city, $result[2][1]->city);
740
741		$this->assertEquals($this->fixtures[0]->address->country, $result[0][1]->country);
742		$this->assertEquals($this->fixtures[1]->address->country, $result[1][1]->country);
743		$this->assertEquals($this->fixtures[2]->address->country, $result[2][1]->country);
744
745		$this->assertEquals($this->fixtures[0]->status,$result[0]['status']);
746		$this->assertEquals($this->fixtures[1]->status,$result[1]['status']);
747		$this->assertEquals($this->fixtures[2]->status,$result[2]['status']);
748		}
749
750		public function testShouldSupportMultipleNewOperatorsAndSingleScalarWithAliases()
751		{
		@@ 750-805 (lines=56) @@
747		$this->assertEquals($this->fixtures[2]->status,$result[2]['status']);
748		}
749
750		public function testShouldSupportMultipleNewOperatorsAndSingleScalarWithAliases()
751		{
752		$dql = "
753		SELECT
754		new CmsUserDTO(
755		u.name,
756		e.email
757		) as cmsUser,
758		new CmsAddressDTO(
759		a.country,
760		a.city
761		) as cmsAddress,
762		u.status as cmsUserStatus
763		FROM
764		Doctrine\Tests\Models\CMS\CmsUser u
765		JOIN
766		u.email e
767		JOIN
768		u.address a
769		ORDER BY
770		u.name";
771
772		$query = $this->_em->createQuery($dql);
773		$result = $query->getResult();
774
775		$this->assertCount(3, $result);
776
777		$this->assertInstanceOf(CmsUserDTO::class, $result[0]['cmsUser']);
778		$this->assertInstanceOf(CmsUserDTO::class, $result[1]['cmsUser']);
779		$this->assertInstanceOf(CmsUserDTO::class, $result[2]['cmsUser']);
780
781		$this->assertInstanceOf(CmsAddressDTO::class, $result[0]['cmsAddress']);
782		$this->assertInstanceOf(CmsAddressDTO::class, $result[1]['cmsAddress']);
783		$this->assertInstanceOf(CmsAddressDTO::class, $result[2]['cmsAddress']);
784
785		$this->assertEquals($this->fixtures[0]->name, $result[0]['cmsUser']->name);
786		$this->assertEquals($this->fixtures[1]->name, $result[1]['cmsUser']->name);
787		$this->assertEquals($this->fixtures[2]->name, $result[2]['cmsUser']->name);
788
789		$this->assertEquals($this->fixtures[0]->email->email, $result[0]['cmsUser']->email);
790		$this->assertEquals($this->fixtures[1]->email->email, $result[1]['cmsUser']->email);
791		$this->assertEquals($this->fixtures[2]->email->email, $result[2]['cmsUser']->email);
792
793
794		$this->assertEquals($this->fixtures[0]->address->city, $result[0]['cmsAddress']->city);
795		$this->assertEquals($this->fixtures[1]->address->city, $result[1]['cmsAddress']->city);
796		$this->assertEquals($this->fixtures[2]->address->city, $result[2]['cmsAddress']->city);
797
798		$this->assertEquals($this->fixtures[0]->address->country, $result[0]['cmsAddress']->country);
799		$this->assertEquals($this->fixtures[1]->address->country, $result[1]['cmsAddress']->country);
800		$this->assertEquals($this->fixtures[2]->address->country, $result[2]['cmsAddress']->country);
801
802		$this->assertEquals($this->fixtures[0]->status,$result[0]['cmsUserStatus']);
803		$this->assertEquals($this->fixtures[1]->status,$result[1]['cmsUserStatus']);
804		$this->assertEquals($this->fixtures[2]->status,$result[2]['cmsUserStatus']);
805		}
806
807		public function testShouldSupportMultipleNewOperatorsAndSingleScalarWithAndWithoutAliases()
808		{
		@@ 807-862 (lines=56) @@
804		$this->assertEquals($this->fixtures[2]->status,$result[2]['cmsUserStatus']);
805		}
806
807		public function testShouldSupportMultipleNewOperatorsAndSingleScalarWithAndWithoutAliases()
808		{
809		$dql = "
810		SELECT
811		new CmsUserDTO(
812		u.name,
813		e.email
814		) as cmsUser,
815		new CmsAddressDTO(
816		a.country,
817		a.city
818		),
819		u.status
820		FROM
821		Doctrine\Tests\Models\CMS\CmsUser u
822		JOIN
823		u.email e
824		JOIN
825		u.address a
826		ORDER BY
827		u.name";
828
829		$query = $this->_em->createQuery($dql);
830		$result = $query->getResult();
831
832		$this->assertCount(3, $result);
833
834		$this->assertInstanceOf(CmsUserDTO::class, $result[0]['cmsUser']);
835		$this->assertInstanceOf(CmsUserDTO::class, $result[1]['cmsUser']);
836		$this->assertInstanceOf(CmsUserDTO::class, $result[2]['cmsUser']);
837
838		$this->assertInstanceOf(CmsAddressDTO::class, $result[0][0]);
839		$this->assertInstanceOf(CmsAddressDTO::class, $result[1][0]);
840		$this->assertInstanceOf(CmsAddressDTO::class, $result[2][0]);
841
842		$this->assertEquals($this->fixtures[0]->name, $result[0]['cmsUser']->name);
843		$this->assertEquals($this->fixtures[1]->name, $result[1]['cmsUser']->name);
844		$this->assertEquals($this->fixtures[2]->name, $result[2]['cmsUser']->name);
845
846		$this->assertEquals($this->fixtures[0]->email->email, $result[0]['cmsUser']->email);
847		$this->assertEquals($this->fixtures[1]->email->email, $result[1]['cmsUser']->email);
848		$this->assertEquals($this->fixtures[2]->email->email, $result[2]['cmsUser']->email);
849
850
851		$this->assertEquals($this->fixtures[0]->address->city, $result[0][0]->city);
852		$this->assertEquals($this->fixtures[1]->address->city, $result[1][0]->city);
853		$this->assertEquals($this->fixtures[2]->address->city, $result[2][0]->city);
854
855		$this->assertEquals($this->fixtures[0]->address->country, $result[0][0]->country);
856		$this->assertEquals($this->fixtures[1]->address->country, $result[1][0]->country);
857		$this->assertEquals($this->fixtures[2]->address->country, $result[2][0]->country);
858
859		$this->assertEquals($this->fixtures[0]->status,$result[0]['status']);
860		$this->assertEquals($this->fixtures[1]->status,$result[1]['status']);
861		$this->assertEquals($this->fixtures[2]->status,$result[2]['status']);
862		}
863
864		public function testShouldSupportMultipleNewOperatorsAndMultipleScalars()
865		{

doctrine / orm

Code Duplication Length = 56-56 lines in 3 locations

tests/Doctrine/Tests/ORM/Functional/NewOperatorTest.php 3 locations