Missing Primary Id in relation's data

[Ilyes512]

Is there a reason why the output of fetching a table with a many-to-many relation (or any other form of relation) lacks the relation's primary id? For instance if one has a user wish can have multiple roles and you try and fetch a specific user with all it roles. The roles data does not contain the Primary Id of the specific role. Is there a way to still get those Primary Ids in the data?

[pleerock]

it should contain. Provide a code example how your entity look like and how do you query them

[Ilyes512]

So for instance. If I want to fetch a specific user with all role id's it will not return the RoleUser.RoleId.

This is the current result:

{
    "items": [
        {
            "userId": 1,
            "name": "John",
            "email": "john@domain.com",
            "password": "1234",
            "maxApiKeys": 1234,
            "rememberToken": "",
            "isActive": true,
            "createdAt": "2017-03-02T08:44:07.000Z",
            "updatedAt": "2017-03-02T08:44:09.000Z",
            "userRoles": [
                {
                    "roleUserId": 1
                },
                {
                    "roleUserId": 2
                }
            ]
        }
    ],
    "pagination": {
        "page": null,
        "count": 1,
        "total": 0
    }
}

The result I want to achieve is:

{
    "items": [
        {
            "userId": 1,
            "name": "John",
            "email": "john@domain.com",
            "password": "1234",
            "maxApiKeys": 1234,
            "rememberToken": "",
            "isActive": true,
            "createdAt": "2017-03-02T08:44:07.000Z",
            "updatedAt": "2017-03-02T08:44:09.000Z",
            "userRoles": [
                {
                    "roleId": 3
                },
                {
                    "roleId": 4
                }
            ]
        }
    ],
    "pagination": {
        "page": null,
        "count": 1,
        "total": 0
    }
}

The entities I use are:

@Entity()
export class RoleUser {

    @PrimaryGeneratedColumn()
    public roleUserId: number;

    @ManyToOne(type => Role, role => role.roleId, {onDelete: 'CASCADE'})
    public roleId: number;

    @ManyToOne(type => User, user => user.userId, {onDelete: 'CASCADE'})
    public userId: number;
}

@Entity()
export class User {

    @PrimaryGeneratedColumn()
    public userId: number;

    @Column({type: 'string'})
    public name: string;

    @OneToMany(type => RoleUser, roleUser => roleUser.userId)
    public userRoles: RoleUser[];
}

@Entity()
export class Role {

    @PrimaryGeneratedColumn()
    public roleId: number;

    @Column({type: 'string', length: 100})
    public displayName: string;

    @OneToMany(type => RoleUser, roleUser => roleUser.roleId)
    public roleUsers: RoleUser[];
}

This is how I fetch the data:

let userRepository = this.connection.getRepository(User);

return userRepository
    .createQueryBuilder('user')
    .setFirstResult(offset)
    .setMaxResults(range.limit)
    .leftJoinAndSelect('user.userRoles', 'roleUser')
    //.addSelect(['roleUser.roleId', 'roleUser.userId'])
    .getManyAndCount()
    .then(([items, count]) => {
        debug('items', JSON.stringify(items));

        return {
            items,
            ranges,
            count
        } as CollectionResponseData<any>;
    })
    .catch(e => {
        debug('query error', e);
    });

[pleerock]

You misunderstood the concept that relations are objects, not ids. This code is not valid:

    @ManyToOne(type => Role, role => role.roleId, {onDelete: 'CASCADE'})
    public roleId: number;

What it should be:

    @ManyToOne(type => Role, role => role.roleId, {onDelete: 'CASCADE'})
    public role: Role;

And now, if you want to have a role object you should join it too, and you'll have your role object with role id inside.

Alternatively, if you don't want to load role you can do this hack:

    @ManyToOne(type => Role, role => role.roleId, {onDelete: 'CASCADE'})
         @JoinColumn({ name: "roleId" })
    public role: Role;

    @Column("int", { nullable: true })
    public roleId: number;

[Ilyes512]

Nice. We got it working! Thanks for your (very) fast response! 👍

[maxcan]

@pleerock - that doesn't seem like a "hack" at all but a reasonable way to set up a table where you could run a query and just get the ID without needing a join on the OneToMany table. In fact, I was wondering exactly how to do that this morning. Do you think we should add it to the docs?

[pleerock]

@maxcan for what you are talking there is a feature called @RelationId, which allows to selection only id/ids of the relation. And thats what we are working on right now.

[maxcan]

That's perfect. Really love this library.

…

On Mon, Mar 13, 2017 at 02:34 Umed Khudoiberdiev ***@***.***> wrote: @maxcan <https://github.com/maxcan> for what you are talking there is a feature called @RelationId, which allows to selection only id/ids of the relation. And thats what we are working on right now. — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub <#324 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AAneTIs1-_5HEqszXmNyH8-rbds04Joaks5rlQ2ogaJpZM4MQt3i> .