Add support for CONN_HEALTH_CHECKS and OPTIONS

[lorddaedra]

Hello!

How to convert my config to django-environ? I'm worry about CONN_HEALTH_CHECKS and OPTIONS.

DATABASES = types.MappingProxyType({
    'default': {
        'ENGINE': 'django.db.backends.postgresql',
        'HOST': '127.0.0.1',
        'NAME': 'devdatabase',
        'CONN_MAX_AGE': None,
        'CONN_HEALTH_CHECKS': True,
        'OPTIONS': {'sslmode': 'require'} if IS_PRODUCTION else {},
        'PASSWORD': 'django-insecure-database_password',
        'PORT': '5432',
        'USER': 'devdatabaseuser',
    },
})

Names like CONN_MAX_AGE are hardcoded in https://github.com/joke2k/django-environ/blob/main/environ/environ.py#L132-L137...

[denys-pidlisnyi]

#418

[sergeyklay]

Implemented in #418. Thank you for contributing!

[lorddaedra]

@denys-pidlisnyi @sergeyklay
What's about OPTIONS?
(It's not possible to use sslmode, isolation_level etc. settings without OPTIONS)

https://docs.djangoproject.com/en/4.1/ref/databases/#isolation-level
https://www.postgresql.org/docs/current/libpq-connect.html#LIBPQ-PARAMKEYWORDS

[sergeyklay]

Feel free to make a PR :)

[lorddaedra]

To be honestly, I use another package, dj-database-url. "Sister issue": jazzband/dj-database-url#180 :-)

this is my current settings.py, it works fine without any package code modifications:

# https://docs.djangoproject.com/en/4.1/ref/settings/#databases

DATABASES = types.MappingProxyType({
    'default': dj_database_url.parse(
        url=os.environ['DATABASE_URL'],
        engine='django.db.backends.postgresql',
        conn_max_age=None,
        ssl_require=not IS_DEVELOPMENT and not bool(os.getenv('CI', default=False)),
    ) | {'CONN_HEALTH_CHECKS': True},
})

I just commented because of you closed this issue (may be by mistake) but only half of issue was fixed... May be it should stay open but it's up to you...

[stat1c-void]

I wonder - are those changes really needed?

Here's example code for adding non-standard params to DB configuration:

DATABASES = {
    'default': {
        **env.db_url(),
        'CONN_MAX_AGE': None,
        'CONN_HEALTH_CHECKS': True,
        'TEST': {
            'MIGRATE': False
        }
    }
}

OPTIONS can be done in a similar way.

[Bensge]

@sergeyklay it would be useful if you could bump the package version and release it so that this change is available on PyPi

[sergeyklay]

@Bensge I'm on this track.

[pataquets]

Looks like OPTIONS is already supported and released:

django-environ/environ/environ.py

Lines 590 to 597 in df301b6

	if url.query:
	config_options = {}
	for k, v in parse_qs(url.query).items():
	if k.upper() in cls._DB_BASE_OPTIONS:
	config.update({k.upper(): _cast(v[0])})
	else:
	config_options.update({k: _cast_int(v[0])})
	config['OPTIONS'] = config_options

@lorddaedra: fancy to close the issue?

Also, I think @stat1c-void smart trick is worth a "tips" section snippet. I'll get to it as soon as I have some more time (unless someone beats to me at it 😄).

[lorddaedra]

About trick: yes, it's useful workaround (but I usually prefer modern style https://peps.python.org/pep-0584/ )

About options: may be we should add pool and server_side_binding to supported options too.
https://docs.djangoproject.com/en/dev/ref/databases/#connection-pool

Can we somehow do not hardcode them but load on app start instead?

[pataquets]

Thanks for the trick, @lorddaedra! I didn't knew about it.
About options: if options is supported (in general), wouldn't it be better to file separate issues for specific options?
(unless I'm missing sthg important about options, not very familiar using it, please bear with my newbiness)

[lorddaedra]

I agree with you, we can open new issue if needed for pool and server_side_binding.

There is nothing special with them.