C# (CSharp) Deveel.Data.Sql.Parser SqlBetweenExpressionNode 예제들

예제 #1

파일: ExpressionBuilder.cs 프로젝트: prepare/deveeldb

        public override void VisitBetweenExpression(SqlBetweenExpressionNode expressionNode)
        {
            var testExp = Build(expressionNode.Expression);
            var minValue = Build(expressionNode.MinValue);
            var maxValue = Build(expressionNode.MaxValue);

            var smallerExp = SqlExpression.SmallerOrEqualThan(testExp, maxValue);
            var greaterExp = SqlExpression.GreaterOrEqualThan(testExp, minValue);

            outputExpression = SqlExpression.And(smallerExp, greaterExp);

            if (expressionNode.Not)
                outputExpression = SqlExpression.Not(outputExpression);
        }

예제 #2

        private static SqlExpression VisitBetweenExpression(SqlBetweenExpressionNode expressionNode)
        {
            var testExp  = Build(expressionNode.Expression);
            var minValue = Build(expressionNode.MinValue);
            var maxValue = Build(expressionNode.MaxValue);

            var smallerExp = SqlExpression.SmallerOrEqualThan(testExp, maxValue);
            var greaterExp = SqlExpression.GreaterOrEqualThan(testExp, minValue);

            SqlExpression exp = SqlExpression.And(smallerExp, greaterExp);

            if (expressionNode.Not)
            {
                exp = SqlExpression.Not(exp);
            }

            return(exp);
        }

예제 #3

파일: SqlNodeVisitor.cs 프로젝트: ArsenShnurkov/deveeldb

 public virtual void VisitBetweenExpression(SqlBetweenExpressionNode node)
 {
 }

예제 #4

파일: ExpressionBuilder.cs 프로젝트: furesoft/deveeldb

        private static SqlExpression VisitBetweenExpression(SqlBetweenExpressionNode expressionNode)
        {
            var testExp = Build(expressionNode.Expression);
            var minValue = Build(expressionNode.MinValue);
            var maxValue = Build(expressionNode.MaxValue);

            var smallerExp = SqlExpression.SmallerOrEqualThan(testExp, maxValue);
            var greaterExp = SqlExpression.GreaterOrEqualThan(testExp, minValue);

            SqlExpression exp = SqlExpression.And(smallerExp, greaterExp);

            if (expressionNode.Not)
                exp = SqlExpression.Not(exp);

            return exp;
        }

예제 #5

 public virtual void VisitBetweenExpression(SqlBetweenExpressionNode node)
 {
 }