[V6] TypeError: Cannot read properties of undefined (reading 'query')

[holoyan]

I want to write test for my package but I'm getting error when fetching record from db

import { test } from '@japa/runner'
import { BaseModel, column } from '@adonisjs/lucid/orm'


test.group('Some title | check type', (group) => {
  group.setup(async () => {
    await setup() // this works ok - db connection, table create
  })

  group.teardown(async () => {
    await cleanupTables() // this is ok too
  })

  test('ensure dummy assert works', async ({ assert }) => {

    class User extends BaseModel {
      @column({ isPrimary: true })
      declare id: number

      @column()
      declare username: string

      @column()
      declare email: string

      @column()
      declare password: string
    }

    const a = await User.find(1) // user with id=1 exsists in db

    assert.instanceOf(a, User)
  })
})

TypeError: Cannot read properties of undefined (reading 'query')
 
   at Object.executor tests/roles/has_roles.spec.ts:44
   42|      }
   43|  
 ❯ 44|      const a = await User.find(1)
   45|  
   46|      assert.instanceOf(a, User)

   ⁃ TestRunner.#runTest
     node_modules/@japa/core/src/test/runner.ts:311
   ⁃ TestRunner.#wrapTestInTimeout
     node_modules/@japa/core/src/test/runner.ts:384
   ⁃ TestRunner.#wrapTestInRetries
     node_modules/@japa/core/src/test/runner.ts:396
   ⁃ TestRunner.run
     node_modules/@japa/core/src/test/runner.ts:443
   ⁃ Test.exec
     node_modules/@japa/core/src/test/main.ts:466
   ⁃ GroupRunner.run
     node_modules/@japa/core/src/group/runner.ts:166

[tomgobich]

I have not tried writing tests that create models on the fly, so I'm just spitballing here. Models need booted, so maybe try adding a boot call just before your query?

test.group('Some title | check type', (group) => {
  group.setup(async () => {
    await setup() // this works ok - db connection, table create
  })

  group.teardown(async () => {
    await cleanupTables() // this is ok too
  })

  test('ensure dummy assert works', async ({ assert }) => {

    class User extends BaseModel {
      @column({ isPrimary: true })
      declare id: number

      @column()
      declare username: string

      @column()
      declare email: string

      @column()
      declare password: string
    }

    User.boot() // <--
    const a = await User.find(1) // user with id=1 exsists in db

    assert.instanceOf(a, User)
  })
})```

[thetutlage]

I would suggest looking at the Auth package tests that uses Lucid models. Especially this line https://github.com/adonisjs/auth/blob/develop/tests/helpers.ts#L102

[holoyan]

I looked into Lucid package tests before posting here, but it wasn't fully clear for me.

This one was really helpfull hint , thanks I managed to make it work.

[holoyan]

I'm getting similar issue when using predefined models.

I would suggest looking at the Auth package tests that uses Lucid models. Especially this line

@thetutlage I've followed your suggestion and it works for the models created on the fly(thanks) but I'm getting error when using models from src/models directory.

I'm about to finish this package and I'm blocked becouse of this issue.
if you look into the test case you can see that User and Post models are created on the fly and I can do create and get operations, but if I use Role model it throws error

> @holoyan/[email protected] quick:test
> node --import=./tsnode.esm.js --enable-source-maps bin/test.ts


   TypeError: Cannot read properties of undefined (reading 'booted')
 

   ⁃ run
     node_modules/@japa/runner/index.ts:209

also tried to call this methods but still getting same error

    Role.boot()
    Role.useAdapter(db.modelAdapter())


    // again error
    await Role.create({
      slug: 'edit',
      title: 'Edit',
    }) // TypeError: Cannot read properties of undefined (reading 'booted')

So basicly I want to have some kind of environment where I can call package methods and then check if DB operations are correct or not, something like this

import {Acl} from 'package'
import ModelPermission from 'package/models'


// Give a user the permission to edit
await Acl.model(user).allow('edit');

// then make direct call to db and check
const row = await ModelPermission.where(/*my consition */).first()
    assert.isTrue(row.some_column)

Any solution?

[parker-codes]

If anyone reaching this was getting this error after running a command, you may need to enable the framework to be loaded with the startApp option:

static options: CommandOptions = {
  startApp: true,
};

Official Docs

[dunhamjared]

OMG, thank you so so much.

[S0lide]

Thanks a lot ! It REALLY helped me out