"""Config for Store Specific Youtube Adjustment workflow."""

import os

feed_name = 'store_specific_youtube_adjustment'
secrets_path = 'datalytics__youtube_adjustment'
feed_version = '1.0'
expected_bucket_owner = os.environ.get('EXPECTED_BUCKET_OWNER', '437795906767')

_rights_mgmt = 'filedrop/videoservices/rights_mgmt/'

S3_BUCKET = os.environ.get('DATALYTICS_S3_BUCKET', 'dev-cucumbers').strip('/')
S3_ROOT = 'etl/videoservices/rights_mgmt/'
ADJUSTMENT_DIR = os.path.join(_rights_mgmt, 'adjustment_report/')

S3_ROOT = 's3://{bucket}/{path}'.format(
    bucket=S3_BUCKET, path=S3_ROOT)

ADJUSTMENT_DIR = 's3://{bucket}/{path}'.format(
    bucket=S3_BUCKET, path=ADJUSTMENT_DIR
)
STORE_SPECIFIC_YOUTUBE_ANALYTICS_SCHEMA = os.environ.get(
    'STORE_SPECIFIC_YOUTUBE_ANALYTICS_SCHEMA', 'YOUTUBE_ANALYTICS')
STORE_SPECIFIC_YOUTUBE_MAPPING_SCHEMA = os.environ.get(
    'STORE_SPECIFIC_YOUTUBE_MAPPING_SCHEMA', 'YOUTUBE_MAPPING')
STORE_SPECIFIC_DEV_DB = os.environ.get('STORE_SPECIFIC_DEV_DB', 'LY_DEV')
STORE_SPECIFIC_DEV_SCHEMA = os.environ.get(
    'STORE_SPECIFIC_DEV_SCHEMA', 'TEST')

STORE_SPECIFIC_DB = os.environ.get('STORE_SPECIFIC_DB', 'PROD')

ADJUSTMENT_DEV_ROOT_TABLE = 'ADJUSTMENT'
ADJUSTMENT_PROD_ROOT_TABLE = 'ADJUSTMENT_V2'
ADJUSTMENT_REPORT_TABLE = 'ADJUSTMENT_REPORT'
ASSET_VIEW_TABLE = 'ASSET_VIEW'

ADJUSTMENT_REPORT_TABLE = '{DB}.{SCHEMA}.{TABLE}'.format(
    DB=STORE_SPECIFIC_DB,
    SCHEMA=STORE_SPECIFIC_YOUTUBE_ANALYTICS_SCHEMA,
    TABLE=ADJUSTMENT_REPORT_TABLE
)

ADJUSTMENT_PROD_TABLE = '{DB}.{SCHEMA}.{TABLE}'.format(
    DB=STORE_SPECIFIC_DB,
    SCHEMA=STORE_SPECIFIC_YOUTUBE_ANALYTICS_SCHEMA,
    TABLE=ADJUSTMENT_PROD_ROOT_TABLE
)

ASSET_VIEW_TABLE = '{DB}.{SCHEMA}.{TABLE}'.format(
    DB=STORE_SPECIFIC_DB,
    SCHEMA=STORE_SPECIFIC_YOUTUBE_MAPPING_SCHEMA,
    TABLE=ASSET_VIEW_TABLE
)

ADJUSTMENT_DEV_TABLE = '{DB}.{SCHEMA}.{TABLE}'.format(
    DB=STORE_SPECIFIC_DEV_DB,
    SCHEMA=STORE_SPECIFIC_DEV_SCHEMA,
    TABLE=ADJUSTMENT_DEV_ROOT_TABLE
)

MARKET_SHARE_SCHEMA = os.environ.get(
    'MARKET_SHARE_SCHEMA', 'MARKET_SHARE')

STORE_SPECIFIC_YOUTUBE_ADJUSTMENT_FORMAT = '{}.{}.{}'.format(
    STORE_SPECIFIC_DB, MARKET_SHARE_SCHEMA, 'YT_ADJUSTMENT')

CMS_DICT = [
    {'asset_root': 'asset_conflict_report_theorchardmusic_N_v1-0.csv',
     'adjustment_root': 'YouTube_263000_theorchardmusic_label_AP*_report.csv',
     'CMS': 'ORCH'},

    {'asset_root': '',
     'adjustment_root': 'YouTube_9_dmgi_label_AP_*_report.csv',
     'CMS': 'ENT'}
]

EMAIL_LIST = ['datarequests@theorchard.com', 'conflicts@theorchard.com']