DKIJakartaCitySeeder.ts 2.3 KB

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