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("lunchTime")),
        TimeComponentExtractor.getInstance(
            TimeComponentExtractor.TimeComponent.HOUR)));


    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(new SimpleColumn("dept"));
    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 group.
    QueryGroup group1 = new QueryGroup();
    group1.addColumn(new SimpleColumn("lunchTime"));
    q.setGroup(group1);


    q.validate();


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


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

View Full Code Here

    // Add pivot.
    QueryPivot pivot = new QueryPivot();
    pivot.addColumn(new SimpleColumn("dept"));
    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.
    QueryPivot pivot = new QueryPivot();
    pivot.addColumn(new SimpleColumn("dept"));
    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.
    QueryPivot pivot = new QueryPivot();
    pivot.addColumn(new SimpleColumn("dept"));
    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

        log.error("Parsing error: " + messageToUserAndLog);
        throw new InvalidQueryException(MessagesEnum.PARSE_ERROR.getMessageWithArgs(ulocale, 
            messageToUserAndLog));
      }
      query.setLocaleForUserMessages(ulocale);
      query.validate();
    }
    return query;
  }
}

View Full Code Here

                log.error("Parsing error: " + messageToUserAndLog);
                throw new InvalidQueryException(MessagesEnum.PARSE_ERROR.getMessageWithArgs(ulocale,
                        messageToUserAndLog));
            }
            query.setLocaleForUserMessages(ulocale);
            query.validate();
        }
        return query;
    }
}

View Full Code Here

      } catch (ParseException ex) {
        String messageToUserAndLog = ex.getMessage();
        log.error("Parsing error: " + messageToUserAndLog);
        throw new InvalidQueryException("Query error: " + messageToUserAndLog);
      }
      query.validate();
    }
    return query;
  }
}

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.