| | |
|---|
| | | package com.zy.asrs.mapper; |
|---|
| | | |
|---|
| | | import com.zy.asrs.entity.DeviceDataLog; |
|---|
| | | import com.baomidou.mybatisplus.mapper.BaseMapper; |
|---|
| | | import org.apache.ibatis.annotations.Delete; |
|---|
| | | import com.baomidou.mybatisplus.core.mapper.BaseMapper; |
|---|
| | | import org.apache.ibatis.annotations.Mapper; |
|---|
| | | import org.apache.ibatis.annotations.Param; |
|---|
| | | import org.springframework.stereotype.Repository; |
|---|
| | | import java.util.List; |
|---|
| | | |
|---|
| | | @Mapper |
|---|
| | | @Repository |
|---|
| | | public interface DeviceDataLogMapper extends BaseMapper<DeviceDataLog> { |
|---|
| | | |
|---|
| | | @Delete("delete from wcs_device_data_log where create_time < FROM_UNIXTIME(UNIX_TIMESTAMP() - (#{days} * 24 * 60 * 60)) limit 50000") |
|---|
| | | int clearLog(@Param("days") int days); |
|---|
| | | |
|---|
| | | int insertBatch(@Param("list") List<DeviceDataLog> list); |
|---|
| | | |
|---|
| | | } |
|---|
