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())) ; }
public WhereSql andOnNotNull(String condition, Object value) { if (value == null) { return this; } return and(condition, value); }
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())); }
.table(getTableName()) .whereSql( new WhereSql() .andOnNotNull("node_type = ?", request.getNodeType() == null ? null : request.getNodeType().name()) .andOnNotEmpty("name = ?", request.getNodeGroup()) .table(getTableName()) .whereSql( new WhereSql() .andOnNotNull("node_type = ?", request.getNodeType() == null ? null : request.getNodeType().name()) .andOnNotEmpty("name = ?", request.getNodeGroup())
public WhereSql orOnNotNull(String condition, Object value) { if (value == null) { return this; } return or(condition, value); }
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())); }
.table(getTableName()) .whereSql( new WhereSql() .andOnNotNull("node_type = ?", request.getNodeType() == null ? null : request.getNodeType().name()) .andOnNotEmpty("name = ?", request.getNodeGroup()) .table(getTableName()) .whereSql( new WhereSql() .andOnNotNull("node_type = ?", request.getNodeType() == null ? null : request.getNodeType().name()) .andOnNotEmpty("name = ?", request.getNodeGroup())
public WhereSql orOnNotNull(String condition, Object value) { if (value == null) { return this; } return or(condition, value); }
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())) ; }
.table(getTableName()) .whereSql( new WhereSql() .andOnNotNull("node_type = ?", request.getNodeType() == null ? null : request.getNodeType().name()) .andOnNotEmpty("name = ?", request.getNodeGroup()) .table(getTableName()) .whereSql( new WhereSql() .andOnNotNull("node_type = ?", request.getNodeType() == null ? null : request.getNodeType().name()) .andOnNotEmpty("name = ?", request.getNodeGroup())
public WhereSql orOnNotEmpty(String condition, String value) { if (StringUtils.isEmpty(value)) { return this; } return or(condition, value); }
public WhereSql andOnNotNull(String condition, Object value) { if (value == null) { return this; } return and(condition, value); }
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())) ; }
public WhereSql orOnNotEmpty(String condition, String value) { if (StringUtils.isEmpty(value)) { return this; } return or(condition, value); }
public WhereSql andOnNotEmpty(String condition, String value) { if (StringUtils.isEmpty(value)) { return this; } return and(condition, value); }