dburl_to_connection.py

from urllib.parse import urlparse


database_url = input()

parsed = urlparse(database_url)

parts = {
    'port': parsed.port,
    'dbname': parsed.path[1:],
    'host': parsed.hostname,
    'user': parsed.username,
    'password': parsed.password
}

connection_options = ' '.join(
    f'{name}={value}'
    for name, value in parts.items()
)

print(connection_options)

pg_dump (heroku config:get DATABASE_URL -a hms-weave | python3 dburl_to_connection.py) -t hospital_affiliation_option -a | heroku psql -a hms-weave-staging