SqlSchemaMigrationServiceTest.php

Go to the documentation of this file.

<?php
namespace TYPO3\CMS\Install\Tests\Unit\Service;

/*
 * 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\Utility\GeneralUtility;
use TYPO3\CMS\Install\Service\SqlSchemaMigrationService;

class SqlSchemaMigrationServiceTest extends \TYPO3\CMS\Core\Tests\UnitTestCase
{
    protected function getSqlSchemaMigrationService()
    {
        $subject = $this->getAccessibleMock(SqlSchemaMigrationService::class, ['isDbalEnabled'], [], '', false);
        $subject->expects($this->any())->method('isDbalEnabled')->will($this->returnValue(false));

        return $subject;
    }

    protected function getDbalEnabledSqlSchemaMigrationService()
    {
        $databaseConnection = $this->getAccessibleMock(\TYPO3\CMS\Dbal\Database\DatabaseConnection::class, ['dummy'], [], '', false);
        $databaseConnection->_set('dbmsSpecifics', GeneralUtility::makeInstance(\TYPO3\CMS\Dbal\Database\Specifics\PostgresSpecifics::class));

        $subject = $this->getAccessibleMock(SqlSchemaMigrationService::class, ['isDbalEnabled', 'getDatabaseConnection'], [], '', false);
        $subject->expects($this->any())->method('isDbalEnabled')->will($this->returnValue(true));
        $subject->expects($this->any())->method('getDatabaseConnection')->will($this->returnValue($databaseConnection));

        return $subject;
    }

    public function getFieldDefinitionsFileContentHandlesMultipleWhitespacesInFieldDefinitions()
    {
        $subject = $this->getSqlSchemaMigrationService();
        // Multiple whitespaces and tabs in field definition
        $inputString = 'CREATE table atable (' . LF . 'aFieldName   int(11)' . TAB . TAB . TAB . 'unsigned   DEFAULT \'0\'' . LF . ');';
        $result = $subject->getFieldDefinitions_fileContent($inputString);

        $this->assertEquals(
            [
                'atable' => [
                    'fields' => [
                        'aFieldName' => 'int(11) unsigned default \'0\'',
                    ],
                    'extra' => [
                        'COLLATE' => '',
                    ],
                ],
            ],
            $result
        );
    }

    public function getDatabaseExtraFindsChangedFields()
    {
        $subject = $this->getSqlSchemaMigrationService();
        $differenceArray = $subject->getDatabaseExtra(
            [
                'tx_foo' => [
                    'fields' => [
                        'foo' => 'varchar(999) DEFAULT \'0\' NOT NULL'
                    ]
                ]
            ],
            [
                'tx_foo' => [
                    'fields' => [
                        'foo' => 'varchar(255) DEFAULT \'0\' NOT NULL'
                    ]
                ]
            ]
        );

        $this->assertEquals(
            $differenceArray,
            [
                'extra' => [],
                'diff' => [
                    'tx_foo' => [
                        'fields' => [
                            'foo' => 'varchar(999) DEFAULT \'0\' NOT NULL'
                        ]
                    ]
                ],
                'diff_currentValues' => [
                    'tx_foo' => [
                        'fields' => [
                            'foo' => 'varchar(255) DEFAULT \'0\' NOT NULL'
                        ]
                    ]
                ]
            ]
        );
    }

    public function getDatabaseExtraFindsChangedFieldsIncludingNull()
    {
        $subject = $this->getSqlSchemaMigrationService();
        $differenceArray = $subject->getDatabaseExtra(
            [
                'tx_foo' => [
                    'fields' => [
                        'foo' => 'varchar(999) NULL'
                    ]
                ]
            ],
            [
                'tx_foo' => [
                    'fields' => [
                        'foo' => 'varchar(255) NULL'
                    ]
                ]
            ]
        );

        $this->assertEquals(
            $differenceArray,
            [
                'extra' => [],
                'diff' => [
                    'tx_foo' => [
                        'fields' => [
                            'foo' => 'varchar(999) NULL'
                        ]
                    ]
                ],
                'diff_currentValues' => [
                    'tx_foo' => [
                        'fields' => [
                            'foo' => 'varchar(255) NULL'
                        ]
                    ]
                ]
            ]
        );
    }

    public function getDatabaseExtraFindsChangedFieldsIgnoreNotNull()
    {
        $subject = $this->getSqlSchemaMigrationService();
        $differenceArray = $subject->getDatabaseExtra(
            [
                'tx_foo' => [
                    'fields' => [
                        'foo' => 'varchar(999) DEFAULT \'0\' NOT NULL'
                    ]
                ]
            ],
            [
                'tx_foo' => [
                    'fields' => [
                        'foo' => 'varchar(255) DEFAULT \'0\' NOT NULL'
                    ]
                ]
            ],
            '',
            true
        );

        $this->assertEquals(
            $differenceArray,
            [
                'extra' => [],
                'diff' => [
                    'tx_foo' => [
                        'fields' => [
                            'foo' => 'varchar(999) DEFAULT \'0\''
                        ]
                    ]
                ],
                'diff_currentValues' => [
                    'tx_foo' => [
                        'fields' => [
                            'foo' => 'varchar(255) DEFAULT \'0\''
                        ]
                    ]
                ]
            ]
        );
    }

    public function getDatabaseExtraIgnoresCaseDifference()
    {
        $subject = $this->getSqlSchemaMigrationService();
        $differenceArray = $subject->getDatabaseExtra(
            [
                'tx_foo' => [
                    'fields' => [
                        'foo' => 'INT(11) DEFAULT \'0\' NOT NULL',
                    ]
                ]
            ],
            [
                'tx_foo' => [
                    'fields' => [
                        'foo' => 'int(11) DEFAULT \'0\' NOT NULL',
                    ]
                ]
            ]
        );

        $this->assertEquals(
            $differenceArray,
            [
                'extra' => [],
                'diff' => [],
                'diff_currentValues' => null,
            ]
        );
    }

    public function getDatabaseExtraIgnoresCaseDifferenceButKeepsCaseInSetIntact()
    {
        $subject = $this->getSqlSchemaMigrationService();
        $differenceArray = $subject->getDatabaseExtra(
            [
                'tx_foo' => [
                    'fields' => [
                        'subtype' => 'SET(\'Tx_MyExt_Domain_Model_Xyz\',\'Tx_MyExt_Domain_Model_Abc\',\'\') NOT NULL DEFAULT \'\',',
                    ]
                ]
            ],
            [
                'tx_foo' => [
                    'fields' => [
                        'subtype' => 'set(\'Tx_MyExt_Domain_Model_Xyz\',\'Tx_MyExt_Domain_Model_Abc\',\'\') NOT NULL DEFAULT \'\',',
                    ]
                ]
            ]
        );

        $this->assertEquals(
            $differenceArray,
            [
                'extra' => [],
                'diff' => [],
                'diff_currentValues' => null,
            ]
        );
    }

    public function getDatabaseExtraDoesNotLowercaseReservedWordsForTheComparison()
    {
        $subject = $this->getSqlSchemaMigrationService();
        $differenceArray = $subject->getDatabaseExtra(
            [
                'tx_foo' => [
                    'fields' => [
                        'PRIMARY KEY (md5hash)',
                    ]
                ]
            ],
            [
                'tx_foo' => [
                    'fields' => [
                        'PRIMARY KEY (md5hash)'],
                ]
            ]
        );

        $this->assertEquals(
            $differenceArray,
            [
                'extra' => [],
                'diff' => [],
                'diff_currentValues' => null,
            ]
        );
    }

    public function getDatabaseExtraFindsNewSpatialKeys()
    {
        $subject = $this->getSqlSchemaMigrationService();
        $differenceArray = $subject->getDatabaseExtra(
            [
                'tx_foo' => [
                    'keys' => [
                        'foo' => 'SPATIAL foo (foo)'
                    ]
                ]
            ],
            [
                'tx_foo' => [
                    'keys' => []
                ]
            ]
        );

        $this->assertEquals(
            $differenceArray,
            [
                'extra' => [
                    'tx_foo' => [
                        'keys' => [
                            'foo' => 'SPATIAL foo (foo)'
                        ]
                    ]
                ],
                'diff' => [],
                'diff_currentValues' => null
            ]
        );
    }

    public function checkColumnDefinitionIfCommentIsSupplied()
    {
        $subject = $this->getSqlSchemaMigrationService();
        $fieldDefinition = $subject->assembleFieldDefinition(
            [
                'Field' => 'uid',
                'Type' => 'int(11)',
                'Null' => 'NO',
                'Key' => 'PRI',
                'Default' => null,
                'Extra' => 'auto_increment',
                'Comment' => 'I am a comment',
            ]
        );

        $this->assertSame(
            'int(11) NOT NULL auto_increment COMMENT \'I am a comment\'',
            $fieldDefinition
        );
    }

    public function checkColumnDefinitionIfNoCommentIsSupplied()
    {
        $subject = $this->getSqlSchemaMigrationService();
        $fieldDefinition = $subject->assembleFieldDefinition(
            [
                'Field' => 'uid',
                'Type' => 'int(11)',
                'Null' => 'NO',
                'Key' => 'PRI',
                'Default' => null,
                'Extra' => 'auto_increment',
            ]
        );

        $this->assertSame(
            'int(11) NOT NULL auto_increment',
            $fieldDefinition
        );
    }

    public function getDatabaseExtraIncludesEngineIfMySQLIsUsed()
    {
        $subject = $this->getSqlSchemaMigrationService();
        $differenceArray = $subject->getDatabaseExtra(
            [
                'tx_foo' => [
                    'fields' => [
                        'foo' => 'INT(11) DEFAULT \'0\' NOT NULL',
                    ],
                    'extra' => [
                        'ENGINE' => 'InnoDB'
                    ]
                ]
            ],
            [
                'tx_foo' => [
                    'fields' => [
                        'foo' => 'int(11) DEFAULT \'0\' NOT NULL',
                    ],
                    'extra' => [
                        'ENGINE' => 'InnoDB'
                    ]
                ]
            ]
        );

        $this->assertSame(
            $differenceArray,
            [
                'extra' => [],
                'diff' => [],
                'diff_currentValues' => null,
            ]
        );
    }

    public function getDatabaseExtraExcludesEngineIfDbalIsUsed()
    {
        $subject = $this->getDbalEnabledSqlSchemaMigrationService();
        $differenceArray = $subject->getDatabaseExtra(
            [
                'tx_foo' => [
                    'fields' => [
                        'foo' => 'INT(11) DEFAULT \'0\' NOT NULL',
                    ],
                    'extra' => [
                        'ENGINE' => 'InnoDB'
                    ]
                ]
            ],
            [
                'tx_foo' => [
                    'fields' => [
                        'foo' => 'int(11) DEFAULT \'0\' NOT NULL',
                    ],
                    'extra' => []
                ]
            ]
        );

        $this->assertSame(
            $differenceArray,
            [
                'extra' => [],
                'diff' => [],
                'diff_currentValues' => null,
            ]
        );
    }

    public function getDatabaseExtraIncludesUnsignedAttributeIfMySQLIsUsed()
    {
        $subject = $this->getSqlSchemaMigrationService();
        $differenceArray = $subject->getDatabaseExtra(
            [
                'tx_foo' => [
                    'fields' => [
                        'foo' => 'INT(11) UNSIGNED DEFAULT \'0\' NOT NULL',
                    ],
                    'extra' => [
                        'ENGINE' => 'InnoDB'
                    ]
                ]
            ],
            [
                'tx_foo' => [
                    'fields' => [
                        'foo' => 'int(11) DEFAULT \'0\' NOT NULL',
                    ],
                    'extra' => [
                        'ENGINE' => 'InnoDB'
                    ]
                ]
            ]
        );

        $this->assertSame(
            $differenceArray,
            [
                'extra' => [],
                'diff' => [
                    'tx_foo' => [
                        'fields' => [
                            'foo' => 'int(11) UNSIGNED DEFAULT \'0\' NOT NULL',
                        ],
                    ]
                ],
                'diff_currentValues' => [
                    'tx_foo' => [
                        'fields' => [
                            'foo' => 'int(11) DEFAULT \'0\' NOT NULL',
                        ],
                    ]
                ]
            ]
        );
    }

    public function getDatabaseExtraExcludesUnsignedAttributeIfDbalIsUsed()
    {
        $subject = $this->getDbalEnabledSqlSchemaMigrationService();
        $differenceArray = $subject->getDatabaseExtra(
            [
                'tx_foo' => [
                    'fields' => [
                        'foo' => 'INT(11) UNSIGNED DEFAULT \'0\' NOT NULL',
                    ],
                    'extra' => [
                        'ENGINE' => 'InnoDB'
                    ]
                ]
            ],
            [
                'tx_foo' => [
                    'fields' => [
                        'foo' => 'int(11) DEFAULT \'0\' NOT NULL',
                    ],
                    'extra' => [
                        'ENGINE' => 'InnoDB'
                    ]
                ]
            ]
        );

        $this->assertSame(
            $differenceArray,
            [
                'extra' => [],
                'diff' => [],
                'diff_currentValues' => null
            ]
        );
    }

    public function getDatabaseExtraIgnoresIndexPrefixLengthIfDbalIsUsed()
    {
        $subject = $this->getDbalEnabledSqlSchemaMigrationService();
        $differenceArray = $subject->getDatabaseExtra(
            [
                'tx_foo' => [
                    'keys' => [
                        'foo' => 'KEY foo (foo(199))'
                    ]
                ]
            ],
            [
                'tx_foo' => [
                    'keys' => [
                        'foo' => 'KEY foo (foo)'
                    ]
                ]
            ]
        );

        $this->assertSame(
            $differenceArray,
            [
                'extra' => [],
                'diff' => [],
                'diff_currentValues' => null,
            ]
        );
    }

    public function getDatabaseExtraComparesIndexPrefixLengthIfMySQLIsUsed()
    {
        $subject = $this->getSqlSchemaMigrationService();
        $differenceArray = $subject->getDatabaseExtra(
            [
                'tx_foo' => [
                    'keys' => [
                        'foo' => 'KEY foo (foo(199))'
                    ]
                ]
            ],
            [
                'tx_foo' => [
                    'keys' => [
                        'foo' => 'KEY foo (foo)'
                    ]
                ]
            ]
        );

        $this->assertSame(
            $differenceArray,
            [
                'extra' => [],
                'diff' => [
                    'tx_foo' => [
                        'keys' => [
                            'foo' => 'KEY foo (foo(199))'
                        ]
                    ]
                ],
                'diff_currentValues' => [
                    'tx_foo' => [
                        'keys' => [
                            'foo' => 'KEY foo (foo)'
                        ]
                    ]
                ]
            ]
        );
    }
}