Typo3DatabaseBackendTest.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\Core\Tests\Functional\Cache\Backend;
 
use ‪TYPO3\CMS\Core\Cache\Backend\Typo3DatabaseBackend;
use ‪TYPO3\CMS\Core\Cache\Frontend\FrontendInterface;
use ‪TYPO3\CMS\Core\Database\Connection;
use ‪TYPO3\CMS\Core\Database\ConnectionPool;
use TYPO3\TestingFramework\Core\Functional\FunctionalTestCase;
 
class ‪Typo3DatabaseBackendTest extends FunctionalTestCase
{
    use \Prophecy\PhpUnit\ProphecyTrait;
    public function ‪getReturnsPreviouslySetEntry(): void
    {
        $frontendProphecy = $this->prophesize(FrontendInterface::class);
        $frontendProphecy->getIdentifier()->willReturn('pages');
 
        $subject = new ‪Typo3DatabaseBackend('Testing');
        $subject->setCache($frontendProphecy->reveal());
 
        $subject->set('myIdentifier', 'myData');
        self::assertSame('myData', $subject->get('myIdentifier'));
    }
 
    public function ‪getReturnsPreviouslySetEntryWithNewContentIfSetWasCalledMultipleTimes(): void
    {
        $frontendProphecy = $this->prophesize(FrontendInterface::class);
        $frontendProphecy->getIdentifier()->willReturn('pages');
 
        $subject = new ‪Typo3DatabaseBackend('Testing');
        $subject->setCache($frontendProphecy->reveal());
 
        $subject->set('myIdentifier', 'myData');
        $subject->set('myIdentifier', 'myNewData');
        self::assertSame('myNewData', $subject->get('myIdentifier'));
    }
 
    public function ‪setInsertsDataWithTagsIntoCacheTable(): void
    {
        $frontendProphecy = $this->prophesize(FrontendInterface::class);
        $frontendProphecy->getIdentifier()->willReturn('pages');
 
        $subject = new ‪Typo3DatabaseBackend('Testing');
        $subject->setCache($frontendProphecy->reveal());
 
        $subject->set('myIdentifier', 'myData', ['aTag', 'anotherTag']);
 
        $cacheTableConnection = (new ‪ConnectionPool())->getConnectionForTable('cache_pages');
        $tagsTableConnection = (new ‪ConnectionPool())->getConnectionForTable('cache_pages_tags');
        self::assertSame(1, $cacheTableConnection->count('*', 'cache_pages', ['identifier' => 'myIdentifier']));
        self::assertSame(1, $tagsTableConnection->count('*', 'cache_pages_tags', ['identifier' => 'myIdentifier', 'tag' => 'aTag']));
        self::assertSame(1, $tagsTableConnection->count('*', 'cache_pages_tags', ['identifier' => 'myIdentifier', 'tag' => 'anotherTag']));
    }
 
    public function ‪setStoresCompressedContent(): void
    {
        $frontendProphecy = $this->prophesize(FrontendInterface::class);
        $frontendProphecy->getIdentifier()->willReturn('pages');
 
        // Have backend with compression enabled
        $subject = new ‪Typo3DatabaseBackend('Testing', ['compression' => true]);
        $subject->setCache($frontendProphecy->reveal());
 
        $subject->set('myIdentifier', 'myCachedContent');
 
        $row = (new ‪ConnectionPool())
            ->getConnectionForTable('cache_pages')
            ->select(
                ['content'],
                'cache_pages',
                ['identifier' => 'myIdentifier']
            )
            ->fetchAssociative();
 
        // Content comes back uncompressed
        self::assertSame('myCachedContent', gzuncompress($row['content']));
    }
 
    public function ‪getReturnsFalseIfNoCacheEntryExists(): void
    {
        $frontendProphecy = $this->prophesize(FrontendInterface::class);
        $frontendProphecy->getIdentifier()->willReturn('pages');
 
        $subject = new ‪Typo3DatabaseBackend('Testing');
        $subject->setCache($frontendProphecy->reveal());
 
        self::assertFalse($subject->get('myIdentifier'));
    }
 
    public function ‪getReturnsFalseForExpiredCacheEntry(): void
    {
        $frontendProphecy = $this->prophesize(FrontendInterface::class);
        $frontendProphecy->getIdentifier()->willReturn('pages');
 
        // Push an expired row into db
        (new ‪ConnectionPool())->getConnectionForTable('cache_pages')->insert(
            'cache_pages',
            [
                'identifier' => 'myIdentifier',
                'expires' => ‪$GLOBALS['EXEC_TIME'] - 60,
                'content' => 'myCachedContent',
            ],
            [
                'content' => ‪Connection::PARAM_LOB,
            ]
        );
 
        $subject = new ‪Typo3DatabaseBackend('Testing');
        $subject->setCache($frontendProphecy->reveal());
 
        self::assertFalse($subject->get('myIdentifier'));
    }
 
    public function ‪getReturnsNotExpiredCacheEntry(): void
    {
        $frontendProphecy = $this->prophesize(FrontendInterface::class);
        $frontendProphecy->getIdentifier()->willReturn('pages');
 
        // Push a row into db
        (new ‪ConnectionPool())->getConnectionForTable('cache_pages')->insert(
            'cache_pages',
            [
                'identifier' => 'myIdentifier',
                'expires' => ‪$GLOBALS['EXEC_TIME'] + 60,
                'content' => 'myCachedContent',
            ],
            [
                'content' => ‪Connection::PARAM_LOB,
            ]
        );
 
        $subject = new ‪Typo3DatabaseBackend('Testing');
        $subject->setCache($frontendProphecy->reveal());
 
        self::assertSame('myCachedContent', $subject->get('myIdentifier'));
    }
 
    public function ‪getReturnsUnzipsNotExpiredCacheEntry(): void
    {
        $frontendProphecy = $this->prophesize(FrontendInterface::class);
        $frontendProphecy->getIdentifier()->willReturn('pages');
 
        // Push a compressed row into db
        (new ‪ConnectionPool())->getConnectionForTable('cache_pages')->insert(
            'cache_pages',
            [
                'identifier' => 'myIdentifier',
                'expires' => ‪$GLOBALS['EXEC_TIME'] + 60,
                'content' => gzcompress('myCachedContent'),
            ],
            [
                'content' => ‪Connection::PARAM_LOB,
            ]
        );
 
        // Have backend with compression enabled
        $subject = new ‪Typo3DatabaseBackend('Testing', ['compression' => true]);
        $subject->setCache($frontendProphecy->reveal());
 
        // Content comes back uncompressed
        self::assertSame('myCachedContent', $subject->get('myIdentifier'));
    }
 
    public function ‪getReturnsEmptyStringUnzipped(): void
    {
        $frontendProphecy = $this->prophesize(FrontendInterface::class);
        $frontendProphecy->getIdentifier()->willReturn('pages');
 
        // Push a compressed row into db
        (new ‪ConnectionPool())->getConnectionForTable('cache_pages')->insert(
            'cache_pages',
            [
                'identifier' => 'myIdentifier',
                'expires' => ‪$GLOBALS['EXEC_TIME'] + 60,
                'content' => gzcompress(''),
            ],
            [
                'content' => ‪Connection::PARAM_LOB,
            ]
        );
 
        // Have backend with compression enabled
        $subject = new ‪Typo3DatabaseBackend('Testing', ['compression' => true]);
        $subject->setCache($frontendProphecy->reveal());
 
        // Content comes back uncompressed
        self::assertSame('', $subject->get('myIdentifier'));
    }
 
    public function ‪hasReturnsFalseIfNoCacheEntryExists(): void
    {
        $frontendProphecy = $this->prophesize(FrontendInterface::class);
        $frontendProphecy->getIdentifier()->willReturn('pages');
 
        $subject = new ‪Typo3DatabaseBackend('Testing');
        $subject->setCache($frontendProphecy->reveal());
 
        self::assertFalse($subject->has('myIdentifier'));
    }
 
    public function ‪hasReturnsFalseForExpiredCacheEntry(): void
    {
        $frontendProphecy = $this->prophesize(FrontendInterface::class);
        $frontendProphecy->getIdentifier()->willReturn('pages');
 
        // Push an expired row into db
        (new ‪ConnectionPool())->getConnectionForTable('cache_pages')->insert(
            'cache_pages',
            [
                'identifier' => 'myIdentifier',
                'expires' => ‪$GLOBALS['EXEC_TIME'] - 60,
                'content' => 'myCachedContent',
            ],
            [
                'content' => ‪Connection::PARAM_LOB,
            ]
        );
 
        $subject = new ‪Typo3DatabaseBackend('Testing');
        $subject->setCache($frontendProphecy->reveal());
 
        self::assertFalse($subject->has('myIdentifier'));
    }
 
    public function ‪hasReturnsNotExpiredCacheEntry(): void
    {
        $frontendProphecy = $this->prophesize(FrontendInterface::class);
        $frontendProphecy->getIdentifier()->willReturn('pages');
 
        // Push a row into db
        (new ‪ConnectionPool())->getConnectionForTable('cache_pages')->insert(
            'cache_pages',
            [
                'identifier' => 'myIdentifier',
                'expires' => ‪$GLOBALS['EXEC_TIME'] + 60,
                'content' => 'myCachedContent',
            ],
            [
                'content' => ‪Connection::PARAM_LOB,
            ]
        );
 
        $subject = new ‪Typo3DatabaseBackend('Testing');
        $subject->setCache($frontendProphecy->reveal());
 
        self::assertTrue($subject->has('myIdentifier'));
    }
 
    public function ‪removeReturnsFalseIfNoEntryHasBeenRemoved(): void
    {
        $frontendProphecy = $this->prophesize(FrontendInterface::class);
        $frontendProphecy->getIdentifier()->willReturn('pages');
 
        $subject = new ‪Typo3DatabaseBackend('Testing');
        $subject->setCache($frontendProphecy->reveal());
 
        self::assertFalse($subject->remove('myIdentifier'));
    }
 
    public function ‪removeReturnsTrueIfAnEntryHasBeenRemoved(): void
    {
        $frontendProphecy = $this->prophesize(FrontendInterface::class);
        $frontendProphecy->getIdentifier()->willReturn('pages');
 
        // Push a row into db
        (new ‪ConnectionPool())->getConnectionForTable('cache_pages')->insert(
            'cache_pages',
            [
                'identifier' => 'myIdentifier',
                'expires' => ‪$GLOBALS['EXEC_TIME'] + 60,
                'content' => 'myCachedContent',
            ],
            [
                'content' => ‪Connection::PARAM_LOB,
            ]
        );
 
        $subject = new ‪Typo3DatabaseBackend('Testing');
        $subject->setCache($frontendProphecy->reveal());
 
        self::assertTrue($subject->remove('myIdentifier'));
    }
 
    public function ‪removeRemovesCorrectEntriesFromDatabase(): void
    {
        $frontendProphecy = $this->prophesize(FrontendInterface::class);
        $frontendProphecy->getIdentifier()->willReturn('pages');
 
        // Add one cache row to remove and another one that shouldn't be removed
        $cacheTableConnection = (new ‪ConnectionPool())->getConnectionForTable('cache_pages');
        $cacheTableConnection->bulkInsert(
            'cache_pages',
            [
                ['myIdentifier', ‪$GLOBALS['EXEC_TIME'] + 60, 'myCachedContent'],
                ['otherIdentifier', ‪$GLOBALS['EXEC_TIME'] + 60, 'otherCachedContent'],
            ],
            ['identifier', 'expires', 'content'],
            [
                'content' => ‪Connection::PARAM_LOB,
            ]
        );
        $subject = new ‪Typo3DatabaseBackend('Testing');
        $subject->setCache($frontendProphecy->reveal());
 
        // Add a couple of tags
        $tagsTableConnection = (new ‪ConnectionPool())->getConnectionForTable('cache_pages_tags');
        $tagsTableConnection->bulkInsert(
            'cache_pages_tags',
            [
                ['myIdentifier', 'aTag'],
                ['myIdentifier', 'otherTag'],
                ['otherIdentifier', 'aTag'],
                ['otherIdentifier', 'otherTag'],
            ],
            ['identifier', 'tag']
        );
 
        $subject->remove('myIdentifier');
 
        // cache row with removed identifier has been removed, other one exists
        self::assertSame(0, $cacheTableConnection->count('*', 'cache_pages', ['identifier' => 'myIdentifier']));
        self::assertSame(1, $cacheTableConnection->count('*', 'cache_pages', ['identifier' => 'otherIdentifier']));
 
        // tags of myIdentifier should have been removed, others exist
        self::assertSame(0, $tagsTableConnection->count('*', 'cache_pages_tags', ['identifier' => 'myIdentifier']));
        self::assertSame(2, $tagsTableConnection->count('*', 'cache_pages_tags', ['identifier' => 'otherIdentifier']));
    }
 
    public function ‪findIdentifiersByTagReturnsIdentifierTaggedWithGivenTag(): void
    {
        $subject = $this->‪getSubjectObject();
 
        self::assertEquals(['idA' => 'idA'], $subject->findIdentifiersByTag('tagA'));
        self::assertEquals(['idA' => 'idA', 'idB' => 'idB'], $subject->findIdentifiersByTag('tagB'));
        self::assertEquals(['idB' => 'idB', 'idC' => 'idC'], $subject->findIdentifiersByTag('tagC'));
    }
 
    public function ‪flushByTagWorksWithEmptyCacheTablesWithMysql(): void
    {
        $subject = $this->‪getSubjectObject(true);
        $subject->flushByTag('tagB');
    }
 
    public function ‪flushByTagsWorksWithEmptyCacheTablesWithMysql(): void
    {
        $subject = $this->‪getSubjectObject(true);
        $subject->flushByTags(['tagB']);
    }
 
    public function ‪flushByTagRemovesCorrectRowsFromDatabaseWithMysql(): void
    {
        $subject = $this->‪getSubjectObject(true);
        $subject->flushByTag('tagB');
 
        $cacheTableConnection = (new ‪ConnectionPool())->getConnectionForTable('cache_pages');
        self::assertSame(0, $cacheTableConnection->count('*', 'cache_pages', ['identifier' => 'idA']));
        self::assertSame(0, $cacheTableConnection->count('*', 'cache_pages', ['identifier' => 'idB']));
        self::assertSame(1, $cacheTableConnection->count('*', 'cache_pages', ['identifier' => 'idC']));
        $tagsTableConnection = (new ‪ConnectionPool())->getConnectionForTable('cache_pages_tags');
        self::assertSame(0, $tagsTableConnection->count('*', 'cache_pages_tags', ['identifier' => 'idA']));
        self::assertSame(0, $tagsTableConnection->count('*', 'cache_pages_tags', ['identifier' => 'idB']));
        self::assertSame(2, $tagsTableConnection->count('*', 'cache_pages_tags', ['identifier' => 'idC']));
    }
 
    public function ‪flushByTagsRemovesCorrectRowsFromDatabaseWithMysql(): void
    {
        $subject = $this->‪getSubjectObject(true);
        $subject->flushByTags(['tagC', 'tagD']);
 
        $cacheTableConnection = (new ‪ConnectionPool())->getConnectionForTable('cache_pages');
        self::assertSame(1, $cacheTableConnection->count('*', 'cache_pages', ['identifier' => 'idA']));
        self::assertSame(0, $cacheTableConnection->count('*', 'cache_pages', ['identifier' => 'idB']));
        self::assertSame(0, $cacheTableConnection->count('*', 'cache_pages', ['identifier' => 'idC']));
        $tagsTableConnection = (new ‪ConnectionPool())->getConnectionForTable('cache_pages_tags');
        self::assertSame(2, $tagsTableConnection->count('*', 'cache_pages_tags', ['identifier' => 'idA']));
        self::assertSame(0, $tagsTableConnection->count('*', 'cache_pages_tags', ['identifier' => 'idB']));
        self::assertSame(0, $tagsTableConnection->count('*', 'cache_pages_tags', ['identifier' => 'idC']));
    }
 
    public function ‪flushByTagWorksWithEmptyCacheTablesWithNonMysql(): void
    {
        $subject = $this->‪getSubjectObject(true, false);
        $subject->flushByTag('tagB');
    }
 
    public function ‪flushByTagsWorksWithEmptyCacheTablesWithNonMysql(): void
    {
        $subject = $this->‪getSubjectObject(true, false);
        $subject->flushByTags(['tagB', 'tagC']);
    }
 
    public function ‪flushByTagRemovesCorrectRowsFromDatabaseWithNonMysql(): void
    {
        $subject = $this->‪getSubjectObject(true, false);
        $subject->flushByTag('tagB');
 
        $cacheTableConnection = (new ‪ConnectionPool())->getConnectionForTable('cache_pages');
        self::assertSame(0, $cacheTableConnection->count('*', 'cache_pages', ['identifier' => 'idA']));
        self::assertSame(0, $cacheTableConnection->count('*', 'cache_pages', ['identifier' => 'idB']));
        self::assertSame(1, $cacheTableConnection->count('*', 'cache_pages', ['identifier' => 'idC']));
        $tagsTableConnection = (new ‪ConnectionPool())->getConnectionForTable('cache_pages_tags');
        self::assertSame(0, $tagsTableConnection->count('*', 'cache_pages_tags', ['identifier' => 'idA']));
        self::assertSame(0, $tagsTableConnection->count('*', 'cache_pages_tags', ['identifier' => 'idB']));
        self::assertSame(2, $tagsTableConnection->count('*', 'cache_pages_tags', ['identifier' => 'idC']));
    }
 
    public function ‪flushByTagsRemovesCorrectRowsFromDatabaseWithNonMysql(): void
    {
        $subject = $this->‪getSubjectObject(true, false);
        $subject->flushByTags(['tagC', 'tagD']);
 
        $cacheTableConnection = (new ‪ConnectionPool())->getConnectionForTable('cache_pages');
        self::assertSame(1, $cacheTableConnection->count('*', 'cache_pages', ['identifier' => 'idA']));
        self::assertSame(0, $cacheTableConnection->count('*', 'cache_pages', ['identifier' => 'idB']));
        self::assertSame(0, $cacheTableConnection->count('*', 'cache_pages', ['identifier' => 'idC']));
        $tagsTableConnection = (new ‪ConnectionPool())->getConnectionForTable('cache_pages_tags');
        self::assertSame(2, $tagsTableConnection->count('*', 'cache_pages_tags', ['identifier' => 'idA']));
        self::assertSame(0, $tagsTableConnection->count('*', 'cache_pages_tags', ['identifier' => 'idB']));
        self::assertSame(0, $tagsTableConnection->count('*', 'cache_pages_tags', ['identifier' => 'idC']));
    }
 
    public function ‪collectGarbageWorksWithEmptyTableWithMysql(): void
    {
        $subject = $this->‪getSubjectObject(true);
        $subject->collectGarbage();
    }
 
    public function ‪collectGarbageRemovesCacheEntryWithExpiredLifetimeWithMysql(): void
    {
        $frontendProphecy = $this->prophesize(FrontendInterface::class);
        $frontendProphecy->getIdentifier()->willReturn('pages');
 
        // Must be mocked here to test for "mysql" version implementation
        $subject = $this->getMockBuilder(Typo3DatabaseBackend::class)
            ->onlyMethods(['isConnectionMysql'])
            ->setConstructorArgs(['Testing'])
            ->getMock();
        $subject->expects(self::once())->method('isConnectionMysql')->willReturn(true);
        $subject->setCache($frontendProphecy->reveal());
 
        // idA should be expired after EXEC_TIME manipulation, idB should stay
        $subject->set('idA', 'dataA', [], 60);
        $subject->set('idB', 'dataB', [], 240);
 
        ‪$GLOBALS['EXEC_TIME'] = ‪$GLOBALS['EXEC_TIME'] + 120;
 
        $subject->collectGarbage();
 
        $cacheTableConnection = (new ‪ConnectionPool())->getConnectionForTable('cache_pages');
        self::assertSame(0, $cacheTableConnection->count('*', 'cache_pages', ['identifier' => 'idA']));
        self::assertSame(1, $cacheTableConnection->count('*', 'cache_pages', ['identifier' => 'idB']));
    }
 
    public function ‪collectGarbageRemovesTagEntriesForCacheEntriesWithExpiredLifetimeWithMysql(): void
    {
        $frontendProphecy = $this->prophesize(FrontendInterface::class);
        $frontendProphecy->getIdentifier()->willReturn('pages');
 
        // Must be mocked here to test for "mysql" version implementation
        $subject = $this->getMockBuilder(Typo3DatabaseBackend::class)
            ->onlyMethods(['isConnectionMysql'])
            ->setConstructorArgs(['Testing'])
            ->getMock();
        $subject->expects(self::once())->method('isConnectionMysql')->willReturn(true);
        $subject->setCache($frontendProphecy->reveal());
 
        // tag rows tagA and tagB should be removed by garbage collector after EXEC_TIME manipulation
        $subject->set('idA', 'dataA', ['tagA', 'tagB'], 60);
        $subject->set('idB', 'dataB', ['tagB', 'tagC'], 240);
 
        ‪$GLOBALS['EXEC_TIME'] = ‪$GLOBALS['EXEC_TIME'] + 120;
 
        $subject->collectGarbage();
 
        $tagsTableConnection = (new ‪ConnectionPool())->getConnectionForTable('cache_pages_tags');
        self::assertSame(0, $tagsTableConnection->count('*', 'cache_pages_tags', ['identifier' => 'idA']));
        self::assertSame(2, $tagsTableConnection->count('*', 'cache_pages_tags', ['identifier' => 'idB']));
    }
 
    public function ‪collectGarbageRemovesOrphanedTagEntriesFromTagsTableWithMysql(): void
    {
        $frontendProphecy = $this->prophesize(FrontendInterface::class);
        $frontendProphecy->getIdentifier()->willReturn('pages');
 
        // Must be mocked here to test for "mysql" version implementation
        $subject = $this->getMockBuilder(Typo3DatabaseBackend::class)
            ->onlyMethods(['isConnectionMysql'])
            ->setConstructorArgs(['Testing'])
            ->getMock();
        $subject->expects(self::once())->method('isConnectionMysql')->willReturn(true);
        $subject->setCache($frontendProphecy->reveal());
 
        // tag rows tagA and tagB should be removed by garbage collector after EXEC_TIME manipulation
        $subject->set('idA', 'dataA', ['tagA', 'tagB'], 60);
        $subject->set('idB', 'dataB', ['tagB', 'tagC'], 240);
 
        $tagsTableConnection = (new ‪ConnectionPool())->getConnectionForTable('cache_pages_tags');
 
        // Push two orphaned tag row into db - tags that have no related cache record anymore for whatever reason
        $tagsTableConnection->insert(
            'cache_pages_tags',
            [
                'identifier' => 'idC',
                'tag' => 'tagC',
            ]
        );
        $tagsTableConnection->insert(
            'cache_pages_tags',
            [
                'identifier' => 'idC',
                'tag' => 'tagD',
            ]
        );
 
        ‪$GLOBALS['EXEC_TIME'] = ‪$GLOBALS['EXEC_TIME'] + 120;
 
        $subject->collectGarbage();
 
        self::assertSame(0, $tagsTableConnection->count('*', 'cache_pages_tags', ['identifier' => 'idA']));
        self::assertSame(2, $tagsTableConnection->count('*', 'cache_pages_tags', ['identifier' => 'idB']));
        self::assertSame(0, $tagsTableConnection->count('*', 'cache_pages_tags', ['identifier' => 'idC']));
    }
 
    public function ‪collectGarbageWorksWithEmptyTableWithNonMysql(): void
    {
        $frontendProphecy = $this->prophesize(FrontendInterface::class);
        $frontendProphecy->getIdentifier()->willReturn('pages');
 
        // Must be mocked here to test for "mysql" version implementation
        $subject = $this->getMockBuilder(Typo3DatabaseBackend::class)
            ->onlyMethods(['isConnectionMysql'])
            ->setConstructorArgs(['Testing'])
            ->getMock();
        $subject->expects(self::once())->method('isConnectionMysql')->willReturn(false);
        $subject->setCache($frontendProphecy->reveal());
 
        $subject->collectGarbage();
    }
 
    public function ‪collectGarbageRemovesCacheEntryWithExpiredLifetimeWithNonMysql(): void
    {
        $frontendProphecy = $this->prophesize(FrontendInterface::class);
        $frontendProphecy->getIdentifier()->willReturn('pages');
 
        // Must be mocked here to test for "mysql" version implementation
        $subject = $this->getMockBuilder(Typo3DatabaseBackend::class)
            ->onlyMethods(['isConnectionMysql'])
            ->setConstructorArgs(['Testing'])
            ->getMock();
        $subject->expects(self::once())->method('isConnectionMysql')->willReturn(false);
        $subject->setCache($frontendProphecy->reveal());
 
        // idA should be expired after EXEC_TIME manipulation, idB should stay
        $subject->set('idA', 'dataA', [], 60);
        $subject->set('idB', 'dataB', [], 240);
 
        ‪$GLOBALS['EXEC_TIME'] = ‪$GLOBALS['EXEC_TIME'] + 120;
 
        $subject->collectGarbage();
 
        $cacheTableConnection = (new ‪ConnectionPool())->getConnectionForTable('cache_pages');
        self::assertSame(0, $cacheTableConnection->count('*', 'cache_pages', ['identifier' => 'idA']));
        self::assertSame(1, $cacheTableConnection->count('*', 'cache_pages', ['identifier' => 'idB']));
    }
 
    public function ‪collectGarbageRemovesTagEntriesForCacheEntriesWithExpiredLifetimeWithNonMysql(): void
    {
        $frontendProphecy = $this->prophesize(FrontendInterface::class);
        $frontendProphecy->getIdentifier()->willReturn('pages');
 
        // Must be mocked here to test for "mysql" version implementation
        $subject = $this->getMockBuilder(Typo3DatabaseBackend::class)
            ->onlyMethods(['isConnectionMysql'])
            ->setConstructorArgs(['Testing'])
            ->getMock();
        $subject->expects(self::once())->method('isConnectionMysql')->willReturn(false);
        $subject->setCache($frontendProphecy->reveal());
 
        // tag rows tagA and tagB should be removed by garbage collector after EXEC_TIME manipulation
        $subject->set('idA', 'dataA', ['tagA', 'tagB'], 60);
        $subject->set('idB', 'dataB', ['tagB', 'tagC'], 240);
 
        ‪$GLOBALS['EXEC_TIME'] = ‪$GLOBALS['EXEC_TIME'] + 120;
 
        $subject->collectGarbage();
 
        $tagsTableConnection = (new ‪ConnectionPool())->getConnectionForTable('cache_pages_tags');
        self::assertSame(0, $tagsTableConnection->count('*', 'cache_pages_tags', ['identifier' => 'idA']));
        self::assertSame(2, $tagsTableConnection->count('*', 'cache_pages_tags', ['identifier' => 'idB']));
    }
 
    public function ‪collectGarbageRemovesOrphanedTagEntriesFromTagsTableWithNonMysql(): void
    {
        $frontendProphecy = $this->prophesize(FrontendInterface::class);
        $frontendProphecy->getIdentifier()->willReturn('pages');
 
        // Must be mocked here to test for "mysql" version implementation
        $subject = $this->getMockBuilder(Typo3DatabaseBackend::class)
            ->onlyMethods(['isConnectionMysql'])
            ->setConstructorArgs(['Testing'])
            ->getMock();
        $subject->expects(self::once())->method('isConnectionMysql')->willReturn(false);
        $subject->setCache($frontendProphecy->reveal());
 
        // tag rows tagA and tagB should be removed by garbage collector after EXEC_TIME manipulation
        $subject->set('idA', 'dataA', ['tagA', 'tagB'], 60);
        $subject->set('idB', 'dataB', ['tagB', 'tagC'], 240);
 
        $tagsTableConnection = (new ‪ConnectionPool())->getConnectionForTable('cache_pages_tags');
 
        // Push two orphaned tag row into db - tags that have no related cache record anymore for whatever reason
        $tagsTableConnection->insert(
            'cache_pages_tags',
            [
                'identifier' => 'idC',
                'tag' => 'tagC',
            ]
        );
        $tagsTableConnection->insert(
            'cache_pages_tags',
            [
                'identifier' => 'idC',
                'tag' => 'tagD',
            ]
        );
 
        ‪$GLOBALS['EXEC_TIME'] = ‪$GLOBALS['EXEC_TIME'] + 120;
 
        $subject->collectGarbage();
 
        self::assertSame(0, $tagsTableConnection->count('*', 'cache_pages_tags', ['identifier' => 'idA']));
        self::assertSame(2, $tagsTableConnection->count('*', 'cache_pages_tags', ['identifier' => 'idB']));
        self::assertSame(0, $tagsTableConnection->count('*', 'cache_pages_tags', ['identifier' => 'idC']));
    }
 
    public function ‪flushLeavesCacheAndTagsTableEmpty(): void
    {
        $frontendProphecy = $this->prophesize(FrontendInterface::class);
        $frontendProphecy->getIdentifier()->willReturn('pages');
 
        $subject = new ‪Typo3DatabaseBackend('Testing');
        $subject->setCache($frontendProphecy->reveal());
 
        $subject->set('idA', 'dataA', ['tagA', 'tagB']);
 
        $subject->flush();
 
        $cacheTableConnection = (new ‪ConnectionPool())->getConnectionForTable('cache_pages');
        $tagsTableConnection = (new ‪ConnectionPool())->getConnectionForTable('cache_pages_tags');
        self::assertSame(0, $cacheTableConnection->count('*', 'cache_pages', []));
        self::assertSame(0, $tagsTableConnection->count('*', 'cache_pages_tags', []));
    }
 
    protected function ‪getSubjectObject($returnMockObject = false, $isConnectionMysql = true): ‪Typo3DatabaseBackend
    {
        $frontendProphecy = $this->prophesize(FrontendInterface::class);
        $frontendProphecy->getIdentifier()->willReturn('pages');
 
        if (!$returnMockObject) {
            $subject = new ‪Typo3DatabaseBackend('Testing');
        } else {
            $subject = $this->getMockBuilder(Typo3DatabaseBackend::class)
                ->onlyMethods(['isConnectionMysql'])
                ->setConstructorArgs(['Testing'])
                ->getMock();
            $subject->expects(self::once())->method('isConnectionMysql')->willReturn($isConnectionMysql);
        }
        $subject->setCache($frontendProphecy->reveal());
 
        $subject->set('idA', 'dataA', ['tagA', 'tagB']);
        $subject->set('idB', 'dataB', ['tagB', 'tagC']);
        $subject->set('idC', 'dataC', ['tagC', 'tagD']);
 
        return $subject;
    }
}