public override void CallingConstraintExistsReturnsFalseIfConstraintDoesNotExistWithSchema()
{
using (var table = new HanaTestTable(Processor, "schemaName", "id int"))
{
table.WithUniqueConstraintOn("ID");
this.Processor.ConstraintExists("schemaName", table.Name, "DoesNotExist").ShouldBeFalse();
}
}
public override void CallingConstraintExistsCanAcceptTableNameWithSingleQuote()
{
using (var table = new HanaTestTable("Test'Table", Processor, null, "id int"))
{
table.WithUniqueConstraintOn("ID");
this.Processor.ConstraintExists(null, table.Name, "UC_id").ShouldBeTrue();
}
}
public override void CallingConstraintExistsReturnsTrueIfConstraintExistsWithSchema()
{
using (var table = new HanaTestTable(Processor, "schema", "id int"))
{
table.WithUniqueConstraintOn("ID");
this.Processor.ConstraintExists("schema", table.Name, "UC_id").ShouldBeTrue();
}
}
public override void CallingConstraintExistsReturnsFalseIfConstraintDoesNotExist()
{
using (var table = new HanaTestTable(Processor, null, "id int"))
{
table.WithUniqueConstraintOn("ID");
Processor.ConstraintExists(null, table.Name, "DoesNotExist").ShouldBeFalse();
}
}
public override void CallingConstraintExistsReturnsFalseIfConstraintDoesNotExistWithSchema()
{
Assert.Ignore("HANA does not support schema like us know schema in hana is a database name");
using (var table = new HanaTestTable(Processor, "schemaName", "id int"))
{
table.WithUniqueConstraintOn("ID");
this.Processor.ConstraintExists("schemaName", table.Name, "DoesNotExist").ShouldBeFalse();
}
}