From 75d0daa4f8dc2010ec92f35cac08a19d240ca45d Mon Sep 17 00:00:00 2001 From: ynhfasrs <ynhfasrs@qq.com> Date: 星期五, 27 六月 2025 14:23:37 +0800 Subject: [PATCH] # --- src/main/java/com/zy/asrs/mapper/DeviceDataLogMapper.java | 4 ++++ 1 files changed, 4 insertions(+), 0 deletions(-) diff --git a/src/main/java/com/zy/asrs/mapper/DeviceDataLogMapper.java b/src/main/java/com/zy/asrs/mapper/DeviceDataLogMapper.java index 286d049..af8cd73 100644 --- a/src/main/java/com/zy/asrs/mapper/DeviceDataLogMapper.java +++ b/src/main/java/com/zy/asrs/mapper/DeviceDataLogMapper.java @@ -2,6 +2,7 @@ import com.zy.asrs.entity.DeviceDataLog; import com.baomidou.mybatisplus.mapper.BaseMapper; +import org.apache.ibatis.annotations.Delete; import org.apache.ibatis.annotations.Mapper; import org.springframework.stereotype.Repository; @@ -9,4 +10,7 @@ @Repository public interface DeviceDataLogMapper extends BaseMapper<DeviceDataLog> { + @Delete("delete from wcs_device_data_log where create_time < DATEADD(HOUR, -72, GETDATE())") + int clearLog(); + } -- Gitblit v1.9.1