1 files changed, 113 insertions, 0 deletions
diff --git a/israfil-foundation-testing/src/test/java/net/israfil/foundation/mock/sql/MockResultSetMetaDataTest.java b/israfil-foundation-testing/src/test/java/net/israfil/foundation/mock/sql/MockResultSetMetaDataTest.java
new file mode 100644
index 0000000..8a2d7c8
--- /dev/null
+++ b/israfil-foundation-testing/src/test/java/net/israfil/foundation/mock/sql/MockResultSetMetaDataTest.java
@@ -0,0 +1,113 @@
+/*
+ * Copyright © 2003-2009 Israfil Consulting Services Corporation
+ * Copyright © 2003-2009 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: MockResultSetMetaDataTest.java 130 2006-12-31 23:22:17Z cgruber $
+ */
+package net.israfil.foundation.mock.sql;
+
+import java.sql.SQLException;
+
+import net.israfil.foundation.mock.sql.MockResultSetMetaData.ColSpec;
+import net.israfil.foundation.mock.sql.MockResultSetMetaData.DBType;
+
+import org.testng.Assert;
+import org.testng.annotations.Test;
+
+/**
+ * 
+ * @author <a href="mailto:cgruber@israfil.net">Christian Edward Gruber </a>
+ * @author Latest: $Author: cgruber $
+ * @version $Revision: 130 $
+ */
+public class MockResultSetMetaDataTest   {
+
+	
+	public MockResultSetMetaDataTest() {
+		super();
+	}
+	
+	@Test
+	public void testResultSetMetaDataCreation() throws SQLException {
+		String colA = "colA", colB = "colB", colC = "colC";
+		String[] cols = { colA, colB, colC };
+		MockResultSetMetaData rsmd = new MockResultSetMetaData(cols);
+		Assert.assertEquals(3,rsmd.getColumnCount());
+		Assert.assertEquals(colA,rsmd.getColumnName(1));
+		Assert.assertEquals(colB,rsmd.getColumnName(2));
+		Assert.assertEquals(colC,rsmd.getColumnName(3));
+	}
+
+	@Test
+	public void testResultSetMetaDataColumnReferencing() throws SQLException {
+		String colA = "colA", colB = "colB", colC = "colC";
+		String[] cols = { colA, colB, colC };
+		MockResultSetMetaData rsmd = new MockResultSetMetaData(cols);
+		
+		Assert.assertEquals(3,rsmd.getColumnCount());
+		
+		Assert.assertEquals(colA,rsmd.getColumnName(1));
+		Assert.assertEquals(colB,rsmd.getColumnName(2));
+		Assert.assertEquals(colC,rsmd.getColumnName(3));
+
+		Assert.assertEquals(1,rsmd.getColumnNumber(colA));
+		Assert.assertEquals(2,rsmd.getColumnNumber(colB));
+		Assert.assertEquals(3,rsmd.getColumnNumber(colC));
+	}
+	
+	@Test
+	public void testResultSetMetaDataCreationWithColDefs() throws SQLException {
+		ColSpec colA = new ColSpec("colA", DBType.STRING, 12 );
+		ColSpec colB = new ColSpec("colB", DBType.INTEGER, 5, 0 );
+		ColSpec colC = new ColSpec("colC", DBType.DECIMAL, 3, 5, false);
+		ColSpec colD = new ColSpec("colD", DBType.STRING, 4, false);
+		ColSpec[] cols = { colA, colB, colC, colD };
+		MockResultSetMetaData rsmd = new MockResultSetMetaData(cols);
+		Assert.assertEquals(4,rsmd.getColumnCount());
+		
+		Assert.assertEquals(colA.name,rsmd.getColumnName(1));
+		Assert.assertEquals(colB.name,rsmd.getColumnName(2));
+		Assert.assertEquals(colC.name,rsmd.getColumnName(3));
+		Assert.assertEquals(colD.name,rsmd.getColumnName(4));
+		
+		Assert.assertEquals(colA.type.sqltype,rsmd.getColumnType(1));
+		Assert.assertEquals(colB.type.sqltype,rsmd.getColumnType(2));
+		Assert.assertEquals(colC.type.sqltype,rsmd.getColumnType(3));
+		Assert.assertEquals(colD.type.sqltype,rsmd.getColumnType(4));
+		
+		Assert.assertEquals(colA.width,rsmd.getColumnDisplaySize(1));
+		Assert.assertEquals(colB.precision,rsmd.getPrecision(2));
+		Assert.assertEquals(colB.scale,rsmd.getScale(2));
+		Assert.assertEquals(colC.precision,rsmd.getPrecision(3));
+		Assert.assertEquals(colC.scale,rsmd.getScale(3));
+		Assert.assertEquals(colD.width,rsmd.getColumnDisplaySize(4));
+	}
+	
+}