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(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 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 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 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 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 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 CallingConstraintExistsReturnsTrueIfConstraintExistWithSchema()
 {
     using (var table = new OracleTestTable(Connection, Quoter, SchemaName, Quoter.QuoteColumnName("id") + " int"))
     {
         table.WithUniqueConstraintOn("id");
         Processor.ConstraintExists(SchemaName, table.Name, "UC_id").ShouldBeTrue();
     }
 }