from __future__ import annotations

import os
from dataclasses import dataclass
from pathlib import Path


ALLOWED_CONNECTIONS = {"iberofarmacos"}
ALLOWED_TABLES = {
    "devoluciones", "dim_cadena", "dim_cliente", "dim_producto",
    "dim_sucursal", "dim_vendedor", "fact_facturacion", "pedidos",
    "pesos_comarketing", "presupuesto_vendedor", "presupuesto_visitador",
    "productos", "sucursales", "ventas_comarketing", "ventas_desglosadas",
    "ventas_facturacion",
}


@dataclass(frozen=True)
class Settings:
    token: str
    database_path: Path
    log_dir: Path
    host: str
    port: int
    adapter: str
    lock_path: Path
    max_request_bytes: int
    simulated_delay_seconds: float
    podman_bin: str
    podman_image: str
    podman_network: str
    sync_script: str
    sync_directory: str
    podman_env_file: str
    podman_remote: bool
    sync_timeout_seconds: int

    @classmethod
    def from_env(cls) -> "Settings":
        return cls(
            token=os.getenv("WORKER_TOKEN", ""),
            database_path=Path(os.getenv("WORKER_DATABASE_PATH", "./worker/data/worker.sqlite3")),
            log_dir=Path(os.getenv("WORKER_LOG_DIR", "./worker/logs")),
            host=os.getenv("WORKER_HOST", "127.0.0.1"),
            port=int(os.getenv("WORKER_PORT", "8081")),
            adapter=os.getenv("WORKER_ADAPTER", "simulated"),
            lock_path=Path(os.getenv("WORKER_LOCK_PATH", "./worker/data/.full_sync.lock")),
            max_request_bytes=int(os.getenv("WORKER_MAX_REQUEST_BYTES", "16384")),
            simulated_delay_seconds=float(os.getenv("WORKER_SIMULATED_DELAY_SECONDS", "0.02")),
            podman_bin=os.getenv("PODMAN_BIN", "/usr/bin/podman"),
            podman_image=os.getenv("PODMAN_IMAGE", "localhost/bi-sync:1.0"),
            podman_network=os.getenv("PODMAN_NETWORK", "superset_internal"),
            sync_script=os.getenv("SYNC_SCRIPT", "/opt/bi-sync/sync/sync_reporting.py"),
            sync_directory=os.getenv("SYNC_DIRECTORY", "/opt/bi-sync/sync"),
            podman_env_file=os.getenv("PODMAN_ENV_FILE", "/opt/bi-sync/secrets/bi-sync.env"),
            podman_remote=os.getenv("PODMAN_REMOTE", "false").lower() == "true",
            sync_timeout_seconds=int(os.getenv("SYNC_TIMEOUT_SECONDS", "14400")),
        )
