"""Configuration for distribution_fee ETL."""

from os import environ


SWF_WORKFLOW_NAME = 'ows_ft_etl_distribution_fee'
SWF_WORKFLOW_ID = 'ows_ft_etl_distribution_fee_execution'
SWF_WORKFLOW_TIMEOUT = 7200
SWF_WORKFLOW_VERSION = '1.0'

SNS_ACTION_SUCCESS = 'etl-success'
SNS_SOURCE = 'distribution_fee'
SNS_TOPIC_ARN = environ.get('SNS_TOPIC_ARN')
SNS_REGION_NAME = 'us-east-1'

TABLE_ETL_LOG = 'distribution_fee_etl_log'

TABLE_DS_CLIENT_AMOUNT = 'client_amount'
TABLE_DS_REVENUE_THEATRICAL = 'theatrical_revenue'
TABLE_DS_REVENUE_CABLE = 'cable_revenue'
TABLE_DS_REVENUE_DIGITAL = 'digital_revenue'

# mapping of revenue tables and their columns for orchard's revenue share
REVENUE_TABLE_COLUMNS = {
    TABLE_DS_REVENUE_CABLE: 'orchard_amount',
    TABLE_DS_REVENUE_DIGITAL: 'amount',
    TABLE_DS_REVENUE_THEATRICAL: 'orchard_amount'}

TABLE_AR_VENDOR_CONTRACT = 'vendor_contract'
TABLE_AR_VENDOR_TER_CONTRACT = 'vendor_territory_contract'

PROC_AR_VENDOR_CONTRACT = 'sp_get_active_vendor_contract'