Preload relationship acts strangely

[unkobweb]

Hi everyone,

Im coding an export function for my web app, so i need to preload much entities and relations, I did this code :

  async exportToJSON({ request, response }: HttpContextContract) {
    const gameboardUuid = request.param('uuid')
    const gameboard = await Gameboard.query().where('uuid', gameboardUuid).preload('freetexts').preload('positions', (posQuery) => {
      posQuery.preload('stacks', (stackQuery) => {
        stackQuery.preload('ranges', (rangeQuery) => {
          rangeQuery.preload('legend', (rangeLegendQuery) => {
            rangeLegendQuery.preload('legendColors', (rangeLegendcolorQuery) => {
              rangeLegendcolorQuery.orderBy('created_at', 'asc')
            })
          })
          rangeQuery.preload('rangeCellData')
          rangeQuery.preload('rangeCellTexts')
        })
      })
      posQuery.preload('legend', (legendQuery) => {
        legendQuery.preload('legendColors')
      })
    }).firstOrFail();

    if (gameboard.fromPremiumGameboardUuid) {
      return response.status(403).json({message: 'You can\'t export a premium gameboard'})
    }

    response.send(gameboard)
  }

And there is the return for one of my gameboard : https://pastebin.mozilla.org/vqZJDJdr

But it's strange, Im supposed to have relations of my range, so I tried with this code :

  async exportToJSON({ request, response }: HttpContextContract) {
    const gameboardUuid = request.param('uuid')
    const gameboard = await Gameboard.query().where('uuid', gameboardUuid).preload('freetexts').preload('positions', (posQuery) => {
      posQuery.preload('stacks', (stackQuery) => {
        stackQuery.preload('ranges')
      })
      posQuery.preload('legend', (legendQuery) => {
        legendQuery.preload('legendColors')
      })
    }).firstOrFail();

    for (const position of gameboard.positions) {
      for (const stack of position.stacks) {
        for (const range of stack.ranges) {
          await range.load('legend',(legendQuery) => {
            legendQuery.preload('legendColors', (legendColors) => {
              legendColors.orderBy('created_at', 'asc')
            })
          })
          await range.load('rangeCellData',(rangeCellDataQuery) => {
            rangeCellDataQuery.preload('legendColor')
          })
          await range.load('rangeCellTexts')
        }
      }
    }

    if (gameboard.fromPremiumGameboardUuid) {
      return response.status(403).json({message: 'You can\'t export a premium gameboard'})
    }

    response.send(gameboard)
  }

And i got this result for the same gameboard : https://pastebin.mozilla.org/nu72huEk
This time i have relations of my range entity, but this code have pretty bad performance. I think my first code have to work but just something can be wrong in my code or entities.

For example, there is the model of range :

import { DateTime } from 'luxon'
import { BaseModel, beforeCreate, BelongsTo, belongsTo, column, HasMany, hasMany } from '@ioc:Adonis/Lucid/Orm'
import { v4 as uuidv4 } from 'uuid'
import Legend from './Legend'
import Stack from './Stack'
import RangeCellData from './RangeCellData'
import RangeCellText from './RangeCellText'

export default class Range extends BaseModel {
  public static selfAssignPrimaryKey = true

  @column({ isPrimary: true })
  public uuid: string

  @column()
  public legendUuid: string

  // @column()
  // public originLegendUuid: string

  @column()
  public stackUuid: string

  @column()
  public label: string

  @column()
  public x: number

  @column()
  public y: number

  @column()
  public width: number

  @column()
  public height: number

  @column()
  public scaleX: number

  @column()
  public scaleY: number

  @column()
  public locked: boolean

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

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

  @belongsTo(() => Stack)
  public stack: BelongsTo<typeof Stack>

  @belongsTo(() => Legend)
  public legend: BelongsTo<typeof Legend>

  // @belongsTo(() => Legend)
  // public originLegend: BelongsTo<typeof Legend>

  @hasMany(() => RangeCellData)
  public rangeCellData: HasMany<typeof RangeCellData>

  @hasMany(() => RangeCellText)
  public rangeCellTexts: HasMany<typeof RangeCellText>

  @beforeCreate()
  public static assignUuid(range: Range) {
    range.uuid = uuidv4()
  }
}

And the code for RangeCellData entity :

import { DateTime } from 'luxon'
import { BaseModel, beforeCreate, BelongsTo, belongsTo, column } from '@ioc:Adonis/Lucid/Orm'
import { v4 as uuidv4 } from 'uuid'
import LegendColor from './LegendColor'
import Range from './Range'

export default class RangeCellData extends BaseModel {
  public static selfAssignPrimaryKey = true

  @column({ isPrimary: true })
  public uuid: string

  @column()
  public rangeUuid: string

  @column()
  public cellId: number

  @column()
  public legendColorUuid: string

  @column()
  public weight: number

  @column()
  public isBorder: boolean

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

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

  @belongsTo(() => LegendColor)
  public legendColor: BelongsTo<typeof LegendColor>

  @belongsTo(() => Range)
  public range: BelongsTo<typeof Range>

  @beforeCreate()
  public static assignUuid(rangeCellData: RangeCellData) {
    rangeCellData.uuid = uuidv4()
  }
}

Im currently running this app with NodeJS v16.17.0 and here is my dependencies :

  "dependencies": {
    "@adonisjs/auth": "^8.2.1",
    "@adonisjs/bouncer": "^2.3.0",
    "@adonisjs/core": "^5.7.4",
    "@adonisjs/drive-s3": "^1.3.2",
    "@adonisjs/lucid": "^18.0.0",
    "@adonisjs/repl": "^3.1.10",
    "chalk": "^4.1.2",
    "cli-progress": "^3.11.2",
    "inquirer": "^8.0.0",
    "luxon": "^2.3.1",
    "mysql": "^2.18.1",
    "mysql2": "^2.3.3",
    "nyc": "^15.1.0",
    "octokit": "^2.0.14",
    "proxy-addr": "^2.0.7",
    "reflect-metadata": "^0.1.13",
    "source-map-support": "^0.5.21",
    "uuid": "^8.3.2",
    "wordpress-hash-node": "^1.0.0"
  }

Tell me if you need more information and thank you for helping me <3
Have a nice day !

[unkobweb]

I tried with just this code too :

    const gameboard = Gameboard.query().where('uuid', gameboardUuid).preload('freetexts').preload('positions', (posQuery) => {
      posQuery.preload('stacks', (stackQuery) => {
        stackQuery.preload('ranges', (rangeQuery) => {
          rangeQuery.preload('rangeCellData')
        })
      })
    }).firstOrFail();

And even this don't give me my rangeCellData, here is my migration files :

import BaseSchema from '@ioc:Adonis/Lucid/Schema'

export default class RangeCellData extends BaseSchema {
  protected tableName = 'range_cell_data'

  public async up () {
    this.schema.createTable(this.tableName, (table) => {
      table.string('uuid').primary()
      table.string('range_uuid').references('ranges.uuid').notNullable().onDelete('CASCADE')
      table.integer('cell_id').unsigned().notNullable()
      table.string('legend_color_uuid').references('legend_colors.uuid').notNullable().onDelete('CASCADE')
      table.boolean('is_border').notNullable().defaultTo(false)
      table.integer('weight').notNullable()
      table.timestamps(true, true)
      table.unique(['range_uuid', 'cell_id', 'legend_color_uuid'])
    })
  }

  public async down () {
    this.schema.dropTable(this.tableName)
  }
}

import BaseSchema from '@ioc:Adonis/Lucid/Schema'

export default class Ranges extends BaseSchema {
  protected tableName = 'ranges'

  public async up () {
    this.schema.createTable(this.tableName, (table) => {
      table.string('uuid').primary()
      table.string('legend_uuid').references('legends.uuid').onDelete('CASCADE').nullable()
      // table.string('origin_legend_uuid').references('legends.uuid').onDelete('CASCADE').notNullable()
      table.string('stack_uuid').references('stacks.uuid').onDelete('CASCADE').notNullable()
      table.string('label').notNullable()
      table.integer('x').notNullable()
      table.integer('y').notNullable()
      table.integer('width').defaultTo(1).notNullable()
      table.integer('height').defaultTo(1).notNullable()
      table.double('scale_x').defaultTo(1).notNullable()
      table.double('scale_y').defaultTo(1).notNullable()
      table.boolean('locked').notNullable().defaultTo(false)
      table.timestamps(true, true)
    })
  }

  public async down () {
    this.schema.dropTable(this.tableName)
  }
}