public override void CallingIndexExistsCanAcceptSchemaNameWithSingleQuote()
{
using (var table = new SqlServerTestTable(Processor, "test'schema", "id int"))
{
var indexName = table.WithIndexOn("id");
Processor.IndexExists("test'schema", table.Name, indexName).ShouldBeTrue();
}
}
public override void CallingIndexExistsCanAcceptTableNameWithSingleQuote()
{
using (var table = new SqlServerTestTable("Test'Table", Processor, null, "id int"))
{
var indexName = table.WithIndexOn("id");
Processor.IndexExists(null, table.Name, indexName).ShouldBeTrue();
}
}
public override void CallingIndexExistsCanAcceptIndexNameWithSingleQuote()
{
const string columnSingleQuote = "i'd";
using (var table = new SqlServerTestTable(Processor, null, Quoter.Quote(columnSingleQuote) + " int"))
{
var indexName = table.WithIndexOn(columnSingleQuote);
Processor.IndexExists(null, table.Name, indexName).ShouldBeTrue();
}
}
public override void CallingIndexExistsReturnsTrueIfIndexExistsWithSchema()
{
using (var table = new SqlServerTestTable(Processor, "test_schema", "id int"))
{
var indexName = table.WithIndexOn("id");
Processor.IndexExists("test_schema", table.Name, indexName).ShouldBeTrue();
}
}
