"""Config for Deezer Marketshare Workflow."""
import os


feed_name = 'deezer_marketshare'
secrets_path = 'deezer_marketshare'
feed_version = '1.0'
s3_feed_name = 'DeezerMarketShare'

# environment to run in
environment = os.environ.get('ENVIRONMENT', 'dev')

# bucket for dropped data
drop_bucket = os.environ.get(
    'FEED_INGESTION_DROP_BUCKET', 'dev-feed-drop')

# bucket for archived data
data_bucket = os.environ.get('FEED_INGESTION_DATA_BUCKET', 'dev-cucumbers')

# S3 locations for dropped and archived files
s3 = {
    'drop': (
        's3://{drop_bucket}/feed-drop/{feed_name}/'.format(
            drop_bucket=drop_bucket, feed_name=s3_feed_name)),
    'archives': (
        's3://{data_bucket}/{feed_name}/archives/{{date:%Y-%m}}/'.format(
            data_bucket=data_bucket, feed_name=s3_feed_name)),
    'processed': (
        's3://{data_bucket}/{feed_name}/processed/{{date:%Y-%m}}/'.format(
            data_bucket=data_bucket, feed_name=s3_feed_name)),
}

zephir = {
    'username': os.environ.get('ZEPHIR_DEEZER_USERNAME'),
    'password': os.environ.get('ZEPHIR_DEEZER_PASSWORD'),
    'host': os.environ.get('ZEPHIR_DEEZER_HOST', 'https://zephir.deezer.com'),
    'search': os.environ.get('ZEPHIR_DEEZER_SEARCH',
                             '/external?path=invoices'),
    'path': os.environ.get('ZEPHIR_DEEZER_PATH',
                           '/external/download?file=invoices/')
}

zip_pattern = r'TheOrchard_{date:%Y%m}_(adjustment_)?\d{{4,5}}.zip'
summary_file = 'summary_v1.csv'

file_pattern = r'{date:%m%Y}summary_v1.*.csv'
file_prefix = 'data_in_v4/'

snowflake_table_names = {
    'staging_raw': 'staging_raw_deezer_market_share',
}

product_types = {
    'is_adsup': ['MFS', 'MOD', 'Mobile Free Service', 'SMR', 'WBR'],
    'non_bundle': [
        'Discount 1&euro', 'Discount 1&euro /6months',
        'Discount 1&euro/6months', 'Discount 1€/6month',
        'Discount 3€/3month', 'Discount 5€/2month',
        '1und1 DE Standalone Premium+', '3 DK Premium+ Standalone',
        '3 SE Premium+ Extended Trial 3 months', '3 SE Premium+ Standalone',
        '3 UK Premium+ Extended Trial 6 months', '3 UK Premium+ Standalone',
        '3DK DK Premium+ Standalone',
        '3DK Integrated Billing DK Premium+ Standalone',
        '3SE Premium+ Standalone', '99€/3months)', '99€/3months)',
        '99€/3months)', 'AMC AL Premium + Standalone', 'Ampya Premium',
        'Ampya Premium+', 'Auchan Extended T&B 3 months',
        'BMW DE Premium+ 12 months', 'BMW DE Premium+ T&B 1 month',
        'BMW ES Premium+ 12 months', 'BMW ES Premium+ T&B 1 month',
        'BMW FR Premium+ 12 months', 'BMW FR Premium+ T&B 1 month',
        'BMW IT Premium+ 12 months', 'BMW IT Premium+ T&B 1 month',
        'BMW NL Premium+ 12 months', 'BMW NL Premium+ T&B 1 month',
        'BMW UK Premium+ 12 months', 'BMW UK Premium+ T&B 1 month',
        'Bit&eacute LV Standalone Premium +', 'Bité LV Standalone Premium +',
        'Bité LV Standalone Premium + (First 12 months)',
        'Caisse epargne - Deezer Premium+', 'Cricket US standalone',
        'DNA FI Premium+ 3 months Try and Buy', 'DNA FI Premium+ Standalone',
        'DNA FI Premium+ Standalone discount price',
        'DTAC TH Premium+ Standalone', 'Deezer Premium plus upsell (tango)',
        'Deezer Upsell Premium+', 'Deezer Worldwide Premium Standalone',
        'Deezer Worldwide Premium+ Standalone',
        'Deezer Worldwide Premium+ Standalone IOS',
        'Deezer Worldwide Premium+ Standalone IOS new price',
        'Digi MY Standalone - New Pricing', 'Digi MY Standalone Premium+',
        'Fastweb IT Premium+ Standalone',
        'La Repubblica IT Premium+ Standalone', 'Lime AG Premium+ Standalone',
        'Lime AI Premium+ Standalone', 'Lime BB Premium+ Standalone',
        'Lime DM Premium+ Standalone', 'Lime GD Premium+ Standalone',
        'Lime JM Premium+ Standalone', 'Lime KN Premium+ Standalone',
        'Lime KY Premium+ Standalone', 'Lime LC Premium+ Standalone',
        'Lime VC Premium+ Standalone', 'Lime VG Premium+ Standalone',
        'M1 Integrated billing SG Premium+ Standalone',
        'M1 SG Premium+ Standalone',
        'M1 SG Premium+ Standalone Discount Price 6 months',
        'MFS', 'MOD', 'Mobile Free Service',
        'Numericable BE Premium+ Standalone',
        'Numericable BE Premium+ T&B opt-out 3 months',
        'Orange ES Premium+ Extended Trial 6 months',
        'Orange ES Premium+ New Standalone', 'Orange ES Premium+ Standalone',
        'Orange ES Premium+ T&B 2 Months',
        'Orange FR Premium+ Retention Offer - Family offer',
        'Orange FR Premium+ Sales Force 6 months',
        'Orange FR Standalone Premium+ - Family offer',
        'Orange FR Standalone discount 3€/3months-new subs',
        'Orange FR premium+ discount 3€/3month - conversion',
        'Orange RO Premium+ 6 months trial', 'Orange RO Premium+ Standalone',
        'Orange Standalone - Premium', 'Orange Standalone - Premium+',
        'Orange UK Standalone Premium Plus', 'Orange standalone premium',
        'Orange standalone premium plus', 'Premium', 'Premium+',
        'Premium+ 12 months commitment',
        'Premium+ Caisse d&#039 &eacute pargne',
        'Premium+ Orange PL Standalone', 'Premium+ Samsung',
        'Premium+ TMobile AT Standalone', 'Premium+ TMobile NL Standalone',
        'Premium+ Tiers Parties', 'SMR', 'Samsung - Deezer Premium+',
        'Samsung 3 months', 'Smart PH Postpaid Daily Premium +',
        'Smart PH Postpaid Monthly Premium +',
        'Smart PH Postpaid Weekly Premium +', 'Smart PH Stand alone Premium +',
        'Sonos - Premium+ Xmas', 'Standalone Belgacom - Premium',
        'Standalone Belgacom - Premium+', 'Standalone EE - Premium+',
        'Standalone Orange FR premium +', 'Standalone Orange FR premium +',
        'Standalone Orange FR premium +', 'Standalone Orange FR premium +',
        'Standalone Orange FR premium +', 'Standalone Orange FR premium +',
        'Standalone Tango - Premium', 'Standalone Tango - Premium+',
        'Student Offer (50%/12 months)', 'Student Offer (ImaginR)',
        'Summer Offer (0', 'Summer Offer (1',
        'Swisscom CH Premium + Discount Price 6 months',
        'Swisscom CH Premium + Postpaid Standalone',
        'Swisscom intergrated billing CH Premium+ Postpaid Standalone',
        'T-Hrvatski Telekom Premium+ Standalone',
        'T-Mobile CZ Premium+ Standalone',
        'TIGO TZ Premium+ Standalone Prepaid Daily',
        'TIGO TZ Premium+ Standalone Prepaid Monthly',
        'TIGO TZ Premium+ Standalone Prepaid weekly',
        'TMobile AT Premium+ Try and Buy 3 months',
        'Tele2 EE Standalone Premium +', 'Tele2 LT Standalone Premium +',
        'Telekom SK Premium+ Standalone',
        'TelekomSlovenije SI Premium+ Standalone',
        'Telenor HU Premium Standalone', 'Telenor HU Premium+ Standalone',
        'Telenor HU Premium+ Try and Buy 3 months',
        'Telenor ME Premium+ Standalone', 'Telenor RS Standalone Premium+',
        'Tigo BO Premium+ Prepaid Daily', 'Tigo BO Premium+ Prepaid Weekly',
        'Tigo BO Premium+ Single Device Monthly prepaid',
        'Tigo CO Premium+ Prepaid Daily', 'Tigo CO Premium+ Prepaid Weekly',
        'Tigo GT Premium+ Prepaid Daily', 'Tigo GT Premium+ Prepaid Weekly',
        'Tigo HN Premium+ Prepaid Daily', 'Tigo HN Premium+ Prepaid Weekly',
        'Tigo HN Premium+ Single Device Monthly prepaid',
        'Tigo PY Premium+ Prepaid Daily', 'Tigo PY Premium+ Prepaid Weekly)',
        'Tigo SN Premium+ Standalone Prepaid Daily',
        'Tigo SN Premium+ Standalone Prepaid Monthly',
        'Tigo SN Premium+ Standalone Prepaid Weekly',
        'Tigo SV Premium+ Prepaid Daily', 'Tigo SV Premium+ Prepaid Weekly',
        'Tigo SV Premium+ Single Device Monthly prepaid',
        'Totalplay MX Standalone Premium+', 'UOL BR Premium+ Standalone',
        'Upsell Belgacom - Premium+', 'Upsell EE - Premium+',
        'Upsell EE - Premium+ / EE UK (Premium+ Upsell)',
        'Upsell Tango - Premium+', 'Viva BH Standalone Premium +',
        'Vodacom ZA Monthly Standalone P+',
        'Vodacom ZA Stadalone Promotion P+', 'Vodacom ZA T&B 2 months',
        'Vodafone Extended Trial', 'Vodafone Standalone Premium Plus', 'WBR',
        'Xmas 2015 (0', 'bose - Deezer Premium+', 'bose - Deezer Premium+ US',
        'sonos_biyearly - Deezer Elite', 'sonos_biyearly - Deezer Premium+',
        'sonos_monthly - Deezer Elite', 'sonos_monthly - Deezer Premium+',
        'sonos_yearly - Deezer Elite', 'sonos_yearly - Deezer Premium+'],
    'is_trial': [
        '3 SE Premium+ Extended Trial 3 months',
        '3 UK Premium+ Extended Trial 6 months',
        '3SE Premium+ Samsung 6 months T&amp B', '99€/3months)',
        '99€/3months)', '99€/3months)',
        'Auchan Extended T&B 3 months', 'BMW DE Premium+ T&B 1 month',
        'BMW ES Premium+ T&B 1 month', 'BMW FR Premium+ T&B 1 month',
        'BMW IT Premium+ T&B 1 month', 'BMW NL Premium+ T&B 1 month',
        'BMW UK Premium+ T&B 1 month',
        'DNA FI Premium+ 3 months Try and Buy',
        'Numericable BE Premium+ T&B opt-out 3 months',
        'Orange ES Premium+ Extended Trial 6 months',
        'Orange ES Premium+ T&B 2 Months',
        'Orange ES Premium+ T&amp B 2 Months',
        'Orange FR Standalone discount 3€/3months-new subs',
        'Orange FR premium+ discount 3€/3month - conversion',
        'Orange RO Premium+ 6 months trial',
        'Premium+ Caisse d&#039 &eacute pargne', 'Premium+ Samsung',
        'Samsung - Deezer Premium+', 'Samsung 3 months',
        'Summer Offer (0', 'Summer Offer (1',
        'TMobile AT Premium+ Try and Buy 3 months',
        'Telenor HU Premium+ Try and Buy 3 months',
        'Vodacom ZA T&B 2 months', 'Vodafone Extended Trial',
        'Xmas 2015 (0'],
    'is_multiuser': [
        'Orange FR Bundle Premium+ - Family Offer',
        'Orange FR Premium+ Retention Offer - Family offer',
        'Orange FR Standalone Premium+ - Family offer']
}