java - 无法在 JUnit 测试用例中覆盖 List

Question

在我的代码中，我使用 List 通过连接各种来捕获查询结果表并映射到 DTO 对象。这段代码在 main 中工作得很好。但当我尝试创建测试用例时，我无法覆盖 List < Tuple > 代码。请提供您的意见。

例如:

    @SuppressWarnings("unchecked")
    private List<FeedbackDTO> getList(String sortingProperty, String direction, UUID workflowId, UUID categoryId,
        String type) {

    StringBuilder query = new StringBuilder(
            "select feedback.id, feedback.workflowId, user.userName, user.firstName, "
                    + "user.lastName, feedback.submittedDate, country.countryName, "
                    + "region.regionName, feedback.comments, feedback.ratings, feedback.acknowledged "
                    + "from Feedback feedback, User user, Country country, Region region "
                    + "where feedback.userId = user.id and user.countryId = country.id and user.regionId = region.id "
                    + "and feedback.workflowId = " + "'" + workflowId + "'" + " and feedback.categoryId = " + "'"
                    + categoryId + "'" + " and feedback.type = " + "'" + type + "'" + " order by ");
    if (sortingProperty.equalsIgnoreCase("firstName")) {
        query.append("user.firstName ");
    } 
    query.append(direction);
    Query queryList = entityManager.createNativeQuery(query.toString(), Tuple.class);
    List<Tuple> tupleList = queryList.getResultList();
    List<FeedbackDTO> feedbackList = new ArrayList<FeedbackDTO>();
    for (Tuple tuple : tupleList) {
        FeedbackDTO feedbackDTO = new FeedbackDTO();
        feedbackDTO.setId(UUID.fromString((String) tuple.get("id")));
        feedbackDTO.setUserName((String) tuple.get("userName"));
        feedbackDTO.setFirstName((String) tuple.get("firstName"));
        feedbackDTO.setLastName((String) tuple.get("lastName"));
        feedbackDTO.setCountryName((String) tuple.get("countryName"));
        feedbackDTO.setAcknowledged((Boolean) tuple.get("acknowledged"));
        feedbackDTO.setRegionName((String) tuple.get("regionName"));
        feedbackDTO.setComments((String) tuple.get("comments"));
        feedbackDTO.setSubmittedDate((Date) tuple.get("submittedDate"));
        feedbackDTO.setRatings((Double) tuple.get("ratings"));
        feedbackList.add(feedbackDTO);
    }
    return feedbackList;
}

在我的测试用例中:

    @Test
    public void testGetFeedbackListNoFeedback() {
    try {
        Query queryList = mock(Query.class);

        FeedbackTestDTO feedback = new FeedbackTestDTO();
        feedback.setId(id);
        feedback.setSolutionId(solutionId);
        feedback.setComments("Please swich-on the power");
        feedback.setType("Alternate Solution");

        List<Object> tupleList = new ArrayList<>();

        tupleList.add(feedback);

        StringBuilder query = new StringBuilder(
                "select * from feedback order by user.firstName ASC");

        Sort sort = new Sort("firstName:ASC");
        Pageable pageable = PageRequest.of(0, 20, sort);
        when(entityManager.createNativeQuery(query.toString(), javax.persistence.Tuple.class)).thenReturn(queryList);
        when(queryList.getResultList()).thenReturn(tupleList);
        this.mockFeedbackListDTO = feedbackServiceImpl.getFeedbackList(workflowId, categoryId, "", "",
                "2019-08-29T01:00:00Z", "2019-08-29T13:00:00Z", "5", pageable, true);
        assertEquals(201, this.mockFeedbackListDTO.getCode());
    } catch (BusinessException | ParseException be) {
        assertEquals("No feedback from users", accessor.getMessage(be.getLocalizedMessage()));
    }
}

Answer 1

 List<Tuple> tupleList = new ArrayList<>();
    NativeQueryTupleTransformer nativeQueryTupleTransformer = new NativeQueryTupleTransformer();
    tupleList.add((Tuple)nativeQueryTupleTransformer.transformTuple(new BigDecimal[]{new BigDecimal(123),new BigDecimal(123),new BigDecimal(123)},new String[]{"0","1","2"} ));
    tupleList.add((Tuple)nativeQueryTupleTransformer.transformTuple(new BigDecimal[]{new BigDecimal(123),new BigDecimal(123),new BigDecimal(123)},new String[]{"0","1","2"} ));
    tupleList.add((Tuple)nativeQueryTupleTransformer.transformTuple(new BigDecimal[]{new BigDecimal(123),new BigDecimal(123),new BigDecimal(123)},new String[]{"0","1","2"} ));
    Mockito.when(service.getRecordRangeForPagination(Mockito.anyString(),Mockit.anyLong(),Mockito.anyString())).thenReturn(tupleList);