How to preload relationships on after hook

[babojamo]

Hi Everyone,

I want to ask if this is a bug or if the behavior is just like this.
Assuming I have a user with a post and every post has comments.

I want to get the list of comments with the "creator" of the post.

My query is like this:

const comments = await Comment.query().preload('post', (postQuery) => {
      postQuery.preload('user')
    });

but when getting the result, the user under the post is undefined

Result

console.log(comments[0].post) // has value

console.log(comments[0].post.user) // undefined

after disabling the "preloadRelation" in the "Comment" model then that's time I can get the user through the comments model

    @beforeFetch()
    public static preloadRelation(model) {
      // model.preload('post')
    }

Re-run the query

const comment = await Comment.query().preload('post', (postQuery) => {
      postQuery.preload('user')
    });

Result

console.log(comments[0].post) // has value

console.log(comments[0].post.user) // has value

Conclusion
I assume the preload will not run twice on the same relationship

These are the models

User Model

class User {
    @hasMany(() => Post, { foreignKey: 'user_id' })
    public posts: HasMany<typeof Post>

    ...
}

Post Model

class Post {
    @hasMany(() => Comment, { foreignKey: 'post_id' })
    public comments: HasMany<typeof Comment>

    @belongsTo(() => User, { foreignKey: 'user_id' })
    public user: BelongsTo<typeof User>;

    ...
}

Comment Model

class Comment {
    @belongsTo(() => Post, { foreignKey: 'post_id' })
    public post: BelongsTo<typeof Post>;

    @beforeFetch()
    public static preloadRelation(model) {
      model.preload('post')
    }

    ...
}

[WeyIin]

class User {
    @hasMany(() => Post, { 
         foreignKey: 'user_id' ,
         onQuery: (query) => {
	    if (!query.isRelatedSubQuery) {
               query.preload('comments')
            }
         }
     })
    public posts: HasMany<typeof Post>

    ...
}

using it like:

user.preload('post')

will load comments of a posts too.

I have something like this set up, currently can't check the code but it should work.