specify certain database in command-line

[sqlalchemy-bot]

Migrated issue, originally created by holsety huang (@holsety)

I want something like:

alembic -d mysql://user:password@localhost/database upgrade head

specify the database in config file is not so convenient.

[sqlalchemy-bot]

Michael Bayer (@zzzeek) wrote:

because alembic has no notion of a single database URL, it can't be a fixed argument like that. the best approach would be an option like -x "opt=value" which allows arbitrary configuration options to be added to the command line.

[sqlalchemy-bot]

Michael Bayer (@zzzeek) wrote:

amazingly, I added this feature the other day in response to a totally different issue, and I named it "-x" just like I proposed here.

So with 0.6.0 you'd say:

alembic -x dbname=mysql://user:pw@host/db upgrade head

then in your env.py:

    cmd_line_url = context.get_x_argument(as_dictionary=True).get('dbname])
    if cmd_line_url:
        engine = create_engine(cmd_line_url)
    else:
        engine = engine_from_config(
                config.get_section(config.config_ini_section),
                prefix='sqlalchemy.',
                poolclass=pool.NullPool)

    connection = engine.connect()

[sqlalchemy-bot]

Changes by Michael Bayer (@zzzeek):

• added labels: command interface

[sqlalchemy-bot]

Michael Bayer (@zzzeek) wrote:

I've added the above example to the 0.6.0 documentation (and also gave it a quick test).

[sqlalchemy-bot]

Changes by Michael Bayer (@zzzeek):

• changed status to closed