radar_farmagitechs/prisma/seeders/UserAreaSeeder.js

const prisma = require('../../src/prisma/PrismaClient.js');

async function seedUserAreas() {
    try {
        // Ambil user dengan role 'sales1' dan 'sales2'
        const sales1 = await prisma.userKeycloak.findFirst({ where: { id: '26042443-e53a-44b1-ab52-12985e8bdad1' } });
        const sales2 = await prisma.userKeycloak.findFirst({ where: { id: '49349b07-a46c-4686-a964-8bbcedbf63f2' } });

        if (!sales1 || !sales2) {
            throw new Error('User sales1 or sales2 not found');
        }

        // Ambil provinsi
        const jawaTengah = await prisma.province.findFirst({ where: { name: 'Jawa Tengah' } });
        const diy = await prisma.province.findFirst({ where: { name: 'DI Yogyakarta' } });

        if (!jawaTengah || !diy) {
            throw new Error('Province Jawa Tengah or DI Yogyakarta not found');
        }

        // Buat user_areas
        await prisma.userArea.createMany({
            data: [
                {
                    user_id: sales1.id,
                    province_id: jawaTengah.id,
                },
                {
                    user_id: sales2.id,
                    province_id: diy.id,
                },
            ],
        });

        console.log('✅ User area seeded');
    } catch (error) {
        console.error('❌ Error seeding user area:', error);
    }
}

module.exports = seedUserAreas;

if (require.main === module) {
    seedUserAreas()
        .then(() => {
            console.log('🌱 Seeder selesai!');
            process.exit(0);
        })
        .catch((err) => {
            console.error('❌ Error saat seeding:', err);
            process.exit(1);
        });
}