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);
}
