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("dev")
public class CheckTableStructureTest {

    @Autowired
    private JdbcTemplate jdbcTemplate;

    @Test
    public void checkActivityPlayerRatingTableStructure() {
        System.out.println("=== 检查 t_activity_player_rating 表结构 ===");
        
        String sql = "DESCRIBE t_activity_player_rating";
        List<Map<String, Object>> columns = jdbcTemplate.queryForList(sql);
        
        for (Map<String, Object> column : columns) {
            System.out.println("字段: " + column.get("Field") + 
                             ", 类型: " + column.get("Type") + 
                             ", 是否为空: " + column.get("Null") + 
                             ", 键: " + column.get("Key") + 
                             ", 默认值: " + column.get("Default"));
        }
        
        // 检查是否存在rating_scheme_id字段
        boolean hasRatingSchemeId = columns.stream()
            .anyMatch(col -> "rating_scheme_id".equals(col.get("Field")));
        
        System.out.println("是否存在rating_scheme_id字段: " + hasRatingSchemeId);
    }
}