@Test
public void testGetUpdateCount() {
statementHandler.prepareUpdateCount(".*", 3);
statementHandler.prepareUpdateCount("insert xyz", 4);
assertEquals(new Integer(4), statementHandler.getUpdateCount("insert xyz"));
assertEquals(new Integer(3), statementHandler.getUpdateCount(".*"));
statementHandler.setUseRegularExpressions(true);
assertEquals(new Integer(3), statementHandler.getUpdateCount("insert xyz"));
assertEquals(new Integer(3), statementHandler.getUpdateCount("insert"));
statementHandler.setExactMatch(true);
assertEquals(new Integer(4), statementHandler.getUpdateCount("insert Xyz"));
assertNull(statementHandler.getUpdateCount("insert"));
statementHandler.prepareUpdateCounts("update", new int[] {1, 2});
assertEquals(new Integer(1), statementHandler.getUpdateCount("update"));
}
@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 testHasMultipleUpdateCounts() {
statementHandler.prepareUpdateCount("update", 3);
statementHandler.prepareUpdateCounts("insert into xyz", new int[] {4});
statementHandler.prepareUpdateCounts("insert into abc", new int[] {1, 2, 4});
assertFalse(statementHandler.hasMultipleUpdateCounts("update"));
assertFalse(statementHandler.hasMultipleUpdateCounts("do nothing"));
assertTrue(statementHandler.hasMultipleUpdateCounts("insert into xyz"));
assertTrue(statementHandler.hasMultipleUpdateCounts("insert into abc"));
}
@Test
public void testGetUpdateCounts() {
int[] updateCounts = new int[] {1, 2};
statementHandler.prepareUpdateCounts(".*", updateCounts);
statementHandler.prepareUpdateCount("insert xyz", 4);
Integer[] returnedUpdateCounts = statementHandler.getUpdateCounts(".*");
assertEquals(2, returnedUpdateCounts.length);
assertEquals(new Integer(1), returnedUpdateCounts[0]);
assertEquals(new Integer(2), returnedUpdateCounts[1]);
returnedUpdateCounts = statementHandler.getUpdateCounts("insert xyz");
assertEquals(1, returnedUpdateCounts.length);
assertEquals(new Integer(4), returnedUpdateCounts[0]);
assertNull(statementHandler.getUpdateCounts("do nothing"));
}
@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"));
}
