[kotlin] How to migrate a database and handle errors?

[MartinX3]

Hi people,

I need to change table and column names, so I changed the entities and wrote this startup script.
But I want to exit it if a problem appears.

Sadly the application doesn't exit, instead it still runs.
The bigger problem is, that after stopping the startup script it "updates" the database with the current entity changes.
Or it seems that the application updates the DB before my script runs.
As example I wanted to rename table Apple, to table Banana, but before this step a hibernate exception occurs, it aborts the migration and creates a new empty table called Banana.

So in the end I want to prevent quarkus from entering the lifecyclestep where it tries to update the database with the entity changes itself.

currently I use as a workaround quarkus.hibernate-orm.database.generation=none

(It should upgrade the production database, so i can't deactivate the quarkus db update setting)

currently I use this:

package de.app.tmp_db_migration

import io.quarkus.hibernate.reactive.panache.Panache.withTransaction
import io.quarkus.runtime.Quarkus.asyncExit
import io.quarkus.runtime.Quarkus.blockingExit
import io.quarkus.runtime.Startup
import io.smallrye.mutiny.Multi
import io.smallrye.mutiny.Uni
import io.smallrye.mutiny.Uni.createFrom
import io.vertx.mutiny.pgclient.PgPool
import org.hibernate.reactive.mutiny.Mutiny.LOG
import kotlin.system.exitProcess

@Startup
@Suppress("unused")
class DBMigrationBean(
    private val client: PgPool
) {
    init {
        try {
            createFrom().item(LOG.warn("START DB MIGRATION - MIGRATE TABLES"))
                .call { _ -> withTransaction(::migrateDB) }
                .invoke { _ -> LOG.warn("END DB MIGRATION - MIGRATED TABLES") }
                .await().indefinitely()
        } catch (exp: Exception) {
            LOG.error("Error in DB CALL", exp)
            asyncExit(-1)
            blockingExit()
            exitProcess(-1)
        }
    }
}

[quarkus-bot[bot]]

/cc @evanchooly