"""Config for sme_labelcopy_loader."""
import os

ENV = os.environ.get('Environment', 'dev')

# service_name for secrets manager
service_name = 'sme_labelcopy_loader'

unload_filename = 'sme_labelcopy_{table_name}_{date}.csv'

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

s3_upload_path = 'sme_labelcopy_ingest/source/{date}/{filename}'

# ssh set up only for dev development
ssh_host = os.environ.get('SSH_HOST')
ssh_port = os.environ.get('SSH_PORT', 22)
ssh_username = os.environ.get('SSH_USERNAME')
ssh_private_key = os.environ.get('SSH_PRIVATE_KEY')
ssh_password = os.environ.get('SSH_PASSWORD')

# PostgreSQL setup
psql_host = os.environ.get('PSQL_HOST')
psql_username = os.environ.get('PSQL_USER')
psql_password = os.environ.get('PSQL_PASSWORD')
psql_database = os.environ.get('PSQL_DATABASE')
psql_port = os.environ.get('PSQL_PORT', 6432)

sql = 'SELECT * FROM orchard_ro.{table_name} {filter_clause};'

tables = {
    'sme_product_metadata_v2':
        'WHERE barcode IS NOT Null AND isrc IS NOT Null',
    'sme_participant_data': '',
    'sme_track_participants': '',
    'sme_song_participants': ''
}

SENTRY_DSN = os.environ.get('SENTRY_DSN')