QueryTest.php

Go to the documentation of this file.

<?php
 
declare(strict_types=1);
 
/*
 * 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 PHPUnit\Framework\MockObject\MockObject;
use Prophecy\PhpUnit\ProphecyTrait;
use Psr\Container\ContainerInterface;
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\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\AccessibleObjectInterface;
use TYPO3\TestingFramework\Core\Unit\UnitTestCase;
 
class ‪QueryTest extends UnitTestCase
{
    use ProphecyTrait;
 
    protected ‪$query;
 
    protected ‪$querySettings;
 
    protected ‪$persistenceManager;
 
    protected ‪$dataMapFactory;
 
    protected ‪$container;
 
    protected function ‪setUp(): void
    {
        parent::setUp();
        $this->query = $this->getAccessibleMock(Query::class, ['getSelectorName'], [], '', false);
        $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);
        $this->container = $this->createMock(ContainerInterface::class);
        $this->query->_set('container', $this->container);
    }
 
    public function ‪executeReturnsQueryResultInstanceAndInjectsItself(): void
    {
        $queryResult = $this->createMock(QueryResult::class);
        $this->container->expects(self::once())->method('has')->with(QueryResultInterface::class)->willReturn(true);
        $this->container->expects(self::once())->method('get')->with(QueryResultInterface::class)->willReturn($queryResult);
        $actualResult = $this->query->execute();
        self::assertSame($queryResult, $actualResult);
    }
 
    public function ‪executeReturnsRawObjectDataIfReturnRawQueryResultIsSet(): void
    {
        $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(): void
    {
        $this->expectException(\InvalidArgumentException::class);
        $this->expectExceptionCode(1245071870);
        $this->query->setLimit(1.5);
    }
 
    public function ‪setLimitRejectsIntegersLessThanOne(): void
    {
        $this->expectException(\InvalidArgumentException::class);
        $this->expectExceptionCode(1245071870);
        $this->query->setLimit(0);
    }
 
    public function ‪setOffsetAcceptsOnlyIntegers(): void
    {
        $this->expectException(\InvalidArgumentException::class);
        $this->expectExceptionCode(1245071872);
        $this->query->setOffset(1.5);
    }
 
    public function ‪setOffsetRejectsIntegersLessThanZero(): void
    {
        $this->expectException(\InvalidArgumentException::class);
        $this->expectExceptionCode(1245071872);
        $this->query->setOffset(-1);
    }
 
    public function ‪equalsForCaseSensitiveFalseLowercasesOperandProvider(): array
    {
        return [
            'Polish alphabet' => ['name', 'ĄĆĘŁŃÓŚŹŻABCDEFGHIJKLMNOPRSTUWYZQXVąćęłńóśźżabcdefghijklmnoprstuwyzqxv', 'ąćęłńóśźżabcdefghijklmnoprstuwyzqxvąćęłńóśźżabcdefghijklmnoprstuwyzqxv'],
            'German alphabet' => ['name', 'ßÜÖÄüöä', 'ßüöäüöä'],
            'Greek alphabet' => ['name', 'Τάχιστη αλώπηξ βαφής ψημένη γη', 'τάχιστη αλώπηξ βαφής ψημένη γη'],
            'Russian alphabet' => ['name', 'АВСТРАЛИЯавстралия', 'австралияавстралия'],
        ];
    }
 
    public function ‪equalsForCaseSensitiveFalseLowercasesOperand(string $propertyName, $operand, string $expectedOperand): void
    {
        $qomFactory = $this->getAccessibleMock(QueryObjectModelFactory::class, ['comparison']);
        $qomFactory->expects(self::once())->method('comparison')->with(self::anything(), self::anything(), $expectedOperand);
        $this->query->method('getSelectorName')->willReturn('someSelector');
        $this->query->_set('qomFactory', $qomFactory);
        $this->query->equals($propertyName, $operand, false);
    }
 
    public function ‪logicalAndSupportsASingleConstraint(): void
    {
        $subject = new ‪Query(
            $this->prophesize(DataMapFactory::class)->reveal(),
            $this->prophesize(PersistenceManagerInterface::class)->reveal(),
            new ‪QueryObjectModelFactory(),
            $this->prophesize(ContainerInterface::class)->reveal()
        );
 
        $constraint1 = new ‪Comparison(new ‪PropertyValue('propertyName1'), '=', 'value1');
 
        $logicalAnd = $subject->logicalAnd($constraint1);
        self::assertSame($constraint1, $logicalAnd);
    }
 
    public function ‪logicalAndSupportsMultipleConstraintsAsArray(): void
    {
        $subject = new ‪Query(
            $this->prophesize(DataMapFactory::class)->reveal(),
            $this->prophesize(PersistenceManagerInterface::class)->reveal(),
            new ‪QueryObjectModelFactory(),
            $this->prophesize(ContainerInterface::class)->reveal()
        );
 
        $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 = new ‪Query(
            $this->prophesize(DataMapFactory::class)->reveal(),
            $this->prophesize(PersistenceManagerInterface::class)->reveal(),
            new ‪QueryObjectModelFactory(),
            $this->prophesize(ContainerInterface::class)->reveal()
        );
 
        $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 = new ‪Query(
            $this->prophesize(DataMapFactory::class)->reveal(),
            $this->prophesize(PersistenceManagerInterface::class)->reveal(),
            new ‪QueryObjectModelFactory(),
            $this->prophesize(ContainerInterface::class)->reveal()
        );
 
        $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
        );
    }
 
    public function ‪logicalOrSupportsASingleConstraint(): void
    {
        $subject = new ‪Query(
            $this->prophesize(DataMapFactory::class)->reveal(),
            $this->prophesize(PersistenceManagerInterface::class)->reveal(),
            new ‪QueryObjectModelFactory(),
            $this->prophesize(ContainerInterface::class)->reveal()
        );
 
        $constraint1 = new ‪Comparison(new ‪PropertyValue('propertyName1'), '=', 'value1');
 
        $logicalOr = $subject->logicalOr($constraint1);
        self::assertSame($constraint1, $logicalOr);
    }
 
    public function ‪logicalOrSupportsMultipleConstraintsAsArray(): void
    {
        $subject = new ‪Query(
            $this->prophesize(DataMapFactory::class)->reveal(),
            $this->prophesize(PersistenceManagerInterface::class)->reveal(),
            new ‪QueryObjectModelFactory(),
            $this->prophesize(ContainerInterface::class)->reveal()
        );
 
        $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 = new ‪Query(
            $this->prophesize(DataMapFactory::class)->reveal(),
            $this->prophesize(PersistenceManagerInterface::class)->reveal(),
            new ‪QueryObjectModelFactory(),
            $this->prophesize(ContainerInterface::class)->reveal()
        );
 
        $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 = new ‪Query(
            $this->prophesize(DataMapFactory::class)->reveal(),
            $this->prophesize(PersistenceManagerInterface::class)->reveal(),
            new ‪QueryObjectModelFactory(),
            $this->prophesize(ContainerInterface::class)->reveal()
        );
 
        $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
        );
    }
}