"""Application configuration."""

import os

import sqlalchemy
from snowflake.sqlalchemy import URL

POOL_CLASS = sqlalchemy.pool.QueuePool
POOL_SIZE = 10
POOL_RECYCLE = 3600  # Avoids connections going stale, recycle after 1 hour
POOL_MAX_OVERFLOW = 5
POOL_PRE_PING = True

SNOWFLAKE_DB_URL = URL(
    account=os.environ.get('SNOWFLAKE_ACCOUNT'),
    user=os.environ.get('SNOWFLAKE_USER'),
    password=os.environ.get('SNOWFLAKE_PASSWORD'),
    database=os.environ.get('SNOWFLAKE_DATABASE'),
    schema=os.environ.get('SNOWFLAKE_SCHEMA'),
    warehouse=os.environ.get('SNOWFLAKE_WAREHOUSE')
)