public void increment(Calendar calendar, int increment) { switch (this) { case QUARTERLY: increment *= 3; } calendar.add(calendarField(), increment); }
public void increment(Calendar calendar, int increment) { switch (this) { case QUARTERLY: increment *= 3; } calendar.add(calendarField(), increment); }
public Date negativeOffsetFrom(Date time) { return DateUtils.add(time, updatePeriod.calendarField(), -quantity); } }
public Date negativeOffsetFrom(Date time) { return DateUtils.add(time, updatePeriod.calendarField(), -quantity); } }
public Date offsetFrom(Date time) { return DateUtils.add(time, updatePeriod.calendarField(), quantity); }
public Date offsetFrom(Date time) { return DateUtils.add(time, updatePeriod.calendarField(), quantity); }
/** * Get partition value strings for given range, for the specified updateInterval * * @param fromDate * @param toDate * @param interval * @return */ public List<String> getPartitions(Date fromDate, Date toDate, UpdatePeriod interval) { Calendar cal = Calendar.getInstance(); cal.setTime(fromDate); List<String> partitions = new ArrayList<String>(); Date dt = cal.getTime(); while (dt.compareTo(toDate) < 0) { String part = interval.format(cal.getTime()); partitions.add(part); cal.add(interval.calendarField(), 1); dt = cal.getTime(); } return partitions; }
public Date truncate(Date date) { switch (this) { case WEEKLY: Date truncDate = DateUtils.truncate(date, Calendar.DAY_OF_MONTH); Calendar cal = Calendar.getInstance(); cal.setTime(truncDate); cal.set(Calendar.DAY_OF_WEEK, cal.getFirstDayOfWeek()); return cal.getTime(); case QUARTERLY: Date dt = DateUtils.truncate(date, this.calendarField()); dt.setMonth(dt.getMonth() - (dt.getMonth() % 3)); return dt; default: return DateUtils.truncate(date, this.calendarField()); } }
public TimePartition partitionAtDiff(int increment) { Calendar cal = Calendar.getInstance(); cal.setTime(date); if (getUpdatePeriod().equals(UpdatePeriod.QUARTERLY)) { increment *= 3; } cal.add(updatePeriod.calendarField(), increment); return new TimePartition(updatePeriod, cal.getTime()); }
/** * Get partition value strings for given range, for the specified updateInterval * * @param fromDate * @param toDate * @param interval * @return */ public List<String> getPartitions(Date fromDate, Date toDate, UpdatePeriod interval) { Calendar cal = Calendar.getInstance(); cal.setTime(fromDate); List<String> partitions = new ArrayList<String>(); Date dt = cal.getTime(); while (dt.compareTo(toDate) < 0) { String part = interval.format(cal.getTime()); partitions.add(part); cal.add(interval.calendarField(), 1); dt = cal.getTime(); } return partitions; }
public TimePartition partitionAtDiff(int increment) { Calendar cal = Calendar.getInstance(); cal.setTime(date); if (getUpdatePeriod().equals(UpdatePeriod.QUARTERLY)) { increment *= 3; } cal.add(updatePeriod.calendarField(), increment); return new TimePartition(updatePeriod, cal.getTime()); }
public Date truncate(Date date) { switch (this) { case WEEKLY: Date truncDate = DateUtils.truncate(date, Calendar.DAY_OF_MONTH); Calendar cal = Calendar.getInstance(); cal.setTime(truncDate); cal.set(Calendar.DAY_OF_WEEK, cal.getFirstDayOfWeek()); return cal.getTime(); case QUARTERLY: Date dt = DateUtils.truncate(date, this.calendarField()); dt.setMonth(dt.getMonth() - (dt.getMonth() % 3)); return dt; default: return DateUtils.truncate(date, this.calendarField()); } }
cal.add(this.calendarField(), 1); return getFloorDate(cal.getTime()); } else {
cal.add(this.calendarField(), 1); return getFloorDate(cal.getTime()); } else {
public static Date timeAtDiff(Date date, UpdatePeriod period, int d) { Calendar cal = Calendar.getInstance(); cal.setTime(date); if (period.equals(UpdatePeriod.QUARTERLY)) { d *= 3; } cal.add(period.calendarField(), d); return cal.getTime(); }
@Override public Date get(Object key) { if (!containsKey(key) && key instanceof Integer) { calendar.setTime(super.get(0)); calendar.add(updatePeriod.calendarField(), (Integer) key); put((Integer) key, calendar.getTime()); } return super.get(key); } }
whereClauses.put(getDbName() + "c4_testfact2", TestBetweenTimeRangeWriter.getBetweenClause("timehourchain1", "full_hour", getUptoHour(TWODAYS_BACK), getUptoHour(getOneLess(NOW, UpdatePeriod.HOURLY.calendarField())), TestTimeRangeWriter.DB_FORMAT)); System.out.println("HQL:" + hqlQuery); String expected = getDbName() + "c4_testfact2", TestBetweenTimeRangeWriter.getBetweenClause("timehourchain1", "full_hour", getUptoHour(TWODAYS_BACK), getUptoHour(getOneLess(NOW, UpdatePeriod.HOURLY.calendarField())), TestTimeRangeWriter.DB_FORMAT) + " OR " + TestBetweenTimeRangeWriter.getBetweenClause("timehourchain1", "full_hour", getUptoHour(BEFORE_6_DAYS), getUptoHour(getOneLess(BEFORE_4_DAYS, UpdatePeriod.HOURLY.calendarField())), TestTimeRangeWriter.DB_FORMAT)); expected =
whereClauses.put(getDbName() + "c4_testfact2", TestBetweenTimeRangeWriter.getBetweenClause( "timehourchain2", "full_hour", getUptoHour(TWODAYS_BACK), getUptoHour(getOneLess(NOW, UpdatePeriod.HOURLY.calendarField())), TestTimeRangeWriter.DB_FORMAT)); System.out.println("HQL:" + hqlQuery); String expected = getDbName() + "c4_testfact2", TestBetweenTimeRangeWriter.getBetweenClause("timehourchain2", "full_hour", getUptoHour(TWODAYS_BACK), getUptoHour(getOneLess(NOW, UpdatePeriod.HOURLY.calendarField())), TestTimeRangeWriter.DB_FORMAT) + " OR " + TestBetweenTimeRangeWriter.getBetweenClause("timehourchain2", "full_hour", getUptoHour(BEFORE_6_DAYS), getUptoHour(getOneLess(BEFORE_4_DAYS, UpdatePeriod.HOURLY.calendarField())), TestTimeRangeWriter.DB_FORMAT)); expected =