Spring Boot Flyway

原创

陈振阳Plus 2022-11-03 19:55:27 博主文章分类：Spring Boot ©著作权

文章标签 spring boot java mysql sql spring 文章分类 spring boot 后端开发

©著作权归作者所有：来自51CTO博客作者陈振阳Plus的原创作品，请联系作者获取转载授权，否则将追究法律责任

发博词

Spring Boot AutoConfigure封装了两种类型的数据库版本控制工具：flyway和liquibase。简单比较了一下，flyway要方便很多。

配置详解

FLYWAY (FlywayProperties)

flyway.enabled=true # Enable flyway.
flyway.encoding= #
flyway.baseline-on-migrate= true#
flyway.baseline-description= #
flyway.baseline-version=1 # version to start migration
flyway.url= # JDBC url of the database to migrate. If not set, the primary configured data source is used.
flyway.user= # Login user of the database to migrate.
flyway.password= # JDBC password if you want Flyway to create its own DataSource
flyway.schemas= # schemas to update
flyway.table= schema_version#
flyway.target=迁移时使用的目标版本，默认为latest version，也就是全部脚本文件都执行
flyway.out-of-order= #
flyway.init-sqls= # SQL statements to execute to initialize a connection immediately after obtaining it.
flyway.check-location=false # Check that migration scripts location exists.
flyway.clean-on-validation-error= #
flyway.validate-on-migrate= #
flyway.ignore-failed-future-migration= #
flyway.locations=classpath:db/migration # locations of migrations scripts
flyway.placeholder-prefix= #
flyway.placeholder-replacement= #
flyway.placeholder-suffix= #
flyway.placeholders.*= #
flyway.sql-migration-prefix=V #
flyway.sql-migration-separator= #
flyway.sql-migration-suffix=.sql #

TIP

baseline

flyway.baseline-on-migrate: true
flyway.baseline-version: 0.1.0.2
flyway.baseline-description: sdfs

Spring Boot 1.5.6.RELEASE的flyway.baseline-version属性不管用；

placeholders

placeholders 提供了类似freemaker的模板功能，可以在脚本中写入 create table ${foo1}; 在flyway.setPlaceholders(map->{map.put(“foo1”,“table1”)})，替换脚本中的foo1 =》 table1

常用配置

flyway:
  enabled: true 
  url: jdbc:mysql://localhost:3306/flyway_test
  user: root
  password: root
  check-location: true
  locations: classpath:db/migration/mysql
  validate-on-migrate: true
  clean-on-validation-error: true
  target: 1.1.0.2
  baseline-on-migrate: true
  baseline-version: 0.1.0.2
  baseline-description: sdfs