@Override public List<JobFeedbackPo> fetchTop(String jobClientNodeGroup, int top) { return new SelectSql(getSqlTemplate()) .select() .all() .from() .table(getTableName(jobClientNodeGroup)) .orderBy() .column("gmt_created", OrderByType.ASC) .limit(0, top) .list(RshHolder.JOB_FEED_BACK_LIST_RSH); }
@Override public List<JobFeedbackPo> fetchTop(String jobClientNodeGroup, int top) { return new SelectSql(getSqlTemplate()) .select() .all() .from() .table(getTableName(jobClientNodeGroup)) .orderBy() .column("gmt_created", OrderByType.ASC) .limit(0, top) .list(RshHolder.JOB_FEED_BACK_LIST_RSH); }
@Override protected List<JobPo> load(String loadTaskTrackerNodeGroup, int loadSize) { try { return new SelectSql(sqlTemplate) .select() .all() .from() .table(getTableName(loadTaskTrackerNodeGroup)) .where("is_running = ?", false) .and("trigger_time< ?", SystemClock.now()) .orderBy() .column("priority", OrderByType.ASC) .column("trigger_time", OrderByType.ASC) .column("gmt_created", OrderByType.ASC) .limit(0, loadSize) .list(RshHolder.JOB_PO_LIST_RSH); } catch (Exception e) { LOGGER.error("Error when load job:" + e.getMessage(), e); return null; } }
@Override protected List<JobPo> load(String loadTaskTrackerNodeGroup, int loadSize) { try { return new SelectSql(sqlTemplate) .select() .all() .from() .table(getTableName(loadTaskTrackerNodeGroup)) .where("is_running = ?", false) .and("trigger_time< ?", SystemClock.now()) .orderBy() .column("priority", OrderByType.ASC) .column("trigger_time", OrderByType.ASC) .column("gmt_created", OrderByType.ASC) .limit(0, loadSize) .list(RshHolder.JOB_PO_LIST_RSH); } catch (Exception e) { LOGGER.error("Error when load job:" + e.getMessage(), e); return null; } }
@Override public PaginationRsp<JobLogPo> search(JobLoggerRequest request) { PaginationRsp<JobLogPo> response = new PaginationRsp<JobLogPo>(); Long results = new SelectSql(getSqlTemplate()) .select() .columns("count(1)") .from() .table(getTableName()) .whereSql(buildWhereSql(request)) .single(); response.setResults(results.intValue()); if (results == 0) { return response; } // 查询 rows List<JobLogPo> rows = new SelectSql(getSqlTemplate()) .select() .all() .from() .table(getTableName()) .whereSql(buildWhereSql(request)) .orderBy() .column("log_time", OrderByType.DESC) .limit(request.getStart(), request.getLimit()) .list(RshHolder.JOB_LOGGER_LIST_RSH); response.setRows(rows); return response; }
@Override public PaginationRsp<JobLogPo> search(JobLoggerRequest request) { PaginationRsp<JobLogPo> response = new PaginationRsp<JobLogPo>(); Long results = new SelectSql(getSqlTemplate()) .select() .columns("count(1)") .from() .table(getTableName()) .whereSql(buildWhereSql(request)) .single(); response.setResults(results.intValue()); if (results == 0) { return response; } // 查询 rows List<JobLogPo> rows = new SelectSql(getSqlTemplate()) .select() .all() .from() .table(getTableName()) .whereSql(buildWhereSql(request)) .orderBy() .column("log_time", OrderByType.DESC) .limit(request.getStart(), request.getLimit()) .list(RshHolder.JOB_LOGGER_LIST_RSH); response.setRows(rows); return response; }
public PaginationRsp<JobPo> pageSelect(JobQueueReq request) { PaginationRsp<JobPo> response = new PaginationRsp<JobPo>(); WhereSql whereSql = buildWhereSql(request); Long results = new SelectSql(getSqlTemplate()) .select() .columns("count(1)") .from() .table(getTableName(request)) .whereSql(whereSql) .single(); response.setResults(results.intValue()); if (results > 0) { List<JobPo> jobPos = new SelectSql(getSqlTemplate()) .select() .all() .from() .table(getTableName(request)) .whereSql(whereSql) .orderBy() .column(CharacterUtils.camelCase2Underscore(request.getField()), OrderByType.convert(request.getDirection())) .limit(request.getStart(), request.getLimit()) .list(RshHolder.JOB_PO_LIST_RSH); response.setRows(jobPos); } return response; }
public PaginationRsp<JobPo> pageSelect(JobQueueReq request) { PaginationRsp<JobPo> response = new PaginationRsp<JobPo>(); WhereSql whereSql = buildWhereSql(request); Long results = new SelectSql(getSqlTemplate()) .select() .columns("count(1)") .from() .table(getTableName(request)) .whereSql(whereSql) .single(); response.setResults(results.intValue()); if (results > 0) { List<JobPo> jobPos = new SelectSql(getSqlTemplate()) .select() .all() .from() .table(getTableName(request)) .whereSql(whereSql) .orderBy() .column(CharacterUtils.camelCase2Underscore(request.getField()), OrderByType.convert(request.getDirection())) .limit(request.getStart(), request.getLimit()) .list(RshHolder.JOB_PO_LIST_RSH); response.setRows(jobPos); } return response; }
.andOnNotEmpty("name = ?", request.getNodeGroup()) .orderBy() .column("gmt_created", OrderByType.DESC) .limit(request.getStart(), request.getLimit())
.andOnNotEmpty("name = ?", request.getNodeGroup()) .orderBy() .column("gmt_created", OrderByType.DESC) .limit(request.getStart(), request.getLimit())
@Override public List<JobFeedbackPo> fetchTop(String jobClientNodeGroup, int top) { return new SelectSql(getSqlTemplate()) .select() .all() .from() .table(getTableName(jobClientNodeGroup)) .orderBy() .column("gmt_created", OrderByType.ASC) .limit(0, top) .list(RshHolder.JOB_FEED_BACK_LIST_RSH); }
@Override protected List<JobPo> load(String loadTaskTrackerNodeGroup, int loadSize) { try { return new SelectSql(sqlTemplate) .select() .all() .from() .table(getTableName(loadTaskTrackerNodeGroup)) .where("is_running = ?", false) .and("trigger_time< ?", SystemClock.now()) .orderBy() .column("priority", OrderByType.ASC) .column("trigger_time", OrderByType.ASC) .column("gmt_created", OrderByType.ASC) .limit(0, loadSize) .list(RshHolder.JOB_PO_LIST_RSH); } catch (Exception e) { LOGGER.error("Error when load job:" + e.getMessage(), e); return null; } }
@Override public PaginationRsp<JobLogPo> search(JobLoggerRequest request) { PaginationRsp<JobLogPo> response = new PaginationRsp<JobLogPo>(); Long results = new SelectSql(getSqlTemplate()) .select() .columns("count(1)") .from() .table(getTableName()) .whereSql(buildWhereSql(request)) .single(); response.setResults(results.intValue()); if (results == 0) { return response; } // 查询 rows List<JobLogPo> rows = new SelectSql(getSqlTemplate()) .select() .all() .from() .table(getTableName()) .whereSql(buildWhereSql(request)) .orderBy() .column("log_time", OrderByType.DESC) .limit(request.getStart(), request.getLimit()) .list(RshHolder.JOB_LOGGER_LIST_RSH); response.setRows(rows); return response; }
public PaginationRsp<JobPo> pageSelect(JobQueueReq request) { PaginationRsp<JobPo> response = new PaginationRsp<JobPo>(); WhereSql whereSql = buildWhereSql(request); Long results = new SelectSql(getSqlTemplate()) .select() .columns("count(1)") .from() .table(getTableName(request)) .whereSql(whereSql) .single(); response.setResults(results.intValue()); if (results > 0) { List<JobPo> jobPos = new SelectSql(getSqlTemplate()) .select() .all() .from() .table(getTableName(request)) .whereSql(whereSql) .orderBy() .column(CharacterUtils.camelCase2Underscore(request.getField()), OrderByType.convert(request.getDirection())) .limit(request.getStart(), request.getLimit()) .list(RshHolder.JOB_PO_LIST_RSH); response.setRows(jobPos); } return response; }
.andOnNotEmpty("name = ?", request.getNodeGroup()) .orderBy() .column("gmt_created", OrderByType.DESC) .limit(request.getStart(), request.getLimit())