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

Viewed 21028

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
2 Answers

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

Not sure if this completely answers your question. There is another property liquibase.default-schema=schemaNameToCreate

But even with that I was never able to get it to create the schema from scratch.

Related