JOOQ with flyway and gradle

build.gradle.kts

import com.opentable.db.postgres.embedded.*
import org.flywaydb.core.*
import org.jooq.codegen.*

tasks.named("compileKotlin") {
    doFirst {
        //create embedded postgresql
        EmbeddedPostgres.builder().setPort(5400).start().use {
            //migrate embedded posrtgresql
            Flyway.configure()
                .locations("filesystem:$projectDir/migrations/")
                .schemas("public")
                .dataSource(it.postgresDatabase)
                .load()
                .migrate()

            //generate jooq classes
            GenerationTool.generate("some xml for jooq")
        }
    }
}