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(); } }