Test with sql queries.

DeviceControllerTest.java

@Test
    @Sql(scripts = {"/create_devices.sql"}, executionPhase = Sql.ExecutionPhase.BEFORE_TEST_METHOD)
    @Sql(scripts = {"/remove_devices.sql"}, executionPhase = Sql.ExecutionPhase.AFTER_TEST_METHOD)
    public void create_shouldFailWhenTheSameDeviceIsAddedASecondTime() throws Exception {
        final ResultActions secondResultActions = mockMvc.perform(post("/devices")
                .contentType(APPLICATION_JSON)
                .content(objectMapper.writeValueAsString(bulkDeviceUploadRequestWithDeviceThatWeAlreadyKnow())))
                .andExpect(status().isOk());

        expectSingleError(secondResultActions, DEVICE_INTERNAL_ID_DUPLICATE, new Error("DEVICE.UPLOAD.ERROR.DEVICE_EXISTS", "Device already known in the system."));

        verifyZeroInteractions(eventPublisher);
    }