QueryTest.php

Go to the documentation of this file.

<?php
 
/*
 * 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!
 */
 
namespace ‪TYPO3\CMS\Extbase\Tests\Unit\Persistence\Generic;
 
use Prophecy\Argument;
use ‪TYPO3\CMS\Extbase\Object\ObjectManager;
use ‪TYPO3\CMS\Extbase\Persistence\Generic\Mapper\DataMapFactory;
use ‪TYPO3\CMS\Extbase\Persistence\Generic\Qom\Comparison;
use ‪TYPO3\CMS\Extbase\Persistence\Generic\Qom\LogicalAnd;
use ‪TYPO3\CMS\Extbase\Persistence\Generic\Qom\LogicalOr;
use ‪TYPO3\CMS\Extbase\Persistence\Generic\Qom\PropertyValue;
use ‪TYPO3\CMS\Extbase\Persistence\Generic\Qom\PropertyValueInterface;
use ‪TYPO3\CMS\Extbase\Persistence\Generic\Qom\QueryObjectModelFactory;
use ‪TYPO3\CMS\Extbase\Persistence\Generic\Query;
use ‪TYPO3\CMS\Extbase\Persistence\Generic\QueryResult;
use ‪TYPO3\CMS\Extbase\Persistence\Generic\QuerySettingsInterface;
use ‪TYPO3\CMS\Extbase\Persistence\PersistenceManagerInterface;
use ‪TYPO3\CMS\Extbase\Persistence\QueryResultInterface;
use TYPO3\TestingFramework\Core\Unit\UnitTestCase;
 
class ‪QueryTest extends UnitTestCase
{
    protected ‪$query;
 
    protected ‪$querySettings;
 
    protected ‪$persistenceManager;
 
    protected ‪$dataMapFactory;
 
    protected function ‪setUp(): void
    {
        parent::setUp();
        $this->query = $this->getAccessibleMock(Query::class, ['getSelectorName'], ['someType']);
        $this->querySettings = $this->createMock(QuerySettingsInterface::class);
        $this->query->_set('querySettings', $this->querySettings);
        $this->persistenceManager = $this->createMock(PersistenceManagerInterface::class);
        $this->query->_set('persistenceManager', $this->persistenceManager);
        $this->dataMapFactory = $this->createMock(DataMapFactory::class);
        $this->query->_set('dataMapFactory', $this->dataMapFactory);
    }
 
    public function ‪executeReturnsQueryResultInstanceAndInjectsItself()
    {
        $objectManager = $this->createMock(ObjectManager::class);
        $this->query->_set('objectManager', $objectManager);
        $queryResult = $this->createMock(QueryResult::class);
        $objectManager->expects(self::once())->method('get')->with(QueryResultInterface::class, $this->query)->willReturn($queryResult);
        $actualResult = $this->query->execute();
        self::assertSame($queryResult, $actualResult);
    }
 
    public function ‪executeReturnsRawObjectDataIfReturnRawQueryResultIsSet()
    {
        $this->persistenceManager->expects(self::once())->method('getObjectDataByQuery')->with($this->query)->willReturn('rawQueryResult');
        $expectedResult = 'rawQueryResult';
        $actualResult = $this->query->execute(true);
        self::assertEquals($expectedResult, $actualResult);
    }
 
    public function ‪setLimitAcceptsOnlyIntegers()
    {
        $this->expectException(\InvalidArgumentException::class);
        $this->expectExceptionCode(1245071870);
        $this->query->setLimit(1.5);
    }
 
    public function ‪setLimitRejectsIntegersLessThanOne()
    {
        $this->expectException(\InvalidArgumentException::class);
        $this->expectExceptionCode(1245071870);
        $this->query->setLimit(0);
    }
 
    public function ‪setOffsetAcceptsOnlyIntegers()
    {
        $this->expectException(\InvalidArgumentException::class);
        $this->expectExceptionCode(1245071872);
        $this->query->setOffset(1.5);
    }
 
    public function ‪setOffsetRejectsIntegersLessThanZero()
    {
        $this->expectException(\InvalidArgumentException::class);
        $this->expectExceptionCode(1245071872);
        $this->query->setOffset(-1);
    }
 
    public function ‪equalsForCaseSensitiveFalseLowercasesOperandProvider()
    {
        return [
            'Polish alphabet' => ['name', 'ĄĆĘŁŃÓŚŹŻABCDEFGHIJKLMNOPRSTUWYZQXVąćęłńóśźżabcdefghijklmnoprstuwyzqxv', 'ąćęłńóśźżabcdefghijklmnoprstuwyzqxvąćęłńóśźżabcdefghijklmnoprstuwyzqxv'],
            'German alphabet' => ['name', 'ßÜÖÄüöä', 'ßüöäüöä'],
            'Greek alphabet' => ['name', 'Τάχιστη αλώπηξ βαφής ψημένη γη', 'τάχιστη αλώπηξ βαφής ψημένη γη'],
            'Russian alphabet' => ['name', 'АВСТРАЛИЯавстралия', 'австралияавстралия']
        ];
    }
 
    public function ‪equalsForCaseSensitiveFalseLowercasesOperand($propertyName, $operand, $expectedOperand)
    {
        $objectManager = $this->createMock(ObjectManager::class);
        $dynamicOperand = $this->createMock(PropertyValueInterface::class);
        $objectManager->expects(self::any())->method('get')->willReturn($dynamicOperand);
        $qomFactory = $this->getAccessibleMock(QueryObjectModelFactory::class, ['comparison']);
        $qomFactory->_set('objectManager', $objectManager);
        $qomFactory->expects(self::once())->method('comparison')->with(self::anything(), self::anything(), $expectedOperand);
        $this->query->expects(self::any())->method('getSelectorName')->willReturn('someSelector');
        $this->query->_set('qomFactory', $qomFactory);
        $this->query->equals($propertyName, $operand, false);
    }
 
    public function ‪logicalAndSupportsASingleConstraint(): void
    {
        $subject = $this->‪createQueryForLogicalAndTests();
 
        $constraint1 = new Comparison(new PropertyValue('propertyName1'), '=', 'value1');
 
        $logicalAnd = $subject->logicalAnd($constraint1);
        self::assertSame($constraint1, $logicalAnd);
    }
 
    public function ‪logicalAndSupportsMultipleConstraintsAsArray(): void
    {
        $subject = $this->‪createQueryForLogicalAndTests();
 
        $constraint1 = new ‪Comparison(new ‪PropertyValue('propertyName1'), '=', 'value1');
        $constraint2 = new ‪Comparison(new ‪PropertyValue('propertyName2'), '=', 'value2');
 
        $logicalAnd = $subject->logicalAnd([$constraint1, $constraint2]);
        self::assertEquals(
            new ‪LogicalAnd($constraint1, $constraint2),
            $logicalAnd
        );
    }
 
    public function ‪logicalAndSupportsMultipleConstraintsAsMethodArguments(): void
    {
        $subject = $this->‪createQueryForLogicalAndTests();
 
        $constraint1 = new ‪Comparison(new ‪PropertyValue('propertyName1'), '=', 'value1');
        $constraint2 = new ‪Comparison(new ‪PropertyValue('propertyName2'), '=', 'value2');
        $constraint3 = new ‪Comparison(new ‪PropertyValue('propertyName3'), '=', 'value3');
 
        $logicalAnd = $subject->logicalAnd($constraint1, $constraint2, $constraint3);
        self::assertEquals(
            new ‪LogicalAnd(new ‪LogicalAnd($constraint1, $constraint2), $constraint3),
            $logicalAnd
        );
    }
 
    public function ‪logicalAndSupportsMultipleConstraintsWithArrayAsFirstArgumentAndFurtherConstraintArguments(): void
    {
        $subject = $this->‪createQueryForLogicalAndTests();
 
        $constraint1 = new ‪Comparison(new ‪PropertyValue('propertyName1'), '=', 'value1');
        $constraint2 = new ‪Comparison(new ‪PropertyValue('propertyName2'), '=', 'value2');
        $constraint3 = new ‪Comparison(new ‪PropertyValue('propertyName3'), '=', 'value3');
        $constraint4 = new ‪Comparison(new ‪PropertyValue('propertyName4'), '=', 'value4');
 
        $logicalAnd = $subject->logicalAnd([$constraint1, $constraint2], $constraint3, $constraint4);
 
        self::assertEquals(
            new ‪LogicalAnd(new ‪LogicalAnd(new ‪LogicalAnd($constraint1, $constraint2), $constraint3), $constraint4),
            $logicalAnd
        );
    }
 
    private function ‪createQueryForLogicalAndTests(): ‪Query
    {
        $objectManager = $this->prophesize(ObjectManager::class);
        $objectManager
            ->get(Argument::exact(LogicalAnd::class), Argument::cetera())
            ->will(
                function (array $methodArguments) {
                    return new ‪LogicalAnd($methodArguments[1], $methodArguments[2]);
                }
            )
        ;
 
        $qomFactory = new QueryObjectModelFactory();
        $qomFactory->injectObjectManager($objectManager->reveal());
 
        ‪$query = new ‪Query('type');
        ‪$query->‪injectQomFactory($qomFactory);
 
        return ‪$query;
    }
 
    public function ‪logicalOrSupportsASingleConstraint(): void
    {
        $subject = $this->‪createQueryForLogicalOrTests();
 
        $constraint1 = new Comparison(new PropertyValue('propertyName1'), '=', 'value1');
 
        $logicalOr = $subject->logicalOr($constraint1);
        self::assertSame($constraint1, $logicalOr);
    }
 
    public function ‪logicalOrSupportsMultipleConstraintsAsArray(): void
    {
        $subject = $this->‪createQueryForLogicalOrTests();
 
        $constraint1 = new ‪Comparison(new ‪PropertyValue('propertyName1'), '=', 'value1');
        $constraint2 = new ‪Comparison(new ‪PropertyValue('propertyName2'), '=', 'value2');
 
        $logicalOr = $subject->logicalOr([$constraint1, $constraint2]);
        self::assertEquals(
            new ‪LogicalOr($constraint1, $constraint2),
            $logicalOr
        );
    }
 
    public function ‪logicalOrSupportsMultipleConstraintsAsMethodArguments(): void
    {
        $subject = $this->‪createQueryForLogicalOrTests();
 
        $constraint1 = new ‪Comparison(new ‪PropertyValue('propertyName1'), '=', 'value1');
        $constraint2 = new ‪Comparison(new ‪PropertyValue('propertyName2'), '=', 'value2');
        $constraint3 = new ‪Comparison(new ‪PropertyValue('propertyName3'), '=', 'value3');
 
        $logicalOr = $subject->logicalOr($constraint1, $constraint2, $constraint3);
        self::assertEquals(
            new ‪LogicalOr(new ‪LogicalOr($constraint1, $constraint2), $constraint3),
            $logicalOr
        );
    }
 
    public function ‪logicalOrSupportsMultipleConstraintsWithArrayAsFirstArgumentAndFurtherConstraintArguments(): void
    {
        $subject = $this->‪createQueryForLogicalOrTests();
 
        $constraint1 = new ‪Comparison(new ‪PropertyValue('propertyName1'), '=', 'value1');
        $constraint2 = new ‪Comparison(new ‪PropertyValue('propertyName2'), '=', 'value2');
        $constraint3 = new ‪Comparison(new ‪PropertyValue('propertyName3'), '=', 'value3');
        $constraint4 = new ‪Comparison(new ‪PropertyValue('propertyName4'), '=', 'value4');
 
        $logicalOr = $subject->logicalOr([$constraint1, $constraint2], $constraint3, $constraint4);
 
        self::assertEquals(
            new ‪LogicalOr(new ‪LogicalOr(new ‪LogicalOr($constraint1, $constraint2), $constraint3), $constraint4),
            $logicalOr
        );
    }
 
    private function ‪createQueryForLogicalOrTests(): ‪Query
    {
        $objectManager = $this->prophesize(ObjectManager::class);
        $objectManager
            ->get(Argument::exact(LogicalOr::class), Argument::cetera())
            ->will(
                function (array $methodArguments) {
                    return new ‪LogicalOr($methodArguments[1], $methodArguments[2]);
                }
            )
        ;
 
        $qomFactory = new QueryObjectModelFactory();
        $qomFactory->injectObjectManager($objectManager->reveal());
 
        ‪$query = new ‪Query('type');
        ‪$query->‪injectQomFactory($qomFactory);
 
        return ‪$query;
    }
}