InsertSql insertSql = new InsertSql(getSqlTemplate()) .insert(getTableName()) .columns("gmt_created", "node_group", "identity", insertSql.values( taskTrackerMDataPo.getGmtCreated(), taskTrackerMDataPo.getNodeGroup(), insertSql.doBatchInsert();
@Override public void addNodeGroup(NodeType nodeType, String name) { Long count = new SelectSql(getSqlTemplate()) .select() .columns("count(1)") .from() .table(getTableName()) .where("node_type = ?", nodeType.name()) .and("name = ?", name) .single(); if (count > 0) { // already exist return; } new InsertSql(getSqlTemplate()) .insert(getTableName()) .columns("node_type", "name", "gmt_created") .values(nodeType.name(), name, SystemClock.now()) .doInsert(); }
@Override public boolean add(List<JobFeedbackPo> jobFeedbackPos) { if (CollectionUtils.isEmpty(jobFeedbackPos)) { return true; } // insert ignore duplicate record for (JobFeedbackPo jobFeedbackPo : jobFeedbackPos) { String jobClientNodeGroup = jobFeedbackPo.getJobRunResult().getJobMeta().getJob().getSubmitNodeGroup(); new InsertSql(getSqlTemplate()) .insertIgnore(getTableName(jobClientNodeGroup)) .columns("gmt_created", "job_result") .values(jobFeedbackPo.getGmtCreated(), JSON.toJSONString(jobFeedbackPo.getJobRunResult())) .doInsert(); } return true; }
private InsertSql buildInsertSql() { return new InsertSql(getSqlTemplate()) .insert(getTableName()) .columns("log_time", "gmt_created", "log_type", "success", "msg", "task_tracker_identity", "level", "task_id", "real_task_id", "job_id", "job_type", "priority", "submit_node_group", "task_tracker_node_group", "ext_params", "internal_ext_params", "need_feedback", "cron_expression", "trigger_time", "retry_times", "max_retry_times", "rely_on_prev_cycle", "repeat_count", "repeated_count", "repeat_interval" ); }
@Override public void log(List<JobLogPo> jobLogPos) { if (CollectionUtils.isEmpty(jobLogPos)) { return; } InsertSql insertSql = buildInsertSql(); for (JobLogPo jobLogPo : jobLogPos) { setInsertSqlValues(insertSql, jobLogPo); } insertSql.doBatchInsert(); }
private InsertSql setInsertSqlValues(InsertSql insertSql, JobLogPo jobLogPo) { return insertSql.values(jobLogPo.getLogTime(), jobLogPo.getGmtCreated(), jobLogPo.getLogType().name(), jobLogPo.isSuccess(), jobLogPo.getMsg(), jobLogPo.getTaskTrackerIdentity(), jobLogPo.getLevel().name(), jobLogPo.getTaskId(), jobLogPo.getRealTaskId(), jobLogPo.getJobId(), jobLogPo.getJobType() == null ? null : jobLogPo.getJobType().name(), jobLogPo.getPriority(), jobLogPo.getSubmitNodeGroup(), jobLogPo.getTaskTrackerNodeGroup(), JSON.toJSONString(jobLogPo.getExtParams()), JSON.toJSONString(jobLogPo.getInternalExtParams()), jobLogPo.isNeedFeedback(), jobLogPo.getCronExpression(), jobLogPo.getTriggerTime(), jobLogPo.getRetryTimes(), jobLogPo.getMaxRetryTimes(), jobLogPo.getDepPreCycle(), jobLogPo.getRepeatCount(), jobLogPo.getRepeatedCount(), jobLogPo.getRepeatInterval()); }
@Override public void log(JobLogPo jobLogPo) { if (jobLogPo == null) { return; } InsertSql insertSql = buildInsertSql(); setInsertSqlValues(insertSql, jobLogPo).doInsert(); }
private InsertSql buildInsertSql() { return new InsertSql(getSqlTemplate()) .insert(getTableName()) .columns("log_time", "gmt_created", "log_type", "success", "msg", "task_tracker_identity", "level", "task_id", "real_task_id", "job_id", "job_type", "priority", "submit_node_group", "task_tracker_node_group", "ext_params", "internal_ext_params", "need_feedback", "cron_expression", "trigger_time", "retry_times", "max_retry_times", "rely_on_prev_cycle", "repeat_count", "repeated_count", "repeat_interval" ); }
@Override public void log(List<JobLogPo> jobLogPos) { if (CollectionUtils.isEmpty(jobLogPos)) { return; } InsertSql insertSql = buildInsertSql(); for (JobLogPo jobLogPo : jobLogPos) { setInsertSqlValues(insertSql, jobLogPo); } insertSql.doBatchInsert(); }
private InsertSql setInsertSqlValues(InsertSql insertSql, JobLogPo jobLogPo) { return insertSql.values(jobLogPo.getLogTime(), jobLogPo.getGmtCreated(), jobLogPo.getLogType().name(), jobLogPo.isSuccess(), jobLogPo.getMsg(), jobLogPo.getTaskTrackerIdentity(), jobLogPo.getLevel().name(), jobLogPo.getTaskId(), jobLogPo.getRealTaskId(), jobLogPo.getJobId(), jobLogPo.getJobType() == null ? null : jobLogPo.getJobType().name(), jobLogPo.getPriority(), jobLogPo.getSubmitNodeGroup(), jobLogPo.getTaskTrackerNodeGroup(), JSON.toJSONString(jobLogPo.getExtParams()), JSON.toJSONString(jobLogPo.getInternalExtParams()), jobLogPo.isNeedFeedback(), jobLogPo.getCronExpression(), jobLogPo.getTriggerTime(), jobLogPo.getRetryTimes(), jobLogPo.getMaxRetryTimes(), jobLogPo.getDepPreCycle(), jobLogPo.getRepeatCount(), jobLogPo.getRepeatedCount(), jobLogPo.getRepeatInterval()); }
@Override public void log(JobLogPo jobLogPo) { if (jobLogPo == null) { return; } InsertSql insertSql = buildInsertSql(); setInsertSqlValues(insertSql, jobLogPo).doInsert(); }
return; InsertSql insertSql = new InsertSql(getSqlTemplate()) .insert(getTableName()) .columns("gmt_created", "node_group", "identity", insertSql.values( jobClientMDataPo.getGmtCreated(), jobClientMDataPo.getNodeGroup(), ); insertSql.doBatchInsert();
@Override public void addNodeGroup(NodeType nodeType, String name) { Long count = new SelectSql(getSqlTemplate()) .select() .columns("count(1)") .from() .table(getTableName()) .where("node_type = ?", nodeType.name()) .and("name = ?", name) .single(); if (count > 0) { // already exist return; } new InsertSql(getSqlTemplate()) .insert(getTableName()) .columns("node_type", "name", "gmt_created") .values(nodeType.name(), name, SystemClock.now()) .doInsert(); }
@Override public boolean add(List<JobFeedbackPo> jobFeedbackPos) { if (CollectionUtils.isEmpty(jobFeedbackPos)) { return true; } // insert ignore duplicate record for (JobFeedbackPo jobFeedbackPo : jobFeedbackPos) { String jobClientNodeGroup = jobFeedbackPo.getJobRunResult().getJobMeta().getJob().getSubmitNodeGroup(); new InsertSql(getSqlTemplate()) .insertIgnore(getTableName(jobClientNodeGroup)) .columns("gmt_created", "job_result") .values(jobFeedbackPo.getGmtCreated(), JSON.toJSONString(jobFeedbackPo.getJobRunResult())) .doInsert(); } return true; }
private InsertSql buildInsertSql() { return new InsertSql(getSqlTemplate()) .insert(getTableName()) .columns("log_time", "gmt_created", "log_type", "success", "msg", "task_tracker_identity", "level", "task_id", "real_task_id", "job_id", "job_type", "priority", "submit_node_group", "task_tracker_node_group", "ext_params", "internal_ext_params", "need_feedback", "cron_expression", "trigger_time", "retry_times", "max_retry_times", "rely_on_prev_cycle", "repeat_count", "repeated_count", "repeat_interval" ); }
@Override public void log(List<JobLogPo> jobLogPos) { if (CollectionUtils.isEmpty(jobLogPos)) { return; } InsertSql insertSql = buildInsertSql(); for (JobLogPo jobLogPo : jobLogPos) { setInsertSqlValues(insertSql, jobLogPo); } insertSql.doBatchInsert(); }
private InsertSql setInsertSqlValues(InsertSql insertSql, JobLogPo jobLogPo) { return insertSql.values(jobLogPo.getLogTime(), jobLogPo.getGmtCreated(), jobLogPo.getLogType().name(), jobLogPo.isSuccess(), jobLogPo.getMsg(), jobLogPo.getTaskTrackerIdentity(), jobLogPo.getLevel().name(), jobLogPo.getTaskId(), jobLogPo.getRealTaskId(), jobLogPo.getJobId(), jobLogPo.getJobType() == null ? null : jobLogPo.getJobType().name(), jobLogPo.getPriority(), jobLogPo.getSubmitNodeGroup(), jobLogPo.getTaskTrackerNodeGroup(), JSON.toJSONString(jobLogPo.getExtParams()), JSON.toJSONString(jobLogPo.getInternalExtParams()), jobLogPo.isNeedFeedback(), jobLogPo.getCronExpression(), jobLogPo.getTriggerTime(), jobLogPo.getRetryTimes(), jobLogPo.getMaxRetryTimes(), jobLogPo.getDepPreCycle(), jobLogPo.getRepeatCount(), jobLogPo.getRepeatedCount(), jobLogPo.getRepeatInterval()); }
@Override public void log(JobLogPo jobLogPo) { if (jobLogPo == null) { return; } InsertSql insertSql = buildInsertSql(); setInsertSqlValues(insertSql, jobLogPo).doInsert(); }
@Override public void insert(List<JobTrackerMDataPo> jobTrackerMDataPos) { InsertSql insertSql = new InsertSql(getSqlTemplate()) .insert(getTableName()) .columns("gmt_created", "identity", "timestamp", "receive_job_num", "push_job_num", "exe_success_num", "exe_failed_num", "exe_later_num", "exe_exception_num", "fix_executing_job_num"); for (JobTrackerMDataPo jobTrackerMDataPo : jobTrackerMDataPos) { insertSql.values( jobTrackerMDataPo.getGmtCreated(), jobTrackerMDataPo.getIdentity(), jobTrackerMDataPo.getTimestamp(), jobTrackerMDataPo.getReceiveJobNum(), jobTrackerMDataPo.getPushJobNum(), jobTrackerMDataPo.getExeSuccessNum(), jobTrackerMDataPo.getExeFailedNum(), jobTrackerMDataPo.getExeLaterNum(), jobTrackerMDataPo.getExeExceptionNum(), jobTrackerMDataPo.getFixExecutingJobNum() ); } insertSql.doBatchInsert(); }
protected boolean add(String tableName, JobPo jobPo) { return new InsertSql(getSqlTemplate()) .insert(tableName) .columns("job_id", "job_type", "priority", "repeated_count", "repeat_interval") .values(jobPo.getJobId(), jobPo.getJobType() == null ? null : jobPo.getJobType().name(), jobPo.getPriority(), jobPo.getRepeatedCount(), jobPo.getRepeatInterval()) .doInsert() == 1;