"""Config for Ingestion Workflow."""

import os

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

drop_bucket = 'prod-orcdbucket'
# drop_bucket = os.environ.get('FEED_INGESTION_DROP_BUCKET', 'dev-cucumbers')
data_bucket = os.environ.get('FEED_INGESTION_DATA_BUCKET', 'dev-cucumbers')

# Drop path
drop_path = 'feed-drop/Seated/'

# Temp Staging Raw Table
temp_staging_raw_table = 'temp_staging_raw_{report}_{date:%Y%m%d}'

# Reports
reports = {
    'opt_ins': {
        'staging_raw_table': 'RAW_SEATED_OPT_INS',
        'staging_raw_table_errors': 'RAW_SEATED_OPT_INS_ERRORS',
        'filename_template':
        # Example: Eli_[artist_id]_2026-01-16_[opt_in_id]_v1.0.csv
            '.*_{date:%Y-%m-%d}_.*_v1\\.0\\.csv$',
        'pii_columns': ['FIRST_NAME', 'LAST_NAME', 'EMAIL', 'PHONE_NUMBER'],
    }
}