Examples of com.google.visualization.datasource.query.QueryFilter

Package com.google.visualization.datasource.query

Examples of com.google.visualization.datasource.query.QueryFilter

com.google.visualization.datasource.query.QueryFilter
A query filter. Any class that implements this interface can act as a filter, i.e., be the part of a query that decides for a given TableRow if that row is part of the result set. @author Yonatan B.Y.

    assertEquals(ComparisonFilter.Operator.NE, f.getOperator());
  }


  public void testColumnValueFilterWithBoolean2() throws Exception {
    Query query = QueryBuilder.getInstance().parseQuery(" WHERE `min` >= FalSe");
    QueryFilter filter = query.getFilter();
    assertTrue(filter instanceof ColumnValueFilter);
    ColumnValueFilter f = (ColumnValueFilter) filter;
    assertEquals("min", f.getColumn().getId());
    Value val = f.getValue();
    assertTrue(val instanceof BooleanValue);

View Full Code Here

    assertEquals(false, f.isComparisonOrderReversed());
  }


  public void testReverseColumnValueFilter1() throws Exception {
    Query query = QueryBuilder.getInstance().parseQuery(" WHERE -.3 < `ba ba`");
    QueryFilter filter = query.getFilter();
    assertTrue(filter instanceof ColumnValueFilter);
    ColumnValueFilter f = (ColumnValueFilter) filter;
    assertEquals("ba ba", f.getColumn().getId());
    Value val = f.getValue();
    assertTrue(val instanceof NumberValue);

View Full Code Here

    assertEquals(true, f.isComparisonOrderReversed());
  }


  public void testReverseColumnValueFilter2() throws Exception {
    Query query = QueryBuilder.getInstance().parseQuery(" WHERE 'select' > count  ");
    QueryFilter filter = query.getFilter();
    assertTrue(filter instanceof ColumnValueFilter);
    ColumnValueFilter f = (ColumnValueFilter) filter;
    assertEquals("count", f.getColumn().getId());
    Value val = f.getValue();
    assertTrue(val instanceof TextValue);

View Full Code Here

    assertEquals(true, f.isComparisonOrderReversed());
  }


  public void testReverseColumnValueFilter3() throws Exception {
    Query query = QueryBuilder.getInstance().parseQuery(" WHERE false <> `false`  ");
    QueryFilter filter = query.getFilter();
    assertTrue(filter instanceof ColumnValueFilter);
    ColumnValueFilter f = (ColumnValueFilter) filter;
    assertEquals("false", f.getColumn().getId());
    Value val = f.getValue();
    assertTrue(val instanceof BooleanValue);

View Full Code Here

    assertEquals(true, f.isComparisonOrderReversed());
  }


  public void testNegationFilter() throws Exception {
    Query query = QueryBuilder.getInstance().parseQuery(" WHERE not (c1 < c2) ");
    QueryFilter filter = query.getFilter();
    assertTrue(filter instanceof NegationFilter);
    NegationFilter f = (NegationFilter) filter;
    QueryFilter subFilter = f.getSubFilter();
    assertTrue(subFilter instanceof ColumnColumnFilter);
    ColumnColumnFilter ccf = (ColumnColumnFilter) subFilter;
    assertEquals("c1", ccf.getFirstColumn().getId());
    assertEquals("c2", ccf.getSecondColumn().getId());
    assertEquals(ComparisonFilter.Operator.LT, ccf.getOperator());

View Full Code Here

  }


  public void testAndFilter() throws Exception {
    Query query = QueryBuilder.getInstance().parseQuery(
        " WHERE c1 < c2 AND 4 >= `WHERE` aNd (`c1` < `c 3`)");
    QueryFilter filter = query.getFilter();
    assertTrue(filter instanceof CompoundFilter);
    CompoundFilter f = (CompoundFilter) filter;
    assertEquals(CompoundFilter.LogicalOperator.AND, f.getOperator());
    List<QueryFilter> subFilters = f.getSubFilters();
    assertEquals(3, subFilters.size());
    QueryFilter f1 = subFilters.get(0);
    QueryFilter f2 = subFilters.get(1);
    QueryFilter f3 = subFilters.get(2);
    assertTrue(f1 instanceof ColumnColumnFilter);
    assertTrue(f2 instanceof ColumnValueFilter);
    assertTrue(f3 instanceof ColumnColumnFilter);
    Set<String> allColumnIds = f.getAllColumnIds();
    assertEquals(Sets.newHashSet("c1", "c2", "c 3", "WHERE"), allColumnIds);

View Full Code Here


  public void testMultipleAndAssociativity() throws Exception {
    Query query = QueryBuilder.getInstance().parseQuery(
        " WHERE `Date` > '2008-06-01' and `RoleId` != 47 and "
            + "`RoleId` != 6 and `RoleId` != 8 and `RoleId` != 2");
    QueryFilter filter = query.getFilter();
    assertTrue(filter instanceof CompoundFilter);
    CompoundFilter f = (CompoundFilter) filter;
    assertEquals(CompoundFilter.LogicalOperator.AND, f.getOperator());
    List<QueryFilter> subFilters = f.getSubFilters();
    ColumnValueFilter[] filters = new ColumnValueFilter[5];

View Full Code Here

  }


  public void testOrFilterWithExtraneousParantheses() throws Exception {
    Query query = QueryBuilder.getInstance().parseQuery(
        " WHERE (((c1 < c2)) OR 4 >= `WHERE` OR (`c1` < `c 3`))");
    QueryFilter filter = query.getFilter();
    assertTrue(filter instanceof CompoundFilter);
    CompoundFilter f = (CompoundFilter) filter;
    assertEquals(CompoundFilter.LogicalOperator.OR, f.getOperator());
    List<QueryFilter> subFilters = f.getSubFilters();
    assertEquals(3, subFilters.size());
    QueryFilter f1 = subFilters.get(0);
    QueryFilter f2 = subFilters.get(1);
    QueryFilter f3 = subFilters.get(2);
    assertTrue(f1 instanceof ColumnColumnFilter);
    assertTrue(f2 instanceof ColumnValueFilter);
    assertTrue(f3 instanceof ColumnColumnFilter);
    Set<String> allColumnIds = f.getAllColumnIds();
    assertEquals(Sets.newHashSet("c1", "c2", "c 3", "WHERE"), allColumnIds);

View Full Code Here

  public void testReallyComplexFilter() throws Exception {
    Query query = QueryBuilder.getInstance().parseQuery(
        "SELECT c1,c2 WHERE (NOT ((c1 < c2) OR (NOT (c3 < " +
            "c4))) AND (NOT ((NOT (NOT (c5 < c6))) OR (c7 < c8))) AND " +
            "((c9 < c10) AND ((c11 < c12) OR ((c13 < c14) AND (c15 < c16)))))");
    QueryFilter filter = query.getFilter();
    assertTrue(filter instanceof CompoundFilter);
    CompoundFilter f = (CompoundFilter) filter;
    assertEquals(CompoundFilter.LogicalOperator.AND, f.getOperator());
    List<QueryFilter> subFilters = f.getSubFilters();
    assertEquals(3, subFilters.size());
    QueryFilter f1 = subFilters.get(0);
    QueryFilter f2 = subFilters.get(1);
    QueryFilter f3 = subFilters.get(2);


    // f1: (!((c1 < c2) || (!(c3 < c4)))
    assertTrue(f1 instanceof NegationFilter);
    NegationFilter nf = (NegationFilter) f1;
    QueryFilter subFilter = nf.getSubFilter();
    assertTrue(subFilter instanceof CompoundFilter);
    CompoundFilter cf = (CompoundFilter) subFilter;
    assertEquals(CompoundFilter.LogicalOperator.OR, cf.getOperator());
    subFilters = cf.getSubFilters();
    assertEquals(2, subFilters.size());

View Full Code Here

            "c9 < c10 AND c11 < c12 OR c13 < c14 AND c15 < c16");
        // interpretation: (!(c1 < c2)) or
        //                 ((not (c3 < c4)) and (not (c5 < c6))) or
        //                 ((c7 < c8) and (c9 < c10) and (c11 < c12)) or
        //                 ((c13 < c14) and (c15 < c16))
    QueryFilter filter = query.getFilter();
    assertTrue(filter instanceof CompoundFilter);
    CompoundFilter f = (CompoundFilter) filter;
    assertEquals(CompoundFilter.LogicalOperator.OR, f.getOperator());
    List<QueryFilter> subFilters = f.getSubFilters();
    assertEquals(4, subFilters.size());
    QueryFilter f1 = subFilters.get(0);
    QueryFilter f2 = subFilters.get(1);
    QueryFilter f3 = subFilters.get(2);
    QueryFilter f4 = subFilters.get(3);


    // f1: (!(c1 < c2))
    assertTrue(f1 instanceof NegationFilter);
    NegationFilter nf = (NegationFilter) f1;
    QueryFilter subFilter = nf.getSubFilter();
    assertTrue(subFilter instanceof ColumnColumnFilter);
    assertEquals(Sets.newHashSet("c1", "c2"), subFilter.getAllColumnIds());


    // f2: ((!(c3<c4)) && (!(c5<c6)))))
    assertTrue(f2 instanceof CompoundFilter);
    CompoundFilter cf = (CompoundFilter) f2;
    assertEquals(CompoundFilter.LogicalOperator.AND, cf.getOperator());
    subFilters = cf.getSubFilters();
    assertEquals(2, subFilters.size());
    assertTrue(subFilters.get(0) instanceof NegationFilter);
    assertTrue(subFilters.get(1) instanceof NegationFilter);
    QueryFilter tmp = ((NegationFilter) subFilters.get(0)).getSubFilter();
    assertTrue(tmp instanceof ColumnColumnFilter);
    assertEquals(Sets.newHashSet("c3", "c4"), tmp.getAllColumnIds());
    tmp = ((NegationFilter) subFilters.get(1)).getSubFilter();
    assertTrue(tmp instanceof ColumnColumnFilter);
    assertEquals(Sets.newHashSet("c5", "c6"), tmp.getAllColumnIds());


    //f3: ((c7 < c8) && (c9 < c10) && (c11 < c12))
    assertTrue(f3 instanceof CompoundFilter);
    cf = (CompoundFilter) f3;
    assertEquals(CompoundFilter.LogicalOperator.AND, cf.getOperator());

View Full Code Here

0 1 2 3

TOP

Related Classes of com.google.visualization.datasource.query.QueryFilter

com.google.visualization.datasource.query.engine.QueryEngine

com.google.visualization.datasource.query.engine.QueryEngineTest

com.google.visualization.datasource.query.parser.QueryBuilderTest

com.google.visualization.datasource.query.parser.QueryParser

com.google.visualization.datasource.QuerySplitterTest

com.google.visualization.datasource.util.SqlDataSourceHelper

com.google.visualization.datasource.util.SqlDataSourceHelperTest

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.