修改yml

lxw

2022-10-26 6eabba8dec8c7d7e6f858f2c6dbccd30a9a775ca

修改yml

 res.db

Binary files differ

 src/main/java/com/whyc/pojo/BattgroupInfo.java

@@ -9,6 +9,7 @@
import io.swagger.annotations.ApiModelProperty;
import lombok.*;
import lombok.experimental.Accessors;
import org.springframework.format.annotation.DateTimeFormat;

import java.io.Serializable;
import java.util.ArrayList;

 src/main/java/com/whyc/service/StationInfoService.java

@@ -291,7 +291,9 @@
                return new Response().set(1,false,"文件不存在");
            }else{
                //3.删除fileid对应的数据(stationId,fileId)
                dataMapper.deleteDataAndInfo(stationId,fileId);
                //dataMapper.deleteDataAndInfo(stationId,fileId);
                //3根据(stationId,fileId)删除groupinfo和groupdata数据
                deleteDataAndInfo(stationId,fileId);

                //4.删除fileid对应的参数
                paramMapper.deleteParamByFileId(fileId);
@@ -302,7 +304,26 @@
            }
        }
    }

    //3根据(stationId,fileId)删除groupinfo和groupdata数据
    public void deleteDataAndInfo(int stationId,int fileId){
        //先查询出对应的电池组id然后删除
        QueryWrapper wrapper=new QueryWrapper();
        wrapper.eq("station_id",stationId);
        wrapper.eq("file_id",fileId);
        List<BattgroupInfo> list=groupInfoMapper.selectList(wrapper);
        if(list!=null&&list.size()>0){
            for (BattgroupInfo ginfo:list) {
                UpdateWrapper dataWrapper=new UpdateWrapper();
                dataWrapper.eq("battGroup_id",ginfo.getBattgroupId());
                dataMapper.delete(dataWrapper);
            }
        }
        //再删除groupinfo
        UpdateWrapper infoWrapper=new UpdateWrapper();
        infoWrapper.eq("station_id",stationId);
        infoWrapper.eq("file_id",fileId);
        groupInfoMapper.delete(infoWrapper);
    }
    public StationInfo getByFileId(String fileId) {
        return mapper.getByFileId(fileId);
    }

 src/main/resources/config/application-lite-dev.yml

@@ -18,7 +18,7 @@
  datasource:
    driver-class-name: org.sqlite.JDBC
#    url: jdbc:sqlite:C:\Users\29550\Downloads\sqlite-tools-win32-x86-3390400\res.db
    url: jdbc:sqlite:res.db
    url: jdbc:sqlite:res.db?date_string_format=yyyy-MM-dd HH:mm:ss
    initialPoolSize: 2
    minPoolSize: 2
    maxPoolSize: 500

 src/main/resources/config/application-lite-prod.yml

@@ -17,7 +17,7 @@
  datasource:
    type: com.alibaba.druid.pool.DruidDataSource
    driver-class-name: org.sqlite.JDBC
    url: jdbc:sqlite:res.db
    url: jdbc:sqlite:res.db?date_string_format=yyyy-MM-dd HH:mm:ss
    initialPoolSize: 2
    minPoolSize: 2
    maxPoolSize: 500