com.hangum.tadpole.engine.sql.util.executer.ProcedureExecuterManager.java Source code

Introduction

Here is the source code for com.hangum.tadpole.engine.sql.util.executer.ProcedureExecuterManager.java

Source

/*******************************************************************************
 * Copyright (c) 2013 hangum.
 * All rights reserved. This program and the accompanying materials
 * are made available under the terms of the GNU Lesser Public License v2.1
 * which accompanies this distribution, and is available at
 * http://www.gnu.org/licenses/old-licenses/gpl-2.0.html
 * 
 * Contributors:
 *     hangum - initial API and implementation
 ******************************************************************************/
package com.hangum.tadpole.engine.sql.util.executer;

import org.apache.commons.lang.StringUtils;
import org.apache.log4j.Logger;
import org.eclipse.jface.dialogs.MessageDialog;

import com.hangum.tadpole.engine.Messages;
import com.hangum.tadpole.engine.define.DBDefine;
import com.hangum.tadpole.engine.manager.TadpoleSQLManager;
import com.hangum.tadpole.engine.query.dao.DBInfoDAO;
import com.hangum.tadpole.engine.query.dao.mysql.ProcedureFunctionDAO;
import com.hangum.tadpole.engine.query.dao.system.UserDBDAO;
import com.hangum.tadpole.engine.sql.util.executer.procedure.MSSQLProcedureExecuter;
import com.hangum.tadpole.engine.sql.util.executer.procedure.MySqlProcedureExecuter;
import com.hangum.tadpole.engine.sql.util.executer.procedure.OracleProcedureExecuter;
import com.hangum.tadpole.engine.sql.util.executer.procedure.PostgreSQLProcedureExecuter;
import com.hangum.tadpole.engine.sql.util.executer.procedure.ProcedureExecutor;
import com.ibatis.sqlmap.client.SqlMapClient;

/**
 * RDB procedure executer manager
 * 
 * @author hangum
 *
 */
public class ProcedureExecuterManager {
    /**
     * Logger for this class
     */
    private static final Logger logger = Logger.getLogger(ProcedureExecuterManager.class);

    protected UserDBDAO userDB;
    protected ProcedureFunctionDAO procedureDAO;

    public ProcedureExecuterManager(UserDBDAO userDB, ProcedureFunctionDAO procedureDAO) {
        this.userDB = userDB;
        this.procedureDAO = procedureDAO;
    }

    /**
     * return procedure executer
     * 
     * @return
     * @throws Exception
     */
    public ProcedureExecutor getExecuter() throws Exception {
        if (userDB.getDBDefine() == DBDefine.ORACLE_DEFAULT | userDB.getDBDefine() == DBDefine.TIBERO_DEFAULT) {
            return new OracleProcedureExecuter(procedureDAO, userDB);
        } else if (userDB.getDBDefine() == DBDefine.MSSQL_8_LE_DEFAULT
                || userDB.getDBDefine() == DBDefine.MSSQL_DEFAULT) {
            return new MSSQLProcedureExecuter(procedureDAO, userDB);
        } else if (userDB.getDBDefine() == DBDefine.MYSQL_DEFAULT
                || userDB.getDBDefine() == DBDefine.MARIADB_DEFAULT) {
            return new MySqlProcedureExecuter(procedureDAO, userDB);
        } else if (userDB.getDBDefine() == DBDefine.POSTGRE_DEFAULT) {
            return new PostgreSQLProcedureExecuter(procedureDAO, userDB);
        } else {
            throw new Exception(Messages.get().ProcedureExecuterManager_0);
        }
    }

    /**
     * DB is that it supports?
     * 
     * @return
     */
    public boolean isSupport() {
        try {
            getExecuter();

            return true;
        } catch (Exception e) {
            return false;
        }
    }

    /**
     * Is executed procedure?
     * 
     * @param procedureDAO
     * @param useDB
     * @return
     */
    public boolean isExecuted(ProcedureFunctionDAO procedureDAO, UserDBDAO selectUseDB) {
        if (!isSupport()) {
            MessageDialog.openWarning(null, Messages.get().Warning, Messages.get().ProcedureExecuterManager_0);
            return false;
        }
        if (!procedureDAO.isValid()) {
            MessageDialog.openWarning(null, Messages.get().Warning, Messages.get().ProcedureExecuterManager_4);
            return false;
        }

        if (userDB.getDBDefine() == DBDefine.MYSQL_DEFAULT) {
            double dbVersion = 0.0;
            try {
                SqlMapClient sqlClient = TadpoleSQLManager.getInstance(userDB);
                DBInfoDAO dbInfo = (DBInfoDAO) sqlClient.queryForObject("findDBInfo"); //$NON-NLS-1$
                dbVersion = Double.parseDouble(StringUtils.substring(dbInfo.getProductversion(), 0, 3));

                if (dbVersion < 5.5) {
                    MessageDialog.openInformation(null, Messages.get().Information,
                            Messages.get().ProcedureExecuterManager_6);
                    return false;
                }
            } catch (Exception e) {
                logger.error("find DB info", e); //$NON-NLS-1$

                return false;
            }

        }

        try {
            ProcedureExecutor procedureExecutor = getExecuter();
            procedureExecutor.getInParameters();
        } catch (Exception e) {
            MessageDialog.openError(null, Messages.get().Error, e.getMessage());
            return false;
        }

        return true;
    }

}