lami-shequn/backend/scripts/add-riskevent-discoveredat.ts

/**
 * 为 RiskEvent 表添加 discoveredAt(Date) 字段
 *
 * 用法: cd backend && npx tsx scripts/add-riskevent-discoveredat.ts
 */
import 'dotenv/config';
import Parse from '../src/db/parse-client.js';

async function main(): Promise<void> {
  console.log('=== 为 RiskEvent 添加 discoveredAt 字段 ===');
  console.log(`Server: ${Parse.serverURL}`);
  console.log(`App ID: ${Parse.applicationId}\n`);

  try {
    const n = await new Parse.Query('_User').count({ useMasterKey: true });
    console.log(`✅ Parse 连接正常 (_User: ${n} 条)\n`);
  } catch (err: any) {
    console.error(`❌ Parse 连接失败: ${err.message}`);
    process.exit(1);
  }

  const schema = new Parse.Schema('RiskEvent');
  try {
    await schema.addField('discoveredAt', 'Date');
    await schema.update({ useMasterKey: true });
    console.log('+ RiskEvent.discoveredAt (Date) 字段已添加');
  } catch (err: any) {
    if (err.message?.includes('already')) {
      console.log('~ RiskEvent.discoveredAt 字段已存在，无需添加');
    } else {
      console.warn(`⚠ RiskEvent.discoveredAt 添加失败: ${err.message}`);
    }
  }

  console.log('\n=== 完成 ===');
}

main().catch((err) => {
  console.error('失败:', err.message);
  process.exit(1);
});