QueryLocalizedDataTest.php

Go to the documentation of this file.

<?php
declare(strict_types = 1);
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 PHPUnit\Framework\MockObject\MockObject;
use TYPO3\CMS\Core\Context\Context;
use TYPO3\CMS\Core\Utility\GeneralUtility;
use TYPO3\CMS\Extbase\Persistence\Generic\PersistenceManager;
use TYPO3\CMS\Extbase\Persistence\ObjectStorage;
use TYPO3\CMS\Extbase\Persistence\QueryInterface;
use TYPO3\CMS\Extbase\Reflection\ObjectAccess;
use TYPO3\CMS\Extbase\Service\EnvironmentService;
use TYPO3\CMS\Frontend\Page\PageRepository;

class QueryLocalizedDataTest extends \TYPO3\TestingFramework\Core\Functional\FunctionalTestCase
{
    protected $testExtensionsToLoad = ['typo3/sysext/extbase/Tests/Functional/Fixtures/Extensions/blog_example'];

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

    protected $objectManager;

    protected $postRepository;

    protected $persistenceManager;

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

        $this->importCSVDataSet(ORIGINAL_ROOT . 'typo3/sysext/extbase/Tests/Functional/Persistence/Fixtures/translatedBlogExampleData.csv');
        $this->setUpBasicFrontendEnvironment();

        $this->objectManager = GeneralUtility::makeInstance(\TYPO3\CMS\Extbase\Object\ObjectManager::class);
        $configuration = [
            'persistence' => [
                'storagePid' => 20,
                'classes' => [
                    'TYPO3\CMS\Extbase\Domain\Model\Category' => [
                        'mapping' => ['tableName' => 'sys_category']
                    ]
                ]
            ]
        ];
        $configurationManager = $this->objectManager->get(\TYPO3\CMS\Extbase\Configuration\ConfigurationManagerInterface::class);
        $configurationManager->setConfiguration($configuration);
        $this->postRepository = $this->objectManager->get(\ExtbaseTeam\BlogExample\Domain\Repository\PostRepository::class);
        $this->persistenceManager = $this->objectManager->get(PersistenceManager::class);
    }

    protected function setUpBasicFrontendEnvironment()
    {
        $environmentServiceMock = $this->createMock(EnvironmentService::class);
        $environmentServiceMock
            ->expects($this->atLeast(1))
            ->method('isEnvironmentInFrontendMode')
            ->willReturn(true);
        GeneralUtility::setSingletonInstance(EnvironmentService::class, $environmentServiceMock);

        $pageRepositoryFixture = new PageRepository();
        $frontendControllerMock = $this->createMock(\TYPO3\CMS\Frontend\Controller\TypoScriptFrontendController::class);
        $frontendControllerMock->sys_page = $pageRepositoryFixture;
        $GLOBALS['TSFE'] = $frontendControllerMock;
        $GLOBALS['TSFE']->sys_language_uid = 0;
        $GLOBALS['TSFE']->sys_language_content = 0;
        $GLOBALS['TSFE']->sys_language_contentOL = 1;
        $GLOBALS['TSFE']->sys_language_mode = 'strict';
    }

    public function findByUidOverlayModeOnDefaultLanguage()
    {
        $GLOBALS['TSFE']->sys_language_content = 0;
        $GLOBALS['TSFE']->sys_language_contentOL = 'hideNonTranslated';
        $post2 = $this->postRepository->findByUid(2);

        $this->assertEquals(['Post 2', 2, 2, 'Blog 1', 1, 1, 'John', 1, 1], [
            $post2->getTitle(),
            $post2->getUid(),
            $post2->_getProperty('_localizedUid'),
            $post2->getBlog()->getTitle(),
            $post2->getBlog()->getUid(),
            $post2->getBlog()->_getProperty('_localizedUid'),
            $post2->getAuthor()->getFirstname(),
            $post2->getAuthor()->getUid(),
            $post2->getAuthor()->_getProperty('_localizedUid')
        ]);

        //this is needed because of https://forge.typo3.org/issues/59992
        $this->persistenceManager->clearState();

        $post2translated = $this->postRepository->findByUid(11);
        $this->assertEquals(['Post 2', 2, 2, 'Blog 1', 1, 1, 'John', 1, 1], [
            $post2translated->getTitle(),
            $post2translated->getUid(),
            $post2translated->_getProperty('_localizedUid'),
            $post2translated->getBlog()->getTitle(),
            $post2translated->getBlog()->getUid(),
            $post2translated->getBlog()->_getProperty('_localizedUid'),
            $post2translated->getAuthor()->getFirstname(),
            $post2translated->getAuthor()->getUid(),
            $post2translated->getAuthor()->_getProperty('_localizedUid')
        ]);
    }

    public function findByUidNoOverlaysDefaultLanguage()
    {
        $GLOBALS['TSFE']->sys_language_content = 0;
        $GLOBALS['TSFE']->sys_language_contentOL = 0;

        $post2 = $this->postRepository->findByUid(2);
        $this->assertEquals(['Post 2', 2, 2, 'Blog 1', 1, 1, 'John', 1, 1], [
            $post2->getTitle(),
            $post2->getUid(),
            $post2->_getProperty('_localizedUid'),
            $post2->getBlog()->getTitle(),
            $post2->getBlog()->getUid(),
            $post2->getBlog()->_getProperty('_localizedUid'),
            $post2->getAuthor()->getFirstname(),
            $post2->getAuthor()->getUid(),
            $post2->getAuthor()->_getProperty('_localizedUid')
        ]);

        //this is needed because of https://forge.typo3.org/issues/59992
        $this->persistenceManager->clearState();

        $post2translated = $this->postRepository->findByUid(11);
        $this->assertEquals(['Post 2', 2, 2, 'Blog 1', 1, 1, 'John', 1, 1], [
            $post2translated->getTitle(),
            $post2translated->getUid(),
            $post2translated->_getProperty('_localizedUid'),
            $post2translated->getBlog()->getTitle(),
            $post2translated->getBlog()->getUid(),
            $post2translated->getBlog()->_getProperty('_localizedUid'),
            $post2translated->getAuthor()->getFirstname(),
            $post2translated->getAuthor()->getUid(),
            $post2translated->getAuthor()->_getProperty('_localizedUid')
        ]);
    }

    public function findByUidOverlayModeOnLanguage()
    {
        $GLOBALS['TSFE']->sys_language_content = 1;
        $GLOBALS['TSFE']->sys_language_contentOL = 'hideNonTranslated';

        $post2 = $this->postRepository->findByUid(2);
        //this is needed because of https://forge.typo3.org/issues/59992
        $this->persistenceManager->clearState();
        $post2translated = $this->postRepository->findByUid(11);

        foreach ([$post2, $post2translated] as $post) {
            $this->assertEquals(['Post 2 - DK', 2, 11, 'Blog 1 DK', 1, 2, 'Translated John', 1, 2], [
                $post->getTitle(),
                $post->getUid(),
                $post->_getProperty('_localizedUid'),
                $post->getBlog()->getTitle(),
                $post->getBlog()->getUid(),
                $post->getBlog()->_getProperty('_localizedUid'),
                $post->getAuthor()->getFirstname(),
                $post->getAuthor()->getUid(),
                $post->getAuthor()->_getProperty('_localizedUid')
            ]);
        }
    }

    public function findByUidNoOverlaysLanguage()
    {
        $GLOBALS['TSFE']->sys_language_content = 1;
        $GLOBALS['TSFE']->sys_language_contentOL = 0;

        $post2 = $this->postRepository->findByUid(2);
        $this->assertEquals(['Post 2 - DK', 2, 11, 'Blog 1 DK', 1, 2, 'Translated John', 1, 2], [
            $post2->getTitle(),
            $post2->getUid(),
            $post2->_getProperty('_localizedUid'),
            $post2->getBlog()->getTitle(),
            $post2->getBlog()->getUid(),
            $post2->getBlog()->_getProperty('_localizedUid'),
            $post2->getAuthor()->getFirstname(),
            $post2->getAuthor()->getUid(),
            $post2->getAuthor()->_getProperty('_localizedUid')
        ]);

        //this is needed because of https://forge.typo3.org/issues/59992
        $this->persistenceManager->clearState();

        $post2translated = $this->postRepository->findByUid(11);
        $this->assertEquals(['Post 2 - DK', 2, 11, 'Blog 1 DK', 1, 2, 'Translated John', 1, 2], [
            $post2translated->getTitle(),
            $post2translated->getUid(),
            $post2translated->_getProperty('_localizedUid'),
            $post2translated->getBlog()->getTitle(),
            $post2translated->getBlog()->getUid(),
            $post2translated->getBlog()->_getProperty('_localizedUid'),
            $post2translated->getAuthor()->getFirstname(),
            $post2translated->getAuthor()->getUid(),
            $post2translated->getAuthor()->_getProperty('_localizedUid')
        ]);
    }

    public function customFindByUidOverlayEnabled()
    {
        // we're in default lang and fetching by uid of the record in default language
        $query = $this->postRepository->createQuery();
        $querySettings = $query->getQuerySettings();
        $querySettings->setLanguageUid(0);
        $querySettings->setLanguageOverlayMode(true);
        $query->matching($query->equals('uid', 2));
        $post2 = $query->execute()->getFirst();

        $this->assertEquals(['Post 2', 2, 2, 'Blog 1', 1, 1, 'John', 1, 1], [
            $post2->getTitle(),
            $post2->getUid(),
            $post2->_getProperty('_localizedUid'),
            $post2->getBlog()->getTitle(),
            $post2->getBlog()->getUid(),
            $post2->getBlog()->_getProperty('_localizedUid'),
            $post2->getAuthor()->getFirstname(),
            $post2->getAuthor()->getUid(),
            $post2->getAuthor()->_getProperty('_localizedUid')
        ]);

        //this is needed because of https://forge.typo3.org/issues/59992
        $this->persistenceManager->clearState();

        $query = $this->postRepository->createQuery();
        $querySettings = $query->getQuerySettings();
        $querySettings->setLanguageUid(0);
        $querySettings->setLanguageOverlayMode(true);
        $query->matching($query->equals('uid', 11));
        $post2 = $query->execute()->getFirst();

        $this->assertNull($post2);

        //this is needed because of https://forge.typo3.org/issues/59992
        $this->persistenceManager->clearState();

        $query = $this->postRepository->createQuery();
        $querySettings = $query->getQuerySettings();
        $querySettings->setLanguageUid(1);
        $querySettings->setLanguageOverlayMode(true);
        $query->matching($query->equals('uid', 2));
        $post2 = $query->execute()->getFirst();

        $this->assertEquals(['Post 2 - DK', 2, 11, 'Blog 1', 1, 1, 'John', 1, 1], [
            $post2->getTitle(),
            $post2->getUid(),
            $post2->_getProperty('_localizedUid'),
            $post2->getBlog()->getTitle(),
            $post2->getBlog()->getUid(),
            $post2->getBlog()->_getProperty('_localizedUid'),
            $post2->getAuthor()->getFirstname(),
            $post2->getAuthor()->getUid(),
            $post2->getAuthor()->_getProperty('_localizedUid')
        ]);

        //this is needed because of https://forge.typo3.org/issues/59992
        $this->persistenceManager->clearState();

        $query = $this->postRepository->createQuery();
        $querySettings = $query->getQuerySettings();
        $querySettings->setLanguageUid(1);
        $querySettings->setLanguageOverlayMode(true);
        $query->matching($query->equals('uid', 11));
        $post2 = $query->execute()->getFirst();

        $this->assertNull($post2);
    }

    public function customFindByUidOverlayDisabled()
    {
        $query = $this->postRepository->createQuery();
        $querySettings = $query->getQuerySettings();
        $querySettings->setLanguageUid(0);
        $querySettings->setLanguageOverlayMode(false);
        $query->matching($query->equals('uid', 2));
        $post2 = $query->execute()->getFirst();

        $this->assertEquals(['Post 2', 2, 2, 'Blog 1', 1, 1, 'John', 1, 1], [
            $post2->getTitle(),
            $post2->getUid(),
            $post2->_getProperty('_localizedUid'),
            $post2->getBlog()->getTitle(),
            $post2->getBlog()->getUid(),
            $post2->getBlog()->_getProperty('_localizedUid'),
            $post2->getAuthor()->getFirstname(),
            $post2->getAuthor()->getUid(),
            $post2->getAuthor()->_getProperty('_localizedUid')
        ]);

        //this is needed because of https://forge.typo3.org/issues/59992
        $this->persistenceManager->clearState();

        $query = $this->postRepository->createQuery();
        $querySettings = $query->getQuerySettings();
        $querySettings->setLanguageUid(0);
        $querySettings->setLanguageOverlayMode(false);
        $query->matching($query->equals('uid', 11));
        $post2 = $query->execute()->getFirst();

        $this->assertNull($post2);

        //this is needed because of https://forge.typo3.org/issues/59992
        $this->persistenceManager->clearState();

        $query = $this->postRepository->createQuery();
        $querySettings = $query->getQuerySettings();
        $querySettings->setLanguageUid(1);
        $querySettings->setLanguageOverlayMode(false);
        $query->matching($query->equals('uid', 2));
        $post2 = $query->execute()->getFirst();

        //the john is not translated but it should
        $this->assertEquals(['Post 2 - DK', 2, 11, 'Blog 1', 1, 1, 'John', 1, 1], [
            $post2->getTitle(),
            $post2->getUid(),
            $post2->_getProperty('_localizedUid'),
            $post2->getBlog()->getTitle(),
            $post2->getBlog()->getUid(),
            $post2->getBlog()->_getProperty('_localizedUid'),
            $post2->getAuthor()->getFirstname(),
            $post2->getAuthor()->getUid(),
            $post2->getAuthor()->_getProperty('_localizedUid')
        ]);

        //this is needed because of https://forge.typo3.org/issues/59992
        $this->persistenceManager->clearState();

        $query = $this->postRepository->createQuery();
        $querySettings = $query->getQuerySettings();
        $querySettings->setLanguageUid(1);
        $querySettings->setLanguageOverlayMode(false);
        $query->matching($query->equals('uid', 11));
        $post2 = $query->execute()->getFirst();

        $this->assertNull($post2);

        //We're setting global context here to show that the result is different then one above.
        //this means that language which is set in global context influences overlays of relations
        $GLOBALS['TSFE']->sys_language_content = 1;
        $GLOBALS['TSFE']->sys_language_contentOL = 'hideNonTranslated';

        //this is needed because of https://forge.typo3.org/issues/59992
        $this->persistenceManager->clearState();

        $query = $this->postRepository->createQuery();
        $querySettings = $query->getQuerySettings();
        $querySettings->setLanguageUid(1);
        $querySettings->setLanguageOverlayMode(false);
        $query->matching($query->equals('uid', 11));
        $post2 = $query->execute()->getFirst();

        $this->assertNull($post2);
    }

    public function queryFirst5PostsDataProvider()
    {
        //put it to variable to make cases with the same expected values explicit
        $lang0Expected = [
            [
                'title' => 'Post 4',
                'uid' => 4,
                '_localizedUid' => 4,
                'blog.title' => 'Blog 1',
                'blog.uid' => 1,
                'blog._localizedUid' => 1,
                'author.firstname' => 'John',
                'author.uid' => 1,
                'author._localizedUid' => 1,
                'secondAuthor.firstname' => 'John',
                'secondAuthor.uid' => 1,
                'secondAuthor._localizedUid' => 1,
                'tags' => [],
            ],
            [
                'title' => 'Post 2',
                'uid' => 2,
                '_localizedUid' => 2,
                'blog.title' => 'Blog 1',
                'blog.uid' => 1,
                'blog._localizedUid' => 1,
                'author.firstname' => 'John',
                'author.uid' => 1,
                'author._localizedUid' => 1,
                'secondAuthor.firstname' => 'John',
                'secondAuthor.uid' => 1,
                'secondAuthor._localizedUid' => 1,
                'tags.0.name' => 'Tag2',
                'tags.0.uid' => 2,
                'tags.0._localizedUid' => 2,
                'tags.1.name' => 'Tag3',
                'tags.1.uid' => 3,
                'tags.1._localizedUid' => 3,
                'tags.2.name' => 'Tag4',
                'tags.2.uid' => 4,
                'tags.2._localizedUid' => 4,
            ],
            [
                'title' => 'Post 7',
                'uid' => 7,
                '_localizedUid' => 7,
                'blog.title' => 'Blog 1',
                'blog.uid' => 1,
                'blog._localizedUid' => 1,
                'author.firstname' => 'John',
                'author.uid' => 1,
                'author._localizedUid' => 1,
                'secondAuthor.firstname' => 'John',
                'secondAuthor.uid' => 1,
                'secondAuthor._localizedUid' => 1,
                'tags' => [],
            ],
            [
                'title' => 'Post 6',
                'uid' => 6,
                '_localizedUid' => 6,
                'blog.title' => 'Blog 1',
                'blog.uid' => 1,
                'blog._localizedUid' => 1,
                'author.firstname' => 'John',
                'author.uid' => 1,
                'author._localizedUid' => 1,
                'secondAuthor.firstname' => 'John',
                'secondAuthor.uid' => 1,
                'secondAuthor._localizedUid' => 1,
                'tags' => [],
            ],
            [
                'title' => 'Post 1 - not translated',
                'uid' => 1,
                '_localizedUid' => 1,
                'blog.title' => 'Blog 1',
                'blog.uid' => 1,
                'blog._localizedUid' => 1,
                'author.firstname' => 'John',
                'author.uid' => 1,
                'author._localizedUid' => 1,
                'secondAuthor.firstname' => 'Never translate me henry',
                'secondAuthor.uid' => 3,
                'secondAuthor._localizedUid' => 3,
                'tags.0.name' => 'Tag1',
                'tags.0.uid' => 1,
                'tags.0._localizedUid' => 1,
                'tags.1.name' => 'Tag2',
                'tags.1.uid' => 2,
                'tags.1._localizedUid' => 2,
                'tags.2.name' => 'Tag3',
                'tags.2.uid' => 3,
                'tags.2._localizedUid' => 3,
            ],
        ];
        return [
            [
                'language' => 0,
                'overlay' => true,
                'expected' => $lang0Expected
            ],
            [
                'language' => 0,
                'overlay' => false,
                'expected' => $lang0Expected
            ],
            [
                'language' => 1,
                'overlay' => true,
                'expected' => [
                    [
                        'title' => 'Post 4 - DK',
                        'uid' => 4,
                        '_localizedUid' => 12,
                        'blog.title' => 'Blog 1',
                        'blog.uid' => 1,
                        'blog._localizedUid' => 1,
                        'author.firstname' => 'John',
                        'author.uid' => 1,
                        'author._localizedUid' => 1,
                        'secondAuthor.firstname' => 'John',
                        'secondAuthor.uid' => 1,
                        'secondAuthor._localizedUid' => 1,
                        'tags' => [],
                    ],
                    [
                        'title' => 'Post 2 - DK',
                        'uid' => 2,
                        '_localizedUid' => 11,
                        'blog.title' => 'Blog 1',
                        'blog.uid' => 1,
                        'blog._localizedUid' => 1,
                        'author.firstname' => 'John',
                        'author.uid' => 1,
                        'author._localizedUid' => 1,
                        'secondAuthor.firstname' => 'John',
                        'secondAuthor.uid' => 1,
                        'secondAuthor._localizedUid' => 1,
                        'tags.0.name' => 'Tag2',
                        'tags.0.uid' => 2,
                        'tags.0._localizedUid' => 2,
                        'tags.1.name' => 'Tag3',
                        'tags.1.uid' => 3,
                        'tags.1._localizedUid' => 3,
                        'tags.2.name' => 'Tag4',
                        'tags.2.uid' => 4,
                        'tags.2._localizedUid' => 4,
                    ],
                    [
                        'title' => 'Post DK only',
                        'uid' => 15,
                        '_localizedUid' => 15,
                        'blog.title' => 'Blog 1',
                        'blog.uid' => 1,
                        'blog._localizedUid' => 1,
                        'author.firstname' => 'John',
                        'author.uid' => 1,
                        'author._localizedUid' => 1,
                        'secondAuthor.firstname' => 'John',
                        'secondAuthor.uid' => 1,
                        'secondAuthor._localizedUid' => 1,
                        'tags' => [],

                    ],
                    [
                        'title' => 'Post 7 - DK',
                        'uid' => 7,
                        '_localizedUid' => 14,
                        'blog.title' => 'Blog 1',
                        'blog.uid' => 1,
                        'blog._localizedUid' => 1,
                        'author.firstname' => 'John',
                        'author.uid' => 1,
                        'author._localizedUid' => 1,
                        'secondAuthor.firstname' => 'John',
                        'secondAuthor.uid' => 1,
                        'secondAuthor._localizedUid' => 1,
                        'tags' => [],
                    ],
                    [
                        'title' => 'Post 5 - DK',
                        'uid' => 5,
                        '_localizedUid' => 13,
                        'blog.title' => 'Blog 1',
                        'blog.uid' => 1,
                        'blog._localizedUid' => 1,
                        'author.firstname' => 'John',
                        'author.uid' => 1,
                        'author._localizedUid' => 1,
                        'secondAuthor.firstname' => 'John',
                        'secondAuthor.uid' => 1,
                        'secondAuthor._localizedUid' => 1,
                        'tags' => [],
                    ],
                ],
            ],
            [
                'language' => 1,
                'overlay' => 'hideNonTranslated',
                'expected' => [
                    [
                        'title' => 'Post 4 - DK',
                        'uid' => 4,
                        '_localizedUid' => 12,
                        'blog.title' => 'Blog 1',
                        'blog.uid' => 1,
                        'blog._localizedUid' => 1,
                        'author.firstname' => 'John',
                        'author.uid' => 1,
                        'author._localizedUid' => 1,
                        'secondAuthor.firstname' => 'John',
                        'secondAuthor.uid' => 1,
                        'secondAuthor._localizedUid' => 1,
                        'tags' => [],
                    ],
                    [
                        'title' => 'Post 2 - DK',
                        'uid' => 2,
                        '_localizedUid' => 11,
                        'blog.title' => 'Blog 1',
                        'blog.uid' => 1,
                        'blog._localizedUid' => 1,
                        'author.firstname' => 'John',
                        'author.uid' => 1,
                        'author._localizedUid' => 1,
                        'secondAuthor.firstname' => 'John',
                        'secondAuthor.uid' => 1,
                        'secondAuthor._localizedUid' => 1,
                        'tags.0.name' => 'Tag2',
                        'tags.0.uid' => 2,
                        'tags.0._localizedUid' => 2,
                        'tags.1.name' => 'Tag3',
                        'tags.1.uid' => 3,
                        'tags.1._localizedUid' => 3,
                        'tags.2.name' => 'Tag4',
                        'tags.2.uid' => 4,
                        'tags.2._localizedUid' => 4,
                    ],
                    [
                        'title' => 'Post DK only',
                        'uid' => 15,
                        '_localizedUid' => 15,
                        'blog.title' => 'Blog 1',
                        'blog.uid' => 1,
                        'blog._localizedUid' => 1,
                        'author.firstname' => 'John',
                        'author.uid' => 1,
                        'author._localizedUid' => 1,
                        'secondAuthor.firstname' => 'John',
                        'secondAuthor.uid' => 1,
                        'secondAuthor._localizedUid' => 1,
                        'tags' => [],
                    ],
                    [
                        'title' => 'Post 7 - DK',
                        'uid' => 7,
                        '_localizedUid' => 14,
                        'blog.title' => 'Blog 1',
                        'blog.uid' => 1,
                        'blog._localizedUid' => 1,
                        'author.firstname' => 'John',
                        'author.uid' => 1,
                        'author._localizedUid' => 1,
                        'secondAuthor.firstname' => 'John',
                        'secondAuthor.uid' => 1,
                        'secondAuthor._localizedUid' => 1,
                        'tags' => [],
                    ],
                    [
                        'title' => 'Post 5 - DK',
                        'uid' => 5,
                        '_localizedUid' => 13,
                        'blog.title' => 'Blog 1',
                        'blog.uid' => 1,
                        'blog._localizedUid' => 1,
                        'author.firstname' => 'John',
                        'author.uid' => 1,
                        'author._localizedUid' => 1,
                        'secondAuthor.firstname' => 'John',
                        'secondAuthor.uid' => 1,
                        'secondAuthor._localizedUid' => 1,
                        'tags' => [],
                    ],
                ],
            ],
            [
                'language' => 1,
                'overlay' => false,
                'expected' => [
                    [
                        'title' => 'Post 4 - DK',
                        'uid' => 4,
                        '_localizedUid' => 12,
                        'blog.title' => 'Blog 1',
                        'blog.uid' => 1,
                        'blog._localizedUid' => 1,
                        'author.firstname' => 'John',
                        'author.uid' => 1,
                        'author._localizedUid' => 1,
                        'secondAuthor.firstname' => 'John',
                        'secondAuthor.uid' => 1,
                        'secondAuthor._localizedUid' => 1,
                        'tags' => [],
                    ],
                    [
                        'title' => 'Post 2 - DK',
                        'uid' => 2,
                        '_localizedUid' => 11,
                        'blog.title' => 'Blog 1',
                        'blog.uid' => 1,
                        'blog._localizedUid' => 1,
                        'author.firstname' => 'John',
                        'author.uid' => 1,
                        'author._localizedUid' => 1,
                        'secondAuthor.firstname' => 'John',
                        'secondAuthor.uid' => 1,
                        'secondAuthor._localizedUid' => 1,
                        'tags.0.name' => 'Tag2',
                        'tags.0.uid' => 2,
                        'tags.0._localizedUid' => 2,
                        'tags.1.name' => 'Tag3',
                        'tags.1.uid' => 3,
                        'tags.1._localizedUid' => 3,
                        'tags.2.name' => 'Tag4',
                        'tags.2.uid' => 4,
                        'tags.2._localizedUid' => 4,
                    ],
                    [
                        'title' => 'Post DK only',
                        'uid' => 15,
                        '_localizedUid' => 15,
                        'blog.title' => 'Blog 1',
                        'blog.uid' => 1,
                        'blog._localizedUid' => 1,
                        'author.firstname' => 'John',
                        'author.uid' => 1,
                        'author._localizedUid' => 1,
                        'secondAuthor.firstname' => 'John',
                        'secondAuthor.uid' => 1,
                        'secondAuthor._localizedUid' => 1,
                        'tags' => [],
                    ],
                    [
                        'title' => 'Post 7 - DK',
                        'uid' => 7,
                        '_localizedUid' => 14,
                        'blog.title' => 'Blog 1',
                        'blog.uid' => 1,
                        'blog._localizedUid' => 1,
                        'author.firstname' => 'John',
                        'author.uid' => 1,
                        'author._localizedUid' => 1,
                        'secondAuthor.firstname' => 'John',
                        'secondAuthor.uid' => 1,
                        'secondAuthor._localizedUid' => 1,
                        'tags' => [],
                    ],
                    [
                        'title' => 'Post 5 - DK',
                        'uid' => 5,
                        '_localizedUid' => 13,
                        'blog.title' => 'Blog 1',
                        'blog.uid' => 1,
                        'blog._localizedUid' => 1,
                        'author.firstname' => 'John',
                        'author.uid' => 1,
                        'author._localizedUid' => 1,
                        'secondAuthor.firstname' => 'John',
                        'secondAuthor.uid' => 1,
                        'secondAuthor._localizedUid' => 1,
                        'tags' => [],
                    ],
                ],
            ],
        ];
    }

    public function queryFirst5Posts($languageUid, $overlay, $expected)
    {
        $query = $this->postRepository->createQuery();
        $querySettings = $query->getQuerySettings();
        $querySettings->setLanguageUid($languageUid);
        $querySettings->setLanguageOverlayMode($overlay);

        $query->setOrderings([
            'content' => QueryInterface::ORDER_ASCENDING,
            'uid' => QueryInterface::ORDER_ASCENDING
        ]);
        $query->setLimit(5);
        $query->setOffset(0);
        $posts = $query->execute()->toArray();

        $this->assertCount(5, $posts);
        $this->assertObjectsProperties($posts, $expected);
    }

    public function queryPostsByPropertyDataProvider()
    {
        $lang0Expected = [
            [
                'title' => 'Post 5',
                'uid' => 5,
                '_localizedUid' => 5,
                'blog.title' => 'Blog 1',
                'blog.uid' => 1,
                'blog._localizedUid' => 1,
                'author.firstname' => 'John',
                'author.uid' => 1,
                'author._localizedUid' => 1,
                'secondAuthor.firstname' => 'John',
                'secondAuthor.uid' => 1,
                'secondAuthor._localizedUid' => 1,
            ],
            [
                'title' => 'Post 6',
                'uid' => 6,
                '_localizedUid' => 6,
                'blog.title' => 'Blog 1',
                'blog.uid' => 1,
                'blog._localizedUid' => 1,
                'author.firstname' => 'John',
                'author.uid' => 1,
                'author._localizedUid' => 1,
                'secondAuthor.firstname' => 'John',
                'secondAuthor.uid' => 1,
                'secondAuthor._localizedUid' => 1,
                'tags' => [],
            ]
        ];
        $lang1Expected = [
            [
                'title' => 'Post 5 - DK',
                'uid' => 5,
                '_localizedUid' => 13,
                'blog.title' => 'Blog 1',
                'blog.uid' => 1,
                'blog._localizedUid' => 1,
                'author.firstname' => 'John',
                'author.uid' => 1,
                'author._localizedUid' => 1,
                'secondAuthor.firstname' => 'John',
                'secondAuthor.uid' => 1,
                'secondAuthor._localizedUid' => 1,
            ],
            [
                'title' => 'Post DK only',
                'uid' => 15,
                '_localizedUid' => 15,
                'blog.title' => 'Blog 1',
                'blog.uid' => 1,
                'blog._localizedUid' => 1,
                'author.firstname' => 'John',
                'author.uid' => 1,
                'author._localizedUid' => 1,
                'secondAuthor.firstname' => 'John',
                'secondAuthor.uid' => 1,
                'secondAuthor._localizedUid' => 1,
            ],

        ];
        return [
            [
                'language' => 0,
                'overlay' => true,
                'expected' => $lang0Expected
                ],
            [
                'language' => 0,
                'overlay' => 'hideNonTranslated',
                'expected' => $lang0Expected
            ],
                    [
                'language' => 0,
                'overlay' => false,
                'expected' => $lang0Expected
            ],
            [
                'language' => 1,
                'overlay' => true,
                'expected' => $lang1Expected
            ],
            [
                'language' => 1,
                'overlay' => 'hideNonTranslated',
                'expected' => $lang1Expected,
            ],
            [
                'language' => 1,
                'overlay' => false,
                'expected' => $lang1Expected,
            ],
        ];
    }

    public function queryPostsByProperty($languageUid, $overlay, $expected)
    {
        $query = $this->postRepository->createQuery();
        $querySettings = $query->getQuerySettings();
        $querySettings->setLanguageUid($languageUid);
        $querySettings->setLanguageOverlayMode($overlay);

        $query->matching(
            $query->logicalOr(
                $query->like('title', 'Post 5%'),
                $query->like('title', 'Post 6%'),
                $query->like('title', 'Post DK only')
            )
        );
        $query->setOrderings(['uid' => QueryInterface::ORDER_ASCENDING]);
        $posts = $query->execute()->toArray();

        $this->assertCount(count($expected), $posts);
        $this->assertObjectsProperties($posts, $expected);
    }

    public function postsWithoutRespectingSysLanguageDataProvider()
    {
        $lang0Expected = [
             [
                 'title' => 'Blog 1',
                 'uid' => 1,
                 '_localizedUid' => 1,
             ],
             [
                 'title' => 'Blog 1',
                 'uid' => 1,
                 '_localizedUid' => 1,
             ],
         ];
        $lang1Expected = [
             [
                 'title' => 'Blog 1 DK',
                 'uid' => 1,
                 '_localizedUid' => 2,
             ],
             [
                 'title' => 'Blog 1 DK',
                 'uid' => 1,
                 '_localizedUid' => 2,
             ],
         ];
        return [
             [
                 'language' => 0,
                 'overlay' => 'hideNonTranslated',
                 'mode' => null,
                 'expected' => $lang0Expected
             ],
             [
                 'language' => 0,
                 'overlay' => 'hideNonTranslated',
                 'mode' => 'strict',
                 'expected' => $lang0Expected
             ],
             [
                 'language' => 0,
                 'overlay' => 0,
                 'mode' => null,
                 'expected' => $lang0Expected
             ],
             [
                 'language' => 0,
                 'overlay' => 0,
                 'mode' => 'strict',
                 'expected' => $lang0Expected
             ],
             [
                 'language' => 1,
                 'overlay' => 'hideNonTranslated',
                 'mode' => null,
                 'expected' => $lang1Expected
             ],
             [
                 'language' => 1,
                 'overlay' => 'hideNonTranslated',
                 'mode' => 'strict',
                 'expected' => $lang1Expected
             ],
             [
                 'language' => 1,
                 'overlay' => 0,
                 'mode' => null,
                 'expected' => $lang1Expected
             ],
             [
                 'language' => 1,
                 'overlay' => 0,
                 'mode' => 'strict',
                 'expected' => $lang1Expected
             ],
         ];
    }

    public function postsWithoutRespectingSysLanguage($languageUid, $overlay, $languageMode, $expected)
    {
        $GLOBALS['TSFE']->sys_language_content = $languageUid;
        $GLOBALS['TSFE']->sys_language_contentOL = $overlay;

        $blogRepository = $this->objectManager->get(\ExtbaseTeam\BlogExample\Domain\Repository\BlogRepository::class);
        $query = $blogRepository->createQuery();
        $querySettings = $query->getQuerySettings();
        $querySettings->setLanguageMode($languageMode);
        $querySettings->setRespectSysLanguage(false);

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

        $this->assertCount(count($expected), $posts);
        $this->assertObjectsProperties($posts, $expected);
    }

    protected function assertObjectsProperties($objects, $expected)
    {
        $actual = [];
        foreach ($objects as $key => $post) {
            $actualPost = [];
            $propertiesToCheck = array_keys($expected[$key]);
            foreach ($propertiesToCheck as $propertyPath) {
                $actualPost[$propertyPath] = self::getPropertyPath($post, $propertyPath);
            }
            $actual[] = $actualPost;
            $this->assertEquals($expected[$key], $actual[$key], 'Assertion of the $expected[' . $key . '] failed');
        }
        $this->assertEquals($expected, $actual);
    }

    protected static function getPropertyPath($subject, $propertyPath)
    {
        $propertyPathSegments = explode('.', $propertyPath);
        try {
            foreach ($propertyPathSegments as $pathSegment) {
                $subject = ObjectAccess::getPropertyInternal($subject, $pathSegment, true);
                if ($subject instanceof \SplObjectStorage || $subject instanceof ObjectStorage) {
                    $subject = iterator_to_array(clone $subject, false);
                }
            }
        } catch (\TYPO3\CMS\Extbase\Reflection\Exception\PropertyNotAccessibleException $error) {
            return null;
        }
        return $subject;
    }
}