PostgreSQLProcedureExecuter.java

/*******************************************************************************
 * 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.procedure;

import java.util.List;

import org.apache.commons.lang.StringUtils;
import org.apache.log4j.Logger;

import com.hangum.tadpole.engine.query.dao.mysql.ProcedureFunctionDAO;
import com.hangum.tadpole.engine.query.dao.rdb.InOutParameterDAO;
import com.hangum.tadpole.engine.query.dao.system.UserDBDAO;

/**
 * oracle procedure executer
 * 
 * ex) http://www.postgresql.org/docs/9.1/static/xfunc-sql.html
 * 
 * @author hangum
 * @author nilriri
 */

public class PostgreSQLProcedureExecuter extends ProcedureExecutor {
	/**
	 * Logger for this class
	 */
	private static final Logger logger = Logger.getLogger(PostgreSQLProcedureExecuter.class);

	/**
	 * 
	 * @param procedureDAO
	 * @param userDB
	 */
	public PostgreSQLProcedureExecuter(ProcedureFunctionDAO procedureDAO, UserDBDAO userDB) {
		super(procedureDAO, userDB);
	}
	
	/**
	 * execute script
	 */
	public String getMakeExecuteScript() throws Exception {
		StringBuffer sbQuery = new StringBuffer();
		if(!"".equals(procedureDAO.getPackagename())){
			sbQuery.append("SELECT " + procedureDAO.getPackagename() + "." + procedureDAO.getSysName() + "(");
		}else{
			sbQuery.append("SELECT " + procedureDAO.getSysName() + "(");
		}
		
		List<InOutParameterDAO> inList = getInParameters();
		InOutParameterDAO inOutParameterDAO = inList.get(0);
		String[] inParams = StringUtils.split(inOutParameterDAO.getRdbType(), ",");
		for(int i=0; i<inParams.length; i++) {
			String name = StringUtils.trimToEmpty(inParams[i]);
			
			if(i == (inParams.length-1)) sbQuery.append(String.format(":%s", name));
			else sbQuery.append(String.format(":%s, ", name));
		}
		sbQuery.append(");");

		if(logger.isDebugEnabled()) logger.debug("Execute Procedure query is\t  " + sbQuery.toString());
		
		return sbQuery.toString();
	}
	
	@Override
	public boolean exec(List<InOutParameterDAO> parameterList)  throws Exception {
		throw new Exception("Do now use the method");
	}

}