Deveel.Data.Sql.Expressions.SqlBetweenEspressionTests Class Reference

Public Member Functions
void	BetweenNumerics ()
void	BetweenDates ()

Detailed Description

Definition at line 24 of file SqlBetweenEspressionTests.cs.

Member Function Documentation

void Deveel.Data.Sql.Expressions.SqlBetweenEspressionTests.BetweenDates ( )

inline

Definition at line 48 of file SqlBetweenEspressionTests.cs.

                                   {
            const string sql = "TODATE('2001-02-12') BETWEEN TODATE('2000-01-20') AND TODATE('2003-01-01')";

            SqlExpression expression = null;
            Assert.DoesNotThrow(() => expression = SqlExpression.Parse(sql));
            Assert.IsNotNull(expression);

            Assert.IsInstanceOf<SqlBinaryExpression>(expression);
            Assert.AreEqual(SqlExpressionType.And, expression.ExpressionType);

            SqlExpression resultExpression = null;
            Assert.DoesNotThrow(() => resultExpression = expression.Evaluate());
            Assert.IsNotNull(resultExpression);
            Assert.AreEqual(SqlExpressionType.Constant, resultExpression.ExpressionType);

            var value = ((SqlConstantExpression)resultExpression).Value;

            Assert.IsInstanceOf<BooleanType>(value.Type);
            Assert.AreEqual(SqlBoolean.True, (SqlBoolean)value.Value);
        }

void Deveel.Data.Sql.Expressions.SqlBetweenEspressionTests.BetweenNumerics ( )

inline

Definition at line 26 of file SqlBetweenEspressionTests.cs.

                                      {
            const string sql = "22 BETWEEN 10 AND 54";

            SqlExpression expression = null;
            Assert.DoesNotThrow(() => expression = SqlExpression.Parse(sql));
            Assert.IsNotNull(expression);

            Assert.IsInstanceOf<SqlBinaryExpression>(expression);
            Assert.AreEqual(SqlExpressionType.And, expression.ExpressionType);

            SqlExpression resultExpression = null;
            Assert.DoesNotThrow(() => resultExpression = expression.Evaluate());
            Assert.IsNotNull(resultExpression);
            Assert.AreEqual(SqlExpressionType.Constant, resultExpression.ExpressionType);

            var value = ((SqlConstantExpression) resultExpression).Value;

            Assert.IsInstanceOf<BooleanType>(value.Type);
            Assert.AreEqual(SqlBoolean.True, (SqlBoolean)value.Value);
        }

---

The documentation for this class was generated from the following file:

• /var/calculate/remote/distfiles/egit-src/deveeldb.git/src/deveeldb-nunit/Deveel.Data.Sql.Expressions/SqlBetweenEspressionTests.cs