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