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

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

858
859
860
861
862
863
864
865
866
867
868
        query.getPivot().getColumnIds());
  }

  public void testDateLiterals() throws Exception {
    Query query = QueryBuilder.getInstance().parseQuery("WHERE c1 > DATE '2006-08-23'");
    assertEquals(new DateValue(2006, 7, 23),
        ((ColumnValueFilter) query.getFilter()).getValue());
    query = QueryBuilder.getInstance().parseQuery(
        "WHERE c1 = DaTeTiMe '2007-01-30 15:33:22.432'");
    assertEquals(new DateTimeValue(2007, 0, 30, 15, 33, 22, 432),
        ((ColumnValueFilter) query.getFilter()).getValue());
View Full Code Here
64
65
66
67
68
69
70
71
72
73
74
  public void testToQueryString() {
    ColumnValueFilter filter1 = new ColumnValueFilter(new SimpleColumn("c2"),
        new NumberValue(100.23), ComparisonFilter.Operator.GE);
    ColumnValueFilter filter2 = new ColumnValueFilter(
        new AggregationColumn(new SimpleColumn("c3"), AggregationType.MAX),
        new DateValue(2007, 2, 3), ComparisonFilter.Operator.LIKE, true);

    assertEquals("`c2` >= 100.23", filter1.toQueryString());
    assertEquals("DATE '2007-3-3' LIKE MAX(`c3`)", filter2.toQueryString());

  }
View Full Code Here
251
252
253
254
255
256
257
258
259
260
261
        String[] split = content.split("-");
        year = Integer.parseInt(split[0]);
        month = Integer.parseInt(split[1]);
        month--; // normalize 1-12 to 0-11.
        day = Integer.parseInt(split[2]);
        return new DateValue(year, month, day);
      case TIMEOFDAY:
        split = content.split(":");
        hour = Integer.parseInt(split[0]);
        minute = Integer.parseInt(split[1]);
        if (split[2].contains(".")) {
View Full Code Here
294
295
296
297
298
299
300
301
302
303
304
      case DATETIME:
        return new DateTimeValue(random.nextInt(200) + 1900, random.nextInt(12),
            random.nextInt(28) + 1, random.nextInt(24), random.nextInt(60),
            random.nextInt(60), random.nextInt(999));
      case DATE:
        return new DateValue(random.nextInt(200) + 1900, random.nextInt(12),
            random.nextInt(28) + 1);
      case TIMEOFDAY:
        return new TimeOfDayValue(random.nextInt(24), random.nextInt(60),
            random.nextInt(60), random.nextInt(999));
      default:
View Full Code Here
84
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
    TableRow row = new TableRow();
    row.addCell(new TableCell("aaa"));
    row.addCell(new TableCell(222));
    row.addCell(new TableCell(false));
    row.addCell(new TableCell(new DateValue(2001, 10, 14)));
    row.addCell(new TableCell(new TimeOfDayValue(12, 11, 13, 14)));
    row.addCell(new TableCell(new DateTimeValue(2000, 10 , 1, 1, 10, 23, 432)));
    rows.add(row);

    row = new TableRow();
    row.addCell(new TableCell(new TextValue("ccc"), "$ccc"));
    row.addCell(new TableCell(111));
    row.addCell(new TableCell(true));
    row.addCell(new TableCell(new DateValue(2001, 1, 14)));
    row.addCell(new TableCell(new TimeOfDayValue(12, 30, 13, 14)));
    row.addCell(new TableCell(new DateTimeValue(1000, 11, 1, 1, 10, 23, 432)));
    rows.add(row);

    row = new TableRow();
    row.addCell(new TableCell("bbb"));
    row.addCell(new TableCell(3));
    row.addCell(new TableCell(true));
    row.addCell(new TableCell(new DateValue(2012, 2, 14)));
    row.addCell(new TableCell(new TimeOfDayValue(12, 11, 3, 14)));
    row.addCell(new TableCell(new DateTimeValue(2000, 1 , 1, 1, 10, 31, 4)));
    rows.add(row);

    row = new TableRow();
    row.addCell("ddd");
    row.addCell(222);
    row.addCell(false);
    row.addCell(new DateValue(1997, 5, 5));
    row.addCell(new TimeOfDayValue(12, 15, 15, 14));
    row.addCell(new DateTimeValue(3100, 1, 2, 15, 15, 1, 0));
    rows.add(row);

    testData.addRows(rows);
View Full Code Here
172
173
174
175
176
177
178
179
180
    }
    assertEquals(5, testData.getNumberOfRows());
    assertEquals(testData.getRow(4).getCell(0).getValue().compareTo(new TextValue("blah")), 0);
    assertEquals(testData.getRow(4).getCell(1).getValue().compareTo(new NumberValue(5)), 0);
    assertEquals(testData.getRow(4).getCell(2).getValue().compareTo(BooleanValue.TRUE), 0);
    assertEquals(testData.getRow(4).getCell(3).getValue().compareTo(new DateValue(c1)), 0);
    assertEquals(testData.getRow(4).getCell(4).getValue().compareTo(new TimeOfDayValue(c2)), 0);
    assertEquals(testData.getRow(4).getCell(5).getValue().compareTo(new DateTimeValue(c2)), 0);
  }
View Full Code Here
338
339
340
341
342
343
344
345
346
347
348
    DataTable dataTable = testData.clone();
   
    TableCell newNumberValueCell = new TableCell(new NumberValue(5699), "5699$");
    newNumberValueCell.setCustomProperty("testProperty", "A test property");
    TableCell newBooleanValueCell = new TableCell(false);
    TableCell newDateValueCell = new TableCell(new DateValue(2011, 3, 6), "03/06/2011");
   
    dataTable.setCell(1, 1, newNumberValueCell);
    dataTable.setCell(2, 2, newBooleanValueCell);
    dataTable.setCell(2, 3, newDateValueCell);
   
View Full Code Here
42
43
44
45
46
47
48
49
50
51
52
    TableRow row = new TableRow();
    row.addCell(true);
    row.addCell(BooleanValue.getNullValue());
    row.addCell(-2.3);
    row.addCell("foo");
    row.addCell(new DateValue(2008, 2, 3));
    row.getCell(2).setFormattedValue("bar-2.3");
    row.getCell(4).setCustomProperty("foo", "bar");
   
    TableRow clonedRow = row.clone();
   
View Full Code Here
93
94
95
96
97
98
99
100
101
102
103
      // Text
      formattedValue = textFormatter.format(new TextValue("this is a test"));
      assertEquals("this is a test", formattedValue);

      // Date
      formattedValue = dateFormatter.format(new DateValue(1988, 11, 24));
      assertFalse(StringUtils.isEmpty(formattedValue));
      language = ulocale.getDisplayLanguage();
      if (isReadableLetters(language)) {
        assertTrue(formattedValue.contains("88"));
      }
View Full Code Here
243
244
245
246
247
248
249
250
251
252
253
    // Text
    formattedValue = textFormatter.format(new TextValue("this is another test"));
    assertEquals("this is another test", formattedValue);

    // Date
    formattedValue = dateFormatter.format(new DateValue(1988, 11, 24));
    assertEquals("12 | 24 | 88", formattedValue);

    // Time
    formattedValue =
        timeFormatter.format(new TimeOfDayValue(2, 24, 6));
View Full Code Here
TOP

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

  • com.google.feedserver.samples.wrappers.gviz.GVizTypeConverter
  • com.google.visualization.datasource.datatable.DataTableTest
  • com.google.visualization.datasource.datatable.TableCellTest
  • com.google.visualization.datasource.datatable.TableRowTest
  • com.google.visualization.datasource.datatable.ValueFormatter
  • com.google.visualization.datasource.datatable.ValueFormatterTest
  • com.google.visualization.datasource.query.ColumnValueFilterTest
  • com.google.visualization.datasource.query.ComparisonFilterTest
  • com.google.visualization.datasource.query.engine.ColumnValueAggregatorTest
  • com.google.visualization.datasource.query.mocks.MockDataSource
    • 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.