springboot2 集成flyway4.2.0
参考文献:
https://stackoverflow.com/questions/53343506/spring-boot-2-1-0-with-flyway-4-2-0
因为flyway4.2.0以上不支持oracle11.2版本,所以flyway选择4.2.0版本;
同时springboot2.x对flyway的依赖为5.x,旧的api已经不支持,故做修改
引入依赖
<dependency>
<groupId>org.flywaydb</groupId>
<artifactId>flyway-core</artifactId>
<version>4.2.0</version>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-jdbc</artifactId>
</dependency>
注入bean
springboot下集成了 对flyway的自动化配置org.springframework.boot.autoconfigure.flyway.FlywayAutoConfiguration
@Configuration(proxyBeanMethods = false)
@ConditionalOnMissingBean(Flyway.class)
@EnableConfigurationProperties({ DataSourceProperties.class, FlywayProperties.class })
@Import({ FlywayMigrationInitializerEntityManagerFactoryDependsOnPostProcessor.class,
FlywayMigrationInitializerJdbcOperationsDependsOnPostProcessor.class,
FlywayMigrationInitializerNamedParameterJdbcOperationsDependsOnPostProcessor.class })
public static class FlywayConfiguration {
@Bean
public Flyway flyway(FlywayProperties properties, DataSourceProperties dataSourceProperties,
ResourceLoader resourceLoader, ObjectProvider<DataSource> dataSource,
@FlywayDataSource ObjectProvider<DataSource> flywayDataSource,
ObjectProvider<FlywayConfigurationCustomizer> fluentConfigurationCustomizers,
ObjectProvider<JavaMigration> javaMigrations, ObjectProvider<Callback> callbacks) {...}
@Bean
@ConditionalOnMissingBean
public FlywayMigrationInitializer flywayInitializer(Flyway flyway,
ObjectProvider<FlywayMigrationStrategy> migrationStrategy) {
return new FlywayMigrationInitializer(flyway, migrationStrategy.getIfAvailable());
}
如果没有为Flyway的bean,就会采用下面的配置注入flyway和flywayInitializer,所以这里手动注入
@Configuration
@ConditionalOnProperty(prefix = "spring.flyway", name = "enabled", matchIfMissing = true)
public class FlywayConfig {
@Bean
public Flyway flyway(DataSource dataSource) {
Flyway flyway = new Flyway();
flyway.setBaselineOnMigrate(true);
flyway.setDataSource(dataSource);
return flyway;
}
@Bean
public FlywayMigrationInitializer flywayInitializer(Flyway flyway) {
return new MyFlywayMigrationInitializer(flyway, null);
}
}
设置不自动执行flyway初始化脚本
spring-boot-autoconfigure会自动初始化flyway,把bean容器中的DataSource放入Flyway中,在初始化完成之后,在afterPropertiesSet中会自动执行flyway.migrate(),这样就实现了每次启动项目都会自动去查看数据库的版本与存放数据库脚本的版本差异,进行迁移。
public class MyFlywayMigrationInitializer extends FlywayMigrationInitializer {
/**
* Create a new {@link FlywayMigrationInitializer} instance.
*
* @param flyway the flyway instance
* @param migrationStrategy the migration strategy or {@code null}
*/
public MyFlywayMigrationInitializer(Flyway flyway, FlywayMigrationStrategy migrationStrategy) {
super(flyway, migrationStrategy);
}
@Override
public void afterPropertiesSet() throws Exception {
//去掉springboot启动时执行flyway初始化脚本
//super.afterPropertiesSet();
}
}