{% extends "_base.html" %}
{% import 'tables/_macros.html' as table_macros %}

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

{% block body %}
<div class="row">
  <div class="col">
    <h2 class="mb-3">SQL Query</h2>

    <form
      action="{{ request.url_for('get_tables_query_run') }}"
      method="get"
      hx-boost="true"
      hx-target="#table-results"
      hx-select="#table-results"
      hx-swap="outerHTML"
      hx-indicator="#table-placeholder"
      hx-disabled-elt="find button[type='submit']"
      hx-on:htmx:before-request="document.getElementById('table-results').style.display='none'"
      hx-on:htmx:after-request="document.getElementById('table-results').style.display=''"
    >
      <div class="mb-3">
        <textarea id="sql-editor" name="sql" rows="5" class="form-control">{{ sql_query }}</textarea>
      </div>

      {% 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">
          <button type="submit" class="btn btn-primary">
            <i class="bi-lightning" aria-hidden="true"></i> Execute
          </button>
        </div>
      </div>
    </form>

    <div id="table-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-4"></span></th>
              <th><span class="placeholder col-3"></span></th>
              <th><span class="placeholder col-5"></span></th>
            </tr>
          </thead>
          <tbody>
            {% for i in range(8) %}
            <tr>
              <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 "tables/_results_fallback.html" %}
  </div>
</div>
{% endblock %}

{% block extra_scripts %}
<script src="{{ url_for('static', path='/editor.bundle.js') }}"></script>
<script>
  window.addEventListener("DOMContentLoaded", () => {
    const textArea = document.querySelector("textarea#sql-editor")
    textArea.style.display = "none"
    const sqlSchema = {{ sql_schema | tojson }}
    const sqlEditor = editor.createEditor(textArea, { readOnly: false, dialect: 'duckdb', schema: sqlSchema})
  })
</script>
{% endblock %}