/**
* 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 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 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 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 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 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 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"));
}
protected ResultSet createResultSet(MockPreparedStatement stmt) {
MockResultSet rs = new MockResultSet(stmt);
String sql = stmt.getSql();
if ("SELECT 1".equalsIgnoreCase(sql)) {
rs.getRows().add(new Object[] {1});
} else if ("SELECT NOW()".equalsIgnoreCase(sql)) {
rs.getRows().add(new Object[] {new java.sql.Timestamp(System.currentTimeMillis())});
} else if ("SELECT ?".equalsIgnoreCase(sql)) {
rs.getRows().add(new Object[] {stmt.getParameters().get(0)});
}
return rs;
}
public JdbcTestSupport() {
mockConnection = new MockConnection();
mockPreparedStatement = new MockPreparedStatement();
mockConnection.prepareStatementReturn = mockPreparedStatement;
mockStatement = new MockStatement();
mockConnection.createStatementReturn = mockStatement;
mockResultSet = new MockResultSet();
mockResultSet.returnedRows = new ArrayList();
mockPreparedStatement.executeQueryReturn = mockResultSet;
mockStatement.executeQueryReturn = mockResultSet;
}
/** @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());
}
/** @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());
}
protected ResultSet executeQuery(MockStatement stmt, String sql) throws SQLException {
if (logExecuteQueryEnable && LOG.isDebugEnabled()) {
LOG.debug("executeQuery " + sql);
}
MockConnection conn = stmt.getMockConnection();
long idleTimeMillis = System.currentTimeMillis() - conn.getLastActiveTimeMillis();
if (idleTimeMillis >= this.idleTimeCount) {
throw new SQLException("connection is idle time count");
}
conn.setLastActiveTimeMillis(System.currentTimeMillis());
if (conn != null) {
if (conn.getConnectProperties() != null) {
Object propertyValue = conn.getConnectProperties().get("executeSleep");
if (propertyValue != null) {
long millis = Long.parseLong(propertyValue.toString());
try {
Thread.sleep(millis);
} catch (InterruptedException e) {
// skip
}
}
}
}
if ("SELECT value FROM _int_1000_".equalsIgnoreCase(sql)) {
MockResultSet rs = new MockResultSet(stmt);
for (int i = 0; i < 1000; ++i) {
rs.getRows().add(new Object[] {i});
}
return rs;
}
return this.executeHandler.executeQuery(stmt, sql);
}
/** @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 testRelative() 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.relative(2));
assertEquals(2, rs.getRow());
assertTrue(rs.relative(-1));
assertEquals(1, rs.getRow());
assertTrue(rs.relative(1));
assertEquals(2, rs.getRow());
assertFalse(rs.relative(1));
assertEquals(2, rs.getRow());
assertFalse(rs.relative(-2));
assertEquals(2, rs.getRow());
}