public void TestGetAlterTablesQueries() { var schema = new DatabaseSchema(); schema.AlterTable("table1") .AddColumn("column1") .AddColumn("column2") .ModifyColumn("column3", ColumnType.Int()) .ModifyColumn("column4", ColumnType.Int()) .DropColumn("column5") .DropColumn("column6") .AddPrimaryKeyConstraint("id") .AddForeignKeyConstraint("table2_id", "table2", "id") .AddForeignKeyConstraint("table3_id", "table3", "id"); var service = new MySqlExecutor(schema); var result = service.GetAlterTablesQueries(); Assert.AreEqual(9, result.Count); Assert.AreEqual("ALTER TABLE `table1` ADD `column1` VARCHAR(255) COLLATE utf8mb4_unicode_ci NOT NULL;\r", result[0]); Assert.AreEqual("ALTER TABLE `table1` ADD `column2` VARCHAR(255) COLLATE utf8mb4_unicode_ci NOT NULL;\r", result[1]); Assert.AreEqual("ALTER TABLE `table1` MODIFY COLUMN `column3` INT NOT NULL;\r", result[2]); Assert.AreEqual("ALTER TABLE `table1` MODIFY COLUMN `column4` INT NOT NULL;\r", result[3]); Assert.AreEqual("ALTER TABLE `table1` DROP COLUMN `column5`;\r", result[4]); Assert.AreEqual("ALTER TABLE `table1` DROP COLUMN `column6`;\r", result[5]); Assert.AreEqual("ALTER TABLE `table1` ADD PRIMARY KEY (`id`);\r", result[6]); Assert.AreEqual("ALTER TABLE `table1` ADD FOREIGN KEY (`table2_id`) REFERENCES `table2`(`id`);\r", result[7]); Assert.AreEqual("ALTER TABLE `table1` ADD FOREIGN KEY (`table3_id`) REFERENCES `table3`(`id`);\r", result[8]); }
public void TestGetAlterTablesQueries() { var schema = new DatabaseSchema(); schema.AlterTable("table1") .AddColumn("column1") .AddColumn("column2") .ModifyColumn("column3", ColumnType.Int()) .ModifyColumn("column4", ColumnType.Int()) .DropColumn("column5") .DropColumn("column6") .AddPrimaryKeyConstraint("id") .AddForeignKeyConstraint("table2_id", "table2", "id") .AddForeignKeyConstraint("table3_id", "table3", "id"); var service = new SqlServerExecutor(schema); var result = service.GetAlterTablesQueries(); Assert.AreEqual(9, result.Count); Assert.AreEqual("ALTER TABLE [dbo].[table1] ADD [column1] NVARCHAR(255) NOT NULL;\r", result[0]); Assert.AreEqual("ALTER TABLE [dbo].[table1] ADD [column2] NVARCHAR(255) NOT NULL;\r", result[1]); Assert.AreEqual("ALTER TABLE [dbo].[table1] ALTER COLUMN [column3] INT NOT NULL;\r", result[2]); Assert.AreEqual("ALTER TABLE [dbo].[table1] ALTER COLUMN [column4] INT NOT NULL;\r", result[3]); Assert.AreEqual("ALTER TABLE [dbo].[table1] DROP COLUMN [column5];\r", result[4]); Assert.AreEqual("ALTER TABLE [dbo].[table1] DROP COLUMN [column6];\r", result[5]); Assert.AreEqual("ALTER TABLE [dbo].[table1] ADD PRIMARY KEY ([id]);\r", result[6]); Assert.AreEqual("ALTER TABLE [dbo].[table1] ADD FOREIGN KEY ([table2_id]) REFERENCES [dbo].[table2]([id]);\r", result[7]); Assert.AreEqual("ALTER TABLE [dbo].[table1] ADD FOREIGN KEY ([table3_id]) REFERENCES [dbo].[table3]([id]);\r", result[8]); }
public static AlterTableSchema AlterTable(string tableName) { return(schema.AlterTable(tableName)); }