db_utils.py

import os
import urllib.parse

from databases import Database

# Get env variables for db connection
from .utils import get_logger

db_host = os.environ.get('db_host', 'localhost')
db_name = os.environ.get('db_name', 'vincent')
db_port = urllib.parse.quote_plus(str(os.environ.get('db_port', '5432')))
db_user = urllib.parse.quote_plus(str(os.environ.get('db_user', 'vincent')))
db_pass = urllib.parse.quote_plus(str(os.environ.get('db_pass', 'password')))
ssl_mode = urllib.parse.quote_plus(str(os.environ.get('ssl_mode', 'prefer')))
db_url = f"postgresql://{db_user}:{db_pass}@{db_host}:{db_port}/{db_name}?sslmode={ssl_mode}"

logging = get_logger(name='db_utils')
logging.info(
    f"Defining configuration for db at [postgresql://{db_user}:****@{db_host}:{db_port}/{db_name}?sslmode={ssl_mode}]")

database: Database = Database(db_url,
                              #ssl=True,
                              min_size=5,
                              max_size=20)