dev.fuelyour.vertxkuickstartcore.migrations.Migration.kt Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of vertx-kuickstart-core Show documentation

Core libraries used by microservices created from the vertx-kuickstart template

There is a newer version: 0.0.19

Show newest version

package dev.fuelyour.vertxkuickstartcore.migrations

import io.vertx.core.json.JsonObject
import org.flywaydb.core.Flyway

/**
 * Runs flyway migrations for both the public and the test schemas for the
 * database specified by the dbConfig
 *
 * @param dbConfig The database configuration. Required fields:
 *     SERVICE_DB_HOST, SERVICE_DB_PORT, SERVICE_DB_NAME,
 *     SERVICE_DB_USER, SERVICE_DB_PASSWORD
 */
fun migrate(dbConfig: JsonObject) {
    val host = dbConfig.getString("SERVICE_DB_HOST")
    val port = dbConfig.getInteger("SERVICE_DB_PORT")
    val name = dbConfig.getString("SERVICE_DB_NAME")
    val url = "jdbc:postgresql://$host:$port/$name"
    val user = dbConfig.getString("SERVICE_DB_USER")
    val password = dbConfig.getString("SERVICE_DB_PASSWORD")
    val flyway = Flyway
        .configure()
        .schemas("public")
        .dataSource(url, user, password)
        .load()
    flyway.migrate()
}