/**
 * Helios, OpenSource Monitoring
 * Brought to you by the Helios Development Group
 *
 * Copyright 2013, Helios Development Group and individual contributors
 * as indicated by the @author tags. See the copyright.txt file in the
 * distribution for a full listing of individual contributors.
 *
 * This is free software; you can redistribute it and/or modify it
 * under the terms of the GNU Lesser General Public License as
 * published by the Free Software Foundation; either version 2.1 of
 * the License, or (at your option) any later version.
 *
 * This software 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
 * Lesser General Public License for more details.
 *
 * You should have received a copy of the GNU Lesser General Public
 * License along with this software; if not, write to the Free
 * Software Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA
 * 02110-1301 USA, or see the FSF site: http://www.fsf.org. 
 *
 */
package org.helios.apmrouter.catalog.jdbc.h2;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;

import org.apache.log4j.Logger;
import org.h2.tools.TriggerAdapter;

/**
 * <p>Title: AgentSelectTrigger</p>
 * <p>Description: </p> 
 * <p>Company: Helios Development Group LLC</p>
 * @author Whitehead (nwhitehead AT heliosdev DOT org)
 * <p><code>org.helios.apmrouter.catalog.jdbc.h2.AgentSelectTrigger</code></p>
 */

public class AgentSelectTrigger extends TriggerAdapter {
	/** Instance logger */
	protected final Logger log = Logger.getLogger(getClass());

	/**
	 * Creates a new AgentSelectTrigger
	 */
	public AgentSelectTrigger() {
		// TODO Auto-generated constructor stub
	}

	/**
	 * {@inheritDoc}
	 * @see org.h2.tools.TriggerAdapter#fire(java.sql.Connection, java.sql.ResultSet, java.sql.ResultSet)
	 */
	@Override
	public void fire(Connection conn, ResultSet oldRow, ResultSet newRow) throws SQLException {
		log.info("\n\t=================\n\tSELECT TRIGGER:\n\tOldRow:" + format(oldRow) + "\n\tNewRow:" + format(newRow) + "\n\t=================\n");		

	}
	
	protected static String format(ResultSet rs) throws SQLException {
		StringBuilder b = new StringBuilder("ResultSet [");
		if(rs==null) {
			b.append("\n\tNULL.");
		} else {
			ResultSetMetaData rsmd = rs.getMetaData();
			while(rs.next()) {
				b.append("\n\t-->");
				for(int i = 0; i < rsmd.getColumnCount(); i++) {
					Object value = rs.getObject(i+1);
					if(value==null) value = "<null>";
					b.append(rsmd.getColumnDisplaySize(i+1)).append(":[").append(value).append("],");
				}
				b.deleteCharAt(b.length()-1);
				b.append("<--");
			}
		}
		b.append("\n]");
		return b.toString();
	}

}