multi-platform-media-manage/server/temp_query.cjs

const mysql = require('mysql2/promise');

async function main() {
  const conn = await mysql.createConnection({
    host: '8.136.223.156',
    port: 6630,
    user: 'media_manager',
    password: 'media_manager',
    database: 'media_manager'
  });
  
  // 查询发布结果
  const [results] = await conn.query(`
    SELECT *
    FROM publish_results
    WHERE task_id = 61
    LIMIT 3
  `);
  console.log('\n=== Task 61 Results ===');
  console.log(JSON.stringify(results, null, 2));
  
  // 查询账号信息
  const [accounts] = await conn.query(`
    SELECT 
      id,
      platform,
      account_name,
      account_id
    FROM platform_accounts
    WHERE id = 24
  `);
  console.log('\n=== Account 24 ===');
  console.log(JSON.stringify(accounts, null, 2));
  
  console.log(JSON.stringify(rows, null, 2));
  await conn.end();
}

main().catch(console.error);