在已有的项目中集成flyway
集成的2种方式:
方式一:在spring中集成flyway,定义在应用启动时自动运行Flyway
- 首先加入flyway的核心jar包
<dependency>
<groupId>org.flywaydb</groupId>
<artifactId>flyway-core</artifactId>
<version>${Flyway.version}</version>
</dependency>
-
在spring的配置文件中配置
<!-- Flyway configuration -->
<bean id="flyway" class="org.Flyway.core.Flyway" init-method="migrate">
<property name="baselineOnMigrate" value="true" />
<property name="locations" value="filesystem:/path/to/migrations/" />
<property name="dataSource" ref="dataSource" />
</bean>
<!-- Entity Manager Factory configuration -->
<bean id="entityManagerFactory" class="o.s.orm.jpa.LocalContainerEntityManagerFactoryBean" depends-on="flyway">
<property name="dataSource" ref="dataSource" />
<property name="jpaVendorAdapter">
<bean class="o.s.orm.jpa.vendor.HibernateJpaVendorAdapter">
<property name="database" value="${jpa.database}"/>
</bean>
</property>
</bean>
<!-- an example of a data source -->
<bean id="dataSource" class="o.a.commons.dbcp.BasicDataSource" lazy-init="true" destroy-method="close">
<property name="driverClassName" value="org.hsqldb.jdbcDriver"/>
<property name="url" value="jdbc:hsqldb:mem:qade"/>
<property name="username" value="sa"/>
<property name="password" value=""/>
</bean>
-
如果使用spring的JavaConfig来配置,则应该这样配置
@Configuration
public class AppConfig {
@Bean(initMethod = "migrate")
Flyway flyway() {
Flyway flyway = new Flyway();
flyway.setBaselineOnMigrate(true);
flyway.setLocations("filesystem:/path/to/migrations/");
flyway.setDataSource(dataSource());
return flyway;
}
@Bean
@DependsOn("flyway") //??flyway?entityManagerFactory?????????
EntityManagerFactory entityManagerFactory() {
LocalContainerEntityManagerFactoryBean bean = new LocalContainerEntityManagerFactoryBean();
bean.setDataSource(dataSource());
// other configurations
return bean.getObject();
}
@Bean
DataSource dataSource() {
DataSource dataSource = new BasicDataSource();
// data source configuration
return dataSource;
}
}
-
如果上面的dataSource是在另一个JavaConfig文件中,则这样配置
@Autowired
DataSource dataSource;
注意:
sql文件的命名规则V<VERSION>__<DESCRIPTION>.<FORMAT>
版本名+DESCRIPTION+后缀(.sql)
版本名中间可以有.和_,例如V1 V1.1 V1_1
注意版本名和DESCRIPTION之间有2个下划线
DESCRIPTION中间也可以有下划线
方式二:在maven命令行执行
-
首先配置maven插件
<plugin>
<groupId>org.flywaydb</groupId>
<artifactId>flyway-maven-plugin</artifactId>
<version>${flyway.version}</version>
<configuration>
<driver>com.mysql.jdbc.Driver</driver>
<url>jdbc:mysql://localhost:3306/huatuo_dev?useUnicode=true&characterEncoding=utf-8&useSSL=false</url>
<user>root</user>
<password></password>
<!-- 设置接受flyway进行版本管理的数据库,多个数据库以逗号分隔 -->
<schemas>huatuo_dev</schemas>
<!-- 设置存放flyway metadata数据的表名 -->
<table>schema_version</table>
<!-- 设置flyway扫描sql升级脚本、java升级脚本的目录路径或包路径 -->
<locations>
<location>/db/migration/mysql</location>
<!--<location>com.kedacom.flywaydemo.migrations</location>-->
</locations>
<!-- 设置sql脚本文件的编码 -->
<encoding>UTF-8</encoding>
</configuration>
</plugin>
然后执行命令,常见命令如下:
如果我们想初始化数据库,删除所有的表和数据,那么只需要执行命令:
mvn flyway:clean
如果我们想知道所有migration的详细信息,可以通过执行下面命令来打印信息:
mvn flyway:info
用来validate已经执行的migration任务。
mvn flyway:validate
mvn flyway:baseline
用来回滚数据库到一个配置文件中设定好的baseline。
用来删除执行失败的migration任务。
mvn flyway:repair