Examples of BetweenCriteria

com.cetsoft.imcache.cache.search.criteria.BetweenCriteria
The Class BetweenCriteria is used to retrieve items greater than lowerBound and less than upperBound.
org.teiid.query.sql.lang.BetweenCriteria
Represents criteria such as: " [NOT] BETWEEN AND ".

Examples of com.cetsoft.imcache.cache.search.criteria.BetweenCriteria

        .build();
    cache.put(0, createObject(1, 1));
    cache.put(1, createObject(2, 2));
    cache.put(2, createObject(3, 3));
    List<SimpleObject> objects = cache
        .execute(CacheQuery.newQuery().setCriteria(new BetweenCriteria("j", 1, 3).or(new ETCriteria("j", 3)))
            .setFilter(new LTFilter("k", 3)));
    for (SimpleObject simpleObject : objects) {
      System.out.println(simpleObject);
    }
  }

View Full Code Here

Examples of com.cetsoft.imcache.cache.search.criteria.BetweenCriteria

  public static void main(String []args){
    SearchableCache<Integer, SimpleObject> cache = CacheBuilder.heapCache().addIndex("j", IndexType.RANGE_INDEX).build();
    cache.put(0, createObject(1, 1));
    cache.put(1, createObject(2, 2));
    cache.put(2, createObject(3, 3));
    List<SimpleObject> objects = cache.execute(CacheQuery.newQuery().setCriteria(new BetweenCriteria("j",1,3).
        or(new ETCriteria("j", 3))).setFilter(new LEFilter("k", 3)));
    for (SimpleObject simpleObject : objects) {
      System.out.println(simpleObject);
    }
  }

View Full Code Here

Examples of org.teiid.query.sql.lang.BetweenCriteria

        ElementSymbol a = new ElementSymbol("a");  //$NON-NLS-1$
        select.addSymbol(a);


        Expression constant1 = new Constant(new Integer(1000));
        Expression constant2 = new Constant(new Integer(2000));
        Criteria crit = new BetweenCriteria(a, constant1, constant2);


        Query query = new Query();
        query.setSelect(select);
        query.setFrom(from);
        query.setCriteria(crit);

View Full Code Here

Examples of org.teiid.query.sql.lang.BetweenCriteria

        ElementSymbol a = new ElementSymbol("a");  //$NON-NLS-1$
        select.addSymbol(a);


        Expression constant1 = new Constant(new Integer(1000));
        Expression constant2 = new Constant(new Integer(2000));
        BetweenCriteria crit = new BetweenCriteria(a, constant1, constant2);
        crit.setNegated(true);
        Query query = new Query();
        query.setSelect(select);
        query.setFrom(from);
        query.setCriteria(crit);
        helpTest("SELECT a from db.g where a NOT BETWEEN 1000 AND 2000",  //$NON-NLS-1$

View Full Code Here

Examples of org.teiid.query.sql.lang.BetweenCriteria

        
        assertEquals("Incorrect string for null object", SQLStringVisitor.UNDEFINED, sql); //$NON-NLS-1$
  }
    
    public void testBetweenCriteria1() {
        BetweenCriteria bc = new BetweenCriteria(
            new ElementSymbol("m.g.c1"), //$NON-NLS-1$
            new Constant(new Integer(1000)),
            new Constant(new Integer(2000)) );
        helpTest(bc, "m.g.c1 BETWEEN 1000 AND 2000"); //$NON-NLS-1$
    }

View Full Code Here

Examples of org.teiid.query.sql.lang.BetweenCriteria

            new Constant(new Integer(2000)) );
        helpTest(bc, "m.g.c1 BETWEEN 1000 AND 2000"); //$NON-NLS-1$
    }
    
    public void testBetweenCriteria2() {
        BetweenCriteria bc = new BetweenCriteria(
            new ElementSymbol("m.g.c1"), //$NON-NLS-1$
            new Constant(new Integer(1000)),
            new Constant(new Integer(2000)) );
        bc.setNegated(true);
        helpTest(bc, "m.g.c1 NOT BETWEEN 1000 AND 2000"); //$NON-NLS-1$
    }

View Full Code Here

Examples of org.teiid.query.sql.lang.BetweenCriteria

  }  
  
  // ################################## TEST HELPERS ################################  
    
  public static BetweenCriteria example(String element, int lower, int upper, boolean negated) {
        BetweenCriteria criteria = new BetweenCriteria(new ElementSymbol(element),
                                                       new Constant(new Integer(lower)),
                                                       new Constant(new Integer(upper)));
        criteria.setNegated(negated);
    return criteria;        
    }

View Full Code Here

Examples of org.teiid.query.sql.lang.BetweenCriteria

    }
    
  // ################################## ACTUAL TESTS ################################
  
  public void testEquals1() {
        BetweenCriteria c1 = example("x", 1, 20, false); //$NON-NLS-1$
        BetweenCriteria c2 = example("x", 1, 20, false); //$NON-NLS-1$
    assertTrue("Equivalent between criteria don't compare as equal: " + c1 + ", " + c2, c1.equals(c2));         //$NON-NLS-1$ //$NON-NLS-2$
  }

View Full Code Here

Examples of org.teiid.query.sql.lang.BetweenCriteria

        BetweenCriteria c2 = example("x", 1, 20, false); //$NON-NLS-1$
    assertTrue("Equivalent between criteria don't compare as equal: " + c1 + ", " + c2, c1.equals(c2));         //$NON-NLS-1$ //$NON-NLS-2$
  }


    public void testEquals2() {    
        BetweenCriteria c1 = example("x", 1, 20, true); //$NON-NLS-1$
        BetweenCriteria c2 = (BetweenCriteria)c1.clone();
        assertTrue("Equivalent between criteria don't compare as equal: " + c1 + ", " + c2, c1.equals(c2));              //$NON-NLS-1$ //$NON-NLS-2$
    }

View Full Code Here

Examples of org.teiid.query.sql.lang.BetweenCriteria

        BetweenCriteria c2 = (BetweenCriteria)c1.clone();
        assertTrue("Equivalent between criteria don't compare as equal: " + c1 + ", " + c2, c1.equals(c2));              //$NON-NLS-1$ //$NON-NLS-2$
    }


    public void testEquals3() {    
        BetweenCriteria c1 = example("x", 1, 20, true); //$NON-NLS-1$
        BetweenCriteria c2 = (BetweenCriteria)c1.clone();
        c2.setNegated(false);
        assertFalse("Criteria should not be equal: " + c1 + ", " + c2, c1.equals(c2));              //$NON-NLS-1$ //$NON-NLS-2$
    }

View Full Code Here

0 1

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.