Examples of com.google.visualization.datasource.query.QuerySort.addSort()

Package com.google.visualization.datasource.query

Class com.google.visualization.datasource.query.QuerySort

Examples of com.google.visualization.datasource.query.QuerySort.addSort()

com.google.visualization.datasource.query.QuerySort.addSort()
Adds a column sort condition. Validates that the column ID is not already specified in the sort. @param columnSort The column sort condition.

    Query query = new Query();
    QuerySort querySort = new QuerySort();
    AggregationColumn column1 =
        new AggregationColumn(new SimpleColumn("ID"), AggregationType.COUNT);
    SimpleColumn column2 = new SimpleColumn("FNAME");
    querySort.addSort(column1, SortOrder.DESCENDING);
    querySort.addSort(column2, SortOrder.ASCENDING);
    query.setSort(querySort);
    StrBuilder queryStringBuilder = new StrBuilder();
    SqlDataSourceHelper.appendOrderByClause(query, queryStringBuilder);
    assertEquals(queryStringBuilder.toString(),

View Full Code Here

    QuerySort querySort = new QuerySort();
    AggregationColumn column1 =
        new AggregationColumn(new SimpleColumn("ID"), AggregationType.COUNT);
    SimpleColumn column2 = new SimpleColumn("FNAME");
    querySort.addSort(column1, SortOrder.DESCENDING);
    querySort.addSort(column2, SortOrder.ASCENDING);
    query.setSort(querySort);
    StrBuilder queryStringBuilder = new StrBuilder();
    SqlDataSourceHelper.appendOrderByClause(query, queryStringBuilder);
    assertEquals(queryStringBuilder.toString(),
        "ORDER BY count(`ID`) DESC, `FNAME` ",

View Full Code Here

   * Test sorting by a number column.
   */
  public void testSortByNumberAscending() throws Exception {
    Query q = new Query();
    QuerySort sort = new QuerySort();
    sort.addSort(new ColumnSort(new SimpleColumn("weight"),
        SortOrder.ASCENDING));
    q.setSort(sort);
    DataTable res = QueryEngine.executeQuery(q, input, ULocale.US);


    assertEquals(3, res.getRows().size());

View Full Code Here

   * Test sorting by a number column.
   */
  public void testSortByNumberDescending() throws Exception {
    Query q = new Query();
    QuerySort sort = new QuerySort();
    sort.addSort(new ColumnSort(new SimpleColumn("weight"),
        SortOrder.DESCENDING));
    q.setSort(sort);
    DataTable res = QueryEngine.executeQuery(q, input, ULocale.US);


    assertEquals(3, res.getRows().size());

View Full Code Here

   * Test sorting by a text column.
   */
  public void testSortByTextAscending() throws Exception {
    Query q = new Query();
    QuerySort sort = new QuerySort();
    sort.addSort(new ColumnSort(new SimpleColumn("name"), SortOrder.ASCENDING));
    q.setSort(sort);
    DataTable res = QueryEngine.executeQuery(q, input, ULocale.US);


    assertEquals(3, res.getRows().size());
    assertEquals("aaa", res.getRows().get(0).getCells().get(0).toString());

View Full Code Here

   * Test sorting by a text column.
   */
  public void testSortByTextDescnding() throws Exception {
    Query q = new Query();
    QuerySort sort = new QuerySort();
    sort.addSort(new ColumnSort(new SimpleColumn("name"),
        SortOrder.DESCENDING));
    q.setSort(sort);
    DataTable res = QueryEngine.executeQuery(q, input, ULocale.US);


    assertEquals(3, res.getRows().size());

View Full Code Here

   * Test sorting by a text column, while this is the only selected column.
   */
  public void testSelectionAndSortByTextDescending() throws Exception {
    Query q = new Query();
    QuerySort sort = new QuerySort();
    sort.addSort(new ColumnSort(new SimpleColumn("name"),
        SortOrder.DESCENDING));
    q.setSort(sort);


    QuerySelection selection = new QuerySelection();
    selection.addColumn(new SimpleColumn("name"));

View Full Code Here

    selection.addColumn(new SimpleColumn("age"));
    q.setSelection(selection);


    // Add sort.
    QuerySort sort = new QuerySort();
    sort.addSort(new ScalarFunctionColumn(
        Lists.newArrayList((AbstractColumn) new SimpleColumn("hireDate")),
        TimeComponentExtractor.getInstance(
            TimeComponentExtractor.TimeComponent.DAY)), SortOrder.ASCENDING);
    q.setSort(sort);

View Full Code Here

    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

  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:
        ;

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.