const mysql = require('mysql2/promise');
|
|
async function checkActivityDates() {
|
let connection;
|
|
try {
|
// 创建数据库连接
|
connection = await mysql.createConnection({
|
host: '139.155.104.10',
|
port: 3306,
|
user: 'ryc',
|
password: 'KiYap3E8X8RLcM6T',
|
database: 'ryc',
|
connectTimeout: 60000,
|
acquireTimeout: 60000,
|
timeout: 60000
|
});
|
|
console.log('数据库连接成功！');
|
|
// 查询活动数据
|
const [rows] = await connection.execute(`
|
SELECT
|
id,
|
name,
|
signup_deadline,
|
match_time,
|
address,
|
player_max,
|
state,
|
create_time,
|
update_time
|
FROM t_activity
|
WHERE state = 1
|
ORDER BY id DESC
|
LIMIT 10
|
`);
|
|
console.log('\n=== 活动数据检查 ===');
|
console.log(`找到 ${rows.length} 条活动记录：\n`);
|
|
rows.forEach((row, index) => {
|
console.log(`${index + 1}. 活动ID: ${row.id}`);
|
console.log(` 名称: ${row.name}`);
|
console.log(` 报名截止时间: ${row.signup_deadline || '未设置'}`);
|
console.log(` 比赛时间: ${row.match_time || '未设置'}`);
|
console.log(` 地址: ${row.address || '未设置'}`);
|
console.log(` 最大人数: ${row.player_max || '未限制'}`);
|
console.log(` 状态: ${row.state}`);
|
console.log(` 创建时间: ${row.create_time}`);
|
console.log(` 更新时间: ${row.update_time}`);
|
console.log(' ---');
|
});
|
|
// 统计时间字段为空的记录
|
const [emptyDates] = await connection.execute(`
|
SELECT
|
COUNT(*) as total,
|
SUM(CASE WHEN signup_deadline IS NULL THEN 1 ELSE 0 END) as empty_signup_deadline,
|
SUM(CASE WHEN match_time IS NULL THEN 1 ELSE 0 END) as empty_match_time
|
FROM t_activity
|
WHERE state = 1
|
`);
|
|
console.log('\n=== 时间字段统计 ===');
|
console.log(`总活动数: ${emptyDates[0].total}`);
|
console.log(`报名截止时间为空: ${emptyDates[0].empty_signup_deadline}`);
|
console.log(`比赛时间为空: ${emptyDates[0].empty_match_time}`);
|
|
// 检查最近的活动详情
|
const [latestActivity] = await connection.execute(`
|
SELECT * FROM t_activity WHERE state = 1 ORDER BY id DESC LIMIT 1
|
`);
|
|
if (latestActivity.length > 0) {
|
console.log('\n=== 最新活动详情 ===');
|
const activity = latestActivity[0];
|
console.log('完整活动信息:');
|
console.log(JSON.stringify(activity, null, 2));
|
}
|
|
} catch (error) {
|
console.error('数据库查询失败:', error.message);
|
console.error('错误详情:', error);
|
} finally {
|
if (connection) {
|
await connection.end();
|
console.log('\n数据库连接已关闭');
|
}
|
}
|
}
|
|
// 运行查询
|
checkActivityDates();
|
