How i can disable alembic logging at runtime?

Question

I need to disable alembic migrations logging, while executing migrations in unit tests, .

I can't just remove alembic logger it from alembic.ini: i need this output while performing migrations myself.

Following did not work for me: logging.getLogger('alembic').setLevel(logging.CRITICAL)

How i can disable it at runtime?

Answer 1

You need to edit the alembic.ini file and change the logging setting for this particular log. You can read about it in the relevant section of the Alembic tutorial. By default, this section should be in your configuration file:

[logger_alembic]
level = INFO
handlers =
qualname = alembic

I set mine to WARN instead, and these logs went away.

Answer 2

Sounds like you're invoking Alembic from within your unit tests by calling out to the alembic command, which is a separate process and does not inherit your logging configuration.

Instead, you should invoke Alembic programmatically:

import logging
import alembic.config
import alembic.command

logging.getLogger('alembic').setLevel(logging.CRITICAL)

alembic_cfg = alembic.config.Config('alembic.ini')
alembic.command.upgrade(alembic_cfg, 'head')

See the documentation for more info about the Alembic API.