Ace migration commands failing when using the connection flag

[pokedpeter]

I'm unable to run the following migration commands successfully: refresh, reset and fresh when providing a connection with the --connection flag

refresh and reset provide the same error:

node ace migration:refresh --connection=pg
[ error ]  """pg""" is not a valid connection name. Double check "config/database" file

While, fresh provides a different error:

node ace migration:fresh --connection=pg

   Exception: E_UNMANAGED_DB_CONNECTION: Cannot connect to unregistered connection "pg"

In contrast, the flag works with run, status and rollback commands

This is a minor issue as my current workaround for all these commands is to manually set the connection environment variable when calling the commands, eg:
DB_CONNECTION=pg node ace migration:refresh

Prerequisites

Package version

18.4.0

Node.js and npm version

Node: v18.16.0
npm: 9.5.1

Sample Code (to reproduce the issue)

1. Obtain the connection key in database.ts. The default pg one is enough to replicate the issue.

...
  connections: {
    pg: { ... },
  }
...

2. Run either the refresh or reset migration command with the --connection flag with the provided connection key pg and note the error

node ace migration:refresh --connection=pg
[ error ]  """pg""" is not a valid connection name. Double check "config/database" file

BONUS

A quick glance at the migration command files shows something in common with the working commands which the non-working ones lack:

  private instantiateMigrator() {
    const db = this.application.container.use('Adonis/Lucid/Database')
    const Migrator = this.application.container.resolveBinding('Adonis/Lucid/Migrator')

    this.migrator = new Migrator(db, this.application, {
      direction: 'up',
      connectionName: this.connection,
      dryRun: this.dryRun,
      disableLocks: this.disableLocks,
    })
  }

Can I attempt a fix?

[stale]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.

[igortrinidad]

I'm facing the same issue, what about creating a PR to handle this @pokedpeter ?