"""Config for the GfK Physical Ingestion Workflow."""

import os

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

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

s3 = {
    'archive_path': 'GfK_Physical/archives/{date}/',
    'processed_path': 'GfK_Physical/processed/{date}/',
}

# File pattern: BM{YY}{MM}{DD}CSV.ZIP e.g. BM260426CSV.ZIP for 2026-04-26
file_template = 'BM{yy}{mm}{dd}CSV.ZIP'

staging_raw_table = 'staging_raw_gfk_physical'

sftp = {
    'host': os.environ.get('GFK_PHYSICAL_SFTP_HOST'),
    'username': os.environ.get('GFK_PHYSICAL_SFTP_USERNAME'),
    'password': os.environ.get('GFK_PHYSICAL_SFTP_PASSWORD'),
    'port': int(os.environ.get('GFK_PHYSICAL_SFTP_PORT', 22)),
    'path': os.environ.get('GFK_PHYSICAL_SFTP_PATH', '/FEED'),
}