@Override public boolean updateLastGenerateTriggerTime(String jobId, Long lastGenerateTriggerTime) { return new UpdateSql(getSqlTemplate()) .update() .table(getTableName()) .set("last_generate_trigger_time", lastGenerateTriggerTime) .set("gmt_modified", SystemClock.now()) .where("job_id = ? ", jobId) .doUpdate() == 1; }
@Override public boolean updateLastGenerateTriggerTime(String jobId, Long lastGenerateTriggerTime) { return new UpdateSql(getSqlTemplate()) .update() .table(getTableName()) .set("last_generate_trigger_time", lastGenerateTriggerTime) .set("gmt_modified", SystemClock.now()) .where("job_id = ? ", jobId) .doUpdate() == 1; }
@Override public List<JobPo> getNeedGenerateJobPos(Long checkTime, int topSize) { return new SelectSql(getSqlTemplate()) .select() .all() .from() .table(getTableName()) .where("rely_on_prev_cycle = ?", false) .and("last_generate_trigger_time <= ?", checkTime) .limit(0, topSize) .list(RshHolder.JOB_PO_LIST_RSH); }
@Override public List<JobPo> getNeedGenerateJobPos(Long checkTime, int topSize) { return new SelectSql(getSqlTemplate()) .select() .all() .from() .table(getTableName()) .where("rely_on_prev_cycle = ?", false) .and("last_generate_trigger_time <= ?", checkTime) .limit(0, topSize) .list(RshHolder.JOB_PO_LIST_RSH); }
@Override public boolean updateLastGenerateTriggerTime(String jobId, Long lastGenerateTriggerTime) { return new UpdateSql(getSqlTemplate()) .update() .table(getTableName()) .set("last_generate_trigger_time", lastGenerateTriggerTime) .set("gmt_modified", SystemClock.now()) .where("job_id = ? ", jobId) .doUpdate() == 1; }
@Override public List<JobPo> getNeedGenerateJobPos(Long checkTime, int topSize) { return new SelectSql(getSqlTemplate()) .select() .all() .from() .table(getTableName()) .where("rely_on_prev_cycle = ?", false) .and("last_generate_trigger_time <= ?", checkTime) .limit(0, topSize) .list(RshHolder.JOB_PO_LIST_RSH); }