Help mocking TypeORM's QueryBuilder.

[JoaoVictorDaijo]

I'm trying to test a method which executes a query using TypeORM's createQueryBuilder. I got the usual Nest setup on my provider, I inject my repository and create a queryBuilder using it.

This is how I'm trying to mock the queryBuilder and it's internal methods:

  let instrumento2Utils: Instrumento2Utils;
  let amostraRep: Mocked<Repository<AmostraAluno>>;

  beforeAll(async () => {
    const { unit, unitRef } = await TestBed.solitary(Instrumento2Utils)
      .mock(String(getRepositoryToken(AmostraAluno)))
      .impl((stubFn) => ({
        createQueryBuilder: stubFn().mockReturnValue({
          select: stubFn().mockReturnThis(),
          leftJoin: stubFn().mockReturnThis(),
          where: stubFn().mockReturnThis(),
          andWhere: stubFn().mockReturnThis(),
          getRawOne: stubFn().mockResolvedValue({
            idAmostras: ['amostraId1', 'amostraId2'],
          }),
        }),
      }))
      .compile();

    instrumento2Utils = unit;
    amostraRep = unitRef.get(String(getRepositoryToken(AmostraAluno)));
  });

When I run this simple it case:

    it('should return amostraIds based on distrito', async () => {
      const filter: RelatorioAprendizagensFilterDto = {
        ano: 2022,
        periodo: PeriodoAcompanhamento.PRIMEIRA_COLETA_ACOMPANHAMENTO_I,
        distrito: ['distrito1'],
      };

      const result = await instrumento2Utils.getAmostrasIds(filter);

      expect(result).toEqual(new Map([['ALL', ['amostraId1', 'amostraId2']]]));
    });

I get this error: TypeError: Cannot read properties of undefined (reading 'leftJoin')