Support import.sql or similar facility for data population when not using Hibernate to create the schema
#21.866 aperta il 1 dic 2021
Metriche repository
- Star
- (12.967 star)
- Metriche merge PR
- (Merge medio 6g 4h) (325 PR mergiate in 30 g)
Descrizione
Description
If I am using JPA to create my schema through Hibernate, I can easily add test data by creating an import.sql file in my resources.
However if I switch to using Flyway with PostgreSQL dev services, there doesn't seem to be an easy to do this except creating some extra migrations which are just used for test.
In Spring Boot I can create a data.sql file in my resources, and I can configure Spring Boot to execute this regardless of how my schema was created or what database I am using.
I am aware of the TC_INITSCRIPT option for test containers - but this would not work for our CI builds on k8s where TestContainers is not used (and in addition there doesn't seem to be an easy way to configure this when using dev services - quarkus.datasource.devservices.properties.TC_INIT_SCRIPT is documented not to work).
Implementation ideas
No response