9.5/_query_parser_test_8php_source.html

<?php

namespace ‪TYPO3\CMS\Extbase\Tests\Functional\Persistence;


/*

 * This file is part of the TYPO3 CMS project.

 *

 * It is free software; you can redistribute it and/or modify it under

 * the terms of the GNU General Public License, either version 2

 * of the License, or any later version.

 *

 * For the full copyright and license information, please read the

 * LICENSE.txt file that was distributed with this source code.

 *

 * The TYPO3 project - inspiring people to share!

 */


use ‪TYPO3\CMS\Core\Utility\GeneralUtility;


class ‪QueryParserTest extends \TYPO3\TestingFramework\Core\Functional\FunctionalTestCase

{


    protected ‪$testExtensionsToLoad = ['typo3/sysext/extbase/Tests/Functional/Fixtures/Extensions/blog_example'];


    protected ‪$coreExtensionsToLoad = ['extbase', 'fluid'];


    protected ‪$objectManager;


    protected ‪$blogRepository;


    protected function ‪setUp()

    {

        parent::setUp();


        $this->importDataSet(ORIGINAL_ROOT . 'typo3/sysext/extbase/Tests/Functional/Persistence/Fixtures/categories.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/blogs.xml');

        $this->importDataSet(ORIGINAL_ROOT . 'typo3/sysext/extbase/Tests/Functional/Persistence/Fixtures/tags-mm.xml');

        $this->importDataSet(ORIGINAL_ROOT . 'typo3/sysext/extbase/Tests/Functional/Persistence/Fixtures/persons.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/post-tag-mm.xml');

        $this->importDataSet(ORIGINAL_ROOT . 'typo3/sysext/extbase/Tests/Functional/Persistence/Fixtures/category-mm.xml');

        $this->importDataSet(ORIGINAL_ROOT . 'typo3/sysext/extbase/Tests/Functional/Persistence/Fixtures/fe_users.xml');

        $this->importDataSet(ORIGINAL_ROOT . 'typo3/sysext/extbase/Tests/Functional/Persistence/Fixtures/fe_groups.xml');


        $this->objectManager = GeneralUtility::makeInstance(\‪TYPO3\CMS\‪Extbase\Object\ObjectManager::class);

        $this->blogRepository = $this->objectManager->get(\‪ExtbaseTeam\BlogExample\Domain\Repository\BlogRepository::class);

    }


    public function ‪queryWithMultipleRelationsToIdenticalTablesReturnsExpectedResultForOrQuery()

    {

        $postRepository = $this->objectManager->get('ExtbaseTeam\\BlogExample\\Domain\\Repository\\PostRepository');

        $query = $postRepository->createQuery();

        $query->matching(

            $query->logicalAnd(

                $query->equals('blog', 3),

                $query->logicalOr(

                    $query->equals('tags.name', 'Tag12'),

                    $query->equals('author.tags.name', 'TagForAuthor1')

                )

            )

        );


        $result = $query->execute()->toArray();

        $this->assertEquals(3, count($result));

    }


    public function ‪queryWithRelationHasAndBelongsToManyReturnsExpectedResult()

    {

        $postRepository = $this->objectManager->get('ExtbaseTeam\\BlogExample\\Domain\\Repository\\PostRepository');

        $query = $postRepository->createQuery();

        $query->matching(

            $query->equals('tags.name', 'Tag12')

        );

        $result = $query->execute()->toArray();

        $this->assertEquals(2, count($result));

    }


    public function ‪queryWithRelationHasManyWithoutParentKeyFieldNameReturnsExpectedResult()

    {

        $frontendUserRepository = $this->objectManager->get('TYPO3\\CMS\\Extbase\\Domain\\Repository\\FrontendUserRepository');

        $query = $frontendUserRepository->createQuery();

        $query->matching(

            $query->equals('usergroup.title', 'Group A')

        );


        $result = $query->execute()->toArray();

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

    }


    public function ‪queryWithRelationHasOneAndHasAndBelongsToManyWithoutParentKeyFieldNameReturnsExpectedResult()

    {

        $postRepository = $this->objectManager->get('ExtbaseTeam\\BlogExample\\Domain\\Repository\\PostRepository');

        $query = $postRepository->createQuery();

        $query->matching(

            $query->equals('author.firstname', 'Author')

        );

        $result = $query->execute()->toArray();

        // there are 16 post in total, 2 without author, 1 hidden, 1 deleted => 12 posts

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

    }


    public function ‪orReturnsExpectedResult()

    {

        $postRepository = $this->objectManager->get('ExtbaseTeam\\BlogExample\\Domain\\Repository\\PostRepository');

        $query = $postRepository->createQuery();

        $query->matching(

            $query->logicalOr(

                $query->equals('tags.name', 'Tag12'),

                $query->equals('tags.name', 'Tag11')

            )

        );

        $result = $query->execute()->toArray();

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

    }


    public function ‪queryWithMultipleRelationsToIdenticalTablesReturnsExpectedResultForAndQuery()

    {

        $postRepository = $this->objectManager->get('ExtbaseTeam\\BlogExample\\Domain\\Repository\\PostRepository');

        $query = $postRepository->createQuery();

        $query->matching(

            $query->logicalAnd(

                $query->equals('blog', 3),

                $query->equals('tags.name', 'Tag12'),

                $query->equals('author.tags.name', 'TagForAuthor1')

            )

        );

        $result = $query->execute()->toArray();

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

    }


    public function ‪queryWithFindInSetReturnsExpectedResult()

    {

        $frontendUserRepository = $this->objectManager->get('TYPO3\\CMS\\Extbase\\Domain\\Repository\\FrontendUserRepository');

        $query = $frontendUserRepository->createQuery();


        $result = $query->matching($query->contains('usergroup', 1))

            ->execute();

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

    }


    public function ‪queryForPostWithCategoriesReturnsPostWithCategories()

    {

        $postRepository = $this->objectManager->get('ExtbaseTeam\\BlogExample\\Domain\\Repository\\PostRepository');

        $query = $postRepository->createQuery();

        $post = $query->matching($query->equals('uid', 1))->execute()->current();

        $this->assertCount(3, $post->getCategories());

    }

}