QueryTest.php

Go to the documentation of this file.

<?php
namespace TYPO3\CMS\Extbase\Tests\Unit\Persistence\Generic;

class QueryTest extends \TYPO3\CMS\Core\Tests\UnitTestCase {

    protected $query;

    protected $querySettings;

    protected $persistenceManager;

    protected $backend;

    protected $dataMapper;

    public function setUp() {
        $this->query = $this->getAccessibleMock('TYPO3\CMS\Extbase\Persistence\Generic\Query', array('dummy'), array('someType'));
        $this->querySettings = $this->getMock('TYPO3\\CMS\\Extbase\\Persistence\\Generic\\QuerySettingsInterface');
        $this->query->_set('querySettings', $this->querySettings);
        $this->persistenceManager = $this->getMock('TYPO3\\CMS\\Extbase\\Persistence\\PersistenceManagerInterface');
        $this->backend = $this->getMock('TYPO3\\CMS\\Extbase\\Persistence\\Generic\\BackendInterface');
        $this->backend->expects($this->any())->method('getQomFactory')->will($this->returnValue(NULL));
        $this->persistenceManager->expects($this->any())->method('getBackend')->will($this->returnValue($this->backend));
        $this->query->_set('persistenceManager', $this->persistenceManager);
        $this->dataMapper = $this->getMock('TYPO3\\CMS\\Extbase\\Persistence\\Generic\\Mapper\\DataMapper');
        $this->query->_set('dataMapper', $this->dataMapper);
    }

    public function executeReturnsQueryResultInstanceAndInjectsItself() {
        $objectManager = $this->getMock('TYPO3\\CMS\\Extbase\\Object\\ObjectManager');
        $this->query->_set('objectManager', $objectManager);
        $queryResult = $this->getMock('TYPO3\\CMS\\Extbase\\Persistence\\Generic\\QueryResult', array(), array(), '', FALSE);
        $objectManager->expects($this->once())->method('get')->with('TYPO3\\CMS\\Extbase\\Persistence\\QueryResultInterface', $this->query)->will($this->returnValue($queryResult));
        $actualResult = $this->query->execute();
        $this->assertSame($queryResult, $actualResult);
    }

    public function executeReturnsRawObjectDataIfRawQueryResultSettingIsTrue() {
        $this->querySettings->expects($this->once())->method('getReturnRawQueryResult')->will($this->returnValue(TRUE));
        $this->persistenceManager->expects($this->once())->method('getObjectDataByQuery')->with($this->query)->will($this->returnValue('rawQueryResult'));
        $expectedResult = 'rawQueryResult';
        $actualResult = $this->query->execute();
        $this->assertEquals($expectedResult, $actualResult);
    }

    public function executeReturnsRawObjectDataIfReturnRawQueryResultIsSet() {
        $this->persistenceManager->expects($this->once())->method('getObjectDataByQuery')->with($this->query)->will($this->returnValue('rawQueryResult'));
        $expectedResult = 'rawQueryResult';
        $actualResult = $this->query->execute(TRUE);
        $this->assertEquals($expectedResult, $actualResult);
    }

    public function setLimitAcceptsOnlyIntegers() {
        $this->query->setLimit(1.5);
    }

    public function setLimitRejectsIntegersLessThanOne() {
        $this->query->setLimit(0);
    }

    public function setOffsetAcceptsOnlyIntegers() {
        $this->query->setOffset(1.5);
    }

    public function setOffsetRejectsIntegersLessThanZero() {
        $this->query->setOffset(-1);
    }

    public function equalsForCaseSensitiveFalseLowercasesOperandProvider() {
        return array(
            'Polish alphabet' => array('name', 'ĄĆĘŁŃÓŚŹŻABCDEFGHIJKLMNOPRSTUWYZQXVąćęłńóśźżabcdefghijklmnoprstuwyzqxv', 'ąćęłńóśźżabcdefghijklmnoprstuwyzqxvąćęłńóśźżabcdefghijklmnoprstuwyzqxv'),
            'German alphabet' => array('name', 'ßÜÖÄüöä', 'ßüöäüöä'),
            'Greek alphabet' => array('name', 'Τάχιστη αλώπηξ βαφής ψημένη γη', 'τάχιστη αλώπηξ βαφής ψημένη γη'),
            'Russian alphabet' => array('name', 'АВСТРАЛИЯавстралия', 'австралияавстралия')
        );
    }

    public function equalsForCaseSensitiveFalseLowercasesOperand($propertyName, $operand, $expectedOperand) {
        $objectManager = $this->getMock('TYPO3\\CMS\\Extbase\\Object\\ObjectManager');
        $dynamicOperand = $this->getMock('TYPO3\\CMS\\Extbase\\Persistence\\Generic\\Qom\\PropertyValueInterface');
        $objectManager->expects($this->any())->method('get')->will($this->returnValue($dynamicOperand));
        $qomFactory = $this->getAccessibleMock('TYPO3\\CMS\\Extbase\\Persistence\\Generic\\Qom\\QueryObjectModelFactory', array('comparison'));
        $qomFactory->_set('objectManager', $objectManager);
        $qomFactory->expects($this->once())->method('comparison')->with($this->anything(), $this->anything(), $expectedOperand);
        $this->query->_set('qomFactory', $qomFactory);
        $this->query->equals($propertyName, $operand, FALSE);
    }
}