public void ShouldWriteQueryForRemoveCheckConstraint()
{
var op = new RemoveCheckConstraintOperation(_schemaName, _tableName, _constraintName);
Trace.WriteLine(op.ToQuery());
const string expectedQuery = "alter table [schemaName].[tableName] drop constraint [constraintName]";
Assert.AreEqual(expectedQuery, op.ToQuery());
}
public void ShouldDisableWhenMergedWithRemoveCheckConstraint()
{
var op = new AddCheckConstraintOperation("schema", "table", "name", "1", true, true);
var removeOp = new RemoveCheckConstraintOperation("SCHEMA", "TABLE", "NAME");
op.Merge(removeOp);
Assert.That(op.Disabled, Is.True);
Assert.That(removeOp.Disabled, Is.True);
}
public void ShouldSetPropertiesForRemoveCheckConstraint()
{
var op = new RemoveCheckConstraintOperation(_schemaName, _tableName, _constraintName);
Assert.AreEqual(_schemaName, op.SchemaName);
Assert.AreEqual(_tableName, op.TableName);
Assert.AreEqual(_constraintName, op.Name);
Assert.That(op.ObjectName, Is.EqualTo($"{_schemaName}.{_constraintName}"));
Assert.That(op.TableObjectName, Is.EqualTo($"{_schemaName}.{_tableName}"));
}
