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

Package com.google.visualization.datasource.query

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

com.google.visualization.datasource.query.ColumnSort
A sort definition for a single column. This class is immutable. @author Yoah B.D.

   * 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

    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) {
        queryStringBuilder.append(" DESC");
      }
      if (col < numOfSortColumns - 1) {
        queryStringBuilder.append(", ");
      }

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

    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) {
        queryStringBuilder.append(" DESC");
      }
      if (col < numOfSortColumns - 1) {
        queryStringBuilder.append(", ");
      }

View Full Code Here

        columnLookup = lookup;
        List<ColumnSort> columns = sort.getSortColumns();
        sortColumns = new AbstractColumn[columns.size()];
        sortColumnOrder = new SortOrder[columns.size()];
        for(int i = 0; i < columns.size(); i++) {
            ColumnSort columnSort = columns.get(i);
            sortColumns[i] = columnSort.getColumn();
            sortColumnOrder[i] = columnSort.getOrder();
        }
    }

View Full Code Here

    columnLookup = lookup;
    List<ColumnSort> columns = sort.getSortColumns();
    sortColumns = new AbstractColumn[columns.size()];
    sortColumnOrder = new SortOrder[columns.size()];
    for (int i = 0; i < columns.size(); i++) {
      ColumnSort columnSort = columns.get(i);
      sortColumns[i] = columnSort.getColumn();
      sortColumnOrder[i] = columnSort.getOrder();
    }
  }

View Full Code Here

TOP

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

com.google.visualization.datasource.query.engine.QueryEngineTest

com.google.visualization.datasource.query.engine.TableRowComparator

com.google.visualization.datasource.QuerySplitterTest

com.google.visualization.datasource.util.SqlDataSourceHelper

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.