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()))
                ;
    }
@author Robert HG (254963746@qq.com) on 5/21/15.
lts-core/src/main/java/com/github/ltsopensource/biz/logger/mysql/MysqlJobLogger.java