_delete_test_plans.js 623 B

123456789101112131415161718
  1. const { PrismaClient } = require('@prisma/client');
  2. const prisma = new PrismaClient();
  3. async function main() {
  4. const result = await prisma.subscriptionPlan.deleteMany({
  5. where: {
  6. name: { in: ['测试套餐', '测试版', 'Test Plan', 'TestPackage'] }
  7. }
  8. });
  9. console.log('Deleted count:', result.count);
  10. const remaining = await prisma.subscriptionPlan.findMany({
  11. orderBy: { sortOrder: 'asc' }
  12. });
  13. console.log('Remaining plans:', remaining.map(p => ({ id: p.id, name: p.name, level: p.level, priceMonthly: p.priceMonthly })));
  14. }
  15. main().catch(console.error).finally(() => prisma.$disconnect());