QueryBuilderFactoryTest::testCanBuildQueriesUsingOrOperator() - Code Metrics - Inspection of "Merge tag 'v2.2.3'" - studiomado/query-bundle - Measure and Improve Code Quality continuously with Scrutinizer

Passed

Push — master ( 243f13...a9f992 )

by Simone

created 2018-01-07 01:53 UTC

testCanBuildQueriesUsingOrOperator() B

↳ Parent: QueryBuilderFactoryTest

Complexity

Conditions	1
Paths	1

Size

Total Lines	26
Code Lines	22

Duplication

Lines	0
Ratio	0 %

Importance

Changes	2
Bugs	1	Features	0

Metric	Value
c	2
b	1
f	0
dl	0
loc	26
rs	8.8571
cc	1
eloc	22
nc	1
nop	0

<?php

namespace Mado\QueryBundle\Tests\Objects;

use Mado\QueryBundle\Queries\QueryBuilderFactory;
use PHPUnit\Framework\TestCase;

class QueryBuilderFactoryTest extends TestCase
{
    public function setUp()
    {
        $this->manager = \Doctrine\ORM\EntityManager::create(array(
            'driver' => 'pdo_sqlite',
            'path' => __DIR__ . '/../../data/db.sqlite',
        ),
        \Doctrine\ORM\Tools\Setup::createAnnotationMetadataConfiguration(
            array(__DIR__."/src"),
            true
        ));
    }

    public function testProvideOneSingleResult()
    {
        $queryBuilderFactory = new QueryBuilderFactory($this->manager);
        $queryBuilderFactory->setFields([ 'id' ]);
        $queryBuilderFactory->setAndFilters([ 'id|eq' => 33 ]);
        $queryBuilderFactory->createQueryBuilder(MySimpleEntity::class, 'e');
        $queryBuilderFactory->filter();

        $doctrineQueryBuilder = $queryBuilderFactory->getQueryBuilder();
        $doctrineQueryBuilder->setMaxResults(1);

        $this->assertEquals(
            "SELECT m0_.id AS id_0 FROM MySimpleEntity m0_ WHERE m0_.id = ? LIMIT 1",
            $doctrineQueryBuilder->getQuery()->getSql()
        );
    }

    public function testSampleQueryMakedWithQueryBuilderFactory()
    {
        $queryBuilderFactory = new QueryBuilderFactory($this->manager);
        $queryBuilderFactory->setFields([ 'id' ]);
        $queryBuilderFactory->setAndFilters([ 'id|eq' => 33 ]);
        $queryBuilderFactory->createQueryBuilder(MySimpleEntity::class, 'e');
        $queryBuilderFactory->filter();

        $this->assertEquals(
            "SELECT m0_.id AS id_0 FROM MySimpleEntity m0_ WHERE m0_.id = ?",
            $queryBuilderFactory->getQueryBuilder()->getQuery()->getSql()
        );

        $this->assertEquals(
            "SELECT e FROM Mado\QueryBundle\Tests\Objects\MySimpleEntity e WHERE e.id = :field_id",
            $queryBuilderFactory->getQueryBuilder()->getQuery()->getDql()
        );
    }

    public function testOneToManyQueryMakedHandly()
    {
        $queryBuilderFactory = new QueryBuilderFactory($this->manager);
        $queryBuilderFactory->setFields([ 'id' ]);
        $queryBuilderFactory->setRel([ 'group' ]);
        $queryBuilderFactory->setAndFilters([
            '_embedded.group.name|contains|1' => 'ad',
            '_embedded.group.name|contains|2' => 'ns',
            '_embedded.group.name|contains|3' => 'dm',
            '_embedded.group.name|contains|4' => 'mi',
        ]);
        $queryBuilderFactory->createQueryBuilder(User::class, 'e');
        $queryBuilderFactory->filter();

        $this->assertEquals(
            "SELECT" .
            " u0_.id AS id_0," .
            " u0_.username AS username_1," .
            " u0_.group_id AS group_id_2 " .
            "FROM User u0_ " .
            "INNER JOIN Group g1_ ON u0_.group_id = g1_.id " .
            "WHERE g1_.name LIKE ? " .
            "AND g1_.name LIKE ? " .
            "AND g1_.name LIKE ? " .
            "AND g1_.name LIKE ?",
            $queryBuilderFactory->getQueryBuilder()->getQuery()->getSql()
        );
    }

    public function testFiltersMustContainsAlsoFieldEquality()
    {
        $factory = new QueryBuilderFactory($this->manager);

        $validFilters = [
            'eq',
            'neq',
            'gt',
            'gte',
            'lt',
            'lte',
            'startswith',
            'contains',
            'notcontains',
            'endswith',
            'list',
            'nlist',
            'field_eq',
        ];

        $this->assertEquals(
            $validFilters,
            $factory->getAvailableFilters()
        );
    }

    public function testCanBuildQueriesUsingOrOperator()
    {
        $queryBuilderFactory = new QueryBuilderFactory($this->manager);
        $queryBuilderFactory->setFields([ 'id' ]);
        $queryBuilderFactory->setRel([ 'group' ]);
        $queryBuilderFactory->setOrFilters([
            '_embedded.group.name|contains|1' => 'ad',
            '_embedded.group.name|contains|2' => 'ns',
            '_embedded.group.name|contains|3' => 'dm',
            '_embedded.group.name|contains|4' => 'mi',
        ]);
        $queryBuilderFactory->createQueryBuilder(User::class, 'e');
        $queryBuilderFactory->filter();

        $this->assertEquals(
            "SELECT" .
            " u0_.id AS id_0," .
            " u0_.username AS username_1," .
            " u0_.group_id AS group_id_2 " .
            "FROM User u0_ " .
            "INNER JOIN Group g1_ ON u0_.group_id = g1_.id " .
            "WHERE g1_.name LIKE ? " .
            "OR g1_.name LIKE ? " .
            "OR g1_.name LIKE ? " .
            "OR g1_.name LIKE ?",
            $queryBuilderFactory->getQueryBuilder()->getQuery()->getSql()
        );
    }

    /** @expectedException \Mado\QueryBundle\Exceptions\MissingFiltersException */
    public function testThrowMissingFiltersExceptionsWheneverFiltersAreMissing()
    {
        $queryBuilderFactory = new QueryBuilderFactory($this->manager);
        $queryBuilderFactory->filter();
    }
}

/** @Entity() */
class MySimpleEntity
{
    /** @Id @Column(type="integer") */
    private $id;
}

/** @Entity() */
class User
{
    /** @Id @Column(type="integer") */
    private $id;
    /** @Column(type="string") */
    private $username;
    /** @ManyToOne(targetEntity="Group", inversedBy="member") */
    private $group;
}

/** @Entity() */
class Group
{
    /** @Id @Column(type="integer") */
    private $id;
    /** @Column(type="string") */
    private $name;
    /** @OneToMany(targetEntity="User", mappedBy="member") */
    private $members;
}


1			<?php
2
3			namespace Mado\QueryBundle\Tests\Objects;
4
5			use Mado\QueryBundle\Queries\QueryBuilderFactory;
6			use PHPUnit\Framework\TestCase;
7
8			class QueryBuilderFactoryTest extends TestCase
9			{
10			public function setUp()
11			{
12			$this->manager = \Doctrine\ORM\EntityManager::create(array(
13			'driver' => 'pdo_sqlite',
14			'path' => __DIR__ . '/../../data/db.sqlite',
15			),
16			\Doctrine\ORM\Tools\Setup::createAnnotationMetadataConfiguration(
17			array(__DIR__."/src"),
18			true
19			));
20			}
21
22			public function testProvideOneSingleResult()
23			{
24			$queryBuilderFactory = new QueryBuilderFactory($this->manager);
25			$queryBuilderFactory->setFields([ 'id' ]);
26			$queryBuilderFactory->setAndFilters([ 'id\|eq' => 33 ]);
27			$queryBuilderFactory->createQueryBuilder(MySimpleEntity::class, 'e');
28			$queryBuilderFactory->filter();
29
30			$doctrineQueryBuilder = $queryBuilderFactory->getQueryBuilder();
31			$doctrineQueryBuilder->setMaxResults(1);
32
33			$this->assertEquals(
34			"SELECT m0_.id AS id_0 FROM MySimpleEntity m0_ WHERE m0_.id = ? LIMIT 1",
35			$doctrineQueryBuilder->getQuery()->getSql()
36			);
37			}
38
39			public function testSampleQueryMakedWithQueryBuilderFactory()
40			{
41			$queryBuilderFactory = new QueryBuilderFactory($this->manager);
42			$queryBuilderFactory->setFields([ 'id' ]);
43			$queryBuilderFactory->setAndFilters([ 'id\|eq' => 33 ]);
44			$queryBuilderFactory->createQueryBuilder(MySimpleEntity::class, 'e');
45			$queryBuilderFactory->filter();
46
47			$this->assertEquals(
48			"SELECT m0_.id AS id_0 FROM MySimpleEntity m0_ WHERE m0_.id = ?",
49			$queryBuilderFactory->getQueryBuilder()->getQuery()->getSql()
50			);
51
52			$this->assertEquals(
53			"SELECT e FROM Mado\QueryBundle\Tests\Objects\MySimpleEntity e WHERE e.id = :field_id",
54			$queryBuilderFactory->getQueryBuilder()->getQuery()->getDql()
55			);
56			}
57
58			public function testOneToManyQueryMakedHandly()
59			{
60			$queryBuilderFactory = new QueryBuilderFactory($this->manager);
61			$queryBuilderFactory->setFields([ 'id' ]);
62			$queryBuilderFactory->setRel([ 'group' ]);
63			$queryBuilderFactory->setAndFilters([
64			'_embedded.group.name\|contains\|1' => 'ad',
65			'_embedded.group.name\|contains\|2' => 'ns',
66			'_embedded.group.name\|contains\|3' => 'dm',
67			'_embedded.group.name\|contains\|4' => 'mi',
68			]);
69			$queryBuilderFactory->createQueryBuilder(User::class, 'e');
70			$queryBuilderFactory->filter();
71
72			$this->assertEquals(
73			"SELECT" .
74			" u0_.id AS id_0," .
75			" u0_.username AS username_1," .
76			" u0_.group_id AS group_id_2 " .
77			"FROM User u0_ " .
78			"INNER JOIN Group g1_ ON u0_.group_id = g1_.id " .
79			"WHERE g1_.name LIKE ? " .
80			"AND g1_.name LIKE ? " .
81			"AND g1_.name LIKE ? " .
82			"AND g1_.name LIKE ?",
83			$queryBuilderFactory->getQueryBuilder()->getQuery()->getSql()
84			);
85			}
86
87			public function testFiltersMustContainsAlsoFieldEquality()
88			{
89			$factory = new QueryBuilderFactory($this->manager);
90
91			$validFilters = [
92			'eq',
93			'neq',
94			'gt',
95			'gte',
96			'lt',
97			'lte',
98			'startswith',
99			'contains',
100			'notcontains',
101			'endswith',
102			'list',
103			'nlist',
104			'field_eq',
105			];
106
107			$this->assertEquals(
108			$validFilters,
109			$factory->getAvailableFilters()
110			);
111			}
112
113			public function testCanBuildQueriesUsingOrOperator()
114			{
115			$queryBuilderFactory = new QueryBuilderFactory($this->manager);
116			$queryBuilderFactory->setFields([ 'id' ]);
117			$queryBuilderFactory->setRel([ 'group' ]);
118			$queryBuilderFactory->setOrFilters([
119			'_embedded.group.name\|contains\|1' => 'ad',
120			'_embedded.group.name\|contains\|2' => 'ns',
121			'_embedded.group.name\|contains\|3' => 'dm',
122			'_embedded.group.name\|contains\|4' => 'mi',
123			]);
124			$queryBuilderFactory->createQueryBuilder(User::class, 'e');
125			$queryBuilderFactory->filter();
126
127			$this->assertEquals(
128			"SELECT" .
129			" u0_.id AS id_0," .
130			" u0_.username AS username_1," .
131			" u0_.group_id AS group_id_2 " .
132			"FROM User u0_ " .
133			"INNER JOIN Group g1_ ON u0_.group_id = g1_.id " .
134			"WHERE g1_.name LIKE ? " .
135			"OR g1_.name LIKE ? " .
136			"OR g1_.name LIKE ? " .
137			"OR g1_.name LIKE ?",
138			$queryBuilderFactory->getQueryBuilder()->getQuery()->getSql()
139			);
140			}
141
142			/** @expectedException \Mado\QueryBundle\Exceptions\MissingFiltersException */
143			public function testThrowMissingFiltersExceptionsWheneverFiltersAreMissing()
144			{
145			$queryBuilderFactory = new QueryBuilderFactory($this->manager);
146			$queryBuilderFactory->filter();
147			}
148			}
149
150			/** @Entity() */
151			class MySimpleEntity
152			{
153			/** @Id @Column(type="integer") */
154			private $id;
155			}
156
157			/** @Entity() */
158			class User
159			{
160			/** @Id @Column(type="integer") */
161			private $id;
162			/** @Column(type="string") */
163			private $username;
164			/** @ManyToOne(targetEntity="Group", inversedBy="member") */
165			private $group;
166			}
167
168			/** @Entity() */
169			class Group
170			{
171			/** @Id @Column(type="integer") */
172			private $id;
173			/** @Column(type="string") */
174			private $name;
175			/** @OneToMany(targetEntity="User", mappedBy="member") */
176			private $members;
177			}
178

studiomado / query-bundle

GitHub Access Token became invalid

Push — master ( 243f13...a9f992 )

testCanBuildQueriesUsingOrOperator() B

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like