"""Common config for the proccessing_accounting ETLs."""

import os

PRODUCTION_BUCKET = 'prod-statement-detail-exports'
QA_BUCKET = 'qa-statement-detail-exports'
LABEL_KEY_PATH = 'schematized_files/{}_label_all_all_{}/user_id_type={}L/'
SUBACCOUNT_KEY_PATH = (
    'schematized_files/{}_subaccount_all_all_{}/user_id_type={}S/')
MONTHLY_LABEL_IDS = [
    10303, 14251, 17144, 17292, 17559, 17975, 18072, 18074, 18089, 18094,
    18215, 18389, 18805, 19405, 19973, 20177, 20329, 20892, 21109, 21786,
    21805, 22057, 26035
]
QUARTERLY_LABEL_IDS = [
    2604, 4565, 4938, 5333, 7123, 7724, 8869, 10109, 16055, 16175, 17901,
    21127, 22234, 22264, 7482
]

MONTHLY_SUBACCOUNT_IDS = [13823]
QUARTERLY_SUBACCOUNT_IDS = []


SF_CONFIG = {
    'role': os.environ.get('SNOWFLAKE_ROLE'),
    'warehouse': os.environ.get('SNOWFLAKE_WAREHOUSE'),
    'db': os.environ.get('SNOWFLAKE_DATABASE'),
    'database': os.environ.get('SNOWFLAKE_DATABASE'),  # for the native SF conn
    'schema': os.environ.get('SNOWFLAKE_SCHEMA'),
    'user': os.environ.get('SNOWFLAKE_USER'),
    'password': os.environ.get('SNOWFLAKE_PASSWORD'),
    'account': os.environ.get('SNOWFLAKE_ACCOUNT')
}