private WhereSql buildWhereSql(JobQueueReq request) { return new WhereSql() .andOnNotEmpty("job_id = ?", request.getJobId()) .andOnNotEmpty("task_id = ?", request.getTaskId()) .andOnNotEmpty("real_task_id = ?", request.getRealTaskId()) .andOnNotEmpty("task_tracker_node_group = ?", request.getTaskTrackerNodeGroup()) .andOnNotEmpty("job_type = ?", request.getJobType()) .andOnNotEmpty("submit_node_group = ?", request.getSubmitNodeGroup()) .andOnNotNull("need_feedback = ?", request.getNeedFeedback()) .andBetween("gmt_created", JdbcTypeUtils.toTimestamp(request.getStartGmtCreated()), JdbcTypeUtils.toTimestamp(request.getEndGmtCreated())) .andBetween("gmt_modified", JdbcTypeUtils.toTimestamp(request.getStartGmtModified()), JdbcTypeUtils.toTimestamp(request.getEndGmtModified())); }
private WhereSql buildWhereSql(JobQueueReq request) { return new WhereSql() .andOnNotEmpty("job_id = ?", request.getJobId()) .andOnNotEmpty("task_id = ?", request.getTaskId()) .andOnNotEmpty("real_task_id = ?", request.getRealTaskId()) .andOnNotEmpty("task_tracker_node_group = ?", request.getTaskTrackerNodeGroup()) .andOnNotEmpty("job_type = ?", request.getJobType()) .andOnNotEmpty("submit_node_group = ?", request.getSubmitNodeGroup()) .andOnNotNull("need_feedback = ?", request.getNeedFeedback()) .andBetween("gmt_created", JdbcTypeUtils.toTimestamp(request.getStartGmtCreated()), JdbcTypeUtils.toTimestamp(request.getEndGmtCreated())) .andBetween("gmt_modified", JdbcTypeUtils.toTimestamp(request.getStartGmtModified()), JdbcTypeUtils.toTimestamp(request.getEndGmtModified())); }
private WhereSql buildWhereSql(JobLoggerRequest request) { return new WhereSql() .andOnNotEmpty("task_id = ?", request.getTaskId()) .andOnNotEmpty("real_task_id = ?", request.getRealTaskId()) .andOnNotEmpty("task_tracker_node_group = ?", request.getTaskTrackerNodeGroup()) .andOnNotEmpty("log_type = ?", request.getLogType()) .andOnNotEmpty("level = ?", request.getLevel()) .andOnNotEmpty("success = ?", request.getSuccess()) .andBetween("log_time", JdbcTypeUtils.toTimestamp(request.getStartLogTime()), JdbcTypeUtils.toTimestamp(request.getEndLogTime())) ; }
private WhereSql buildWhereSql(JobLoggerRequest request) { return new WhereSql() .andOnNotEmpty("task_id = ?", request.getTaskId()) .andOnNotEmpty("real_task_id = ?", request.getRealTaskId()) .andOnNotEmpty("task_tracker_node_group = ?", request.getTaskTrackerNodeGroup()) .andOnNotEmpty("log_type = ?", request.getLogType()) .andOnNotEmpty("level = ?", request.getLevel()) .andOnNotEmpty("success = ?", request.getSuccess()) .andBetween("log_time", JdbcTypeUtils.toTimestamp(request.getStartLogTime()), JdbcTypeUtils.toTimestamp(request.getEndLogTime())) ; }
private UpdateSql buildUpdateSqlPrefix(JobQueueReq request) { return new UpdateSql(getSqlTemplate()) .update() .table(getTableName(request)) .setOnNotNull("cron_expression", request.getCronExpression()) .setOnNotNull("need_feedback", request.getNeedFeedback()) .setOnNotNull("ext_params", JSON.toJSONString(request.getExtParams())) .setOnNotNull("trigger_time", JdbcTypeUtils.toTimestamp(request.getTriggerTime())) .setOnNotNull("priority", request.getPriority()) .setOnNotNull("max_retry_times", request.getMaxRetryTimes()) .setOnNotNull("rely_on_prev_cycle", request.getRelyOnPrevCycle() == null ? true : request.getRelyOnPrevCycle()) .setOnNotNull("submit_node_group", request.getSubmitNodeGroup()) .setOnNotNull("task_tracker_node_group", request.getTaskTrackerNodeGroup()) .setOnNotNull("repeat_count", request.getRepeatCount()) .setOnNotNull("repeat_interval", request.getRepeatInterval()) .setOnNotNull("gmt_modified", SystemClock.now()); }
private UpdateSql buildUpdateSqlPrefix(JobQueueReq request) { return new UpdateSql(getSqlTemplate()) .update() .table(getTableName(request)) .setOnNotNull("cron_expression", request.getCronExpression()) .setOnNotNull("need_feedback", request.getNeedFeedback()) .setOnNotNull("ext_params", JSON.toJSONString(request.getExtParams())) .setOnNotNull("trigger_time", JdbcTypeUtils.toTimestamp(request.getTriggerTime())) .setOnNotNull("priority", request.getPriority()) .setOnNotNull("max_retry_times", request.getMaxRetryTimes()) .setOnNotNull("rely_on_prev_cycle", request.getRelyOnPrevCycle() == null ? true : request.getRelyOnPrevCycle()) .setOnNotNull("submit_node_group", request.getSubmitNodeGroup()) .setOnNotNull("task_tracker_node_group", request.getTaskTrackerNodeGroup()) .setOnNotNull("repeat_count", request.getRepeatCount()) .setOnNotNull("repeat_interval", request.getRepeatInterval()) .setOnNotNull("gmt_modified", SystemClock.now()); }
private WhereSql buildWhereSql(JobLoggerRequest request) { return new WhereSql() .andOnNotEmpty("task_id = ?", request.getTaskId()) .andOnNotEmpty("real_task_id = ?", request.getRealTaskId()) .andOnNotEmpty("task_tracker_node_group = ?", request.getTaskTrackerNodeGroup()) .andBetween("log_time", JdbcTypeUtils.toTimestamp(request.getStartLogTime()), JdbcTypeUtils.toTimestamp(request.getEndLogTime())) ; }
private WhereSql buildWhereSql(JobQueueReq request) { return new WhereSql() .andOnNotEmpty("job_id = ?", request.getJobId()) .andOnNotEmpty("task_id = ?", request.getTaskId()) .andOnNotEmpty("real_task_id = ?", request.getRealTaskId()) .andOnNotEmpty("task_tracker_node_group = ?", request.getTaskTrackerNodeGroup()) .andOnNotEmpty("job_type = ?", request.getJobType()) .andOnNotEmpty("submit_node_group = ?", request.getSubmitNodeGroup()) .andOnNotNull("need_feedback = ?", request.getNeedFeedback()) .andBetween("gmt_created", JdbcTypeUtils.toTimestamp(request.getStartGmtCreated()), JdbcTypeUtils.toTimestamp(request.getEndGmtCreated())) .andBetween("gmt_modified", JdbcTypeUtils.toTimestamp(request.getStartGmtModified()), JdbcTypeUtils.toTimestamp(request.getEndGmtModified())); }
private UpdateSql buildUpdateSqlPrefix(JobQueueReq request) { return new UpdateSql(getSqlTemplate()) .update() .table(getTableName(request)) .setOnNotNull("cron_expression", request.getCronExpression()) .setOnNotNull("need_feedback", request.getNeedFeedback()) .setOnNotNull("ext_params", JSON.toJSONString(request.getExtParams())) .setOnNotNull("trigger_time", JdbcTypeUtils.toTimestamp(request.getTriggerTime())) .setOnNotNull("priority", request.getPriority()) .setOnNotNull("max_retry_times", request.getMaxRetryTimes()) .setOnNotNull("rely_on_prev_cycle", request.getRelyOnPrevCycle() == null ? true : request.getRelyOnPrevCycle()) .setOnNotNull("submit_node_group", request.getSubmitNodeGroup()) .setOnNotNull("task_tracker_node_group", request.getTaskTrackerNodeGroup()) .setOnNotNull("repeat_count", request.getRepeatCount()) .setOnNotNull("repeat_interval", request.getRepeatInterval()) .setOnNotNull("gmt_modified", SystemClock.now()); }