/**
* Test method for {@link
* org.seasar.framework.mock.sql.MockResultSet#addRowData(org.seasar.framework.util.ArrayMap)}.
*/
public void testAddAndGetRowData() {
MockResultSet rs = new MockResultSet();
ArrayMap rowData = new ArrayMap();
rowData.put("id", new Integer(1));
rs.addRowData(rowData);
assertSame(rowData, rs.getRowData(1));
}
/** @throws Exception */
public void testFirst() throws Exception {
MockResultSet rs = new MockResultSet();
rs.setType(ResultSet.TYPE_SCROLL_INSENSITIVE);
ArrayMap rowData = new ArrayMap();
Timestamp value = new Timestamp(0);
rowData.put("hoge", value);
rs.addRowData(rowData);
assertTrue(rs.first());
assertTrue(rs.isFirst());
}
/** @throws Exception */
public void testIsLast() throws Exception {
MockResultSet rs = new MockResultSet();
ArrayMap rowData = new ArrayMap();
Timestamp value = new Timestamp(0);
rowData.put("hoge", value);
rs.addRowData(rowData);
assertFalse(rs.isLast());
assertTrue(rs.next());
assertTrue(rs.isLast());
}
/** @throws Exception */
public void testGetByte() throws Exception {
MockResultSet rs = new MockResultSet();
ArrayMap rowData = new ArrayMap();
Byte value = new Byte((byte) 1);
rowData.put("hoge", value);
rs.addRowData(rowData);
assertTrue(rs.next());
assertEquals((byte) 1, rs.getByte(1));
assertEquals((byte) 1, rs.getByte("hoge"));
}
/** @throws Exception */
public void testGetString() throws Exception {
MockResultSet rs = new MockResultSet();
ArrayMap rowData = new ArrayMap();
String value = "aaa";
rowData.put("hoge", value);
rs.addRowData(rowData);
assertTrue(rs.next());
assertEquals(value, rs.getString(1));
assertEquals(value, rs.getString("hoge"));
}
/** @throws Exception */
public void testGetShort() throws Exception {
MockResultSet rs = new MockResultSet();
ArrayMap rowData = new ArrayMap();
Short value = new Short((short) 0);
rowData.put("hoge", value);
rs.addRowData(rowData);
assertTrue(rs.next());
assertEquals(value.shortValue(), rs.getShort(1));
assertEquals(value.shortValue(), rs.getShort("hoge"));
}
/** @throws Exception */
public void testGetObject() throws Exception {
MockResultSet rs = new MockResultSet();
ArrayMap rowData = new ArrayMap();
Object value = new Object();
rowData.put("hoge", value);
rs.addRowData(rowData);
assertTrue(rs.next());
assertSame(value, rs.getObject(1));
assertSame(value, rs.getObject("hoge"));
}
/** @throws Exception */
public void testGetLong() throws Exception {
MockResultSet rs = new MockResultSet();
ArrayMap rowData = new ArrayMap();
Long value = new Long(0);
rowData.put("hoge", value);
rs.addRowData(rowData);
assertTrue(rs.next());
assertEquals(value.longValue(), rs.getLong(1));
assertEquals(value.longValue(), rs.getLong("hoge"));
}
/** @throws Exception */
public void testGetInt() throws Exception {
MockResultSet rs = new MockResultSet();
ArrayMap rowData = new ArrayMap();
Integer value = new Integer(0);
rowData.put("hoge", value);
rs.addRowData(rowData);
assertTrue(rs.next());
assertEquals(value.intValue(), rs.getInt(1));
assertEquals(value.intValue(), rs.getInt("hoge"));
}
/** @throws Exception */
public void testGetFloat() throws Exception {
MockResultSet rs = new MockResultSet();
ArrayMap rowData = new ArrayMap();
Float value = new Float(0);
rowData.put("hoge", value);
rs.addRowData(rowData);
assertTrue(rs.next());
assertEquals(value.floatValue(), rs.getFloat(1), 0);
assertEquals(value.floatValue(), rs.getFloat("hoge"), 0);
}
/** @throws Exception */
public void testGetTimestamp() throws Exception {
MockResultSet rs = new MockResultSet();
ArrayMap rowData = new ArrayMap();
Timestamp value = new Timestamp(0);
rowData.put("hoge", value);
rs.addRowData(rowData);
assertTrue(rs.next());
assertEquals(value, rs.getTimestamp(1));
assertEquals(value, rs.getTimestamp("hoge"));
}
/** @throws Exception */
public void testGetBoolean() throws Exception {
MockResultSet rs = new MockResultSet();
ArrayMap rowData = new ArrayMap();
Boolean value = Boolean.TRUE;
rowData.put("hoge", value);
rs.addRowData(rowData);
assertTrue(rs.next());
assertTrue(rs.getBoolean(1));
assertTrue(rs.getBoolean("hoge"));
}
/** @throws Exception */
public void testGetColumnData() throws Exception {
MockResultSet rs = new MockResultSet();
ArrayMap rowData = new ArrayMap();
Integer value = new Integer(1);
rowData.put("id", value);
rs.addRowData(rowData);
assertTrue(rs.next());
assertEquals(value, rs.getColumnData(1));
assertEquals(value, rs.getColumnData("id"));
}
/** @throws Exception */
public void testNext() throws Exception {
MockResultSet rs = new MockResultSet();
ArrayMap rowData = new ArrayMap();
Integer value = new Integer(1);
rowData.put("id", value);
rs.addRowData(rowData);
assertTrue(rs.next());
assertEquals(1, rs.getRow());
assertFalse(rs.next());
assertEquals(2, rs.getRow());
assertFalse(rs.next());
assertEquals(2, rs.getRow());
}
/** @throws Exception */
public void testGetBigDecimal() throws Exception {
MockResultSet rs = new MockResultSet();
ArrayMap rowData = new ArrayMap();
BigDecimal value = new BigDecimal(1);
rowData.put("id", value);
rs.addRowData(rowData);
assertTrue(rs.next());
assertEquals(value, rs.getBigDecimal(1));
assertEquals(value, rs.getBigDecimal("id"));
BigDecimal value2 = rs.getBigDecimal(1, 2);
assertEquals(2, value2.scale());
value2 = rs.getBigDecimal("id", 2);
assertEquals(2, value2.scale());
}
/** @throws Exception */
public void testAbsolute() throws Exception {
MockResultSet rs = new MockResultSet();
rs.setType(ResultSet.TYPE_SCROLL_INSENSITIVE);
ArrayMap rowData = new ArrayMap();
Timestamp value = new Timestamp(0);
rowData.put("hoge", value);
rs.addRowData(rowData);
rs.addRowData(rowData);
assertTrue(rs.absolute(1));
assertEquals(1, rs.getRow());
assertTrue(rs.absolute(2));
assertEquals(2, rs.getRow());
assertFalse(rs.absolute(0));
assertEquals(2, rs.getRow());
assertFalse(rs.absolute(3));
assertEquals(2, rs.getRow());
}
/** @throws Exception */
public void testPrevious() throws Exception {
MockResultSet rs = new MockResultSet();
try {
rs.previous();
fail();
} catch (SQLException e) {
System.out.println(e);
}
rs.setType(ResultSet.TYPE_SCROLL_INSENSITIVE);
ArrayMap rowData = new ArrayMap();
Integer value = new Integer(1);
rowData.put("id", value);
rs.addRowData(rowData);
assertTrue(rs.next());
assertFalse(rs.next());
assertTrue(rs.previous());
assertEquals(1, rs.getRow());
assertFalse(rs.previous());
assertEquals(0, rs.getRow());
}