nestjs - 如何在连接 queryBuilder 中使用 entiy queryBuilder？

Question

我有两个实体：tableUnion、标签。我为他们创建了两个 queryBuilders。如何在连接查询生成器中使用它？我想让它们保持独立的功能。

    const entityManager = getManager();
    const connection = getConnection();

    const tableUn = this.tableUnion.createQueryBuilder('tu')
        .select('id')
        .addSelect('description', 'name');

    const tableTg = this.tags.createQueryBuilder('tg')
        .select(['id', 'name']);

    return await connection
        .createQueryBuilder()
        .select('*')
        .from(
            tableUn => tableUn,
            'tu'
        )
        .addFrom(
            tableTg => tableTg,
            'tg'
        ).getRawMany();

标签： nestjstypeorm

Answer 1

    return await createQueryBuilder(null, 'u')
        .select('*')
        .from(
            qb => tableUn(qb).from(TableUnion, 'tu'),
            'tu'
        )
        .addFrom(
            qb => tableTg(qb).from(TagsEntity, 'tg'),
            'tg'
        ).getRawMany();