Examples of QuerySort

com.google.visualization.datasource.query.QuerySort
Sorting definition for a query. Sort is defined as a list of column sorts where the first is the primary sort order, the second is the secondary sort order, etc. @author Yoah B.D.

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

    q = new Query();
    QuerySelection selection = new QuerySelection();
    selection.addColumn(new SimpleColumn("A"));
    selection.addColumn(new AggregationColumn(new SimpleColumn("B"), AggregationType.MAX));
    q.setSelection(selection);
    QuerySort sort = new QuerySort();
    sort.addSort(new ColumnSort(new SimpleColumn("A"), SortOrder.DESCENDING));
    q.setSort(sort);
    QueryFilter filter = new ColumnValueFilter(new SimpleColumn("A"), new TextValue("foo"),
                                               ComparisonFilter.Operator.GT);
    q.setFilter(filter);
    q.setRowLimit(7);

View Full Code Here

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

  static void appendOrderByClause(Query query, StrBuilder queryStringBuilder) {
    if (!query.hasSort()) {
      return;
    }
    queryStringBuilder.append("ORDER BY ");
    QuerySort querySort = query.getSort();
    List<ColumnSort> sortColumns = querySort.getSortColumns();
    int numOfSortColumns = sortColumns.size();
    for (int col = 0; col < numOfSortColumns; col++) {
      ColumnSort columnSort = sortColumns.get(col);
      queryStringBuilder.append(getColumnId(columnSort.getColumn()));
      if (columnSort.getOrder() == SortOrder.DESCENDING) {

View Full Code Here

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

   */
  private static DataTable performSort(DataTable table, Query query, ULocale locale) {
    if (!query.hasSort()) {
      return table;
    }
    QuerySort sortBy = query.getSort();
    // A table description column lookup is enough because sorting by a column
    // that has multiple matching columns after pivoting is impossible. For example,
    // it is impossible to sort by an aggregation column when there is a pivot.
    DataTableColumnLookup columnLookup = new DataTableColumnLookup(table);
    TableRowComparator comparator = new TableRowComparator(sortBy, locale, columnLookup);

View Full Code Here

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

  static void appendOrderByClause(Query query, StrBuilder queryStringBuilder) {
    if (!query.hasSort()) {
      return;
    }
    queryStringBuilder.append("ORDER BY ");
    QuerySort querySort = query.getSort();
    List<ColumnSort> sortColumns = querySort.getSortColumns();
    int numOfSortColumns = sortColumns.size();
    for (int col = 0; col < numOfSortColumns; col++) {
      ColumnSort columnSort = sortColumns.get(col);
      queryStringBuilder.append(getColumnId(columnSort.getColumn()));
      if (columnSort.getOrder() == SortOrder.DESCENDING) {

View Full Code Here

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

    query.setPivot(pivot);
  }


// The order by clause (e.g., ORDER BY c1, c2 ASC, c3 DESC)
  final public void orderByClause(Query query) throws ParseException, InvalidQueryException {
  QuerySort sort = new QuerySort();
  AbstractColumn column;
  SortOrder order;
    jj_consume_token(KW_ORDER);
    jj_consume_token(KW_BY);
    column = abstractColumnDescriptor();
    order = sortOrder();
    sort.addSort(column, order);
    label_4:
    while (true) {
      switch ((jj_ntk==-1)?jj_ntk():jj_ntk) {
      case OP_COMMA:
        ;
        break;
      default:
        jj_la1[14] = jj_gen;
        break label_4;
      }
      jj_consume_token(OP_COMMA);
      column = abstractColumnDescriptor();
      order = sortOrder();
      sort.addSort(column, order);
    }
    query.setSort(sort);
  }

View Full Code Here

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

   */
  private static DataTable performSort(DataTable table, Query query, ULocale locale) {
    if (!query.hasSort()) {
      return table;
    }
    QuerySort sortBy = query.getSort();
    // A table description column lookup is enough because sorting by a column
    // that has multiple matching columns after pivoting is impossible. For example,
    // it is impossible to sort by an aggregation column when there is a pivot.
    DataTableColumnLookup columnLookup = new DataTableColumnLookup(table);
    TableRowComparator comparator = new TableRowComparator(sortBy, locale, columnLookup);

View Full Code Here

0 1

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.