javascript - How to get all the data from tables using TypeORM? - Stack Overflow

admin管理员组

文章数量:1395744

I'm building a Nest.js app with PostgresQL using TypeORM, I have entity User and entity Role, which are connected to each other with Many-to-Many relation. User has an array of roles, where each role assigned to this user is stored, but when I try to get all the users, that roles array doesn't show. Using Sequelize ORM i could get all the data from users using that code - {include: {all: true}}, example:

const users = await this.usersRepository.find({include: {all: true}})

But in TypeORM it doesn't work. I tried to find it in TypeORM docs, but I didn't find an answer. Sorry for my english, i hope you understood me.

I'm building a Nest.js app with PostgresQL using TypeORM, I have entity User and entity Role, which are connected to each other with Many-to-Many relation. User has an array of roles, where each role assigned to this user is stored, but when I try to get all the users, that roles array doesn't show. Using Sequelize ORM i could get all the data from users using that code - {include: {all: true}}, example:

const users = await this.usersRepository.find({include: {all: true}})

But in TypeORM it doesn't work. I tried to find it in TypeORM docs, but I didn't find an answer. Sorry for my english, i hope you understood me.

• javascript
• node.js
• postgresql
• nestjs
• typeorm

Share Improve this question Follow edited Aug 5, 2022 at 8:56 nevermind1727 asked Aug 5, 2022 at 8:54 nevermind1727nevermind1727 2311 gold badge11 silver badge44 bronze badges

Add a ment  | 

1 Answer 1

Sorted by: Reset to default 3

It seems TypeORM wait for a list of relations you want to populate : https://orkhan.gitbook.io/typeorm/docs/relational-query-builder

In your case, it could look like :

const users = await this.usersRepository.find({relations: {roles: true}})

本文标签： javascriptHow to get all the data from tables using TypeORMStack Overflow