kongzy
2023-09-22 3124f3a5b7f45d043b228829b6b3a2e541b31574
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
package com.nms.swspkmas_standalone.config;
 
import lombok.extern.slf4j.Slf4j;
import org.flywaydb.core.Flyway;
import org.flywaydb.core.api.FlywayException;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.context.annotation.Configuration;
 
import javax.annotation.PostConstruct;
import javax.sql.DataSource;
 
@Configuration
@Slf4j
public class FlywayConfig {
    @Autowired
    private DataSource dataSource;
 
    @PostConstruct
    public void migrate() {
        Flyway flyway = Flyway.configure()
                .dataSource(dataSource)
                .locations("classpath:db/migration")
                .encoding("UTF-8")
                .outOfOrder(true)
                .cleanDisabled(true)
                .cleanOnValidationError(false)
                .sqlMigrationPrefix("V")
                .sqlMigrationSeparator("_")
                .sqlMigrationSuffixes(".sql")
                .validateOnMigrate(true)
                .baselineOnMigrate(true)
                .load();
        flyway.migrate();
//        try {
//            flyway.migrate();
//        } catch (FlywayException e) {
//            log.error("Flyway配置第一次加载出错", e);
//            try {
//                flyway.repair();//生成版本记录表
//                log.info("Flyway配置修复成功");
//                flyway.migrate();
//                log.info("Flyway配置重新加载成功");
//            } catch (Exception e1) {
//                log.error("Flyway配置第二次加载出错", e1);
//                throw e1;
//            }
//        }
    }
}