TYPO3 / TYPO3.CMS

     * @throws \Doctrine\DBAL\Schema\SchemaException

     * @throws \InvalidArgumentException

     */

    protected function getNewFieldUpdateSuggestions(SchemaDiff $schemaDiff): array

    {

        $changedTables = [];

        foreach ($schemaDiff->changedTables as $index => $changedTable) {

            $fromTable = $this->buildQuotedTable($schemaDiff->fromSchema->getTable($changedTable->name));

            if (count($changedTable->addedColumns) !== 0) {

                // Treat each added column with a new diff to get a dedicated suggestions

                // just for this single column.

                foreach ($changedTable->addedColumns as $addedColumn) {

                    $changedTables[$index . ':tbl_' . $addedColumn->getName()] = GeneralUtility::makeInstance(

                        TableDiff::class,

                        $changedTable->name,

                        [$addedColumn],

                        [],

                        [],

                        [],

                        [],

                        [],

                        $fromTable

                    );

                }

            }

            if (count($changedTable->addedIndexes) !== 0) {

                // Treat each added index with a new diff to get a dedicated suggestions

                // just for this index.

                foreach ($changedTable->addedIndexes as $addedIndex) {

                    $changedTables[$index . ':idx_' . $addedIndex->getName()] = GeneralUtility::makeInstance(

                        TableDiff::class,

                        $changedTable->name,

                        [],

                        [],

                        [],

                        [$this->buildQuotedIndex($addedIndex)],

                        [],

                        [],

                        $fromTable

                    );

                }

            }

            if (count($changedTable->addedForeignKeys) !== 0) {

                // Treat each added foreign key with a new diff to get a dedicated suggestions

                // just for this foreign key.

                foreach ($changedTable->addedForeignKeys as $addedForeignKey) {

                    $fkIndex = $index . ':fk_' . $addedForeignKey->getName();

                    $changedTables[$fkIndex] = GeneralUtility::makeInstance(

                        TableDiff::class,

                        $changedTable->name,

                        [],

                        [],

                        [],

                        [],

                        [],

                        [],

                        $fromTable

                    );

                    $changedTables[$fkIndex]->addedForeignKeys = [$this->buildQuotedForeignKey($addedForeignKey)];

                }

            }

        }

        // Build a new schema diff that only contains added fields

        $addFieldSchemaDiff = GeneralUtility::makeInstance(

            SchemaDiff::class,

            [],

            $changedTables,

            [],

            $schemaDiff->fromSchema

        );

        $statements = $addFieldSchemaDiff->toSql($this->connection->getDatabasePlatform());

        return ['add' => $this->calculateUpdateSuggestionsHashes($statements)];

    }

    /**

     * Extract update suggestions (SQL statements) for changed options

     * @throws \Doctrine\DBAL\Schema\SchemaException

     * @throws \InvalidArgumentException

     */

    protected function getDropFieldUpdateSuggestions(SchemaDiff $schemaDiff): array

    {

        $changedTables = [];

        foreach ($schemaDiff->changedTables as $index => $changedTable) {

            $fromTable = $this->buildQuotedTable($schemaDiff->fromSchema->getTable($changedTable->name));

            if (count($changedTable->removedColumns) !== 0) {

                // Treat each changed column with a new diff to get a dedicated suggestions

                // just for this single column.

                foreach ($changedTable->removedColumns as $removedColumn) {

                    $changedTables[$index . ':tbl_' . $removedColumn->getName()] = GeneralUtility::makeInstance(

                        TableDiff::class,

                        $changedTable->name,

                        [],

                        [],

                        [$this->buildQuotedColumn($removedColumn)],

                        [],

                        [],

                        [],

                        $fromTable

                    );

                }

            }

            if (count($changedTable->removedIndexes) !== 0) {

                // Treat each removed index with a new diff to get a dedicated suggestions

                // just for this index.

                foreach ($changedTable->removedIndexes as $removedIndex) {

                    $changedTables[$index . ':idx_' . $removedIndex->getName()] = GeneralUtility::makeInstance(

                        TableDiff::class,

                        $changedTable->name,

                        [],

                        [],

                        [],

                        [],

                        [],

                        [$this->buildQuotedIndex($removedIndex)],

                        $fromTable

                    );

                }

            }

            if (count($changedTable->removedForeignKeys) !== 0) {

                // Treat each removed foreign key with a new diff to get a dedicated suggestions

                // just for this foreign key.

                foreach ($changedTable->removedForeignKeys as $removedForeignKey) {

                    $fkIndex = $index . ':fk_' . $removedForeignKey->getName();

                    $changedTables[$fkIndex] = GeneralUtility::makeInstance(

                        TableDiff::class,

                        $changedTable->name,

                        [],

                        [],

                        [],

                        [],

                        [],

                        [],

                        $fromTable

                    );

                    $changedTables[$fkIndex]->removedForeignKeys = [$this->buildQuotedForeignKey($removedForeignKey)];

                }

            }

        }

        // Build a new schema diff that only contains removable fields

        $removedFieldDiff = GeneralUtility::makeInstance(

            SchemaDiff::class,

            [],

            $changedTables,

            [],

            $schemaDiff->fromSchema

        );

        $statements = $removedFieldDiff->toSql($this->connection->getDatabasePlatform());

        return ['drop' => $this->calculateUpdateSuggestionsHashes($statements)];

    }

    /**

     * Extract update suggestions (SQL statements) for tables that can