CrudRepository test cases without inserting data in DB

Question

I have one repository class which which implements CrudRepository. Then in service class I have auto wired this repositary. Then in controller class I have autowired this service.

I want to write test cases of controller Class. I am using below configuration.

    @RunWith(SpringJUnit4ClassRunner.class)
    @SpringBootTest(webEnvironment = WebEnvironment.RANDOM_PORT)
    public class XYZControllerTest {

        MockMvc mockMvc;

        @Mock
        private XYZController xyzController;

        @Autowired
        private TestRestTemplate template;

        @Autowired
        XYZRepository xyzRepository;

        @Before
        public void setup() throws Exception {
            mockMvc = MockMvcBuilders.standaloneSetup(xyzController).build();
        }

        @Test
        public void testPanelShouldBeRegistered() throws Exception {
            HttpEntity<Object> xyz = getHttpEntity("{\"name\": \"test 1\", \"email\": \"test10000000000001@gmail.com\","
                    + " \"registrationNumber\": \"41DCT\",\"registrationDate\":\"2018-08-08T12:12:12\" }");
            ResponseEntity<XYZ> response = template.postForEntity("/api/xyz", xyz, XYZ.class);

    }
}

My problem is that when I run test case, data is going to insert in DB which is used for application. Can I test it without inserting data in DB.

Possible duplicate of [How to test Spring Data repositories?](https://stackoverflow.com/questions/23435937/how-to-test-spring-data-repositories) — Clomez, Dec 11 '18 at 06:31
No. Its not same. In that question they suggesting for integration testing. — Dhaval Goti, Dec 11 '18 at 08:45
You must mock the `XYZRepository` rather than wiring it from Spring config. — Benoit, Dec 11 '18 at 09:28

score 0 · Answer 1 · answered Dec 13 '18 at 08:11

Conceptually when we are testing services we mock repositories instead of injection.

You need to mock your repository and setup behavior for returning data.

An example :

@MockBean
XYZRepository xyzRepository;

@Test
public void test() {

    // other mocks
    //
    when(xyzRepository.findAll()).thenReturn(Arrays.asList(new XYZ()));

    // service calls
    // assertions
}

CrudRepository test cases without inserting data in DB

1 Answers1