21 lines
708 B
TypeScript
21 lines
708 B
TypeScript
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);
|