Value of column in one to one relation using TypeORM + Postgres is null

Question

I'm trying to set up a simple one-to-one relation between an item and item_name. The entity looks as follows:

@Entity('item')
export class ItemEntity {
  @PrimaryColumn('integer')
  id: number;

  @OneToOne(() => ItemNameEntity)
  @JoinColumn()
  name: ItemNameEntity;

  // ... other props
}

item-name.entity

@Entity('item_name')
export class ItemNameEntity {
  @PrimaryGeneratedColumn()
  id: number;

  @Column()
  en: string;

  @Column()
  fr: string;

  // ... other properties
}

I insert an item using the following payload:

{
      id: 26,
      name: { en: 'English name', fr: 'French name' },
}

It stores the item as expected, and adds a nameId column. The problem is that it does not insert anything into item_name, and thus the nameId column is null.

What am I missing here?

Carlo Corradini · Accepted Answer · 2021-07-31 14:15:10Z

1

From this.

You have to set cascade: true on name relation in ItemEntity:

@Entity('item')
export class ItemEntity {
  @PrimaryColumn('integer')
  id: number;

  @OneToOne(() => ItemNameEntity, { cascade: true })
  @JoinColumn()
  name: ItemNameEntity;

  // ... other props
}

Setting cascade: true on ItemEntity tells TypeORM that if a new itemName is "linked" on an item and the item is saved, the new itemName should also be saved to the database.

Example:

const manager = getManager();
const item: ItemEntity = manager.create(ItemEntity, {
  id: 26,
  name: manager.create(ItemNameEntity, {
    en: 'English name',
    fr: 'French name'
  }),
});
await manager.save(ItemEntity, item);

answered Jul 31, 2021 at 14:15

Carlo Corradini

3,4933 gold badges24 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Tim VN Over a year ago

This pointed me in the direction I want to go in. I'm inserting the item_name entities before saving the parent (item), and it works. The itemId column is filled with the correct id. Thanks for your help!

Collectives™ on Stack Overflow

Value of column in one to one relation using TypeORM + Postgres is null

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related