Access database using Lucid Models inside a Ace command.

[kush-prof]

I created a custom ace for setting up a cron job on my server but when I try to access the database from the command I am getting the following error.

ocLookupException: E_IOC_LOOKUP_FAILED: Cannot resolve "App/Models/User" namespace from the IoC Container

at /Users/cosmos/node/one2one-backend/commands/TestCommand.ts(anonymous):3
1  import { BaseCommand } from '@adonisjs/ace';
2  import Database from '@ioc:Adonis/Lucid/Database';
3  import User from 'App/Models/User';
4  
5  export default class TestCommand extends BaseCommand {
6    /**
7     * Command Name is used to run the command
8     */

1 Function.lookupFailed
  /Users/cosmos/node/one2one-backend/node_modules/@adonisjs/fold/build/src/Exceptions/IocLookupException.js:18

2 Ioc.onLookupFailed
  /Users/cosmos/node/one2one-backend/node_modules/@adonisjs/fold/build/src/Ioc/index.js:61

3 Ioc.use
  /Users/cosmos/node/one2one-backend/node_modules/@adonisjs/fold/build/src/Ioc/index.js:401

4 Module._compile
  /Users/cosmos/node/one2one-backend/node_modules/pirates/lib/index.js:99

5 Object.newLoader [as .ts]
  /Users/cosmos/node/one2one-backend/node_modules/pirates/lib/index.js:104

TestCommand.ts

import { BaseCommand } from '@adonisjs/ace';
import User from 'App/Models/User';

export default class TestCommand extends BaseCommand {
 /**
  * Command Name is used to run the command
  */
 public static commandName = 'test:command';

 /**
  * Command Name is displayed in the "help" output
  */
 public static description = '';

 public async run() {
   console.log('Test');

   const data = User.all();

   return data;
 }
}

[thetutlage]

Couple of things here.

• You must load the application using the settings.loadApp option. Commands do not boot the application by default.
• 2nd, commands cannot have top level imports, as they are scanned when generating the ace-manifest.json file.

The following code should work

import { BaseCommand } from '@adonisjs/ace';

export default class TestCommand extends BaseCommand {
 /**
  * Command Name is used to run the command
  */
 public static commandName = 'test:command';

 /**
  * Command Name is displayed in the "help" output
  */
 public static description = '';

 public static settings = {
   loadApp: true
 }

 public async run() {
   const User = (await import('App/Models/User')).default

   const data = await User.all();

   return data;
 }
}

I know there are no docs around this right now and hence this can get confusing.

[kush-prof]

Thanks for the quick reply, it worked.

Do you recommend anything in specific for invoking the custom commands programatically? Currently I am using shelljs

[matthiasrohmer]

For dynamic imports one needs to user the IoC container directly, for anyone who is running into the same problem I was:

this.model = (
      await this.application.container.use(`App/Models/${this.modelName}`)
    ).default;

[moabsi]

i am having this same problem with Adonis V6 can anyone help
the that were mentioned above didn't work for me as i tries to wait for import
const { default: Actions } = await import('#models/actions')

but still no luck with fixing it

[RomainLanz]

You still have to boot the application.

📚 https://docs.adonisjs.com/guides/ace/creating-commands#command-metadata