seed.js

require('dotenv').config();
const mongoose = require('mongoose');
const Event = require('./models/eventModel');
const Booth = require('./models/boothModel');
const User = require('./models/userModel');

const seedDB = async () => {
  await mongoose.connect(process.env.MONGODB_URI, { useNewUrlParser: true, useUnifiedTopology: true });
  console.log('Connected to MongoDB for seeding...');

  // Clear existing data
  await Event.deleteMany({});
  await Booth.deleteMany({});
  console.log('Cleared existing events and booths...');

  // Upsert testing users (admin and normal user)
  await User.deleteMany({ userId: { $in: ['admin', 'admin2', 'testuser'] } });
  const adminUser = new User({
    userId: 'admin',
    password: 'adminpass',
    nickname: 'Admin',
    email: 'admin@example.com',
    role: 'admin'
  });
  const normalUser = new User({
    userId: 'testuser',
    password: 'password',
    nickname: 'Test User',
    email: 'testuser@example.com',
    role: 'user'
  });
  await adminUser.save();
  await normalUser.save();
  console.log('Seeded test users: admin/adminpass and testuser/password');

  // Create a dummy event
  const event = new Event({
    name: 'HK Food Carnival 2025',
    date: new Date('2025-12-20'),
    location: 'AsiaWorld-Expo',
    description: 'The biggest food carnival in Hong Kong!',
    coverImageUrl: 'https://images.unsplash.com/photo-1543353071-10c8ba85a904?q=80&w=1200&auto=format&fit=crop'
  });
  await event.save();
  console.log('Created dummy event...');

  // Create dummy booths
  const booths = [];
  for (let i = 1; i <= 25; i++) {
    booths.push({
      boothId: `A${i}`,
      event: event._id,
      floor: 1,
      priceTier: i % 2 === 0 ? 'premium' : 'economy',
      price: i % 2 === 0 ? 500 : 300,
    });
  }
  for (let i = 1; i <= 15; i++) {
    booths.push({
        boothId: `B${i}`,
        event: event._id,
        floor: 2,
        priceTier: i % 2 === 0 ? 'premium' : 'economy',
        price: i % 2 === 0 ? 600 : 400,
      });
  }


  await Booth.insertMany(booths);
  console.log('Created 40 dummy booths...');

  mongoose.connection.close();
  console.log('Disconnected from MongoDB.');
};

seedDB().catch(err => {
  console.error(err);
  mongoose.connection.close();
});