mvn管理flyway数据库版本

maven 的pom添加flyway插件

---

<!-- flyway数据库版本管理插件，用于单测时生成数据库-->
<plugin>
    <groupId>org.flywaydb</groupId>
    <artifactId>flyway-maven-plugin</artifactId>
    <version>4.0.3</version>
    <dependencies>
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.38</version>
        </dependency>
    </dependencies>
    <configuration>
        <driver>com.mysql.jdbc.Driver</driver>
        <url>jdbc:mysql://localhost:3306/bce_budget?useSSL=true</url>
        <user>root</user>
        <password>ant</password>
        <!-- 设置flyway sql执行文件路径 -->
        <locations>
            <location>filesystem:sql</location>
        </locations>
        <!-- 设置sql脚本文件的编码 -->
        <encoding>UTF-8</encoding>
    </configuration>
</plugin>

flyway常用命令:

./mvnw flyway:clean

./mvnw flyway:repair

./mvnw flyway:migrate