import os
from dotenv import load_dotenv

load_dotenv()

class Config:
    SECRET_KEY = os.getenv("SECRET_KEY", "change-me-in-production-please")
    SESSION_HOURS = 8

    # ── Analytics Server (DataAnalytics DB — isi server pe rehta hai) ──────────
    SQL_SERVER   = os.getenv("SQL_SERVER", "")
    SQL_DATABASE = os.getenv("SQL_DATABASE", "")
    SQL_USERNAME = os.getenv("SQL_USERNAME", "")
    SQL_PASSWORD = os.getenv("SQL_PASSWORD", "")

    # ── Client / Production Server (alag server pe client DBs) ─────────────────
    CLIENT_SQL_SERVER   = os.getenv("CLIENT_SQL_SERVER", "")
    CLIENT_SQL_USERNAME = os.getenv("CLIENT_SQL_USERNAME", "")
    CLIENT_SQL_PASSWORD = os.getenv("CLIENT_SQL_PASSWORD", "")

    SSRS_BASE   = os.getenv("SSRS_BASE", "")
    SSRS_API    = os.getenv("SSRS_API", "")
    SSRS_DOMAIN = os.getenv("SSRS_DOMAIN", "")
    SSRS_USER   = os.getenv("SSRS_USER", "")
    SSRS_PASS   = os.getenv("SSRS_PASS", "")

ROLE_ADMIN  = 1
ROLE_DBA    = 2
ROLE_CLIENT = 3