@Override public boolean updateLastGenerateTriggerTime(String jobId, Long lastGenerateTriggerTime) { return new UpdateSql(getSqlTemplate()) .update() .table(getTableName()) .set("last_generate_trigger_time", lastGenerateTriggerTime) .set("gmt_modified", SystemClock.now()) .where("job_id = ? ", jobId) .doUpdate() == 1; }
public UpdateSql andOnNotNull(String condition, Object value) { if (value == null) { return this; } return and(condition, value); }
public UpdateSql orOnNotNull(String condition, Object value) { if (value == null) { return this; } return or(condition, value); }
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()); }
@Override public boolean selectiveUpdateByTaskId(JobQueueReq request) { Assert.hasLength(request.getRealTaskId(), "Only allow update by realTaskId and taskTrackerNodeGroup"); Assert.hasLength(request.getTaskTrackerNodeGroup(), "Only allow update by realTaskId and taskTrackerNodeGroup"); UpdateSql sql = buildUpdateSqlPrefix(request); return sql.where("real_task_id = ?", request.getRealTaskId()) .and("task_tracker_node_group = ?", request.getTaskTrackerNodeGroup()) .doUpdate() == 1; }
public int doUpdate() { String finalSQL = getSQL(); try { if (LOGGER.isDebugEnabled()) { LOGGER.debug(SQLFormatter.format(finalSQL)); } return sqlTemplate.update(finalSQL, params.toArray()); } catch (SQLException e) { throw new JdbcException("Update SQL Error:" + SQLFormatter.format(finalSQL), e); } }
public UpdateSql setOnNotNull(String column, Object value) { if (value == null) { return this; } return set(column, value); }
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()); }
@Override public boolean selectiveUpdateByTaskId(JobQueueReq request) { Assert.hasLength(request.getRealTaskId(), "Only allow update by realTaskId and taskTrackerNodeGroup"); Assert.hasLength(request.getTaskTrackerNodeGroup(), "Only allow update by realTaskId and taskTrackerNodeGroup"); UpdateSql sql = buildUpdateSqlPrefix(request); return sql.where("real_task_id = ?", request.getRealTaskId()) .and("task_tracker_node_group = ?", request.getTaskTrackerNodeGroup()) .doUpdate() == 1; }
public int doUpdate() { String finalSQL = getSQL(); try { if (LOGGER.isDebugEnabled()) { LOGGER.debug(SQLFormatter.format(finalSQL)); } return sqlTemplate.update(finalSQL, params.toArray()); } catch (SQLException e) { throw new JdbcException("Update SQL Error:" + SQLFormatter.format(finalSQL), e); } }
public UpdateSql setOnNotNull(String column, Object value) { if (value == null) { return this; } return set(column, value); }
@Override public boolean updateLastGenerateTriggerTime(String jobId, Long lastGenerateTriggerTime) { return new UpdateSql(getSqlTemplate()) .update() .table(getTableName()) .set("last_generate_trigger_time", lastGenerateTriggerTime) .set("gmt_modified", SystemClock.now()) .where("job_id = ? ", jobId) .doUpdate() == 1; }
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()); }
@Override public boolean selectiveUpdateByTaskId(JobQueueReq request) { Assert.hasLength(request.getRealTaskId(), "Only allow update by realTaskId and taskTrackerNodeGroup"); Assert.hasLength(request.getTaskTrackerNodeGroup(), "Only allow update by realTaskId and taskTrackerNodeGroup"); UpdateSql sql = buildUpdateSqlPrefix(request); return sql.where("real_task_id = ?", request.getRealTaskId()) .and("task_tracker_node_group = ?", request.getTaskTrackerNodeGroup()) .doUpdate() == 1; }
public UpdateSql orOnNotNull(String condition, Object value) { if (value == null) { return this; } return or(condition, value); }
public UpdateSql andOnNotNull(String condition, Object value) { if (value == null) { return this; } return and(condition, value); }
public int doUpdate() { String finalSQL = getSQL(); try { if (LOGGER.isDebugEnabled()) { LOGGER.debug(SQLFormatter.format(finalSQL)); } return sqlTemplate.update(finalSQL, params.toArray()); } catch (SQLException e) { throw new JdbcException("Update SQL Error:" + SQLFormatter.format(finalSQL), e); } }