// backend/prisma/seed.ts
import { PrismaClient } from '@prisma/client';
import * as bcrypt from 'bcrypt';
import { config } from 'dotenv';
import path from 'path';

// Load environment variables from the correct path
const envPath = path.join(__dirname, '..', '.env');
console.log('Loading .env from:', envPath);
config({ path: envPath });

// Verify DATABASE_URL is loaded
if (!process.env.DATABASE_URL) {
  console.error('❌ DATABASE_URL is not set in environment');
  console.log('Current directory:', process.cwd());
  console.log('.env path:', envPath);
  process.exit(1);
}

console.log('✅ DATABASE_URL found:', process.env.DATABASE_URL.substring(0, 30) + '...');

const prisma = new PrismaClient();

async function main() {
  console.log('🌱 Starting seeding...');

  // Test the connection
  await prisma.$connect();
  console.log('✅ Database connected successfully');

  // Create organization types
  const clinicType = await prisma.organizationType.upsert({
    where: { name: 'CLINIC' },
    update: {},
    create: { name: 'CLINIC' },
  });
  console.log('✅ Created clinic type');

  const labType = await prisma.organizationType.upsert({
    where: { name: 'LAB' },
    update: {},
    create: { name: 'LAB' },
  });
  console.log('✅ Created lab type');

  // Create plans
  const plans = [
    { name: 'trial', maxUsers: 5, price: 0, features: {} },
    { name: 'Small', maxUsers: 5, price: 79, features: {} },
    { name: 'Medium', maxUsers: 10, price: 129, features: {} },
    { name: 'Large', maxUsers: 15, price: 179, features: {} },
    { name: 'Enterprise', maxUsers: 999999, price: 299, features: {} },
  ];

  for (const plan of plans) {
    await prisma.plan.upsert({
      where: { name: plan.name },
      update: {},
      create: plan,
    });
  }
  console.log('✅ Created plans');

  // Create features and permissions
  const features = [
    {
      name: 'Patient Management',
      permissions: ['VIEW_PATIENTS', 'CREATE_PATIENTS', 'EDIT_PATIENTS', 'DELETE_PATIENTS']
    },
    {
      name: 'Order Management',
      permissions: ['VIEW_ORDERS', 'CREATE_ORDERS', 'EDIT_ORDERS', 'DELETE_ORDERS', 'TRACK_ORDERS']
    },
    {
      name: 'Case Management',
      permissions: ['VIEW_CASES', 'CREATE_CASES', 'EDIT_CASES', 'DELETE_CASES']
    },
    {
      name: 'Reports',
      permissions: ['VIEW_REPORTS', 'EXPORT_REPORTS']
    },
    {
      name: 'Team Management',
      permissions: ['INVITE_USERS', 'REMOVE_USERS', 'MANAGE_PERMISSIONS']
    },
    {
      name: 'Billing',
      permissions: ['VIEW_INVOICES', 'CREATE_INVOICES', 'MANAGE_PAYMENTS']
    }
  ];

  for (const feature of features) {
    const createdFeature = await prisma.feature.upsert({
      where: { name: feature.name },
      update: {},
      create: { name: feature.name },
    });

    for (const permissionName of feature.permissions) {
      await prisma.permission.upsert({
        where: { name: permissionName },
        update: {},
        create: {
          name: permissionName,
          featureId: createdFeature.id,
        },
      });
    }
  }
  console.log('✅ Created features and permissions');

  console.log('🌱 Seeding completed successfully!'); ``
}

main()
  .catch((e) => {
    console.error('❌ Seeding failed:', e);
    process.exit(1);
  })
  .finally(async () => {
    await prisma.$disconnect();
  });