SqlSchemaMigrationServiceTest.php

Go to the documentation of this file.

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

use TYPO3\CMS\Install\Service\SqlSchemaMigrationService;

class SqlSchemaMigrationServiceTest extends \TYPO3\CMS\Core\Tests\UnitTestCase {

    public function getFieldDefinitionsFileContentHandlesMultipleWhitespacesInFieldDefinitions() {
        $subject = new SqlSchemaMigrationService();
        // 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(
            array(
                'atable' => array(
                    'fields' => array(
                        'aFieldName' => 'int(11) unsigned default \'0\'',
                    ),
                    'extra' => array(
                        'COLLATE' => '',
                    ),
                ),
            ),
            $result
        );
    }

    public function getDatabaseExtraFindsChangedFields() {
        $subject = new SqlSchemaMigrationService();
        $differenceArray = $subject->getDatabaseExtra(
            array(
                'tx_foo' => array(
                    'fields' => array(
                        'foo' => 'varchar(999) DEFAULT \'0\' NOT NULL'
                    )
                )
            ),
            array(
                'tx_foo' => array(
                    'fields' => array(
                        'foo' => 'varchar(255) DEFAULT \'0\' NOT NULL'
                    )
                )
            )
        );

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

    public function getDatabaseExtraFindsChangedFieldsIncludingNull() {
        $subject = new SqlSchemaMigrationService();
        $differenceArray = $subject->getDatabaseExtra(
            array(
                'tx_foo' => array(
                    'fields' => array(
                        'foo' => 'varchar(999) NULL'
                    )
                )
            ),
            array(
                'tx_foo' => array(
                    'fields' => array(
                        'foo' => 'varchar(255) NULL'
                    )
                )
            )
        );

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

    public function getDatabaseExtraFindsChangedFieldsIgnoreNotNull() {
        $subject = new SqlSchemaMigrationService();
        $differenceArray = $subject->getDatabaseExtra(
            array(
                'tx_foo' => array(
                    'fields' => array(
                        'foo' => 'varchar(999) DEFAULT \'0\' NOT NULL'
                    )
                )
            ),
            array(
                'tx_foo' => array(
                    'fields' => array(
                        'foo' => 'varchar(255) DEFAULT \'0\' NOT NULL'
                    )
                )
            ),
            '',
            TRUE
        );

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

    public function getDatabaseExtraIgnoresCaseDifference() {
        $subject = new SqlSchemaMigrationService();
        $differenceArray = $subject->getDatabaseExtra(
            array(
                'tx_foo' => array(
                    'fields' => array(
                        'foo' => 'INT(11) DEFAULT \'0\' NOT NULL'
                    )
                )
            ),
            array(
                'tx_foo' => array(
                    'fields' => array(
                        'foo' => 'int(11) DEFAULT \'0\' NOT NULL'
                    )
                )
            )
        );


        $this->assertEquals(
            $differenceArray,
            array(
                'extra' => array(),
                'diff' => array(),
                'diff_currentValues' => NULL
            )
        );
    }

    public function getDatabaseExtraIgnoresCaseDifferenceButKeepsCaseInSetIntact() {
        $subject = new SqlSchemaMigrationService();
        $differenceArray = $subject->getDatabaseExtra(
            array(
                'tx_foo' => array(
                    'fields' => array(
                        'subtype' => 'SET(\'Tx_MyExt_Domain_Model_Xyz\',\'Tx_MyExt_Domain_Model_Abc\',\'\') NOT NULL DEFAULT \'\',',
                    )
                )
            ),
            array(
                'tx_foo' => array(
                    'fields' => array(
                        'subtype' => 'set(\'Tx_MyExt_Domain_Model_Xyz\',\'Tx_MyExt_Domain_Model_Abc\',\'\') NOT NULL DEFAULT \'\',',
                    )
                )
            )
        );

        $this->assertEquals(
            $differenceArray,
            array(
                'extra' => array(),
                'diff' => array(),
                'diff_currentValues' => NULL,
            )
        );
    }

    public function getDatabaseExtraDoesNotLowercaseReservedWordsForTheComparison() {
        $subject = new SqlSchemaMigrationService();
        $differenceArray = $subject->getDatabaseExtra(
            array(
                'tx_foo' => array(
                    'fields' => array(
                        'PRIMARY KEY (md5hash)'
                    )
                )
            ),
            array(
                'tx_foo' => array(
                    'fields' => array(
                        'PRIMARY KEY (md5hash)')
                )
            )
        );


        $this->assertEquals(
            $differenceArray,
            array(
                'extra' => array(),
                'diff' => array(),
                'diff_currentValues' => NULL
            )
        );
    }
}