Using seed for Nest.Js and Prisma Mysql

01-seed-test.seed.ts

import { PrismaClient } from '@prisma/client';

export default async function seed(prisma: PrismaClient) {
  await prisma.user.createMany({ data: [] });
}

schema.prisma

model Seed {
  id        Int      @id @default(autoincrement())
  name      String
  createdAt DateTime @default(now())
}

seed.ts

import { PrismaClient } from '@prisma/client';
import * as fs from 'fs';
import * as path from 'path';

const prisma = new PrismaClient();

async function seed() {
  const seedFilesPath = path.join(__dirname + '/seeds');

  const seedFiles = await fs
    .readdirSync(seedFilesPath)
    .filter((file: string) => file.endsWith('.seed.ts'));

  for (const seedFile of seedFiles) {
    console.log('----------------seed-start------------');
    console.log(`Seeding ${seedFile}`);
    const seedDatabase = await prisma.seed.findFirst({
      where: {
        name: seedFile,
      },
    });

    if (seedDatabase) {
      console.log(`seed ${seedFile} already exists`);
      console.log('----------------seed-end-------------');
      continue;
    }

    await prisma.$transaction(async (prisma) => {
      console.log(`Seeding ${seedFile} begin transaction`);

      const seedFilePath = path.join(seedFilesPath, seedFile);
      // eslint-disable-next-line @typescript-eslint/no-var-requires
      const { default: seedFunction } = require(seedFilePath);
      await seedFunction(prisma);
      await prisma.seed.create({
        data: {
          name: seedFile,
        },
      });
      console.log(`Seeding ${seedFile} completed`);
    });

    console.log('----------------seed-end--------------');
  }

  console.log('All Seeding completed successfully');
}

seed()
  .catch((error) => {
    console.error('Seeding error:', error);
  })
  .finally(async () => {
    await prisma.$disconnect();
  });

The seed.tsfile will be located in the prisma/seed.ts directory
The seeds files will be located in the prisma/seeds/*.seed.ts directory

Run seeds

npx prisma db seed