javascript - NestJs: How to access database in entity listeners? - Stack Overflow

admin管理员组

文章数量:1429559

I've got a @BeforeInsert() listener in my Post entity. The listener is supposed to create a unique slug for the slug column before insertion.

For example:

export class Post extends BaseEntity {
    @PrimaryGeneratedColumn()
    id: number

    @Column()
    title: string

    @Column()
    slug: string

    @BeforeInsert()
    private updateSlug() {
        this.slug = slugify(this.title)
        // I will need to access the database to check whether the same slug has existsed already or not. 
        // How do I access the database in this listener method?
    }
}

Since the slug column is supposed to be unique, I will have to check in the database to know whether the same slug already exists. If the slug already exists, I will then need to append a number behind the slug, like hello-word-1.

However, to do so, I will need to access the Post repository of the entity in the Post entity class before I can access the database. But I don't see how I can inject the repository into my Post entity class to access the database for this purpose.

How should I approach this problem?

I've got a @BeforeInsert() listener in my Post entity. The listener is supposed to create a unique slug for the slug column before insertion.

For example:

export class Post extends BaseEntity {
    @PrimaryGeneratedColumn()
    id: number

    @Column()
    title: string

    @Column()
    slug: string

    @BeforeInsert()
    private updateSlug() {
        this.slug = slugify(this.title)
        // I will need to access the database to check whether the same slug has existsed already or not. 
        // How do I access the database in this listener method?
    }
}

Since the slug column is supposed to be unique, I will have to check in the database to know whether the same slug already exists. If the slug already exists, I will then need to append a number behind the slug, like hello-word-1.

However, to do so, I will need to access the Post repository of the entity in the Post entity class before I can access the database. But I don't see how I can inject the repository into my Post entity class to access the database for this purpose.

How should I approach this problem?

• javascript
• node.js
• typescript
• nestjs
• typeorm

Share Improve this question Follow edited Apr 15, 2019 at 8:04 Carven asked Apr 15, 2019 at 7:54 CarvenCarven 15.7k3030 gold badges124124 silver badges185185 bronze badges 1

• You should not access the repository from your entity, but you can provide an API in a custom repository to do what you need as you can get the entity manager from there. Then you just call the repository from your codebase when you need. Checking the slug before insert is too late to my mind, this is something you should do beforehand. – zenbeni Commented Apr 19, 2019 at 16:07

Add a ment  | 

1 Answer 1

Sorted by: Reset to default 4

As far as I know it's not possible to use dependency injection in typeorm entities, since they are not instantiated by nest. You can however use an EntitySubscriber instead which can inject dependencies. See the solution from this Github issue:

import { Injectable } from '@nestjs/mon';
import { InjectConnection, InjectRepository } from '@nestjs/typeorm';
import { Connection, EntitySubscriberInterface, InsertEvent, Repository } from 'typeorm';
import { Post } from '../models';

@Injectable()
export class PostSubscriber implements EntitySubscriberInterface {

  constructor(
    @InjectConnection() readonly connection: Connection,
    // Inject your repository here
    @InjectRepository(Photo) private readonly postRepository: Repository<Post>,
  ) {
    connection.subscribers.push(this);
  }

  listenTo() {
    return Post;
  }

  beforeInsert(event: InsertEvent<Post>) {
    // called before insert
  };

}

本文标签： javascriptNestJs How to access database in entity listenersStack Overflow