{% extends "_base.html" %}

{% block extra_styles %}
<style>
  #query-placeholder { display: none; }
  #query-placeholder.htmx-request { display: block; }
</style>
{% endblock %}

{% block body %}
<div class="row">
  <div class="col">
    <h2 class="mb-3">{{ query.title }}</h2>

    {% if query.description %}
    <div>
      {{ query.description | render_markdown | safe }}
    </div>
    {% endif %}

    <form
      action="{{ request.url_for('get_query_run', query_id=query.name) }}"
      method="get"
      hx-boost="true"
      hx-target="#query-results"
      hx-select="#query-results"
      hx-swap="outerHTML"
      hx-indicator="#query-placeholder"
      hx-disabled-elt="find button[type='submit']"
      hx-on:htmx:before-request="document.getElementById('query-results').style.display='none'"
      hx-on:htmx:after-request="document.getElementById('query-results').style.display=''"
    >
      {% if sql_params|length %}
      <h3 class="mb-3">Parameters</h3>
      {% for param_name, param_value in sql_params | dictsort(by='key') %}
      <div class="row mb-3">
        <label for="param-{{ param_name }}" class="col-form-label col-sm-2">{{ param_name }}</label>
        <div class="col-sm-4">
          <input id="param-{{ param_name }}" class="form-control" name="{{ param_name }}" value="{{ param_value }}">
        </div>
      </div>
      {% endfor %}
      {% endif %}

      <div class="mb-3">
        <div class="d-flex justify-content-end">
          <div class="row">
            <div class="col">
              <a href="/tables/query?sql={{ query.sql | urlencode }}{% if sql_params | length > 0 %}&{{ sql_params | urlencode}}{% endif %}" class="btn btn-secondary" type="button" hx-boost="false">
                <i class="bi-code" aria-hidden="true"></i> Edit SQL
              </a>
            </div>

            <div class="col-auto">
              <button type="submit" class="btn btn-primary">
                <i class="bi-lightning" aria-hidden="true"></i> Execute
              </button>
            </div>
          </div>
        </div>
      </div>
    </form>

    <div id="query-placeholder" class="htmx-indicator placeholder-wave mt-3" aria-hidden="true">
      <div class="d-flex align-items-center gap-2 mb-2 text-muted">
        <div class="spinner-border spinner-border-sm" role="status" aria-hidden="true"></div>
        <span>Executing query…</span>
      </div>

      <div class="table-responsive">
        <table class="table table-sm table-bordered">
          <thead>
            <tr>
              <th><span class="placeholder col-1"></span></th>
              <th><span class="placeholder col-4"></span></th>
              <th><span class="placeholder col-3"></span></th>
              <th><span class="placeholder col-5"></span></th>
            </tr>
          </thead>
          <tbody class="table-group-divider">
            {% for i in range(8) %}
            <tr>
              <td><span class="placeholder col-1"></span></td>
              <td><span class="placeholder col-{{ 3 + (i % 4) }}"></span></td>
              <td><span class="placeholder col-{{ 2 + (i % 3) }}"></span></td>
              <td><span class="placeholder col-{{ 4 + (i % 3) }}"></span></td>
            </tr>
            {% endfor %}
          </tbody>
        </table>
      </div>
    </div>

    {% include "queries/_results.html" %}
  </div>
</div>
{% endblock %}

{% block extra_scripts %}
{% endblock %}