How to use findDistinctValuesOfColumn method of org.cerberus.servlet.crud.countryenvironment.ReadDeployType class

Best Cerberus-source code snippet using org.cerberus.servlet.crud.countryenvironment.ReadDeployType.findDistinctValuesOfColumn

Source:ReadDeployType.java

...94        AnswerItem answer = new AnswerItem(msg);95        try {96            JSONObject jsonResponse = new JSONObject();97            if (!columnName.isEmpty()) {98                answer = findDistinctValuesOfColumn(appContext, request, columnName);99                jsonResponse = (JSONObject) answer.getItem();100            } else if (request.getParameter("deploytype") == null) {101                answer = findDeployTypeList(appContext, userHasPermissions, request);102                jsonResponse = (JSONObject) answer.getItem();103            } else {104                String deployType = policy.sanitize(request.getParameter("deploytype"));105                answer = findDeployTypeByID(deployType, appContext, userHasPermissions);106                jsonResponse = (JSONObject) answer.getItem();107            }108            jsonResponse.put("messageType", answer.getResultMessage().getMessage().getCodeString());109            jsonResponse.put("message", answer.getResultMessage().getDescription());110            jsonResponse.put("sEcho", echo);111            response.getWriter().print(jsonResponse.toString());112        } catch (JSONException e) {113            LOG.warn(e);114            //returns a default error message with the json format that is able to be parsed by the client-side115            response.getWriter().print(AnswerUtil.createGenericErrorAnswer());116        }117    }118    // <editor-fold defaultstate="collapsed" desc="HttpServlet methods. Click on the + sign on the left to edit the code.">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    /**154     * Returns a short description of the servlet.155     *156     * @return a String containing servlet description157     */158    @Override159    public String getServletInfo() {160        return "Short description";161    }// </editor-fold>162    private AnswerItem findDeployTypeList(ApplicationContext appContext, boolean userHasPermissions, HttpServletRequest request) throws JSONException {163        AnswerItem item = new AnswerItem();164        JSONObject object = new JSONObject();165        deployTypeService = appContext.getBean(DeployTypeService.class);166        int startPosition = Integer.valueOf(ParameterParserUtil.parseStringParam(request.getParameter("iDisplayStart"), "0"));167        int length = Integer.valueOf(ParameterParserUtil.parseStringParam(request.getParameter("iDisplayLength"), "0"));168        String searchParameter = ParameterParserUtil.parseStringParam(request.getParameter("sSearch"), "");169        int columnToSortParameter = Integer.parseInt(ParameterParserUtil.parseStringParam(request.getParameter("iSortCol_0"), "0"));170        String sColumns = ParameterParserUtil.parseStringParam(request.getParameter("sColumns"), "deploytype,description");171        String columnToSort[] = sColumns.split(",");172        String columnName = columnToSort[columnToSortParameter];173        String sort = ParameterParserUtil.parseStringParam(request.getParameter("sSortDir_0"), "asc");174        List<String> individualLike = new ArrayList(Arrays.asList(ParameterParserUtil.parseStringParam(request.getParameter("sLike"),"").split(",")));175        Map<String, List<String>> individualSearch = new HashMap<String, List<String>>();176        for (int a = 0; a < columnToSort.length; a++) {177            if (null != request.getParameter("sSearch_" + a) && !request.getParameter("sSearch_" + a).isEmpty()) {178                List<String> search = new ArrayList(Arrays.asList(request.getParameter("sSearch_" + a).split(",")));179                if(individualLike.contains(columnToSort[a])) {180                	individualSearch.put(columnToSort[a]+":like", search);181                }else {182                	individualSearch.put(columnToSort[a], search);183                }            184            }185        }186        AnswerList resp = deployTypeService.readByCriteria(startPosition, length, columnName, sort, searchParameter, individualSearch);187        JSONArray jsonArray = new JSONArray();188        if (resp.isCodeEquals(MessageEventEnum.DATA_OPERATION_OK.getCode())) {  //the service was able to perform the query, then we should get all values189            for (DeployType deploytype : (List<DeployType>) resp.getDataList()) {190                jsonArray.put(convertDeployTypeToJSONObject(deploytype));191            }192        }193        object.put("hasPermissions", userHasPermissions);194        object.put("contentTable", jsonArray);195        object.put("iTotalRecords", resp.getTotalRows());196        object.put("iTotalDisplayRecords", resp.getTotalRows());197        item.setItem(object);198        item.setResultMessage(resp.getResultMessage());199        return item;200    }201    private AnswerItem findDeployTypeByID(String id, ApplicationContext appContext, boolean userHasPermissions) throws JSONException, CerberusException {202        AnswerItem item = new AnswerItem();203        JSONObject object = new JSONObject();204        IDeployTypeService libService = appContext.getBean(IDeployTypeService.class);205        //finds the Deploy Type206        AnswerItem answer = libService.readByKey(id);207        if (answer.isCodeEquals(MessageEventEnum.DATA_OPERATION_OK.getCode())) {208            //if the service returns an OK message then we can get the item and convert it to JSONformat209            DeployType lib = (DeployType) answer.getItem();210            JSONObject response = convertDeployTypeToJSONObject(lib);211            object.put("contentTable", response);212        }213        object.put("hasPermissions", userHasPermissions);214        item.setItem(object);215        item.setResultMessage(answer.getResultMessage());216        return item;217    }218    private JSONObject convertDeployTypeToJSONObject(DeployType deployType) throws JSONException {219        Gson gson = new Gson();220        JSONObject result = new JSONObject(gson.toJson(deployType));221        return result;222    }223    private AnswerItem findDistinctValuesOfColumn(ApplicationContext appContext, HttpServletRequest request, String columnName) throws JSONException {224        AnswerItem answer = new AnswerItem();225        JSONObject object = new JSONObject();226        deployTypeService = appContext.getBean(IDeployTypeService.class);227        228        String searchParameter = ParameterParserUtil.parseStringParam(request.getParameter("sSearch"), "");229        String sColumns = ParameterParserUtil.parseStringParam(request.getParameter("sColumns"), "test,testcase,application,project,ticket,description,behaviororvalueexpected,readonly,bugtrackernewurl,deploytype,mavengroupid");230        String columnToSort[] = sColumns.split(",");231        List<String> individualLike = new ArrayList(Arrays.asList(ParameterParserUtil.parseStringParam(request.getParameter("sLike"), "").split(",")));232        Map<String, List<String>> individualSearch = new HashMap<>();233        for (int a = 0; a < columnToSort.length; a++) {234            if (null != request.getParameter("sSearch_" + a) && !request.getParameter("sSearch_" + a).isEmpty()) {235            	List<String> search = new ArrayList(Arrays.asList(request.getParameter("sSearch_" + a).split(",")));236            	if(individualLike.contains(columnToSort[a])) {237                	individualSearch.put(columnToSort[a]+":like", search);...

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.