{% 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>
  <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|human }}</td>
          <td class="num">{{ e.columns|human }}</td>
          <td class="muted">{{ e.profiled_at|dt }}</td>
        </tr>
      {% endfor %}
    </tbody>
  </table>
{% endfor %}

{% endblock %}