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

async function run() {
  const [rows] = await pool.query<any[]>(
    'SELECT perf_id, ai_total_score, problems, suggestions FROM ai_result ORDER BY ai_id DESC LIMIT 2'
  );
  for (const row of rows) {
    console.log('=== perfId:', row.perf_id, '===');
    console.log('ai_total_score:', row.ai_total_score);
    console.log('problems raw:', row.problems);
    console.log('suggestions raw:', row.suggestions);
    console.log('problems parsed:', JSON.parse(row.problems || '[]'));
    console.log('suggestions parsed:', JSON.parse(row.suggestions || '[]'));
  }
  await pool.end();
}

run().catch(console.error);