{% extends "base.html" %}
{% set section = "connections" %}
{% block title %}Connections — Pipekit{% endblock %}

{% block content %}
<div class="panel">
    <header>
        Connections
        <span class="subtitle">{{ connections|length }} total</span>
        <span style="margin-left:auto">
            <a class="btn" href="/connections/new">New connection…</a>
        </span>
    </header>
    <div class="body tight">
        {% if connections %}
        <table class="grid">
            <thead>
                <tr>
                    <th>name</th>
                    <th>driver</th>
                    <th>jdbc url</th>
                    <th>default dest</th>
                    <th></th>
                </tr>
            </thead>
            <tbody>
            {% for c in connections %}
                <tr>
                    <td><strong>{{ c.name }}</strong></td>
                    <td class="mono">{{ c.driver_kind }}</td>
                    <td class="mono" style="max-width:26rem;overflow:hidden;text-overflow:ellipsis;white-space:nowrap">{{ c.jdbc_url }}</td>
                    <td class="mono">{{ c.default_dest_schema or '—' }}</td>
                    <td style="text-align:right;white-space:nowrap">
                        <a href="/connections/{{ c.id }}/edit">edit</a> ·
                        <form class="inline" method="post" action="/connections/{{ c.id }}/delete"
                              onsubmit="return confirm('Delete connection {{ c.name }}?')">
                            <button class="ghost" type="submit" style="padding:0;border:none;color:var(--danger)">delete</button>
                        </form>
                    </td>
                </tr>
            {% endfor %}
            </tbody>
        </table>
        {% else %}
        <div class="empty">No connections yet.</div>
        {% endif %}
    </div>
</div>

<div class="panel">
    <header>Registered drivers
        <span class="subtitle">{{ drivers|length }} JDBC drivers available</span>
    </header>
    <div class="body tight">
        {% if drivers %}
        <table class="grid">
            <thead><tr><th>kind</th><th>name</th><th>jar</th><th>class</th></tr></thead>
            <tbody>
            {% for d in drivers %}
                <tr>
                    <td class="mono">{{ d.kind }}</td>
                    <td>{{ d.name }}</td>
                    <td class="mono" style="max-width:28rem;overflow:hidden;text-overflow:ellipsis;white-space:nowrap">{{ d.jar_file }}</td>
                    <td class="mono">{{ d.class_name }}</td>
                </tr>
            {% endfor %}
            </tbody>
        </table>
        {% else %}
        <div class="empty">No drivers registered.</div>
        {% endif %}
    </div>
</div>
{% endblock %}