Unable to obtain DB url without masked password

[whatnick]

Expected behaviour

We have some legacy code which obtains DB url from the index using db.index.url. It expects unmasked password for establishing a secondary connection to implement dataset/product deletes.

Actual behaviour

URL obtained via SQLAlchemy has password masked.

Steps to reproduce the behaviour

from psycopg2.extensions import parse_dsn
pg_url = dc.index.url
self._logger.debug(pg_url)
pg_dsn = parse_dsn(str(pg_url))
conn = psycopg2.connect(**pg_dsn)

Establishing connection fails

Proposed solutions

• Short term : Use render_as_string with hide password false.
• Long term : Internally implement dataset and product deletion to avoid such issues.

Environment information

• Which datacube --version are you using? - 1.9.0
• What datacube deployment/enviornment are you running against? - Local Devcontainer