Package com.google.visualization.datasource.datatable.value

Examples of com.google.visualization.datasource.datatable.value.NumberValue

67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
        TableRow row;

        row = new TableRow();
        row.addCell(new TableCell(new TextValue("aaa")));
        row.addCell(new TableCell(new NumberValue(222)));
        row.addCell(new TableCell(BooleanValue.TRUE, "T"));
        input.addRow(row);

        row = new TableRow();
        row.addCell(new TableCell(new TextValue("ccc")));
        row.addCell(new TableCell(new NumberValue(111)));
        row.addCell(new TableCell(BooleanValue.TRUE, "T"));
        input.addRow(row);

        row = new TableRow();
        row.addCell(new TableCell(new TextValue("bbb")));
        row.addCell(new TableCell(new NumberValue(333)));
        row.addCell(new TableCell(BooleanValue.FALSE, "F"));
        input.addRow(row);
    }
View Full Code Here
1296
1297
1298
1299
1300
1301
1302
1303
1304
1305
1306
        selection.addColumn(col1);
        selection.addColumn(col2);
        q.setSelection(selection);

        // Add Filter
        QueryFilter filter = new ColumnValueFilter(col3, new NumberValue(-5),
                ComparisonFilter.Operator.GT);
        q.setFilter(filter);

        q.validate();
View Full Code Here
1327
1328
1329
1330
1331
1332
1333
1334
1335
1336
1337
        // selection with modulo ('weight' is a column id): "select weight, weight % 10"
        Query q = new Query();

        AbstractColumn col1 = new ScalarFunctionColumn(
                Lists.<AbstractColumn>newArrayList(), new Constant(new NumberValue(10)));
        AbstractColumn col2 = new ScalarFunctionColumn(
                Lists.<AbstractColumn>newArrayList(new SimpleColumn("weight"), col1),
                Modulo.getInstance());

        // Add selection
View Full Code Here
1382
1383
1384
1385
1386
1387
1388
1389
1390
1391
1392
1393
1394
1395
1396
1397
1398
        selection.addColumn(new SimpleColumn("name"));
        selection.addColumn(new SimpleColumn("weight"));
        q.setSelection(selection);

        AbstractColumn col1 = new ScalarFunctionColumn(
                Lists.<AbstractColumn>newArrayList(), new Constant(new NumberValue(2)));
        AbstractColumn col2 = new ScalarFunctionColumn(
                Lists.<AbstractColumn>newArrayList(new SimpleColumn("weight"), col1),
                Modulo.getInstance());

        QueryFilter filter = new ColumnValueFilter(col2,
                new NumberValue(0), ComparisonFilter.Operator.EQ);
        q.setFilter(filter);

        q.validate();

        DataTable result = QueryEngine.executeQuery(q, res, ULocale.US);
View Full Code Here
1444
1445
1446
1447
1448
1449
1450
1451
1452
1453
1454
        Query query = new Query();
        QuerySelection selection = new QuerySelection(); // SELECT (sum(sales) / 7)
        List<AbstractColumn> columns = Lists.newArrayList();
        columns.add(new AggregationColumn(new SimpleColumn("Sales"), AggregationType.SUM));
        columns.add(new ScalarFunctionColumn(Lists.<AbstractColumn>newArrayList(),
                new Constant(new NumberValue(7))));
        AbstractColumn selectedColumn = new ScalarFunctionColumn(columns, Quotient.getInstance());
        selection.addColumn(selectedColumn);

        query.setSelection(selection);
        QueryGroup group = new QueryGroup();
View Full Code Here
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
        columnDescriptions.add(new ColumnDescription("i2", ValueType.TEXT, null));
        columnDescriptions.add(new ColumnDescription("i3", ValueType.DATE, null));
        dataTable = CsvDataSourceHelper.read(reader, columnDescriptions, false);
        assertEquals(3, dataTable.getNumberOfRows());
        assertEquals(3, dataTable.getNumberOfColumns());
        assertEquals(new NumberValue(1), dataTable.getRow(0).getCell(0).getValue());
        assertEquals(new TextValue("a"), dataTable.getRow(0).getCell(1).getValue());
        assertEquals(DateValue.getNullValue(), dataTable.getRow(0).getCell(2).getValue());
        assertEquals(new NumberValue(4), dataTable.getRow(1).getCell(0).getValue());
        assertEquals(new TextValue("x13a"), dataTable.getRow(1).getCell(1).getValue());
        assertEquals(DateValue.getNullValue(), dataTable.getRow(1).getCell(2).getValue());
        assertEquals(new NumberValue(1400), dataTable.getRow(2).getCell(0).getValue());
        assertEquals(new TextValue("4"), dataTable.getRow(2).getCell(1).getValue());
        assertEquals(DateValue.getNullValue(), dataTable.getRow(2).getCell(2).getValue());

        // Working example with a table description filled only with types.
        reader = new StringReader("1,a,2004-03-01\n4,x13a,2005-04-02\n1400,4,2006-05-03");
        columnDescriptions = Lists.newArrayList();
        columnDescriptions.add(new ColumnDescription("i1", ValueType.NUMBER, null));
        columnDescriptions.add(new ColumnDescription("i2", ValueType.TEXT, null));
        columnDescriptions.add(new ColumnDescription("i3", ValueType.DATE, null));
        dataTable = CsvDataSourceHelper.read(reader, columnDescriptions, false);
        assertEquals(3, dataTable.getNumberOfRows());
        assertEquals(3, dataTable.getNumberOfColumns());
        assertEquals(new NumberValue(1), dataTable.getRow(0).getCell(0).getValue());
        assertEquals(new TextValue("a"), dataTable.getRow(0).getCell(1).getValue());
        assertEquals(new DateValue(2004, 2, 1), dataTable.getRow(0).getCell(2).getValue());
        assertEquals(new NumberValue(4), dataTable.getRow(1).getCell(0).getValue());
        assertEquals(new TextValue("x13a"), dataTable.getRow(1).getCell(1).getValue());
        assertEquals(new DateValue(2005, 3, 2), dataTable.getRow(1).getCell(2).getValue());
        assertEquals(new NumberValue(1400), dataTable.getRow(2).getCell(0).getValue());
        assertEquals(new TextValue("4"), dataTable.getRow(2).getCell(1).getValue());
        assertEquals(new DateValue(2006, 4, 3), dataTable.getRow(2).getCell(2).getValue());
        assertEquals("i1", dataTable.getColumnDescription(0).getId());
        assertEquals("Column0", dataTable.getColumnDescription(0).getLabel());
        assertEquals("i2", dataTable.getColumnDescription(1).getId());
        assertEquals("Column1", dataTable.getColumnDescription(1).getLabel());
        assertEquals("i3", dataTable.getColumnDescription(2).getId());
        assertEquals("Column2", dataTable.getColumnDescription(2).getLabel());

        // Working example with header rows.
        reader = new StringReader("1,a,2004-03-01\n4,x13a,2005-04-02\n1400,4,2006-05-03");
        columnDescriptions = Lists.newArrayList();
        columnDescriptions.add(new ColumnDescription("i1", ValueType.NUMBER, null));
        columnDescriptions.add(new ColumnDescription("i2", ValueType.TEXT, null));
        columnDescriptions.add(new ColumnDescription("i3", ValueType.DATE, null));
        dataTable = CsvDataSourceHelper.read(reader, columnDescriptions, true);
        assertEquals(2, dataTable.getNumberOfRows());
        assertEquals(3, dataTable.getNumberOfColumns());
        assertEquals(new NumberValue(4), dataTable.getRow(0).getCell(0).getValue());
        assertEquals(new TextValue("x13a"), dataTable.getRow(0).getCell(1).getValue());
        assertEquals(new DateValue(2005, 3, 2), dataTable.getRow(0).getCell(2).getValue());
        assertEquals(new NumberValue(1400), dataTable.getRow(1).getCell(0).getValue());
        assertEquals(new TextValue("4"), dataTable.getRow(1).getCell(1).getValue());
        assertEquals(new DateValue(2006, 4, 3), dataTable.getRow(1).getCell(2).getValue());
        assertEquals("i1", dataTable.getColumnDescription(0).getId());
        assertEquals("1", dataTable.getColumnDescription(0).getLabel());
        assertEquals("i2", dataTable.getColumnDescription(1).getId());
View Full Code Here
219
220
221
222
223
224
225
226
227
228
229
230
231
232
        columnDescriptions.add(columnDescription);

        DataTable dataTable = CsvDataSourceHelper.read(reader, columnDescriptions, true);
        assertEquals(2, dataTable.getNumberOfRows());
        assertEquals(3, dataTable.getNumberOfColumns());
        assertEquals(new NumberValue(4), dataTable.getRow(0).getCell(0).getValue());
        assertEquals(new TextValue("x13a"), dataTable.getRow(0).getCell(1).getValue());
        assertEquals(new DateValue(2005, 3, 2), dataTable.getRow(0).getCell(2).getValue());
        assertEquals(new NumberValue(1400), dataTable.getRow(1).getCell(0).getValue());
        assertEquals(new TextValue("4"), dataTable.getRow(1).getCell(1).getValue());
        assertEquals(new DateValue(2006, 4, 3), dataTable.getRow(1).getCell(2).getValue());
        assertEquals("i1", dataTable.getColumnDescription(0).getId());
        assertEquals("1", dataTable.getColumnDescription(0).getLabel());
        assertEquals("i2", dataTable.getColumnDescription(1).getId());
View Full Code Here
244
245
246
247
248
249
250
251
252
253
254
255
256
        columnDescriptions.add(new ColumnDescription("i3", ValueType.NUMBER, null));

        DataTable dataTable = CsvDataSourceHelper.read(reader, columnDescriptions, true);
        assertEquals(1, dataTable.getNumberOfRows());
        assertEquals(3, dataTable.getNumberOfColumns());
        assertEquals(new NumberValue(4), dataTable.getRow(0).getCell(0).getValue());
        assertEquals(new NumberValue(5), dataTable.getRow(0).getCell(1).getValue());
        assertEquals(new NumberValue(6), dataTable.getRow(0).getCell(2).getValue());
        assertEquals("i1", dataTable.getColumnDescription(0).getId());
        assertEquals("1", dataTable.getColumnDescription(0).getLabel());
        assertEquals("i2", dataTable.getColumnDescription(1).getId());
        assertEquals("2", dataTable.getColumnDescription(1).getLabel());
        assertEquals("i3", dataTable.getColumnDescription(2).getId());
View Full Code Here
75
76
77
78
79
80
81
        if(values.get(0).isNull() || values.get(1).isNull()) {
            return NumberValue.getNullValue();
        }
        double sum = ((NumberValue) values.get(0)).getValue() +
                ((NumberValue) values.get(1)).getValue();
        return new NumberValue(sum);
    }
View Full Code Here
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
        columnDescriptions.add(new ColumnDescription("i4", ValueType.NUMBER, null));

        DataTable dataTable = CsvDataSourceHelper.read(reader, columnDescriptions, true);
        assertEquals(2, dataTable.getNumberOfRows());
        assertEquals(4, dataTable.getNumberOfColumns());
        assertEquals(new NumberValue(4), dataTable.getRow(0).getCell(0).getValue());
        assertEquals(new NumberValue(5), dataTable.getRow(0).getCell(1).getValue());
        assertEquals(new NumberValue(6), dataTable.getRow(0).getCell(2).getValue());
        assertEquals(NumberValue.getNullValue(), dataTable.getRow(0).getCell(3).getValue());
        assertEquals(new NumberValue(7), dataTable.getRow(1).getCell(0).getValue());
        assertEquals(NumberValue.getNullValue(), dataTable.getRow(1).getCell(1).getValue());
        assertEquals(NumberValue.getNullValue(), dataTable.getRow(1).getCell(2).getValue());
        assertEquals(new NumberValue(10), dataTable.getRow(1).getCell(3).getValue());
        assertEquals("i1", dataTable.getColumnDescription(0).getId());
        assertEquals("1", dataTable.getColumnDescription(0).getLabel());
        assertEquals("i2", dataTable.getColumnDescription(1).getId());
        assertEquals("", dataTable.getColumnDescription(1).getLabel());
        assertEquals("i3", dataTable.getColumnDescription(2).getId());
View Full Code Here
TOP

Related Classes of com.google.visualization.datasource.datatable.value.NumberValue

  • com.google.feedserver.samples.wrappers.gviz.GVizTypeConverter
  • com.google.visualization.datasource.DataSourceHelperTest
  • com.google.visualization.datasource.DataSourceServiceTest
  • com.google.visualization.datasource.datatable.DataTableTest
  • com.google.visualization.datasource.datatable.TableCell
  • com.google.visualization.datasource.datatable.TableCellTest
  • com.google.visualization.datasource.datatable.ValueFormatter
  • com.google.visualization.datasource.datatable.ValueFormatterTest
  • com.google.visualization.datasource.query.ColumnValueFilterTest
  • com.google.visualization.datasource.query.ComparisonFilterTest
    • 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.