I have an Spring Boot application integrated with Hibernate for the database persistence.
I have two different data.sql files:
While testing, both of them are loaded before any test class. However, I only want to load the test/resources one, leaving the main/resources only and solely for app initialization.
How can I do that?
Thanks.
You should change the spring.jpa.hibernate.ddl-auto=create to update (it only updates the changes from the .sql file), because with create each time that the app runs, "cleans the DB", so thats why the both .sql are processed each time.
I hope this solve your problem.
if test class is starting the spring boot application then i don`t think that you can stop loading the main/resources .sql file.
but if you want to load the .sql file from test/resources just before/after the execution of methods(in test class) then you can use @SqlGroup annotation.
@SqlGroup({
@Sql(executionPhase = Sql.ExecutionPhase.BEFORE_TEST_METHOD, scripts = "classpath:beforeTestRun.sql"),
@Sql(executionPhase = Sql.ExecutionPhase.AFTER_TEST_METHOD, scripts = "classpath:afterTestRun.sql")
})
You can add the following configuration (at least in spring boot 2) to your test application.yaml or application.properties file.
spring:
datasource:
data: data.sql
Once this value is set spring boot will only load the test data.sql when running tests.
Maintain a separate properties file for test as it will help you in segregating the things between test and development.
application.properties for dev
application-local.properties for local env
application-test.properties for test
Have profiles according to your need and have properties with respect to profiles.
Another alternative is to override the properties based on your need.
