@Override public long getCount(String jobClientNodeGroup) { return ((Long) new SelectSql(getSqlTemplate()) .select() .columns("count(1)") .from() .table(getTableName(jobClientNodeGroup)) .single()).intValue(); }
@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 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 protected JobPo getJob(String taskTrackerNodeGroup, String jobId) { return new SelectSql(sqlTemplate) .select() .all() .from() .table(getTableName(taskTrackerNodeGroup)) .where("job_id = ?", jobId) .and("task_tracker_node_group = ?", taskTrackerNodeGroup) .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 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); }
@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 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 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()) .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); }
@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 List<NodeGroupPo> getNodeGroup(NodeType nodeType) { return new SelectSql(getSqlTemplate()) .select() .all() .from() .table(getTableName()) .where("node_type = ?", nodeType.name()) .list(RshHolder.NODE_GROUP_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); }