"""
Configurazione centralizzata per ImdbUpdate
"""
from pathlib import Path

# Percorsi base
BASE_DIR = Path(__file__).parent.resolve()
EMPTY_DIR = BASE_DIR / "Empty"
TEMP_DIR = BASE_DIR / "Temp"

# URL IMDb datasets
IMDB_URLS = {
    'name_basics': 'https://datasets.imdbws.com/name.basics.tsv.gz',
    'title_akas': 'https://datasets.imdbws.com/title.akas.tsv.gz',
    'title_basics': 'https://datasets.imdbws.com/title.basics.tsv.gz',
    'title_crew': 'https://datasets.imdbws.com/title.crew.tsv.gz',
    'title_episode': 'https://datasets.imdbws.com/title.episode.tsv.gz',
    'title_principals': 'https://datasets.imdbws.com/title.principals.tsv.gz',
    'title_ratings': 'https://datasets.imdbws.com/title.ratings.tsv.gz',
}

# Database
ACCESS_DB_TEMPLATE = "db_split_IMDB.accdb"
ACCESS_DB_FINAL = TEMP_DIR / ACCESS_DB_TEMPLATE

# Export paths (da VBA originale)
EXPORT_PATHS = [
    r"I:\SOFTWARE\ProcedureICR\ICRmonitor\MonitorLinker",
    r"C:\IcrMonitor\MonitorLinker",
]

# GemmaLoader (Acquisti)
GEMMA_LOADER_PATH = r"\\mediaset.it\cologno\icr_acquisti\GemmaLoader\GemmaLoader.accdb"
GEMMA_LOADER_PASSWORD = "maugag"

# Parquet output
PARQUET_OUTPUT_PATH = BASE_DIR / "parquet" / "imdb_full.parquet"
PARQUET_PUBLISH_PATHS = [
    r"I:\SOFTWARE\PYTHON_SRV\PYTHON_LOCAL\MyICR_Suite\local_db\parquet",
]

# Log
LOG_DIR = Path(r"I:\SOFTWARE\ProcedureICR\ICRmonitor\MonitorLinker\UPDATES\log")

# Processing
MAX_DIRECTORS = 5
MAX_ACTORS = 5

# DuckDB
DUCKDB_THREADS = 0        # 0 = auto-detect CPU cores
DUCKDB_MEMORY_LIMIT = '4GB'

# Filtri titoli
TITLE_TYPES = ['movie', 'tvMiniSeries', 'tvMovie', 'tvSeries']