Examples of com.google.visualization.datasource.query.Query.validate()

Package com.google.visualization.datasource.query

Class com.google.visualization.datasource.query.Query

Examples of com.google.visualization.datasource.query.Query.validate()

com.google.visualization.datasource.query.Query.validate()
Validates the query. Runs a sanity check on the query, verifies that there are no duplicates, and that the query follows a basic set of rules required for its execution. Specifically, verifies the following: - There are no duplicate columns in the clauses. - No column appears both as a selection and as an aggregation. - When aggregation is used, checks that all selected columns are valid (a column is valid if it is either grouped-by, or is a scalar function column the arguments of which are all valid columns). - No column is both grouped-by, and aggregated in, the select clause. - No column both appears as pivot, and aggregated in, the select clause. - No grouping/pivoting is used when there is no aggregation in the select clause. - If aggregation is used in the select clause, no column is ordered-by that is not in the select clause. - No column appears both as a group-by and a pivot. - If pivoting is used, the order by clause does not contain aggregation columns. - The order-by clause does not contain aggregation columns that were not defined in the select clause. @throws InvalidQueryException

        Lists.newArrayList((AbstractColumn) new SimpleColumn("hireDate")),
        TimeComponentExtractor.getInstance(
            TimeComponentExtractor.TimeComponent.DAY)), SortOrder.ASCENDING);
    q.setSort(sort);


    q.validate();


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


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

View Full Code Here

    AbstractColumn col5 = new ScalarFunctionColumn(
        Lists.<AbstractColumn>newArrayList(col1, col4), Sum.getInstance());
    selection.addColumn(col5);
    selection.addColumn(new SimpleColumn("age"));
    q.setSelection(selection);
    q.validate();


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


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

View Full Code Here

    // Add group
    QueryGroup group = new QueryGroup();
    group.addColumn(col3);
    q.setGroup(group);


    q.validate();


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


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

View Full Code Here

    // Add Filter
    QueryFilter filter = new ColumnValueFilter(col3, new NumberValue(-5),
        ComparisonFilter.Operator.GT);
    q.setFilter(filter);


    q.validate();


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


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

View Full Code Here

    QuerySelection selection = new QuerySelection();
    selection.addColumn(new SimpleColumn("weight"));
    selection.addColumn(col2);
    q.setSelection(selection);
    
    q.validate();


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


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

View Full Code Here


    QueryFilter filter = new ColumnValueFilter(col2,
      new NumberValue(0), ComparisonFilter.Operator.EQ);
    q.setFilter(filter);
  
    q.validate();


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


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

View Full Code Here

    // 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

    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

    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

    selection.addColumn(new AggregationColumn(new SimpleColumn("Songs"),
        AggregationType.AVG));
    selection.addColumn(new AggregationColumn(new SimpleColumn("Sales"),
        AggregationType.SUM));
    q.setSelection(selection);
    q.validate();


    DataTable result = QueryEngine.executeQuery(q, res, ULocale.US);
    // Test column description
    List<ColumnDescription> cols = result.getColumnDescriptions();

View Full Code Here

0 1 2

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.