schema not read from [alias_dsn]

[sgohl]

possibly related to: #628
but actually the opposite:

having

[alias_dsn]
mysql1 = mysql://root@mysql1:3306/es

fails with

mycli -d mysql1 
Usage: mycli [OPTIONS] DATABASE
Try 'mycli --help' for help.

Error: Missing argument 'DATABASE'.

why do I need to define the schema in the alias_dsn when I need to provide it as required arg anyway?

how do I provide a config that allows me to just execute

mycli

which will then use a default dsn? I don't want to provide the schema arg to the cli

[rolandwalker]

Hi! Thanks for the report!

What version of mycli?

Does it behave differently without -d:

mycli mysql1

?

[sgohl]

> mycli mysql1
mycli 1.55.0

Alright, without -d it works ! Didn't even think of, because

  -d, --dsn TEXT                  Use DSN configured into the [alias_dsn]

That's good enough for me, but there's one thing:

is it possible to define a default DSN that would be used when you don't define a DSN via cli ?

like this

[alias_dsn]
default = mysql://root:@mysql1:3306/es

expected:

> mycli 
MySQL 5.7.44
mycli 1.55.0
Home: http://mycli.net
Bug tracker: https://github.com/dbcli/mycli/issues
Thanks to the contributor — Mike Palandra
MySQL root@mysql1:es>                                                                                                                                                                                                                                         
Goodbye!

that would be great!

[rolandwalker]

Alright, without -d it works

Interesting! I still couldn't duplicate the issue with either v1.55.0 or the latest v1.60.0. For me it works with or without -d.

is it possible to define a default DSN that would be used when you don't define a DSN via cli ?

Not sure about changing the mycli defaults there. It should be super easy to do this in the user's shell, though. Something like

mycli() { [[ $# -eq 0 ]] && command mycli mysql1 || command mycli "${@}"; }

would make plain invocations of mycli connect to mysql1, and if other arguments were given, pass those to the mycli executable instead.

[sgohl]

yeah that was my plan b - thanks anyway, I'm happy 👍

I still couldn't duplicate the issue with either

I think the issue was with an older version, before I upgraded