package com.rongyichuang.common.api;
|
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.jdbc.core.JdbcTemplate;
|
import org.springframework.web.bind.annotation.PostMapping;
|
import org.springframework.web.bind.annotation.RequestMapping;
|
import org.springframework.web.bind.annotation.RestController;
|
|
@RestController
|
@RequestMapping("/cleanup")
|
public class DataCleanupController {
|
|
@Autowired
|
private JdbcTemplate jdbcTemplate;
|
|
@PostMapping("/clean-media-data")
|
public String cleanMediaData() {
|
try {
|
String sql = "DELETE FROM t_media WHERE target_id NOT REGEXP '^[0-9]+$'";
|
int deletedRows = jdbcTemplate.update(sql);
|
return "已删除 " + deletedRows + " 条错误数据";
|
} catch (Exception e) {
|
return "清理失败: " + e.getMessage();
|
}
|
}
|
}
|
