"""Configuration for User Creation."""

import os
from os.path import dirname, join

from dotenv import load_dotenv

# Load environment variables from a .env file
dotenv_path = join(dirname(__file__), ".env")
load_dotenv(dotenv_path)

QA_ENVIRONMENT = "qa"
PROD_ENVIRONMENT = "prod"
DEV_ENVIRONMENT = "dev"
PASSWORD_MIN_LENGTH = 24
DOT_MYCNF_FILE_PATH = os.environ.get("DOT_MYCNF_FILE_PATH") or "~/"

# snowflake
SNOWFLAKE_ACCOUNT = "orchard"
SNOWFLAKE_USER = os.environ.get("SNOWFLAKE_USER") or None
SNOWFLAKE_PASSWORD = os.environ.get("SNOWFLAKE_PASSWORD") or None
SNOWFLAKE_ROLE = "ACCOUNTADMIN"

# user creation environment variables
REPORTSAR_HOST = "reportsar.theorchard.com"
REPORTSAR02_HOST = "reportsar02.theorchard.com"
REPORTSDD_HOST = "reportsdd.theorchard.com"
REPORTSDD02_HOST = "reportsdd02.theorchard.com"
QA_AR_DB_HOST = "qa.db.qaorch.com"
QA_DD_DB_HOST = "qadddb.qaorch.com"
DEV_AR_DB_HOST = "phys.db.devorch.com"

USER_SNOWFLAKE_WAREHOUSE = "DEV_OWS_WAREHOUSE"
USER_SNOWFLAKE_ROLE = "DEV_ENGINEERING"
PROD_AWS_ACCOUNT_ID = "437795906767"
DEV_AWS_ACCOUNT_ID = "103233932089"