public override void CallingIndexExistsCanAcceptTableNameWithSingleQuote()
{
using (var table = new OracleTestTable("Test'Table", this.Connection, null, this.Factory, "id int"))
{
table.WithIndexOn("ID");
this.Processor.IndexExists(null, table.Name, "UI_id").ShouldBeTrue();
}
}
public override void CallingIndexExistsReturnsFalseIfIndexDoesNotExistWithSchema()
{
using (var table = new OracleTestTable(this.Connection, SchemaName, this.Factory, "id int"))
{
table.WithIndexOn("ID");
this.Processor.IndexExists(SchemaName, table.Name, "DoesNotExist").ShouldBeFalse();
}
}
public override void CallingIndexExistsReturnsFalseIfIndexDoesNotExistWithSchema()
{
using (var table = new OracleTestTable(Connection, SchemaName, Quoter.QuoteColumnName("id") + " int"))
{
table.WithIndexOn("id");
Processor.IndexExists(SchemaName, table.Name, "DoesNotExist").ShouldBeFalse();
}
}
public override void CallingIndexExistsCanAcceptTableNameWithSingleQuote()
{
using (var table = new OracleTestTable("Test'Table", Connection, null, Quoter.QuoteColumnName("id") + " int"))
{
table.WithIndexOn("id");
Processor.IndexExists(null, table.Name, "UI_id").ShouldBeTrue();
}
}
public void CallingIndexExistsWithIncorrectCaseReturnsFalseIfIndexExist()
{
//the IndexExists() function is'nt case sensitive
using (var table = new OracleTestTable(this.Connection, null, this.Factory, "id int"))
{
table.WithIndexOn("ID", "ui_id");
this.Processor.IndexExists(null, table.Name, "Ui_Id").ShouldBeTrue();
}
}
public override void CallingIndexExistsReturnsTrueIfIndexExists()
{
using (var table = new OracleTestTable(this.Connection, null, this.Factory, "id int"))
{
table.WithIndexOn("ID");
this.Processor.IndexExists(null, table.Name, "UI_id").ShouldBeTrue();
}
}
public void CallingIndexExistsWithIncorrectCaseReturnsFalseIfIndexExist()
{
using (var table = new OracleTestTable(Connection, null, Quoter.QuoteColumnName("id") + " int"))
{
table.WithIndexOn("id");
Processor.IndexExists(null, table.Name, "UI_ID").ShouldBeFalse();
}
}
public void CallingIndexExistsReturnsTrueIfIndexExistWithSchema()
{
using (var table = new OracleTestTable(Connection, Quoter, SchemaName, Quoter.QuoteColumnName("id") + " int"))
{
table.WithIndexOn("id");
Processor.IndexExists(SchemaName, table.Name, "UI_id").ShouldBeTrue();
}
}