增加数据库自动更新开关

648540858

2023-02-01 166272ad11ae283e179c288ef4ae1b306ed9a589

增加数据库自动更新开关

 src/main/java/com/genersoft/iot/vmp/conf/FlywayConfig.java

@@ -21,8 +21,15 @@
    @Autowired
    private DataSource dataSource;

    @Autowired
    private UserSetting userSetting;

    @PostConstruct
    public void migrate() {
        if (!userSetting.getSyncDb()) {
            logger.info("[数据库自动升级] 已关闭");
            return;
        }
        Flyway flyway = Flyway.configure()
                .dataSource(dataSource)
                .locations("db/migration")//sql文件名称规则："V20210625.17.30__V1.0.sql"

 src/main/java/com/genersoft/iot/vmp/conf/UserSetting.java

@@ -46,6 +46,7 @@
    private Boolean syncChannelOnDeviceOnline = Boolean.FALSE;

    private Boolean sipLog = Boolean.FALSE;
    private Boolean syncDb = Boolean.TRUE;

    private String serverId = "000000";

@@ -216,4 +217,12 @@
    public void setSipLog(Boolean sipLog) {
        this.sipLog = sipLog;
    }

    public Boolean getSyncDb() {
        return syncDb;
    }

    public void setSyncDb(Boolean syncDb) {
        this.syncDb = syncDb;
    }
}

 src/main/resources/all-application.yml

@@ -199,6 +199,8 @@
    sip-use-source-ip-as-remote-address: false
    # 是否开启sip日志
    sip-log: true
    # 自动数据库升级，保证表结构完整
    sync-db: true

# 关闭在线文档（生产环境建议关闭）
springdoc: