Unlock 30% off on Manual Testing Annual Plans this Holiday Season.

Copied to Clipboard!

How to use findDistinctValuesOfColumn method of org.cerberus.servlet.crud.testcampaign.ReadCampaign class

Best Cerberus-source code snippet using org.cerberus.servlet.crud.testcampaign.ReadCampaign.findDistinctValuesOfColumn

Source:ReadCampaign.java

...87            if (request.getParameter("campaign") == null && Strings.isNullOrEmpty(columnName)) {88                answer = findCampaignList(userHasPermissions, appContext, request);89                jsonResponse = (JSONObject) answer.getItem();90            } else if (!Strings.isNullOrEmpty(columnName)) {91                answer = findDistinctValuesOfColumn(appContext, request, columnName);92                jsonResponse = (JSONObject) answer.getItem();93            } else {94                answer = findCampaignByKey(request.getParameter("campaign"), userHasPermissions, appContext, request);95                jsonResponse = (JSONObject) answer.getItem();96            }97            jsonResponse.put("messageType", answer.getResultMessage().getMessage().getCodeString());98            jsonResponse.put("message", answer.getResultMessage().getDescription());99            response.getWriter().print(jsonResponse.toString());100        } catch (JSONException ex) {101            LOG.warn(ex);102            //returns a default error message with the json format that is able to be parsed by the client-side103            response.getWriter().print(AnswerUtil.createGenericErrorAnswer());104        }105    }106    // <editor-fold defaultstate="collapsed" desc="HttpServlet methods. Click on the + sign on the left to edit the code.">107    /**108     * Handles the HTTP <code>GET</code> method.109     *110     * @param request servlet request111     * @param response servlet response112     * @throws ServletException if a servlet-specific error occurs113     * @throws IOException if an I/O error occurs114     */115    @Override116    protected void doGet(HttpServletRequest request, HttpServletResponse response)117            throws ServletException, IOException {118        processRequest(request, response);119    }120    /**121     * Handles the HTTP <code>POST</code> method.122     *123     * @param request servlet request124     * @param response servlet response125     * @throws ServletException if a servlet-specific error occurs126     * @throws IOException if an I/O error occurs127     */128    @Override129    protected void doPost(HttpServletRequest request, HttpServletResponse response)130            throws ServletException, IOException {131        processRequest(request, response);132    }133    /**134     * Returns a short description of the servlet.135     *136     * @return a String containing servlet description137     */138    @Override139    public String getServletInfo() {140        return "Short description";141    }// </editor-fold>142    private AnswerItem<JSONObject> findCampaignList(Boolean userHasPermissions, ApplicationContext appContext, HttpServletRequest request) throws JSONException {143        AnswerItem<JSONObject> item = new AnswerItem<>();144        AnswerList<Campaign> answer = new AnswerList<>();145        JSONObject resp = new JSONObject();146        int startPosition = Integer.valueOf(ParameterParserUtil.parseStringParam(request.getParameter("iDisplayStart"), "0"));147        int length = Integer.valueOf(ParameterParserUtil.parseStringParam(request.getParameter("iDisplayLength"), "0"));148        String searchParameter = ParameterParserUtil.parseStringParam(request.getParameter("sSearch"), "");149        int columnToSortParameter = Integer.parseInt(ParameterParserUtil.parseStringParam(request.getParameter("iSortCol_0"), "1"));150        String sColumns = ParameterParserUtil.parseStringParam(request.getParameter("sColumns"), "campaignid,campaign,Description");151        String columnToSort[] = sColumns.split(",");152        String columnName = columnToSort[columnToSortParameter];153        String sort = ParameterParserUtil.parseStringParam(request.getParameter("sSortDir_0"), "asc");154        List<String> individualLike = new ArrayList<>(Arrays.asList(ParameterParserUtil.parseStringParam(request.getParameter("sLike"), "").split(",")));155        campaignService = appContext.getBean(ICampaignService.class);156        Map<String, List<String>> individualSearch = new HashMap<>();157        for (int a = 0; a < columnToSort.length; a++) {158            if (null != request.getParameter("sSearch_" + a) && !request.getParameter("sSearch_" + a).isEmpty()) {159                List<String> search = new ArrayList<>(Arrays.asList(request.getParameter("sSearch_" + a).split(",")));160                if (individualLike.contains(columnToSort[a])) {161                    individualSearch.put(columnToSort[a] + ":like", search);162                } else {163                    individualSearch.put(columnToSort[a], search);164                }165            }166        }167        answer = campaignService.readByCriteria(startPosition, length, columnName, sort, searchParameter, individualSearch);168//        boolean userHasPermissions = request.isUserInRole("TestAdmin");169        JSONArray jsonArray = new JSONArray();170        if (answer.isCodeEquals(MessageEventEnum.DATA_OPERATION_OK.getCode())) {//the service was able to perform the query, then we should get all values171            for (Campaign campaign : (List<Campaign>) answer.getDataList()) {172                jsonArray.put(convertCampaigntoJSONObject(campaign));173            }174        }175        resp.put("contentTable", jsonArray);176        resp.put("hasPermissions", userHasPermissions);177        resp.put("iTotalRecords", answer.getTotalRows());178        resp.put("iTotalDisplayRecords", answer.getTotalRows());179        item.setItem(resp);180        item.setResultMessage(answer.getResultMessage());181        return item;182    }183    private AnswerItem<JSONObject> findCampaignByKey(String key, Boolean userHasPermissions, ApplicationContext appContext, HttpServletRequest request) throws JSONException {184        AnswerItem<JSONObject> item = new AnswerItem<>();185        JSONObject object = new JSONObject();186        campaignService = appContext.getBean(ICampaignService.class);187        AnswerItem answer = campaignService.readByKey(key);188        Campaign p;189        if (answer.isCodeEquals(MessageEventEnum.DATA_OPERATION_OK.getCode())) {//the service was able to perform the query, then we should get all values190            p = (Campaign) answer.getItem();191            JSONObject response = convertCampaigntoJSONObject(p);192            if (request.getParameter("parameter") != null) {193                ICampaignParameterService campaignParameterService = appContext.getBean(ICampaignParameterService.class);194                AnswerList resp = campaignParameterService.readByCampaign(key);195                if (resp.isCodeEquals(MessageEventEnum.DATA_OPERATION_OK.getCode())) {//the service was able to perform the query, then we should get all values196                    JSONArray a = new JSONArray();197                    for (Object c : resp.getDataList()) {198                        CampaignParameter cc = (CampaignParameter) c;199                        a.put(convertCampaignParametertoJSONObject(cc));200                    }201                    response.put("parameter", a);202                }203            }204            if (request.getParameter("label") != null) {205                ICampaignLabelService campaignLabelService = appContext.getBean(ICampaignLabelService.class);206                AnswerList resp = campaignLabelService.readByVarious(key);207                if (resp.isCodeEquals(MessageEventEnum.DATA_OPERATION_OK.getCode())) {//the service was able to perform the query, then we should get all values208                    JSONArray a = new JSONArray();209                    for (Object c : resp.getDataList()) {210                        CampaignLabel cc = (CampaignLabel) c;211                        a.put(convertCampaignLabeltoJSONObject(cc));212                    }213                    response.put("label", a);214                }215            }216            if (request.getParameter("testcase") != null) {217                ITestCaseService testCaseService = appContext.getBean(ITestCaseService.class);218                AnswerList<TestCase> resp = testCaseService.findTestCaseByCampaignNameAndCountries(key, null);219                if (resp.isCodeEquals(MessageEventEnum.DATA_OPERATION_OK.getCode())) {//the service was able to perform the query, then we should get all values220                    JSONArray a = new JSONArray();221                    for (Object c : resp.getDataList()) {222                        TestCase cc = (TestCase) c;223                        a.put(convertTestCasetoJSONObject(cc));224                    }225                    response.put("testcase", a);226                }227            }228            if (request.getParameter("tag") != null) {229                ITagService tagService = appContext.getBean(ITagService.class);230                AnswerList<Tag> resp = tagService.readByCampaign(key);231                if (resp.isCodeEquals(MessageEventEnum.DATA_OPERATION_OK.getCode())) {//the service was able to perform the query, then we should get all values232                    JSONArray a = new JSONArray();233                    for (Tag c : (List<Tag>) resp.getDataList()) {234                        a.put(convertTagtoJSONObject(c));235                    }236                    response.put("tag", a);237                }238            }239            object.put("contentTable", response);240        }241        object.put("hasPermissions", userHasPermissions);242        item.setItem(object);243        item.setResultMessage(answer.getResultMessage());244        return item;245    }246    private AnswerItem<JSONObject> findDistinctValuesOfColumn(ApplicationContext appContext, HttpServletRequest request, String columnName) throws JSONException {247        AnswerItem<JSONObject> answer = new AnswerItem<>();248        JSONObject object = new JSONObject();249        campaignService = appContext.getBean(ICampaignService.class);250        String searchParameter = ParameterParserUtil.parseStringParam(request.getParameter("sSearch"), "");251        String sColumns = ParameterParserUtil.parseStringParam(request.getParameter("sColumns"), "para,valC,valS,descr");252        String columnToSort[] = sColumns.split(",");253        List<String> individualLike = new ArrayList<>(Arrays.asList(ParameterParserUtil.parseStringParam(request.getParameter("sLike"), "").split(",")));254        Map<String, List<String>> individualSearch = new HashMap<>();255        for (int a = 0; a < columnToSort.length; a++) {256            if (null != request.getParameter("sSearch_" + a) && !request.getParameter("sSearch_" + a).isEmpty()) {257                List<String> search = new ArrayList<>(Arrays.asList(request.getParameter("sSearch_" + a).split(",")));258                if (individualLike.contains(columnToSort[a])) {259                    individualSearch.put(columnToSort[a] + ":like", search);260                } else {...

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.