@Test
public void testClearMethods() {
statementHandler.prepareResultSet("select", new MockResultSet("id"));
statementHandler.prepareUpdateCount("select", 3);
statementHandler.prepareThrowsSQLException("select");
statementHandler.prepareReturnsResultSet("select", true);
statementHandler.prepareGeneratedKeys("select", new MockResultSet("id"));
statementHandler.clearResultSets();
statementHandler.clearUpdateCounts();
statementHandler.clearThrowsSQLException();
statementHandler.clearReturnsResultSet();
statementHandler.clearGeneratedKeys();
assertNull(statementHandler.getResultSet("select"));
assertNull(statementHandler.getUpdateCount("select"));
assertFalse(statementHandler.getThrowsSQLException("select"));
assertNull(statementHandler.getReturnsResultSet("select"));
assertNull(statementHandler.getGeneratedKeys("select"));
}
@Test
public void testPreparedSQLOrdered() {
MockResultSet result1 = new MockResultSet("id1");
MockResultSet result2 = new MockResultSet("id2");
statementHandler.prepareResultSet("select", result1);
statementHandler.prepareResultSet("SelecT", result2);
statementHandler.prepareUpdateCount("SelecT", 3);
statementHandler.prepareUpdateCount("select2", 2);
statementHandler.prepareReturnsResultSet("select", false);
statementHandler.prepareReturnsResultSet("selecT", true);
statementHandler.prepareGeneratedKeys("seLECT", result1);
statementHandler.prepareGeneratedKeys("select", result2);
assertSame(result2, statementHandler.getResultSet("select"));
assertSame(result2, statementHandler.getResultSets("select")[0]);
assertEquals(new Integer(3), statementHandler.getUpdateCount("SELECT"));
assertEquals(new Integer(3), statementHandler.getUpdateCounts("selecT")[0]);
assertTrue(statementHandler.getReturnsResultSet("select").booleanValue());
assertSame(result1, statementHandler.getGeneratedKeys("select"));
}
@Test
public void testGetGeneratedKeys() {
MockResultSet result = new MockResultSet("id");
statementHandler.prepareGeneratedKeys("insert into table", result);
statementHandler.prepareGeneratedKeys("insert .*", result);
assertSame(result, statementHandler.getGeneratedKeys("insert into table abc"));
assertSame(result, statementHandler.getGeneratedKeys("insert .*"));
assertNull(statementHandler.getGeneratedKeys("insert into othertable"));
statementHandler.setUseRegularExpressions(true);
assertSame(result, statementHandler.getGeneratedKeys("insert into table"));
assertSame(result, statementHandler.getGeneratedKeys("INSERt regular"));
statementHandler.setCaseSensitive(true);
assertNull(statementHandler.getGeneratedKeys("INSERt regular"));
}