import mysql from 'mysql2/promise';
import dotenv from 'dotenv';

dotenv.config();

async function checkDatabase() {
  try {
    const connection = await mysql.createConnection({
      host: process.env.DB_HOST || 'localhost',
      port: Number(process.env.DB_PORT) || 3306,
      user: process.env.DB_USER || 'root',
      password: process.env.DB_PASSWORD || '',
      database: process.env.DB_NAME || 'employee_performance',
    });
    
    console.log('✓ 已连接到数据库\n');
    
    // 查看所有表
    const [tables] = await connection.query('SHOW TABLES');
    console.log('数据库中的表:');
    console.log(tables);
    
    await connection.end();
    process.exit(0);
  } catch (error: any) {
    console.error('❌ 错误:', error.message);
    process.exit(1);
  }
}

checkDatabase();