neim/neim-biz/src/main/java/com/jiayue/biz/mapper/ProphaseWeatherDataOrgMapper.java

package com.jiayue.biz.mapper;

import com.baomidou.dynamic.datasource.annotation.DS;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.jiayue.biz.domain.ProphaseWeatherData;
import com.jiayue.biz.domain.ProphaseWeatherDataOrg;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;

@DS("tdengine")
public interface ProphaseWeatherDataOrgMapper extends BaseMapper<ProphaseWeatherDataOrg> {

    @Insert("<script>" +
            "insert into weather_org_${equipmentId} USING prophase_weather_data_org TAGS(${equipmentId}) values " +
            "<foreach collection='prophaseWeatherDataList' item='p' separator=','> " +
            "(#{p.ts},#{p.tInst},#{p.tMax},#{p.tMin},#{p.tAve},#{p.tSta},#{p.rhInst},#{p.rhMax},#{p.rhMin},#{p.rhAve},#{p.rhSta},#{p.paInst},#{p.paMax},#{p.paMin},#{p.paAve},#{p.paSta},#{p.airDensity}) " +
            "</foreach> " +
            "</script>")
    int insertSplice(@Param("prophaseWeatherDataList") List<ProphaseWeatherData> prophaseWeatherDataList, @Param("equipmentId") String equipmentId);

}