@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, noQueryOptions());
        DBQueries.bulkAdd(rowsToAdd, NAME, connection);
        assertQueryResultSet("SELECT * FROM " + TABLE_NAME, rowsToAdd, connectionManager);
    }finally {
        DBUtils.closeQuietly(connection);
    }
}