import * as dotenv from 'dotenv';
dotenv.config();
import pool from './src/config/database';
import * as AIResultDAO from './src/dao/AIResultDAO';

async function run() {
  // 直接查原始数据
  const [rows] = await pool.query<any[]>('SELECT * FROM ai_result WHERE perf_id = 9');
  console.log('原始数据库行:', rows[0]);
  console.log('problems 类型:', typeof rows[0]?.problems);
  console.log('suggestions 类型:', typeof rows[0]?.suggestions);

  // 通过 DAO 查
  const result = await AIResultDAO.findByPerfId(9);
  console.log('\nDAO 返回:');
  console.log('  aiTotalScore:', result?.aiTotalScore, typeof result?.aiTotalScore);
  console.log('  aiProblems:', result?.aiProblems);
  console.log('  aiSuggestions:', result?.aiSuggestions);

  await pool.end();
}

run().catch(console.error);