DIYogyakartaCitySeeder.ts 2.2 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283
  1. import prisma from '../../../src/prisma/PrismaClient';
  2. import { now } from '../../../src/utils/TimeLocal';
  3. const cityNames: string[] = [
  4. 'Kabupaten Bantul',
  5. 'Kabupaten Gunungkidul',
  6. 'Kabupaten Kulon Progo',
  7. 'Kabupaten Sleman',
  8. 'Kota Yogyakarta'
  9. ];
  10. export async function seedDIYogyakartaCities(): Promise<void> {
  11. const province = await prisma.province.findFirst({
  12. where: { name: 'DI Yogyakarta' },
  13. });
  14. if (!province) {
  15. console.error('❌ Province DI Yogyakarta not found. Seed it first.');
  16. return;
  17. }
  18. for (const name of cityNames) {
  19. await prisma.city.upsert({
  20. where: {
  21. name_province_id: {
  22. name,
  23. province_id: province.id,
  24. },
  25. },
  26. update: { updatedAt: now().toDate() },
  27. create: {
  28. name,
  29. province_id: province.id,
  30. createdAt: now().toDate(),
  31. },
  32. });
  33. }
  34. console.log('✅ DI Yogyakarta City seeded!');
  35. }
  36. // const prisma = require('../../../src/prisma/PrismaClient.js');
  37. // const timeLocal = require('../../../src/utils/TimeLocal.js')
  38. // const cityNames = [
  39. // 'Kabupaten Bantul',
  40. // 'Kabupaten Gunungkidul',
  41. // 'Kabupaten Kulon Progo',
  42. // 'Kabupaten Sleman',
  43. // 'Kota Yogyakarta'
  44. // // 5
  45. // ];
  46. // exports.seedDIYogyakartaCities = async () => {
  47. // const province = await prisma.province.findFirst({
  48. // where: { name: 'DI Yogyakarta' },
  49. // });
  50. // if (!province) {
  51. // console.error('❌ Province DI Yogyakarta not found. Seed it first.');
  52. // return;
  53. // }
  54. // for (const name of cityNames) {
  55. // await prisma.city.upsert({
  56. // where: {
  57. // name_province_id: {
  58. // name,
  59. // province_id: province.id,
  60. // },
  61. // },
  62. // update: { updatedAt: timeLocal.now().toDate() },
  63. // create: {
  64. // name,
  65. // province_id: province.id,
  66. // createdAt: timeLocal.now().toDate()
  67. // },
  68. // });
  69. // }
  70. // console.log('✅ DI Yogyakarta City seeded!.');
  71. // };