import 'dotenv/config';
import { PrismaPg } from '@prisma/adapter-pg';
import { PrismaClient } from '../src/generated/prisma/client';
import { CDCGPSF_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 page of ['meeting_requests', 'meeting_calendar']) {
      const items = CDCGPSF_TRANSLATIONS.filter(item => item.page === page);
      console.log(page, await seedTranslationItems(prisma, 'cdcgpsf', items));
    }
    // Correct the initial English placeholder only; leave custom Admin wording intact.
    await prisma.translation.updateMany({
      where: {
        module: 'cdcgpsf', page: 'meeting_calendar',
        translationKey: 'cdc_ui.venue', khmerText: 'Venue',
      },
      data: { khmerText: 'ទីកន្លែង' },
    });
  } finally {
    await prisma.$disconnect();
  }
}

main().catch(error => {
  console.error('Could not seed CDC-GPSF meeting translations.', error);
  process.exitCode = 1;
});