/***
    * License Agreement.
    * 
    * JSPA (POJO-SP)
    * 
    * Copyright (C) 2009 HRX Pty Ltd
    * 
    * This file is part of JSPA.
    * 
   * JSPA is free software: you can redistribute it and/or modify it under the
   * terms of the GNU Lesser General Public License version 3 as published by the
   * Free Software Foundation.
   * 
   * JSPA 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 Lesser General Public License for more details.
   * 
   * You should have received a copy of the GNU Lesser General Public License
   * along with JSPA. If not, see <http://www.gnu.org/licenses/>.
   */
  package com.hrx.rasp.util.dao.metadata;
  
  import java.lang.reflect.Field;
  import java.util.HashSet;
  import java.util.Set;
  
  import com.hrx.rasp.util.dao.ResultSetProcessor;
  import com.hrx.rasp.util.dao.annotations.IN;
  import com.hrx.rasp.util.dao.annotations.INOUT;
  import com.hrx.rasp.util.dao.annotations.OUT;
  import com.hrx.rasp.util.dao.annotations.Operation;
  import com.hrx.rasp.util.dao.operation.OperationType;
  
  /***
   * @author dan.stoica <dan.stoica@acslink.net.au>
   * 
   */
  public class StoredProcMetaDataImpl implements StoredProcMetaData
  {
  	private long startTime = 0;
  	private OperationType operation;
  	private String procName;
  
  	private Class<?> functionReturnClass;
  	private Class<ResultSetProcessor<Object>> resultSetProcessorClass;
  
  	private StoredProcPkMetaData embeddedIdMetaData;
  	private Field embeddedIdField;
  
  	private int errorCodeIndex;
  	private int errorMessageIndex;
  
  	/***
  	 * The maximum number of results to retrieve from result set.
  	 * 
  	 */
  	private int maxResult = 0;
  
  	/***
  	 * The start position of the first result, numbered from 0 for ResutlSet
  	 * parameters
  	 */
  	private int startPosition = 0;
  
  	private boolean defaultErrorIndex;
  
  	private boolean embeddedId = false;
  	/***
  	 * <parameter index, Oracle SQL Type>
  	 */
  	private final Set<StoredProcField<IN>> paramsIn = new HashSet<StoredProcField<IN>>();
  	private final Set<StoredProcField<OUT>> paramsOut = new HashSet<StoredProcField<OUT>>();
  	private final Set<StoredProcField<INOUT>> paramsInOUT = new HashSet<StoredProcField<INOUT>>();
  	// primary key can be any type (IN, OUT or INOUT)
  	private final Set<StoredProcField<?>> primaryKeyParameters = new HashSet<StoredProcField<?>>();
  	private int argCount;
  
  	public void clear()
  	{
  		this.argCount = 0;
  		this.procName = null;
  		this.embeddedIdField = null;
  		this.embeddedIdMetaData = null;
  		this.functionReturnClass = null;
  		this.resultSetProcessorClass = null;
  		paramsIn.clear();
  		paramsOut.clear();
  		paramsInOUT.clear();
  		embeddedId = false;
  		primaryKeyParameters.clear();
  	}
  
  	public void putInParameter(StoredProcField<IN> spField)
  	{
  		paramsIn.add(spField);
  		putPkParameter(spField);
  	}
  
  	public void putOutParameter(StoredProcField<OUT> spField)
 	{
 		paramsOut.add(spField);
 		putPkParameter(spField);
 	}
 
 	public void putInOutParameter(StoredProcField<INOUT> spField)
 	{
 		paramsInOUT.add(spField);
 		putPkParameter(spField);
 	}
 
 	public void putPkParameter(StoredProcField<?> spField)
 	{
 		if (spField.isPrimaryKey() && !isEmbeddedId())
 		{
 			this.primaryKeyParameters.add(spField);
 		}
 	}
 
 	/***
 	 * @return the paramsIn
 	 */
 	public Set<StoredProcField<IN>> getInParameters()
 	{
 		return paramsIn;
 	}
 
 	/***
 	 * @return the paramsOut
 	 */
 	public Set<StoredProcField<OUT>> getOutParameters()
 	{
 		return paramsOut;
 	}
 
 	/***
 	 * @return
 	 */
 	public Set<StoredProcField<INOUT>> getInOutParameters()
 	{
 		return paramsInOUT;
 	}
 
 	public Set<StoredProcField<?>> getPrimaryKeyParameters()
 	{
 		return primaryKeyParameters;
 	}
 
 	/***
 	 * @return the procName
 	 */
 	public String getStoredProcName()
 	{
 		return procName;
 	}
 
 	/***
 	 * @param procName
 	 *            the procName to set
 	 */
 	public void setStoredProcName(String procName)
 	{
 		this.procName = procName;
 	}
 
 	public int getArgCount()
 	{
 		if (argCount == 0)
 		{
 			argCount = this.paramsIn.size() + paramsOut.size() + paramsInOUT.size() + primaryKeyParameters.size();
 			if (embeddedIdMetaData != null)
 			{
 				argCount = argCount + this.embeddedIdMetaData.getArgCount();
 			}
 		}
 		return argCount;
 	}
 
 	public void setEmbeddedId(Field embeddedIdField, StoredProcPkMetaData embeddedIdMetaData)
 	{
 		this.embeddedId = true;
 		this.embeddedIdField = embeddedIdField;
 		this.embeddedIdMetaData = embeddedIdMetaData;
 		this.primaryKeyParameters.clear();
 	}
 
 	public Field getEmbeddedIdField()
 	{
 		return embeddedIdField;
 	}
 
 	public StoredProcPkMetaData getEmbeddedIdMetaData()
 	{
 		return embeddedIdMetaData;
 	}
 
 	public OperationType getOperationType()
 	{
 		return operation;
 	}
 
 	public void prepare(Operation operation, int errorCodeIndex, int errorMessageIndex)
 	{
 		clear();
 		setOperationType(operation.type());
 		setStoredProcName(operation.name());
 		setErrorCodeIndex(errorCodeIndex);
 		setErrorMessageIndex(errorMessageIndex);
 	}
 
 	public void setOperationType(OperationType operation)
 	{
 		this.operation = operation;
 	}
 
 	/***
 	 * @return the resultSetProcessorClass
 	 */
 	public Class<ResultSetProcessor<Object>> getResultSetProcessorClass()
 	{
 		return (Class<ResultSetProcessor<Object>>) resultSetProcessorClass;
 	}
 
 	/***
 	 * @param resultSetProcessorClass
 	 *            the resultSetProcessorClass to set
 	 */
 	public void setResultSetProcessorClass(Class<ResultSetProcessor<Object>> resultSetProcessorClass)
 	{
 		this.resultSetProcessorClass = resultSetProcessorClass;
 	}
 
 	/***
 	 * @return the functionReturnClass
 	 */
 	public Class<?> getFunctionReturnClass()
 	{
 		return functionReturnClass;
 	}
 
 	/***
 	 * @param functionReturnClass
 	 *            the functionReturnClass to set
 	 */
 	public void setFunctionReturnClass(Class<?> functionReturnClass)
 	{
 		this.functionReturnClass = functionReturnClass;
 	}
 
 	/***
 	 * @return the embeddedId
 	 */
 	public boolean isEmbeddedId()
 	{
 		return embeddedId;
 	}
 
 	/***
 	 * @return the errorCodeIndex
 	 */
 	public int getErrorCodeIndex()
 	{
 		return errorCodeIndex;
 	}
 
 	/***
 	 * @param errorCodeIndex
 	 *            the errorCodeIndex to set
 	 */
 	public void setErrorCodeIndex(int errorCodeIndex)
 	{
 		this.errorCodeIndex = errorCodeIndex;
 	}
 
 	/***
 	 * @return the errorMessageIndex
 	 */
 	public int getErrorMessageIndex()
 	{
 		return errorMessageIndex;
 	}
 
 	/***
 	 * @param errorMessageIndex
 	 *            the errorMessageIndex to set
 	 */
 	public void setErrorMessageIndex(int errorMessageIndex)
 	{
 		this.errorMessageIndex = errorMessageIndex;
 	}
 
 	/***
 	 * @return the defaultErrorIndex
 	 */
 	public boolean isDefaultErrorIndex()
 	{
 		return defaultErrorIndex;
 	}
 
 	/***
 	 * @param defaultErrorIndex
 	 *            the defaultErrorIndex to set
 	 */
 	public void setDefaultErrorIndex(boolean defaultErrorIndex)
 	{
 		this.defaultErrorIndex = defaultErrorIndex;
 	}
 
 	/***
 	 * @return the maxResult
 	 */
 	public int getMaxResult()
 	{
 		return maxResult;
 	}
 
 	/***
 	 * @param maxResult
 	 *            the maxResult to set
 	 */
 	public void setMaxResult(int maxResult)
 	{
 		this.maxResult = maxResult;
 	}
 
 	/***
 	 * @return the startPosition
 	 */
 	public int getStartPosition()
 	{
 		return startPosition;
 	}
 
 	/***
 	 * @param startPosition
 	 *            the startPosition to set
 	 */
 	public void setStartPosition(int startPosition)
 	{
 		this.startPosition = startPosition;
 	}
 
 	/***
 	 * @return the startTime
 	 */
 	public long getStartTime()
 	{
 		return startTime;
 	}
 
 	/***
 	 * @param startTime
 	 *            the startTime to set
 	 */
 	public void startTimer()
 	{
 		this.startTime = System.currentTimeMillis();
 	}
 
 }