Spring Boot: How to setup test data with liquibase in unit test
There is a spring.liquibase.dropFirst
config property. Maybe this is what you're looking for?
Related videos on Youtube
René Winkler
Passionate software engineer who is steadily improving his programming skills and who is willing to share this knowledge. Read the documentation Ask, ask and ask... Practice, practice, practice... On Stackoverflow when maven is building or websphere is deploying...
Updated on January 23, 2020Comments
-
René Winkler over 4 years
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
-
Simon Ludwig over 7 yearsI had the same problem and posted my answer here: stackoverflow.com/questions/40210247/…
-