const mysql = require('mysql2/promise');
|
|
// 数据库连接配置
|
const dbConfig = {
|
host: '139.155.104.10',
|
port: 3306,
|
user: 'ryc',
|
password: 'KiYap3E8X8RLcM6T',
|
database: 'ryc',
|
connectTimeout: 60000,
|
acquireTimeout: 60000,
|
timeout: 60000
|
};
|
|
async function verifyBirthdayData() {
|
let connection;
|
|
try {
|
console.log('连接数据库...');
|
connection = await mysql.createConnection(dbConfig);
|
|
// 查询最近的报名记录及其关联的用户信息
|
const query = `
|
SELECT
|
ap.id as registration_id,
|
ap.project_name,
|
ap.description as registration_description,
|
p.name as player_name,
|
p.phone as player_phone,
|
p.gender,
|
p.education,
|
p.introduction,
|
u.id as user_id,
|
u.name as user_name,
|
u.phone as user_phone,
|
u.birthday,
|
ap.create_time
|
FROM t_activity_player ap
|
LEFT JOIN t_player p ON ap.player_id = p.id
|
LEFT JOIN t_user u ON p.user_id = u.id
|
WHERE ap.id IN (25, 26)
|
ORDER BY ap.create_time DESC
|
LIMIT 5
|
`;
|
|
console.log('查询最近的报名记录...');
|
const [rows] = await connection.execute(query);
|
|
if (rows.length > 0) {
|
console.log('\n✅ 找到报名记录:');
|
rows.forEach((row, index) => {
|
console.log(`\n--- 记录 ${index + 1} ---`);
|
console.log(`报名ID: ${row.registration_id}`);
|
console.log(`选手姓名: ${row.player_name}`);
|
console.log(`选手电话: ${row.player_phone}`);
|
console.log(`性别: ${row.gender === 0 ? '男' : '女'}`);
|
console.log(`学历: ${row.education}`);
|
console.log(`项目名称: ${row.project_name}`);
|
console.log(`报名描述: ${row.registration_description}`);
|
console.log(`用户ID: ${row.user_id}`);
|
console.log(`用户姓名: ${row.user_name}`);
|
console.log(`用户电话: ${row.user_phone}`);
|
console.log(`生日: ${row.birthday}`);
|
console.log(`报名时间: ${row.create_time}`);
|
|
if (row.birthday) {
|
console.log('✅ 生日字段已正确保存到用户表');
|
} else {
|
console.log('❌ 生日字段未保存到用户表');
|
}
|
});
|
} else {
|
console.log('❌ 未找到报名记录');
|
}
|
|
} catch (error) {
|
console.error('❌ 数据库查询失败:', error.message);
|
} finally {
|
if (connection) {
|
await connection.end();
|
console.log('\n数据库连接已关闭');
|
}
|
}
|
}
|
|
verifyBirthdayData();
|
