import os
from pathlib import Path
from dotenv import load_dotenv

load_dotenv()


def _get_base_dir() -> Path:
    infamous_dir = os.getenv("INFAMOUSDIR")
    if not infamous_dir:
        return Path(__file__).resolve().parent.parent.parent
    return Path(infamous_dir) / "projects-cea" / "spotify-summer-2025-cea"


BASE_DIR = _get_base_dir()


class PATHS:
    base = BASE_DIR
    sql = BASE_DIR / "sql"
    sql_init = BASE_DIR / "sql" / "_create"


class QUERY_PATHS:
    _sql = PATHS.sql
    _init = PATHS.sql_init

    date = _sql / "date-query.sql"
    fill_main = _sql / "fill-main.sql"
    make_hyper = _sql / "make-hyper.sql"
    init_isrcs = _init / "init-isrcs.sql"
    init_main = _init / "init-main.sql"


TABLES = {
    "isrcs": "prod_eu_analytics.spotify_summer_2025_isrcs",
    "main": "prod_eu_analytics.spotify_summer_2025_main",
    "hyper": "prod_eu_analytics.spotify_summer_2025_hyper",
}

TABLEAU_SITE = "int_mktng"

TABLEAU_DATASOURCE_IDS = {
    "spotify_summer_2025": "fcf54de5-d64a-48cb-a863-bb925d1a0199",
}