Doctrine\Tests\ORM\Functional\Ticket\GH7805Test

Complexity

Total Complexity

3

Size/Duplication

Total Lines	46
Duplicated Lines	0 %

Importance

Changes	3
Bugs	0	Features	0

3 Methods

Rating	Name	Duplication	Size	Complexity
A	setUp()	0	4	1
A	testPaginationWithFunction()	0	18	1
A	testPaginationWithSimpleArithmetic()	0	18	1

<?php

declare(strict_types=1);

namespace Doctrine\Tests\ORM\Functional\Ticket;

use Doctrine\ORM\Tools\Pagination\Paginator;
use Doctrine\Tests\Models\CMS\CmsArticle;
use Doctrine\Tests\OrmFunctionalTestCase;
use function count;
use function iterator_to_array;

class GH7805Test extends OrmFunctionalTestCase
{
    protected function setUp()
    {
        $this->useModelSet('cms');
        parent::setUp();
    }

    public function testPaginationWithFunction()
    {
        $article = new CmsArticle();

        $article->topic   = 'Test ORDER BY with Function';
        $article->text    = 'This test fails on MySQL if ORDER BY part is not added to SELECT.';
        $article->version = 1;

        $this->_em->persist($article);
        $this->_em->flush();

        $query = $this->_em->createQuery('SELECT a FROM Doctrine\Tests\Models\CMS\CmsArticle a ORDER BY SQRT(a.version) ASC');
        $query->setFirstResult(0);
        $query->setMaxResults(1);

        $paginator = new Paginator($query, true);
        $paginator->setUseOutputWalkers(false);
        $this->assertEquals(1, count(iterator_to_array($paginator)));
    }

    public function testPaginationWithSimpleArithmetic()
    {
        $article = new CmsArticle();

        $article->topic   = 'Test ORDER BY with SimpleArithmetic';
        $article->text    = 'This test fails on MySQL if ORDER BY part is not added to SELECT.';
        $article->version = 1;

        $this->_em->persist($article);
        $this->_em->flush();

        $query = $this->_em->createQuery('SELECT a FROM Doctrine\Tests\Models\CMS\CmsArticle a ORDER BY a.version + 0 ASC');
        $query->setFirstResult(0);
        $query->setMaxResults(1);

        $paginator = new Paginator($query, true);
        $paginator->setUseOutputWalkers(false);
        $this->assertEquals(1, count(iterator_to_array($paginator)));
    }
}