9.5/_create_table_fragment_test_8php_source.html

<?php

declare(strict_types = 1);


namespace ‪TYPO3\CMS\Core\Tests\Unit\Database\Schema\Parser;


/*

 * 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\Core\Database\Schema\Parser\AST\AbstractCreateStatement;

use ‪TYPO3\CMS\Core\Database\Schema\Parser\AST\CreateTableStatement;

use ‪TYPO3\CMS\Core\Database\Schema\Parser\Parser;

use TYPO3\TestingFramework\Core\Unit\UnitTestCase;


class ‪CreateTableFragmentTest extends UnitTestCase

{

    public function ‪canParseCreateTableFragmentDataProvider(): array

    {

        return [

            'CREATE TABLE' => [

                'CREATE TABLE aTable (aField INT);',

                'aTable',

                false

            ],

            'CREATE TEMPORARY TABLE' => [

                'CREATE TEMPORARY TABLE aTable (aField INT);',

                'aTable',

                true

            ],

            'CREATE TABLE IF NOT EXISTS' => [

                'CREATE TABLE IF NOT EXISTS aTable (aField INT);',

                'aTable',

                false

            ],

            'CREATE TEMPORARY TABLE IF NOT EXISTS' => [

                'CREATE TEMPORARY TABLE IF NOT EXISTS aTable (aField INT);',

                'aTable',

                true

            ],

            'CREATE TABLE (quoted table name)' => [

                'CREATE TABLE `aTable` (aField INT);',

                'aTable',

                false

            ],

            'CREATE TEMPORARY TABLE (quoted table name)' => [

                'CREATE TEMPORARY TABLE `aTable` (aField INT);',

                'aTable',

                true

            ],

            'CREATE TABLE IF NOT EXISTS (quoted table name)' => [

                'CREATE TABLE IF NOT EXISTS `aTable` (aField INT);',

                'aTable',

                false

            ],

            'CREATE TEMPORARY TABLE IF NOT EXISTS (quoted table name)' => [

                'CREATE TEMPORARY TABLE IF NOT EXISTS `aTable` (aField INT);',

                'aTable',

                true

            ],

        ];

    }


    public function ‪canParseCreateTableFragment(string $statement, string $tableName, bool $isTemporary)

    {

        $subject = $this->‪createSubject($statement);

        $this->assertInstanceOf(CreateTableStatement::class, $subject);

        $this->assertSame($tableName, $subject->tableName->schemaObjectName);

        $this->assertSame($isTemporary, $subject->isTemporary);

    }


    protected function ‪createSubject(string $statement): ‪AbstractCreateStatement

    {

        ‪$parser = new ‪Parser($statement);

        return ‪$parser->getAST();

    }

}