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

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

Source:ReadLabel.java

...104                    Integer id = Integer.valueOf(policy.sanitize(request.getParameter("id")));105                    answer = findLabelByKey(id, appContext, userHasPermissions);106                    jsonResponse = (JSONObject) answer.getItem();107                } else if (request.getParameter("system") != null && !Strings.isNullOrEmpty(columnName)) {108                    answer = findDistinctValuesOfColumn(request.getParameter("system"),appContext, request, columnName);109                    jsonResponse = (JSONObject) answer.getItem();110                } else if (request.getParameter("system") != null) {111                    String system = policy.sanitize(request.getParameter("system"));112                    answer = findLabelList(system, appContext, userHasPermissions, request);113                    jsonResponse = (JSONObject) answer.getItem();114                }115            }116            jsonResponse.put("messageType", answer.getResultMessage().getMessage().getCodeString());117            jsonResponse.put("message", answer.getResultMessage().getDescription());118            jsonResponse.put("sEcho", echo);119            response.getWriter().print(jsonResponse.toString());120        } catch (JSONException e) {121            LOG.warn(e);122            //returns a default error message with the json format that is able to be parsed by the client-side123            response.getWriter().print(AnswerUtil.createGenericErrorAnswer());124        }125    }126    // <editor-fold defaultstate="collapsed" desc="HttpServlet methods. Click on the + sign on the left to edit the code.">127    /**128     * Handles the HTTP <code>GET</code> method.129     *130     * @param request servlet request131     * @param response servlet response132     * @throws ServletException if a servlet-specific error occurs133     * @throws IOException if an I/O error occurs134     */135    @Override136    protected void doGet(HttpServletRequest request, HttpServletResponse response)137            throws ServletException, IOException {138        try {139            processRequest(request, response);140        } catch (CerberusException ex) {141            LOG.warn(ex);142        }143    }144    /**145     * Handles the HTTP <code>POST</code> method.146     *147     * @param request servlet request148     * @param response servlet response149     * @throws ServletException if a servlet-specific error occurs150     * @throws IOException if an I/O error occurs151     */152    @Override153    protected void doPost(HttpServletRequest request, HttpServletResponse response)154            throws ServletException, IOException {155        try {156            processRequest(request, response);157        } catch (CerberusException ex) {158            LOG.warn(ex);159        }160    }161    /**162     * Returns a short description of the servlet.163     *164     * @return a String containing servlet description165     */166    @Override167    public String getServletInfo() {168        return "Short description";169    }// </editor-fold>170    private AnswerItem findLabelList(String system, ApplicationContext appContext, boolean userHasPermissions, HttpServletRequest request) throws JSONException {171        AnswerItem item = new AnswerItem();172        JSONObject object = new JSONObject();173        labelService = appContext.getBean(LabelService.class);174        int startPosition = Integer.valueOf(ParameterParserUtil.parseStringParam(request.getParameter("iDisplayStart"), "0"));175        int length = Integer.valueOf(ParameterParserUtil.parseStringParam(request.getParameter("iDisplayLength"), "0"));176        /*int sEcho  = Integer.valueOf(request.getParameter("sEcho"));*/177        String searchParameter = ParameterParserUtil.parseStringParam(request.getParameter("sSearch"), "");178        int columnToSortParameter = Integer.parseInt(ParameterParserUtil.parseStringParam(request.getParameter("iSortCol_0"), "1"));179        String sColumns = ParameterParserUtil.parseStringParam(request.getParameter("sColumns"), "System,Label,Color,Display,parentLabelId,Description");180        String columnToSort[] = sColumns.split(",");181        String columnName = columnToSort[columnToSortParameter];182        String sort = ParameterParserUtil.parseStringParam(request.getParameter("sSortDir_0"), "asc");183        List<String> individualLike = new ArrayList(Arrays.asList(ParameterParserUtil.parseStringParam(request.getParameter("sLike"),"").split(",")));184        Map<String, List<String>> individualSearch = new HashMap<>();185        for (int a = 0; a < columnToSort.length; a++) {186            if (null != request.getParameter("sSearch_" + a) && !request.getParameter("sSearch_" + a).isEmpty()) {187                List<String> search = new ArrayList(Arrays.asList(request.getParameter("sSearch_" + a).split(",")));188                if(individualLike.contains(columnToSort[a])) {189                	individualSearch.put(columnToSort[a]+":like", search);190                }else {191                	individualSearch.put(columnToSort[a], search);192                }193            }194        }195        AnswerList resp = labelService.readBySystemByCriteria(system, startPosition, length, columnName, sort, searchParameter, individualSearch);196        JSONArray jsonArray = new JSONArray();197        if (resp.isCodeEquals(MessageEventEnum.DATA_OPERATION_OK.getCode())) {//the service was able to perform the query, then we should get all values198            for (Label label : (List<Label>) resp.getDataList()) {199                JSONObject labelObject = convertLabelToJSONObject(label);200                if (!"".equals(label.getParentLabel())) {201                    AnswerItem parentLabel = labelService.readByKey(Integer.valueOf(label.getParentLabel()));202                    if(parentLabel.getItem() != null) {203                       labelObject.put("labelParentObject", convertLabelToJSONObject((Label) parentLabel.getItem()));204                    }205                }206                jsonArray.put(labelObject);207            }208        }209        object.put("hasPermissions", userHasPermissions);210        object.put("contentTable", jsonArray);211        object.put("iTotalRecords", resp.getTotalRows());212        object.put("iTotalDisplayRecords", resp.getTotalRows());213        item.setItem(object);214        item.setResultMessage(resp.getResultMessage());215        return item;216    }217    private AnswerItem findLabelByKey(Integer id, ApplicationContext appContext, boolean userHasPermissions) throws JSONException, CerberusException {218        AnswerItem item = new AnswerItem();219        JSONObject object = new JSONObject();220        ILabelService labelService = appContext.getBean(ILabelService.class);221        //finds the project     222        AnswerItem answer = labelService.readByKey(id);223        if (answer.isCodeEquals(MessageEventEnum.DATA_OPERATION_OK.getCode())) {224            //if the service returns an OK message then we can get the item and convert it to JSONformat225            Label label = (Label) answer.getItem();226            JSONObject labelObject = convertLabelToJSONObject(label);227            if (!"".equals(label.getParentLabel())) {228                labelObject.put("labelParentObject", convertLabelToJSONObject((Label) labelService.readByKey(Integer.valueOf(label.getParentLabel())).getItem()));229            }230            JSONObject response = labelObject;231            object.put("contentTable", response);232        }233        object.put("hasPermissions", userHasPermissions);234        item.setItem(object);235        item.setResultMessage(answer.getResultMessage());236        return item;237    }238    private JSONObject convertLabelToJSONObject(Label label) throws JSONException {239        Gson gson = new Gson();240        JSONObject result = new JSONObject(gson.toJson(label));241        JSONObject display = new JSONObject();242        display.put("label", label.getLabel());243        display.put("color", label.getColor());244        result.put("display", display);245        return result;246    }247    private AnswerItem findDistinctValuesOfColumn(String system, ApplicationContext appContext, HttpServletRequest request, String columnName) throws JSONException {248        AnswerItem answer = new AnswerItem();249        JSONObject object = new JSONObject();250        labelService = appContext.getBean(ILabelService.class);251        String searchParameter = ParameterParserUtil.parseStringParam(request.getParameter("sSearch"), "");252        String sColumns = ParameterParserUtil.parseStringParam(request.getParameter("sColumns"), "System,Label,Color,Display,parentLabelId,Description");253        String columnToSort[] = sColumns.split(",");254        255        List<String> individualLike = new ArrayList(Arrays.asList(ParameterParserUtil.parseStringParam(request.getParameter("sLike"), "").split(",")));256        Map<String, List<String>> individualSearch = new HashMap<>();257        for (int a = 0; a < columnToSort.length; a++) {258            if (null != request.getParameter("sSearch_" + a) && !request.getParameter("sSearch_" + a).isEmpty()) {259            	List<String> search = new ArrayList(Arrays.asList(request.getParameter("sSearch_" + a).split(",")));260            	if(individualLike.contains(columnToSort[a])) {261                	individualSearch.put(columnToSort[a]+":like", search);...

findDistinctValuesOfColumn

Using AI Code Generation

1    public void findDistinctValuesOfColumn() throws CerberusException {2        String column = request.getParameter("column");3        String table = request.getParameter("table");4        String system = request.getParameter("system");5        String country = request.getParameter("country");6        String environment = request.getParameter("environment");7        String application = request.getParameter("application");8        if (StringUtil.isNullOrEmpty(column)9                || StringUtil.isNullOrEmpty(table)10                || StringUtil.isNullOrEmpty(system)11                || StringUtil.isNullOrEmpty(country)12                || StringUtil.isNullOrEmpty(environment)13                || StringUtil.isNullOrEmpty(application)) {14            response.setContentType("text/html");15            response.setStatus(HttpServletResponse.SC_BAD_REQUEST);16            return;17        }18        response.setContentType("text/html;charset=UTF-8");19        response.setStatus(HttpServletResponse.SC_OK);20        try (PrintWriter out = response.getWriter()) {21            out.print(ReadLabel.findDistinctValuesOfColumn(column, table, system, country, environment, application));22        } catch (IOException ex) {23            LOG.error(ex.toString(), ex);24        }25    }26    public static String findDistinctValuesOfColumn(String column, String table, String system, String country, String environment, String application) throws CerberusException {27        String result = "";28        List<String> distinctValues = new ArrayList<>();29        IFactoryLabel factoryLabel = new FactoryLabel();30        ILabelService labelService = factoryLabel.createService();31        ILabelDAO labelDAO = factoryLabel.createDAO();32        try {33            distinctValues = labelDAO.findDistinctValuesOfColumn(column, table, system, country, environment, application);34            for (String distinctValue : distinctValues) {35                result += distinctValue + ";";36            }37        } catch (CerberusException ex) {38            LOG.error(ex.toString(), ex);39        }40        return result;41    }42    public static String findDistinctValuesOfColumn(String column, String table, String system, String country, String environment, String application) throws CerberusException {43        String result = "";44        List<String> distinctValues = new ArrayList<>();45        IFactoryLabel factoryLabel = new FactoryLabel();46        ILabelService labelService = factoryLabel.createService();47        ILabelDAO labelDAO = factoryLabel.createDAO();

findDistinctValuesOfColumn

Using AI Code Generation

1import org.cerberus.servlet.crud.transversaltables.ReadLabel;2import org.cerberus.servlet.crud.transversaltables.ReadLabel;3import java.util.List;4List<String> distinctLabelList = ReadLabel.findDistinctValuesOfColumn("label", "label", "Cerberus");5for (String label:distinctLabelList)6{7    System.out.println(label);8}9javax.swing.JOptionPane.showMessageDialog(null, distinctLabelList.toString());10javax.swing.JOptionPane.showInputDialog(null, distinctLabelList.toString());11javax.swing.JOptionPane.showInputDialog(null, distinctLabelList.toString(), "List of labels", javax.swing.JOptionPane.INFORMATION_MESSAGE);12javax.swing.JOptionPane.showInputDialog(null, distinctLabelList.toString(), "List of labels", javax.swing.JOptionPane.INFORMATION_MESSAGE, null, null, "List of labels");

findDistinctValuesOfColumn

Using AI Code Generation

1ReadLabel readLabel = new ReadLabel();2String table = request.getParameter("table");3String column = request.getParameter("column");4List<String> distinctValues = readLabel.findDistinctValuesOfColumn(table, column);5Gson gson = new Gson();6String json = gson.toJson(distinctValues);7response.setContentType("application/json");8response.getWriter().write(json);9ReadLabel readLabel = new ReadLabel();10String table = request.getParameter("table");11String column = request.getParameter("column");12List<String> distinctValues = readLabel.findDistinctValuesOfColumn(table, column);13Gson gson = new Gson();14String json = gson.toJson(distinctValues);15response.setContentType("application/json");16response.getWriter().write(json);17ReadLabel readLabel = new ReadLabel();18String table = request.getParameter("table");19String column = request.getParameter("column");20List<String> distinctValues = readLabel.findDistinctValuesOfColumn(table, column);

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.