How to use findDistinctValuesOfColumn method of org.cerberus.servlet.crud.transversaltables.ReadEventHook class

Best Cerberus-source code snippet using org.cerberus.servlet.crud.transversaltables.ReadEventHook.findDistinctValuesOfColumn

Source:ReadEventHook.java

...99            if (request.getParameter("id") == null && Strings.isNullOrEmpty(columnName)) {100                answer = findParameterList(system1, appContext, userHasPermissions, request);101                jsonResponse = (JSONObject) answer.getItem();102            } else if (!Strings.isNullOrEmpty(columnName)) {103                answer = findDistinctValuesOfColumn(system1, appContext, request, columnName);104                jsonResponse = (JSONObject) answer.getItem();105            } else {106                answer = findParameterBySystemByKey(request.getParameter("id"), userHasPermissions, appContext, request);107                jsonResponse = (JSONObject) answer.getItem();108            }109            jsonResponse.put("messageType", answer.getResultMessage().getMessage().getCodeString());110            jsonResponse.put("message", answer.getResultMessage().getDescription());111            jsonResponse.put("sEcho", echo);112            response.getWriter().print(jsonResponse.toString());113        } catch (JSONException e) {114            LOG.warn(e);115            //returns a default error message with the json format that is able to be parsed by the client-side116            response.getWriter().print(AnswerUtil.createGenericErrorAnswer());117        }118    }119    /**120     * Handles the HTTP <code>GET</code> method.121     *122     * @param request servlet request123     * @param response servlet response124     * @throws ServletException if a servlet-specific error occurs125     * @throws IOException if an I/O error occurs126     */127    @Override128    protected void doGet(HttpServletRequest request, HttpServletResponse response)129            throws ServletException, IOException {130        try {131            processRequest(request, response);132        } catch (CerberusException ex) {133            LOG.warn(ex);134        }135    }136    /**137     * Handles the HTTP <code>POST</code> method.138     *139     * @param request servlet request140     * @param response servlet response141     * @throws ServletException if a servlet-specific error occurs142     * @throws IOException if an I/O error occurs143     */144    @Override145    protected void doPost(HttpServletRequest request, HttpServletResponse response)146            throws ServletException, IOException {147        try {148            processRequest(request, response);149        } catch (CerberusException ex) {150            LOG.warn(ex);151        }152    }153    private AnswerItem<JSONObject> findParameterList(String system1, ApplicationContext appContext, boolean userHasPermissions, HttpServletRequest request) throws JSONException {154        AnswerItem<JSONObject> item = new AnswerItem<>();155        JSONObject object = new JSONObject();156        eventHookService = appContext.getBean(EventHookService.class);157        int startPosition = Integer.valueOf(ParameterParserUtil.parseStringParam(request.getParameter("iDisplayStart"), "0"));158        int length = Integer.valueOf(ParameterParserUtil.parseStringParam(request.getParameter("iDisplayLength"), "0"));159        /*int sEcho  = Integer.valueOf(request.getParameter("sEcho"));*/160        String searchParameter = ParameterParserUtil.parseStringParam(request.getParameter("sSearch"), "");161        int columnToSortParameter = Integer.parseInt(ParameterParserUtil.parseStringParam(request.getParameter("iSortCol_0"), "2"));162        String sColumns = ParameterParserUtil.parseStringParam(request.getParameter("sColumns"), "para,valC,valS,descr");163        String columnToSort[] = sColumns.split(",");164        String columnName = columnToSort[columnToSortParameter];165        String sort = ParameterParserUtil.parseStringParam(request.getParameter("sSortDir_0"), "asc");166        List<String> individualLike = new ArrayList<>(Arrays.asList(ParameterParserUtil.parseStringParam(request.getParameter("sLike"), "").split(",")));167        Map<String, List<String>> individualSearch = new HashMap<>();168        for (int a = 0; a < columnToSort.length; a++) {169            if (null != request.getParameter("sSearch_" + a) && !request.getParameter("sSearch_" + a).isEmpty()) {170                List<String> search = new ArrayList<>(Arrays.asList(request.getParameter("sSearch_" + a).split(",")));171                if (individualLike.contains(columnToSort[a])) {172                    individualSearch.put(columnToSort[a] + ":like", search);173                } else {174                    individualSearch.put(columnToSort[a], search);175                }176            }177        }178        AnswerList<EventHook> resp = eventHookService.readByEventReferenceByCriteria(null, false, startPosition, length, columnName, sort, searchParameter, individualSearch);179        JSONArray jsonArray = new JSONArray();180        if (resp.isCodeEquals(MessageEventEnum.DATA_OPERATION_OK.getCode())) {//the service was able to perform the query, then we should get all values181            for (EventHook eventHook : resp.getDataList()) {182                JSONObject localParam = new JSONObject();183                localParam = eventHook.toJson();184                localParam.put("hasPermissionsUpdate", userHasPermissions);185                jsonArray.put(localParam);186            }187        }188        object.put("hasPermissions", userHasPermissions);189        object.put("contentTable", jsonArray);190        object.put("iTotalRecords", resp.getTotalRows());191        object.put("iTotalDisplayRecords", resp.getTotalRows());192        item.setItem(object);193        item.setResultMessage(resp.getResultMessage());194        return item;195    }196    private AnswerItem<JSONObject> findParameterBySystemByKey(String key, Boolean userHasPermissions, ApplicationContext appContext, HttpServletRequest request) throws JSONException {197        AnswerItem<JSONObject> item = new AnswerItem<>();198        JSONObject object = new JSONObject();199        eventHookService = appContext.getBean(EventHookService.class);200        AnswerItem answer = eventHookService.readByKey(Integer.valueOf(key));201        EventHook p = null;202        if (answer.isCodeEquals(MessageEventEnum.DATA_OPERATION_OK.getCode())) {//the service was able to perform the query, then we should get all values203            p = (EventHook) answer.getItem();204            JSONObject localParam = new JSONObject();205            localParam = p.toJson();206            localParam.put("hasPermissionsUpdate", userHasPermissions);207            object.put("contentTable", localParam);208        }209        object.put("hasPermissions", userHasPermissions);210        item.setItem(object);211        item.setResultMessage(answer.getResultMessage());212        return item;213    }214    private AnswerItem<JSONObject> findDistinctValuesOfColumn(String system, ApplicationContext appContext, HttpServletRequest request, String columnName) throws JSONException {215        AnswerItem<JSONObject> answer = new AnswerItem<>();216        JSONObject object = new JSONObject();217        eventHookService = appContext.getBean(IEventHookService.class);218        String searchParameter = ParameterParserUtil.parseStringParam(request.getParameter("sSearch"), "");219        String sColumns = ParameterParserUtil.parseStringParam(request.getParameter("sColumns"), "para,valC,valS,descr");220        String columnToSort[] = sColumns.split(",");221        List<String> individualLike = new ArrayList<>(Arrays.asList(ParameterParserUtil.parseStringParam(request.getParameter("sLike"), "").split(",")));222        Map<String, List<String>> individualSearch = new HashMap<>();223        for (int a = 0; a < columnToSort.length; a++) {224            if (null != request.getParameter("sSearch_" + a) && !request.getParameter("sSearch_" + a).isEmpty()) {225                List<String> search = new ArrayList<>(Arrays.asList(request.getParameter("sSearch_" + a).split(",")));226                if (individualLike.contains(columnToSort[a])) {227                    individualSearch.put(columnToSort[a] + ":like", search);228                } else {...

findDistinctValuesOfColumn

Using AI Code Generation

1distinctValues = findDistinctValuesOfColumn("Country");2distinctValues = findDistinctValuesOfColumn("Country", "Browser", "Chrome");3distinctValues = findDistinctValuesOfColumn("Country", "Browser", "Chrome");4distinctValues = findDistinctValuesOfColumn("Country", "Browser", "Chrome");5distinctValues = findDistinctValuesOfColumn("Country", "Browser", "Chrome");6distinctValues = findDistinctValuesOfColumn("Country", "Browser", "Chrome");7distinctValues = findDistinctValuesOfColumn("Country", "Browser", "Chrome");8distinctValues = findDistinctValuesOfColumn("Country", "Browser", "Chrome");9distinctValues = findDistinctValuesOfColumn("Country", "Browser", "Chrome");10distinctValues = findDistinctValuesOfColumn("Country", "Browser", "Chrome");

Automation Testing Tutorials

Learn to execute automation testing from scratch with LambdaTest Learning Hub. Right from setting up the prerequisites to run your first automation test, to following best practices and diving deeper into advanced test scenarios. LambdaTest Learning Hubs compile a list of step-by-step guides to help you be proficient with different test automation frameworks i.e. Selenium, Cypress, TestNG etc.