const mysql = require('mysql2/promise');
|
|
async function checkDatabaseActivityTimes() {
|
console.log('🔍 检查数据库中的比赛时间数据...\n');
|
|
const connection = await mysql.createConnection({
|
host: 'localhost',
|
user: 'root',
|
password: 'root',
|
database: 'ryc',
|
port: 3306
|
});
|
|
try {
|
// 查询Activity表中的时间字段
|
const [activities] = await connection.execute(`
|
SELECT
|
id,
|
name,
|
signup_deadline,
|
match_time,
|
created_at,
|
updated_at
|
FROM Activity
|
WHERE id IN (16, 19, 22, 25, 28, 31)
|
ORDER BY id
|
`);
|
|
console.log('📊 数据库中的比赛时间数据:');
|
console.log('─'.repeat(80));
|
|
activities.forEach(activity => {
|
console.log(`🏆 ID: ${activity.id} - ${activity.name}`);
|
console.log(` 📅 signup_deadline: ${activity.signup_deadline}`);
|
console.log(` 🏁 match_time: ${activity.match_time}`);
|
console.log(` 📝 created_at: ${activity.created_at}`);
|
console.log(` 🔄 updated_at: ${activity.updated_at}`);
|
console.log('─'.repeat(40));
|
});
|
|
// 检查是否有其他时间相关的字段
|
const [columns] = await connection.execute(`
|
SHOW COLUMNS FROM Activity LIKE '%time%' OR SHOW COLUMNS FROM Activity LIKE '%date%'
|
`);
|
|
console.log('\n🔍 Activity表中所有时间相关字段:');
|
columns.forEach(col => {
|
console.log(` ${col.Field}: ${col.Type} (${col.Null === 'YES' ? 'nullable' : 'not null'})`);
|
});
|
|
} catch (error) {
|
console.error('❌ 数据库查询失败:', error.message);
|
} finally {
|
await connection.end();
|
}
|
}
|
|
checkDatabaseActivityTimes();
|
