"""Common configuration."""

import logging
import os

import sqlalchemy

ENVIRONMENT_DEV = 'dev'
ENVIRONMENT_TEST = 'test'
ENVIRONMENT = os.environ.get('Environment', ENVIRONMENT_DEV)

# Logger configuration
LOGGING_LEVEL = os.environ.get('LOGGING_LEVEL', logging.INFO)
logger = logging.getLogger()
logger.setLevel(LOGGING_LEVEL)

# Database configuration
# --------
# art_relations database connection setup
AR_DB_CREDENTIALS = {
    'database': os.environ.get('AR_MYSQL_DATABASE'),
    'host': os.environ.get('AR_MYSQL_HOST'),
    'password': os.environ.get('AR_MYSQL_PASSWORD'),
    'user': os.environ.get('AR_MYSQL_USER')
}
AR_DB_CONNECTION_STRING = (
    'mysql+pymysql://{user}:{password}@{host}/{db}'.format(
        user=AR_DB_CREDENTIALS.get('user'),
        password=AR_DB_CREDENTIALS.get('password'),
        host=AR_DB_CREDENTIALS.get('host'),
        db=AR_DB_CREDENTIALS.get('database')))

DB_CONNECT_ARGS = {'charset': 'utf8'}
DB_POOLCLASS = sqlalchemy.pool.NullPool

# Test
if ENVIRONMENT == ENVIRONMENT_TEST:
    # Use sqlite db for model-related testing functions.
    AR_DB_CONNECTION_STRING = 'sqlite://'
    DB_CONNECT_ARGS = {}
    DB_POOLCLASS = sqlalchemy.pool.StaticPool