"""Config for Store Spicific Spotify Strikes Workflow."""
import datetime
import os

feed_name = 'store_specific_spotify_strikes'
secrets_path = 'datalytics__spotify_strikes'
feed_version = '1.0'

_s3_path = 'etl/store/spotify/hides_and_strikes'

# Common
EMAIL_LIST = ['leon@theorchard.com', 'datarequests@theorchard.com']


# Strikes
STRIKES_TABLE = 'SPOTIFY_STRIKES'
STRIKES_S3_PATH = os.path.join(_s3_path, 'strikes.tsv')
STRIKES_SHEET_ID = '1w0h-ZVtlxb_GDb9BVvfehHQvYB6HpGxOG4tJfCoC69k'

S3_BUCKET = os.environ.get('DATALYTICS_S3_BUCKET', 'dev-cucumbers').strip('/')
STORE_SPECIFIC_DB = os.environ.get('STORE_SPECIFIC_DB', 'PROD')
STORE_SPECIFIC_HIDDEN_CONTENT_SCHEMA = os.environ.get(
    'STORE_SPECIFIC_HIDDEN_CONTENT_SCHEMA', 'HIDDEN_CONTENT')

MARKET_SHARE_DB = os.environ.get('MARKET_SHARE_DB', 'PROD')
MARKET_SHARE_SCHEMA = os.environ.get(
    'MARKET_SHARE_SCHEMA', 'MARKET_SHARE')

SNOWFLAKE_FILE_FORMAT_TSV = '{db}.{schema}.TSV_HEAD'.format(
    db=MARKET_SHARE_DB, schema=MARKET_SHARE_SCHEMA)


S3_PATH = 's3://{bucket}/{path}'.format(
    bucket=S3_BUCKET, path=STRIKES_S3_PATH)

TODAY = datetime.date.today().strftime('%Y-%m-%d')

STRIKES_TABLE = '{DB}.{SCHEMA}.{TABLE}'.format(
    DB=STORE_SPECIFIC_DB,
    SCHEMA=STORE_SPECIFIC_HIDDEN_CONTENT_SCHEMA,
    TABLE=STRIKES_TABLE
)

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