#!/usr/bin/env python3
import subprocess
import sys
from pathlib import Path

ROOT = Path(__file__).resolve().parent
RENDER = ROOT / "render_excel_like.py"
SERVER = ROOT / "grafo_d_server.py"
SQLITE_DB = ROOT / "DATABASE" / "GRAFO_D_DATABASE.sqlite"

def main():
    port = sys.argv[1] if len(sys.argv) > 1 else "8780"

    if not SQLITE_DB.exists():
        raise SystemExit(f"Missing canonical SQLite database: {SQLITE_DB}")

    subprocess.run([sys.executable, str(RENDER)], cwd=str(ROOT), check=True)
    subprocess.run([sys.executable, str(SERVER), str(port)], cwd=str(ROOT), check=True)

if __name__ == "__main__":
    main()