/*
 * Copyright (c) 2007, 2008, 2009, 2010, 2011, 2012, 2013, 2014, 2015, 2016, 2017 David Berkman
 * 
 * This file is part of the SmallMind Code Project.
 * 
 * The SmallMind Code Project is free software, you can redistribute
 * it and/or modify it under either, at your discretion...
 * 
 * 1) The terms of 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.
 * 
 * ...or...
 * 
 * 2) The terms of the Apache License, Version 2.0.
 * 
 * The SmallMind Code Project 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
 * General Public License or Apache License for more details.
 * 
 * You should have received a copy of the GNU Affero General Public License
 * and the Apache License along with the SmallMind Code Project. If not, see
 * <http://www.gnu.org/licenses/> or <http://www.apache.org/licenses/LICENSE-2.0>.
 * 
 * Additional permission under the GNU Affero GPL version 3 section 7
 * ------------------------------------------------------------------
 * If you modify this Program, or any covered work, by linking or
 * combining it with other code, such other code is not for that reason
 * alone subject to any of the requirements of the GNU Affero GPL
 * version 3.
 */
package org.smallmind.persistence.sql;

import java.io.PrintWriter;
import java.lang.reflect.InvocationHandler;
import java.lang.reflect.Method;
import java.lang.reflect.Proxy;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.util.UUID;
import java.util.concurrent.atomic.AtomicBoolean;
import javax.sql.StatementEvent;
import javax.sql.StatementEventListener;

public class PooledPreparedStatement implements InvocationHandler {

  private AbstractPooledConnection<?> pooledConnection;
  private PreparedStatement actualStatement;
  private PreparedStatement proxyStatement;
  private String statementId;
  private AtomicBoolean closed = new AtomicBoolean(false);

  public PooledPreparedStatement (AbstractPooledConnection<?> pooledConnection, PreparedStatement actualStatement) {

    this.pooledConnection = pooledConnection;
    this.actualStatement = actualStatement;

    statementId = UUID.randomUUID().toString();
    proxyStatement = (PreparedStatement)(Proxy.newProxyInstance(PooledPreparedStatement.class.getClassLoader(), new Class[] {PreparedStatement.class}, this));
  }

  public Object invoke (Object proxy, Method method, Object[] args)
    throws Throwable {

    if (method.getName().equals("close")) {

      StatementEvent event = new PooledPreparedStatementEvent(pooledConnection, actualStatement, statementId);

      for (StatementEventListener listener : pooledConnection.getStatementEventListeners()) {
        listener.statementClosed(event);
      }

      return null;
    }
    else {
      try {
        return method.invoke(actualStatement, args);
      }
      catch (Throwable throwable) {
        if (throwable instanceof SQLException) {

          StatementEvent event = new PooledPreparedStatementEvent(pooledConnection, actualStatement, (SQLException)throwable, statementId);

          for (StatementEventListener listener : pooledConnection.getStatementEventListeners()) {
            listener.statementErrorOccurred(event);
          }
        }

        throw throwable;
      }
    }
  }

  public String getStatementId () {

    return statementId;
  }

  public PreparedStatement getPreparedStatement () {

    return proxyStatement;
  }

  public PrintWriter getLogWriter ()
    throws SQLException {

    return pooledConnection.getLogWriter();
  }

  public void close ()
    throws SQLException {

    if (closed.compareAndSet(false, true)) {
      actualStatement.close();
    }
  }

  public void finalize ()
    throws SQLException {

    try {
      close();
    }
    catch (SQLException sqlExecption) {

      PrintWriter logWriter;

      if ((logWriter = getLogWriter()) != null) {
        sqlExecption.printStackTrace(logWriter);
      }
    }
  }
}