You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@commons.apache.org by df...@apache.org on 2009/03/11 01:36:43 UTC
svn commit: r752322 - in
/commons/proper/dbutils/trunk/src/test/org/apache/commons/dbutils: ./
handlers/
Author: dfabulich
Date: Wed Mar 11 00:36:43 2009
New Revision: 752322
URL: http://svn.apache.org/viewvc?rev=752322&view=rev
Log:
Fixing tests based on sebb's feedback.
Modified:
commons/proper/dbutils/trunk/src/test/org/apache/commons/dbutils/BasicRowProcessorTest.java
commons/proper/dbutils/trunk/src/test/org/apache/commons/dbutils/BeanProcessorTest.java
commons/proper/dbutils/trunk/src/test/org/apache/commons/dbutils/ProxyFactoryTest.java
commons/proper/dbutils/trunk/src/test/org/apache/commons/dbutils/ResultSetIteratorTest.java
commons/proper/dbutils/trunk/src/test/org/apache/commons/dbutils/handlers/ArrayListHandlerTest.java
commons/proper/dbutils/trunk/src/test/org/apache/commons/dbutils/handlers/BeanListHandlerTest.java
commons/proper/dbutils/trunk/src/test/org/apache/commons/dbutils/handlers/MapListHandlerTest.java
Modified: commons/proper/dbutils/trunk/src/test/org/apache/commons/dbutils/BasicRowProcessorTest.java
URL: http://svn.apache.org/viewvc/commons/proper/dbutils/trunk/src/test/org/apache/commons/dbutils/BasicRowProcessorTest.java?rev=752322&r1=752321&r2=752322&view=diff
==============================================================================
--- commons/proper/dbutils/trunk/src/test/org/apache/commons/dbutils/BasicRowProcessorTest.java (original)
+++ commons/proper/dbutils/trunk/src/test/org/apache/commons/dbutils/BasicRowProcessorTest.java Wed Mar 11 00:36:43 2009
@@ -40,43 +40,53 @@
public void testToArray() throws SQLException {
- int rowCount = 0;
Object[] a = null;
- while (this.rs.next()) {
- a = processor.toArray(this.rs);
- assertEquals(COLS, a.length);
- rowCount++;
- }
+ assertTrue(this.rs.next());
+ a = processor.toArray(this.rs);
+ assertEquals(COLS, a.length);
+ assertEquals("1", a[0]);
+ assertEquals("2", a[1]);
+ assertEquals("3", a[2]);
+
+ assertTrue(this.rs.next());
+ a = processor.toArray(this.rs);
+ assertEquals(COLS, a.length);
- assertEquals(ROWS, rowCount);
assertEquals("4", a[0]);
assertEquals("5", a[1]);
assertEquals("6", a[2]);
+
+ assertFalse(this.rs.next());
}
public void testToBean() throws SQLException, ParseException {
- int rowCount = 0;
- TestBean b = null;
- while (this.rs.next()) {
- b = (TestBean) processor.toBean(this.rs, TestBean.class);
- assertNotNull(b);
- rowCount++;
- }
-
- assertEquals(ROWS, rowCount);
- assertEquals("4", b.getOne());
- assertEquals("5", b.getTwo());
- assertEquals("6", b.getThree());
- assertEquals("not set", b.getDoNotSet());
- assertEquals(3, b.getIntTest());
- assertEquals(new Integer(4), b.getIntegerTest());
- assertEquals(null, b.getNullObjectTest());
- assertEquals(0, b.getNullPrimitiveTest());
+ TestBean row = null;
+ assertTrue(this.rs.next());
+ row = (TestBean) processor.toBean(this.rs, TestBean.class);
+ assertEquals("1", row.getOne());
+ assertEquals("2", row.getTwo());
+ assertEquals("3", row.getThree());
+ assertEquals("not set", row.getDoNotSet());
+
+ assertTrue(this.rs.next());
+ row = (TestBean) processor.toBean(this.rs, TestBean.class);
+
+ assertEquals("4", row.getOne());
+ assertEquals("5", row.getTwo());
+ assertEquals("6", row.getThree());
+ assertEquals("not set", row.getDoNotSet());
+ assertEquals(3, row.getIntTest());
+ assertEquals(new Integer(4), row.getIntegerTest());
+ assertEquals(null, row.getNullObjectTest());
+ assertEquals(0, row.getNullPrimitiveTest());
// test date -> string handling
- assertNotNull(b.getNotDate());
- assertTrue(!"not a date".equals(b.getNotDate()));
- datef.parse(b.getNotDate());
+ assertNotNull(row.getNotDate());
+ assertTrue(!"not a date".equals(row.getNotDate()));
+ datef.parse(row.getNotDate());
+
+ assertFalse(this.rs.next());
+
}
public void testToBeanList() throws SQLException, ParseException {
@@ -85,8 +95,13 @@
assertNotNull(list);
assertEquals(ROWS, list.size());
- TestBean b = (TestBean) list.get(1);
-
+ TestBean b = (TestBean) list.get(0);
+ assertEquals("1", b.getOne());
+ assertEquals("2", b.getTwo());
+ assertEquals("3", b.getThree());
+ assertEquals("not set", b.getDoNotSet());
+
+ b = (TestBean) list.get(1);
assertEquals("4", b.getOne());
assertEquals("5", b.getTwo());
assertEquals("6", b.getThree());
@@ -103,19 +118,22 @@
public void testToMap() throws SQLException {
- int rowCount = 0;
- Map m = null;
- while (this.rs.next()) {
- m = processor.toMap(this.rs);
- assertNotNull(m);
- assertEquals(COLS, m.keySet().size());
- rowCount++;
- }
+ assertTrue(this.rs.next());
+ Map m = processor.toMap(this.rs);
+ assertEquals(COLS, m.keySet().size());
+ assertEquals("1", m.get("one"));
+ assertEquals("2", m.get("TWO"));
+ assertEquals("3", m.get("Three"));
+
+ assertTrue(this.rs.next());
+ m = processor.toMap(this.rs);
+ assertEquals(COLS, m.keySet().size());
- assertEquals(ROWS, rowCount);
assertEquals("4", m.get("One")); // case shouldn't matter
assertEquals("5", m.get("two"));
assertEquals("6", m.get("THREE"));
+
+ assertFalse(this.rs.next());
}
}
Modified: commons/proper/dbutils/trunk/src/test/org/apache/commons/dbutils/BeanProcessorTest.java
URL: http://svn.apache.org/viewvc/commons/proper/dbutils/trunk/src/test/org/apache/commons/dbutils/BeanProcessorTest.java?rev=752322&r1=752321&r2=752322&view=diff
==============================================================================
--- commons/proper/dbutils/trunk/src/test/org/apache/commons/dbutils/BeanProcessorTest.java (original)
+++ commons/proper/dbutils/trunk/src/test/org/apache/commons/dbutils/BeanProcessorTest.java Wed Mar 11 00:36:43 2009
@@ -23,16 +23,16 @@
private static final BeanProcessor beanProc = new BeanProcessor();
public void testProcess() throws SQLException {
- int rowCount = 0;
TestBean b = null;
- while (this.rs.next()) {
- b = (TestBean) beanProc.toBean(this.rs, TestBean.class);
- assertNotNull(b);
- rowCount++;
- }
-
- assertEquals(ROWS, rowCount);
+ assertTrue(this.rs.next());
+ b = (TestBean) beanProc.toBean(this.rs, TestBean.class);
+ assertEquals(13.0, b.getColumnProcessorDoubleTest(), 0);
+
+ assertTrue(this.rs.next());
+ b = (TestBean) beanProc.toBean(this.rs, TestBean.class);
assertEquals(13.0, b.getColumnProcessorDoubleTest(), 0);
+
+ assertFalse(this.rs.next());
}
}
Modified: commons/proper/dbutils/trunk/src/test/org/apache/commons/dbutils/ProxyFactoryTest.java
URL: http://svn.apache.org/viewvc/commons/proper/dbutils/trunk/src/test/org/apache/commons/dbutils/ProxyFactoryTest.java?rev=752322&r1=752321&r2=752322&view=diff
==============================================================================
--- commons/proper/dbutils/trunk/src/test/org/apache/commons/dbutils/ProxyFactoryTest.java (original)
+++ commons/proper/dbutils/trunk/src/test/org/apache/commons/dbutils/ProxyFactoryTest.java Wed Mar 11 00:36:43 2009
@@ -18,13 +18,6 @@
import java.lang.reflect.InvocationHandler;
import java.lang.reflect.Method;
-import java.sql.CallableStatement;
-import java.sql.Connection;
-import java.sql.Driver;
-import java.sql.PreparedStatement;
-import java.sql.ResultSet;
-import java.sql.ResultSetMetaData;
-import java.sql.Statement;
/**
* ProxyFactoryTest performs simple type checking on proxy objects returned
@@ -42,42 +35,31 @@
};
public void testCreateConnection() {
- assertTrue(
- ProxyFactory.instance().createConnection(stub)
- instanceof Connection);
+ assertNotNull(ProxyFactory.instance().createConnection(stub));
}
public void testCreateDriver() {
- assertTrue(
- ProxyFactory.instance().createDriver(stub) instanceof Driver);
+ assertNotNull(ProxyFactory.instance().createDriver(stub));
}
public void testCreatePreparedStatement() {
- assertTrue(
- ProxyFactory.instance().createPreparedStatement(stub)
- instanceof PreparedStatement);
+ assertNotNull(ProxyFactory.instance().createPreparedStatement(stub));
}
public void testCreateResultSet() {
- assertTrue(
- ProxyFactory.instance().createResultSet(stub) instanceof ResultSet);
+ assertNotNull(ProxyFactory.instance().createResultSet(stub));
}
public void testCreateResultSetMetaData() {
- assertTrue(
- ProxyFactory.instance().createResultSetMetaData(stub)
- instanceof ResultSetMetaData);
+ assertNotNull(ProxyFactory.instance().createResultSetMetaData(stub));
}
public void testCreateStatement() {
- assertTrue(
- ProxyFactory.instance().createStatement(stub) instanceof Statement);
+ assertNotNull(ProxyFactory.instance().createStatement(stub));
}
public void testCreateCallableStatement() {
- assertTrue(
- ProxyFactory.instance().createCallableStatement(stub)
- instanceof CallableStatement);
+ assertNotNull(ProxyFactory.instance().createCallableStatement(stub));
}
}
Modified: commons/proper/dbutils/trunk/src/test/org/apache/commons/dbutils/ResultSetIteratorTest.java
URL: http://svn.apache.org/viewvc/commons/proper/dbutils/trunk/src/test/org/apache/commons/dbutils/ResultSetIteratorTest.java?rev=752322&r1=752321&r2=752322&view=diff
==============================================================================
--- commons/proper/dbutils/trunk/src/test/org/apache/commons/dbutils/ResultSetIteratorTest.java (original)
+++ commons/proper/dbutils/trunk/src/test/org/apache/commons/dbutils/ResultSetIteratorTest.java Wed Mar 11 00:36:43 2009
@@ -27,20 +27,23 @@
Iterator iter = new ResultSetIterator(this.rs);
- int rowCount = 0;
Object[] row = null;
- while (iter.hasNext()) {
- rowCount++;
- row = (Object[]) iter.next();
-
- assertNotNull(row);
- assertEquals(COLS, row.length);
- }
+ assertTrue(iter.hasNext());
+ row = (Object[]) iter.next();
+ assertEquals(COLS, row.length);
+ assertEquals("1", row[0]);
+ assertEquals("2", row[1]);
+ assertEquals("3", row[2]);
+
+ assertTrue(iter.hasNext());
+ row = (Object[]) iter.next();
+ assertEquals(COLS, row.length);
- assertEquals(ROWS, rowCount);
assertEquals("4", row[0]);
assertEquals("5", row[1]);
assertEquals("6", row[2]);
+
+ assertFalse(iter.hasNext());
}
}
Modified: commons/proper/dbutils/trunk/src/test/org/apache/commons/dbutils/handlers/ArrayListHandlerTest.java
URL: http://svn.apache.org/viewvc/commons/proper/dbutils/trunk/src/test/org/apache/commons/dbutils/handlers/ArrayListHandlerTest.java?rev=752322&r1=752321&r2=752322&view=diff
==============================================================================
--- commons/proper/dbutils/trunk/src/test/org/apache/commons/dbutils/handlers/ArrayListHandlerTest.java (original)
+++ commons/proper/dbutils/trunk/src/test/org/apache/commons/dbutils/handlers/ArrayListHandlerTest.java Wed Mar 11 00:36:43 2009
@@ -36,15 +36,23 @@
assertEquals(ROWS, results.size());
Iterator iter = results.iterator();
- Object[] row = null;
- while (iter.hasNext()) {
- row = (Object[]) iter.next();
- assertEquals(COLS, row.length);
- }
+ Object[] row = null;
+ assertTrue(iter.hasNext());
+ row = (Object[]) iter.next();
+ assertEquals(COLS, row.length);
+ assertEquals("1", row[0]);
+ assertEquals("2", row[1]);
+ assertEquals("3", row[2]);
+
+ assertTrue(iter.hasNext());
+ row = (Object[]) iter.next();
+ assertEquals(COLS, row.length);
- assertEquals("4", row[0]);
- assertEquals("5", row[1]);
- assertEquals("6", row[2]);
+ assertEquals("4", row[0]);
+ assertEquals("5", row[1]);
+ assertEquals("6", row[2]);
+
+ assertFalse(iter.hasNext());
}
public void testEmptyResultSetHandle() throws SQLException {
Modified: commons/proper/dbutils/trunk/src/test/org/apache/commons/dbutils/handlers/BeanListHandlerTest.java
URL: http://svn.apache.org/viewvc/commons/proper/dbutils/trunk/src/test/org/apache/commons/dbutils/handlers/BeanListHandlerTest.java?rev=752322&r1=752321&r2=752322&view=diff
==============================================================================
--- commons/proper/dbutils/trunk/src/test/org/apache/commons/dbutils/handlers/BeanListHandlerTest.java (original)
+++ commons/proper/dbutils/trunk/src/test/org/apache/commons/dbutils/handlers/BeanListHandlerTest.java Wed Mar 11 00:36:43 2009
@@ -38,15 +38,22 @@
Iterator iter = results.iterator();
TestBean row = null;
- while (iter.hasNext()) {
- row = (TestBean) iter.next();
- assertNotNull(row);
- }
+ assertTrue(iter.hasNext());
+ row = (TestBean) iter.next();
+ assertEquals("1", row.getOne());
+ assertEquals("2", row.getTwo());
+ assertEquals("3", row.getThree());
+ assertEquals("not set", row.getDoNotSet());
+
+ assertTrue(iter.hasNext());
+ row = (TestBean) iter.next();
- assertEquals("4", row.getOne());
- assertEquals("5", row.getTwo());
- assertEquals("6", row.getThree());
- assertEquals("not set", row.getDoNotSet());
+ assertEquals("4", row.getOne());
+ assertEquals("5", row.getTwo());
+ assertEquals("6", row.getThree());
+ assertEquals("not set", row.getDoNotSet());
+
+ assertFalse(iter.hasNext());
}
public void testEmptyResultSetHandle() throws SQLException {
Modified: commons/proper/dbutils/trunk/src/test/org/apache/commons/dbutils/handlers/MapListHandlerTest.java
URL: http://svn.apache.org/viewvc/commons/proper/dbutils/trunk/src/test/org/apache/commons/dbutils/handlers/MapListHandlerTest.java?rev=752322&r1=752321&r2=752322&view=diff
==============================================================================
--- commons/proper/dbutils/trunk/src/test/org/apache/commons/dbutils/handlers/MapListHandlerTest.java (original)
+++ commons/proper/dbutils/trunk/src/test/org/apache/commons/dbutils/handlers/MapListHandlerTest.java Wed Mar 11 00:36:43 2009
@@ -38,14 +38,22 @@
Iterator iter = results.iterator();
Map row = null;
- while (iter.hasNext()) {
- row = (Map) iter.next();
- assertEquals(COLS, row.keySet().size());
- }
+ assertTrue(iter.hasNext());
+ row = (Map) iter.next();
+ assertEquals(COLS, row.keySet().size());
+ assertEquals("1", row.get("one"));
+ assertEquals("2", row.get("TWO"));
+ assertEquals("3", row.get("Three"));
+
+ assertTrue(iter.hasNext());
+ row = (Map) iter.next();
+ assertEquals(COLS, row.keySet().size());
- assertEquals("4", row.get("one"));
- assertEquals("5", row.get("TWO"));
- assertEquals("6", row.get("Three"));
+ assertEquals("4", row.get("one"));
+ assertEquals("5", row.get("TWO"));
+ assertEquals("6", row.get("Three"));
+
+ assertFalse(iter.hasNext());
}
public void testEmptyResultSetHandle() throws SQLException {