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

Package com.google.visualization.datasource.query

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

com.google.visualization.datasource.query.Query
google.com/apis/visualization/documentation/querylanguage.html"> query language reference . A Query can be executed by the query engine (see: {@link com.google.visualization.datasource.DataSourceHelper#applyQuery}). It can be split in 2 Query objects based on the Capabilities value (see: {@link com.google.visualization.datasource.DataSourceHelper#splitQuery}). Note on errors: Since this class handles a user generated query, all errors (of type INVALID_QUERY) should provide a descriptive error message for both the user. @author Itai R. @author Yonatan B.Y.

    assertEquals("baba", v.toString());
    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

    assertEquals(true, v.getValue());
    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(ComparisonFilter.Operator.GE, f.getOperator());
    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(ComparisonFilter.Operator.LT, f.getOperator());
    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(ComparisonFilter.Operator.GT, f.getOperator());
    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(ComparisonFilter.Operator.NE, f.getOperator());
    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;

View Full Code Here

    assertEquals("c2", ccf.getSecondColumn().getId());
    assertEquals(ComparisonFilter.Operator.LT, ccf.getOperator());
  }


  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());

View Full Code Here

    Set<String> allColumnIds = f.getAllColumnIds();
    assertEquals(Sets.newHashSet("c1", "c2", "c 3", "WHERE"), allColumnIds);
  }


  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

    assertEquals(new NumberValue(2), filters[4].getValue());


  }


  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());

View Full Code Here

    Set<String> allColumnIds = f.getAllColumnIds();
    assertEquals(Sets.newHashSet("c1", "c2", "c 3", "WHERE"), allColumnIds);
  }


  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());

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

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

com.google.feedserver.samples.wrappers.gviz.GVizWrapper

com.google.visualization.datasource.DataSourceHelper

com.google.visualization.datasource.DataSourceHelperTest

com.google.visualization.datasource.DataSourceRequest

com.google.visualization.datasource.DataSourceServiceTest

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

com.google.visualization.datasource.query.parser.QueryBuilder

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

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

com.google.visualization.datasource.QuerySplitter

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.