@Override public boolean removeQueue(String taskTrackerNodeGroup) { return new DropTableSql(getSqlTemplate()) .drop(JobQueueUtils.getExecutableQueueName(taskTrackerNodeGroup)) .doDrop(); }
@Override public boolean removeQueue(String taskTrackerNodeGroup) { return new DropTableSql(getSqlTemplate()) .drop(JobQueueUtils.getExecutableQueueName(taskTrackerNodeGroup)) .doDrop(); }
@Override public boolean remove(String taskTrackerNodeGroup, String jobId) { return new DeleteSql(getSqlTemplate()) .delete() .from() .table(getTableName(taskTrackerNodeGroup)) .where("job_id = ?", jobId) .doDelete() == 1; }
@Override public boolean remove(String taskTrackerNodeGroup, String jobId) { return new DeleteSql(getSqlTemplate()) .delete() .from() .table(getTableName(taskTrackerNodeGroup)) .where("job_id = ?", jobId) .doDelete() == 1; }
@Override public boolean removeBatch(String realTaskId, String taskTrackerNodeGroup) { new DeleteSql(getSqlTemplate()) .delete() .from() .table(getTableName(taskTrackerNodeGroup)) .where("real_task_id = ?", realTaskId) .and("task_tracker_node_group = ?", taskTrackerNodeGroup) .doDelete(); return true; }
@Override public boolean removeBatch(String realTaskId, String taskTrackerNodeGroup) { new DeleteSql(getSqlTemplate()) .delete() .from() .table(getTableName(taskTrackerNodeGroup)) .where("real_task_id = ?", realTaskId) .and("task_tracker_node_group = ?", taskTrackerNodeGroup) .doDelete(); return true; }
@Override public JobPo getJob(String taskTrackerNodeGroup, String taskId) { return new SelectSql(getSqlTemplate()) .select() .all() .from() .table(getTableName(taskTrackerNodeGroup)) .where("task_id = ?", taskId) .and("task_tracker_node_group = ?", taskTrackerNodeGroup) .single(RshHolder.JOB_PO_RSH); } }
@Override public long countJob(String realTaskId, String taskTrackerNodeGroup) { return (Long) new SelectSql(getSqlTemplate()) .select() .columns("COUNT(1)") .from() .table(getTableName(taskTrackerNodeGroup)) .where("real_task_id = ?", realTaskId) .and("task_tracker_node_group = ?", taskTrackerNodeGroup) .single(); }
@Override public long countJob(String realTaskId, String taskTrackerNodeGroup) { return (Long) new SelectSql(getSqlTemplate()) .select() .columns("COUNT(1)") .from() .table(getTableName(taskTrackerNodeGroup)) .where("real_task_id = ?", realTaskId) .and("task_tracker_node_group = ?", taskTrackerNodeGroup) .single(); }
@Override public List<JobPo> getDeadJob(String taskTrackerNodeGroup, long deadline) { return new SelectSql(getSqlTemplate()) .select() .all() .from() .table(getTableName(taskTrackerNodeGroup)) .where("is_running = ?", true) .and("gmt_modified < ?", deadline) .list(RshHolder.JOB_PO_LIST_RSH); }
@Override public List<JobPo> getDeadJob(String taskTrackerNodeGroup, long deadline) { return new SelectSql(getSqlTemplate()) .select() .all() .from() .table(getTableName(taskTrackerNodeGroup)) .where("is_running = ?", true) .and("gmt_modified < ?", deadline) .list(RshHolder.JOB_PO_LIST_RSH); }
@Override public JobPo getJob(String taskTrackerNodeGroup, String taskId) { return new SelectSql(getSqlTemplate()) .select() .all() .from() .table(getTableName(taskTrackerNodeGroup)) .where("task_id = ?", taskId) .and("task_tracker_node_group = ?", taskTrackerNodeGroup) .single(RshHolder.JOB_PO_RSH); } }
@Override public void resume(JobPo jobPo) { new UpdateSql(getSqlTemplate()) .update() .table(getTableName(jobPo.getTaskTrackerNodeGroup())) .set("is_running", false) .set("task_tracker_identity", null) .set("gmt_modified", SystemClock.now()) .where("job_id=?", jobPo.getJobId()) .doUpdate(); }
@Override public void resume(JobPo jobPo) { new UpdateSql(getSqlTemplate()) .update() .table(getTableName(jobPo.getTaskTrackerNodeGroup())) .set("is_running", false) .set("task_tracker_identity", null) .set("gmt_modified", SystemClock.now()) .where("job_id=?", jobPo.getJobId()) .doUpdate(); }
@Override public boolean removeQueue(String taskTrackerNodeGroup) { return new DropTableSql(getSqlTemplate()) .drop(JobQueueUtils.getExecutableQueueName(taskTrackerNodeGroup)) .doDrop(); }
@Override public boolean remove(String taskTrackerNodeGroup, String jobId) { return new DeleteSql(getSqlTemplate()) .delete() .from() .table(getTableName(taskTrackerNodeGroup)) .where("job_id = ?", jobId) .doDelete() == 1; }
@Override public boolean removeBatch(String realTaskId, String taskTrackerNodeGroup) { new DeleteSql(getSqlTemplate()) .delete() .from() .table(getTableName(taskTrackerNodeGroup)) .where("real_task_id = ?", realTaskId) .and("task_tracker_node_group = ?", taskTrackerNodeGroup) .doDelete(); return true; }
@Override public List<JobPo> getDeadJob(String taskTrackerNodeGroup, long deadline) { return new SelectSql(getSqlTemplate()) .select() .all() .from() .table(getTableName(taskTrackerNodeGroup)) .where("is_running = ?", true) .and("gmt_modified < ?", deadline) .list(RshHolder.JOB_PO_LIST_RSH); }
@Override public long countJob(String realTaskId, String taskTrackerNodeGroup) { return (Long) new SelectSql(getSqlTemplate()) .select() .columns("COUNT(1)") .from() .table(getTableName(taskTrackerNodeGroup)) .where("real_task_id = ?", realTaskId) .and("task_tracker_node_group = ?", taskTrackerNodeGroup) .single(); }
@Override public void resume(JobPo jobPo) { new UpdateSql(getSqlTemplate()) .update() .table(getTableName(jobPo.getTaskTrackerNodeGroup())) .set("is_running", false) .set("task_tracker_identity", null) .set("gmt_modified", SystemClock.now()) .where("job_id=?", jobPo.getJobId()) .doUpdate(); }