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();
        }
    }
}