Package com.google.visualization.datasource.datatable

Examples of com.google.visualization.datasource.datatable.DataTable

42
43
44
45
46
47
48
49
50
51
52
53
54
55
    TableRow falseRow = new TableRow();
    falseRow.addCell(new TableCell("a"));
    falseRow.addCell(new TableCell(123));
    falseRow.addCell(new TableCell("b"));

    DataTable table = new DataTable();
    table.addColumn(new ColumnDescription("c1", ValueType.TEXT, "c1"));
    table.addColumn(new ColumnDescription("c2", ValueType.TEXT, "c2"));
    table.addColumn(new ColumnDescription("c3", ValueType.TEXT, "c3"));

    ColumnColumnFilter filter1 = new ColumnColumnFilter(new SimpleColumn("c1"),
        new SimpleColumn("c3"), ComparisonFilter.Operator.EQ);
    ColumnValueFilter filter2 = new ColumnValueFilter(new SimpleColumn("c2"),
        new NumberValue(100), ComparisonFilter.Operator.GT);
View Full Code Here
70
71
72
73
74
75
76
77
78
79
80
81
82
83
    TableRow trueRow = new TableRow();
    trueRow.addCell(new TableCell("a"));
    trueRow.addCell(new TableCell(123));
    trueRow.addCell(new TableCell("b"));

    DataTable table = new DataTable();
    table.addColumn(new ColumnDescription("c1", ValueType.TEXT, "c1"));
    table.addColumn(new ColumnDescription("c2", ValueType.TEXT, "c2"));
    table.addColumn(new ColumnDescription("c3", ValueType.TEXT, "c3"));

    ColumnColumnFilter filter1 = new ColumnColumnFilter(new SimpleColumn("c1"),
        new SimpleColumn("c3"), ComparisonFilter.Operator.NE);
    ColumnValueFilter filter2 = new ColumnValueFilter(new SimpleColumn("c2"),
        new NumberValue(1000), ComparisonFilter.Operator.GT);
View Full Code Here
76
77
78
79
80
81
82
83
84
85
86
  @Override
  public void setUp() throws Exception {
    super.setUp();

    input = new DataTable();
    input.addColumn(new ColumnDescription("name", ValueType.TEXT, "label0"));
    input.addColumn(new ColumnDescription("weight", ValueType.NUMBER, "label1"));
    input.addColumn(new ColumnDescription("isPig", ValueType.BOOLEAN, "label2"));

    TableRow row;
View Full Code Here
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
  /**
   * Test an empty query, no modification from input to output,
   */
  public void testEmptyQuery() throws Exception {
    Query q = new Query();
    DataTable res = QueryEngine.executeQuery(q, input, ULocale.US);
    List<ColumnDescription> cols = res.getColumnDescriptions();
    assertEquals(3, cols.size());
    assertEquals("name", cols.get(0).getId());
    assertEquals("weight", cols.get(1).getId());
    assertEquals("isPig", cols.get(2).getId());
    assertEquals(ValueType.TEXT, cols.get(0).getType());
    assertEquals(ValueType.NUMBER, cols.get(1).getType());
    assertEquals(ValueType.BOOLEAN, cols.get(2).getType());
    assertEquals("label0", cols.get(0).getLabel());
    assertEquals("label1", cols.get(1).getLabel());
    assertEquals("label2", cols.get(2).getLabel());

    assertEquals(3, res.getRows().size());
  }
View Full Code Here
137
138
139
140
141
142
143
144
145
146
147
148
    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());
    assertEquals("111.0", res.getRows().get(0).getCells().get(1).toString());
    assertEquals("222.0", res.getRows().get(1).getCells().get(1).toString());
    assertEquals("333.0", res.getRows().get(2).getCells().get(1).toString());
  }
View Full Code Here
154
155
156
157
158
159
160
161
162
163
164
165
    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());
    assertEquals("333.0", res.getRows().get(0).getCells().get(1).toString());
    assertEquals("222.0", res.getRows().get(1).getCells().get(1).toString());
    assertEquals("111.0", res.getRows().get(2).getCells().get(1).toString());
  }
View Full Code Here
170
171
172
173
174
175
176
177
178
179
180
181
  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());
    assertEquals("bbb", res.getRows().get(1).getCells().get(0).toString());
    assertEquals("ccc", res.getRows().get(2).getCells().get(0).toString());
  }
View Full Code Here
187
188
189
190
191
192
193
194
195
196
197
198
    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());
    assertEquals("ccc", res.getRows().get(0).getCells().get(0).toString());
    assertEquals("bbb", res.getRows().get(1).getCells().get(0).toString());
    assertEquals("aaa", res.getRows().get(2).getCells().get(0).toString());
  }
View Full Code Here
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
   */
  public void testSelectWithNoCols() throws Exception {
    Query q = new Query();
    QuerySelection sel = new QuerySelection();
    q.setSelection(sel);
    DataTable res = QueryEngine.executeQuery(q, input, ULocale.US);
    List<ColumnDescription> cols = res.getColumnDescriptions();

    assertEquals(3, cols.size());
    assertEquals("name", cols.get(0).getId());
    assertEquals("weight", cols.get(1).getId());
    assertEquals("isPig", cols.get(2).getId());

    assertEquals(3, res.getRows().size());
    assertEquals(3, res.getRows().get(0).getCells().size());
  }
View Full Code Here
222
223
224
225
226
227
228
229
230
231
232
233
234
235
  public void testSelectionOfFirstCol() throws Exception {
    Query q = new Query();
    QuerySelection sel = new QuerySelection();
    sel.addColumn(new SimpleColumn("name"));
    q.setSelection(sel);
    DataTable res = QueryEngine.executeQuery(q, input, ULocale.US);
    List<ColumnDescription> cols = res.getColumnDescriptions();

    assertEquals(1, cols.size());
    assertEquals("name", cols.get(0).getId());

    assertEquals(3, res.getRows().size());
    assertEquals(1, res.getRows().get(0).getCells().size());
  }
View Full Code Here
TOP

Related Classes of com.google.visualization.datasource.datatable.DataTable

  • AdvancedExampleServlet
  • AdvancedExampleServlet2
  • com.google.feedserver.samples.wrappers.gviz.GVizWrapper
  • com.google.visualization.datasource.DataSourceHelper
  • com.google.visualization.datasource.DataSourceHelperTest
  • com.google.visualization.datasource.DataSourceService
  • com.google.visualization.datasource.DataSourceServiceTest
  • com.google.visualization.datasource.query.ColumnColumnFilterTest
  • com.google.visualization.datasource.query.ColumnValueFilterTest
  • com.google.visualization.datasource.query.CompoundFilterTest
    • 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.