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

    selection.addColumn(new AggregationColumn(new SimpleColumn("Sales"),
        AggregationType.MIN));
    selection.addColumn(new AggregationColumn(new SimpleColumn("Fans"),
        AggregationType.AVG));
    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

        Lists.newArrayList((AbstractColumn) new SimpleColumn("lunchTime")),
        TimeComponentExtractor.getInstance(
            TimeComponentExtractor.TimeComponent.HOUR)));
    q.setGroup(group);


    q.validate();


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


    // Test column description
    List<ColumnDescription> cols =

View Full Code Here

            new SimpleColumn("seniorityStartTime"),
            new SimpleColumn("hireDate")), DateDiff.getInstance()));
    group.addColumn(new SimpleColumn("dept"));
    q.setGroup(group);


    q.validate();


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


    // Test column description
    cols = result.getColumnDescriptions();

View Full Code Here

        Lists.newArrayList((AbstractColumn) new SimpleColumn("lunchTime")),
        TimeComponentExtractor.getInstance(
            TimeComponentExtractor.TimeComponent.HOUR)));
    q.setPivot(pivot);


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


    assertEquals(4, cols.size());

View Full Code Here

        Lists.<AbstractColumn>newArrayList(
            new SimpleColumn("seniorityStartTime"),
            new SimpleColumn("hireDate")), DateDiff.getInstance()));
    q1.setPivot(pivot1);


    q1.validate();


    DataTable result1 = QueryEngine.executeQuery(q1, res.clone(), ULocale.US);


    // Test column description
    List<ColumnDescription> cols1 = result1.getColumnDescriptions();

View Full Code Here

    // Add pivot.
    QueryPivot pivot = new QueryPivot();
    pivot.addColumn(new SimpleColumn("isSenior"));
    q.setPivot(pivot);


    q.validate();


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


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

View Full Code Here

    // Add pivot.
    pivot = new QueryPivot();
    pivot.addColumn(new SimpleColumn("isSenior"));
    q.setPivot(pivot);


    q.validate();


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


    // Test column description
    cols = result.getColumnDescriptions();

View Full Code Here

        Lists.newArrayList((AbstractColumn) new SimpleColumn("lunchTime")),
        TimeComponentExtractor.getInstance(
            TimeComponentExtractor.TimeComponent.HOUR)));
    q.setPivot(pivot);


    q.validate();


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


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

View Full Code Here

        Lists.<AbstractColumn>newArrayList(
            new SimpleColumn("seniorityStartTime"),
            new SimpleColumn("hireDate")), DateDiff.getInstance()));
    q.setPivot(pivot);


    q.validate();


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


    // Test column description
    cols = result.getColumnDescriptions();

View Full Code Here

        (AbstractColumn) new SimpleColumn("lunchTime")),
        TimeComponentExtractor.getInstance(
            TimeComponentExtractor.TimeComponent.HOUR)));
    q.setPivot(pivot);


    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.