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

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

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

com.google.visualization.datasource.datatable.value.DateTimeValue
A value of type date-time. Used to represent a specific day in a given year as well as a specific time during that day. This differs from {@link DateValue}, which represents only a specific day in a given year. DateTime is represented internally by a GregorianCalendar. The calendar is immutable and is kept only for validation of the input. @author Hillel M.

        assertEquals(new NumberValue(2008), year.evaluate(dateValues));
        assertEquals(new NumberValue(7), month.evaluate(dateValues));
        assertEquals(new NumberValue(13), day.evaluate(dateValues));


        List<Value> dateTimeValues =
                Lists.newArrayList((Value) new DateTimeValue(
                        2001, 2, 3, 9, 12, 22, 333));
        assertEquals(new NumberValue(2001), year.evaluate(dateTimeValues));
        assertEquals(new NumberValue(2), month.evaluate(dateTimeValues));
        assertEquals(new NumberValue(3), day.evaluate(dateTimeValues));
        assertEquals(new NumberValue(9), hour.evaluate(dateTimeValues));
        assertEquals(new NumberValue(12), minute.evaluate(dateTimeValues));
        assertEquals(new NumberValue(22), second.evaluate(dateTimeValues));
        assertEquals(new NumberValue(333), millisecond.evaluate(dateTimeValues));


        List<Value> timeOfDayValues =
                Lists.newArrayList((Value) new TimeOfDayValue(23, 22, 21, 20));
        assertEquals(new NumberValue(23), hour.evaluate(timeOfDayValues));
        assertEquals(new NumberValue(22), minute.evaluate(timeOfDayValues));
        assertEquals(new NumberValue(21), second.evaluate(timeOfDayValues));
        assertEquals(new NumberValue(20), millisecond.evaluate(timeOfDayValues));
        timeOfDayValues = Lists.newArrayList((Value) new TimeOfDayValue(9, 12, 22));
        // Tests that milliseconds return 0 when the the TimeOfDayValue is
        // initialized without the milliseconds.
        assertEquals(new NumberValue(0), millisecond.evaluate(timeOfDayValues));


        List<Value> dateValues1 =
                Lists.newArrayList((Value) new DateValue(2008, 1, 13));
        List<Value> dateValues2 =
                Lists.newArrayList((Value) new DateValue(2008, 4, 13));
        List<Value> dateValues3 =
                Lists.newArrayList((Value) new DateValue(2008, 8, 13));
        List<Value> dateValues4 =
                Lists.newArrayList((Value) new DateValue(2008, 11, 13));
        List<Value> dateValues5 =
                Lists.newArrayList((Value) new DateValue(2008, 5, 13));


        assertEquals(new NumberValue(1), quarter.evaluate(dateValues1));
        assertEquals(new NumberValue(2), quarter.evaluate(dateValues2));
        assertEquals(new NumberValue(3), quarter.evaluate(dateValues3));
        assertEquals(new NumberValue(4), quarter.evaluate(dateValues4));
        assertEquals(new NumberValue(2), quarter.evaluate(dateValues5));


        assertEquals(new NumberValue(4), dayofweek.evaluate(dateValues1));
        assertEquals(new NumberValue(3), dayofweek.evaluate(dateValues2));
        assertEquals(new NumberValue(7), dayofweek.evaluate(dateValues3));
        assertEquals(new NumberValue(7), dayofweek.evaluate(dateValues4));
        assertEquals(new NumberValue(6), dayofweek.evaluate(dateValues5));


        List<Value> dateTimeValues1 =
                Lists.newArrayList((Value) new DateTimeValue(
                        2001, 0, 3, 9, 12, 22, 333));
        List<Value> dateTimeValues2 =
                Lists.newArrayList((Value) new DateTimeValue(
                        2001, 3, 3, 9, 12, 22, 333));
        List<Value> dateTimeValues3 =
                Lists.newArrayList((Value) new DateTimeValue(
                        2001, 8, 3, 9, 12, 22, 333));
        List<Value> dateTimeValues4 =
                Lists.newArrayList((Value) new DateTimeValue(
                        2001, 10, 3, 9, 12, 22, 333));
        List<Value> dateTimeValues5 =
                Lists.newArrayList((Value) new DateTimeValue(
                        2001, 7, 3, 9, 12, 22, 333));


        assertEquals(new NumberValue(1), quarter.evaluate(dateTimeValues1));
        assertEquals(new NumberValue(2), quarter.evaluate(dateTimeValues2));
        assertEquals(new NumberValue(3), quarter.evaluate(dateTimeValues3));

View Full Code Here

        ToDate toDate = ToDate.getInstance();
        List<Value> valuesList1 =
                Lists.<Value>newArrayList(new DateValue(2008, 1, 13));
        List<Value> valuesList2 =
                Lists.<Value>newArrayList(
                        new DateTimeValue(2008, 2, 23, 9, 12, 22, 333));
        List<Value> valuesList3 =
                Lists.<Value>newArrayList(new NumberValue(1234567890000.53421423424));
        List<Value> valuesList4 =
                Lists.<Value>newArrayList(new NumberValue(-1234567890000.0));
        assertEquals(new DateValue(2008, 1, 13), toDate.evaluate(valuesList1));

View Full Code Here

                    milli = Integer.parseInt(secondMilliSplit[1]);
                }
                else {
                    second = Integer.parseInt(timeSplit[2]);
                }
                return new DateTimeValue(year, month, day, hour, minute, second, milli);
            case DATE:
                String[] split = content.split("-");
                year = Integer.parseInt(split[0]);
                month = Integer.parseInt(split[1]);
                month--; // normalize 1-12 to 0-11.

View Full Code Here

                for(int i = 0; i < numLetters; i++) {
                    builder.append('a' + random.nextInt(26));
                }
                return new TextValue(builder.toString());
            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);

View Full Code Here

        assertEquals(NumberValue.getNullValue(),
                dataTable.getRow(2).getCell(4).getValue());
        assertEquals("true", dataTable.getRow(2).getCell(5).getValue().toString());
        assertEquals(dataTable.getRow(0).getCell(6).getValue().toString(),
                new DateValue(gc), dataTable.getRow(0).getCell(6).getValue());
        assertEquals(new DateTimeValue(gc),
                dataTable.getRow(0).getCell(7).getValue());
        assertEquals(new TimeOfDayValue(gc),
                dataTable.getRow(0).getCell(8).getValue());
        assertEquals(DateValue.getNullValue(),
                dataTable.getRow(1).getCell(6).getValue());

View Full Code Here

            if(isReadableLetters(language)) {
                assertTrue(formattedValue.contains("24"));
            }


            // Timestamp
            formattedValue = dateTimeFormatter.format(new DateTimeValue(1597, 9, 29, 1, 2, 33, 142));
            assertFalse(StringUtils.isEmpty(formattedValue));
            language = ulocale.getDisplayLanguage();
            if(isReadableLetters(language)) {
                assertTrue(formattedValue.contains("29"));
            }

View Full Code Here

        formattedValue =
                timeFormatter.format(new TimeOfDayValue(2, 24, 6));
        assertEquals("02-24", formattedValue);


        // Timestamp
        formattedValue = timestampFormatter.format(new DateTimeValue(1597, 9, 29, 1, 2, 33, 142));
        assertEquals("29_10_97 01:02", formattedValue);
    }

View Full Code Here

                ValueFormatter.createDefault(ValueType.BOOLEAN, null).parse("true"));


        assertEquals(new DateValue(2009, Calendar.JANUARY, 1),
                ValueFormatter.createDefault(ValueType.DATE, null).parse("2009-1-1"));


        assertEquals(new DateTimeValue(2009, Calendar.JANUARY, 1, 12, 13, 14, 0),
                ValueFormatter.createDefault(ValueType.DATETIME, null).parse("2009-1-1 12:13:14"));


        assertEquals(new TimeOfDayValue(12, 13, 14, 0),
                ValueFormatter.createDefault(ValueType.TIMEOFDAY, null).parse("12:13:14"));

View Full Code Here

        assertEquals(TimeOfDayValue.getNullValue(), timeOfDayFormatter.parse("01.15.2004"));
    }


    public void testParseDateTime() {
        ValueFormatter dateTimeFormatter = ValueFormatter.createDefault(ValueType.DATETIME, null);
        assertEquals(new DateTimeValue(2004, Calendar.FEBRUARY, 15, 7, 22, 44, 0),
                dateTimeFormatter.parse("2004-02-15 7:22:44"));
        dateTimeFormatter =
                ValueFormatter.createFromPattern(ValueType.DATETIME, "MM/dd/yyyy ss:mm:HH", null);
        assertEquals(new DateTimeValue(2004, Calendar.JANUARY, 15, 7, 22, 44, 0),
                dateTimeFormatter.parse("01/15/2004 44:22:7"));
        assertEquals(DateTimeValue.getNullValue(), dateTimeFormatter.parse("01.15.2004"));
    }

View Full Code Here

        assertEquals("", r.renderDataTable(dataTable, true, true));
    }


    public void testAppendCellJson() {
        TableCell dateCell = new TableCell(new DateValue(2009, 1, 12));
        TableCell datetimeCell = new TableCell(new DateTimeValue(2009, 1, 12, 12, 13, 14, 15));
        TableCell numberCell = new TableCell(12.3);
        TableCell textCell = new TableCell("aba");


        JsonRenderer r = new JsonRenderer();

View Full Code Here

0 1 2 3 4 5

TOP

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

com.google.visualization.datasource.datatable.DataTableTest

com.google.visualization.datasource.datatable.ValueFormatter

com.google.visualization.datasource.datatable.ValueFormatterTest

com.google.visualization.datasource.query.mocks.MockDataSource

com.google.visualization.datasource.query.parser.ParserUtils

com.google.visualization.datasource.query.parser.QueryBuilderTest

com.google.visualization.datasource.query.scalarfunction.CurrentDateTime

com.google.visualization.datasource.query.scalarfunction.DateDiffTest

com.google.visualization.datasource.query.scalarfunction.TimeComponentExtractorTest

com.google.visualization.datasource.query.scalarfunction.ToDateTest

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.