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("Youthanasia,4.0 foo", columnDescriptions.get(4).getLabel());
  }
  
  // We used to have a bug with this throwing a runtime exception
  public void testAggregationAppearsTwice() throws Exception {
    Query q = QueryBuilder.getInstance().parseQuery("SELECT isAlive, sum(weight), sum(weight)+1"
        + " GROUP BY isAlive");
    DataTable data = MockDataSource.getData(0);
    DataTable res = QueryEngine.executeQuery(q, data, ULocale.US);
    assertEquals(2, res.getNumberOfRows());
    assertEquals("false", res.getRow(0).getCell(0).getValue().toString());

View Full Code Here

    assertEquals("1568.0", res.getRow(1).getCell(2).getValue().toString());
  }
  
  // Tests that the format operation saves the pattern on the column description.
  public void testFormatStoresPattern() throws Exception {
    Query q = QueryBuilder.getInstance().parseQuery("FORMAT weight 'a#'");
    DataTable data = MockDataSource.getData(0);
    DataTable res = QueryEngine.executeQuery(q, data, ULocale.US);
    assertEquals("a#", res.getColumnDescription("weight").getPattern());
  }

View Full Code Here

    DataTable res = QueryEngine.executeQuery(q, data, ULocale.US);
    assertEquals("a#", res.getColumnDescription("weight").getPattern());
  }
  
  public void testQueryDoesntRuinDataSourcePatterns() throws Exception {
    Query q = QueryBuilder.getInstance().parseQuery("SELECT isAlive, weight WHERE height > 20 "
        + "ORDER BY weight LIMIT 3 OFFSET 2");
    DataTable data = MockDataSource.getData(0).clone();
    data.getColumnDescription("weight").setPattern("f#");
    DataTable res = QueryEngine.executeQuery(q, data, ULocale.US);
    assertEquals("f#", res.getColumnDescription("weight").getPattern());

View Full Code Here

    DataTable res = QueryEngine.executeQuery(q, data, ULocale.US);
    assertEquals("f#", res.getColumnDescription("weight").getPattern());
  }


  public void testQueryWithLikeOperator() throws InvalidQueryException {
    Query q = QueryBuilder.getInstance().parseQuery("SELECT Band WHERE Band like 'Co%'");
    DataTable data = MockDataSource.getData(1).clone();
    DataTable res = QueryEngine.executeQuery(q, data, ULocale.US);
    assertEquals(28, res.getNumberOfRows());
    for (int i = 0; i < res.getNumberOfRows(); i++) {
      assertTrue(res.getValue(i, 0).toString().startsWith("Co"));

View Full Code Here

      assertTrue(res.getValue(i, 0).toString().startsWith("Co"));
    }
  }
  
  public void testScalarFunctions() throws InvalidQueryException {
    Query q = QueryBuilder.getInstance().parseQuery("SELECT upper(name),salary format salary '$0'");
    DataTable data = MockDataSource.getData(3);
    DataTable res = QueryEngine.executeQuery(q, data, ULocale.US);
    assertEquals("JOHN", res.getValue(0, 0).toString());
    assertEquals("$1000", res.getCell(0, 1).getFormattedValue());
  }

View Full Code Here

    DataTable res = MockDataSource.getData(1);
    
    // The returned mock data table should consist of 45 rows
    assertEquals(45, res.getNumberOfRows());
    
    Query q = QueryBuilder.getInstance().parseQuery("SELECT Year, Band, Songs SKIPPING 10");
    
    q.validate();


    DataTable result = QueryEngine.executeQuery(q, res, ULocale.US);


    // Test column description
    List<ColumnDescription> cols =  result.getColumnDescriptions();

View Full Code Here

    DataTable res = MockDataSource.getData(1);


    // The returned mock data table should consist of 45 rows
    assertEquals(45, res.getNumberOfRows());
    
    Query q = QueryBuilder.getInstance().parseQuery("SELECT Year, Band, Songs " + 
        "SKIPPING 4 LIMIT 4 OFFSET 4");
    
    q.validate();


    DataTable result = QueryEngine.executeQuery(q, res, ULocale.US);


    // Test column description
    List<ColumnDescription> cols =  result.getColumnDescriptions();

View Full Code Here

    DataTable res = MockDataSource.getData(1);
    
    // The returned mock data table should consist of 45 rows
    assertEquals(45, res.getNumberOfRows());


    Query q = QueryBuilder.getInstance().parseQuery("SELECT Year, Band, Songs " + 
        "WHERE Fans <= 3000 SKIPPING 10");
    
    q.validate();


    DataTable result = QueryEngine.executeQuery(q, res, ULocale.US);


    // Test column description
    List<ColumnDescription> cols =  result.getColumnDescriptions();

View Full Code Here

    assertEquals(7.55, v.getValue());
    assertEquals(ComparisonFilter.Operator.LE, f.getOperator());
  }


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

View Full Code Here

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

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.