const axios = require('axios');
|
|
// 测试Player phone字段修改后的功能
|
async function testPlayerPhoneFix() {
|
const baseURL = 'http://localhost:8080/api';
|
|
console.log('=== 测试Player phone字段修改后的功能 ===\n');
|
|
try {
|
// 1. 测试GraphQL查询 - 获取选手信息
|
console.log('1. 测试GraphQL查询选手信息...');
|
const graphqlQuery = {
|
query: `
|
query {
|
players(page: 1, size: 5) {
|
content {
|
id
|
name
|
phone
|
userInfo {
|
id
|
phone
|
}
|
}
|
totalElements
|
}
|
}
|
`
|
};
|
|
const graphqlResponse = await axios.post(`${baseURL}/graphql`, graphqlQuery, {
|
headers: {
|
'Content-Type': 'application/json'
|
}
|
});
|
|
if (graphqlResponse.data.data && graphqlResponse.data.data.players) {
|
const players = graphqlResponse.data.data.players.content;
|
console.log(`✓ 成功获取 ${players.length} 个选手信息`);
|
|
// 检查phone字段的数据一致性
|
players.forEach((player, index) => {
|
console.log(` 选手${index + 1}: ${player.name}`);
|
console.log(` Player.phone (已废弃): ${player.phone || 'null'}`);
|
console.log(` User.phone (正确来源): ${player.userInfo?.phone || 'null'}`);
|
|
// 检查数据一致性
|
if (player.userInfo?.phone) {
|
console.log(` ✓ 从User实体成功获取phone: ${player.userInfo.phone}`);
|
} else {
|
console.log(` ⚠ User实体中没有phone数据`);
|
}
|
console.log('');
|
});
|
} else {
|
console.log('✗ GraphQL查询失败或返回空数据');
|
console.log('响应:', JSON.stringify(graphqlResponse.data, null, 2));
|
}
|
|
} catch (error) {
|
console.error('测试过程中发生错误:');
|
if (error.response) {
|
console.error('状态码:', error.response.status);
|
console.error('响应数据:', JSON.stringify(error.response.data, null, 2));
|
} else {
|
console.error('错误信息:', error.message);
|
}
|
}
|
|
try {
|
// 2. 测试活动选手列表API
|
console.log('\n2. 测试活动选手列表API...');
|
const listResponse = await axios.get(`${baseURL}/activity-players/applications`, {
|
params: {
|
page: 1,
|
size: 5
|
}
|
});
|
|
if (listResponse.data && listResponse.data.content) {
|
const applications = listResponse.data.content;
|
console.log(`✓ 成功获取 ${applications.length} 个选手申请记录`);
|
|
applications.forEach((app, index) => {
|
console.log(` 申请${index + 1}: ${app.playerName}`);
|
console.log(` 手机号: ${app.phone || 'null'}`);
|
console.log(` 项目: ${app.projectName || 'null'}`);
|
console.log('');
|
});
|
} else {
|
console.log('✗ 活动选手列表API返回空数据');
|
}
|
|
} catch (error) {
|
console.error('\n活动选手列表API测试失败:');
|
if (error.response) {
|
console.error('状态码:', error.response.status);
|
console.error('响应数据:', JSON.stringify(error.response.data, null, 2));
|
} else {
|
console.error('错误信息:', error.message);
|
}
|
}
|
|
console.log('\n=== 测试完成 ===');
|
console.log('\n总结:');
|
console.log('1. Player实体的phone字段已标记为@Deprecated');
|
console.log('2. 所有SQL查询已修改为从User表获取phone');
|
console.log('3. DTO类已修改为从User实体获取phone');
|
console.log('4. GraphQL schema中Player.phone已标记为废弃');
|
console.log('5. 建议前端逐步迁移到使用userInfo.phone字段');
|
}
|
|
// 运行测试
|
testPlayerPhoneFix();
|
