# Application configuration.

import os
from urllib.parse import quote

from dotenv import load_dotenv
from sqlalchemy.pool import QueuePool

load_dotenv(".env")

DB_CREDENTIALS = {
    "database": os.environ.get("AR_MYSQL_DATABASE"),
    "host": os.environ.get("AR_MYSQL_HOST"),
    "password": quote(str(os.environ.get("AR_MYSQL_PASSWORD"))),
    "port": os.environ.get("AR_MYSQL_PORT"),
    "user": os.environ.get("AR_MYSQL_USER"),
}

DB_URL = "mysql+pymysql://{user}:{password}@{host}/{db}?charset=utf8".format(
    user=DB_CREDENTIALS.get("user"),
    password=DB_CREDENTIALS.get("password"),
    host=DB_CREDENTIALS.get("host"),
    db=DB_CREDENTIALS.get("database"),
)
POOL_CLASS = QueuePool
POOL_SIZE = 15
POOL_RECYCLE_MS = 3600  # Avoids connections going stale
POOL_MAX_OVERFLOW = -1
POOL_PRE_PING = False