app/config.py

import os
from datetime import datetime
from pathlib import Path

# Paths
BASE_DIR = Path(__file__).resolve().parent.parent
DATA_DIR = BASE_DIR / "data"
EXCEL_PATH = DATA_DIR / "ParcelPilot_Assessment_Data.xlsx"

# Reference time stated in Excel README: "2026-08-16 11:00 Asia/Kolkata"
SNAPSHOT_TIMESTAMP_STR = "2026-08-16 11:00:00"
SNAPSHOT_DATETIME = datetime.strptime(SNAPSHOT_TIMESTAMP_STR, "%Y-%m-%d %H:%M:%S")

# Precedence hierarchy weight (Higher number = Higher Authority)
PRECEDENCE_LEVELS = {
    "CUSTOMER_AGREEMENT": 4,
    "CURRENT_SUPPORT_POLICY": 3,
    "CURRENT_SOP": 2,
    "PRODUCT_OPS_GUIDE": 2,
    "HISTORICAL_TICKET": 1,
    "DEPRECATED_POLICY": 0
}

# API Configuration
DEFAULT_PORT = 8000