Adonis V5 useful - tips

sql-debug.md

We can pass this Env File to debug Adonis:

LOG_LEVEL=trace

To show the SQL Queries we can use this setting:

// AppProvider.ts
public async ready () {
    // App is ready
    const Application = (await import('@ioc:Adonis/Core/Application')).default
    const Event = (await import('@ioc:Adonis/Core/Event')).default

    const Logger = (await import('@ioc:Adonis/Core/Logger')).default
    const Database = (await import('@ioc:Adonis/Lucid/Database')).default

    Event.on('db:query', (query: any) => {
      if (Application.inProduction) {
        Logger.debug(query)
      } else {
        Database.prettyPrint(query)
      }
    })
  }
  
  // config/database.ts
  pg: {
    debug: !Application.inProduction,
    // rest
  }