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" ); }
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" ); }
.insert(getTableName()) .columns("gmt_created", "node_group",
@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(); }
.insert(getTableName()) .columns("gmt_created", "node_group",
.insert(getTableName()) .columns("gmt_created", "node_group",
@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(); }
.insert(getTableName()) .columns("gmt_created", "node_group",
@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 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(); }
.insert(getTableName()) .columns("gmt_created", "identity",
.insert(getTableName()) .columns("gmt_created", "identity",
.insert(getTableName()) .columns("gmt_created", "identity",
.insert(getTableName()) .columns("gmt_created", "identity",
protected boolean add(String tableName, JobPo jobPo) { return new InsertSql(getSqlTemplate()) .insert(tableName) .columns("job_id", "job_type",
protected boolean add(String tableName, JobPo jobPo) { return new InsertSql(getSqlTemplate()) .insert(tableName) .columns("job_id", "job_type",
.insert(getTableName()) .columns("gmt_created", "identity",
.insert(getTableName()) .columns("gmt_created", "identity",
@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(); }
@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(); }