public override void CallingTableExistsReturnsTrueIfTableExistsWithSchema()
{
Assert.Ignore("HANA does not support schema like us know schema in hana is a database name");
using (var table = new HanaTestTable(Processor, "test_schema", "id int"))
Processor.TableExists("test_schema", table.Name).ShouldBeTrue();
}
public override void CallingTableExistsCanAcceptSchemaNameWithSingleQuote()
{
Assert.Ignore("HANA does not support schema like us know schema in hana is a database name");
using (var table = new HanaTestTable(Processor, "test'schema", "id int"))
Processor.TableExists("test'schema", table.Name).ShouldBeTrue();
}
public override void CallingConstraintExistsCanAcceptSchemaNameWithSingleQuote()
{
Assert.Ignore("HANA does not support schema like us know schema in hana is a database name");
using (var table = new HanaTestTable(Processor, "test'schema", "id int", "wibble int CONSTRAINT c1 CHECK(wibble > 0)"))
Processor.ConstraintExists("test'schema", table.Name, "c1").ShouldBeTrue();
}
public override void CallingTableExistsReturnsTrueIfTableExistsWithSchema()
{
Assert.Ignore("Schemas aren't supported by this SAP Hana runner");
using (var table = new HanaTestTable(Processor, "test_schema", "id int"))
Processor.TableExists("test_schema", table.Name).ShouldBeTrue();
}
public override void CallingIndexExistsReturnsFalseIfIndexDoesNotExistWithSchema()
{
Assert.Ignore("HANA does not support schema like us know schema in hana is a database name");
using (var table = new HanaTestTable(Processor, "test_schema", "id int"))
Processor.IndexExists("test_schema", table.Name, "DoesNotExist").ShouldBeFalse();
}
public override void CallingColumnExistsCanAcceptColumnNameWithSingleQuote()
{
var columnNameWithSingleQuote = Quoter.Quote("i'd");
using (var table = new HanaTestTable(Processor, null, string.Format("{0} int", columnNameWithSingleQuote)))
Processor.ColumnExists(null, table.Name, "i'd").ShouldBeTrue();
}
public override void CallingConstraintExistsCanAcceptSchemaNameWithSingleQuote()
{
Assert.Ignore("Hana doesn't support check constraints");
using (var table = new HanaTestTable(Processor, "test'schema", "id int", "wibble int CONSTRAINT c1 CHECK(wibble > 0)"))
Processor.ConstraintExists("test'schema", table.Name, "c1").ShouldBeTrue();
}
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 CallingIndexExistsCanAcceptSchemaNameWithSingleQuote()
{
using (var table = new HanaTestTable(Processor, "test'schema", "\"id\" int"))
{
var indexName = table.WithIndexOn("id");
Processor.IndexExists("test'schema", table.Name, indexName).ShouldBeTrue();
}
}
public override void CallingIndexExistsReturnsTrueIfIndexExists()
{
using (var table = new HanaTestTable(Processor, null, "\"id\" int"))
{
var indexName = table.WithIndexOn("id");
Processor.IndexExists(null, table.Name, indexName).ShouldBeTrue();
}
}
public override void CallingIndexExistsCanAcceptTableNameWithSingleQuote()
{
using (var table = new HanaTestTable("Test'Table", Processor, null, "\"id\" int"))
{
var indexName = table.WithIndexOn("id");
Processor.IndexExists(null, table.Name, indexName).ShouldBeTrue();
}
}
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 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 void CallingDefaultValueExistsCanAcceptSchemaNameWithSingleQuote()
{
Assert.Ignore("Hana doesn't support changing a columns default constraint");
using (var table = new HanaTestTable(Processor, "test'schema", "\"id\" int"))
{
table.WithDefaultValueOn("id");
Processor.DefaultValueExists("test'schema", table.Name, "id", 1).ShouldBeTrue();
}
}
public override void CallingIndexExistsCanAcceptIndexNameWithSingleQuote()
{
const string columnSingleQuote = "i'd";
using (var table = new HanaTestTable(Processor, null, Quoter.Quote(columnSingleQuote) + " int"))
{
var indexName = table.WithIndexOn(columnSingleQuote);
Processor.IndexExists(null, table.Name, indexName).ShouldBeTrue();
}
}
public void CallingDefaultValueExistsCanAcceptSchemaNameWithSingleQuote()
{
Assert.Ignore("HANA does not support schema like us know schema in hana is a database name");
using (var table = new HanaTestTable(Processor, "test'schema", "id int"))
{
table.WithDefaultValueOn("id");
Processor.DefaultValueExists("test'schema", table.Name, "id", 1).ShouldBeTrue();
}
}
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();
}
}
public override void CallingColumnExistsReturnsTrueIfColumnExists()
{
using (var table = new HanaTestTable(Processor, null, "id int"))
Processor.ColumnExists(null, table.Name, "id").ShouldBeTrue();
}
public override void CallingColumnExistsReturnsFalseIfColumnDoesNotExistWithSchema()
{
using (var table = new HanaTestTable(Processor, "test_schema", "id int"))
Processor.ColumnExists("test_schema", table.Name, "DoesNotExist").ShouldBeFalse();
}
public override void CallingColumnExistsReturnsFalseIfColumnDoesNotExist()
{
using (var table = new HanaTestTable(Processor, null, "id int"))
Processor.ColumnExists(null, table.Name, "DoesNotExist").ShouldBeFalse();
}
public override void CallingColumnExistsCanAcceptTableNameWithSingleQuote()
{
using (var table = new HanaTestTable("Test'Table", Processor, null, "id int"))
Processor.ColumnExists(null, table.Name, "id").ShouldBeTrue();
}
public override void CallingTableExistsCanAcceptSchemaNameWithSingleQuote()
{
using (var table = new HanaTestTable(Processor, "test'schema", "id int"))
Processor.TableExists("test'schema", table.Name).ShouldBeTrue();
}
