com.seer.datacruncher.profiler.spring.ProfilerLoadController.java Source code

Introduction

Here is the source code for com.seer.datacruncher.profiler.spring.ProfilerLoadController.java

Source

/*
 * Copyright (c) 2015  www.see-r.com
 * All rights reserved
 *
 * This program is free software: you can redistribute it and/or modify
 * it under the terms of the GNU Affero General Public License as
 * published by the Free Software Foundation, either version 3 of the
 * License, or (at your option) any later version.
 *
 * This program is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU Affero General Public License for more details.
 *
 * You should have received a copy of the GNU Affero General Public License
 * along with this program.  If not, see <http://www.gnu.org/licenses/>.
 */

package com.seer.datacruncher.profiler.spring;

import com.seer.datacruncher.jpa.dao.DaoSet;
import com.seer.datacruncher.jpa.entity.DatabaseEntity;
import com.seer.datacruncher.profiler.bl.DataQualityBL;
import com.seer.datacruncher.profiler.bl.TestConnectionBL;
import com.seer.datacruncher.profiler.dto.TestConnectionDTO;
import com.seer.datacruncher.profiler.framework.rdbms.RdbmsNewConnection;
import com.seer.datacruncher.profiler.util.CommonUtil;
import com.seer.datacruncher.profiler.util.DataQualityUtil;

import java.io.IOException;
import java.io.PrintWriter;
import java.util.Hashtable;
import java.util.Vector;

import javax.servlet.ServletException;
import javax.servlet.ServletOutputStream;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;

import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.codehaus.jackson.map.ObjectMapper;
import org.springframework.web.servlet.ModelAndView;
import org.springframework.web.servlet.mvc.multiaction.MultiActionController;

public class ProfilerLoadController extends MultiActionController implements DaoSet {

    protected final Log logger = LogFactory.getLog(getClass());

    public ModelAndView loadProfile(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {

        String dbId = request.getParameter("_dbId");

        DatabaseEntity dbEntity = dbDao.find(Long.parseLong(dbId));

        TestConnectionDTO tcDTO = new TestConnectionDTO();
        tcDTO.setDbType("MYSQL");
        tcDTO.setDsn("//" + dbEntity.getHost() + "/" + dbEntity.getDatabaseName());
        tcDTO.setUser(dbEntity.getUserName());
        tcDTO.setPasswd(dbEntity.getPassword());
        tcDTO.setDriver("com.mysql.jdbc.Driver");
        tcDTO.setProtocol("jdbc:mysql");
        tcDTO.setCatalog(request.getParameter("data_catalog"));
        tcDTO.setSchemaPattern("");
        tcDTO.setTablePattern("");
        tcDTO.setColPattern("");
        tcDTO.setShowType("TABLE");
        tcDTO.setComparion(CommonUtil.notNullValue(request.getParameter("comparison")).equals("true"));
        tcDTO.setJdbcCs("");

        TestConnectionBL tcBL = new TestConnectionBL();

        boolean success = tcBL.testDatabaseConnection(tcDTO, request);
        response.setContentType("application/json");
        PrintWriter out = response.getWriter();

        if (success) {

            if (tcDTO.isComparion()) {
                HttpSession session = request.getSession(true);
                @SuppressWarnings("unchecked")
                Hashtable<String, String> dbParams = (Hashtable<String, String>) session
                        .getAttribute("dbConnectionDataForComparison");
                try {
                    RdbmsNewConnection newConn = new RdbmsNewConnection(dbParams);
                    newConn.openConn();
                    newConn.populateTable();
                    Vector table_v = newConn.getTable();
                    // String tableName = (String)table_v.get(0);
                    // Vector[] avector = newConn.populateColumn(tableName,
                    // null);
                    newConn.closeConn();

                    DataQualityBL dqbl = new DataQualityBL();
                    out.println(
                            "{\"success\": true, tables:" + DataQualityUtil.generateTableColumnNames(table_v, null)
                                    + ", columns: " + dqbl.loadColumnNames(table_v) + "}");
                } catch (Exception e) {
                    e.printStackTrace();
                }
            } else {
                out.println("{\"success\": true}");
            }
        } else {
            out.println("{\"success\": false}");
        }

        DataQualityBL dqbl = new DataQualityBL();
        HttpSession session = request.getSession(true);
        @SuppressWarnings("unchecked")
        Hashtable<String, String> dbParams = (Hashtable<String, String>) session.getAttribute("dbConnectionData");

        String tableNames = dqbl.loadTableNames(dbParams);
        String columnNames = dqbl.loadColumnNames();

        session.setAttribute("tableNames", tableNames);
        session.setAttribute("columnNames", columnNames);

        return null;
    }

    public ModelAndView getColumnNames(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {

        HttpSession session = request.getSession();

        ObjectMapper mapper = new ObjectMapper();

        ServletOutputStream out;
        response.setContentType("application/text");
        out = response.getOutputStream();

        out.write(mapper.writeValueAsBytes(session.getAttribute("columnNames")));
        out.flush();
        out.close();

        return null;
    }

    public ModelAndView getTableNames(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {

        HttpSession session = request.getSession();

        ObjectMapper mapper = new ObjectMapper();

        ServletOutputStream out;
        response.setContentType("application/text");
        out = response.getOutputStream();

        out.write(mapper.writeValueAsBytes(session.getAttribute("tableNames")));
        out.flush();
        out.close();

        return null;
    }

}