Suggestion: create tests for Prisma (alternative to TypeORM) about testing-nestjs HOT 7 CLOSED

import request from 'supertest';
import { Test } from '@nestjs/testing';
import { INestApplication, ValidationPipe } from '@nestjs/common';
import { PrismaService } from '../src/prisma.service';
import { ProductsModule } from '../src/products/products.module';

describe('Products', () => {
  let app: INestApplication;
  let prisma: PrismaService;

  beforeAll(async () => {
    const moduleRef = await Test.createTestingModule({
      imports: [ProductsModule, PrismaService],
    }).compile();

    app = moduleRef.createNestApplication();
    prisma = moduleRef.get<PrismaService>(PrismaService);

    app.useGlobalPipes(new ValidationPipe({ whitelist: true }));

    await app.init();
  });

  afterAll(async () => {
    await app.close();
  });

  afterEach(async () => {
    // TODO: use transactions and transaction rollback once prisma supports it
    await prisma.truncate();
    await prisma.resetSequences();
  });

  it(`/products (GET)`, async () => {
    await prisma.product.createMany({
      data: products,
    });

    await request(app.getHttpServer())
      .get('/products')
      .expect(200)
      .expect((res) => {
        expect(res.body).toStrictEqual(
          expect.arrayContaining([expect.objectContaining(productShape)]),
        );
      });
  });

  it(`/products/:uuid (GET)`, async () => {
    const storedProduct = await prisma.product.create({
      data: product,
    });

    await request(app.getHttpServer())
      .get(`/products/${storedProduct.id}`)
      .expect(200)
      .expect((res) => {
        expect(res.body).toStrictEqual(expect.objectContaining(productShape));
      });
  });
});

  async truncate() {
    for (const { tablename } of await this
      .$queryRaw`SELECT tablename FROM pg_tables WHERE schemaname='public'`) {
      if (tablename !== '_prisma_migrations') {
        // eslint-disable-next-line no-await-in-loop
        await this.$queryRaw(`TRUNCATE TABLE "public"."${tablename}" CASCADE;`);
      }
    }
  }