Database connection doesn't close after command

[backspacerhino]

Given the next code for command:

...
@inject([null, null, 'Adonis/Lucid/Database'])
export default class TestCommand extends BaseCommand {
    public static commandName = 'test'
    public static description = 'test command'

    constructor(app: ApplicationContract, kernel: Kernel, private db: DatabaseContract) {
        super(app, kernel)
    }

    public static settings = {
        loadApp: true,
    }

    public async handle() {
        console.log('testing...');
        // The line below is what causes problems
        const users = await this.db.query().select('*').from('users');
        console.log('END');
    }
...

The command never finished if we have any Database connection opened.
If I remove that line then the command finishes

[thetutlage]

Expected. You have to close the database connection manually. AdonisJS cannot make the decision whether to forcefully close the connection or not. What if your command intentionally is a long running process?

await this.db.manager.closeAll()

[backspacerhino]

Thank you for the reply, now it closes properly. I tried looking in Connection managments but couldn't find it. Could you please add this manual closing to the docs?

[thetutlage]

Send a PR please :)