Push Flyway integration to the next level

[x80486]

Description

Since Quarkus has already support for Flyway, it would be great to support some other "operations" (or commands) to make our life easier while dealing with it:

• quarkus.flyway.validate-on-migrate — Option to automatically call validate when performing the migration
• quarkus.flyway.out-of-order — Allow migrations to be run out of order or not
• quarkus.flyway.clean-disabled — Whether to disable cleaning of the database; extremely useful during development and when tests are about (or prepared to) be run, so we don't have to do this manually all the time

[gastaldi]

There is quarkus.flyway.clean-at-start already, which I suppose it does what your quarkus.flyway.clean-disabled intends?

[gsmet]

Would you be willing to contribute some of that? It doesn’t look too hard.

[gastaldi]

It would be great if you could contribute @x80486, Here is a small diff of how quarkus.flyway.validate-on-migrate would be implemented:

git a/extensions/flyway/runtime/src/main/java/io/quarkus/flyway/runtime/FlywayCreator.java b/extensions/flyway/runtime/src/main/java/io/quarkus/flyway/runtime/FlywayCreator.java
index 0f0ea851e..cb65d82ab 100644
--- a/extensions/flyway/runtime/src/main/java/io/quarkus/flyway/runtime/FlywayCreator.java
+++ b/extensions/flyway/runtime/src/main/java/io/quarkus/flyway/runtime/FlywayCreator.java
@@ -26,6 +26,8 @@ class FlywayCreator {
         flywayRuntimeConfig.repeatableSqlMigrationPrefix.ifPresent(configure::repeatableSqlMigrationPrefix);
 
         configure.baselineOnMigrate(flywayRuntimeConfig.baselineOnMigrate);
+        configure.validateOnMigrate(flywayRuntimeConfig.validateOnMigrate);
+
         flywayRuntimeConfig.baselineVersion.ifPresent(configure::baselineVersion);
         flywayRuntimeConfig.baselineDescription.ifPresent(configure::baselineDescription);
 
diff --git a/extensions/flyway/runtime/src/main/java/io/quarkus/flyway/runtime/FlywayDataSourceRuntimeConfig.java b/extensions/flyway/runtime/src/main/java/io/quarkus/flyway/runtime/FlywayDataSourceRuntimeConfig.java
index dbf08839a..3bd9d8e46 100644
--- a/extensions/flyway/runtime/src/main/java/io/quarkus/flyway/runtime/FlywayDataSourceRuntimeConfig.java
+++ b/extensions/flyway/runtime/src/main/java/io/quarkus/flyway/runtime/FlywayDataSourceRuntimeConfig.java
@@ -82,6 +82,13 @@ public final class FlywayDataSourceRuntimeConfig {
     @ConfigItem
     public boolean baselineOnMigrate;
 
+    /**
+     * TODO: Add Javadoc
+     */
+    @ConfigItem
+    public boolean validateOnMigrate;
+
     /**
      * The initial baseline version.
      */

[x80486]

OK, I'll take it 😎