package com.zy.asrs.mapper;
|
|
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;
|
|
@Mapper
|
@Repository
|
public interface DeviceDataLogMapper extends BaseMapper<DeviceDataLog> {
|
|
@Delete("delete from wcs_device_data_log where create_time < FROM_UNIXTIME(UNIX_TIMESTAMP() - (24 * 60 * 60))")
|
int clearLog();
|
|
}
|
