public void EmptyStringForCloseQuote()
        {
            // Arrange
             var quoter = new OracleQuoter();

             // Act

             // Assert
             quoter.CloseQuote.ShouldBe(string.Empty);
        }
        public void CanQuoteBinaryValue()
        {
            // Arrange
             var quoter = new OracleQuoter();
             // Act

             var value = quoter.QuoteValue(System.Text.Encoding.ASCII.GetBytes("Foo"));

             // Assert
             value.ShouldBe("hextoraw('466F6F')");
        }
        public void CanQuoteNull()
        {
            // Arrange
             var quoter = new OracleQuoter();

             // Act

             var value = quoter.QuoteValue(null);

             // Assert
             value.ShouldBe("NULL");
        }
        public void CanQuoteGuid()
        {
            // Arrange
             var quoter = new OracleQuoter();

             // Act

             var value = quoter.QuoteValue(new Guid("30e16f6e-d8e2-45b9-97aa-9ef500fa1e9b"));

             // Assert
             value.ShouldBe("hextoraw('30E16F6ED8E245B997AA9EF500FA1E9B')");
        }
Exemple #5
0
 public void ShouldEscapeOracleObjectNames()
 {
     //Do Nothing at the moment due to case sensitivity issues with oracle
     OracleQuoter quoter = new OracleQuoter();
     quoter.Quote("Table\"Name").ShouldBe("Table\"Name");
 }
 public OracleGenerator(OracleColumn column, OracleQuoter quoter )
     : base(column, quoter)
 {
 }
        private void QuoteInsertColumnNames(InsertDataExpression expression)
        {
            if ( ! expression.CaseSensitiveColumnNames)
            return;

              var quoter = new OracleQuoter {CaseSensitiveNames = expression.CaseSensitiveColumnNames};
              foreach ( var row in expression.Rows )
              {
             var toRemove = (from nameValue in row
                             let quotedName = quoter.QuoteColumnName(nameValue.Key)
                            where quotedName != nameValue.Key && (expression.CaseSensitiveColumns.Count == 0 || expression.CaseSensitiveColumns.Contains(nameValue.Key))
                             select nameValue).ToList();

             foreach (var keyValuePair in toRemove)
             {
                row.Remove(keyValuePair);
                row.Add(new KeyValuePair<string, object>(quoter.QuoteColumnName(keyValuePair.Key), keyValuePair.Value));
             }
              }
        }