返回指南目录

选择指南版本

使用Flyway

建立对Flyway的支持
用Flyway开发
- Repairing the Flyway schema history table
Multiple datasources
Customizing Flyway
使用Flyway对象
Flyway和Hibernate ORM
Flyway on Kubernetes
- Disabling
- Using a custom image that controls waiting for the Job

Flyway 是一个流行的数据库迁移工具，通常用于JVM环境。

本指南将会介绍Quarkus为使用Flyway提供了哪些一流的支持。

建立对Flyway的支持

As shown in the Developing with Flyway section, to start using Flyway with your project, you just need to:

像通常使用Flyway那样，将你的迁移文件添加到 src/main/resources/db/migration 文件夹中。
激活 migrate-at-start 选项来自动迁移表，或者添加 Flyway 对象，然后像通常那样运行迁移。

在build文件中添加以下依赖项。

Flyway扩展
JDBC驱动扩展 ( quarkus-jdbc-postgresql , quarkus-jdbc-h2 , quarkus-jdbc-mariadb , …)
MariaDB/MySQL的支持现在在一个单独的依赖中，MariaDB/MySQL的用户从现在开始需要添加 flyway-mysql 的依赖。
Microsoft SQL Server的支持现在在一个单独的依赖中，Microsoft SQL Server的用户从现在开始需要添加 flyway-sqlserver 的依赖。
the Oracle support is now in a separate dependency, Oracle users need to add the flyway-database-oracle dependency from now on.

pom.xml

<!-- Flyway specific dependencies -->
<dependency>
    <groupId>io.quarkus</groupId>
    <artifactId>quarkus-flyway</artifactId>
</dependency>

<!-- Flyway SQL Server specific dependencies -->
<dependency>
    <groupId>org.flywaydb</groupId>
    <artifactId>flyway-sqlserver</artifactId>
</dependency>

<!-- Flyway MariaDB/MySQL specific dependencies -->
<dependency>
    <groupId>org.flywaydb</groupId>
    <artifactId>flyway-mysql</artifactId>
</dependency>

<!-- Flyway Oracle specific dependencies -->
<dependency>
    <groupId>org.flywaydb</groupId>
    <artifactId>flyway-database-oracle</artifactId>
</dependency>

<!-- JDBC driver dependencies -->
<dependency>
    <groupId>io.quarkus</groupId>
    <artifactId>quarkus-jdbc-postgresql</artifactId>
</dependency>

build.gradle

// Flyway specific dependencies
implementation("io.quarkus:quarkus-flyway")
// Flyway SQL Server specific dependencies
implementation("org.flywaydb:flyway-sqlserver")
// Flyway MariaDB/MySQL specific dependencies
implementation("org.flywaydb:flyway-mysql")
// Flyway Oracle specific dependencies
implementation("org.flywaydb:flyway-database-oracle")
// JDBC driver dependencies
implementation("io.quarkus:quarkus-jdbc-postgresql")

Flyway support relies on the Quarkus datasource config. It can be customized for the default datasource as well as for every named datasource. First, you need to add the datasource config to the application.properties file in order to allow Flyway to manage the schema. Also, you can customize the Flyway behaviour by using the following properties:

Configuration property fixed at build time - All other configuration properties are overridable at runtime

Configuration property	类型	默认
`quarkus.flyway.enabled` Whether Flyway is enabled during the build. If Flyway is disabled, the Flyway beans won’t be created and Flyway won’t be usable. Environment variable: `QUARKUS_FLYWAY_ENABLED` Show more	boolean	`true`
`quarkus.flyway.locations` Comma-separated list of locations to scan recursively for migrations. The location type is determined by its prefix. Unprefixed locations or locations starting with classpath: point to a package on the classpath and may contain both SQL and Java-based migrations. Locations starting with filesystem: point to a directory on the filesystem, may only contain SQL migrations and are only scanned recursively down non-hidden directories. Environment variable: `QUARKUS_FLYWAY_LOCATIONS` Show more	list of string	`db/migration`
`quarkus.flyway.callbacks` Comma-separated list of fully qualified class names of Callback implementations to use to hook into the Flyway lifecycle. The `org.flywaydb.core.api.callback.Callback` subclass must have a no-args constructor and must not be abstract. These classes must also not have any fields that hold state (unless that state is initialized in the constructor). Environment variable: `QUARKUS_FLYWAY_CALLBACKS` Show more	list of string
`quarkus.flyway.active` Flag to activate/deactivate Flyway for a specific datasource at runtime. Environment variable: `QUARKUS_FLYWAY_ACTIVE` Show more	boolean	`true`
`quarkus.flyway.connect-retries` The maximum number of retries when attempting to connect to the database. After each failed attempt, Flyway will wait up to the configured `connect-retries-interval` duration before attempting to connect again, up to the maximum number of times specified by connectRetries. Environment variable: `QUARKUS_FLYWAY_CONNECT_RETRIES` Show more	int
`quarkus.flyway.connect-retries-interval` The maximum time between retries when attempting to connect to the database. This will cap the interval between connect retries to the value provided. Environment variable: `QUARKUS_FLYWAY_CONNECT_RETRIES_INTERVAL` Show more	Duration	`120 seconds`
`quarkus.flyway.default-schema` Sets the default schema managed by Flyway. This schema name is case-sensitive. If not specified, but schemas is, Flyway uses the first schema in that list. If that is also not specified, Flyway uses the default schema for the database connection. Consequences: This schema will be the one containing the schema history table. This schema will be the default for the database connection (provided the database supports this concept). Environment variable: `QUARKUS_FLYWAY_DEFAULT_SCHEMA` Show more	string
`quarkus.flyway.jdbc-url` The JDBC URL that Flyway uses to connect to the database. Falls back to the datasource URL if not specified. Environment variable: `QUARKUS_FLYWAY_JDBC_URL` Show more	string
`quarkus.flyway.username` The username that Flyway uses to connect to the database. If no specific JDBC URL is configured, falls back to the datasource username if not specified. Environment variable: `QUARKUS_FLYWAY_USERNAME` Show more	string
`quarkus.flyway.password` The password that Flyway uses to connect to the database. If no specific JDBC URL is configured, falls back to the datasource password if not specified. Environment variable: `QUARKUS_FLYWAY_PASSWORD` Show more	string
`quarkus.flyway.schemas` Comma-separated case-sensitive list of schemas managed by Flyway. The first schema in the list will be automatically set as the default one during the migration. It will also be the one containing the schema history table. Environment variable: `QUARKUS_FLYWAY_SCHEMAS` Show more	list of string
`quarkus.flyway.table` The name of Flyway’s schema history table. By default (single-schema mode), the schema history table is placed in the default schema for the connection provided by the datasource. When the flyway.schemas property is set (multi-schema mode), the schema history table is placed in the first schema of the list. Environment variable: `QUARKUS_FLYWAY_TABLE` Show more	string
`quarkus.flyway.sql-migration-prefix` The file name prefix for versioned SQL migrations. Versioned SQL migrations have the following file name structure: prefixVERSIONseparatorDESCRIPTIONsuffix , which using the defaults translates to V1.1__My_description.sql Environment variable: `QUARKUS_FLYWAY_SQL_MIGRATION_PREFIX` Show more	string
`quarkus.flyway.repeatable-sql-migration-prefix` The file name prefix for repeatable SQL migrations. Repeatable SQL migrations have the following file name structure: prefixSeparatorDESCRIPTIONsuffix , which using the defaults translates to R__My_description.sql Environment variable: `QUARKUS_FLYWAY_REPEATABLE_SQL_MIGRATION_PREFIX` Show more	string
`quarkus.flyway.clean-at-start` true to execute Flyway clean command automatically when the application starts, false otherwise. Environment variable: `QUARKUS_FLYWAY_CLEAN_AT_START` Show more	boolean	`false`
`quarkus.flyway.clean-disabled` true to prevent Flyway clean operations, false otherwise. Environment variable: `QUARKUS_FLYWAY_CLEAN_DISABLED` Show more	boolean	`false`
`quarkus.flyway.clean-on-validation-error` true to automatically call clean when a validation error occurs, false otherwise. Environment variable: `QUARKUS_FLYWAY_CLEAN_ON_VALIDATION_ERROR` Show more	boolean	`false`
`quarkus.flyway.migrate-at-start` true to execute Flyway automatically when the application starts, false otherwise. Environment variable: `QUARKUS_FLYWAY_MIGRATE_AT_START` Show more	boolean	`false`
`quarkus.flyway.repair-at-start` true to execute a Flyway repair command when the application starts, false otherwise. Environment variable: `QUARKUS_FLYWAY_REPAIR_AT_START` Show more	boolean	`false`
`quarkus.flyway.validate-at-start` true to execute a Flyway validate command when the application starts, false otherwise. Environment variable: `QUARKUS_FLYWAY_VALIDATE_AT_START` Show more	boolean	`false`
`quarkus.flyway.baseline-on-migrate` true to execute Flyway baseline before migrations This flag is ignored if the flyway_schema_history table exists in the current schema or if the current schema is empty. Note that this will not automatically call migrate, you must either enable baselineAtStart or programmatically call flyway.migrate(). Environment variable: `QUARKUS_FLYWAY_BASELINE_ON_MIGRATE` Show more	boolean	`false`
`quarkus.flyway.baseline-at-start` true to execute Flyway baseline automatically when the application starts. This flag is ignored if the flyway_schema_history table exists in the current schema. This will work even if the current schema is empty. Environment variable: `QUARKUS_FLYWAY_BASELINE_AT_START` Show more	boolean	`false`
`quarkus.flyway.baseline-version` The initial baseline version. Environment variable: `QUARKUS_FLYWAY_BASELINE_VERSION` Show more	string
`quarkus.flyway.baseline-description` The description to tag an existing schema with when executing baseline. Environment variable: `QUARKUS_FLYWAY_BASELINE_DESCRIPTION` Show more	string
`quarkus.flyway.validate-on-migrate` Whether to automatically call validate when performing a migration. Environment variable: `QUARKUS_FLYWAY_VALIDATE_ON_MIGRATE` Show more	boolean	`true`
`quarkus.flyway.out-of-order` Allows migrations to be run "out of order". Environment variable: `QUARKUS_FLYWAY_OUT_OF_ORDER` Show more	boolean	`false`
`quarkus.flyway.ignore-missing-migrations` Ignore missing migrations when reading the history table. When set to true migrations from older versions present in the history table but absent in the configured locations will be ignored (and logged as a warning), when false (the default) the validation step will fail. Environment variable: `QUARKUS_FLYWAY_IGNORE_MISSING_MIGRATIONS` Show more	boolean	`false`
`quarkus.flyway.ignore-future-migrations` Ignore future migrations when reading the history table. When set to true migrations from newer versions present in the history table but absent in the configured locations will be ignored (and logged as a warning), when false (the default) the validation step will fail. Environment variable: `QUARKUS_FLYWAY_IGNORE_FUTURE_MIGRATIONS` Show more	boolean	`false`
`quarkus.flyway.create-schemas` Whether Flyway should attempt to create the schemas specified in the schemas property Environment variable: `QUARKUS_FLYWAY_CREATE_SCHEMAS` Show more	boolean	`true`
`quarkus.flyway.placeholder-prefix` Prefix of every placeholder (default: ${ ) Environment variable: `QUARKUS_FLYWAY_PLACEHOLDER_PREFIX` Show more	string
`quarkus.flyway.placeholder-suffix` Suffix of every placeholder (default: } ) Environment variable: `QUARKUS_FLYWAY_PLACEHOLDER_SUFFIX` Show more	string
`quarkus.flyway.init-sql` The SQL statements to run to initialize a new database connection immediately after opening it. Environment variable: `QUARKUS_FLYWAY_INIT_SQL` Show more	string
`quarkus.flyway.validate-migration-naming` Whether to validate migrations and callbacks whose scripts do not obey the correct naming convention. A failure can be useful to check that errors such as case sensitivity in migration prefixes have been corrected. Environment variable: `QUARKUS_FLYWAY_VALIDATE_MIGRATION_NAMING` Show more	boolean	`false`
`quarkus.flyway.ignore-migration-patterns` Ignore migrations during validate and repair according to a given list of patterns (see https://flywaydb.org/documentation/configuration/parameters/ignoreMigrationPatterns for more information). When this configuration is set, the ignoreFutureMigrations and ignoreMissingMigrations settings are ignored. Patterns are comma separated. Environment variable: `QUARKUS_FLYWAY_IGNORE_MIGRATION_PATTERNS` Show more	list of string
`quarkus.flyway."named-data-sources".locations` Comma-separated list of locations to scan recursively for migrations. The location type is determined by its prefix. Unprefixed locations or locations starting with classpath: point to a package on the classpath and may contain both SQL and Java-based migrations. Locations starting with filesystem: point to a directory on the filesystem, may only contain SQL migrations and are only scanned recursively down non-hidden directories. Environment variable: `QUARKUS_FLYWAY__NAMED_DATA_SOURCES__LOCATIONS` Show more	list of string	`db/migration`
`quarkus.flyway."named-data-sources".callbacks` Comma-separated list of fully qualified class names of Callback implementations to use to hook into the Flyway lifecycle. The `org.flywaydb.core.api.callback.Callback` subclass must have a no-args constructor and must not be abstract. These classes must also not have any fields that hold state (unless that state is initialized in the constructor). Environment variable: `QUARKUS_FLYWAY__NAMED_DATA_SOURCES__CALLBACKS` Show more	list of string
`quarkus.flyway.placeholders` Sets the placeholders to replace in SQL migration scripts. Environment variable: `QUARKUS_FLYWAY_PLACEHOLDERS` Show more	`Map<String,String>`
`quarkus.flyway."named-data-sources".active` Flag to activate/deactivate Flyway for a specific datasource at runtime. Environment variable: `QUARKUS_FLYWAY__NAMED_DATA_SOURCES__ACTIVE` Show more	boolean	`true`
`quarkus.flyway."named-data-sources".connect-retries` The maximum number of retries when attempting to connect to the database. After each failed attempt, Flyway will wait up to the configured `connect-retries-interval` duration before attempting to connect again, up to the maximum number of times specified by connectRetries. Environment variable: `QUARKUS_FLYWAY__NAMED_DATA_SOURCES__CONNECT_RETRIES` Show more	int
`quarkus.flyway."named-data-sources".connect-retries-interval` The maximum time between retries when attempting to connect to the database. This will cap the interval between connect retries to the value provided. Environment variable: `QUARKUS_FLYWAY__NAMED_DATA_SOURCES__CONNECT_RETRIES_INTERVAL` Show more	Duration	`120 seconds`
`quarkus.flyway."named-data-sources".default-schema` Sets the default schema managed by Flyway. This schema name is case-sensitive. If not specified, but schemas is, Flyway uses the first schema in that list. If that is also not specified, Flyway uses the default schema for the database connection. Consequences: This schema will be the one containing the schema history table. This schema will be the default for the database connection (provided the database supports this concept). Environment variable: `QUARKUS_FLYWAY__NAMED_DATA_SOURCES__DEFAULT_SCHEMA` Show more	string
`quarkus.flyway."named-data-sources".jdbc-url` The JDBC URL that Flyway uses to connect to the database. Falls back to the datasource URL if not specified. Environment variable: `QUARKUS_FLYWAY__NAMED_DATA_SOURCES__JDBC_URL` Show more	string
`quarkus.flyway."named-data-sources".username` The username that Flyway uses to connect to the database. If no specific JDBC URL is configured, falls back to the datasource username if not specified. Environment variable: `QUARKUS_FLYWAY__NAMED_DATA_SOURCES__USERNAME` Show more	string
`quarkus.flyway."named-data-sources".password` The password that Flyway uses to connect to the database. If no specific JDBC URL is configured, falls back to the datasource password if not specified. Environment variable: `QUARKUS_FLYWAY__NAMED_DATA_SOURCES__PASSWORD` Show more	string
`quarkus.flyway."named-data-sources".schemas` Comma-separated case-sensitive list of schemas managed by Flyway. The first schema in the list will be automatically set as the default one during the migration. It will also be the one containing the schema history table. Environment variable: `QUARKUS_FLYWAY__NAMED_DATA_SOURCES__SCHEMAS` Show more	list of string
`quarkus.flyway."named-data-sources".table` The name of Flyway’s schema history table. By default (single-schema mode), the schema history table is placed in the default schema for the connection provided by the datasource. When the flyway.schemas property is set (multi-schema mode), the schema history table is placed in the first schema of the list. Environment variable: `QUARKUS_FLYWAY__NAMED_DATA_SOURCES__TABLE` Show more	string
`quarkus.flyway."named-data-sources".sql-migration-prefix` The file name prefix for versioned SQL migrations. Versioned SQL migrations have the following file name structure: prefixVERSIONseparatorDESCRIPTIONsuffix , which using the defaults translates to V1.1__My_description.sql Environment variable: `QUARKUS_FLYWAY__NAMED_DATA_SOURCES__SQL_MIGRATION_PREFIX` Show more	string
`quarkus.flyway."named-data-sources".repeatable-sql-migration-prefix` The file name prefix for repeatable SQL migrations. Repeatable SQL migrations have the following file name structure: prefixSeparatorDESCRIPTIONsuffix , which using the defaults translates to R__My_description.sql Environment variable: `QUARKUS_FLYWAY__NAMED_DATA_SOURCES__REPEATABLE_SQL_MIGRATION_PREFIX` Show more	string
`quarkus.flyway."named-data-sources".clean-at-start` true to execute Flyway clean command automatically when the application starts, false otherwise. Environment variable: `QUARKUS_FLYWAY__NAMED_DATA_SOURCES__CLEAN_AT_START` Show more	boolean	`false`
`quarkus.flyway."named-data-sources".clean-disabled` true to prevent Flyway clean operations, false otherwise. Environment variable: `QUARKUS_FLYWAY__NAMED_DATA_SOURCES__CLEAN_DISABLED` Show more	boolean	`false`
`quarkus.flyway."named-data-sources".clean-on-validation-error` true to automatically call clean when a validation error occurs, false otherwise. Environment variable: `QUARKUS_FLYWAY__NAMED_DATA_SOURCES__CLEAN_ON_VALIDATION_ERROR` Show more	boolean	`false`
`quarkus.flyway."named-data-sources".migrate-at-start` true to execute Flyway automatically when the application starts, false otherwise. Environment variable: `QUARKUS_FLYWAY__NAMED_DATA_SOURCES__MIGRATE_AT_START` Show more	boolean	`false`
`quarkus.flyway."named-data-sources".repair-at-start` true to execute a Flyway repair command when the application starts, false otherwise. Environment variable: `QUARKUS_FLYWAY__NAMED_DATA_SOURCES__REPAIR_AT_START` Show more	boolean	`false`
`quarkus.flyway."named-data-sources".validate-at-start` true to execute a Flyway validate command when the application starts, false otherwise. Environment variable: `QUARKUS_FLYWAY__NAMED_DATA_SOURCES__VALIDATE_AT_START` Show more	boolean	`false`
`quarkus.flyway."named-data-sources".baseline-on-migrate` true to execute Flyway baseline before migrations This flag is ignored if the flyway_schema_history table exists in the current schema or if the current schema is empty. Note that this will not automatically call migrate, you must either enable baselineAtStart or programmatically call flyway.migrate(). Environment variable: `QUARKUS_FLYWAY__NAMED_DATA_SOURCES__BASELINE_ON_MIGRATE` Show more	boolean	`false`
`quarkus.flyway."named-data-sources".baseline-at-start` true to execute Flyway baseline automatically when the application starts. This flag is ignored if the flyway_schema_history table exists in the current schema. This will work even if the current schema is empty. Environment variable: `QUARKUS_FLYWAY__NAMED_DATA_SOURCES__BASELINE_AT_START` Show more	boolean	`false`
`quarkus.flyway."named-data-sources".baseline-version` The initial baseline version. Environment variable: `QUARKUS_FLYWAY__NAMED_DATA_SOURCES__BASELINE_VERSION` Show more	string
`quarkus.flyway."named-data-sources".baseline-description` The description to tag an existing schema with when executing baseline. Environment variable: `QUARKUS_FLYWAY__NAMED_DATA_SOURCES__BASELINE_DESCRIPTION` Show more	string
`quarkus.flyway."named-data-sources".validate-on-migrate` Whether to automatically call validate when performing a migration. Environment variable: `QUARKUS_FLYWAY__NAMED_DATA_SOURCES__VALIDATE_ON_MIGRATE` Show more	boolean	`true`
`quarkus.flyway."named-data-sources".out-of-order` Allows migrations to be run "out of order". Environment variable: `QUARKUS_FLYWAY__NAMED_DATA_SOURCES__OUT_OF_ORDER` Show more	boolean	`false`
`quarkus.flyway."named-data-sources".ignore-missing-migrations` Ignore missing migrations when reading the history table. When set to true migrations from older versions present in the history table but absent in the configured locations will be ignored (and logged as a warning), when false (the default) the validation step will fail. Environment variable: `QUARKUS_FLYWAY__NAMED_DATA_SOURCES__IGNORE_MISSING_MIGRATIONS` Show more	boolean	`false`
`quarkus.flyway."named-data-sources".ignore-future-migrations` Ignore future migrations when reading the history table. When set to true migrations from newer versions present in the history table but absent in the configured locations will be ignored (and logged as a warning), when false (the default) the validation step will fail. Environment variable: `QUARKUS_FLYWAY__NAMED_DATA_SOURCES__IGNORE_FUTURE_MIGRATIONS` Show more	boolean	`false`
`quarkus.flyway."named-data-sources".placeholders` Sets the placeholders to replace in SQL migration scripts. Environment variable: `QUARKUS_FLYWAY__NAMED_DATA_SOURCES__PLACEHOLDERS` Show more	`Map<String,String>`
`quarkus.flyway."named-data-sources".create-schemas` Whether Flyway should attempt to create the schemas specified in the schemas property Environment variable: `QUARKUS_FLYWAY__NAMED_DATA_SOURCES__CREATE_SCHEMAS` Show more	boolean	`true`
`quarkus.flyway."named-data-sources".placeholder-prefix` Prefix of every placeholder (default: ${ ) Environment variable: `QUARKUS_FLYWAY__NAMED_DATA_SOURCES__PLACEHOLDER_PREFIX` Show more	string
`quarkus.flyway."named-data-sources".placeholder-suffix` Suffix of every placeholder (default: } ) Environment variable: `QUARKUS_FLYWAY__NAMED_DATA_SOURCES__PLACEHOLDER_SUFFIX` Show more	string
`quarkus.flyway."named-data-sources".init-sql` The SQL statements to run to initialize a new database connection immediately after opening it. Environment variable: `QUARKUS_FLYWAY__NAMED_DATA_SOURCES__INIT_SQL` Show more	string
`quarkus.flyway."named-data-sources".validate-migration-naming` Whether to validate migrations and callbacks whose scripts do not obey the correct naming convention. A failure can be useful to check that errors such as case sensitivity in migration prefixes have been corrected. Environment variable: `QUARKUS_FLYWAY__NAMED_DATA_SOURCES__VALIDATE_MIGRATION_NAMING` Show more	boolean	`false`
`quarkus.flyway."named-data-sources".ignore-migration-patterns` Ignore migrations during validate and repair according to a given list of patterns (see https://flywaydb.org/documentation/configuration/parameters/ignoreMigrationPatterns for more information). When this configuration is set, the ignoreFutureMigrations and ignoreMissingMigrations settings are ignored. Patterns are comma separated. Environment variable: `QUARKUS_FLYWAY__NAMED_DATA_SOURCES__IGNORE_MIGRATION_PATTERNS` Show more	list of string

Configuration property

类型

默认

quarkus.flyway.enabled

Whether Flyway is enabled during the build.

If Flyway is disabled, the Flyway beans won’t be created and Flyway won’t be usable.

Environment variable: QUARKUS_FLYWAY_ENABLED

boolean

true

quarkus.flyway.locations

Comma-separated list of locations to scan recursively for migrations. The location type is determined by its prefix.

Unprefixed locations or locations starting with classpath: point to a package on the classpath and may contain both SQL and Java-based migrations.

Locations starting with filesystem: point to a directory on the filesystem, may only contain SQL migrations and are only scanned recursively down non-hidden directories.

Environment variable: QUARKUS_FLYWAY_LOCATIONS

list of string

db/migration

quarkus.flyway.callbacks

Comma-separated list of fully qualified class names of Callback implementations to use to hook into the Flyway lifecycle. The org.flywaydb.core.api.callback.Callback subclass must have a no-args constructor and must not be abstract. These classes must also not have any fields that hold state (unless that state is initialized in the constructor).

Environment variable: QUARKUS_FLYWAY_CALLBACKS

list of string

quarkus.flyway.active

Flag to activate/deactivate Flyway for a specific datasource at runtime.

Environment variable: QUARKUS_FLYWAY_ACTIVE

boolean

true

quarkus.flyway.connect-retries

The maximum number of retries when attempting to connect to the database.

After each failed attempt, Flyway will wait up to the configured connect-retries-interval duration before attempting to connect again, up to the maximum number of times specified by connectRetries.

Environment variable: QUARKUS_FLYWAY_CONNECT_RETRIES

int

quarkus.flyway.connect-retries-interval

The maximum time between retries when attempting to connect to the database.

This will cap the interval between connect retries to the value provided.

Environment variable: QUARKUS_FLYWAY_CONNECT_RETRIES_INTERVAL

Duration

120 seconds

quarkus.flyway.default-schema

Sets the default schema managed by Flyway. This schema name is case-sensitive. If not specified, but schemas is, Flyway uses the first schema in that list. If that is also not specified, Flyway uses the default schema for the database connection.

Consequences:

This schema will be the one containing the schema history table.
This schema will be the default for the database connection (provided the database supports this concept).

Environment variable: QUARKUS_FLYWAY_DEFAULT_SCHEMA

string

quarkus.flyway.jdbc-url

The JDBC URL that Flyway uses to connect to the database. Falls back to the datasource URL if not specified.

Environment variable: QUARKUS_FLYWAY_JDBC_URL

string

quarkus.flyway.username

The username that Flyway uses to connect to the database. If no specific JDBC URL is configured, falls back to the datasource username if not specified.

Environment variable: QUARKUS_FLYWAY_USERNAME

string

quarkus.flyway.password

The password that Flyway uses to connect to the database. If no specific JDBC URL is configured, falls back to the datasource password if not specified.

Environment variable: QUARKUS_FLYWAY_PASSWORD

string

quarkus.flyway.schemas

Comma-separated case-sensitive list of schemas managed by Flyway. The first schema in the list will be automatically set as the default one during the migration. It will also be the one containing the schema history table.

Environment variable: QUARKUS_FLYWAY_SCHEMAS

list of string

quarkus.flyway.table

The name of Flyway’s schema history table. By default (single-schema mode), the schema history table is placed in the default schema for the connection provided by the datasource. When the flyway.schemas property is set (multi-schema mode), the schema history table is placed in the first schema of the list.

Environment variable: QUARKUS_FLYWAY_TABLE

string

quarkus.flyway.sql-migration-prefix

The file name prefix for versioned SQL migrations. Versioned SQL migrations have the following file name structure: prefixVERSIONseparatorDESCRIPTIONsuffix , which using the defaults translates to V1.1__My_description.sql

Environment variable: QUARKUS_FLYWAY_SQL_MIGRATION_PREFIX

string

quarkus.flyway.repeatable-sql-migration-prefix

The file name prefix for repeatable SQL migrations. Repeatable SQL migrations have the following file name structure: prefixSeparatorDESCRIPTIONsuffix , which using the defaults translates to R__My_description.sql

Environment variable: QUARKUS_FLYWAY_REPEATABLE_SQL_MIGRATION_PREFIX

string

quarkus.flyway.clean-at-start

true to execute Flyway clean command automatically when the application starts, false otherwise.

Environment variable: QUARKUS_FLYWAY_CLEAN_AT_START

boolean

false

quarkus.flyway.clean-disabled

true to prevent Flyway clean operations, false otherwise.

Environment variable: QUARKUS_FLYWAY_CLEAN_DISABLED

boolean

false

quarkus.flyway.clean-on-validation-error

true to automatically call clean when a validation error occurs, false otherwise.

Environment variable: QUARKUS_FLYWAY_CLEAN_ON_VALIDATION_ERROR

boolean

false

quarkus.flyway.migrate-at-start

true to execute Flyway automatically when the application starts, false otherwise.

Environment variable: QUARKUS_FLYWAY_MIGRATE_AT_START

boolean

false

quarkus.flyway.repair-at-start

true to execute a Flyway repair command when the application starts, false otherwise.

Environment variable: QUARKUS_FLYWAY_REPAIR_AT_START

boolean

false

quarkus.flyway.validate-at-start

true to execute a Flyway validate command when the application starts, false otherwise.

Environment variable: QUARKUS_FLYWAY_VALIDATE_AT_START

boolean

false

quarkus.flyway.baseline-on-migrate

true to execute Flyway baseline before migrations This flag is ignored if the flyway_schema_history table exists in the current schema or if the current schema is empty. Note that this will not automatically call migrate, you must either enable baselineAtStart or programmatically call flyway.migrate().

Environment variable: QUARKUS_FLYWAY_BASELINE_ON_MIGRATE

boolean

false

quarkus.flyway.baseline-at-start

true to execute Flyway baseline automatically when the application starts. This flag is ignored if the flyway_schema_history table exists in the current schema. This will work even if the current schema is empty.

Environment variable: QUARKUS_FLYWAY_BASELINE_AT_START

boolean

false

quarkus.flyway.baseline-version

The initial baseline version.

Environment variable: QUARKUS_FLYWAY_BASELINE_VERSION

string

quarkus.flyway.baseline-description

The description to tag an existing schema with when executing baseline.

Environment variable: QUARKUS_FLYWAY_BASELINE_DESCRIPTION

string

quarkus.flyway.validate-on-migrate

Whether to automatically call validate when performing a migration.

Environment variable: QUARKUS_FLYWAY_VALIDATE_ON_MIGRATE

boolean

true

quarkus.flyway.out-of-order

Allows migrations to be run "out of order".

Environment variable: QUARKUS_FLYWAY_OUT_OF_ORDER

boolean

false

quarkus.flyway.ignore-missing-migrations

Ignore missing migrations when reading the history table. When set to true migrations from older versions present in the history table but absent in the configured locations will be ignored (and logged as a warning), when false (the default) the validation step will fail.

Environment variable: QUARKUS_FLYWAY_IGNORE_MISSING_MIGRATIONS

boolean

false

quarkus.flyway.ignore-future-migrations

Ignore future migrations when reading the history table. When set to true migrations from newer versions present in the history table but absent in the configured locations will be ignored (and logged as a warning), when false (the default) the validation step will fail.

Environment variable: QUARKUS_FLYWAY_IGNORE_FUTURE_MIGRATIONS

boolean

false

quarkus.flyway.create-schemas

Whether Flyway should attempt to create the schemas specified in the schemas property

Environment variable: QUARKUS_FLYWAY_CREATE_SCHEMAS

boolean

true

quarkus.flyway.placeholder-prefix

Prefix of every placeholder (default: ${ )

Environment variable: QUARKUS_FLYWAY_PLACEHOLDER_PREFIX

string

quarkus.flyway.placeholder-suffix

Suffix of every placeholder (default: } )

Environment variable: QUARKUS_FLYWAY_PLACEHOLDER_SUFFIX

string

quarkus.flyway.init-sql

The SQL statements to run to initialize a new database connection immediately after opening it.

Environment variable: QUARKUS_FLYWAY_INIT_SQL

string

quarkus.flyway.validate-migration-naming

Whether to validate migrations and callbacks whose scripts do not obey the correct naming convention. A failure can be useful to check that errors such as case sensitivity in migration prefixes have been corrected.

Environment variable: QUARKUS_FLYWAY_VALIDATE_MIGRATION_NAMING

boolean

false

quarkus.flyway.ignore-migration-patterns

Ignore migrations during validate and repair according to a given list of patterns (see https://flywaydb.org/documentation/configuration/parameters/ignoreMigrationPatterns for more information). When this configuration is set, the ignoreFutureMigrations and ignoreMissingMigrations settings are ignored. Patterns are comma separated.

Environment variable: QUARKUS_FLYWAY_IGNORE_MIGRATION_PATTERNS

list of string

quarkus.flyway."named-data-sources".locations

Comma-separated list of locations to scan recursively for migrations. The location type is determined by its prefix.

Unprefixed locations or locations starting with classpath: point to a package on the classpath and may contain both SQL and Java-based migrations.

Locations starting with filesystem: point to a directory on the filesystem, may only contain SQL migrations and are only scanned recursively down non-hidden directories.

Environment variable: QUARKUS_FLYWAY__NAMED_DATA_SOURCES__LOCATIONS

list of string

db/migration

quarkus.flyway."named-data-sources".callbacks

Environment variable: QUARKUS_FLYWAY__NAMED_DATA_SOURCES__CALLBACKS

list of string

quarkus.flyway.placeholders

Sets the placeholders to replace in SQL migration scripts.

Environment variable: QUARKUS_FLYWAY_PLACEHOLDERS

Map<String,String>

quarkus.flyway."named-data-sources".active

Flag to activate/deactivate Flyway for a specific datasource at runtime.

Environment variable: QUARKUS_FLYWAY__NAMED_DATA_SOURCES__ACTIVE

boolean

true

quarkus.flyway."named-data-sources".connect-retries

The maximum number of retries when attempting to connect to the database.

After each failed attempt, Flyway will wait up to the configured connect-retries-interval duration before attempting to connect again, up to the maximum number of times specified by connectRetries.

Environment variable: QUARKUS_FLYWAY__NAMED_DATA_SOURCES__CONNECT_RETRIES

int

quarkus.flyway."named-data-sources".connect-retries-interval

The maximum time between retries when attempting to connect to the database.

This will cap the interval between connect retries to the value provided.

Environment variable: QUARKUS_FLYWAY__NAMED_DATA_SOURCES__CONNECT_RETRIES_INTERVAL

Duration

120 seconds

quarkus.flyway."named-data-sources".default-schema

Consequences:

This schema will be the one containing the schema history table.
This schema will be the default for the database connection (provided the database supports this concept).

Environment variable: QUARKUS_FLYWAY__NAMED_DATA_SOURCES__DEFAULT_SCHEMA

string

quarkus.flyway."named-data-sources".jdbc-url

The JDBC URL that Flyway uses to connect to the database. Falls back to the datasource URL if not specified.

Environment variable: QUARKUS_FLYWAY__NAMED_DATA_SOURCES__JDBC_URL

string

quarkus.flyway."named-data-sources".username

The username that Flyway uses to connect to the database. If no specific JDBC URL is configured, falls back to the datasource username if not specified.

Environment variable: QUARKUS_FLYWAY__NAMED_DATA_SOURCES__USERNAME

string

quarkus.flyway."named-data-sources".password

The password that Flyway uses to connect to the database. If no specific JDBC URL is configured, falls back to the datasource password if not specified.

Environment variable: QUARKUS_FLYWAY__NAMED_DATA_SOURCES__PASSWORD

string

quarkus.flyway."named-data-sources".schemas

Environment variable: QUARKUS_FLYWAY__NAMED_DATA_SOURCES__SCHEMAS

list of string

quarkus.flyway."named-data-sources".table

Environment variable: QUARKUS_FLYWAY__NAMED_DATA_SOURCES__TABLE

string

quarkus.flyway."named-data-sources".sql-migration-prefix

Environment variable: QUARKUS_FLYWAY__NAMED_DATA_SOURCES__SQL_MIGRATION_PREFIX

string

quarkus.flyway."named-data-sources".repeatable-sql-migration-prefix

Environment variable: QUARKUS_FLYWAY__NAMED_DATA_SOURCES__REPEATABLE_SQL_MIGRATION_PREFIX

string

quarkus.flyway."named-data-sources".clean-at-start

true to execute Flyway clean command automatically when the application starts, false otherwise.

Environment variable: QUARKUS_FLYWAY__NAMED_DATA_SOURCES__CLEAN_AT_START

boolean

false

quarkus.flyway."named-data-sources".clean-disabled

true to prevent Flyway clean operations, false otherwise.

Environment variable: QUARKUS_FLYWAY__NAMED_DATA_SOURCES__CLEAN_DISABLED

boolean

false

quarkus.flyway."named-data-sources".clean-on-validation-error

true to automatically call clean when a validation error occurs, false otherwise.

Environment variable: QUARKUS_FLYWAY__NAMED_DATA_SOURCES__CLEAN_ON_VALIDATION_ERROR

boolean

false

quarkus.flyway."named-data-sources".migrate-at-start

true to execute Flyway automatically when the application starts, false otherwise.

Environment variable: QUARKUS_FLYWAY__NAMED_DATA_SOURCES__MIGRATE_AT_START

boolean

false

quarkus.flyway."named-data-sources".repair-at-start

true to execute a Flyway repair command when the application starts, false otherwise.

Environment variable: QUARKUS_FLYWAY__NAMED_DATA_SOURCES__REPAIR_AT_START

boolean

false

quarkus.flyway."named-data-sources".validate-at-start

true to execute a Flyway validate command when the application starts, false otherwise.

Environment variable: QUARKUS_FLYWAY__NAMED_DATA_SOURCES__VALIDATE_AT_START

boolean

false

quarkus.flyway."named-data-sources".baseline-on-migrate

Environment variable: QUARKUS_FLYWAY__NAMED_DATA_SOURCES__BASELINE_ON_MIGRATE

boolean

false

quarkus.flyway."named-data-sources".baseline-at-start

Environment variable: QUARKUS_FLYWAY__NAMED_DATA_SOURCES__BASELINE_AT_START

boolean

false

quarkus.flyway."named-data-sources".baseline-version

The initial baseline version.

Environment variable: QUARKUS_FLYWAY__NAMED_DATA_SOURCES__BASELINE_VERSION

string

quarkus.flyway."named-data-sources".baseline-description

The description to tag an existing schema with when executing baseline.

Environment variable: QUARKUS_FLYWAY__NAMED_DATA_SOURCES__BASELINE_DESCRIPTION

string

quarkus.flyway."named-data-sources".validate-on-migrate

Whether to automatically call validate when performing a migration.

Environment variable: QUARKUS_FLYWAY__NAMED_DATA_SOURCES__VALIDATE_ON_MIGRATE

boolean

true

quarkus.flyway."named-data-sources".out-of-order

Allows migrations to be run "out of order".

Environment variable: QUARKUS_FLYWAY__NAMED_DATA_SOURCES__OUT_OF_ORDER

boolean

false

quarkus.flyway."named-data-sources".ignore-missing-migrations

Environment variable: QUARKUS_FLYWAY__NAMED_DATA_SOURCES__IGNORE_MISSING_MIGRATIONS

boolean

false

quarkus.flyway."named-data-sources".ignore-future-migrations

Environment variable: QUARKUS_FLYWAY__NAMED_DATA_SOURCES__IGNORE_FUTURE_MIGRATIONS

boolean

false

quarkus.flyway."named-data-sources".placeholders

Sets the placeholders to replace in SQL migration scripts.

Environment variable: QUARKUS_FLYWAY__NAMED_DATA_SOURCES__PLACEHOLDERS

Map<String,String>

quarkus.flyway."named-data-sources".create-schemas

Whether Flyway should attempt to create the schemas specified in the schemas property

Environment variable: QUARKUS_FLYWAY__NAMED_DATA_SOURCES__CREATE_SCHEMAS

boolean

true

quarkus.flyway."named-data-sources".placeholder-prefix

Prefix of every placeholder (default: ${ )

Environment variable: QUARKUS_FLYWAY__NAMED_DATA_SOURCES__PLACEHOLDER_PREFIX

string

quarkus.flyway."named-data-sources".placeholder-suffix

Suffix of every placeholder (default: } )

Environment variable: QUARKUS_FLYWAY__NAMED_DATA_SOURCES__PLACEHOLDER_SUFFIX

string

quarkus.flyway."named-data-sources".init-sql

The SQL statements to run to initialize a new database connection immediately after opening it.

Environment variable: QUARKUS_FLYWAY__NAMED_DATA_SOURCES__INIT_SQL

string

quarkus.flyway."named-data-sources".validate-migration-naming

Environment variable: QUARKUS_FLYWAY__NAMED_DATA_SOURCES__VALIDATE_MIGRATION_NAMING

boolean

false

quarkus.flyway."named-data-sources".ignore-migration-patterns

Environment variable: QUARKUS_FLYWAY__NAMED_DATA_SOURCES__IGNORE_MIGRATION_PATTERNS

list of string

About the Duration format

To write duration values, use the standard java.time.Duration format. See the Duration#parse() javadoc for more information.

You can also use a simplified format, starting with a number:

If the value is only a number, it represents time in seconds.
If the value is a number followed by ms, it represents time in milliseconds.

In other cases, the simplified format is translated to the java.time.Duration format for parsing:

If the value is a number followed by h, m, or s, it is prefixed with PT.
If the value is a number followed by d, it is prefixed with P.

用Flyway开发

The following is an example for the application.properties file:

# configure your datasource
quarkus.datasource.db-kind=postgresql
quarkus.datasource.username=sarah
quarkus.datasource.password=connor
quarkus.datasource.jdbc.url=jdbc:postgresql://localhost:5432/mydatabase

# Run Flyway migrations automatically
quarkus.flyway.migrate-at-start=true

# More Flyway configuration options
# quarkus.flyway.baseline-on-migrate=true
# quarkus.flyway.baseline-version=1.0.0
# quarkus.flyway.baseline-description=Initial version
# quarkus.flyway.connect-retries=10
# quarkus.flyway.schemas=TEST_SCHEMA
# quarkus.flyway.table=flyway_quarkus_history
# quarkus.flyway.locations=db/location1,db/location2
# quarkus.flyway.sql-migration-prefix=X
# quarkus.flyway.repeatable-sql-migration-prefix=K

按照Flyway的命名惯例，在默认文件夹中添加SQL迁移： src/main/resources/db/migration/V1.0.0__Quarkus.sql

CREATE TABLE quarkus
(
  id   INT,
  name VARCHAR(20)
);
INSERT INTO quarkus(id, name)
VALUES (1, 'QUARKED');

现在可以启动你的应用程序，Quarkus会根据你的配置来运行Flyway的迁移方法。

如上例所述，通过设置 quarkus.flyway.migrate-at-start=true Quarkus将在应用启动的时候通过Flyway进行迁移。

@ApplicationScoped
public class MigrationService {
    // You can Inject the object if you want to use it manually
    @Inject
    Flyway flyway; (1)

    public void checkMigration() {
        // This will print 1.0.0
        System.out.println(flyway.info().current().getVersion().toString());
    }
}

1	如果你想直接使用Flyway对象，请注入该对象

如果任何当前迁移脚本被修改，Quarkus在开发模式下会自动重启应用。如果你想在开发测试新的迁移脚本的时候充分利用这个特性，你需要设置 %dev.quarkus.flyway.clean-at-start=true ，这样Flyway会运行被修改的迁移脚本。

Repairing the Flyway schema history table

There are different scenarios which may require repairing the Flyway schema history table. One such scenario is when a migration fails in a database which doesn’t support transactional DDL statements.

In such situations the Flyway repair command comes in handy. In Quarkus this can either be executed automatically before the migration by setting quarkus.flyway.repair-at-start=true or manually by injecting the Flyway object and calling Flyway#repair().

Multiple datasources

Flyway can be configured for multiple datasources. The Flyway properties are prefixed exactly the same way as the named datasources, for example:

quarkus.datasource.db-kind=h2
quarkus.datasource.username=username-default
quarkus.datasource.jdbc.url=jdbc:h2:tcp://localhost/mem:default
quarkus.datasource.jdbc.max-size=13

quarkus.datasource.users.db-kind=h2
quarkus.datasource.users.username=username1
quarkus.datasource.users.jdbc.url=jdbc:h2:tcp://localhost/mem:users
quarkus.datasource.users.jdbc.max-size=11

quarkus.datasource.inventory.db-kind=h2
quarkus.datasource.inventory.username=username2
quarkus.datasource.inventory.jdbc.url=jdbc:h2:tcp://localhost/mem:inventory
quarkus.datasource.inventory.jdbc.max-size=12

# Flyway configuration for the default datasource
quarkus.flyway.schemas=DEFAULT_TEST_SCHEMA
quarkus.flyway.locations=db/default/location1,db/default/location2
quarkus.flyway.migrate-at-start=true

# Flyway configuration for the "users" datasource
quarkus.flyway.users.schemas=USERS_TEST_SCHEMA
quarkus.flyway.users.locations=db/users/location1,db/users/location2
quarkus.flyway.users.migrate-at-start=true

# Flyway configuration for the "inventory" datasource
quarkus.flyway.inventory.schemas=INVENTORY_TEST_SCHEMA
quarkus.flyway.inventory.locations=db/inventory/location1,db/inventory/location2
quarkus.flyway.inventory.migrate-at-start=true

请注意，键中有一个额外的位。语法如下： quarkus.flyway.[optional name.][datasource property] .

在没有配置的情况下，Flyway对每个数据源都是使用默认设置。

Customizing Flyway

In cases where Flyway needs to be configured in addition to the configuration options that Quarkus provides, the io.quarkus.flyway.FlywayConfigurationCustomizer class comes in handy.

To customize Flyway for the default datasource, simply add a bean like so:

@Singleton
public static class MyCustomizer implements FlywayConfigurationCustomizer {

    @Override
    public void customize(FluentConfiguration configuration) {
        // do something with configuration
    }
}

When named datasources are used, the @FlywayDataSource annotation can be used to specify the datasource to which the customizer applies. For example, if there are multiple datasources one of which is called users and customization of Flyway is needed for only that datasource, then the following code can be used:

@Singleton
@FlywayDataSource("users")
public static class UsersCustomizer implements FlywayConfigurationCustomizer {

    @Override
    public void customize(FluentConfiguration configuration) {
        // do something with configuration
    }
}

使用Flyway对象

如果你有兴趣直接使用 Flyway 对象，可以按以下方式注入。

@ApplicationScoped
public class MigrationService {
    // You can Inject the object if you want to use it manually
    @Inject
    Flyway flyway; (1)

    @Inject
    @FlywayDataSource("inventory") (2)
    Flyway flywayForInventory;

    @Inject
    @Named("flyway_users") (3)
    Flyway flywayForUsers;

    public void checkMigration() {
        // Use the flyway instance manually
        flyway.clean(); (4)
        flyway.migrate();
        // This will print 1.0.0
        System.out.println(flyway.info().current().getVersion().toString());
    }
}

1	如果你想直接使用Flyway对象，请注入该对象
2	使用Quarkus `FlywayDataSource` 限定符为指定的数据源注入Flyway。
3	为命名的数据源注入Flyway
4	直接使用Flyway实例

Flyway和Hibernate ORM

当Flyway与Hibernate ORM一起使用时，你可以使用Dev UI来生成初始表创建脚本。

你可以在Hibernate ORM guide找到更多相关信息。

Flyway on Kubernetes

Sometimes, it’s helpful not to execute Flyway initialization on each application startup. One such example is when deploying

on Kubernetes, where it doesn’t make sense to execute Flyway on every single replica. Instead it’s desirable to execute it once and then start the actual application without Flyway. To support this use case, when generating manifests for Kubernetes the generated manifests contain a Kubernetes initialization Job for Flyway. The Job performs initialization and the actual Pod, will starts once the Job is successfully completed.

Disabling

The feature is enabled by default and can be globally disabled, using:

quarkus.kubernetes.init-task-defaults.enabled=false

or on OpenShift:

quarkus.openshift.init-task-defaults.enabled=false

Using a custom image that controls waiting for the Job

To change the wait-for image which by default is groundnuty/k8s-wait-for:no-root-v1.7 you can use:

quarkus.kubernetes.init-task-defaults.wait-for-container.image=my/wait-for-image:1.0

or on Openshift:

quarkus.openshift.init-task-defaults.wait-for-container.image=my/wait-for-image:1.0

Note: In this context globally means for all extensions that support init task externalization.