@Test
public void testDateConversion() {
Field f =
Data.makeColumnField(
"a",
"label",
new Object[] {"Jan 4, 1980", "Jan 4, 1988", "a", "2", null, "Jan 9, 1978"});
Field g = Data.toDate(f, null);
assertNotEquals(f, g);
assertEquals("a", g.name);
assertEquals("label", g.label);
assertEquals(6, g.rowCount());
assertEquals(3, g.valid());
// Should not change
assertEquals(g, Data.toDate(g, null));
}
@Test
public void testDateConversionForBadDates() {
Object[] data = new Object[1000];
for (int i = 0; i < data.length; i++) data[i] = i % 10 == 0 ? "name" : "-";
Field f = Data.makeColumnField("a", "label", data);
Field g = Data.toDate(f);
assertNotEquals(f, g);
assertEquals("a", g.name);
assertEquals("label", g.label);
assertEquals(1000, g.rowCount());
assertEquals(0, g.valid());
}
@Test
public void testDate() {
Field a;
a =
Data.toDate(
Data.makeColumnField(
"a", "label", new Object[] {"January 1, 1970", "January 1, 1970 00:00:01"}));
assertEquals(0.0, a.min(), 1e-9);
assertEquals(1.0 / 3600 / 24, a.max(), 1e-9);
assertEquals(DateUnit.second, a.property("dateUnit"));
a =
Data.toDate(
Data.makeColumnField(
"a", "label", new Object[] {"January 1, 1970", "January 1, 1970 00:04:00"}));
assertEquals(0.0, a.min(), 1e-9);
assertEquals(4.0 / 60 / 24, a.max(), 1e-9);
assertEquals(DateUnit.minute, a.property("dateUnit"));
a =
Data.toDate(
Data.makeColumnField(
"a", "label", new Object[] {"January 1, 1970", "January 1, 1970 00:06:00"}));
assertEquals(0.0, a.min(), 1e-9);
assertEquals(6.0 / 60 / 24, a.max(), 1e-9);
assertEquals(DateUnit.minute, a.property("dateUnit"));
a =
Data.toDate(
Data.makeColumnField(
"a", "label", new Object[] {"January 1, 1970", "January 1, 1970 00:45:00"}));
assertEquals(0.0, a.min(), 1e-9);
assertEquals(45.0 / 60 / 24, a.max(), 1e-9);
assertEquals(DateUnit.minute, a.property("dateUnit"));
a =
Data.toDate(
Data.makeColumnField(
"a", "label", new Object[] {"January 1, 1970", "January 1, 1970 04:59:00"}));
assertEquals(0.0, a.min(), 1e-9);
assertEquals(DateUnit.hour, a.property("dateUnit"));
a =
Data.toDate(
Data.makeColumnField(
"a", "label", new Object[] {"January 1, 1970", "January 1, 1970 05:00:00"}));
assertEquals(0.0, a.min(), 1e-9);
assertEquals(5.0 / 24, a.max(), 1e-9);
assertEquals(DateUnit.hour, a.property("dateUnit"));
a =
Data.toDate(
Data.makeColumnField(
"a", "label", new Object[] {"January 1, 1970", "January 4, 1970"}));
assertEquals(0.0, a.min(), 1e-9);
assertEquals(3.0, a.max(), 1e-9);
assertEquals(DateUnit.day, a.property("dateUnit"));
// Note that only three days are needed to get days as a unit -- this an exception to the usual
// "5 ticks" rule
a =
Data.toDate(
Data.makeColumnField(
"a", "label", new Object[] {"January 10, 1970", "January 2, 1970"}));
assertEquals(1.0, a.min(), 1e-9);
assertEquals(9.0, a.max(), 1e-9);
assertEquals(DateUnit.day, a.property("dateUnit"));
a =
Data.toDate(
Data.makeColumnField("a", "label", new Object[] {"January 10, 1970", "March 2, 1970"}));
assertEquals(9.0, a.min(), 1e-9);
assertEquals(60.0, a.max(), 1e-9);
assertEquals(DateUnit.week, a.property("dateUnit"));
a =
Data.toDate(
Data.makeColumnField(
"a", "label", new Object[] {"January 10, 1970", "December 31, 1970"}));
assertEquals(9.0, a.min(), 1e-9);
assertEquals(364.0, a.max(), 1e-9);
assertEquals(DateUnit.quarter, a.property("dateUnit"));
a =
Data.toDate(
Data.makeColumnField(
"a", "label", new Object[] {"January 10, 1970", "January 10, 1972"}));
assertEquals(9.0, a.min(), 1e-9);
assertEquals(2 * 365 + 9, a.max(), 1e-9);
assertEquals(DateUnit.quarter, a.property("dateUnit"));
a =
Data.toDate(
Data.makeColumnField(
"a", "label", new Object[] {"January 10, 1970", "January 10, 1974"}));
assertEquals(9.0, a.min(), 1e-9);
assertEquals(4 * 365 + 1 + 9, a.max(), 1e-9);
assertEquals(DateUnit.year, a.property("dateUnit"));
a =
Data.toDate(
Data.makeColumnField(
"a", "label", new Object[] {"January 10, 1970", "January 10, 1976"}));
assertEquals(9.0, a.min(), 1e-9);
assertEquals(6 * 365 + 1 + 9, a.max(), 1e-9);
assertEquals(DateUnit.year, a.property("dateUnit"));
a =
Data.toDate(
Data.makeColumnField(
"a", "label", new Object[] {"January 10, 1970", "January 10, 2030"}));
assertEquals(9.0, a.min(), 1e-9);
assertEquals(60 * 365 + 15 + 9, a.max(), 1e-9);
assertEquals(DateUnit.decade, a.property("dateUnit"));
a =
Data.toDate(
Data.toDate(
Data.makeColumnField("a", "label", new Object[] {"09:45:22", "09:45:24"}), null));
assertEquals((9 + 45 / 60.0 + 22 / 3600.0) / 24.0, a.min(), 1e-9);
assertEquals((9 + 45 / 60.0 + 24 / 3600.0) / 24.0, a.max(), 1e-9);
assertEquals(DateUnit.second, a.property("dateUnit"));
}