public void ShouldWriteQueryForUpdateTableWithRemoveOnly()
{
var op = new UpdateTableOperation(SchemaName, Name, null, null, removeColumnList);
var expectedQuery =
string.Format("alter table [schemaName].[name] drop column [column 3]{0}alter table [schemaName].[name] drop column [column 4]", Environment.NewLine);
Assert.AreEqual(expectedQuery, op.ToQuery());
}
public void ShouldWriteQueryForUpdateTableWithUpdateOnly()
{
var op = new UpdateTableOperation(SchemaName, Name, null, updateColumnList, null);
var expectedQuery =
$"alter table [schemaName].[name] alter column [int column] int identity not null{Environment.NewLine}" +
$"alter table [schemaName].[name] alter column [name] varchar(50) not null constraint [{DefaultConstraintName}] default ''";
Assert.AreEqual(expectedQuery, op.ToQuery());
}
public void ShouldWriteQueryForUpdateTableWithAddUpdateRemove()
{
var op = new UpdateTableOperation(SchemaName, Name, addColumnList, updateColumnList, removeColumnList);
var expectedQuery =
$"alter table [schemaName].[name] add [name] varchar(50) not null constraint [{DefaultConstraintName}] default ''{Environment.NewLine}" +
$"alter table [schemaName].[name] add [int column] int identity not null{Environment.NewLine}" +
$"alter table [schemaName].[name] alter column [int column] int identity not null{Environment.NewLine}" +
$"alter table [schemaName].[name] alter column [name] varchar(50) not null constraint [{DefaultConstraintName}] default ''{Environment.NewLine}" +
$"alter table [schemaName].[name] drop column [column 3]{Environment.NewLine}alter table [schemaName].[name] drop column [column 4]";
Assert.AreEqual(expectedQuery, op.ToQuery());
}
