nestjs - 如何从左连接表中选择数据？

Question

我有两个实体：用户和设置表。

@Entity()
export class Users {
    @PrimaryGeneratedColumn()
    id: number;

    @Column()
    name: string;
    
    @Column()
    settingID: number;
}

@Entity()
export class Settings {
    @PrimaryGeneratedColumn()
    id: number;

    @Column()
    name: string;
}

如何从设置表中选择数据？

        return this.usersRepository
            .createQueryBuilder("users")
            .select(['users.id', 'users.name', 'settings.name'])
            .leftJoinAndSelect(Settings, 'settings', 'users.settingID = settings.id')
            .getMany();

现在我没有从设置表中获取数据，只有用户表。

标签： nestjstypeorm

Answer 1

return this.usersRepository
    .createQueryBuilder("users")
    .select(['users.id', 'users.name'])
    .leftJoinAndSelect('users.settings', 'settings', 'users.settingID = settings.id')
    .addSelect(['settings.name', 'settings.prop1', 'settings.prop2'])
    .getMany();

或者

return this.usersRepository
    .createQueryBuilder("users")
    .leftJoinAndSelect('users.settings', 'settings', 'users.settingID = settings.id')
    .select(['users.id', 'users.name', 'settings.name', 'settings.prop1', 'settings.prop2'])
    .getMany();