public override void CallingConstraintExistsReturnsFalseIfConstraintDoesNotExistWithSchema()
{
using (var table = new OracleTestTable(Connection, SchemaName, Quoter.QuoteColumnName("id") + " int"))
{
table.WithUniqueConstraintOn("id");
Processor.ConstraintExists(SchemaName, table.Name, "DoesNotExist").ShouldBeFalse();
}
}
public override void CallingConstraintExistsCanAcceptTableNameWithSingleQuote()
{
using (var table = new OracleTestTable("Test'Table", Connection, null, Quoter.QuoteColumnName("id") + " int"))
{
table.WithUniqueConstraintOn("id");
Processor.ConstraintExists(null, table.Name, "UC_id").ShouldBeTrue();
}
}
public void CallingConstraintExistsWithIncorrectCaseReturnsFalseIfConstraintExists()
{
using (var table = new OracleTestTable(Connection, null, Quoter.QuoteColumnName("id") + " int"))
{
table.WithUniqueConstraintOn("id");
Processor.ConstraintExists(null, table.Name, "UC_ID").ShouldBeFalse();
}
}
public override void CallingIndexExistsCanAcceptIndexNameWithSingleQuote()
{
using (var table = new OracleTestTable(Connection, null, Quoter.QuoteColumnName("id") + " int"))
{
table.WithIndexOn("id", "UI'id");
Processor.IndexExists(null, table.Name, "UI'id").ShouldBeTrue();
}
}
public override void CallingIndexExistsReturnsFalseIfIndexDoesNotExist()
{
using (var table = new OracleTestTable(Connection, null, Quoter.QuoteColumnName("id") + " int"))
{
table.WithIndexOn("id");
Processor.IndexExists(null, table.Name, "DoesNotExist").ShouldBeFalse();
}
}
public void CallingConstraintExistsReturnsFalseIfConstraintExistsInDifferentSchema()
{
using (var table = new OracleTestTable(this.Connection, SchemaName, this.Factory, "id int"))
{
table.WithUniqueConstraintOn("ID");
this.Processor.ConstraintExists("testschema", table.Name, "UC_id").ShouldBeFalse();
}
}
public override void CallingConstraintExistsReturnsFalseIfConstraintDoesNotExistWithSchema()
{
using (var table = new OracleTestTable(this.Connection, SchemaName, this.Factory, "id int"))
{
table.WithUniqueConstraintOn("ID");
this.Processor.ConstraintExists(SchemaName, table.Name, "DoesNotExist").ShouldBeFalse();
}
}
public override void CallingIndexExistsReturnsFalseIfIndexDoesNotExist()
{
using (var table = new OracleTestTable(this.Connection, null, this.Factory, "id int"))
{
table.WithIndexOn("ID");
this.Processor.IndexExists(null, table.Name, "DoesNotExist").ShouldBeFalse();
}
}
public override void CallingConstraintExistsCanAcceptTableNameWithSingleQuote()
{
using( var table = new OracleTestTable( "Test'Table", this.Connection, null, this.Factory, "id int" ) )
{
table.WithUniqueConstraintOn("ID");
this.Processor.ConstraintExists(null, table.Name, "UC_id").ShouldBeTrue();
}
}
public void CallingConstraintExistsReturnsFalseIfConstraintExistsInDifferentSchema()
{
using (var table = new OracleTestTable(Connection, SchemaName, Quoter.QuoteColumnName("id") + " int"))
{
table.WithUniqueConstraintOn("id");
Processor.ConstraintExists("testschema", table.Name, "UC_id").ShouldBeFalse();
}
}
public override void CallingIndexExistsCanAcceptIndexNameWithSingleQuote()
{
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 void CallingConstraintExistsWithIncorrectCaseReturnsTrueIfConstraintExists()
{
//the ConstraintExists() function is'nt case sensitive
using (var table = new OracleTestTable(this.Connection, null, this.Factory, "id int"))
{
table.WithUniqueConstraintOn("ID", "uc_id");
this.Processor.ConstraintExists(null, table.Name, "Uc_Id").ShouldBeTrue();
}
}
public override void CallingIndexExistsReturnsTrueIfIndexExistsWithSchema()
{
using (var table = new OracleTestTable(this.Connection, SchemaName, this.Factory, "id int"))
{
table.WithIndexOn("ID");
this.Processor.IndexExists(SchemaName, table.Name, "UI_id").ShouldBeTrue();
}
}
public void CallingColumnExistsReturnsTrueIfColumnExists()
{
using (var table = new OracleTestTable(Connection, Quoter, null, Quoter.QuoteColumnName("id") + " int"))
Processor.ColumnExists(null, table.Name, "id").ShouldBeTrue();
}
public void CallingColumnExistsWithIncorrectCaseReturnsTrueIfColumnExists()
{
//the ColumnExisits() function is'nt case sensitive
using (var table = new OracleTestTable(this.Connection, null, this.Factory, "id int"))
this.Processor.ColumnExists(null, table.Name, "Id").ShouldBeTrue();
}
public override void CallingTableExistsCanAcceptTableNameWithSingleQuote()
{
using (var table = new OracleTestTable("Test'Table", this.Connection, null, this.Factory, "id int"))
this.Processor.TableExists(null, table.Name).ShouldBeTrue();
}
public override void CallingColumnExistsReturnsTrueIfColumnExistsWithSchema()
{
using (var table = new OracleTestTable(Connection, SchemaName, Quoter.QuoteColumnName("id") + " int"))
Processor.ColumnExists(SchemaName, table.Name, "id").ShouldBeTrue();
}
public override void CallingColumnExistsReturnsFalseIfColumnDoesNotExist()
{
using (var table = new OracleTestTable(Connection, null, Quoter.QuoteColumnName("id") + " int"))
Processor.ColumnExists(null, table.Name, "DoesNotExist").ShouldBeFalse();
}
public override void CallingColumnExistsCanAcceptTableNameWithSingleQuote()
{
using (var table = new OracleTestTable("Test'Table", Connection, null, Quoter.QuoteColumnName("id") + " int"))
Processor.ColumnExists(null, table.Name, "DoesNotExist").ShouldBeFalse();
}
public override void CallingColumnExistsCanAcceptColumnNameWithSingleQuote()
{
using (var table = new OracleTestTable(Connection, null, Quoter.QuoteColumnName("i'd") + " int"))
Processor.ColumnExists(null, table.Name, "i'd").ShouldBeTrue();
}
public void CallingColumnExistsWithIncorrectCaseReturnsFalseIfColumnExists()
{
using (var table = new OracleTestTable(Connection, Quoter, null, Quoter.QuoteColumnName("id") + " int"))
Processor.ColumnExists(null, table.Name, "ID").ShouldBeFalse();
}
public override void CallingConstraintExistsReturnsTrueIfConstraintExists()
{
using (var table = new OracleTestTable(this.Connection, null, this.Factory, "id int"))
{
table.WithUniqueConstraintOn("ID");
this.Processor.ConstraintExists(null, table.Name, "UC_id").ShouldBeTrue();
}
}
public void CallingColumnExistsReturnsFalseIfColumnExistsInDifferentSchema()
{
using (var table = new OracleTestTable(this.Connection, SchemaName, this.Factory, "id int"))
this.Processor.ColumnExists("testschema", table.Name, "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();
}
}
public void CallingTableExistsReturnsFalseIfTableExistsInDifferentSchema()
{
using (var table = new OracleTestTable(Connection, SchemaName, Quoter.QuoteColumnName("id") + " int"))
Processor.TableExists("testschema", table.Name).ShouldBeFalse();
}
public void CallingColumnExistsReturnsFalseIfColumnDoesNotExistWithSchema()
{
using (var table = new OracleTestTable(Connection, Quoter, SchemaName, Quoter.QuoteColumnName("id") + " int"))
Processor.ColumnExists(SchemaName, table.Name, "DoesNotExist").ShouldBeFalse();
}
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 void CallingConstraintExistsReturnsTrueIfConstraintExistWithSchema()
{
using (var table = new OracleTestTable(Connection, Quoter, SchemaName, Quoter.QuoteColumnName("id") + " int"))
{
table.WithUniqueConstraintOn("id");
Processor.ConstraintExists(SchemaName, table.Name, "UC_id").ShouldBeTrue();
}
}
public override void CallingTableExistsReturnsTrueIfTableExistsWithSchema()
{
using (var table = new OracleTestTable(this.Connection, SchemaName, this.Factory, "id int"))
this.Processor.TableExists(SchemaName, table.Name).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();
}
}
