Package com.google.visualization.datasource.query

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

76
77
78
79
80
81
82
83
84
85
86
87
88
  public void tearDown() throws Exception {
    super.tearDown();
  }

  public void testSelect() throws Exception {
    Query query = QueryBuilder.getInstance().parseQuery("SeLeCt  c1,c2  , c3 ");

    assertEquals(null, query.getSort());
    QuerySelection selection = query.getSelection();
    assertEquals(Lists.newArrayList(new SimpleColumn("c1"),
        new SimpleColumn("c2"), new SimpleColumn("c3")),
        selection.getColumns());
  }
View Full Code Here
86
87
88
89
90
91
92
93
        new SimpleColumn("c2"), new SimpleColumn("c3")),
        selection.getColumns());
  }

  public void testSelectAll() throws Exception {
    Query query = QueryBuilder.getInstance().parseQuery("Select *");
    assertTrue(query.isEmpty());
  }
View Full Code Here
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
    assertTrue(query.isEmpty());
  }

  public void testUnicodeInput() throws Exception {
    // Select aleph, bet, gimmel. (Hebrew).
    Query query = QueryBuilder.getInstance().parseQuery("SELECT `\u05d0`,`\u05d1`,`\u05d2` ");

    assertEquals(null, query.getSort());
    QuerySelection selection = query.getSelection();
    assertEquals(Lists.newArrayList(new SimpleColumn("\u05d0"),
        new SimpleColumn("\u05d1"), new SimpleColumn("\u05d2")),
        selection.getColumns());

    query = QueryBuilder.getInstance().parseQuery("SELECT * WHERE c='\u311e'");
    QueryFilter filter = query.getFilter();
    assertTrue(filter instanceof ColumnValueFilter);
    ColumnValueFilter cvf = (ColumnValueFilter) filter;
    assertEquals("c", cvf.getColumn().getId());
    Value v = cvf.getValue();
    assertEquals(ValueType.TEXT, v.getType());
View Full Code Here
111
112
113
114
115
116
117
118
119
120
121
122
123
124
    assertEquals(ValueType.TEXT, v.getType());
    assertEquals("\u311e", ((TextValue) cvf.getValue()).getValue());
  }

  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());
View Full Code Here
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
    assertEquals(SortOrder.DESCENDING, columnSorts.get(1).getOrder());
    assertEquals(SortOrder.ASCENDING, columnSorts.get(2).getOrder());
  }

  public void testSelectAndOrderBy() throws Exception {
    Query query = QueryBuilder.getInstance().parseQuery(
        "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
140
141
142
143
144
145
146
147
148
149
150
151
    assertEquals(new SimpleColumn("c4"), columnSorts.get(0).getColumn());
    assertEquals(SortOrder.DESCENDING, columnSorts.get(0).getOrder());
  }

  public void testOptions() throws Exception {
    Query query = QueryBuilder.getInstance().parseQuery(
        "  OpTiOnS   nO_ValUes   ");

    QueryOptions options = query.getOptions();
    assertTrue(options.isNoValues());
    assertFalse(options.isNoFormat());
  }
View Full Code Here
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
    assertTrue(options.isNoValues());
    assertFalse(options.isNoFormat());
  }

  public void testGroupingAndPivoting() throws Exception {
    Query query = QueryBuilder.getInstance().parseQuery(
        " SELECT a, min(c1), b, avg(c2) group by a,b pivot  c,d");
    QuerySelection selection = query.getSelection();
    QueryGroup group = query.getGroup();
    QueryPivot pivot = query.getPivot();
    assertEquals(Lists.newArrayList(new SimpleColumn("a"),
        new AggregationColumn(new SimpleColumn("c1"), AggregationType.MIN),
        new SimpleColumn("b"),
        new AggregationColumn(new SimpleColumn("c2"), AggregationType.AVG)),
        selection.getColumns());
View Full Code Here
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
    assertEquals(Lists.newArrayList("a", "b"), group.getColumnIds());
    assertEquals(Lists.newArrayList("c", "d"), pivot.getColumnIds());
  }

  public void testStrangeAggregations() throws Exception {
    Query query = QueryBuilder.getInstance().parseQuery(
        " SELECT `a, b`, avg, min(min), max(max) group by `a, b`, avg "
            + " pivot count");
    QuerySelection selection = query.getSelection();
    QueryGroup group = query.getGroup();
    QueryPivot pivot = query.getPivot();
    assertEquals(Lists.newArrayList(new SimpleColumn("a, b"),
        new SimpleColumn("avg"),
        new AggregationColumn(new SimpleColumn("min"), AggregationType.MIN),
        new AggregationColumn(new SimpleColumn("max"), AggregationType.MAX)),
        selection.getColumns());
View Full Code Here
180
181
182
183
184
185
186
187
188
    assertEquals(Lists.newArrayList("a, b", "avg"), group.getColumnIds());
    assertEquals(Lists.newArrayList("count"), pivot.getColumnIds());
  }

  public void testEmptyQuery() throws Exception {
    Query query = QueryBuilder.getInstance().parseQuery("  ");
    assertEquals(null, query.getSelection());
    assertEquals(null, query.getSort());
  }
View Full Code Here
186
187
188
189
190
191
192
193
194
    assertEquals(null, query.getSelection());
    assertEquals(null, query.getSort());
  }

  public void testNullQuery() throws Exception {
    Query query = QueryBuilder.getInstance().parseQuery(null);
    assertEquals(null, query.getSelection());
    assertEquals(null, query.getSort());
  }
View Full Code Here
TOP

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

  • com.google.feedserver.samples.wrappers.gviz.GVizWrapper
  • com.google.visualization.datasource.DataSourceHelper
  • com.google.visualization.datasource.DataSourceHelperTest
  • com.google.visualization.datasource.DataSourceRequest
  • com.google.visualization.datasource.DataSourceServiceTest
  • com.google.visualization.datasource.query.engine.QueryEngineTest
  • com.google.visualization.datasource.query.parser.QueryBuilder
  • com.google.visualization.datasource.query.parser.QueryBuilderTest
  • com.google.visualization.datasource.query.parser.QueryParser
  • com.google.visualization.datasource.QuerySplitter
    • 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.