/*
 * Copyright (c) 2003 - 2008 Israfil Consulting Services Corporation
 * Copyright (c) 2003 - 2008 Christian Edward Gruber
 * All Rights Reserved
 * 
 * This software is licensed under the Berkeley Standard Distribution license,
 * (BSD license), as defined below:
 * 
 * Redistribution and use in source and binary forms, with or without 
 * modification, are permitted provided that the following conditions are met:
 *
 * 1. Redistributions of source code must retain the above copyright notice, this 
 *    list of conditions and the following disclaimer.
 * 2. Redistributions in binary form must reproduce the above copyright notice, 
 *    this list of conditions and the following disclaimer in the documentation 
 *    and/or other materials provided with the distribution.
 * 3. Neither the name of Israfil Consulting Services nor the names of its contributors 
 *    may be used to endorse or promote products derived from this software without 
 *    specific prior written permission.
 *
 * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS" AND 
 * ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED 
 * WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED. 
 * IN NO EVENT SHALL THE COPYRIGHT OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, 
 * INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, 
 * BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, 
 * OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, 
 * WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) 
 * ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY 
 * OF SUCH DAMAGE.
 * 
 * $Id: SoloCollectionTest.java 130 2006-12-31 23:22:17Z cgruber $
 */
package net.israfil.foundation.collections;

import java.sql.ResultSet;
import java.util.Map;

import net.israfil.foundation.mock.sql.MockResultSet;

import org.testng.Assert;
import org.testng.annotations.AfterMethod;
import org.testng.annotations.BeforeMethod;
import org.testng.annotations.Test;

/**
 * 
 * @author <a href="mailto:cgruber@israfil.net">Christian Edward Gruber </a>
 * @author Latest: $Author: cgruber $
 * @version $Revision: 26 $
 */
@Test
public class IterableResultSetTest {

	String colA = "columnA", colB = "columnB" , colC = "columnC";
	String[] columns = { colA, colB, colC };
	Object[][] rows = { { new Integer(0), "cBr0", new Float(2.56f) },
						{ new Integer(1), "cBr1", new Float(4.45f) },
						{ new Integer(2), "cBr2", new Float(9.15f) },
						{ new Integer(3), "cBr3", new Float(-25.45f) } };

	IterableResultSet irs;
	ResultSet rs;

	@BeforeMethod
	protected void setUp() throws Exception {
		rs = new MockResultSet(columns,rows);
		irs = new IterableResultSet( rs );
	}
	
	@AfterMethod
	protected void tearDown() throws Exception {
		rs = null;
		irs = null;
	}	
	
	@Test(expectedExceptions={UnsupportedOperationException.class})
	public void testRemove() {
		irs.iterator().remove();
	}	

	public void testIterableRSInAction() throws Throwable {
		rs.last();
		IterableResultSet irs = new IterableResultSet(rs);
		int rowCount = 0;
		for (Map<String,Object> row : irs) {
			rowCount++;
			for(int colNum = 0; colNum < columns.length; colNum++) {
				Assert.assertEquals(rows[rowCount-1][colNum],row.get(columns[colNum]));
			}
		}
		Assert.assertEquals(4,rowCount);
		irs.dispose();
	}
	

}