PagesAndTtContentWithImagesInFilledDatabaseTest.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\Impexp\Tests\Functional\Import;
 
use ‪TYPO3\CMS\Core\Core\Environment;
use ‪TYPO3\CMS\Core\Database\Connection;
use ‪TYPO3\CMS\Core\Utility\GeneralUtility;
use ‪TYPO3\CMS\Impexp\Import;
use ‪TYPO3\CMS\Impexp\Tests\Functional\AbstractImportExportTestCase;
 
class ‪PagesAndTtContentWithImagesInFilledDatabaseTest extends ‪AbstractImportExportTestCase
{
    protected ‪$additionalFoldersToCreate = [
        '/fileadmin/user_upload',
    ];
 
    protected ‪$pathsToProvideInTestInstance = [
        'typo3/sysext/impexp/Tests/Functional/Fixtures/Folders/fileadmin/user_upload/typo3_image2.jpg' => 'fileadmin/user_upload/typo3_image2.jpg',
    ];
 
    public function ‪importPagesAndRelatedTtContentWithDifferentImageToExistingData(): void
    {
        $this->importCSVDataSet(__DIR__ . '/../Fixtures/DatabaseImports/pages.csv');
        $this->importCSVDataSet(__DIR__ . '/../Fixtures/DatabaseImports/tt_content-with-image.csv');
        $this->importDataSet(__DIR__ . '/../Fixtures/DatabaseImports/sys_language.xml');
        $this->importCSVDataSet(__DIR__ . '/../Fixtures/DatabaseImports/sys_file.csv');
        $this->importCSVDataSet(__DIR__ . '/../Fixtures/DatabaseImports/sys_file_metadata.csv');
        $this->importCSVDataSet(__DIR__ . '/../Fixtures/DatabaseImports/sys_file_reference.csv');
        $this->importDataSet(__DIR__ . '/../Fixtures/DatabaseImports/sys_file_storage.xml');
 
        $subject = GeneralUtility::makeInstance(Import::class);
        $subject->setPid(0);
        $subject->loadFile(
            'EXT:impexp/Tests/Functional/Fixtures/XmlImports/pages-and-ttcontent-with-existing-different-image.xml',
            true
        );
        $subject->importData();
 
        $this->testFilesToDelete[] = ‪Environment::getPublicPath() . '/fileadmin/user_upload/typo3_image2_01.jpg';
 
        $this->assertCSVDataSet(__DIR__ . '/../Fixtures/DatabaseAssertions/importPagesAndRelatedTtContentWithDifferentImageToExistingData.csv');
 
        self::assertFileEquals(__DIR__ . '/../Fixtures/Folders/fileadmin/user_upload/typo3_image2.jpg', ‪Environment::getPublicPath() . '/fileadmin/user_upload/typo3_image2.jpg');
        self::assertFileEquals(__DIR__ . '/../Fixtures/FileAssertions/typo3_image2_01.jpg', ‪Environment::getPublicPath() . '/fileadmin/user_upload/typo3_image2_01.jpg');
    }
 
    public function ‪updatePagesAndRelatedTtContentWithDifferentImageToExistingData(): void
    {
        $this->importCSVDataSet(__DIR__ . '/../Fixtures/DatabaseImports/pages.csv');
        $this->importCSVDataSet(__DIR__ . '/../Fixtures/DatabaseImports/tt_content-with-image.csv');
        $this->importDataSet(__DIR__ . '/../Fixtures/DatabaseImports/sys_language.xml');
        $this->importCSVDataSet(__DIR__ . '/../Fixtures/DatabaseImports/sys_file.csv');
        $this->importCSVDataSet(__DIR__ . '/../Fixtures/DatabaseImports/sys_file_metadata.csv');
        $this->importCSVDataSet(__DIR__ . '/../Fixtures/DatabaseImports/sys_file_reference.csv');
        $this->importDataSet(__DIR__ . '/../Fixtures/DatabaseImports/sys_file_storage.xml');
 
        $subject = GeneralUtility::makeInstance(Import::class);
        try {
            $subject->setPid(0);
            $subject->setUpdate(true);
            $subject->loadFile(
                'EXT:impexp/Tests/Functional/Fixtures/XmlImports/pages-and-ttcontent-with-existing-different-image.xml',
                true
            );
            $subject->importData();
        } catch (\‪Exception $e) {
            // This warning is expected, but the import is completed anyway
            self::assertEquals(
                ['Updating sys_file records is not supported! They will be imported as new records!'],
                $subject->getErrorLog()
            );
        }
 
        $this->testFilesToDelete[] = ‪Environment::getPublicPath() . '/fileadmin/user_upload/typo3_image2_01.jpg';
 
        $this->assertCSVDataSet(__DIR__ . '/../Fixtures/DatabaseAssertions/updatePagesAndRelatedTtContentWithDifferentImageToExistingData.csv');
 
        self::assertFileEquals(__DIR__ . '/../Fixtures/Folders/fileadmin/user_upload/typo3_image2.jpg', ‪Environment::getPublicPath() . '/fileadmin/user_upload/typo3_image2.jpg');
        self::assertFileEquals(__DIR__ . '/../Fixtures/FileAssertions/typo3_image2_01.jpg', ‪Environment::getPublicPath() . '/fileadmin/user_upload/typo3_image2_01.jpg');
    }
 
    public function ‪updatePagesAndRelatedTtContentWithDifferentImageToExistingDataAndPagesAsNew(): void
    {
        $this->importCSVDataSet(__DIR__ . '/../Fixtures/DatabaseImports/pages.csv');
        $this->importCSVDataSet(__DIR__ . '/../Fixtures/DatabaseImports/tt_content-with-image.csv');
        $this->importDataSet(__DIR__ . '/../Fixtures/DatabaseImports/sys_language.xml');
        $this->importCSVDataSet(__DIR__ . '/../Fixtures/DatabaseImports/sys_file.csv');
        $this->importCSVDataSet(__DIR__ . '/../Fixtures/DatabaseImports/sys_file_metadata.csv');
        $this->importCSVDataSet(__DIR__ . '/../Fixtures/DatabaseImports/sys_file_reference.csv');
        $this->importDataSet(__DIR__ . '/../Fixtures/DatabaseImports/sys_file_storage.xml');
 
        $subject = GeneralUtility::makeInstance(Import::class);
        try {
            $subject->setPid(0);
            $subject->setUpdate(true);
            $subject->setImportMode([
                'pages:1' => ‪Import::IMPORT_MODE_AS_NEW,
                'pages:2' => ‪Import::IMPORT_MODE_AS_NEW,
            ]);
            $subject->loadFile(
                'EXT:impexp/Tests/Functional/Fixtures/XmlImports/pages-and-ttcontent-with-existing-different-image.xml',
                true
            );
            $subject->importData();
        } catch (\‪Exception $e) {
            // This warning is expected, but the import is completed anyway
            self::assertEquals(
                ['Updating sys_file records is not supported! They will be imported as new records!'],
                $subject->getErrorLog()
            );
        }
 
        $this->testFilesToDelete[] = ‪Environment::getPublicPath() . '/fileadmin/user_upload/typo3_image2_01.jpg';
 
        $this->assertCSVDataSet(__DIR__ . '/../Fixtures/DatabaseAssertions/updatePagesAndRelatedTtContentWithDifferentImageToExistingDataAndPagesAsNew.csv');
 
        self::assertFileEquals(__DIR__ . '/../Fixtures/Folders/fileadmin/user_upload/typo3_image2.jpg', ‪Environment::getPublicPath() . '/fileadmin/user_upload/typo3_image2.jpg');
        self::assertFileEquals(__DIR__ . '/../Fixtures/FileAssertions/typo3_image2_01.jpg', ‪Environment::getPublicPath() . '/fileadmin/user_upload/typo3_image2_01.jpg');
    }
 
    public function ‪updatePagesAndRelatedTtContentKeepsRelationsBetweenImportedPagesAndRecords(): void
    {
        $this->importCSVDataSet(__DIR__ . '/../Fixtures/DatabaseImports/pages.csv');
        $this->importCSVDataSet(__DIR__ . '/../Fixtures/DatabaseImports/tt_content-with-image.csv');
        $this->importDataSet(__DIR__ . '/../Fixtures/DatabaseImports/sys_language.xml');
        $this->importCSVDataSet(__DIR__ . '/../Fixtures/DatabaseImports/sys_file.csv');
        $this->importCSVDataSet(__DIR__ . '/../Fixtures/DatabaseImports/sys_file_metadata.csv');
        $this->importCSVDataSet(__DIR__ . '/../Fixtures/DatabaseImports/sys_file_reference.csv');
        $this->importDataSet(__DIR__ . '/../Fixtures/DatabaseImports/sys_file_storage.xml');
 
        $subject = GeneralUtility::makeInstance(Import::class);
        try {
            $subject->setPid(0);
            $subject->setUpdate(true);
            $subject->loadFile(
                'EXT:impexp/Tests/Functional/Fixtures/XmlImports/pages-and-ttcontent-with-image-with-forced-uids.xml',
                true
            );
            $subject->importData();
        } catch (\‪Exception $e) {
            // This warning is expected, but the import is completed anyway
            self::assertEquals(
                ['Updating sys_file records is not supported! They will be imported as new records!'],
                $subject->getErrorLog()
            );
        }
 
        $this->testFilesToDelete[] = ‪Environment::getPublicPath() . '/fileadmin/user_upload/typo3_image2_01.jpg';
 
        $this->assertCSVDataSet(__DIR__ . '/../Fixtures/DatabaseAssertions/updatePagesAndRelatedTtContentKeepsRelationsBetweenImportedPagesAndRecords.csv');
 
        self::assertFileEquals(__DIR__ . '/../Fixtures/Folders/fileadmin/user_upload/typo3_image2.jpg', ‪Environment::getPublicPath() . '/fileadmin/user_upload/typo3_image2.jpg');
    }
 
    public function ‪importPagesAndRelatedTtContentWithSameImageToExistingData(): void
    {
        $this->importCSVDataSet(__DIR__ . '/../Fixtures/DatabaseImports/pages.csv');
        $this->importCSVDataSet(__DIR__ . '/../Fixtures/DatabaseImports/tt_content-with-image.csv');
        $this->importDataSet(__DIR__ . '/../Fixtures/DatabaseImports/sys_language.xml');
        $this->importCSVDataSet(__DIR__ . '/../Fixtures/DatabaseImports/sys_file.csv');
        $this->importCSVDataSet(__DIR__ . '/../Fixtures/DatabaseImports/sys_file_metadata.csv');
        $this->importCSVDataSet(__DIR__ . '/../Fixtures/DatabaseImports/sys_file_reference.csv');
        $this->importDataSet(__DIR__ . '/../Fixtures/DatabaseImports/sys_file_storage.xml');
 
        $subject = GeneralUtility::makeInstance(Import::class);
        $subject->setPid(0);
        $subject->loadFile(
            'EXT:impexp/Tests/Functional/Fixtures/XmlImports/pages-and-ttcontent-with-existing-same-image.xml',
            true
        );
        $subject->importData();
 
        $this->assertCSVDataSet(__DIR__ . '/../Fixtures/DatabaseAssertions/importPagesAndRelatedTtContentWithSameImageToExistingData.csv');
 
        self::assertFileEquals(__DIR__ . '/../Fixtures/Folders/fileadmin/user_upload/typo3_image2.jpg', ‪Environment::getPublicPath() . '/fileadmin/user_upload/typo3_image2.jpg');
    }
 
    public function ‪importPagesAndTtContentWithRemappingNewSysFileEntries(): void
    {
        // Have a single sys_file entry with uid 1
        $this->importCSVDataSet(__DIR__ . '/../Fixtures/DatabaseImports/sys_file_single_image.csv');
        $this->importDataSet(__DIR__ . '/../Fixtures/DatabaseImports/sys_file_storage.xml');
 
        $subject = GeneralUtility::makeInstance(Import::class);
        $subject->setPid(0);
        // Import file with sys_file:1 and sys_file:2, where sys_file:1 has one connected
        // content element, and sys_file:2 has two connected content elements.
        $subject->loadFile(
            'EXT:impexp/Tests/Functional/Fixtures/XmlImports/pages-and-ttcontent-with-two-images.xml',
            true
        );
        $subject->importData();
 
        $this->testFilesToDelete[] = ‪Environment::getPublicPath() . '/fileadmin/user_upload/used-1.jpg';
        $this->testFilesToDelete[] = ‪Environment::getPublicPath() . '/fileadmin/user_upload/used-2.jpg';
 
        // Expect mapping is updated: one content element should still reference new sys_file:2,
        // two others should reference new sys_file:3
        $this->assertCSVDataSet(__DIR__ . '/../Fixtures/DatabaseAssertions/importPagesAndTtContentWithRemappingNewSysFileEntries.csv');
    }
 
    public function ‪importImageIntoSystemAndMatchingThePathOfTheSecondStorage(): void
    {
        $this->importCSVDataSet(__DIR__ . '/../Fixtures/DatabaseImports/sys_file_single_image.csv');
        $this->importCSVDataSet(__DIR__ . '/../Fixtures/DatabaseImports/sys_file_storages.csv');
 
        $subject = GeneralUtility::makeInstance(Import::class);
        $subject->setPid(0);
        $subject->loadFile(
            'EXT:impexp/Tests/Functional/Fixtures/XmlImports/pages-and-ttcontent-with-two-images.xml',
            true
        );
        $subject->checkImportPrerequisites();
        self::assertTrue(true);
    }
 
    public function ‪importPagesAndRelatedTtContentKeepsRelationBetweenImportedFlexFormsAndPages(): void
    {
        $this->importCSVDataSet(__DIR__ . '/../Fixtures/DatabaseImports/pages.csv');
 
        ‪$GLOBALS['TCA']['tt_content']['columns']['pi_flexform']['config']['ds']['default'] = '
<T3DataStructure>
    <ROOT>
        <type>array</type>
        <el>
            <flexFormRelation>
                <TCEforms>
                    <label>FlexForm relation</label>
                    <config>
                        <type>group</type>
                        <allowed>pages</allowed>
                        <size>1</size>
                        <maxitems>1</maxitems>
                        <minitems>0</minitems>
                    </config>
                </TCEforms>
            </flexFormRelation>
        </el>
    </ROOT>
</T3DataStructure>';
 
        $subject = GeneralUtility::makeInstance(Import::class);
        $subject->setPid(1);
        $subject->loadFile(
            'EXT:impexp/Tests/Functional/Fixtures/XmlImports/pages-and-ttcontent-with-flexform-relation.xml',
            true
        );
        $subject->importData();
 
        $queryBuilder = $this->getConnectionPool()->getQueryBuilderForTable('tt_content');
        $originalUidIsNotActualUid = $queryBuilder
            ->count('uid')
            ->from('tt_content')
            ->where($queryBuilder->expr()->like(
                'pi_flexform',
                $queryBuilder->createNamedParameter('%<value index="vDEF">4</value>%', ‪Connection::PARAM_STR)
            ))
            ->executeQuery()
            ->fetchOne();
 
        self::assertEquals(1, $originalUidIsNotActualUid);
    }
 
    public function ‪importPagesAndRelatedTtContentKeepsRelationBetweenImportedFlexFormSoftReferenceAndRelatedRecord(): void
    {
        $this->importCSVDataSet(__DIR__ . '/../Fixtures/DatabaseImports/sys_file_single_image.csv');
 
        ‪$GLOBALS['TCA']['tt_content']['columns']['pi_flexform']['config']['ds']['default'] = $this->‪getFlexFormSoftReferenceDataStructure();
 
        $subject = GeneralUtility::makeInstance(Import::class);
        $subject->setPid(0);
        $subject->loadFile(
            'EXT:impexp/Tests/Functional/Fixtures/XmlExports/pages-and-ttcontent-with-flexform-softrefs.xml',
            true
        );
        $subject->importData();
 
        $this->testFilesToDelete[] = ‪Environment::getPublicPath() . '/fileadmin/form_definitions/flexFormWithSoftReference.form.yaml';
 
        $this->assertCSVDataSet(__DIR__ . '/../Fixtures/DatabaseAssertions/importPagesAndRelatedTtContentWithFlexFormSoftReference.csv');
 
        self::assertFileEquals(
            __DIR__ . '/../Fixtures/Folders/fileadmin/form_definitions/flexFormWithSoftReference.form.yaml',
            ‪Environment::getPublicPath() . '/fileadmin/form_definitions/flexFormWithSoftReference.form.yaml'
        );
    }
 
    public function ‪importPagesAndRelatedTtContentCanKeepOriginalFlexFormSoftReference(): void
    {
        $this->importCSVDataSet(__DIR__ . '/../Fixtures/DatabaseImports/sys_file_single_image.csv');
 
        ‪$GLOBALS['TCA']['tt_content']['columns']['pi_flexform']['config']['ds']['default'] = $this->‪getFlexFormSoftReferenceDataStructure();
 
        $subject = GeneralUtility::makeInstance(Import::class);
        $subject->setPid(0);
        $subject->loadFile(
            'EXT:impexp/Tests/Functional/Fixtures/XmlExports/pages-and-ttcontent-with-flexform-softrefs.xml',
            true
        );
        $subject->setSoftrefCfg(['2f9299a90b56944746e4cadb753a6a70' => ['mode' => ‪Import::SOFTREF_IMPORT_MODE_EXCLUDE]]);
        $subject->importData();
 
        $this->testFilesToDelete[] = ‪Environment::getPublicPath() . '/fileadmin/form_definitions/flexFormWithSoftReference.form.yaml';
 
        $this->assertCSVDataSet(__DIR__ . '/../Fixtures/DatabaseAssertions/importPagesAndRelatedTtContentWithExcludedFlexFormSoftReference.csv');
 
        self::assertFileEquals(
            __DIR__ . '/../Fixtures/Folders/fileadmin/form_definitions/flexFormWithSoftReference.form.yaml',
            ‪Environment::getPublicPath() . '/fileadmin/form_definitions/flexFormWithSoftReference.form.yaml'
        );
    }
 
    public function ‪importPagesAndRelatedTtContentCanEditFlexFormSoftReference(): void
    {
        $this->importCSVDataSet(__DIR__ . '/../Fixtures/DatabaseImports/sys_file_single_image.csv');
 
        ‪$GLOBALS['TCA']['tt_content']['columns']['pi_flexform']['config']['ds']['default'] = $this->‪getFlexFormSoftReferenceDataStructure();
 
        $subject = GeneralUtility::makeInstance(Import::class);
        $subject->setPid(0);
        $subject->loadFile(
            'EXT:impexp/Tests/Functional/Fixtures/XmlExports/pages-and-ttcontent-with-flexform-softrefs.xml',
            true
        );
        $subject->setSoftrefCfg(['2f9299a90b56944746e4cadb753a6a70' => ['mode' => ‪Import::SOFTREF_IMPORT_MODE_EDITABLE]]);
        $subject->setSoftrefInputValues(['2f9299a90b56944746e4cadb753a6a70' => '1:1']);
        $subject->importData();
 
        $this->testFilesToDelete[] = ‪Environment::getPublicPath() . '/fileadmin/form_definitions/flexFormWithSoftReference.form.yaml';
 
        $this->assertCSVDataSet(__DIR__ . '/../Fixtures/DatabaseAssertions/importPagesAndRelatedTtContentWithEditedFlexFormSoftReference.csv');
 
        self::assertFileEquals(
            __DIR__ . '/../Fixtures/Folders/fileadmin/form_definitions/flexFormWithSoftReference.form.yaml',
            ‪Environment::getPublicPath() . '/fileadmin/form_definitions/flexFormWithSoftReference.form.yaml'
        );
    }
 
    protected function ‪getFlexFormSoftReferenceDataStructure(): string
    {
        return '
<T3DataStructure>
    <sheets>
        <sDEF>
            <ROOT>
                <type>array</type>
                <el>
                    <settings.persistenceIdentifier>
                        <TCEforms>
                            <label>FlexForm soft reference</label>
                            <config>
                                <type>select</type>
                                <renderType>selectSingle</renderType>
                                <softref>formPersistenceIdentifier</softref>
                            </config>
                        </TCEforms>
                    </settings.persistenceIdentifier>
                </el>
            </ROOT>
        </sDEF>
    </sheets>
</T3DataStructure>';
    }
}