KalimantanTimurCitySeeder.js 1.2 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849
  1. const prisma = require('../../../src/prisma/PrismaClient.js');
  2. const timeLocal = require('../../../src/utils/TimeLocal.js')
  3. const cityNames = [
  4. 'Kabupaten Berau',
  5. 'Kabupaten Kutai Barat',
  6. 'Kabupaten Kutai Kartanegara',
  7. 'Kabupaten Kutai Timur',
  8. 'Kabupaten Mahakam Ulu',
  9. 'Kabupaten Paser',
  10. 'Kabupaten Penajam Paser Utara',
  11. 'Kota Balikpapan',
  12. 'Kota Bontang',
  13. 'Kota Samarinda'
  14. // 10
  15. ];
  16. exports.seedKalimantanTimurCities = async () => {
  17. const province = await prisma.province.findFirst({
  18. where: { name: 'Kalimantan Timur' },
  19. });
  20. if (!province) {
  21. console.error('❌ Province Kalimantan Timur not found. Seed it first.');
  22. return;
  23. }
  24. for (const name of cityNames) {
  25. await prisma.city.upsert({
  26. where: {
  27. name_province_id: {
  28. name,
  29. province_id: province.id,
  30. },
  31. },
  32. update: {
  33. updatedAt: timeLocal.now().toDate()
  34. },
  35. create: {
  36. name,
  37. province_id: province.id,
  38. createdAt: timeLocal.now().toDate()
  39. },
  40. });
  41. }
  42. console.log('✅ Kalimantan Timur City seeded!.');
  43. };