pytest-django --debug-sql

conftest.py

__force_django_debug = False


def pytest_runtest_setup():
    if __force_django_debug:
        # required for logging SQL as pytest always sets DEBUG to False (why?)
        # https://github.com/pytest-dev/pytest-django/blob/master/pytest_django/plugin.py#L473
        from django.conf import settings

        settings.DEBUG = True


def pytest_addoption(parser):
    parser.addoption("--debug-sql", action="store_true", help="Prints logged SQL queries on failure.")


def pytest_configure(config):
    if config.getoption("--debug-sql"):
        global __force_django_debug
        import logging

        logging.getLogger('django.db.backends').setLevel(logging.DEBUG)
        __force_django_debug = True

If no logging handler is configed in settings.py, then an logging handler is required.

dblog = logging.getLogger('django.db.backends')
dblog.setLevel(logging.DEBUG)
dblog.addHandler(logging.StreamHandler())