@Test
public void activeJobs_shouldRemoveCacheActiveJobOnUpdateJobStatus() {
final ActiveJob first = new ActiveJob(1L, "pipeline", 1, "label", "stage", "first");
final ActiveJob second = new ActiveJob(2L, "another", 2, "label", "stage", "job1");
List<ActiveJob> expectedJobs = Arrays.asList(first, second);
when(mockTemplate.queryForList("getActiveJobIds")).thenReturn(Arrays.asList(1L, 2L));
when(mockTemplate.queryForObject("getActiveJobById", arguments("id", 1L).asMap()))
.thenReturn(first);
when(mockTemplate.queryForObject("getActiveJobById", arguments("id", 2L).asMap()))
.thenReturn(second);
jobInstanceDao.setSqlMapClientTemplate(mockTemplate);
jobInstanceDao.activeJobs(); // cache it first
jobInstanceDao.updateStateAndResult(instance(1L)); // should remove from cache
List<ActiveJob> activeJobs = jobInstanceDao.activeJobs();
assertThat(expectedJobs, is(activeJobs));
verify(mockTemplate, times(2)).queryForList("getActiveJobIds");
verify(mockTemplate, times(2)).queryForObject("getActiveJobById", arguments("id", 1L).asMap());
verify(mockTemplate, times(1)).queryForObject("getActiveJobById", arguments("id", 2L).asMap());
}
public int getMaxC_id() {
int maxC_id = -1;
if (ibatisTemplate.queryForObject("getMaxC_id") != null) {
maxC_id = (Integer) ibatisTemplate.queryForObject("getMaxC_id");
}
return maxC_id;
}
@Test
public void orderedScheduledBuilds_shouldCacheJobPlan() {
when(mockTemplate.queryForList(eq("scheduledPlanIds"))).thenReturn(Arrays.asList(1L, 2L));
final DefaultJobPlan firstJob = jobPlan(1);
final DefaultJobPlan secondJob = jobPlan(2);
List<JobPlan> expectedPlans =
new ArrayList<JobPlan>() {
{
add(firstJob);
add(secondJob);
}
};
when(mockTemplate.queryForObject("scheduledPlan", arguments("id", 1L).asMap()))
.thenReturn(firstJob);
when(mockTemplate.queryForObject("scheduledPlan", arguments("id", 2L).asMap()))
.thenReturn(secondJob);
jobInstanceDao.setSqlMapClientTemplate(mockTemplate);
jobInstanceDao.orderedScheduledBuilds();
List<JobPlan> plans = jobInstanceDao.orderedScheduledBuilds();
assertThat(plans, is(expectedPlans));
verify(mockTemplate, times(2)).queryForObject(eq("scheduledPlan"), any());
verify(mockTemplate, times(2)).queryForList(eq("scheduledPlanIds"));
}
@Test
public void updateStatus_shouldRemoveCachedJobPlan() {
when(mockTemplate.queryForList(eq("scheduledPlanIds"))).thenReturn(Arrays.asList(1L));
final DefaultJobPlan firstJob = jobPlan(1);
List<JobPlan> expectedPlans =
new ArrayList<JobPlan>() {
{
add(firstJob);
}
};
when(mockTemplate.queryForObject("scheduledPlan", arguments("id", 1L).asMap()))
.thenReturn(firstJob);
jobInstanceDao.setSqlMapClientTemplate(mockTemplate);
jobInstanceDao.orderedScheduledBuilds(); // populate the cache
JobInstance instance = instance(1);
jobInstanceDao.updateStateAndResult(instance);
List<JobPlan> plans = jobInstanceDao.orderedScheduledBuilds();
assertThat(plans, is(expectedPlans));
verify(mockTemplate, times(2))
.queryForObject(
"scheduledPlan", arguments("id", 1L).asMap()); // because the cache is cleared
verify(mockTemplate, times(2)).queryForList(eq("scheduledPlanIds"));
}
/** 用户即将到期的订单统计 */
public int getCountAboutToExpireOrder(Long userId, int dayEnd) {
Map<String, Object> paramMap = new HashMap<String, Object>();
paramMap.put("userId", userId);
paramMap.put("dayEnd", dayEnd);
paramMap.put("currentDate", new Date());
Object obj = sqlMapClientTemplate.queryForObject("getCountAboutToExpireOrder", paramMap);
return obj != null ? Integer.valueOf(obj.toString()) : 0;
}
public BoardVo getView(long no) {
// System.out.println("BoardDao getView : " + no);
BoardVo vo = (BoardVo) sqlMapClientTemplate.queryForObject("board.getView", no);
return vo;
/*
String sql = "SELECT no, view_cnt, member_no, member_name, title, content, TO_CHAR (reg_date, 'YYYY-MMDD HH:MM:SS') FROM board where no=?";
*/
}
@Test
public void activeJobs_shouldCacheCurrentlyActiveJobIds() {
final ActiveJob first = new ActiveJob(1L, "pipeline", 1, "label", "stage", "job1");
final ActiveJob second = new ActiveJob(2L, "another", 2, "label", "stage", "job1");
List<ActiveJob> expectedJobs = Arrays.asList(first, second);
when(mockTemplate.queryForList("getActiveJobIds")).thenReturn(Arrays.asList(1L, 2L));
when(mockTemplate.queryForObject("getActiveJobById", arguments("id", 1L).asMap()))
.thenReturn(first);
when(mockTemplate.queryForObject("getActiveJobById", arguments("id", 2L).asMap()))
.thenReturn(second);
jobInstanceDao.setSqlMapClientTemplate(mockTemplate);
jobInstanceDao.activeJobs(); // populate the cache
List<ActiveJob> activeJobs = jobInstanceDao.activeJobs();
assertThat(expectedJobs, is(activeJobs));
verify(mockTemplate, times(1)).queryForList("getActiveJobIds");
verify(mockTemplate, times(1)).queryForObject("getActiveJobById", arguments("id", 1L).asMap());
verify(mockTemplate, times(1)).queryForObject("getActiveJobById", arguments("id", 2L).asMap());
}
@Test
public void buildByIdWithTransitions_shouldCacheWhenQueriedFor() {
jobInstanceDao.setSqlMapClientTemplate(mockTemplate);
JobInstance job = JobInstanceMother.assigned("job");
job.setId(1L);
when(mockTemplate.queryForObject("buildByIdWithTransitions", 1L)).thenReturn(job);
JobInstance actual = jobInstanceDao.buildByIdWithTransitions(1L);
assertThat(actual, is(job));
assertThat(actual == job, is(false));
jobInstanceDao.buildByIdWithTransitions(1L);
verify(mockTemplate, times(1)).queryForObject("buildByIdWithTransitions", 1L);
}
@Test
public void buildByIdWithTransitions_shouldClearFromCacheOnUpdateStatusOfJob() {
jobInstanceDao.setSqlMapClientTemplate(mockTemplate);
JobInstance job = JobInstanceMother.assigned("job");
job.setId(1L);
when(mockTemplate.queryForObject("buildByIdWithTransitions", 1L)).thenReturn(job);
JobInstance actual = jobInstanceDao.buildByIdWithTransitions(1L);
assertThat(actual, is(job));
assertThat(actual == job, is(false));
jobInstanceDao.updateStateAndResult(job); // Must clear cahced job instance
jobInstanceDao.buildByIdWithTransitions(1L);
verify(mockTemplate, times(2)).queryForObject("buildByIdWithTransitions", 1L);
}
public int getOrdersCount(SysOrderDto dto) {
Map<String, Object> paraMap = new HashMap<String, Object>();
try {
paraMap.put("fromOrderDate", dto.getFromOrderDate());
paraMap.put("toOrderDate", dto.getToOrderDate());
paraMap.put("fromPayDate", dto.getFromPayDate());
paraMap.put("toPayDate", dto.getToPayDate());
paraMap.put("status", dto.getStatus());
paraMap.put("payDate", dto.getPayDate());
paraMap.put("serviceCode", dto.getServiceCode());
paraMap.put("inOrderName", dto.getInOrderName());
paraMap.put("itemCode", dto.getItemCode());
paraMap.put("inOrder", dto.getInOrder());
paraMap.put("endDate", dto.getEndDate());
paraMap.put("service1Remains", dto.getService1Remains());
paraMap.put("service2Remains", dto.getService2Remains());
paraMap.put("service3Remains", dto.getService3Remains());
} catch (Exception e) {
logger.error(e);
}
Object obj = sqlMapClientTemplate.queryForObject("queryOrderCount", paraMap);
return obj != null ? Integer.valueOf(obj.toString()) : 0;
}
public Object select(Object primaryKey) throws DataAccessException {
logger.debug("Ruuning statement: " + namespace + SELECT);
validateNameSpace();
return sqlMapClientTemplate.queryForObject(namespace + SELECT, primaryKey);
}
public SysOrderDto queryOrder(SysOrderDto dto) {
return (SysOrderDto) sqlMapClientTemplate.queryForObject("queryOrder", dto);
}
/** 用户还未支付订单统计 */
public int getCountOfHaveNotYetPaidOrder(Long userId) {
return (Integer) sqlMapClientTemplate.queryForObject("getCountOfHaveNotYetPaidOrder", userId);
}
/** 当天新增订单数统计 */
public int getNewOrdersStatisticsToDay() {
return (Integer) sqlMapClientTemplate.queryForObject("getNewOrdersStatisticsToDay", new Date());
}
public Integer queryCertAccessHistoryCountByCertId(Long certId) {
return (Integer)
sqlMapClientTemplate.queryForObject("queryCertAccessHistoryCountByCertId", certId);
}