@Test
public void testBulkAdd() throws SQLException {
Connection connection = null;
try {
ConnectionManager connectionManager = temporaryFileDatabase.getConnectionManager(true);
createSchema(connectionManager);
List<DBQueries.Row<Integer, String>> rowsToAdd =
new ArrayList<DBQueries.Row<Integer, String>>(4);
rowsToAdd.add(new DBQueries.Row<Integer, String>(1, "abs"));
rowsToAdd.add(new DBQueries.Row<Integer, String>(1, "gps"));
rowsToAdd.add(new DBQueries.Row<Integer, String>(2, "airbags"));
rowsToAdd.add(new DBQueries.Row<Integer, String>(2, "abs"));
connection = connectionManager.getConnection(null);
DBQueries.bulkAdd(rowsToAdd, NAME, connection);
assertQueryResultSet("SELECT * FROM " + TABLE_NAME, rowsToAdd, connectionManager);
} finally {
DBUtils.closeQuietly(connection);
}
}
