Flyway自学之路-04（springboot结合Flyway）

╰半橙微兮° 2023-02-12 03:28 33阅读 0赞

1.新建项目

watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTIwNDUwNDU_size_16_color_FFFFFF_t_70

watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTIwNDUwNDU_size_16_color_FFFFFF_t_70 1

watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTIwNDUwNDU_size_16_color_FFFFFF_t_70 2

watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTIwNDUwNDU_size_16_color_FFFFFF_t_70 3

2.添加mysql数据库依赖

  1. <dependency>
  2.             <groupId>org.springframework.boot</groupId>
  3.             <artifactId>spring-boot-starter-jdbc</artifactId>
  4.         </dependency>
  5.         <dependency>
  6.             <groupId>mysql</groupId>
  7.             <artifactId>mysql-connector-java</artifactId>
  8.         </dependency>

pom.xml如下所示

  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  3.          xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd">
  4.     <modelVersion>4.0.0</modelVersion>
  5.     <parent>
  6.         <groupId>org.springframework.boot</groupId>
  7.         <artifactId>spring-boot-starter-parent</artifactId>
  8.         <version>2.3.0.RELEASE</version>
  9.         <relativePath/> <!-- lookup parent from repository -->
  10.     </parent>
  11.     <groupId>com.springboot</groupId>
  12.     <artifactId>my_flyway</artifactId>
  13.     <version>0.0.1-SNAPSHOT</version>
  14.     <name>my_flyway</name>
  15.     <description>Demo project for my_flyway</description>
  17.     <properties>
  18.         <java.version>1.8</java.version>
  19.     </properties>
  21.     <dependencies>
  22.         <dependency>
  23.             <groupId>org.springframework.boot</groupId>
  24.             <artifactId>spring-boot-starter</artifactId>
  25.         </dependency>
  26.         <dependency>
  27.             <groupId>org.flywaydb</groupId>
  28.             <artifactId>flyway-core</artifactId>
  29.         </dependency>
  30.         <dependency>
  31.             <groupId>org.springframework.boot</groupId>
  32.             <artifactId>spring-boot-starter-jdbc</artifactId>
  33.         </dependency>
  34.         <dependency>
  35.             <groupId>mysql</groupId>
  36.             <artifactId>mysql-connector-java</artifactId>
  37.         </dependency>
  38.         <dependency>
  39.             <groupId>org.springframework.boot</groupId>
  40.             <artifactId>spring-boot-starter-test</artifactId>
  41.             <scope>test</scope>
  42.             <exclusions>
  43.                 <exclusion>
  44.                     <groupId>org.junit.vintage</groupId>
  45.                     <artifactId>junit-vintage-engine</artifactId>
  46.                 </exclusion>
  47.             </exclusions>
  48.         </dependency>
  49.     </dependencies>
  51.     <build>
  52.         <plugins>
  53.             <plugin>
  54.                 <groupId>org.springframework.boot</groupId>
  55.                 <artifactId>spring-boot-maven-plugin</artifactId>
  56.             </plugin>
  57.         </plugins>
  58.     </build>
  60. </project>

3.配置application.properties

  1. ## 设定 db source 属性
  2. spring.datasource.url=jdbc:mysql://localhost:3306/flyway?serverTimezone=GMT%2B8&useUnicode=true&characterEncoding=utf-8
  3. spring.datasource.username=root
  4. spring.datasource.password=123456
  6. ## 设定 flyway 属性
  7. #spring.flyway.cleanDisabled = false
  8. # flyway 的 clean 命令会删除指定 schema 下的所有 table, 杀伤力太大了, 应该禁掉.
  9. #spring.flyway.enabled = true
  10. # 启用或禁用 flyway
  11. spring.flyway.locations =classpath:db/migration
  12. # 设定 SQL 脚本的目录,多个路径使用逗号分隔, 比如取值为 classpath:db/migration,filesystem:/sql-migrations
  13. #spring.flyway.baselineOnMigrate=true
  14. # 如果指定 schema 包含了其他表,但没有 flyway schema history 表的话, 在执行 flyway migrate 命令之前, 必须先执行 flyway baseline 命令.
  15. # 设置 spring.flyway.baseline-on-migrate 为 true 后, flyway 将在需要 baseline 的时候, 自动执行一次 baseline.
  16. #spring.flyway.baselineVersion=1
  17. # 指定 baseline 的版本号,缺省值为 1, 低于该版本号的 SQL 文件, migrate 的时候被忽略.
  18. #spring.flyway.encoding=
  19. # Encoding of SQL migrations (default: UTF-8)
  20. #spring.flyway.table=flyway_schema_history_myapp
  21. # 设定 flyway 的 metadata 表名, 缺省为 flyway_schema_history
  22. spring.flyway.outOfOrder=true
  23. # 开发环境最好开启 outOfOrder, 生产环境关闭 outOfOrder .
  24. #spring.flyway.schemas=
  25. # 需要 flyway 管控的 schema list, 缺省的话, 使用的时 dbsource.connection直连上的那个 schema, 可以指定多个schema, 但仅会在第一个schema下建立 metadata 表, 也仅在第一个schema应用migration sql 脚本. 但flyway Clean 命令会依次在这些schema下都执行一遍.

4.添加sql文件

watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTIwNDUwNDU_size_16_color_FFFFFF_t_70 4

  1. /*
  2.  Navicat Premium Data Transfer
  4.  Source Server         : localhost
  5.  Source Server Type    : MySQL
  6.  Source Server Version : 80019
  7.  Source Host           : localhost:3306
  8.  Source Schema         : test
  10.  Target Server Type    : MySQL
  11.  Target Server Version : 80019
  12.  File Encoding         : 65001
  14.  Date: 24/05/2020 09:35:26
  15. */
  17. SET NAMES utf8mb4;
  18. SET FOREIGN_KEY_CHECKS = 0;
  20. -- ----------------------------
  21. -- Table structure for person
  22. -- ----------------------------
  23. DROP TABLE IF EXISTS `person`;
  24. CREATE TABLE `person`  (
  25.   `id` int(0) NOT NULL AUTO_INCREMENT,
  26.   `name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  27.   `age` int(0) NOT NULL,
  28.   PRIMARY KEY (`id`) USING BTREE
  29. ) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '人员信息表' ROW_FORMAT = Dynamic;
  31. -- ----------------------------
  32. -- Records of person
  33. -- ----------------------------
  34. INSERT INTO `person` VALUES (1, 'zhangjie', 32);
  35. INSERT INTO `person` VALUES (2, 'zhangsan', 27);
  37. SET FOREIGN_KEY_CHECKS = 1;

5.启动项目

watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTIwNDUwNDU_size_16_color_FFFFFF_t_70 5

打印日志如下所示：

  1. D:\software\java\jdk_1.8\bin\java.exe -XX:TieredStopAtLevel=1 -noverify -Dspring.output.ansi.enabled=always -Dcom.sun.management.jmxremote -Dcom.sun.management.jmxremote.port=63821 -Dcom.sun.management.jmxremote.authenticate=false -Dcom.sun.management.jmxremote.ssl=false -Djava.rmi.server.hostname=localhost -Dspring.liveBeansView.mbeanDomain -Dspring.application.admin.enabled=true "-javaagent:D:\software\idea\IntelliJ IDEA 2018.3.1\lib\idea_rt.jar=63822:D:\software\idea\IntelliJ IDEA 2018.3.1\bin" -Dfile.encoding=UTF-8 -classpath D:\software\java\jdk_1.8\jre\lib\charsets.jar;D:\software\java\jdk_1.8\jre\lib\deploy.jar;D:\software\java\jdk_1.8\jre\lib\ext\access-bridge-64.jar;D:\software\java\jdk_1.8\jre\lib\ext\cldrdata.jar;D:\software\java\jdk_1.8\jre\lib\ext\dnsns.jar;D:\software\java\jdk_1.8\jre\lib\ext\jaccess.jar;D:\software\java\jdk_1.8\jre\lib\ext\jfxrt.jar;D:\software\java\jdk_1.8\jre\lib\ext\localedata.jar;D:\software\java\jdk_1.8\jre\lib\ext\nashorn.jar;D:\software\java\jdk_1.8\jre\lib\ext\sunec.jar;D:\software\java\jdk_1.8\jre\lib\ext\sunjce_provider.jar;D:\software\java\jdk_1.8\jre\lib\ext\sunmscapi.jar;D:\software\java\jdk_1.8\jre\lib\ext\sunpkcs11.jar;D:\software\java\jdk_1.8\jre\lib\ext\zipfs.jar;D:\software\java\jdk_1.8\jre\lib\javaws.jar;D:\software\java\jdk_1.8\jre\lib\jce.jar;D:\software\java\jdk_1.8\jre\lib\jfr.jar;D:\software\java\jdk_1.8\jre\lib\jfxswt.jar;D:\software\java\jdk_1.8\jre\lib\jsse.jar;D:\software\java\jdk_1.8\jre\lib\management-agent.jar;D:\software\java\jdk_1.8\jre\lib\plugin.jar;D:\software\java\jdk_1.8\jre\lib\resources.jar;D:\software\java\jdk_1.8\jre\lib\rt.jar;D:\搜狗高速下载\flyway-springboot-master\flyway-springboot-master\my_flyway\target\classes;D:\document\eclipse_workspace\local_repository\local_repository\org\springframework\boot\spring-boot-starter\2.3.0.RELEASE\spring-boot-starter-2.3.0.RELEASE.jar;D:\document\eclipse_workspace\local_repository\local_repository\org\springframework\boot\spring-boot\2.3.0.RELEASE\spring-boot-2.3.0.RELEASE.jar;D:\document\eclipse_workspace\local_repository\local_repository\org\springframework\spring-context\5.2.6.RELEASE\spring-context-5.2.6.RELEASE.jar;D:\document\eclipse_workspace\local_repository\local_repository\org\springframework\spring-aop\5.2.6.RELEASE\spring-aop-5.2.6.RELEASE.jar;D:\document\eclipse_workspace\local_repository\local_repository\org\springframework\spring-expression\5.2.6.RELEASE\spring-expression-5.2.6.RELEASE.jar;D:\document\eclipse_workspace\local_repository\local_repository\org\springframework\boot\spring-boot-autoconfigure\2.3.0.RELEASE\spring-boot-autoconfigure-2.3.0.RELEASE.jar;D:\document\eclipse_workspace\local_repository\local_repository\org\springframework\boot\spring-boot-starter-logging\2.3.0.RELEASE\spring-boot-starter-logging-2.3.0.RELEASE.jar;D:\document\eclipse_workspace\local_repository\local_repository\ch\qos\logback\logback-classic\1.2.3\logback-classic-1.2.3.jar;D:\document\eclipse_workspace\local_repository\local_repository\ch\qos\logback\logback-core\1.2.3\logback-core-1.2.3.jar;D:\document\eclipse_workspace\local_repository\local_repository\org\apache\logging\log4j\log4j-to-slf4j\2.13.2\log4j-to-slf4j-2.13.2.jar;D:\document\eclipse_workspace\local_repository\local_repository\org\apache\logging\log4j\log4j-api\2.13.2\log4j-api-2.13.2.jar;D:\document\eclipse_workspace\local_repository\local_repository\org\slf4j\jul-to-slf4j\1.7.30\jul-to-slf4j-1.7.30.jar;D:\document\eclipse_workspace\local_repository\local_repository\jakarta\annotation\jakarta.annotation-api\1.3.5\jakarta.annotation-api-1.3.5.jar;D:\document\eclipse_workspace\local_repository\local_repository\org\springframework\spring-core\5.2.6.RELEASE\spring-core-5.2.6.RELEASE.jar;D:\document\eclipse_workspace\local_repository\local_repository\org\springframework\spring-jcl\5.2.6.RELEASE\spring-jcl-5.2.6.RELEASE.jar;D:\document\eclipse_workspace\local_repository\local_repository\org\yaml\snakeyaml\1.26\snakeyaml-1.26.jar;D:\document\eclipse_workspace\local_repository\local_repository\org\flywaydb\flyway-core\6.4.1\flyway-core-6.4.1.jar;D:\document\eclipse_workspace\local_repository\local_repository\org\springframework\boot\spring-boot-starter-jdbc\2.3.0.RELEASE\spring-boot-starter-jdbc-2.3.0.RELEASE.jar;D:\document\eclipse_workspace\local_repository\local_repository\com\zaxxer\HikariCP\3.4.5\HikariCP-3.4.5.jar;D:\document\eclipse_workspace\local_repository\local_repository\org\slf4j\slf4j-api\1.7.30\slf4j-api-1.7.30.jar;D:\document\eclipse_workspace\local_repository\local_repository\org\springframework\spring-jdbc\5.2.6.RELEASE\spring-jdbc-5.2.6.RELEASE.jar;D:\document\eclipse_workspace\local_repository\local_repository\org\springframework\spring-beans\5.2.6.RELEASE\spring-beans-5.2.6.RELEASE.jar;D:\document\eclipse_workspace\local_repository\local_repository\org\springframework\spring-tx\5.2.6.RELEASE\spring-tx-5.2.6.RELEASE.jar;D:\document\eclipse_workspace\local_repository\local_repository\mysql\mysql-connector-java\8.0.20\mysql-connector-java-8.0.20.jar com.springboot.my_flyway.MyFlywayApplication
  3.   .   ____          _            __ _ _
  4.  /\\ / ___'_ __ _ _(_)_ __  __ _ \ \ \ \
  5. ( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \
  6.  \\/  ___)| |_)| | | | | || (_| |  ) ) ) )
  7.   '  |____| .__|_| |_|_| |_\__, | / / / /
  8.  =========|_|==============|___/=/_/_/_/
  9.  :: Spring Boot ::        (v2.3.0.RELEASE)
  11. 2020-05-24 12:15:55.447  INFO 19064 --- [           main] c.s.my_flyway.MyFlywayApplication        : Starting MyFlywayApplication on LAPTOP-SRJM9GEI with PID 19064 (D:\搜狗高速下载\flyway-springboot-master\flyway-springboot-master\my_flyway\target\classes started by 张琴 in D:\搜狗高速下载\flyway-springboot-master\flyway-springboot-master\my_flyway)
  12. 2020-05-24 12:15:55.449  INFO 19064 --- [           main] c.s.my_flyway.MyFlywayApplication        : No active profile set, falling back to default profiles: default
  13. 2020-05-24 12:15:55.968  INFO 19064 --- [           main] o.f.c.internal.license.VersionPrinter    : Flyway Community Edition 6.4.1 by Redgate
  14. 2020-05-24 12:15:55.975  INFO 19064 --- [           main] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Starting...
  15. 2020-05-24 12:15:56.712  INFO 19064 --- [           main] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Start completed.
  16. 2020-05-24 12:15:56.736  INFO 19064 --- [           main] o.f.c.internal.database.DatabaseFactory  : Database: jdbc:mysql://localhost:3306/flyway (MySQL 8.0)
  17. 2020-05-24 12:15:56.768  INFO 19064 --- [           main] o.f.core.internal.command.DbValidate     : Successfully validated 1 migration (execution time 00:00.012s)
  18. 2020-05-24 12:15:56.783  INFO 19064 --- [           main] o.f.c.i.s.JdbcTableSchemaHistory         : Creating Schema History table `flyway`.`flyway_schema_history` ...
  19. 2020-05-24 12:15:56.863  INFO 19064 --- [           main] o.f.core.internal.command.DbMigrate      : Current version of schema `flyway`: << Empty Schema >>
  20. 2020-05-24 12:15:56.863  WARN 19064 --- [           main] o.f.core.internal.command.DbMigrate      : outOfOrder mode is active. Migration of schema `flyway` may not be reproducible.
  21. 2020-05-24 12:15:56.874  INFO 19064 --- [           main] o.f.core.internal.command.DbMigrate      : Migrating schema `flyway` to version 20200524.09.35 - V1.0 person
  22. 2020-05-24 12:15:56.890  WARN 19064 --- [           main] o.f.c.i.s.DefaultSqlScriptExecutor       : DB: Unknown table 'flyway.person' (SQL State: 42S02 - Error Code: 1051)
  23. 2020-05-24 12:15:56.925  WARN 19064 --- [           main] o.f.c.i.s.DefaultSqlScriptExecutor       : DB: Integer display width is deprecated and will be removed in a future release. (SQL State: HY000 - Error Code: 1681)
  24. 2020-05-24 12:15:56.925  WARN 19064 --- [           main] o.f.c.i.s.DefaultSqlScriptExecutor       : DB: Integer display width is deprecated and will be removed in a future release. (SQL State: HY000 - Error Code: 1681)
  25. 2020-05-24 12:15:56.954  INFO 19064 --- [           main] o.f.core.internal.command.DbMigrate      : Successfully applied 1 migration to schema `flyway` (execution time 00:00.097s)
  26. 2020-05-24 12:15:57.018  INFO 19064 --- [           main] c.s.my_flyway.MyFlywayApplication        : Started MyFlywayApplication in 1.862 seconds (JVM running for 3.103)
  27. 2020-05-24 12:15:57.023  INFO 19064 --- [extShutdownHook] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Shutdown initiated...
  28. 2020-05-24 12:15:57.027  INFO 19064 --- [extShutdownHook] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Shutdown completed.
  30. Process finished with exit code 0

查看数据多了2张表

watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTIwNDUwNDU_size_16_color_FFFFFF_t_70 6

watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTIwNDUwNDU_size_16_color_FFFFFF_t_70 7

发表评论

表情：
评论列表 （有 0 条评论，33人围观）

还没有评论，来说两句吧...

相关阅读