How to use findDistinctValuesOfColumn method of org.cerberus.servlet.crud.batch.ReadBuildRevisionBatch class

Best Cerberus-source code snippet using org.cerberus.servlet.crud.batch.ReadBuildRevisionBatch.findDistinctValuesOfColumn

Source:ReadBuildRevisionBatch.java

...95        AnswerItem answer = new AnswerItem(msg);96        try {97            JSONObject jsonResponse = new JSONObject();98            if (!Strings.isNullOrEmpty(columnName)) {99                answer = findDistinctValuesOfColumn(request.getParameter("system"), appContext, request, columnName);100                jsonResponse = (JSONObject) answer.getItem();101            } else {102                answer = findBuildRevisionBatchList(request.getParameter("system"), request.getParameter("country"), request.getParameter("environment"), appContext, userHasPermissions, request);103                jsonResponse = (JSONObject) answer.getItem();104            }105            jsonResponse.put("messageType", answer.getResultMessage().getMessage().getCodeString());106            jsonResponse.put("message", answer.getResultMessage().getDescription());107            jsonResponse.put("sEcho", echo);108            response.getWriter().print(jsonResponse.toString());109        } catch (JSONException e) {110            LOG.warn(e);111            //returns a default error message with the json format that is able to be parsed by the client-side112            response.getWriter().print(AnswerUtil.createGenericErrorAnswer());113        }114    }115// <editor-fold defaultstate="collapsed" desc="HttpServlet methods. Click on the + sign on the left to edit the code.">116    /**117     * Handles the HTTP <code>GET</code> method.118     *119     * @param request servlet request120     * @param response servlet response121     * @throws ServletException if a servlet-specific error occurs122     * @throws IOException if an I/O error occurs123     */124    @Override125    protected void doGet(HttpServletRequest request, HttpServletResponse response)126            throws ServletException, IOException {127        try {128            processRequest(request, response);129        } catch (CerberusException ex) {130            LOG.warn(ex);131        }132    }133    /**134     * Handles the HTTP <code>POST</code> method.135     *136     * @param request servlet request137     * @param response servlet response138     * @throws ServletException if a servlet-specific error occurs139     * @throws IOException if an I/O error occurs140     */141    @Override142    protected void doPost(HttpServletRequest request, HttpServletResponse response)143            throws ServletException, IOException {144        try {145            processRequest(request, response);146        } catch (CerberusException ex) {147            LOG.warn(ex);148        }149    }150    /**151     * Returns a short description of the servlet.152     *153     * @return a String containing servlet description154     */155    @Override156    public String getServletInfo() {157        return "Short description";158    }// </editor-fold>159    private AnswerItem findBuildRevisionBatchList(String system, String country, String environment, ApplicationContext appContext, boolean userHasPermissions, HttpServletRequest request) throws JSONException {160        AnswerItem item = new AnswerItem();161        JSONObject object = new JSONObject();162        brbService = appContext.getBean(IBuildRevisionBatchService.class);163        int startPosition = Integer.valueOf(ParameterParserUtil.parseStringParam(request.getParameter("iDisplayStart"), "0"));164        int length = Integer.valueOf(ParameterParserUtil.parseStringParam(request.getParameter("iDisplayLength"), "0"));165        /*int sEcho  = Integer.valueOf(request.getParameter("sEcho"));*/166        String searchParameter = ParameterParserUtil.parseStringParam(request.getParameter("sSearch"), "");167        int columnToSortParameter = Integer.parseInt(ParameterParserUtil.parseStringParam(request.getParameter("iSortCol_0"), "1"));168        String sColumns = ParameterParserUtil.parseStringParam(request.getParameter("sColumns"), "ID,system,country,Environment,Build,Revision,Batch,DateBatch");169        String columnToSort[] = sColumns.split(",");170        String columnName = columnToSort[columnToSortParameter];171        String sort = ParameterParserUtil.parseStringParam(request.getParameter("sSortDir_0"), "asc");172        AnswerList resp = brbService.readByVariousByCriteria(system, country, environment, startPosition, length, columnName, sort, searchParameter, "");173        JSONArray jsonArray = new JSONArray();174        if (resp.isCodeEquals(MessageEventEnum.DATA_OPERATION_OK.getCode())) {//the service was able to perform the query, then we should get all values175            for (BuildRevisionBatch brb : (List<BuildRevisionBatch>) resp.getDataList()) {176                jsonArray.put(convertToJSONObject(brb));177            }178        }179        object.put("hasPermissions", userHasPermissions);180        object.put("contentTable", jsonArray);181        object.put("iTotalRecords", resp.getTotalRows());182        object.put("iTotalDisplayRecords", resp.getTotalRows());183        item.setItem(object);184        item.setResultMessage(resp.getResultMessage());185        return item;186    }187    private JSONObject convertToJSONObject(BuildRevisionBatch brb) throws JSONException {188        Gson gson = new Gson();189        JSONObject result = new JSONObject(gson.toJson(brb));190        return result;191    }192    private AnswerItem findDistinctValuesOfColumn(String system, ApplicationContext appContext, HttpServletRequest request, String columnName) throws JSONException {193        AnswerItem answer = new AnswerItem();194        JSONObject object = new JSONObject();195        brbService = appContext.getBean(IBuildRevisionBatchService.class);196        197        String searchParameter = ParameterParserUtil.parseStringParam(request.getParameter("sSearch"), "");198        String sColumns = ParameterParserUtil.parseStringParam(request.getParameter("sColumns"), "ID,system,country,Environment,Build,Revision,Batch,DateBatch");199        String columnToSort[] = sColumns.split(",");200        Map<String, List<String>> individualSearch = new HashMap<String, List<String>>();201        for (int a = 0; a < columnToSort.length; a++) {202            if (null!=request.getParameter("sSearch_" + a) && !request.getParameter("sSearch_" + a).isEmpty()) {203                List<String> search = new ArrayList(Arrays.asList(request.getParameter("sSearch_" + a).split(",")));204                individualSearch.put(columnToSort[a], search);205            }206        }...

findDistinctValuesOfColumn

Using AI Code Generation

1import org.cerberus.servlet.crud.batch.ReadBuildRevisionBatch;2List<String> list = new ArrayList<String>();3list = ReadBuildRevisionBatch.findDistinctValuesOfColumn("revision");4import org.cerberus.servlet.crud.batch.ReadBuildRevisionBatch;5List<String> list = new ArrayList<String>();6list = ReadBuildRevisionBatch.findDistinctValuesOfColumn("revision","application","myapplication");7import org.cerberus.servlet.crud.batch.ReadBuildRevisionBatch;8List<String> list = new ArrayList<String>();9list = ReadBuildRevisionBatch.findDistinctValuesOfColumn("revision","application","myapplication","country","mycountry");10import org.cerberus.servlet.crud.batch.ReadBuildRevisionBatch;11List<String> list = new ArrayList<String>();12list = ReadBuildRevisionBatch.findDistinctValuesOfColumn("revision","application","myapplication","country","mycountry");13import org.cerberus.servlet.crud.batch.ReadBuildRevisionBatch;14List<String> list = new ArrayList<String>();

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.