import 'dotenv/config';
import { PrismaPg } from '@prisma/adapter-pg';
import { PrismaClient } from '../src/generated/prisma/client';
import {
  CDC_TRANSLATIONS,
  CEFP_TRANSLATIONS,
  seedTranslationItems,
} from './seeds/translations';

async function main() {
  const connectionString = process.env.DATABASE_URL;
  if (!connectionString) throw new Error('DATABASE_URL is missing');
  const prisma = new PrismaClient({ adapter: new PrismaPg({ connectionString }) });
  try {
    for (const [module, page, seeds] of [
      ['cdc', 'cdc_issue_matrix', CDC_TRANSLATIONS],
      ['cefp', 'cefp_issue_matrix', CEFP_TRANSLATIONS],
    ] as const) {
      const items = seeds.filter((item) => item.page === page);
      console.log(await seedTranslationItems(prisma, module, items));
    }
  } finally {
    await prisma.$disconnect();
  }
}

main().catch((error) => {
  console.error('CDC/CEFP issue matrix seed failed:', error);
  process.exitCode = 1;
});