Not getting relationship or child object inside the parent object in response.

[Vishwas-verma]

I want my User model to include Todo model but I am not getting it inside user model.
Here is my-
User model

import {DateTime} from 'luxon'
import {BaseModel, beforeSave, column, hasMany, HasMany} from '@ioc:Adonis/Lucid/Orm'
import {GenderEnum} from "App/Enums/gender.enum";
import Hash from "@ioc:Adonis/Core/Hash";
import Todo from "App/Models/Todo";

export default class User extends BaseModel {
  @column({isPrimary: true})
  public id: number

  @column()
  public first_name: string

  @column()
  public last_name: string | null

  @column()
  public email: string

  @column({ serializeAs: null })
  public password: string


  @column()
  public phone_number: number

  @column()
  public gender: GenderEnum

  public async getFullName(){
    return `${this.first_name} ${this.last_name}`
  }

  @column.dateTime({serializeAs: null}) // serializeAs is used to hide field in response
  public deletedAt: DateTime

  @column.dateTime({autoCreate: true})
  public createdAt: DateTime

  @column.dateTime({autoCreate: true, autoUpdate: true})
  public updatedAt: DateTime

  @hasMany(() => Todo)
  public todos: HasMany<typeof Todo>

  @beforeSave()
  public static async hashPassword(user: User) {
    if (user.$dirty.password) {
      user.password = await Hash.make(user.password)
    }
  }
}

Todo Model

import {DateTime} from 'luxon'
import {BaseModel, belongsTo, BelongsTo, column} from '@ioc:Adonis/Lucid/Orm'
import User from "App/Models/User";

export default class Todo extends BaseModel {
  @column({isPrimary: true})
  public id: number

  @column()
  public title: string

  @column()
  public is_created: string

  @column()
  public created_by: number

  @column.dateTime({autoCreate: true})
  public createdAt: DateTime

  @column.dateTime({autoCreate: true, autoUpdate: true})
  public updatedAt: DateTime

  @column.dateTime({serializeAs: null})
  public deletedAt: DateTime

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

Here is my controller code:

  public async indexUsers({request,response}:HttpContextContract){
    const filters=request.qs() ; // For input from query params
    const userQuery = User.query().with('todos', builder => {
      builder.select('created_by', 'title'); // user_id is needed
    })
    if(filters.gender) userQuery.where('gender', filters.gender)

    const users = await userQuery
    console.log(users.map(u=>u.todos)); // Getting undefined Here
    console.log(users.map(u=>u.$getRelated('todos') as Todo[])); // Getting undefined Here Too
    return response.json({
      user: users
    })
  }

Request-Response

Why I am not getting todos inside user object in response.

[mastermunj]

Try

@hasMany(() => Todo, {
  foreignKey: 'created_by',
})
public todos: HasMany<typeof Todo>

const userQuery = User.query().preload('todos');

Some overall feedback:

• Use camelCase property names as adonis beautifully handles column mapping from it.
• Do not use asnyc where not needed. Check getFullName method.
• Make use of paginate to avoid sending all the data in response if not needed.

[Vishwas-verma]

Thanks @mastermunj that worked as charm for me but there are instances like

  public async login({request, auth, response}: HttpContextContract) {
    const user = await User.findBy('email',request.body().email);
    if(!user) {
      throw new UserNotFoundException();
    }
    try {
      const validatedData = await request.validate({
        schema: loginSchema
      })
      const token = await auth.attempt(validatedData.email, validatedData.password)
      return response.json({
        token: token,
        user: await (new UserTransformer().transform(user))
      })
    } catch (e) {
      response.badRequest(e)
    }
  }

where when we console log user we are getting -

{
    id: 8,
    first_name: 'Khushi',
    last_name: 'verma',
    email: '[email protected]',
    password: '$argon2id$v=19$t=3,m=4096,p=1$lpfnZK6YurOrLrENaxn+/Q$blyFMnVvXTw8bjChUIGWrA7uTDsAtaPH+J5qh25UIt8',
    phone_number: null,
    gender: 'female',
    createdAt: DateTime {
      ts: 1621849445000,
      _zone: LocalZone {},
      loc: [Locale],
      invalid: null,
      weekData: null,
      c: [Object],
      o: 330,
      isLuxonDateTime: true
    },
    updatedAt: DateTime {
      ts: 1621849445000,
      _zone: LocalZone {},
      loc: [Locale],
      invalid: null,
      weekData: null,
      c: [Object],
      o: 330,
      isLuxonDateTime: true
    }
  },

What to do in this kind of situation when we are creating a model,updating,finding in model how can we preload it?
Is there any other way to include other than preloading a model as this can cause problem in nestedIncludes .

I have to replace logic to achiever the result-
New Logic

  public async login({request, auth, response}: HttpContextContract) {
    const user = await User.query().preload('todos').where('email',request.body().email).firstOrFail();
    if(!user) {
      throw new UserNotFoundException();
    }
    try {
      const validatedData = await request.validate({
        schema: loginSchema
      })
      const token = await auth.attempt(validatedData.email, validatedData.password)
      console.log("u",user);
      return response.json({
        token: token,
        user: await (new UserTransformer().transform(user))
      })
    } catch (e) {
      response.badRequest(e)
    }
  }

Can we not do it in previous logic.