time 00:00.023s) 2022-05-04 15:11:36.815 INFO 13303 --- [ main] o.f.core.internal.command.DbMigrate...Empty Schema >> 2022-05-04 15:11:36.815 WARN 13303 --- [ main] o.f.core.internal.command.DbMigrate...0 rows affected 2022-05-04 15:11:36.938 INFO 13303 --- [ main] o.f.core.internal.command.DbMigrate...0 rows affected 2022-05-04 15:11:36.977 INFO 13303 --- [ main] o.f.core.internal.command.DbMigrate...+----+------+ 2022-05-04 15:11:37.013 INFO 13303 --- [ main] o.f.core.internal.command.DbMigrate
`flyway_schema_history` INFO 82441 --- [main] o.f.core.internal.command.DbMigrate : Current version...of schema `test`: > INFO 82441 --- [main] o.f.core.internal.command.DbMigrate...table 'test.user' (SQL State: 42S02 - Error Code: 1051) INFO 82441 --- [main] o.f.core.internal.command.DbMigrate...Successfully validated 1 migration (execution time 00:00.031s) INFO 83150 --- [main] o.f.core.internal.command.DbMigrate...: Current version of schema `test`: 1 INFO 83150 --- [main] o.f.core.internal.command.DbMigrate
schema_version` 2018-10-08 21:07:59.987 INFO 16088 --- [ main] o.f.core.internal.command.DbMigrate...Empty Schema >> 2018-10-08 21:07:59.988 INFO 16088 --- [ main] o.f.core.internal.command.DbMigrate...version 1 - Initial 2018-10-08 21:08:00.092 INFO 16088 --- [ main] o.f.core.internal.command.DbMigrate
flyway_schema_history` 2020-05-07 12:41:29.479 INFO 13732 --- [ main] o.f.core.internal.command.DbMigrate...Empty Schema >> 2020-05-07 12:41:29.480 INFO 13732 --- [ main] o.f.core.internal.command.DbMigrate...Error Code: 1051) 2020-05-07 12:41:29.631 INFO 13732 --- [ main] o.f.core.internal.command.DbMigrate...time 00:00.013s) 2020-05-07 15:34:50.043 INFO 41880 --- [ main] o.f.core.internal.command.DbMigrate...schema `test`: 1.0 2020-05-07 15:34:50.043 INFO 41880 --- [ main] o.f.core.internal.command.DbMigrate
with version: 1 2020-12-24 14:38:16.122 INFO 10716 --- [ main] o.f.core.internal.command.DbMigrate...schema `flyway`: 1 2020-12-24 14:38:16.134 INFO 10716 --- [ main] o.f.core.internal.command.DbMigrate...ums admin table 2020-12-24 14:38:16.248 INFO 10716 --- [ main] o.f.core.internal.command.DbMigrate...- Add ums admin 2020-12-24 14:38:16.281 INFO 10716 --- [ main] o.f.core.internal.command.DbMigrate...Ums admin view 2020-12-24 14:38:16.314 INFO 10716 --- [ main] o.f.core.internal.command.DbMigrate
0 rows affected 2022-04-13 07:56:56.292 INFO 86030 --- [ main] o.f.core.internal.command.DbMigrate...Empty Schema >> 2022-04-13 07:56:56.297 INFO 86030 --- [ main] o.f.core.internal.command.DbMigrate...0 rows affected 2022-04-13 07:56:56.333 INFO 86030 --- [ main] o.f.core.internal.command.DbMigrate...0 rows affected 2022-04-13 07:56:56.346 INFO 86030 --- [ main] o.f.core.internal.command.DbMigrate
time 00:00.020s) 2021-01-11 16:58:12.075 INFO 37330 --- [ main] o.f.core.internal.command.DbMigrate...schema `test`: 1 2021-01-11 16:58:12.082 INFO 37330 --- [ main] o.f.core.internal.command.DbMigrate...alter table user" 2021-01-11 16:58:12.113 INFO 37330 --- [ main] o.f.core.internal.command.DbMigrate
time 00:00.021s) 2021-11-15 14:04:00.393 INFO 16840 --- [ main] o.f.core.internal.command.DbMigrate...schema `flyway`: 1 2021-11-15 14:04:00.403 INFO 16840 --- [ main] o.f.core.internal.command.DbMigrate...0 rows affected 2021-11-15 14:04:00.445 INFO 16840 --- [ main] o.f.core.internal.command.DbMigrate
// 打印当前数据库的迁移版本 2019-11-16 13:42:34.702 INFO 59115 --- [ main] o.f.core.internal.command.DbMigrate...// 判断,没有需要迁移的脚本 2019-11-16 13:42:34.702 INFO 59115 --- [ main] o.f.core.internal.command.DbMigrate...// 打印当前数据库的迁移版本 2019-11-16 14:20:26.137 INFO 59615 --- [ main] o.f.core.internal.command.DbMigrate...// 开始迁移到版本 1.0 2019-11-16 14:20:26.138 INFO 59615 --- [ main] o.f.core.internal.command.DbMigrate...// 开始迁移到版本 1.1 2019-11-16 14:45:30.957 INFO 59941 --- [ main] o.f.core.internal.command.DbMigrate
书中给我们推荐了几款用于数据库版本控制的工具,如用来做数据对比的DBdiff、数据迁移的DBmigrate等。但是对于Java开发者来说,还有一个更加好的数据库版本控制和迁移工具,就是Flyway。
- taz is the base for full stack Flask applications Flask-Generic - Flask-DBMigrate
Run: func(cmd *cobra.Command, args []string) { 7 ormDB = ormBbAlias{dbConn()} 8 ormDB.DBMigrate
领取专属 10元无门槛券
手把手带您无忧上云