# Application
APP_NAME=pricing-platform
APP_ENV=local
LOG_LEVEL=INFO
LOG_JSON=false

# PostgreSQL
POSTGRES_HOST=localhost
POSTGRES_PORT=5433
POSTGRES_USER=pricing
POSTGRES_PASSWORD=pricing_local_change_me
POSTGRES_DB=pricing
POSTGRES_MLFLOW_DB=mlflow

# SQLAlchemy / app DB URL (derived components preferred; override if needed)
# DATABASE_URL=postgresql+psycopg://pricing:pricing_local_change_me@localhost:5433/pricing

# MLflow (Phase 9 — local file store by default)
MLFLOW_TRACKING_MODE=local
MLFLOW_LOCAL_DIR=artifacts/mlruns
MLFLOW_ENABLED=true
MLFLOW_HOST=localhost
MLFLOW_PORT=5050
# Optional override (file: or http:). When unset, MODE chooses the URI.
# MLFLOW_TRACKING_URI=file:./artifacts/mlruns
MLFLOW_BACKEND_STORE_URI=postgresql+psycopg://pricing:pricing_local_change_me@postgres:5432/mlflow
MLFLOW_ARTIFACT_ROOT=/mlflow/artifacts
MLFLOW_EXPERIMENT_FORECAST=demand-forecasting
MLFLOW_EXPERIMENT_PRICING=dynamic-pricing
MLFLOW_EXPERIMENT_SEGMENTATION=segmentation
MLFLOW_DASHBOARD_DIR=reports/mlflow

# Local paths (relative to project root; never hardcode absolute machine paths in code)
PROJECT_DATA_DIR=data
PROJECT_ARTIFACT_DIR=artifacts
SAMPLE_DATA_DIR=data/sample
RAW_DATA_DIR=data/raw

# Ingestion (Phase 2)
INGEST_MODE=local
INGEST_MAX_RETRIES=3
INGEST_RETRY_BACKOFF_SECONDS=0.5
INGEST_RETRY_MAX_BACKOFF_SECONDS=8.0
INGEST_HTTP_TIMEOUT_SECONDS=30
# MARKETPLACE_SOURCE_URL=http://localhost:9001/marketplace
# WEATHER_SOURCE_URL=http://localhost:9001/weather
# HOLIDAY_SOURCE_URL=http://localhost:9001/holidays
INGEST_MARKETPLACE_BATCH_SIZE=50
INGEST_WEATHER_LOCATIONS=NYC,CHI,LAX,DAL,SEA
INGEST_HOLIDAY_COUNTRY=US
# INGEST_HOLIDAY_YEARS=2025,2026,2027

# EDA (Phase 5)
REPORTS_DIR=reports
EDA_FIGURES_DIR=reports/figures
EDA_SOURCE=auto

# Forecasting (Phase 6)
FORECAST_MODELS_DIR=artifacts/models
FORECAST_REPORTS_DIR=reports/forecasting
FORECAST_TEST_RATIO=0.2
FORECAST_N_SPLITS=3
FORECAST_WALK_FORWARD_HORIZON=7
FORECAST_WALK_FORWARD_STEP=7
FORECAST_MIN_TRAIN_DATES=30
FORECAST_RANDOM_STATE=42

# Dynamic pricing (Phase 7)
PRICING_REPORTS_DIR=reports/pricing
PRICING_MIN_PRICE_FACTOR=0.7
PRICING_MAX_PRICE_FACTOR=1.3
PRICING_GRID_STEPS=25
PRICING_SIM_INCREASE_PCT=0.10
PRICING_SIM_DECREASE_PCT=0.10
PRICING_MIN_OBS_PER_GROUP=20

# Segmentation (Phase 8)
SEGMENT_REPORTS_DIR=reports/segmentation
SEGMENT_FIGURES_DIR=reports/segmentation/figures
SEGMENT_PRODUCT_CLUSTERS=3
SEGMENT_REGION_CLUSTERS=3
SEGMENT_DEMAND_CLUSTERS=4
SEGMENT_RANDOM_STATE=42
SEGMENT_PERSIST_MODE=auto

# Prediction API (Phase 10)
API_HOST=127.0.0.1
API_PORT=8765
API_RELOAD=false
API_TITLE=Pricing Prediction API
API_VERSION=1.0.0

# Connection retries (jobs / API startup)
DB_CONNECT_TIMEOUT_SECONDS=30
DB_CONNECT_RETRIES=10