pivotal.au.se.gemfirexdweb.controller.AddWriterController.java Source code

Introduction

Here is the source code for pivotal.au.se.gemfirexdweb.controller.AddWriterController.java

Source

/*
Copyright (C) MARCH-2014 Pivotal Software, Inc.
    
All rights reserved. This program and the accompanying materials
are made available under the terms of the under the Apache License,
Version 2.0 (the "License?); you may not use this file except in compliance
with the License. You may obtain a copy of the License at
    
http://www.apache.org/licenses/LICENSE-2.0
    
Unless required by applicable law or agreed to in writing, software
distributed under the License is distributed on an "AS IS" BASIS,
WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
See the License for the specific language governing permissions and
limitations under the License.
*/
package pivotal.au.se.gemfirexdweb.controller;

import org.apache.log4j.Logger;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.ModelAttribute;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import pivotal.au.se.gemfirexdweb.beans.AddWriter;
import pivotal.au.se.gemfirexdweb.dao.GemFireXDWebDAOUtil;
import pivotal.au.se.gemfirexdweb.main.Result;
import pivotal.au.se.gemfirexdweb.utils.AdminUtil;

import javax.servlet.ServletOutputStream;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import java.sql.Connection;

@Controller
public class AddWriterController {
    protected static Logger logger = Logger.getLogger("controller");
    private static final String FILENAME = "%s.sql";
    private static final String SAVE_CONTENT_TYPE = "application/x-download";

    @RequestMapping(value = "/addwriter", method = RequestMethod.GET)
    public String createWriter(Model model, HttpServletResponse response, HttpServletRequest request,
            HttpSession session) throws Exception {

        if (session.getAttribute("user_key") == null) {
            logger.debug("user_key is null new Login required");
            response.sendRedirect(request.getContextPath() + "/GemFireXD-Web/login");
            return null;
        } else {
            Connection conn = AdminUtil.getConnection((String) session.getAttribute("user_key"));
            if (conn == null) {
                response.sendRedirect(request.getContextPath() + "/GemFireXD-Web/login");
                return null;
            } else {
                if (conn.isClosed()) {
                    response.sendRedirect(request.getContextPath() + "/GemFireXD-Web/login");
                    return null;
                }
            }

        }

        logger.debug("Received request to add new Table Writer");

        AddWriter writerAttribute = new AddWriter();

        if (request.getParameter("tableName") != null) {
            writerAttribute.setTableName(request.getParameter("tableName"));
        }

        if (request.getParameter("schemaName") != null) {
            writerAttribute.setSchemaName(request.getParameter("schemaName"));
        }

        model.addAttribute("writerAttribute", writerAttribute);

        // This will resolve to /WEB-INF/jsp/addwriter.jsp
        return "addwriter";
    }

    @RequestMapping(value = "/addwriter", method = RequestMethod.POST)
    public String createWriterAction(@ModelAttribute("writerAttribute") AddWriter writerAttribute, Model model,
            HttpServletResponse response, HttpServletRequest request, HttpSession session) throws Exception {
        if (session.getAttribute("user_key") == null) {
            logger.debug("user_key is null new Login required");
            response.sendRedirect(request.getContextPath() + "/GemFireXD-Web/login");
            return null;
        } else {
            Connection conn = AdminUtil.getConnection((String) session.getAttribute("user_key"));
            if (conn == null) {
                response.sendRedirect(request.getContextPath() + "/GemFireXD-Web/login");
                return null;
            } else {
                if (conn.isClosed()) {
                    response.sendRedirect(request.getContextPath() + "/GemFireXD-Web/login");
                    return null;
                }
            }

        }

        logger.debug("Received request to action an event for Table Writer");

        // perform some action here with what we have
        String submit = request.getParameter("pSubmit");

        if (submit != null) {
            // build create HDFS Store SQL
            StringBuffer addWriter = new StringBuffer();

            addWriter.append("CALL SYS.ATTACH_WRITER ('" + writerAttribute.getSchemaName() + "', \n");
            addWriter.append("'" + writerAttribute.getTableName() + "', \n");
            addWriter.append("'" + writerAttribute.getFunctionString() + "', \n");

            if (!checkIfParameterEmpty(request, "initInfoString")) {
                addWriter.append("'" + writerAttribute.getInitInfoString() + "', \n");
            } else {
                addWriter.append("NULL, \n");
            }

            if (!checkIfParameterEmpty(request, "serverGroups")) {
                addWriter.append("'" + writerAttribute.getServerGroups() + "')");
            } else {
                addWriter.append("NULL), \n");
            }

            if (submit.equalsIgnoreCase("create")) {
                Result result = new Result();

                logger.debug("Creating Table Writer as -> " + addWriter.toString());

                result = GemFireXDWebDAOUtil.runStoredCommand(addWriter.toString(),
                        (String) session.getAttribute("user_key"));

                model.addAttribute("result", result);

            } else if (submit.equalsIgnoreCase("Show SQL")) {
                logger.debug("Create Table Writer SQL as follows as -> " + addWriter.toString());
                model.addAttribute("sql", addWriter.toString());
            } else if (submit.equalsIgnoreCase("Save to File")) {
                response.setContentType(SAVE_CONTENT_TYPE);
                response.setHeader("Content-Disposition", "attachment; filename="
                        + String.format(FILENAME, writerAttribute.getTableName() + "-Writer"));

                ServletOutputStream out = response.getOutputStream();
                out.println(addWriter.toString());
                out.close();
                return null;
            }

        }

        // This will resolve to /WEB-INF/jsp/addwriter.jsp
        return "addwriter";
    }

    private boolean checkIfParameterEmpty(HttpServletRequest request, String param) {
        String val = request.getParameter(param);

        if (val != null) {
            if (val.trim().length() == 0) {
                return true;
            } else {
                // we have some data
                return false;
            }
        } else {
            // no data here
            return true;
        }
    }
}