"""Base configuration."""

import os

from analytics_aggregation.util import db

environment = os.environ.get('Environment', 'dev')

aws = {
    'access_key': os.environ.get('AWS_ACCESS_KEY_ID'),
    'access_secret': os.environ.get('AWS_SECRET_ACCESS_KEY')}

redshift = {
    'driver': db.Driver.REDSHIFT,
    'user': os.environ.get('REDSHIFT_READ_WRITE_USER'),
    'password': os.environ.get('REDSHIFT_READ_WRITE_PASSWORD'),
    'host': os.environ.get('REDSHIFT_READ_WRITE_HOST'),
    'port': os.environ.get('REDSHIFT_READ_WRITE_PORT'),
    'db': os.environ.get('REDSHIFT_READ_WRITE_DB')}

logging = {
    'version': 1,
    'disable_existing_loggers': False,
    'formatters': {
        'simple': {
            'format': '%(asctime)s - %(name)s - %(levelname)s - %(message)s'}},
    'handlers': {
        'console': {
            'class': 'logging.StreamHandler',
            'level': 'DEBUG',
            'formatter': 'simple'},
        'loggly': {
            'class': 'loggly.handlers.HTTPSHandler',
            'level': 'INFO',
            'formatter': 'simple',
            'url': os.environ.get('LOGGLY_URI')}},
    'loggers': {
        'garcon': {
            'handlers': ['console', 'loggly'],
            'level': 'DEBUG',
            'propagate': False}}}


SNOWFLAKE_CONFIG = {
    'account': os.environ.get('SNOWFLAKE_ACCOUNT'),
    'db': os.environ.get('SNOWFLAKE_DATABASE'),
    'password': os.environ.get('SNOWFLAKE_PASSWORD'),
    'role': os.environ.get('SNOWFLAKE_ROLE'),
    'schema': os.environ.get('SNOWFLAKE_SCHEMA', 'DEV'),
    'user': os.environ.get('SNOWFLAKE_USER'),
    'warehouse': os.environ.get('SNOWFLAKE_WAREHOUSE')
}

SNOWFLAKE_MICROSERVICE_CONFIG = dict(SNOWFLAKE_CONFIG)
SNOWFLAKE_MICROSERVICE_CONFIG['warehouse'] = (
    os.environ.get('SNOWFLAKE_MICROSERVICE_WAREHOUSE'))

SNOWFLAKE_POOL_SIZE = 10
SNOWFLAKE_POOL_RECYCLE = 3600  # Avoids connections going stale
SNOWFLAKE_POOL_MAX_OVERFLOW = 5
SNOWFLAKE_POOL_PRE_PING = True