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.test.context.ActiveProfiles;

import jakarta.persistence.EntityManager;
import jakarta.persistence.Query;
import java.util.List;

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

    @Autowired
    private EntityManager entityManager;

    @Test
    public void checkActivityPlayerData() {
        System.out.println("=== 检查 t_activity_player 表数据 ===");
        
        // 查询表结构
        String describeQuery = "DESCRIBE t_activity_player";
        Query query = entityManager.createNativeQuery(describeQuery);
        List<Object[]> columns = query.getResultList();
        
        System.out.println("表结构:");
        for (Object[] column : columns) {
            System.out.println("  " + column[0] + " - " + column[1]);
        }
        
        // 查询数据
        String dataQuery = "SELECT id, player_id, activity_id, region_id, description FROM t_activity_player LIMIT 5";
        Query dataQueryObj = entityManager.createNativeQuery(dataQuery);
        List<Object[]> results = dataQueryObj.getResultList();
        
        System.out.println("\n表数据:");
        System.out.println("ID | Player_ID | Activity_ID | Region_ID | Description");
        System.out.println("---|-----------|-------------|-----------|------------");
        
        for (Object[] row : results) {
            System.out.printf("%s | %s | %s | %s | %s%n", 
                row[0], row[1], row[2], row[3], 
                row[4] != null ? row[4].toString().substring(0, Math.min(20, row[4].toString().length())) + "..." : "null");
        }
        
        // 检查是否有region_id不为空的数据
        String regionQuery = "SELECT COUNT(*) FROM t_activity_player WHERE region_id IS NOT NULL";
        Query regionQueryObj = entityManager.createNativeQuery(regionQuery);
        Object regionCount = regionQueryObj.getSingleResult();
        
        System.out.println("\n有region_id的记录数: " + regionCount);
        
        // 查看region表数据
        String regionDataQuery = "SELECT id, name, full_path FROM t_region LIMIT 5";
        Query regionDataQueryObj = entityManager.createNativeQuery(regionDataQuery);
        List<Object[]> regionResults = regionDataQueryObj.getResultList();
        
        System.out.println("\nt_region 表数据:");
        System.out.println("ID | Name | Full_Path");
        System.out.println("---|------|----------");
        
        for (Object[] row : regionResults) {
            System.out.printf("%s | %s | %s%n", row[0], row[1], row[2]);
        }
    }
}