How to use UpdateSqlLibrary class of org.cerberus.servlet.crud.countryenvironment package

Best Cerberus-source code snippet using org.cerberus.servlet.crud.countryenvironment.UpdateSqlLibrary

Source:UpdateSqlLibrary.java

...45import org.apache.logging.log4j.Logger;46/**47 * @author bcivel48 */49@WebServlet(name = "UpdateSqlLibrary", urlPatterns = {"/UpdateSqlLibrary"})50public class UpdateSqlLibrary extends HttpServlet {51    private static final Logger LOG = LogManager.getLogger(UpdateSqlLibrary.class);52    53    /**54     * Processes requests for both HTTP <code>GET</code> and <code>POST</code>55     * methods.56     *57     * @param request  servlet request58     * @param response servlet response59     * @throws ServletException if a servlet-specific error occurs60     * @throws IOException      if an I/O error occurs61     */62    protected void processRequest(HttpServletRequest request, HttpServletResponse response)63            throws ServletException, IOException, CerberusException, JSONException {64        JSONObject jsonResponse = new JSONObject();65        ApplicationContext appContext = WebApplicationContextUtils.getWebApplicationContext(this.getServletContext());66        Answer ans = new Answer();67        MessageEvent msg = new MessageEvent(MessageEventEnum.DATA_OPERATION_ERROR_UNEXPECTED);68        msg.setDescription(msg.getDescription().replace("%DESCRIPTION%", ""));69        ans.setResultMessage(msg);70        response.setContentType("text/html;charset=UTF-8");71        PrintWriter out = response.getWriter();72        String charset = request.getCharacterEncoding() == null ? "UTF-8" : request.getCharacterEncoding();73        // Parameter that are already controled by GUI (no need to decode) --> We SECURE them74        // Parameter that needs to be secured --> We SECURE+DECODE them75        String name = ParameterParserUtil.parseStringParamAndDecodeAndSanitize(request.getParameter("name"), null, charset);76        String type = ParameterParserUtil.parseStringParamAndDecodeAndSanitize(request.getParameter("type"), null, charset);77        String database = ParameterParserUtil.parseStringParamAndDecodeAndSanitize(request.getParameter("database"), null, charset);78        String description = ParameterParserUtil.parseStringParamAndDecodeAndSanitize(request.getParameter("description"), null, charset);79        // Parameter that we cannot secure as we need the html --> We DECODE them80        String script = ParameterParserUtil.parseStringParamAndDecode(request.getParameter("script"), null, charset);81        82        // Prepare the final answer.83        MessageEvent msg1 = new MessageEvent(MessageEventEnum.GENERIC_OK);84        Answer finalAnswer = new Answer(msg1);85        /**86         * Checking all constrains before calling the services.87         */88        if (StringUtil.isNullOrEmpty(name)) {89            msg = new MessageEvent(MessageEventEnum.DATA_OPERATION_ERROR_EXPECTED);90            msg.setDescription(msg.getDescription().replace("%ITEM%", "SqlLibrary")91                    .replace("%OPERATION%", "Update")92                    .replace("%REASON%", "SqlLibrary ID (name) is missing."));93            finalAnswer.setResultMessage(msg);94        } else {95            /**96             * All data seems cleans so we can call the services.97             */98            ISqlLibraryService sqlLibraryService = appContext.getBean(ISqlLibraryService.class);99            AnswerItem resp = sqlLibraryService.readByKey(name);100            if (!(resp.isCodeEquals(MessageEventEnum.DATA_OPERATION_OK.getCode()) && resp.getItem() != null)) {101                /**102                 * Object could not be found. We stop here and report the error.103                 */104                finalAnswer = AnswerUtil.agregateAnswer(finalAnswer, resp);105            } else {106                /**107                 * The service was able to perform the query and confirm the108                 * object exist, then we can update it.109                 */110                SqlLibrary sqlLib = (SqlLibrary) resp.getItem();111                sqlLib.setType(type);112                sqlLib.setDescription(description);113                sqlLib.setDatabase(database);114                sqlLib.setScript(script);115                ans = sqlLibraryService.update(sqlLib);116                finalAnswer = AnswerUtil.agregateAnswer(finalAnswer, ans);117                if (ans.isCodeEquals(MessageEventEnum.DATA_OPERATION_OK.getCode())) {118                    /**119                     * Update was successful. Adding Log entry.120                     */121                    ILogEventService logEventService = appContext.getBean(LogEventService.class);122                    logEventService.createForPrivateCalls("/UpdateSqlLibrary", "UPDATE", "Updated SqlLibrary : ['" + name + "']", request);123                }124            }125        }126        /**127         * Formating and returning the json result.128         */129        jsonResponse.put("messageType", finalAnswer.getResultMessage().getMessage().getCodeString());130        jsonResponse.put("message", finalAnswer.getResultMessage().getDescription());131        response.getWriter().print(jsonResponse);132        response.getWriter().flush();133    }134    // <editor-fold defaultstate="collapsed" desc="HttpServlet methods. Click on the + sign on the left to edit the code.">135    /**136     * Handles the HTTP <code>GET</code> method....

UpdateSqlLibrary

Using AI Code Generation

1package org.cerberus.servlet.crud.countryenvironment;2import java.io.IOException;3import java.io.PrintWriter;4import java.sql.Connection;5import java.sql.SQLException;6import java.util.logging.Level;7import java.util.logging.Logger;8import javax.servlet.ServletException;9import javax.servlet.http.HttpServlet;10import javax.servlet.http.HttpServletRequest;11import javax.servlet.http.HttpServletResponse;12import org.cerberus.crud.entity.SqlLibrary;13import org.cerberus.crud.factory.IFactorySqlLibrary;14import org.cerberus.crud.service.impl.SqlLibraryService;15import org.cerberus.crud.service.impl.UserService;16import org.cerberus.database.DatabaseSpring;17import org.cerberus.engine.entity.MessageEvent;18import org.cerberus.engine.entity.MessageGeneral;19import org.cerberus.enums.MessageEventEnum;20import org.cerberus.factory.impl.FactorySqlLibrary;21import org.cerberus.log.MyLogger;22import org.cerberus.servlet.api.ApiUtil;23import org.cerberus.util.StringUtil;24import org.json.JSONArray;25import org.json.JSONException;26import org.json.JSONObject;27import org.springframework.context.ApplicationContext;28import org.springframework.web.context.support.WebApplicationContextUtils;29public class UpdateSqlLibrary extends HttpServlet {30    private static final org.apache.log4j.Logger LOG = org.apache.log4j.Logger.getLogger(UpdateSqlLibrary.class);31    private final String OBJECT_NAME = "SqlLibrary";32    private final String PARAMETER_SQL_LIBRARY = "sqlLibrary";33    private final String PARAMETER_SQL = "sql";34    private final String PARAMETER_DATABASE = "database";35    private final String PARAMETER_DESCRIPTION = "description";36    private final String PARAMETER_TYPE = "type";

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.