{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "<div style=\"font-family: system-ui, -apple-system, sans-serif; text-align: center; padding: 48px 24px 24px;\">\n",
    "    <div style=\"display: inline-block; background: linear-gradient(135deg, #4a5bc7, #2d3470); color: white;\n",
    "                padding: 12px 20px; border-radius: 12px; margin-bottom: 20px;\">\n",
    "        <span style=\"font-size: 36px; font-weight: 800; letter-spacing: -0.5px;\">PATSTAT Explorer</span>\n",
    "    </div>\n",
    "    <div style=\"font-size: 16px; color: #475569; margin-bottom: 8px; line-height: 1.6;\">\n",
    "        Patent analysis &amp; visualization on EPO PATSTAT\n",
    "    </div>\n",
    "    <div style=\"font-size: 13px; color: #94a3b8; margin-bottom: 32px;\">\n",
    "        <a href=\"https://mtc.berlin\" target=\"_blank\"\n",
    "           style=\"color: #4a5bc7; text-decoration: none; font-weight: 600;\">mtc.berlin</a>\n",
    "        &nbsp;·&nbsp; EPO Technology &amp; Innovation Programme\n",
    "    </div>\n",
    "    <div style=\"background: #f8fafc; border-radius: 12px; padding: 24px 28px; max-width: 540px;\n",
    "                margin: 0 auto; border: 1px solid #e2e8f0; text-align: left;\">\n",
    "        <div style=\"font-size: 14px; color: #334155; line-height: 1.8;\">\n",
    "            Search and analyse patent data from the EPO PATSTAT database —\n",
    "            applicant trends, co-filing networks, citation flows,\n",
    "            technology classifications, and full-text search.\n",
    "            <br/><br/>\n",
    "            Includes an <strong>AI Query Interface</strong> powered by the\n",
    "            <a href=\"https://github.com/mtcberlin/mtc-patstat-mcp-lite\" target=\"_blank\"\n",
    "               style=\"color: #4a5bc7; text-decoration: none; font-weight: 600;\">mtc.berlin PATSTAT MCP</a>\n",
    "            server — ask questions in natural language and let Claude\n",
    "            explore the schema and build SQL for you.\n",
    "        </div>\n",
    "    </div>\n",
    "    <div style=\"background: #f0f4ff; border-radius: 10px; padding: 16px 24px; max-width: 540px;\n",
    "                margin: 28px auto 0; border: 1px solid #dbe4ff;\">\n",
    "        <div style=\"font-size: 14px; color: #2d3470; font-weight: 600;\">▶ &nbsp;Run the cell below to start</div>\n",
    "        <div style=\"font-size: 12px; color: #64748b; margin-top: 6px; line-height: 1.6;\">\n",
    "            First launch downloads &amp; installs everything (~1–2 min).<br/>\n",
    "            Subsequent starts are fast (~10 s).\n",
    "        </div>\n",
    "    </div>\n",
    "    <div style=\"margin-top: 20px; font-size: 12px; color: #cbd5e1;\">\n",
    "        To stop: run <code style=\"background: #f1f5f9; padding: 2px 6px; border-radius: 4px;\n",
    "        color: #64748b;\">stop()</code> in a new cell or restart the kernel.\n",
    "    </div>\n",
    "</div>"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "jupyter": {
     "source_hidden": true
    }
   },
   "outputs": [],
   "source": [
    "import subprocess, os, sys\n",
    "from pathlib import Path\n",
    "from IPython.display import display, HTML, clear_output\n",
    "\n",
    "REPO_URL = \"https://github.com/mtcberlin/epo-tip-svelte-patstat-explorer.git\"\n",
    "APP_DIR = Path.home() / \"patstat_svelte\"\n",
    "\n",
    "def _status(msg):\n",
    "    clear_output(wait=True)\n",
    "    display(HTML(f\"\"\"\n",
    "    <div style=\\\"font-family: system-ui, sans-serif; padding: 20px;\n",
    "                background: #f8fafc; border-left: 4px solid #4a5bc7;\n",
    "                border-radius: 8px;\\\">\n",
    "        <div style=\\\"font-size: 15px; color: #334155;\\\">⏳ {msg}</div>\n",
    "    </div>\"\"\"))\n",
    "\n",
    "if (APP_DIR / \".git\").is_dir():\n",
    "    _status(\"Updating PATSTAT Explorer...\")\n",
    "    subprocess.run([\"git\", \"-C\", str(APP_DIR), \"pull\", \"--ff-only\"],\n",
    "                   capture_output=True, text=True)\n",
    "else:\n",
    "    _status(\"Downloading PATSTAT Explorer (first run)...\")\n",
    "    subprocess.run([\"git\", \"clone\", REPO_URL, str(APP_DIR)],\n",
    "                   capture_output=True, text=True, check=True)\n",
    "\n",
    "os.chdir(str(APP_DIR))\n",
    "\n",
    "# launch.py uses __file__ to find PROJECT_DIR — provide it for exec()\n",
    "launch_path = str(APP_DIR / \"launch.py\")\n",
    "exec(compile(open(launch_path).read(), launch_path, \"exec\"), {**globals(), \"__file__\": launch_path})"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "name": "python",
   "version": "3.12.0"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}