9.5/_abstract_import_export_test_case_8php_source.html

<?php

namespace ‪TYPO3\CMS\Impexp\Tests\Functional;


/*

 * 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 ‪TYPO3\CMS\Backend\Tree\View\PageTreeView;

use ‪TYPO3\CMS\Core\Core\Bootstrap;

use ‪TYPO3\CMS\Core\Database\ConnectionPool;

use ‪TYPO3\CMS\Core\Database\Query\QueryHelper;

use ‪TYPO3\CMS\Core\Database\Query\Restriction\DeletedRestriction;

use ‪TYPO3\CMS\Core\Utility\GeneralUtility;

use ‪TYPO3\CMS\Impexp\Export;

use TYPO3\TestingFramework\Core\Functional\FunctionalTestCase;


abstract class ‪AbstractImportExportTestCase extends FunctionalTestCase

{

    protected ‪$coreExtensionsToLoad = [

        'impexp',

    ];


    protected ‪$testFilesToDelete = [];


    protected function ‪setUp()

    {

        parent::setUp();


        $backendUser = $this->setUpBackendUserFromFixture(1);

        $backendUser->workspace = 0;

        ‪Bootstrap::initializeLanguageObject();

    }


    protected function ‪tearDown()

    {

        foreach ($this->testFilesToDelete as $absoluteFileName) {

            if (@is_file($absoluteFileName)) {

                unlink($absoluteFileName);

            }

        }

        parent::tearDown();

    }


    protected function ‪setPageTree(‪Export $export, $pidToStart, $depth = 1)

    {

        $permsClause = ‪$GLOBALS['BE_USER']->getPagePermsClause(1);


        $tree = GeneralUtility::makeInstance(PageTreeView::class);

        $tree->init('AND ' . $permsClause);

        $tree->tree[] = ['row' => $pidToStart];

        $tree->buffer_idH = [];

        if ($depth > 0) {

            $tree->getTree($pidToStart, $depth, '');

        }


        $idH[$pidToStart]['uid'] = $pidToStart;

        if (!empty($tree->buffer_idH)) {

            $idH[$pidToStart]['subrow'] = $tree->buffer_idH;

        }


        $export->‪setPageTree($idH);

    }


    protected function ‪addRecordsForPid(‪Export $export, $pid, array $tables)

    {

        foreach (‪$GLOBALS['TCA'] as $table => $value) {

            if ($table !== 'pages' && (in_array($table, $tables) || in_array('_ALL', $tables))) {

                if (‪$GLOBALS['BE_USER']->check('tables_select', $table) && !‪$GLOBALS['TCA'][$table]['ctrl']['is_static']) {

                    $orderBy = ‪$GLOBALS['TCA'][$table]['ctrl']['sortby'] ?: ‪$GLOBALS['TCA'][$table]['ctrl']['default_sortby'];


                    $queryBuilder = GeneralUtility::makeInstance(ConnectionPool::class)

                        ->getQueryBuilderForTable($table);


                    $queryBuilder->getRestrictions()

                        ->removeAll()

                        ->add(GeneralUtility::makeInstance(DeletedRestriction::class));


                    $queryBuilder

                        ->select('*')

                        ->from($table)

                        ->where(

                            $queryBuilder->expr()->eq(

                                'pid',

                                $queryBuilder->createNamedParameter($pid, \PDO::PARAM_INT)

                            )

                        );


                    foreach (‪QueryHelper::parseOrderBy((string)$orderBy) as $orderPair) {

                        list($fieldName, $order) = $orderPair;

                        $queryBuilder->addOrderBy($fieldName, $order);

                    }

                    $queryBuilder->addOrderBy('uid', 'ASC');


                    $result = $queryBuilder->execute();

                    while ($row = $result->fetch()) {

                        $export->‪export_addRecord($table, $this->‪forceStringsOnRowValues($row));

                    }

                }

            }

        }

    }


    protected function ‪forceStringsOnRowValues(array $row): array

    {

        foreach ($row as $fieldName => $value) {

            // Keep null but force everything else to string

            $row[$fieldName] = $value === null ? $value : (string)$value;

        }

        return $row;

    }


    protected function ‪isCaseSensitiveFilesystem()

    {

        $caseSensitive = true;

        $path = GeneralUtility::tempnam('aAbB');


        // do the actual sensitivity check

        if (@file_exists(strtoupper($path)) && @file_exists(strtolower($path))) {

            $caseSensitive = false;

        }


        // clean filesystem

        unlink($path);

        return $caseSensitive;

    }

}