CountTest.php

Go to the documentation of this file.

<?php
namespace TYPO3\CMS\Extbase\Tests\Functional\Persistence;

use TYPO3\CMS\Core\Utility\GeneralUtility;
use TYPO3\CMS\Extbase\Persistence\ObjectStorage;

class CountTest extends \TYPO3\CMS\Core\Tests\FunctionalTestCase {

    protected $numberOfRecordsInFixture = 11;

    protected $persistentManager;

    protected $testExtensionsToLoad = array('typo3/sysext/extbase/Tests/Functional/Fixtures/Extensions/blog_example');

    protected $coreExtensionsToLoad = array('extbase', 'fluid');

    protected $objectManager;

    protected $blogRepository;

    public function setUp() {
        parent::setUp();

        $this->importDataSet(ORIGINAL_ROOT . 'typo3/sysext/core/Tests/Functional/Fixtures/pages.xml');
        $this->importDataSet(ORIGINAL_ROOT . 'typo3/sysext/extbase/Tests/Functional/Persistence/Fixtures/blogs.xml');
        $this->importDataSet(ORIGINAL_ROOT . 'typo3/sysext/extbase/Tests/Functional/Persistence/Fixtures/posts.xml');
        $this->importDataSet(ORIGINAL_ROOT . 'typo3/sysext/extbase/Tests/Functional/Persistence/Fixtures/tags.xml');
        $this->importDataSet(ORIGINAL_ROOT . 'typo3/sysext/extbase/Tests/Functional/Persistence/Fixtures/post-tag-mm.xml');

        $this->objectManager = GeneralUtility::makeInstance('TYPO3\\CMS\\Extbase\\Object\\ObjectManager');
        $this->persistentManager = $this->objectManager->get('TYPO3\\CMS\\Extbase\\Persistence\\Generic\\PersistenceManager');
        $this->postRepository = $this->objectManager->get('ExtbaseTeam\\BlogExample\\Domain\\Repository\\PostRepository');
    }

    public function simpleCountTest() {
        $query = $this->postRepository->createQuery();
        $this->assertSame($this->numberOfRecordsInFixture, $query->count());
    }

    public function offsetCountTest() {
        $query = $this->postRepository->createQuery();

        $query->setOffset(6);

        $this->assertSame(($this->numberOfRecordsInFixture - 6), $query->count());
    }

    public function exceedingOffsetCountTest() {
        $query = $this->postRepository->createQuery();

        $query->setOffset(($this->numberOfRecordsInFixture + 5));

        $this->assertSame(0, $query->count());
    }

    public function limitCountTest() {
        $query = $this->postRepository->createQuery();

        $query->setLimit(4);

        $this->assertSame(4, $query->count());
    }

    public function limitAndOffsetCountTest() {
        $query = $this->postRepository->createQuery();

        $query
            ->setOffset(($this->numberOfRecordsInFixture - 3))
            ->setLimit(4);

        $this->assertSame(3, $query->count());
    }

    public function inConstraintCountTest() {
        $query = $this->postRepository->createQuery();

        $query->matching(
            $query->in('uid', array(1,2,3))
        );

        $this->assertSame(3, $query->count());
    }

    public function subpropertyJoinCountTest() {
        $query = $this->postRepository->createQuery();

        $query->matching(
            $query->equals('blog.title', 'Blog1')
        );

        $this->assertSame(10, $query->count());
    }

    public function subpropertyInMultipleLeftJoinCountTest() {
        $query = $this->postRepository->createQuery();

        $query->matching(
            $query->logicalOr(
                $query->equals('tags.uid', 1),
                $query->equals('tags.uid', 2)
            )
        );

        $this->assertSame(10, $query->count());
    }
}