"""art_relations database connection setup."""

import os

from src.configs.config import secrets_manager_client


AR_DB_CREDENTIALS = {
    'user': os.environ.get('AR_MYSQL_USER'),
    'password': secrets_manager_client.get_cred('AR_MYSQL_PASSWORD'),
    'host': os.environ.get('AR_MYSQL_HOST'),
    'port': os.environ.get('AR_MYSQL_PORT', '3306'),
    'database': os.environ.get('AR_MYSQL_DATABASE', 'art_relations'),
}
AR_DB_CONNECTION_STRING = (
    'mysql+pymysql://{user}:{password}@{host}:{port}/{database}'.format(
        user=AR_DB_CREDENTIALS.get('user'),
        password=AR_DB_CREDENTIALS.get('password'),
        host=AR_DB_CREDENTIALS.get('host'),
        port=AR_DB_CREDENTIALS.get('port'),
        database=AR_DB_CREDENTIALS.get('database')
    )
)
AR_DB_CONNECT_ARGS = {
    'charset': 'utf8',
    'connect_timeout': int(os.environ.get('AR_MYSQL_CONNECT_TIMEOUT') or 15),
}