Cannot persist an entity with a 1-to-1 reference to another entity

[thiagomini]

Cannot persist an entity with a 1-to-1 reference to another entity

[B4nan]

No you can't. I told you to swap those, so where you have mappedBy you will have inversedBy and vice versa.

Btw I thought the inversedBy was supposed to be used in the owning side.

Yes, and you had it on the inverse instead. The owning side is where you have the database column.

FYI the inverserBy is actually optional, the owning side does not need to point anywhere, only the inverse side needs to specify the mappedBy option.

[thiagomini]

Additional info below:

Profile Schema

import { BigIntType, EntitySchema } from '@mikro-orm/core';
import { Profile } from './profile.entity';
import { User } from './user.entity';

export const profileSchema = new EntitySchema<Profile>({
  class: Profile,
  tableName: 'profile',
  forceConstructor: true,
  properties: {
    id: {
      type: BigIntType,
      primary: true,
      autoincrement: true,
    },
    user: {
      entity: () => User,
      reference: '1:1',
      mappedBy: 'profile',
      ref: true,
    },
    imageUrl: {
      type: String,
    },
  },
});

User Schema

import { BigIntType, EntitySchema } from '@mikro-orm/core';
import { User } from './user.entity';
import { Address } from './address.entity';
import { Profile } from './profile.entity';

export const userSchema = new EntitySchema<User>({
  class: User,
  tableName: 'user',
  forceConstructor: true,
  properties: {
    id: {
      type: BigIntType,
      primary: true,
      autoincrement: true,
    },
    firstName: {
      type: 'string',
    },
    lastName: {
      type: 'string',
    },
    email: {
      type: 'string',
    },
    addresses: {
      reference: '1:m',
      entity: () => Address,
      mappedBy: 'user',
    },
    profile: {
      reference: '1:1',
      entity: () => Profile,
      inversedBy: 'user',
      nullable: true,
    },
    createdAt: {
      type: 'timestamp',
    },
    updatedAt: {
      type: 'timestamp',
    },
  },
});

⚠️ Apparently, the user's id is not being populated. I have no idea why 🤔

[B4nan]

because it is inverse side, as such it does not represent any database column. your schema is not in sync with entity definition apparently, if you expect such column to exist. swap inversedBy with mappedBy (in both entities)

[thiagomini]

Hey Martin, thanks for the speedy reply! But can we define mappedBy in both entities? I actually get this error when I do so:

MetadataError: Both User.profile and Profile.user are defined as owning sides, use 'mappedBy' on one of them

Btw I thought the inversedBy was supposed to be used in the owning side. What is it's purpose instead?

[thiagomini]

Got it! Thanks, Martin!