@Test public void testScan() throws Exception { List<String> values = new ArrayList<String>(); values.add(millis("2012-01-24")); values.add(millis("2012-12-30")); List<String> results = lookupTable.scan("CAL_DT", values, "YEAR_BEG_DT"); Assert.assertTrue(results.size() > 0); for (String i : results) { System.out.println(i); Assert.assertEquals(millis("2012-01-01"), i); } }
@Test public void testMapValues() throws Exception { Set<String> values = new HashSet<String>(); values.add(millis("2012-01-24")); values.add(millis("2012-12-30")); Set<String> results = lookupTable.mapValues("CAL_DT", values, "YEAR_BEG_DT"); Assert.assertTrue(results.size() == 1); for (String i : results) { System.out.println(i); Assert.assertEquals(millis("2012-01-01"), i); } }
@Test public void testMapRange() throws Exception { Pair<String, String> results = lookupTable.mapRange("CAL_DT", millis("2012-01-24"), millis("2012-12-30"), "QTR_BEG_DT"); Assert.assertTrue(results != null); System.out.println("The first qtr_beg_dt is " + results.getFirst()); System.out.println("The last qtr_beg_dt is " + results.getSecond()); Assert.assertEquals(millis("2012-01-01"), results.getFirst()); Assert.assertEquals(millis("2012-10-01"), results.getSecond()); }
@Test public void testMapRange2() throws Exception { Pair<String, String> results = lookupTable.mapRange("WEEK_BEG_DT", millis("2013-05-01"), millis("2013-08-01"), "CAL_DT"); System.out.println(DateFormat.formatToDateStr(Long.parseLong(results.getFirst()))); System.out.println(DateFormat.formatToDateStr(Long.parseLong(results.getSecond()))); Assert.assertEquals(millis("2013-05-05"), results.getFirst()); Assert.assertEquals(millis("2013-08-03"), results.getSecond()); }