{% extends "base.html" %}
{% block body %}

<input id="q" placeholder="filter tables" autofocus>

{% for c in connections %}
  <h2>{{ c.name }}
    <span class="muted">{{ c.manifest.adapter }} &middot; {{ c.tables|length }} tables &middot; generated {{ c.manifest.generated_at|dt }}</span>
  </h2>
  {% if c.notes %}
    <section id="notes-{{ c.name }}">
      <h3>Connection notes</h3>
      <div class="md">{{ c.notes|md }}</div>
    </section>
  {% endif %}
  <table data-enhance>
    <thead>
      <tr>
        <th data-sort="table">Table</th>
        <th data-sort="type">Type</th>
        <th data-sort="rows" data-sort-type="num" class="num">Rows</th>
        <th data-sort="columns" data-sort-type="num" class="num">Columns</th>
        <th data-sort="profiled">Profiled</th>
      </tr>
    </thead>
    <tbody>
      {% for fqn, e in c.tables.items() %}
        <tr data-table="{{ fqn }}" data-type="{{ e.type }}" data-rows="{{ e.row_count or 0 }}"
            data-columns="{{ e.columns or 0 }}" data-profiled="{{ e.profiled_at }}">
          <td><a href="{{ url_for('table', conn=c.name, table=fqn) }}">{{ fqn }}</a></td>
          <td>{{ e.type|capitalize }}</td>
          <td class="num">{{ e.row_count|number }}</td>
          <td class="num">{{ e.columns|number }}</td>
          <td class="muted">{{ e.profiled_at|dt }}</td>
        </tr>
      {% endfor %}
    </tbody>
  </table>
  {% if c.failed_tables %}
    <p class="muted">Not profiled by the last run ({{ c.failed_tables|length }}):
      {% for fqn in c.failed_tables %}<code>{{ fqn }}</code>{% if not loop.last %}, {% endif %}{% endfor %}
      - they exist; run <code>dbprint generate</code> to see why.</p>
  {% endif %}
{% endfor %}

{% endblock %}