spring boot使用flyway

spring boot集成flyway

1.添加pom依赖

    <plugin>
        <groupId>org.flywaydb</groupId>
        <artifactId>flyway-maven-plugin</artifactId>
        <executions>
            <!--当install时会执行migrate-->
            <execution>
                <phase>generate-sources</phase>
                <goals>
                    <goal>migrate</goal>
                </goals>
            </execution>
        </executions>
        <dependencies>
            <dependency>
                <groupId>mysql</groupId>
                <artifactId>mysql-connector-java</artifactId>
                <version>5.1.39</version>
            </dependency>
        </dependencies>
        <configuration>
            <driver>com.mysql.jdbc.Driver</driver>
            <url>jdbc:mysql://localhost:3306/first_boot</url>
            <user>root</user>
            <password>123456</password>
            <!--<schemas></schemas>-->
        </configuration>
 </plugin>

2.在resource里添加文件夹db/migration

3.将数据库导出sql到上面创建的migration文件夹下，并重命名为
V1_XX_XX_XX.sql，注意V1的V必须大写

4.运行mvn flyway:migrate即可运行sql

mvn flyway:migrate