"""Config for the Sme latam Ingestion Workflow."""

import os

environment = os.environ.get('Environment', 'dev')
feed_name = 'sme_latam'
secrets_path = 'sme_latam'

data_bucket = os.environ.get('FEED_INGESTION_DATA_BUCKET', 'dev-cucumbers')

drop_bucket = os.environ.get('FEED_INGESTION_DROP_BUCKET', 'dev-feed-drop')

s3 = {
    'archive_path': 'sme_latam/archives/{week_year}/{week_number}/',
    'drop_path': 'ftp/sme-data-drop/{week_year}/',
    'processed_path': 'sme_latam/process/{week_year}/'
}

file_template = (
    'BMAT - Sony - Sony Latam Unified Weekly Chart - Week {week_number}.xlsx')

temp_table_name = (
    'temp_staging_raw_sme_latam_weekly_unified_chart_{week_year}{week_number}')

staging_raw_table = 'staging_raw_sme_latam_weekly_unified_chart'