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

Package com.google.visualization.datasource.query

Examples of com.google.visualization.datasource.query.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.

  /**
   * Tests the building of the SQL query ORDER BY clause from the Gviz query.
   */
  public void testBuildOrderByClause() {
    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(),
        "ORDER BY count(`ID`) DESC, `FNAME` ",

View Full Code Here


  public void testOrderBy() throws Exception {
    Query query = QueryBuilder.getInstance().parseQuery(
        "OrDeR   bY  c1,c2 desc , c3 ASC");
    assertEquals(null, query.getSelection());
    QuerySort sort = query.getSort();
    List<ColumnSort> columnSorts = sort.getSortColumns();
    assertEquals(3, columnSorts.size());
    assertEquals(new SimpleColumn("c1"), columnSorts.get(0).getColumn());
    assertEquals(new SimpleColumn("c2"), columnSorts.get(1).getColumn());
    assertEquals(new SimpleColumn("c3"), columnSorts.get(2).getColumn());
    assertEquals(SortOrder.ASCENDING, columnSorts.get(0).getOrder());

View Full Code Here

        "SELect c1   ,    c2 , c3   ORDER BY c4 DESC");
    QuerySelection selection = query.getSelection();
    assertEquals(Lists.newArrayList(new SimpleColumn("c1"),
        new SimpleColumn("c2"), new SimpleColumn("c3")),
        selection.getColumns());
    QuerySort sort = query.getSort();
    List<ColumnSort> columnSorts = sort.getSortColumns();
    assertEquals(1, columnSorts.size());
    assertEquals(new SimpleColumn("c4"), columnSorts.get(0).getColumn());
    assertEquals(SortOrder.DESCENDING, columnSorts.get(0).getOrder());
  }

View Full Code Here

    }
  }


  public void testOrderByOfArithmeticExpression() throws Exception {
    Query query = QueryBuilder.getInstance().parseQuery("order by ((c1+c2)/c3/c4)");
    QuerySort sort = query.getSort();
    List<ColumnSort> columnSorts = sort.getSortColumns();
    assertEquals(1, columnSorts.size());
    ScalarFunctionColumn col1 = new ScalarFunctionColumn(
        Lists.<AbstractColumn>newArrayList(new SimpleColumn("c1"),
            new SimpleColumn("c2")), Sum.getInstance());
    ScalarFunctionColumn col2 = new ScalarFunctionColumn(

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("hireDate"));
    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

0 1

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

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.