<div class="content">
  <h1>Explain</h1>

  <%= form_tag explain_path do %>
    <div class="field"><%= text_area_tag :query, @query, placeholder: "Enter a SQL query" %></div>
    <p>
      <%= submit_tag "Explain", class: "btn btn-info", style: "margin-right: 10px;" %>
      <%= submit_tag "Analyze", class: "btn btn-danger", style: "margin-right: 10px;" %>
      <%= submit_tag "Visualize", class: "btn btn-danger" %>
    </p>
  <% end %>

  <% if @explanation %>
    <% if @visualize %>
      <p>Paste the output below into the <%= link_to "Postgres Explain Visualizer", "https://tatiyants.com/pev/#/plans/new", target: "_blank" %></p>
    <% end %>
    <pre><code><%= @explanation %></code></pre>
    <% unless @visualize %>
      <p><%= link_to "See how to interpret this", "https://www.postgresql.org/docs/current/static/using-explain.html", target: "_blank" %></p>
    <% end %>
    <% if (index = @suggested_index) %>
      <%= render partial: "suggested_index", locals: {index: index, details: index[:details]} %>
    <% end %>
  <% elsif @error %>
    <div class="alert alert-danger"><%= @error %></div>
  <% end %>
</div>
