{% extends "base.html" %}
{% block title %}PSYCHE · Analysis{% endblock %}
{% block body %}
  <h2>Analysis playground</h2>
  <p class="muted">
    Proof-of-concept: preset summaries run in <strong>DuckDB</strong> over bundled demo trial data
    (not the full Hub catalog yet). No SQL required—you pick a view below.
  </p>

  <form class="preset" method="get" action="{{ url_for('analysis') }}">
    <label for="preset">Preset</label>
    <select id="preset" name="preset">
      {% for p in presets %}
        <option value="{{ p.id }}" {% if p.id == current_preset %}selected{% endif %}>{{ p.label }}</option>
      {% endfor %}
    </select>
    <button type="submit">Run</button>
  </form>

  {% if error %}
    <p role="alert"><strong>Error:</strong> {{ error }}</p>
  {% endif %}

  {% if table_html %}
    <h3 style="font-size: 1rem; margin-top: 1.25rem">Result</h3>
    {{ table_html | safe }}
  {% endif %}
{% endblock %}