public void ShouldUpateColumnNameIfItIsRenamed() { var op = new AddRowGuidColOperation("schema", "table", "column"); var renameOp = new RenameColumnOperation("SCHEMA", "TABLE", "COLUMN", "new column"); op.Merge(renameOp); Assert.That(op.Disabled, Is.False); Assert.That(renameOp.Disabled, Is.True); Assert.That(op.ColumnName, Is.EqualTo("new column")); }
public void ShouldNotUpateColumnNameIfNotSameSchemaTableOrColumn(string schemaName, string tableName, string columnName) { var op = new AddRowGuidColOperation("schema", "table", "column"); var renameOp = new RenameColumnOperation(schemaName, tableName, columnName, "new column"); op.Merge(renameOp); Assert.That(op.Disabled, Is.False); Assert.That(renameOp.Disabled, Is.False); Assert.That(op.ColumnName, Is.EqualTo("column")); }
public void ShouldNotRemoveRowGuidColFromColumnWhenMergingRemoveRowGuidColumnOperationAndTheColumnIsNotAUniqueIdentifier() { var columns = new Column[] { Column.NVarChar("name", new CharacterLength(50), "collation", Nullable.Null, null, null, "description"), }; var op = new AddTableOperation("schema", "table", columns, false, "file group", "text image file group", "file stream file group", new string[0]); var addRowGuidColOp = new AddRowGuidColOperation("SCHEMA", "TABLE", "name"); op.Merge(addRowGuidColOp); Assert.That(op.Disabled, Is.False); Assert.That(addRowGuidColOp.Disabled, Is.False); Assert.That(op.Columns[0].RowGuidCol, Is.False); }
public void ShouldAddRowGuidColToColumnWhenMergingAddRowGuidColumnOperation() { var columns = new Column[] { Column.UniqueIdentifier("name", false, Nullable.NotNull, "default expression", "default constraint name", "description"), Column.UniqueIdentifier("name2", false, Nullable.NotNull, "default expression", "default constraint name", "description"), }; var op = new AddTableOperation("schema", "table", columns, false, "file group", "text image file group", "file stream file group", new string[0]); var addRowGuidColOp = new AddRowGuidColOperation("SCHEMA", "TABLE", "name"); op.Merge(addRowGuidColOp); Assert.That(op.Disabled, Is.False); Assert.That(addRowGuidColOp.Disabled, Is.True); Assert.That(op.Columns[0].RowGuidCol, Is.True); Assert.That(op.Columns[1].RowGuidCol, Is.False); }
public void ShouldNotAddRowGuidColForAnotherTablesColumn() { var columns = new Column[] { Column.UniqueIdentifier("uuid", false, Nullable.Null, null, null, "description"), Column.UniqueIdentifier("uuid2", false, Nullable.Null, null, null, "description"), Column.Int("uuid", Nullable.Null, null, null, "description"), }; var op = new UpdateTableOperation("schema", "table", new Column[0], columns, new string[0]); var addRowGuidColOp = new AddRowGuidColOperation("SCHEMA", "table2", "UUID"); op.Merge(addRowGuidColOp); Assert.That(op.Disabled, Is.False); Assert.That(addRowGuidColOp.Disabled, Is.False); Assert.That(op.UpdateColumns[0].RowGuidCol, Is.False); Assert.That(op.UpdateColumns[1].RowGuidCol, Is.False); Assert.That(op.UpdateColumns[2].RowGuidCol, Is.False); }