修改员工和评委的设置

lrj

8 天以前 6d519474e44855682043d3c40db2c86a6822caca

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
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]);
        }
    }
}