public void ShouldDisableWhenMergedWithRemoveOperation()
{
var op = new AddSchemaOperation("name", "owner");
var removeOp = new RemoveSchemaOperation("NAME");
op.Merge(removeOp);
Assert.That(op.Disabled, Is.True);
Assert.That(removeOp.Disabled, Is.True);
}
public void ShouldSetPropertiesForSchema()
{
const string schemaName = "schemaName";
const string schemaOwner = "schemaOwner";
//Test for Input with Both Schema and Owner
var op = new AddSchemaOperation(schemaName, schemaOwner);
Assert.That(op.Name, Is.EqualTo(schemaName));
Assert.That(op.Owner, Is.EqualTo(schemaOwner));
//Assert.That(op.ObjectName, Is.EqualTo(schemaName));
var expectedQuery = string.Format("if not exists (select * from sys.schemas where name = '{0}'){1} exec sp_executesql N'create schema [{0}] authorization [{2}]'", schemaName, Environment.NewLine, schemaOwner);
Assert.That(op.ToQuery(), Is.EqualTo(expectedQuery));
//Test for Input with Schema Only
op = new AddSchemaOperation(schemaName, null);
Assert.That(op.Name, Is.EqualTo(schemaName));
Assert.That(op.Owner, Is.EqualTo(null));
expectedQuery = string.Format("if not exists (select * from sys.schemas where name = '{0}'){1} exec sp_executesql N'create schema [{0}]'", schemaName, Environment.NewLine);
Assert.That(op.ToQuery(), Is.EqualTo(expectedQuery));
}
