"""FinLens — main pipeline entry point.

Usage:
    uv run python main.py                           # all 10 default tickers
    uv run python main.py --tickers AAPL MSFT TSLA  # custom tickers
    uv run python main.py --dry-run                  # fetch + parse, skip DB
"""

import argparse
import json
import logging
import sys
from datetime import datetime
from pathlib import Path

from fetcher import fetch_all
from parser import parse_all
from loader import upsert_all
from enricher import enrich_fin_equity

# ── Logging ───────────────────────────────────────────────────────────────────
logging.basicConfig(
    level=logging.INFO,
    format="%(asctime)s  %(levelname)-8s %(message)s",
    datefmt="%H:%M:%S",
    handlers=[
        logging.StreamHandler(sys.stdout),
        logging.FileHandler("finlens.log", encoding="utf-8"),
    ],
)
logger = logging.getLogger(__name__)

# ── Defaults ──────────────────────────────────────────────────────────────────
DEFAULT_TICKERS = [
    "AAPL", "NVDA", "META", "NFLX", "ORCL",
    "AMD",  "INTC", "IBM",  "QCOM", "CSCO",
]

EXTRAS_DIR = Path("data/extras")


def save_extras(extras_list: list) -> None:
    EXTRAS_DIR.mkdir(parents=True, exist_ok=True)
    ts = datetime.now().strftime("%Y%m%d_%H%M%S")
    out = EXTRAS_DIR / f"extras_{ts}.json"
    with open(out, "w", encoding="utf-8") as f:
        json.dump(extras_list, f, indent=2, default=str)
    logger.info("Extras saved → %s", out)


def run(tickers: list, dry_run: bool = False) -> None:
    logger.info("=" * 65)
    logger.info("FinLens pipeline — %d tickers | mode: %s",
                len(tickers), "DRY RUN" if dry_run else "LIVE")
    logger.info("Tickers: %s", ", ".join(tickers))
    logger.info("=" * 65)

    # 1 — Fetch
    raw_results = fetch_all(tickers)

    # 2 — Parse
    (
        fin_rows, major_rows, inst_rows, fund_rows,
        roster_rows, tx_rows, summary_rows,
        extras_list,
    ) = parse_all(raw_results)
    logger.info(
        "Parsed: fin_equity=%d | major=%d | inst=%d | fund=%d | roster=%d | insider_tx=%d | summary=%d",
        len(fin_rows), len(major_rows), len(inst_rows), len(fund_rows),
        len(roster_rows), len(tx_rows), len(summary_rows),
    )

    # 3 — Preview
    logger.info("\n── fin_equity preview ──")
    for r in fin_rows:
        logger.info(
            "  %-6s | %-10s | %-22s | %-18s | px=%-9s | mktcap=%-14s | inst=%s%%",
            r["ticker"],
            r.get("eq_exchange", ""),
            r.get("sector") or "—",
            r.get("industry", "")[:18] if r.get("industry") else "—",
            r.get("last_pr", "N/A"),
            f"{r['market_cap']:,}" if r.get("market_cap") else "N/A",
            r.get("hld_inst_shr_pcnt", "N/A"),
        )

    # 4 — Save extras
    if extras_list:
        save_extras(extras_list)

    # 5 — Load to DB
    if dry_run:
        logger.info("DRY RUN — skipping DB load.")
        return

    stats = upsert_all(
        fin_rows, major_rows, inst_rows, fund_rows,
        roster_rows, tx_rows, summary_rows,
    )
    logger.info("=" * 65)
    logger.info("DB load complete:")
    logger.info("  fin_equity       → inserted=%d | updated=%d | failed=%d",
                stats["fin_equity"]["inserted"], stats["fin_equity"]["updated"],
                stats["fin_equity"]["failed"])
    logger.info("  major_holders    → inserted=%d | failed=%d",
                stats["major_holders"]["inserted"], stats["major_holders"]["failed"])
    logger.info("  inst_holders     → inserted=%d | failed=%d",
                stats["inst_holders"]["inserted"], stats["inst_holders"]["failed"])
    logger.info("  fund_holders     → inserted=%d | failed=%d",
                stats["fund_holders"]["inserted"], stats["fund_holders"]["failed"])
    logger.info("  insider_roster   → inserted=%d | failed=%d",
                stats["insider_roster"]["inserted"], stats["insider_roster"]["failed"])
    logger.info("  insider_tx       → inserted=%d | failed=%d",
                stats["insider_tx"]["inserted"], stats["insider_tx"]["failed"])
    logger.info("  insider_summary  → inserted=%d | failed=%d",
                stats["insider_summary"]["inserted"], stats["insider_summary"]["failed"])
    logger.info("=" * 65)

    # 6 — Enrich with ISIN, CUSIP, FIGI
    logger.info("Enriching with FIGI, CUSIP, and ISIN...")
    enrich_stats = enrich_fin_equity()
    logger.info("Enrichment complete → enriched=%d | failed=%d",
                enrich_stats["enriched"], enrich_stats["failed"])


def main():
    p = argparse.ArgumentParser(description="FinLens data pipeline")
    p.add_argument("--tickers", nargs="+", default=DEFAULT_TICKERS)
    p.add_argument("--dry-run", action="store_true")
    args = p.parse_args()
    run(tickers=[t.upper() for t in args.tickers], dry_run=args.dry_run)


if __name__ == "__main__":
    main()
