radar_farmagitechs/prisma/seeders/ProvinceSeeder.ts

import prisma from '../../src/prisma/PrismaClient';
import { now } from '../../src/utils/TimeLocal';

const provinces: string[] = [
    "Aceh", "Bali", "Banten", "Bengkulu", "DI Yogyakarta", "DKI Jakarta", "Gorontalo",
    "Jambi", "Jawa Barat", "Jawa Tengah", "Jawa Timur", "Kalimantan Barat",
    "Kalimantan Selatan", "Kalimantan Tengah", "Kalimantan Timur", "Kalimantan Utara",
    "Kepulauan Bangka Belitung", "Kepulauan Riau", "Lampung", "Maluku",
    "Maluku Utara", "Nusa Tenggara Barat", "Nusa Tenggara Timur", "Papua",
    "Papua Barat", "Papua Barat Daya", "Papua Pegunungan", "Papua Selatan",
    "Papua Tengah", "Riau", "Sulawesi Barat", "Sulawesi Selatan", "Sulawesi Tengah",
    "Sulawesi Tenggara", "Sulawesi Utara", "Sumatera Barat", "Sumatera Selatan", "Sumatera Utara"
];

export async function seedProvinces(): Promise<void> {
    for (const name of provinces.sort()) {
        const existing = await prisma.province.findFirst({
            where: { name },
        });

        if (!existing || existing.deletedAt !== null) {
            // Jika tidak ada atau sudah soft-deleted, buat baru
            await prisma.province.create({
                data: {
                    name,
                    createdAt: now().toDate(),
                },
            });
        } else {
            // Jika sudah ada dan aktif, update updatedAt saja (optional)
            await prisma.province.update({
                where: { id: existing.id },
                data: {
                    updatedAt: now().toDate(),
                },
            });
        }
    }

    console.log('✅ Provinces seeded!');
}