Package com.google.visualization.datasource.query

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

62
63
64
65
66
67
68
69
70
71
72
73
    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
240
241
242
243
244
245
246
247
248
249
250
251
  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
224
225
226
227
228
229
230
231
232
233
234
   */
  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
240
241
242
243
244
245
246
247
248
249
250
251
  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
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
    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
187
188
189
190
191
192
193
194
195
196
197
   */
  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
TOP

Related Classes of com.google.visualization.datasource.query.QuerySort

  • com.google.visualization.datasource.query.engine.QueryEngine
  • com.google.visualization.datasource.query.engine.QueryEngineTest
  • com.google.visualization.datasource.query.parser.QueryBuilderTest
  • com.google.visualization.datasource.query.parser.QueryParser
  • com.google.visualization.datasource.QuerySplitterTest
  • com.google.visualization.datasource.util.SqlDataSourceHelper
  • com.google.visualization.datasource.util.SqlDataSourceHelperTest
  • org.apache.commons.lang.text.StrBuilder
  • org.apache.commons.lang3.text.StrBuilder
    • Copyright © 2018 www.massapicom. All rights reserved.
    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.