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

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

235
236
237
238
239
240
241
242
243
244
245
    row.addCell(new TableCell(NumberValue.getNullValue()));
    row.addCell(new TableCell(true));
    rows.add(row);

    row = new TableRow();
    row.addCell(new TableCell(new TextValue("bbb"), "bbb"));
    row.addCell(new TableCell(333));
    row.addCell(new TableCell(true));
    rows.add(row);

    row = new TableRow();
View Full Code Here
73
74
75
76
77
78
79
80
81
82
83
    row.addCell(new TableCell(111));
    row.addCell(new TableCell(true));
    rows.add(row);

    row = new TableRow();
    row.addCell(new TableCell((new TextValue("bbb")), "bbb"));
    row.addCell(new TableCell(333));
    row.addCell(new TableCell(true));
    rows.add(row);

    row = new TableRow();
View Full Code Here
754
755
756
757
758
759
760
761
762
763
764
      default:
        String colValue = rs.getString(column);
        if (colValue == null) {
          value = TextValue.getNullValue();
        } else {
          value = new TextValue(rs.getString(column));
        }
        break;
    }
    // Handle null values.
    if (rs.wasNull()) {
View Full Code Here
85
86
87
88
89
90
91
92
93
94
95
96
97
98
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
    // Test where.
    result = DataSourceHelper.applyQuery(DataSourceHelper.parseQuery(
        "select name,vegeterian where population > 100"), data, ULocale.US);
    assertEquals(2, result.getNumberOfColumns());
    assertEquals(1, result.getNumberOfRows());
    assertEquals(new TextValue("Sloth"), result.getRow(0).getCell(0).getValue());
    assertEquals(BooleanValue.TRUE, result.getRow(0).getCell(1).getValue());

    data = createData();

    // Test group by.
    result = DataSourceHelper.applyQuery(DataSourceHelper.parseQuery(
        "select vegeterian,sum(population) group by vegeterian"), data, ULocale.US);
    assertEquals(2, result.getNumberOfColumns());
    assertEquals(2, result.getNumberOfRows());
    assertEquals(BooleanValue.FALSE, result.getRow(0).getCell(0).getValue());
    assertEquals(new NumberValue(130), result.getRow(0).getCell(1).getValue());

    data = createData();

    // Test pivot.
    result = DataSourceHelper.applyQuery(DataSourceHelper.parseQuery(
        "select sum(population) pivot vegeterian"), data, ULocale.US);
    assertEquals(2, result.getNumberOfColumns());
    assertEquals(1, result.getNumberOfRows());
    assertEquals("false", result.getColumnDescription(0).getLabel());
    assertEquals(new NumberValue(130), result.getRow(0).getCell(0).getValue());

    data = createData();

    // Test order by.
    result = DataSourceHelper.applyQuery(DataSourceHelper.parseQuery(
        "select name order by population"), data, ULocale.US);
    assertEquals(1, result.getNumberOfColumns());
    assertEquals(4, result.getNumberOfRows());
    assertEquals(new TextValue("Leopard"), result.getRow(0).getCell(0).getValue());
    assertEquals(new TextValue("Tiger"), result.getRow(1).getCell(0).getValue());
    assertEquals(new TextValue("Aye-aye"), result.getRow(2).getCell(0).getValue());
    assertEquals(new TextValue("Sloth"), result.getRow(3).getCell(0).getValue());

    data = createData();

    // Test limit and offset.
    result = DataSourceHelper.applyQuery(DataSourceHelper.parseQuery("limit 1 offset 1"), data,
        ULocale.US);
    assertEquals(4, result.getNumberOfColumns());
    assertEquals(1, result.getNumberOfRows());
    assertEquals(new TextValue("Sloth"), result.getRow(0).getCell(0).getValue());

    data = createData();

    // Test label and format.
    result = DataSourceHelper.applyQuery(DataSourceHelper.parseQuery(
View Full Code Here
52
53
54
55
56
57
58
59
60
61
62
    assertTrue(filter.isMatch(table, row));
    filter = new ColumnValueFilter(new SimpleColumn("c2"),
        new NumberValue(100), ComparisonFilter.Operator.LE);
    assertFalse(filter.isMatch(table, row));
    filter = new ColumnValueFilter(new SimpleColumn("c1"),
        new TextValue("b"), ComparisonFilter.Operator.GT);
    assertFalse(filter.isMatch(table, row));
    filter = new ColumnValueFilter(new SimpleColumn("c1"),
        new TextValue("b"), ComparisonFilter.Operator.LT, true);
    assertFalse(filter.isMatch(table, row));
  }
View Full Code Here
498
499
500
501
502
503
504
505
506
    assertTrue(filter instanceof ColumnValueFilter);
    ColumnValueFilter f = (ColumnValueFilter) filter;
    assertEquals("selEct", f.getColumn().getId());
    Value val = f.getValue();
    assertTrue(val instanceof TextValue);
    TextValue v = (TextValue) val;
    assertEquals("baba", v.toString());
    assertEquals(ComparisonFilter.Operator.EQ, f.getOperator());
  }
View Full Code Here
511
512
513
514
515
516
517
518
519
    assertTrue(filter instanceof ColumnValueFilter);
    ColumnValueFilter f = (ColumnValueFilter) filter;
    assertEquals("MiN", f.getColumn().getId());
    Value val = f.getValue();
    assertTrue(val instanceof TextValue);
    TextValue v = (TextValue) val;
    assertEquals("baba", v.toString());
    assertEquals(ComparisonFilter.Operator.NE, f.getOperator());
  }
View Full Code Here
565
566
567
568
569
570
571
572
573
574
    assertTrue(filter instanceof ColumnValueFilter);
    ColumnValueFilter f = (ColumnValueFilter) filter;
    assertEquals("count", f.getColumn().getId());
    Value val = f.getValue();
    assertTrue(val instanceof TextValue);
    TextValue v = (TextValue) val;
    assertEquals("select", v.toString());
    assertEquals(ComparisonFilter.Operator.GT, f.getOperator());
    assertEquals(true, f.isComparisonOrderReversed());
  }
View Full Code Here
643
644
645
646
647
648
649
650
651
652
653
    assertEquals(ComparisonFilter.Operator.NE, filters[1].getOperator());
    assertEquals(ComparisonFilter.Operator.NE, filters[2].getOperator());
    assertEquals(ComparisonFilter.Operator.NE, filters[3].getOperator());
    assertEquals(ComparisonFilter.Operator.NE, filters[4].getOperator());

    assertEquals(new TextValue("2008-06-01"), filters[0].getValue());
    assertEquals(new NumberValue(47), filters[1].getValue());
    assertEquals(new NumberValue(6), filters[2].getValue());
    assertEquals(new NumberValue(8), filters[3].getValue());
    assertEquals(new NumberValue(2), filters[4].getValue());
View Full Code Here
224
225
226
227
228
229
230
231
232
233
234
      case NUMBER:
        return new NumberValue(Double.parseDouble(content));
      case BOOLEAN:
        return BooleanValue.getInstance(Boolean.parseBoolean(content));
      case TEXT:
        return new TextValue(content);
      case DATETIME:
        String[] mainSplit = content.split(" ");
        String[] dateSplit = mainSplit[0].split("-");
        String[] timeSplit = mainSplit[1].split(":");
        int year = Integer.parseInt(dateSplit[0]);
View Full Code Here
TOP

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

  • 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.