Examples of Between

com.intersys.gds.query.Between
Between query takes three arguments, a String key which identifies the key value pair to query, and two numeric arguments. The two numeric arguments are passed in as instances of java.lang.Numeric arguments, and have to be one of the following java.lang.* types (Integer, Long or Double). If the arguments are not of those types, or if the underlying data is not numeric an exception is thrown.
com.j256.ormlite.stmt.query.Between
Internal class handling the SQL 'between' query part. Used by {@link Where#between}. @author graywatson
com.vaadin.data.util.filter.Between
net.sf.ehcache.search.expression.Between
Range criteria @author teck
net.sf.jsqlparser.expression.operators.relational.Between
A "BETWEEN" expr1 expr2 statement
org.crank.crud.criteria.Between
org.jboss.dna.graph.query.model.Between
A constraint that evaluates to true when the value defined by the dynamic operand evaluates to be within the specified range.
org.modeshape.jcr.query.model.Between
A constraint that evaluates to true when the value defined by the dynamic operand evaluates to be within the specified range.

Examples of com.vaadin.data.util.filter.Between

    public boolean translatesFilter(Filter filter) {
        return filter instanceof Between;
    }


    public String getWhereStringForFilter(Filter filter, StatementHelper sh) {
        Between between = (Between) filter;
        sh.addParameterValue(between.getStartValue());
        sh.addParameterValue(between.getEndValue());
        return QueryBuilder.quote(between.getPropertyId()) + " BETWEEN ? AND ?";
    }

View Full Code Here

Examples of com.vaadin.data.util.filter.Between

        return filter instanceof Between;
    }


    @Override
    public String getWhereStringForFilter(Filter filter, StatementHelper sh) {
        Between between = (Between) filter;
        sh.addParameterValue(between.getStartValue());
        sh.addParameterValue(between.getEndValue());
        return QueryBuilder.quote(between.getPropertyId()) + " BETWEEN ? AND ?";
    }

View Full Code Here

Examples of net.sf.ehcache.search.expression.Between

     * @param minInclusive is the minimum inclusive in the range
     * @param maxInclusive is the maximum inclusive in the range
     * @return criteria instance
     */
    public Criteria between(T min, T max, boolean minInclusive, boolean maxInclusive) {
        return new Between(attributeName, min, max, minInclusive, maxInclusive);
    }

View Full Code Here

Examples of net.sf.jsqlparser.expression.operators.relational.Between

                {if (true) return result;}
    throw new Error("Missing return statement in function");
  }


  final public Expression Between() throws ParseException {
        Between result = new Between();
        Expression leftExpression = null;
        Expression betweenExpressionStart = null;
        Expression betweenExpressionEnd = null;
    leftExpression = SimpleExpression();
    switch ((jj_ntk==-1)?jj_ntk():jj_ntk) {
    case K_NOT:
      jj_consume_token(K_NOT);
                       result.setNot(true);
      break;
    default:
      jj_la1[91] = jj_gen;
      ;
    }
    jj_consume_token(K_BETWEEN);
    betweenExpressionStart = SimpleExpression();
    jj_consume_token(K_AND);
    betweenExpressionEnd = SimpleExpression();
                result.setLeftExpression(leftExpression);
                result.setBetweenExpressionStart(betweenExpressionStart);
                result.setBetweenExpressionEnd(betweenExpressionEnd);
                {if (true) return result;}
    throw new Error("Missing return statement in function");
  }

View Full Code Here

Examples of net.sf.jsqlparser.expression.operators.relational.Between

        OrExpression or = new OrExpression(left, rigth);
        this._qualifiedExpression = or;
    }


    public void visit(Between between) {
        Between qualified = new Between();


        Expression start = qualify(session, tableAliases, between.getBetweenExpressionStart());
        Expression end = qualify(session, tableAliases, between.getBetweenExpressionEnd());
        Expression left = qualify(session, tableAliases, between.getLeftExpression());


        qualified.setBetweenExpressionStart(start);
        qualified.setBetweenExpressionEnd(end);
        qualified.setLeftExpression(left);
        this._qualifiedExpression = qualified;
    }

View Full Code Here

Examples of org.crank.crud.criteria.Between

        if (comparison.getValue() != null) {
          final String sOperator = comparison.getOperator()
              .getOperator();
          if (!"like".equalsIgnoreCase(sOperator)) {
            if (comparison instanceof Between) {
              Between between = (Between) comparison;
              query.setParameter(name + "_1", comparison
                  .getValue());
              query
                  .setParameter(name + "_2", between
                      .getValue2());
            } else if (comparison instanceof VerifiedBetween) {
              VerifiedBetween between = (VerifiedBetween) comparison;
              query.setParameter(name + "_1", comparison
                  .getValue());
              query
                  .setParameter(name + "_2", between
                      .getValue2());
            } else {
              query.setParameter(name, comparison.getValue());
            }

View Full Code Here

Examples of org.jboss.dna.graph.query.model.Between

            SelectorName replacement = rewrittenSelectors.get(search.getSelectorName());
            if (replacement == null) return search;
            return new FullTextSearch(replacement, search.getPropertyName(), search.getFullTextSearchExpression());
        }
        if (constraint instanceof Between) {
            Between between = (Between)constraint;
            DynamicOperand lhs = between.getOperand();
            StaticOperand lower = between.getLowerBound(); // Current only a literal; therefore, no reference to selector
            StaticOperand upper = between.getUpperBound(); // Current only a literal; therefore, no reference to selector
            DynamicOperand newLhs = replaceReferencesToRemovedSource(context, lhs, rewrittenSelectors);
            if (lhs == newLhs) return between;
            return new Between(newLhs, lower, upper, between.isLowerBoundIncluded(), between.isUpperBoundIncluded());
        }
        if (constraint instanceof Comparison) {
            Comparison comparison = (Comparison)constraint;
            DynamicOperand lhs = comparison.getOperand1();
            StaticOperand rhs = comparison.getOperand2(); // Current only a literal; therefore, no reference to selector

View Full Code Here

Examples of org.jboss.dna.graph.query.model.Between

            node.addSelector(sourceColumn.getSelectorName());
            return new FullTextSearch(sourceColumn.getSelectorName(), sourceColumn.getPropertyName(),
                                      search.getFullTextSearchExpression());
        }
        if (constraint instanceof Between) {
            Between between = (Between)constraint;
            DynamicOperand lhs = between.getOperand();
            StaticOperand lower = between.getLowerBound(); // Current only a literal; therefore, no reference to selector
            StaticOperand upper = between.getUpperBound(); // Current only a literal; therefore, no reference to selector
            DynamicOperand newLhs = replaceViewReferences(context, lhs, mapping, node);
            if (lhs == newLhs) return between;
            return new Between(newLhs, lower, upper, between.isLowerBoundIncluded(), between.isUpperBoundIncluded());
        }
        if (constraint instanceof Comparison) {
            Comparison comparison = (Comparison)constraint;
            DynamicOperand lhs = comparison.getOperand1();
            StaticOperand rhs = comparison.getOperand2(); // Current only a literal; therefore, no reference to selector

View Full Code Here

Examples of org.jboss.dna.graph.query.model.Between

                                            Object upperBoundLiteral ) {
            assert lowerBoundLiteral != null;
            assert upperBoundLiteral != null;
            Literal lower = lowerBoundLiteral instanceof Literal ? (Literal)lowerBoundLiteral : new Literal(lowerBoundLiteral);
            Literal upper = upperBoundLiteral instanceof Literal ? (Literal)upperBoundLiteral : new Literal(upperBoundLiteral);
            return this.constraintBuilder.setConstraint(new Between(left, lower, upper));
        }

View Full Code Here

Examples of org.jboss.dna.graph.query.model.Between

                        StaticOperand lowerBound = parseStaticOperand(tokens, typeSystem);
                        boolean lowerInclusive = !tokens.canConsume("EXCLUSIVE");
                        tokens.consume("AND");
                        StaticOperand upperBound = parseStaticOperand(tokens, typeSystem);
                        boolean upperInclusive = !tokens.canConsume("EXCLUSIVE");
                        constraint = new Between(left, lowerBound, upperBound, lowerInclusive, upperInclusive);
                        if (not) constraint = new Not(constraint);
                    } else {
                        Operator operator = parseComparisonOperator(tokens);
                        StaticOperand right = parseStaticOperand(tokens, typeSystem);
                        constraint = new Comparison(left, operator, right);

View Full Code Here

0 1 2 3 4 5

TOP

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.