How to use findDistinctValuesOfColumn method of org.cerberus.servlet.crud.usermanagement.ReadLogEvent class

Best Cerberus-source code snippet using org.cerberus.servlet.crud.usermanagement.ReadLogEvent.findDistinctValuesOfColumn

Source:ReadLogEvent.java

...104        AnswerItem answer = new AnswerItem(msg);105        try {106            JSONObject jsonResponse = new JSONObject();107            if (!Strings.isNullOrEmpty(columnName)) {108                answer = findDistinctValuesOfColumn(appContext, request, columnName);109                jsonResponse = (JSONObject) answer.getItem();110            } else if (request.getParameter("logeventid") == null) {111                answer = findLogEventList(appContext, request);112                jsonResponse = (JSONObject) answer.getItem();113            } else if ((request.getParameter("logeventid") != null) && !(idlog_error)) {114                answer = findLogEventByID(appContext, idlog);115                jsonResponse = (JSONObject) answer.getItem();116            }117            jsonResponse.put("messageType", answer.getResultMessage().getMessage().getCodeString());118            jsonResponse.put("message", answer.getResultMessage().getDescription());119            jsonResponse.put("sEcho", echo);120            response.getWriter().print(jsonResponse.toString());121        } catch (JSONException e) {122            LOG.warn(e);123            //returns a default error message with the json format that is able to be parsed by the client-side124            response.getWriter().print(AnswerUtil.createGenericErrorAnswer());125        }126    }127    // <editor-fold defaultstate="collapsed" desc="HttpServlet methods. Click on the + sign on the left to edit the code.">128    /**129     * Handles the HTTP <code>GET</code> method.130     *131     * @param request servlet request132     * @param response servlet response133     * @throws ServletException if a servlet-specific error occurs134     * @throws IOException if an I/O error occurs135     */136    @Override137    protected void doGet(HttpServletRequest request, HttpServletResponse response)138            throws ServletException, IOException {139        try {140            processRequest(request, response);141        } catch (CerberusException ex) {142            LOG.warn(ex);143        }144    }145    /**146     * Handles the HTTP <code>POST</code> method.147     *148     * @param request servlet request149     * @param response servlet response150     * @throws ServletException if a servlet-specific error occurs151     * @throws IOException if an I/O error occurs152     */153    @Override154    protected void doPost(HttpServletRequest request, HttpServletResponse response)155            throws ServletException, IOException {156        try {157            processRequest(request, response);158        } catch (CerberusException ex) {159            LOG.warn(ex);160        }161    }162    /**163     * Returns a short description of the servlet.164     *165     * @return a String containing servlet description166     */167    @Override168    public String getServletInfo() {169        return "Short description";170    }// </editor-fold>171    private AnswerItem findLogEventList(ApplicationContext appContext, HttpServletRequest request) throws CerberusException, JSONException {172        AnswerItem item = new AnswerItem();173        JSONObject jsonResponse = new JSONObject();174        logEventService = appContext.getBean(LogEventService.class);175        int startPosition = Integer.valueOf(ParameterParserUtil.parseStringParam(request.getParameter("iDisplayStart"), "0"));176        int length = Integer.valueOf(ParameterParserUtil.parseStringParam(request.getParameter("iDisplayLength"), "10000"));177        String searchParameter = ParameterParserUtil.parseStringParam(request.getParameter("sSearch"), "");178        int columnToSortParameter = Integer.parseInt(ParameterParserUtil.parseStringParam(request.getParameter("iSortCol_0"), "0"));179        String sColumns = ParameterParserUtil.parseStringParam(request.getParameter("sColumns"), "Time,login,Page,Action,log");180        String columnToSort[] = sColumns.split(",");181        String columnName = columnToSort[columnToSortParameter];182        String sort = ParameterParserUtil.parseStringParam(request.getParameter("sSortDir_0"), "desc");183        List<String> individualLike = new ArrayList(Arrays.asList(ParameterParserUtil.parseStringParam(request.getParameter("sLike"), "").split(",")));184        Map<String, List<String>> individualSearch = new HashMap<String, List<String>>();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        196        AnswerList resp = logEventService.readByCriteria(startPosition, length, columnName, sort, searchParameter, individualSearch);197        JSONArray jsonArray = new JSONArray();198        boolean userHasPermissions = false;199        if (resp.isCodeEquals(MessageEventEnum.DATA_OPERATION_OK.getCode())) {200            for (LogEvent myLogEvent : (List<LogEvent>) resp.getDataList()) {201                jsonArray.put(convertLogEventToJSONObject(myLogEvent));202            }203        }204        jsonResponse.put("hasPermissions", userHasPermissions);205        jsonResponse.put("contentTable", jsonArray);206        jsonResponse.put("iTotalRecords", resp.getTotalRows());207        jsonResponse.put("iTotalDisplayRecords", resp.getTotalRows());208        item.setItem(jsonResponse);209        item.setResultMessage(resp.getResultMessage());210        return item;211    }212    private JSONObject convertLogEventToJSONObject(LogEvent logEvent) throws JSONException {213        Gson gson = new Gson();214        JSONObject result = new JSONObject(gson.toJson(logEvent));215        return result;216    }217    private AnswerItem findLogEventByID(ApplicationContext appContext, long id) throws JSONException, CerberusException {218        AnswerItem item = new AnswerItem();219        JSONObject object = new JSONObject();220        ILogEventService libService = appContext.getBean(ILogEventService.class);221        AnswerItem answer = libService.readByKey(id);222        if (answer.isCodeEquals(MessageEventEnum.DATA_OPERATION_OK.getCode())) {223            //if the service returns an OK message then we can get the item and convert it to JSONformat224            LogEvent lib = (LogEvent) answer.getItem();225            JSONObject response = convertLogEventToJSONObject(lib);226            object.put("contentTable", response);227        }228        item.setItem(object);229        item.setResultMessage(answer.getResultMessage());230        return item;231    }232    private AnswerItem findDistinctValuesOfColumn(ApplicationContext appContext, HttpServletRequest request, String columnName) throws JSONException {233        AnswerItem answer = new AnswerItem();234        JSONObject object = new JSONObject();235        logEventService = appContext.getBean(ILogEventService.class);236        237        String searchParameter = ParameterParserUtil.parseStringParam(request.getParameter("sSearch"), "");238        String sColumns = ParameterParserUtil.parseStringParam(request.getParameter("sColumns"), "Time,login,Page,Action,log");239        String columnToSort[] = sColumns.split(",");240        List<String> individualLike = new ArrayList(Arrays.asList(ParameterParserUtil.parseStringParam(request.getParameter("sLike"), "").split(",")));241        Map<String, List<String>> individualSearch = new HashMap<>();242        for (int a = 0; a < columnToSort.length; a++) {243            if (null != request.getParameter("sSearch_" + a) && !request.getParameter("sSearch_" + a).isEmpty()) {244            	List<String> search = new ArrayList(Arrays.asList(request.getParameter("sSearch_" + a).split(",")));245            	if(individualLike.contains(columnToSort[a])) {246                	individualSearch.put(columnToSort[a]+":like", search);...

findDistinctValuesOfColumn

Using AI Code Generation

1    List<String> list = new ReadLogEvent().findDistinctValuesOfColumn("user", "event", "login");2    for (String string : list) {3        System.out.println(string);4    }5    List<String> list2 = new ReadLogEvent().findDistinctValuesOfColumn("user", "event", "login", "level", "INFO");6    for (String string : list2) {7        System.out.println(string);8    }9}

findDistinctValuesOfColumn

Using AI Code Generation

1<%@ page import="org.cerberus.servlet.crud.usermanagement.ReadLogEvent"%>2<%@ page import="java.util.List"%>3<%@ page import="java.util.ArrayList"%>4    ReadLogEvent readLogEvent = new ReadLogEvent();5    List<String> distinctLogEvent = new ArrayList<String>();6    distinctLogEvent = readLogEvent.findDistinctValuesOfColumn("logEvent", "logevent");7    for (int i = 0; i < distinctLogEvent.size(); i++) {8        out.println("<option value=\"" + distinctLogEvent.get(i) + "\" >" + distinctLogEvent.get(i) + "</option>");9    }

findDistinctValuesOfColumn

Using AI Code Generation

1package org.cerberus.servlet.crud.usermanagement;2import java.io.IOException;3import java.io.PrintWriter;4import java.util.List;5import javax.servlet.ServletException;6import javax.servlet.http.HttpServlet;7import javax.servlet.http.HttpServletRequest;8import javax.servlet.http.HttpServletResponse;9import org.cerberus.crud.entity.User;10import org.cerberus.engine.entity.MessageEvent;11import org.cerberus.enums.MessageEventEnum;12import org.cerberus.exception.CerberusException;13import org.cerberus.log.MyLogger;14import org.cerberus.service.crud.IUserService;15import org.cerberus.version.Infos;16import org.springframework.context.ApplicationContext;17import org.springframework.web.context.support.WebApplicationContextUtils;18public class ReadDistinctValuesOfColumn extends HttpServlet {19    private IUserService userService;20    public void init() throws ServletException {21        ApplicationContext appContext = WebApplicationContextUtils.getWebApplicationContext(this.getServletContext());22        userService = appContext.getBean(IUserService.class);23    }24    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {25        PrintWriter out = response.getWriter();26        String column = request.getParameter("column");27        MessageEvent message = new MessageEvent(MessageEventEnum.DATA_OPERATION_OK);28        message.setDescription(message.getDescription().replace("%ITEM%", "LogEvent").replace("%OPERATION%", "Read distinct values of column " + column));29        try {30            List<String> list = userService.findDistinctValuesOfColumn(column);31            out.print(list);32        } catch (CerberusException ex) {33            MyLogger.log(ReadDistinctValuesOfColumn.class.getName(), ex);34            message = ex.getMessageError();35        }36        out.flush();37        out.close();38    }39    public String getServletInfo() {40        return "Servlet to get distinct values of a column in a table and return them in a json format to be used by typeahead.js";41    }42}

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.