Examples of TextValue

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

407
408
409
410
411
412
413
414
415
416
417
    // null value, check that the value equals to the null value format of the
    // specific type value.
    assertEquals(new NumberValue(100.0),
        dataTable.getRow(0).getCell(0).getValue());
    assertEquals("Yaron", dataTable.getRow(0).getCell(1).getValue().toString());
    assertEquals(new TextValue(""), dataTable.getRow(0).getCell(2).getValue());
    assertEquals("Bar", dataTable.getRow(1).getCell(2).getValue().toString());
    assertEquals("F", dataTable.getRow(1).getCell(3).getValue().toString());
    assertEquals(BooleanValue.getNullValue(),
        dataTable.getRow(1).getCell(5).getValue());
    assertEquals(NumberValue.getNullValue(),
View Full Code Here

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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
TOP
Copyright © 2018 www.massapi.com. 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.