Skip to content

Instantly share code, notes, and snippets.

@jrichardsz
Created December 13, 2021 22:11
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save jrichardsz/661913b8d52b6e820a1b37b972ffdb49 to your computer and use it in GitHub Desktop.
Save jrichardsz/661913b8d52b6e820a1b37b972ffdb49 to your computer and use it in GitHub Desktop.
JDBC mock for tests: MockResultSet.java
//initial source:
// https://github.com/sharfah/java-utils/blob/master/src/test/java/com/sharfah/util/sql/MockResultSet.java
import static org.mockito.Matchers.anyInt;
import static org.mockito.Matchers.anyString;
import static org.mockito.Mockito.doAnswer;
import static org.mockito.Mockito.doReturn;
import static org.mockito.Mockito.mock;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.util.LinkedHashMap;
import java.util.Map;
import java.util.function.Function;
import java.util.stream.Collectors;
import java.util.stream.IntStream;
/**
* Mocks a SQL ResultSet.
*/
public class MockResultSet {
private final Map<String, Integer> columnIndices;
private final Object[][] data;
private int rowIndex;
private MockResultSet(final String[] columnNames, final Object[][] data) {
this.columnIndices = IntStream.range(0, columnNames.length).boxed()
.collect(Collectors.toMap(k -> columnNames[k], Function.identity(), (a, b) -> {
throw new RuntimeException("Duplicate column " + a);
}, LinkedHashMap::new));
this.data = data;
this.rowIndex = -1;
}
private ResultSet buildMock() throws SQLException {
final ResultSet rs = mock(ResultSet.class);
// mock rs.next()
doAnswer(invocation -> {
rowIndex++;
return rowIndex < data.length;
}).when(rs).next();
// mock rs.getString(columnName)
doAnswer(invocation -> {
String columnName = invocation.getArgumentAt(0, String.class);
Integer columnIndex = columnIndices.get(columnName);
return (String) data[rowIndex][columnIndex];
}).when(rs).getString(anyString());
// mock rs.getString(columnIndex)
doAnswer(invocation -> {
Integer index = invocation.getArgumentAt(0, Integer.class);
return (String) data[rowIndex][index - 1];
}).when(rs).getString(anyInt());
// mock rs.getInt(columnName)
doAnswer(invocation -> {
String columnName = invocation.getArgumentAt(0, String.class);
Integer columnIndex = columnIndices.get(columnName);
return (Integer) data[rowIndex][columnIndex];
}).when(rs).getInt(anyString());
// mock rs.getObject(columnName)
doAnswer(invocation -> {
String columnName = invocation.getArgumentAt(0, String.class);
Integer columnIndex = columnIndices.get(columnName);
return data[rowIndex][columnIndex];
}).when(rs).getObject(anyString());
// mock rs.getObject(columnIndex)
doAnswer(invocation -> {
Integer index = invocation.getArgumentAt(0, Integer.class);
return data[rowIndex][index - 1];
}).when(rs).getObject(anyInt());
final ResultSetMetaData rsmd = mock(ResultSetMetaData.class);
// mock rsmd.getColumnCount()
doReturn(columnIndices.size()).when(rsmd).getColumnCount();
// mock rsmd.getColumnName(int)
doAnswer(invocation -> {
Integer index = invocation.getArgumentAt(0, Integer.class);
return columnIndices.keySet().stream().skip(index - 1).findFirst().get();
}).when(rsmd).getColumnName(anyInt());
// mock rs.getMetaData()
doReturn(rsmd).when(rs).getMetaData();
return rs;
}
/**
* Creates the mock ResultSet.
*
* @param columnNames the names of the columns
* @param data
* @return a mocked ResultSet
* @throws SQLException
*/
public static ResultSet create(final String[] columnNames, final Object[][] data)
throws SQLException {
return new MockResultSet(columnNames, data).buildMock();
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment