SubTableRunner.java
1.44 KB
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
package vion.cron.monitor;
import lombok.RequiredArgsConstructor;
import lombok.extern.slf4j.Slf4j;
import org.dromara.hutool.core.date.TimeUtil;
import org.postgresql.util.PGobject;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.scheduling.annotation.Scheduled;
import org.springframework.stereotype.Component;
import java.time.LocalDate;
import java.time.LocalDateTime;
import java.time.LocalTime;
import java.util.ArrayList;
import java.util.List;
import java.util.Map;
/**
* m_event_record 定时删除分表
*/
@Component
@RequiredArgsConstructor
@Slf4j
public class SubTableRunner {
private final JdbcTemplate jdbcTemplate;
@Scheduled(cron = "50 0 0 * * ?")
public void deleteEventRecord() {
log.info("删除m_event_record分表");
var partList = jdbcTemplate.queryForList("select * FROM pathman_partition_list");
List<String> tableNames = new ArrayList<>();
for (Map<String, Object> map : partList) {
var startTime = TimeUtil.parseByISO((String) map.get("range_min"));
if (startTime.isBefore(LocalDateTime.of(LocalDate.now(), LocalTime.MIN).minusDays(30))) {
var o = (PGobject) map.get("partition");
tableNames.add(o.getValue());
}
}
for (String tableName : tableNames) {
jdbcTemplate.execute("drop table " + tableName);
}
log.info("删除m_event_record分表完成");
}
}