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();