public override void CallingConstraintExistsCanAcceptTableNameWithSingleQuote()
{
using (var table = new Db2ISeriesTestTable("Test'Table", Processor, null, "ID INT NOT NULL"))
{
table.WithUniqueConstraintOn("ID", "C'1");
Processor.ConstraintExists(null, table.Name, "C'1").ShouldBeTrue();
}
}
public void CallingConstraintExistsReturnsFalseIfConstraintExistsInDifferentSchema()
{
using (var table = new Db2ISeriesTestTable(Processor, "TstSchma", "ID INT NOT NULL"))
{
table.WithUniqueConstraintOn("ID", "c1");
Processor.ConstraintExists("DNE", table.Name, "c1").ShouldBeFalse();
}
}
public override void CallingConstraintExistsReturnsTrueIfConstraintExistsWithSchema()
{
using (var table = new Db2ISeriesTestTable(Processor, "TstSchma", "ID INT NOT NULL"))
{
table.WithUniqueConstraintOn("ID", "C1");
Processor.ConstraintExists("TstSchma", table.Name, "C1").ShouldBeTrue();
}
}