How do you close a Database Query in Ace Commands

[joshuand1990]

const Database = use('Database')

const users = yield Database.connection('mysql').table('users').select('*');
I get my data but the database connection is still open so the command doesn't stop running.

Using Lucid i don't face any issue and can close with Model.activeConnection.client.destroy().

[thetutlage]

Database.close('mysql')

[joshuand1990]

Database.close is not a function

using "adonis-lucid": "^2.0.5" and "mysql": "^2.11.1".

[thetutlage]

Okay seems like you are using the old version of adonis-lucid. I would recommend making use of the dev release for now. Docs for dev release are here http://dev.adonisjs.com/

Dev release will be released as 3.0 on 26th June (which is 6days from now).

As it is a major, there will be bunch of breaking changes. But it will be worth upgrading coz it is going to be stable.

[thetutlage]

Closing. Please reopen if you can any more questions

[riddict]

If using i am using two models, the connection wont close and the process will not exit. please help