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 Github

copy

Full Screen

...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 {...

Full Screen

Full Screen

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.

LambdaTest Learning Hubs:

YouTube

You could also refer to video tutorials over LambdaTest YouTube channel to get step by step demonstration from industry experts.

Run Cerberus-source automation tests on LambdaTest cloud grid

Perform automation testing on 3000+ real desktop and mobile devices online.

Try LambdaTest Now !!

Get 100 minutes of automation test minutes FREE!!

Next-Gen App & Browser Testing Cloud

Was this article helpful?

Helpful

NotHelpful