Spring Boot: How to setup test data with liquibase in unit test

René Winkler picture René Winkler · Mar 14, 2016 · Viewed 16k times · Source

I'm trying to setup the database schema and some test data with liquibase for some tests. Each test has a separate changelog which setup the schema and some specific data for the test.

In order to make my tests working, I need to drop the schema before each test and fill it with new test data. However, it seems that this is not working because some tests are failing because the old test data is still available. I think something with my configuration is not correct. How can I force liquibase to drop the schema before each test?

My tests look as following:

@RunWith(SpringJUnit4ClassRunner.class)
@SpringApplicationConfiguration(classes = MyTestConfig.class)
@TestPropertySource(properties = "liquibase.change-log=classpath:changelog/schema-with-testdata.xml")
public class MyRepositoryTest {

The config for the tests looks as follows:

@SpringApplicationConfiguration
@Configuration
@EnableAutoConfiguration
@ComponentScan("com.mypackage")
@EntityScan(basePackages = { "com.mypackage.domain" })
@EnableJpaRepositories(basePackages = { "com.mypackage.domain", "com.mypackage.infra.persistence" })
public class MyTestConfig {

And the application.properties under src/main/test/resources is

liquibase.drop-first=true
spring.jpa.hibernate.ddl-auto=none

Answer

MemLeak picture MemLeak · May 6, 2018

There is a spring.liquibase.dropFirst config property. Maybe this is what you're looking for?