Insert with foreign keys with @RelationId() decorator

[sykorax]

Issue type:

[ ] question
[x] bug report
[ ] feature request
[ ] documentation issue

Database system/driver:

[ ] cordova
[ ] mongodb
[ ] mssql
[ ] mysql / mariadb
[ ] oracle
[ ] postgres
[ ] cockroachdb
[x] sqlite
[ ] sqljs
[ ] react-native
[ ] expo

TypeORM version:

[x] latest
[ ] @next
[x] 0.2.15 (or put your version here)

Steps to reproduce or a small repository showing the problem:

I'm trying to insert an enity with entity manager by setting foreign relation ids instead of specify the related object directly, like:

... manager.insert(UserTenantRole, {tenantEntityId: entity.id, roleId: role.id});

However turning logging on shown that NULL values are being inserted by the manager. It seems manager absolutely ignores the given values in case of setting such foreign keys (decorated with @RelationId).

My entity:

import { Entity, JoinColumn, ManyToOne, PrimaryGeneratedColumn, RelationId } from 'typeorm';
import { Role } from './role.entity';
import { TenantUserEntity } from './tenant-user-entity.entity';

@Entity({name: 'users_roles'})
export class UserTenantRole {

  @PrimaryGeneratedColumn('uuid')
  id: string;

  @ManyToOne(type => TenantUserEntity, entity => entity.tenantRoles, {nullable: false})
  @JoinColumn({name: 'entity_id'})
  tenantEntity: Promise<TenantUserEntity> | TenantUserEntity;
  @RelationId((userTenantRole: UserTenantRole) => userTenantRole.tenantEntity)
  tenantEntityId: string;

  @ManyToOne(type => Role, role => role.userTenantRoles, {eager: true, nullable: false})
  @JoinColumn({name: 'role_id'})
  role: Role;
  @RelationId((userTenantRole: UserTenantRole) => userTenantRole.role)
  roleId: string;

}

Using legacy relation passing is fine:

... manager.insert(UserTenantRole, {tenantEntity: entity, role: role});

[pbirsinger]

Also would like to know solution for this, as I don't want to have to load whole related object every time I need to insert ..

[lilacdev]

Need solution too. I don't understand why we would need to do 2 requests as we already know relation.

[lisaah]

This sounds like #1795

[udayrajMT]

For those looking for a solution here's a working example -

let product = new Product();
product.category = { id: 1 }; // or new Category().id = 1 or assigned via constructor
product.storageUrl = req.body.storageUrl;

let result = await this.repository.persist(product);

ref: #447 (comment)

[bombillazo]

Any update on this?