@Override protected String getTableName(JobQueueReq request) { return getTableName(); }
@Override protected String getTableName(JobQueueReq request) { return getTableName(); }
@Override public boolean add(JobPo jobPo) { return super.add(getTableName(), jobPo); }
@Override public boolean add(JobPo jobPo) { return super.add(getTableName(), jobPo); }
public MysqlExecutingJobQueue(Config config) { super(config); // create table createTable(readSqlFile("sql/mysql/lts_executing_job_queue.sql", getTableName())); }
public MysqlExecutingJobQueue(Config config) { super(config); // create table createTable(readSqlFile("sql/mysql/lts_executing_job_queue.sql", getTableName())); }
@Override public boolean remove(String jobId) { return new DeleteSql(getSqlTemplate()) .delete() .from() .table(getTableName()) .where("job_id = ?", jobId) .doDelete() == 1; }
@Override public boolean remove(String jobId) { return new DeleteSql(getSqlTemplate()) .delete() .from() .table(getTableName()) .where("job_id = ?", jobId) .doDelete() == 1; }
@Override public List<JobPo> getDeadJobs(long deadline) { return new SelectSql(getSqlTemplate()) .select() .all() .from() .table(getTableName()) .where("gmt_modified < ?", deadline) .list(RshHolder.JOB_PO_LIST_RSH); }
@Override public List<JobPo> getDeadJobs(long deadline) { return new SelectSql(getSqlTemplate()) .select() .all() .from() .table(getTableName()) .where("gmt_modified < ?", deadline) .list(RshHolder.JOB_PO_LIST_RSH); }
@Override public List<JobPo> getJobs(String taskTrackerIdentity) { return new SelectSql(getSqlTemplate()) .select() .all() .from() .table(getTableName()) .where("task_tracker_identity = ?", taskTrackerIdentity) .list(RshHolder.JOB_PO_LIST_RSH); }
@Override public JobPo getJob(String jobId) { return new SelectSql(getSqlTemplate()) .select() .all() .from() .table(getTableName()) .where("job_id = ?", jobId) .single(RshHolder.JOB_PO_RSH); }
@Override public List<JobPo> getJobs(String taskTrackerIdentity) { return new SelectSql(getSqlTemplate()) .select() .all() .from() .table(getTableName()) .where("task_tracker_identity = ?", taskTrackerIdentity) .list(RshHolder.JOB_PO_LIST_RSH); }
@Override public JobPo getJob(String jobId) { return new SelectSql(getSqlTemplate()) .select() .all() .from() .table(getTableName()) .where("job_id = ?", jobId) .single(RshHolder.JOB_PO_RSH); }
@Override public JobPo getJob(String taskTrackerNodeGroup, String taskId) { return new SelectSql(getSqlTemplate()) .select() .all() .from() .table(getTableName()) .where("task_id = ?", taskId) .and("task_tracker_node_group = ?", taskTrackerNodeGroup) .single(RshHolder.JOB_PO_RSH); }
@Override public JobPo getJob(String taskTrackerNodeGroup, String taskId) { return new SelectSql(getSqlTemplate()) .select() .all() .from() .table(getTableName()) .where("task_id = ?", taskId) .and("task_tracker_node_group = ?", taskTrackerNodeGroup) .single(RshHolder.JOB_PO_RSH); }
public MysqlExecutingJobQueue(Config config) { super(config); // create table createTable(readSqlFile("sql/mysql/lts_executing_job_queue.sql", getTableName())); }
@Override public boolean remove(String jobId) { return new DeleteSql(getSqlTemplate()) .delete() .from() .table(getTableName()) .where("job_id = ?", jobId) .doDelete() == 1; }
@Override public JobPo getJob(String jobId) { return new SelectSql(getSqlTemplate()) .select() .all() .from() .table(getTableName()) .where("job_id = ?", jobId) .single(RshHolder.JOB_PO_RSH); }
@Override public JobPo getJob(String taskTrackerNodeGroup, String taskId) { return new SelectSql(getSqlTemplate()) .select() .all() .from() .table(getTableName()) .where("task_id = ?", taskId) .and("task_tracker_node_group = ?", taskTrackerNodeGroup) .single(RshHolder.JOB_PO_RSH); }