package com.rongyichuang;

import org.junit.jupiter.api.Test;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.test.context.ActiveProfiles;

import java.util.List;
import java.util.Map;

@SpringBootTest
@ActiveProfiles("test")
public class CheckActivityJudgeTableTest {

    @Autowired
    private JdbcTemplate jdbcTemplate;

    @Test
    public void checkActivityJudgeTableStructure() {
        System.out.println("=== 检查t_activity_judge表结构 ===");
        
        try {
            // 查看表结构
            String describeTableSql = "DESCRIBE t_activity_judge";
            List<Map<String, Object>> columns = jdbcTemplate.queryForList(describeTableSql);
            
            System.out.println("t_activity_judge表字段:");
            for (Map<String, Object> column : columns) {
                System.out.println("  字段名: " + column.get("Field") + 
                                 ", 类型: " + column.get("Type") + 
                                 ", 是否为空: " + column.get("Null") + 
                                 ", 默认值: " + column.get("Default"));
            }
            
            // 查看现有的活动-评委关联记录
            String selectRecordsSql = "SELECT * FROM t_activity_judge LIMIT 3";
            List<Map<String, Object>> records = jdbcTemplate.queryForList(selectRecordsSql);
            
            System.out.println("\n现有活动-评委关联记录示例:");
            for (Map<String, Object> record : records) {
                System.out.println("  " + record);
            }
            
        } catch (Exception e) {
            System.out.println("检查表结构时发生异常: " + e.getMessage());
            e.printStackTrace();
        }
    }
}