Doctrine\Tests\ORM\Tools\Pagination\RemoveUselessLeftJoinWalkerTest

Complexity

Total Complexity

4

Size/Duplication

Total Lines	83
Duplicated Lines	0 %

Importance

Changes	1
Bugs	0	Features	0

4 Methods

Rating	Name	Duplication	Size	Complexity
A	testOrderByLeftJoinsAreKept()	0	18	1
A	testWhereLeftJoinsAreKept()	0	18	1
A	testMultipleWhereLeftJoinsAreKept()	0	18	1
A	testUselessLeftJoinsAreRemoved()	0	18	1

<?php

namespace Doctrine\Tests\ORM\Tools\Pagination;

use Doctrine\ORM\Query;
use Doctrine\ORM\Tools\Pagination\LimitSubqueryWalker;
use Doctrine\ORM\Tools\Pagination\RemoveUselessLeftJoinsWalker;

/**
 * @group DDC-1613
 */
class RemoveUselessLeftJoinWalkerTest extends PaginationTestCase
{
    public function testUselessLeftJoinsAreRemoved()
    {
        $dql        = <<<DQL
SELECT p, c, a FROM Doctrine\Tests\ORM\Tools\Pagination\MyBlogPost p 
LEFT JOIN p.category c 
LEFT JOIN p.author a
WHERE p.id IN (SELECT DISTINCT(p2.id) FROM Doctrine\Tests\ORM\Tools\Pagination\MyBlogPost p2 
LEFT JOIN p2.category c2 
LEFT JOIN p2.author a2)
DQL;
        $query      = $this->entityManager->createQuery($dql);
        $limitQuery = clone $query;

        $limitQuery->setHint(Query::HINT_CUSTOM_TREE_WALKERS, [RemoveUselessLeftJoinsWalker::class]);

        $this->assertEquals(
            "SELECT m0_.id AS id_0, m0_.title AS title_1, c1_.id AS id_2, a2_.id AS id_3, a2_.name AS name_4, m0_.author_id AS author_id_5, m0_.category_id AS category_id_6 FROM MyBlogPost m0_ WHERE m0_.id IN (SELECT DISTINCT (m3_.id) FROM MyBlogPost m3_)",
            $limitQuery->getSQL()
        );
    }

    public function testOrderByLeftJoinsAreKept()
    {
        $dql        = <<<DQL
SELECT p, c, a FROM Doctrine\Tests\ORM\Tools\Pagination\MyBlogPost p 
LEFT JOIN p.category c 
LEFT JOIN p.author a
WHERE p.id IN (SELECT DISTINCT(p2.id) FROM Doctrine\Tests\ORM\Tools\Pagination\MyBlogPost p2 
LEFT JOIN p2.category c2 
LEFT JOIN p2.author a2 ORDER BY a2.id DESC)
DQL;
        $query      = $this->entityManager->createQuery($dql);
        $limitQuery = clone $query;

        $limitQuery->setHint(Query::HINT_CUSTOM_TREE_WALKERS, [RemoveUselessLeftJoinsWalker::class]);

        $this->assertEquals(
            "SELECT m0_.id AS id_0, m0_.title AS title_1, c1_.id AS id_2, a2_.id AS id_3, a2_.name AS name_4, m0_.author_id AS author_id_5, m0_.category_id AS category_id_6 FROM MyBlogPost m0_ WHERE m0_.id IN (SELECT DISTINCT (m3_.id) FROM MyBlogPost m3_ LEFT JOIN Author a4_ ON m3_.author_id = a4_.id ORDER BY a4_.id DESC)",
            $limitQuery->getSQL()
        );
    }

    public function testWhereLeftJoinsAreKept()
    {
        $dql        = <<<DQL
SELECT p, c, a FROM Doctrine\Tests\ORM\Tools\Pagination\MyBlogPost p 
LEFT JOIN p.category c 
LEFT JOIN p.author a
WHERE p.id IN (SELECT DISTINCT(p2.id) FROM Doctrine\Tests\ORM\Tools\Pagination\MyBlogPost p2 
LEFT JOIN p2.category c2 
LEFT JOIN p2.author a2 WHERE 2 = a2.id)
DQL;
        $query      = $this->entityManager->createQuery($dql);
        $limitQuery = clone $query;

        $limitQuery->setHint(Query::HINT_CUSTOM_TREE_WALKERS, [RemoveUselessLeftJoinsWalker::class]);

        $this->assertEquals(
            "SELECT m0_.id AS id_0, m0_.title AS title_1, c1_.id AS id_2, a2_.id AS id_3, a2_.name AS name_4, m0_.author_id AS author_id_5, m0_.category_id AS category_id_6 FROM MyBlogPost m0_ WHERE m0_.id IN (SELECT DISTINCT (m3_.id) FROM MyBlogPost m3_ LEFT JOIN Author a4_ ON m3_.author_id = a4_.id WHERE 2 = a4_.id)",
            $limitQuery->getSQL()
        );
    }

    public function testMultipleWhereLeftJoinsAreKept()
    {
        $dql        = <<<DQL
SELECT p, c, a FROM Doctrine\Tests\ORM\Tools\Pagination\MyBlogPost p 
LEFT JOIN p.category c 
LEFT JOIN p.author a
WHERE p.id IN (SELECT DISTINCT(p2.id) FROM Doctrine\Tests\ORM\Tools\Pagination\MyBlogPost p2 
LEFT JOIN p2.category c2 
LEFT JOIN p2.author a2 WHERE 2 = a2.id AND c2.id = 1)
DQL;
        $query      = $this->entityManager->createQuery($dql);
        $limitQuery = clone $query;

        $limitQuery->setHint(Query::HINT_CUSTOM_TREE_WALKERS, [RemoveUselessLeftJoinsWalker::class]);

        $this->assertEquals(
            "SELECT m0_.id AS id_0, m0_.title AS title_1, c1_.id AS id_2, a2_.id AS id_3, a2_.name AS name_4, m0_.author_id AS author_id_5, m0_.category_id AS category_id_6 FROM MyBlogPost m0_ WHERE m0_.id IN (SELECT DISTINCT (m3_.id) FROM MyBlogPost m3_ LEFT JOIN Category c4_ ON m3_.category_id = c4_.id LEFT JOIN Author a5_ ON m3_.author_id = a5_.id WHERE 2 = a5_.id AND c4_.id = 1)",
            $limitQuery->getSQL()
        );
    }
}