[v5] how to load the inverse relationship

[brandonsousa]

if to load USER's PROFILE use preload

User.query()......preload('profile')

how do I load the PROFILE USER

[arthurcvm]

Hi @brandonsousa, send your user and profile model code.

[brandonsousa]

const profiles = await Profile.query().where('status', 'isPublished').preload('users');

error
E_MISSING_MODEL_ATTRIBUTE: "Profile.user" expects "user_id" to exist on "User" model, but is missing

[arthurcvm]

Please send your migrations with relationships definition.

[brandonsousa]

table.integer('user_id')
.notNullable()
.unsigned()
.references('id')
.inTable('users')
.onUpdate('CASCADE');

[arthurcvm]

In Profile model you set this:

@hasOne(() => User, {
    foreignKey: 'id',
    localKey: 'user_id'
  })
  public user: HasOne<typeof User>

and in User model this:

@belongsTo(() => Profile, {
    foreignKey: 'user_id'
  })
  public profile: BelongsTo<typeof Profile>

[brandonsousa]

Thanks, it worked, I was trying to use the same logic that was used in v4