ramunasd / MigrationBundle

        $this->assertEquals($expectedSql, $query->getDescription());

    }

    public function renameTableProvider()

    {

        return [

            [new MySqlPlatform(), 'ALTER TABLE old_table RENAME TO new_table'],

            [new PostgreSqlPlatform(), 'ALTER TABLE old_table RENAME TO new_table'],

            [new OraclePlatform(), 'ALTER TABLE old_table RENAME TO new_table'],

            [

                new SQLServer2005Platform(),

                [

                    "sp_RENAME 'old_table', 'new_table'",

                    "DECLARE @sql NVARCHAR(MAX) = N''; "

                    . "SELECT @sql += N'EXEC sp_rename N''' + dc.name + ''', N'''"

                    . " + REPLACE(dc.name, '50BD45A0', 'EBFCC9B') + ''', ''OBJECT'';' "

                    . "FROM sys.default_constraints dc JOIN sys.tables tbl ON dc.parent_object_id = tbl.object_id "

                    . "WHERE tbl.name = 'new_table';"

                    . "EXEC sp_executesql @sql"

                ]

            ],

        ];

    }

    public function renameColumnProvider()

    {

        ];

    }

    public function addForeignKeyConstraintProvider()

    {

        return [

            [

                new MySqlPlatform(),

                'ALTER TABLE test_table ADD CONSTRAINT fk_test_table_local_column '

                . 'FOREIGN KEY (local_column) REFERENCES foreign_table (foreign_column) ON DELETE CASCADE'

            ],

            [

                new PostgreSqlPlatform(),

                'ALTER TABLE test_table ADD CONSTRAINT fk_test_table_local_column '

                . 'FOREIGN KEY (local_column) REFERENCES foreign_table (foreign_column) ON DELETE CASCADE '

                . 'NOT DEFERRABLE INITIALLY IMMEDIATE'

            ],

            [

                new OraclePlatform(),

                'ALTER TABLE test_table ADD CONSTRAINT fk_test_table_local_column '

                . 'FOREIGN KEY (local_column) REFERENCES foreign_table (foreign_column) ON DELETE CASCADE'

            ],

            [

                new SQLServer2005Platform(),

                'ALTER TABLE test_table ADD CONSTRAINT fk_test_table_local_column '

                . 'FOREIGN KEY (local_column) REFERENCES foreign_table (foreign_column) ON DELETE CASCADE'

            ],

        ];

    }

}