public void ShouldWriteQueryWithDBOSchemaAndWithValuesFalseForAddCheckConstrait()
{
var schemaName = "schemaName";
var tableName = "tableName";
var name = "constraintName";
var expression = "expression";
bool notForReplication = false;
var op = new AddCheckConstraintOperation(schemaName, tableName, name, expression, notForReplication, false);
Trace.WriteLine(op.ToQuery());
var expectedQuery = @"alter table [schemaName].[tableName] add constraint [constraintName] check (expression)";
Assert.AreEqual(expectedQuery, op.ToQuery());
}
public void ShouldWriteQueryForAddCheckConstraint()
{
var schemaName = "schemaName";
var tableName = "tableName";
var name = "constraintName";
var expression = "expression";
bool notForReplication = true;
bool withNoCheck = true;
var op = new AddCheckConstraintOperation(schemaName, tableName, name, expression, notForReplication, withNoCheck);
var expectedQuery = @"alter table [schemaName].[tableName] with nocheck add constraint [constraintName] check not for replication (expression)";
Assert.AreEqual(expectedQuery, op.ToQuery());
}
