import os
import zoneinfo

from audience_common.enums import Environment

SERVICE_NAME = "ows-dmp-workflows"

OWS_ENV: Environment = Environment(os.environ.get("AIRFLOW__CUSTOM__OWS_ENV", "dev"))

OWS_DMP_URL: str = (
    f"https://{OWS_ENV}-ows-dmp.theorchard.io"
    if OWS_ENV in {Environment.PROD, Environment.QA}
    else "http://host.docker.internal:8000"
)

AWS_REGION = "us-east-1"

EASTERN_TZ = zoneinfo.ZoneInfo("US/Eastern")

M2M_TOKEN_SECRET_KEY_NAME = f"{OWS_ENV}/lambda-jwt-refresh/jwt_token"
M2M_TOKEN_SECRET_EXPIRY_KEY_NAME = f"{OWS_ENV}/lambda-jwt-refresh/jwt_token_expiration"

CRM_EMAILS: list[str] = (
    ["crm.support@sonymusic.com"]
    if OWS_ENV == Environment.PROD
    else ["durukov@theorchard.com"]
)
BCC_EMAILS: list[str] = (
    ["durukov@theorchard.com", "rbomberg@theorchard.com"]
    if OWS_ENV == Environment.PROD
    else ["oleh.zhovnuvatyi.sme@sonymusic.com"]
)

SNOWFLAKE_CONN_NAME = os.environ.get("SNOWFLAKE_CONN_NAME", "snowflake_conn")

SNOWFLAKE_ROLE = os.environ.get(
    "AIRFLOW__CUSTOM__SNOWFLAKE_ROLE", "FANSIFTER_ENGINEERING"
)
SNOWFLAKE_SCHEMA = os.environ.get("AIRFLOW__CUSTOM__SNOWFLAKE_SCHEMA", "QA")
SNOWFLAKE_DATABASE = os.environ.get(
    "AIRFLOW__CUSTOM__SNOWFLAKE_DATABASE", "FANSIFTER_APP_REPORTING"
)
SNOWFLAKE_WAREHOUSE = os.environ.get(
    "AIRFLOW__CUSTOM__SNOWFLAKE_WAREHOUSE", "DEV_OWS_WH"
)
SNOWFLAKE_ACCOUNT = os.environ.get(
    "AIRFLOW__CUSTOM__SNOWFLAKE_ACCOUNT", "delphi.us-east-1"
)
SNOWFLAKE_USER = os.environ.get("AIRFLOW__CUSTOM__SNOWFLAKE_USER")

SNOWFLAKE_PASSWORD_SECRET_NAME = os.environ.get(
    "AIRFLOW__CUSTOM__SNOWFLAKE_PASSWORD_SECRET_NAME"
)

SNOWFLAKE_PASSWORD = os.environ.get("SNOWFLAKE_PASSWORD")