[Database][Devservice] Support multiple init scripts

[agreedSkiing]

Description

Since the database devservice support an init script would it be possible to add a new parameter to load mulitple init scripts?

Use case are for application that don't use flyway

Implementation ideas

No response

[quarkus-bot]

/cc @geoand (devservices), @stuartwdouglas (devservices)

[geoand]

cc @yrodiere

[yrodiere]

Not only is it possible, it should be fairly easy and thus is a good candidate for first-time contributors! Want to give it a try? :)

Entry points:

1. Here's where the config for init scripts is defined -- it'll need to be turned into a List<@WithConverter(TrimmedStringConverter.class) String> and usages will have to be adapted to handle multiple values:
   

   quarkus/extensions/datasource/runtime/src/main/java/io/quarkus/datasource/runtime/DevServicesBuildTimeConfig.java

   Line 90 in eb3c31b

   Optional<String> initScriptPath();

2. Here's where it gets stored temporarily before being forwarded to containers -- same deal, will need to be turned to a List<String>:

   quarkus/extensions/datasource/deployment-spi/src/main/java/io/quarkus/datasource/deployment/spi/DevServicesDatasourceContainerConfig.java

   Line 87 in eb3c31b

   public Optional<String> getInitScriptPath() {

3. Here's where it gets passed to testcontainers for postgresql -- need to use withInitScripts (trailing s) instead of withInitScript:

   quarkus/extensions/devservices/postgresql/src/main/java/io/quarkus/devservices/postgresql/deployment/PostgresqlDevServicesProcessor.java

   Line 91 in 0fa9369

   containerConfig.getInitScriptPath().ifPresent(container::withInitScript);

   
   Same thing needs to be done for other databases, of course.

[giamma-frangipane]

I'd like to contribute!

[yrodiere]

Please do!

General help: https://github.com/quarkusio/quarkus/blob/main/CONTRIBUTING.md

Specifics of this issue: see my previous comment :)