private WhereSql buildWhereSql(NodePaginationReq request) {
        return new WhereSql()
                .andOnNotEmpty("identity = ?", request.getIdentity())
                .andOnNotEmpty("node_group = ?", request.getNodeGroup())
                .andOnNotNull("node_type = ?", request.getNodeType() == null ? null : request.getNodeType().name())
                .andOnNotEmpty("ip = ?", request.getIp())
                .andOnNotNull("available = ?", request.getAvailable())
                .andBetween("create_time", JdbcTypeUtils.toTimestamp(request.getStartDate()), JdbcTypeUtils.toTimestamp(request.getEndDate()));
    }
@author Robert HG (254963746@qq.com) on 6/6/15.
lts-admin/src/main/java/com/github/ltsopensource/admin/access/memory/NodeMemCacheAccess.java