Flyway自学之路-03（几个可用命令行操作Flyway）

我会带着你远行 2023-02-12 02:24 17阅读 0赞

# 1.命令行: migrate #

将架构迁移到最新版本。如果Flyway不存在，它将自动创建架构历史记录表。

[![migrate][]][migrate 1]

## Usage ##

> flyway [options] migrate

![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][]

# 2.命令行: clean #

删除已配置模式中的所有对象（表，视图，过程，触发器等）。  
架构将按照`schemas`属性指定的顺序进行清理。

[![clean][]][clean 1]

## Usage ##

> flyway [options] clean

![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][]

# 3.命令行：info #

打印有关所有迁移的详细信息和状态信息。

[![信息][format_png]][format_png 1]

## 用法 ##

> flyway [options] info

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTIwNDUwNDU_size_16_color_FFFFFF_t_70 4][]

# 4.命令行：validate #

针对已解决的迁移（在文件系统或类路径上）验证已应用的迁移，以检测可能会导致无法准确创建模式的意外更改。

如果验证失败

*  发现迁移名称，类型或校验和方面的差异
 *  已应用不再在本地解析的版本
 *  已解决尚未应用的版本

[![验证][format_png 2]][format_png 2 1]

## 用法 ##

> flyway [options] validate

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTIwNDUwNDU_size_16_color_FFFFFF_t_70 5][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTIwNDUwNDU_size_16_color_FFFFFF_t_70 6][]

# 5.命令行：baseline #

为现有数据库提供基准，不包括直到包括的所有迁移`baselineVersion`。

[![基准线][format_png 3]][format_png 3 1]

## 用法 ##

> flyway [options] baseline

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTIwNDUwNDU_size_16_color_FFFFFF_t_70 7][]

# 6.命令行：repair #

修复Flyway模式历史记录表。这将执行以下操作：

*  在没有DDL事务的数据库上删除所有失败的迁移  
    （仍然必须手动清理留下的用户对象）
 *  将可用迁移的校验和，描述和类型与可用迁移重新对齐

[![修理][format_png 4]][format_png 4 1]

## 用法 ##

> flyway [options] repair

![20200524120347418.png][]

[migrate]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9mbHl3YXlkYi5vcmcvYXNzZXRzL2JhbHNhbWlxL2NvbW1hbmQtbWlncmF0ZS5wbmc?x-oss-process=image/format,png
[migrate 1]: https://flywaydb.org/documentation/command/migrate
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTIwNDUwNDU_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/2020052411485392.png?x-oss-process=image/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]: https://img-blog.csdnimg.cn/20200524115101873.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTIwNDUwNDU=,size_16,color_FFFFFF,t_70
[clean]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9mbHl3YXlkYi5vcmcvYXNzZXRzL2JhbHNhbWlxL2NvbW1hbmQtY2xlYW4ucG5n?x-oss-process=image/format,png
[clean 1]: https://flywaydb.org/documentation/command/clean
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTIwNDUwNDU_size_16_color_FFFFFF_t_70 2]: https://img-blog.csdnimg.cn/20200524115148872.png?x-oss-process=image/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 3]: https://img-blog.csdnimg.cn/20200524115230579.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTIwNDUwNDU=,size_16,color_FFFFFF,t_70
[format_png]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9mbHl3YXlkYi5vcmcvYXNzZXRzL2JhbHNhbWlxL2NvbW1hbmQtaW5mby5wbmc?x-oss-process=image/format,png
[format_png 1]: https://flywaydb.org/documentation/command/info
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTIwNDUwNDU_size_16_color_FFFFFF_t_70 4]: https://img-blog.csdnimg.cn/20200524115403495.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTIwNDUwNDU=,size_16,color_FFFFFF,t_70
[format_png 2]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9mbHl3YXlkYi5vcmcvYXNzZXRzL2JhbHNhbWlxL2NvbW1hbmQtdmFsaWRhdGUucG5n?x-oss-process=image/format,png
[format_png 2 1]: https://flywaydb.org/documentation/command/validate
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTIwNDUwNDU_size_16_color_FFFFFF_t_70 5]: https://img-blog.csdnimg.cn/20200524115739309.png?x-oss-process=image/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 6]: https://img-blog.csdnimg.cn/20200524115827849.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTIwNDUwNDU=,size_16,color_FFFFFF,t_70
[format_png 3]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9mbHl3YXlkYi5vcmcvYXNzZXRzL2JhbHNhbWlxL2NvbW1hbmQtYmFzZWxpbmUucG5n?x-oss-process=image/format,png
[format_png 3 1]: https://flywaydb.org/documentation/command/baseline
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTIwNDUwNDU_size_16_color_FFFFFF_t_70 7]: https://img-blog.csdnimg.cn/20200524120203862.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTIwNDUwNDU=,size_16,color_FFFFFF,t_70
[format_png 4]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9mbHl3YXlkYi5vcmcvYXNzZXRzL2JhbHNhbWlxL2NvbW1hbmQtcmVwYWlyLnBuZw?x-oss-process=image/format,png
[format_png 4 1]: https://flywaydb.org/documentation/command/repair
[20200524120347418.png]: https://img-blog.csdnimg.cn/20200524120347418.png