javascript - NestJS/TypeORM：无法读取未定义的属性“createQueryBuilder”

问题描述

在邮递员处调用“localhost:3000/contacts”（带或不带参数）返回此错误，我不知道为什么。我的后端连接到 PostgreSQL 数据库。

TypeError：无法读取 ContactsRepository.Repository.createQueryBuilder 中未定义的属性“createQueryBuilder”（...\Documents\Visual Studio Code Projects\funds-backend-nestjs\node_modules\typeorm\repository\Repository.js:17:29）在 ContactsRepository .getContacts (...\Documents\Visual Studio Code Projects\funds-backend-nestjs\dist\contacts\contacts.repository.js:17:34) 在 ContactsService.getContacts (...\Documents\Visual Studio Code Projects\ fund-backend-nestjs\dist\contacts\contacts.service.js:24:39) 在 ContactsController.getContacts (...\Documents\Visual Studio Code Projects\funds-backend-nestjs\dist\contacts\contacts.controller. js:25:37) at ...\Documents\Visual Studio Code Projects\funds-backend-nestjs\node_modules@nestjs\core\router\router-execution-context.js:38:29 at processTicksAndRejections (internal/process/ task_queues.js:93:5) 在 async ...\Documents\Visual Studio Code Projects\funds-backend-nestjs\node_modules@nestjs\core\router\router-execution-context.js:46:28 at async ...\Documents\Visual Studio代码项目\funds-backend-nestjs\node_modules@nestjs\core\router\router-proxy.js:9:17

我的代码如下所示：

@EntityRepository(Contact)
export class ContactsRepository extends Repository<Contact> {

  async getContacts(filterDto: GetContactsFilterDto): Promise<Contact[]> {
    const { name, search } = filterDto;
    // const query = this.createQueryBuilder('contacts');
    const query = await this.createQueryBuilder()
      .select('contacts')
      .from(Contact, 'contacts');

    if (name) {
      query.andWhere('contacts.name = :name', { name });
    }

    if (search) {
      query.andWhere(
        '(contacts.email LIKE :search OR contacts.telephone LIKE :search)',
        { search: `%${search}%` },
      );
    }

    const contacts = await query.getMany();
    return contacts;
  }

import { BaseEntity, Column, Entity, PrimaryGeneratedColumn } from 'typeorm';

@Entity({ name: 'contacts' })
export class Contact extends BaseEntity {
  @PrimaryGeneratedColumn('uuid')
  id: string;

  @Column()
  email: string;

  @Column()
  html_de: string;

  @Column()
  html_en: string;

  @Column()
  name: string;

  @Column()
  telephone: string;
}

export class ContactsController {
  constructor(private contactsService: ContactsService) {}

  @Get()
  getContacts(
    @Query(ValidationPipe) filterDto: GetContactsFilterDto,
  ): Promise<ContactDto[]> {
    return this.contactsService.getContacts(filterDto);
  }

@Injectable()
export class ContactsService {
  constructor(
    @InjectRepository(ContactsRepository)
    private contactsRepository: ContactsRepository,
  ) {}

  async getContacts(filterDto: GetContactsFilterDto): Promise<Contact[]> {
    return this.contactsRepository.getContacts(filterDto);
  }

import { Module } from '@nestjs/common';
import { TypeOrmModule } from '@nestjs/typeorm';

import { ContactsController } from './contacts.controller';
import { ContactsRepository } from './contacts.repository';
import { ContactsService } from './contacts.service';

@Module({
  controllers: [ContactsController],
  imports: [TypeOrmModule.forFeature([ContactsRepository])],
  providers: [ContactsRepository, ContactsService],
  exports: [ContactsRepository, ContactsService],
})
export class ContactsModule {}

有人知道我该如何解决这个问题吗？问候

标签： javascriptnode.jstypescriptnestjstypeorm

ContactsRepository只应在 the 中使用，TypeOrmModule.forFeature()而不应添加到providersorexports数组中。当它被添加到这里时，注入令牌ContactsRepository不再指向正确的实例，Nest 创建了类，但没有正确扩展它，Repository因为该代码全部由 TypeORM 管理

javascript - NestJS/TypeORM：无法读取未定义的属性“createQueryBuilder”

问题描述

解决方案

推荐阅读