public void ShouldNotRenameTableIfTableIsRenamedAfterColumnsAreRenamed() { var columns = new[] { Column.Int("c1", Nullable.NotNull, null, null, "description"), Column.VarChar("c2", new CharacterLength(1008), "collation", Nullable.NotNull, null, null, "description") }; var op = new AddTableOperation("schema", "table", columns, false, "file group", "textimagefilegroup", "filestreamfilegroup", new string[0]); var renameColumn1Op = new RenameColumnOperation("SCHEMA", "TABLE", "C1", "C1New"); var renameColumn2Op = new RenameColumnOperation("SCHEMA", "TABLE", "C2", "C2New"); var renameTableOp = new RenameObjectOperation("SCHEMA", "TABLE", "T1New"); renameColumn2Op.Merge(renameTableOp); renameColumn1Op.Merge(renameTableOp); op.Merge(renameTableOp); renameColumn1Op.Merge(renameColumn2Op); op.Merge(renameColumn2Op); op.Merge(renameColumn1Op); Assert.That(op.Disabled, Is.False); Assert.That(renameColumn1Op.Disabled, Is.True); Assert.That(renameColumn2Op.Disabled, Is.True); Assert.That(renameTableOp.Disabled, Is.True); Assert.That(columns[0].Name, Is.EqualTo("C1New")); Assert.That(columns[1].Name, Is.EqualTo("C2New")); Assert.That(renameColumn2Op.TableName, Is.EqualTo("T1New")); Assert.That(renameColumn1Op.TableName, Is.EqualTo("T1New")); Assert.That(op.Name, Is.EqualTo("T1New")); }
public void ShouldRenameColumnMultipleTimes() { var columns = new[] { Column.Int("c1", Nullable.NotNull, null, null, "description"), }; var op = new AddTableOperation("schema", "table", columns, false, "file group", "textimagefilegroup", "filestreamfilegroup", new string[0]); var renameColumn1Op = new RenameColumnOperation("SCHEMA", "TABLE", "C1", "C1New"); var renameColumn2Op = new RenameColumnOperation("SCHEMA", "TABLE", "C1New", "C2"); renameColumn1Op.Merge(renameColumn2Op); op.Merge(renameColumn2Op); op.Merge(renameColumn1Op); Assert.That(renameColumn2Op.Disabled, Is.True); Assert.That(renameColumn2Op.Name, Is.EqualTo("C1New")); Assert.That(renameColumn2Op.NewName, Is.EqualTo("C2")); Assert.That(renameColumn1Op.Disabled, Is.True); Assert.That(renameColumn1Op.Name, Is.EqualTo("C1")); Assert.That(renameColumn1Op.NewName, Is.EqualTo("C2")); Assert.That(op.Disabled, Is.False); Assert.That(op.Columns[0].Name, Is.EqualTo("C2")); }
public void ShouldNotRenameTableIfRenamedTableNotAddedDuringMerge() { var renameColumn1Op = new RenameColumnOperation("SCHEMA", "TABLE", "C1", "C1New"); var renameColumn2Op = new RenameColumnOperation("SCHEMA", "TABLE", "C2", "C2New"); var renameTableOp = new RenameObjectOperation("SCHEMA", "TABLE", "T1New"); renameColumn2Op.Merge(renameTableOp); renameColumn1Op.Merge(renameTableOp); renameColumn1Op.Merge(renameColumn2Op); Assert.That(renameColumn1Op.Disabled, Is.False); Assert.That(renameColumn2Op.Disabled, Is.False); Assert.That(renameTableOp.Disabled, Is.False); Assert.That(renameColumn2Op.TableName, Is.EqualTo("TABLE")); Assert.That(renameColumn1Op.TableName, Is.EqualTo("TABLE")); }