radar_farmagitechs/prisma/seeders/UserAreaSeeder.ts

import prisma from '../../src/prisma/PrismaClient';

export async function seedUserAreas(): Promise<void> {
    try {
        // Ambil user dengan username 'sales1' dan 'sales2'
        const sales1 = await prisma.userKeycloak.findFirst({ where: { id: '1b50e497-159f-49c2-aa4d-466e72d796f0' } });
        const sales2 = await prisma.userKeycloak.findFirst({ where: { id: '0ec065d8-547c-46e3-9980-df36b9648767' } });

        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 data user_area
        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: any) {
        console.error('❌ Error seeding user area:', error.message);
    }
}

seedUserAreas();


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

// async function seedUserAreas() {
//     try {
//         // Ambil user dengan role 'sales1' dan 'sales2'
//         const sales1 = await prisma.user.findFirst({ where: { username: 'sales1' } });
//         const sales2 = await prisma.user.findFirst({ where: { username: 'sales2' } });

//         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;