nyla.solutions.dao.patterns.command.SqlFileExecuteCommand Maven / Gradle / Ivy

Go to download
package nyla.solutions.dao.patterns.command;

import nyla.solutions.dao.AbstractDaoOperation;
import nyla.solutions.dao.SQL;
import nyla.solutions.global.exception.ConfigException;
import nyla.solutions.global.exception.SetupException;
import nyla.solutions.global.exception.SystemException;
import nyla.solutions.global.io.IO;

import java.io.IOException;
import java.sql.*;

import nyla.solutions.global.patterns.command.Command;
/**
 *  
 * @author Gregory Green
 * @version 1.0
 *
 *  * SqlFileExecuteCommand execute SQL statement in a file
 * indicate by an input argument or the getSql property.
 * 
 * 

 * 
 */
public class  SqlFileExecuteCommand extends AbstractDaoOperation
implements Command
{
	/**
	 * Execute a single SQL statement
	 */
	public Boolean execute(String filePath)
	{		
		
		if(filePath == null || filePath.length() == 0)
			filePath = this.getSql();
		
		
		 if(filePath== null || filePath.length() == 0)
	         throw new ConfigException("File path not provide and a default is not on Property \"filePath\" of "+this.getClass().getName());
	      
	      SQL sql = null;
	      
	      //read SQL from file
	      String sqlText = null;
	     
	      
	      try
	      {
	    	  sqlText = IO.readFile(filePath);
	    	  
	         sql = this.connect();
	         
	         boolean results = sql.execute(sqlText);
	         sql.commit();
	         
	         return new Boolean(results);
	      }
	      catch(SQLException e)
	      {
	         sql.rollback();
	         throw new SystemException("Sql="+sqlText+" ERROR:"+e.getMessage(),e);
	      }
	      catch(IOException e)
	      {
	    	  throw new SetupException("File path "+filePath+" ERROR:"+e.getMessage(),e);
	      }
	      finally
	      {
	         if(sql != null)
	            sql.dispose();
	      }      
	}//---------------------------------------------
	

}