同步删除调整

xiangpei

2024-12-30 0a9dbf381791653ab21adfeb666faf074d57833a

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
package org.dromara.system.sync;
 
import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
import lombok.extern.slf4j.Slf4j;
import org.dromara.common.oss.core.OssClient;
import org.dromara.common.oss.factory.OssFactory;
import org.dromara.system.domain.SysOss;
import org.dromara.system.domain.properties.Boundary;
import org.dromara.system.domain.vo.SysOssVo;
import org.dromara.system.mapper.SysOssMapper;
import org.dromara.system.uitil.HttpUtils;
import org.springframework.scheduling.annotation.Scheduled;
import org.springframework.stereotype.Component;
 
import java.io.IOException;
import java.time.LocalDateTime;
import java.util.List;
import java.util.Objects;
 
@Slf4j
@Component
public class deleteSync {
 
    private final SysOssMapper baseMapper;
    private final Boundary boundary;
 
    public deleteSync(SysOssMapper baseMapper, Boundary boundary) {
        this.baseMapper = baseMapper;
        this.boundary = boundary;
    }
 
 
    @Scheduled(cron = "0 */10 * * * ?")
    public void remove() throws IOException {
        log.error("同步删除......");
        List<Long> ids = baseMapper.getWillDeleted(LocalDateTime.now().minusDays(1));
 
        if (ids.size() == 0) {
            return;
        }
        OssClient ossClient = OssFactory.instance();
        for (Long ossId : ids) {
            SysOss sysOss = baseMapper.selectById(ossId);
            if (Objects.nonNull(sysOss)) {
                ossClient.delete(sysOss.getFileName());
            }
            HttpUtils.sendDeleteRequest(boundary.getVideo() + "/resource/synchronization/delete",
                String.valueOf(ossId));
        }
    }
 
    /**
     * 每小时删除2天之前的文件信息，因为上面的同步删除并不能保证事务
     *
     * @throws IOException
     */
    @Scheduled(cron = "0 0 * * * ?")
    public void removeOssTable() throws IOException {
        log.error("每小时定时删除超过2天的数据库文件信息......");
        List<Long> ids = baseMapper.getWillDeleted(LocalDateTime.now().minusDays(2));
        if (ids.size() == 0) {
            return;
        }
        // 删除对应文件
        OssClient ossClient = OssFactory.instance();
        for (Long ossId : ids) {
            SysOss sysOss = baseMapper.selectById(ossId);
            if (Objects.nonNull(sysOss)) {
                ossClient.delete(sysOss.getFileName());
            }
        }
        baseMapper.deleteIds(ids);
    }
}