Examples of QueryFilter


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

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

  public void testColumnValueFilterWithText2() throws Exception {
    Query query = QueryBuilder.getInstance().parseQuery(" WHERE MiN <> \"baba\"");
    QueryFilter filter = query.getFilter();
    assertTrue(filter instanceof ColumnValueFilter);
    ColumnValueFilter f = (ColumnValueFilter) filter;
    assertEquals("MiN", f.getColumn().getId());
    Value val = f.getValue();
    assertTrue(val instanceof TextValue);
View Full Code Here

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

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

  public void testColumnValueFilterWithBoolean1() throws Exception {
    Query query = QueryBuilder.getInstance().parseQuery(" WHERE c1 != trUe");
    QueryFilter filter = query.getFilter();
    assertTrue(filter instanceof ColumnValueFilter);
    ColumnValueFilter f = (ColumnValueFilter) filter;
    assertEquals("c1", f.getColumn().getId());
    Value val = f.getValue();
    assertTrue(val instanceof BooleanValue);
View Full Code Here

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

    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

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

    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

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

    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

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

    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

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

    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

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

  }

  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

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

  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

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

  }

  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
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
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.