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