{% extends "base.html" %}
{% set section = "connections" %}
{% block title %}{% if connection %}Edit connection{% else %}New connection{% endif %} — Pipekit{% endblock %}

{% block content %}
<div class="panel">
    <header>
        {% if connection %}
            Edit connection &middot; {{ connection.name }}
        {% else %}
            New connection
        {% endif %}
        <span class="subtitle">jdbc endpoint + credentials</span>
        <span style="margin-left:auto"><a href="{{ cancel_url }}">&larr; back</a></span>
    </header>
    <div class="body">
        <form method="post" action="{{ form_action }}">
            <label class="field">
                <span>name</span>
                <input type="text" name="name" required
                       value="{{ connection.name if connection else '' }}">
                <span class="help">short identifier, used in module and watermark links</span>
            </label>

            <label class="field">
                <span>driver</span>
                <select name="driver_id" required>
                    {% for d in drivers %}
                    <option value="{{ d.id }}"
                        {% if connection and d.id == connection.driver_id %}selected{% endif %}>
                        {{ d.name }} &mdash; {{ d.kind }}
                    </option>
                    {% endfor %}
                </select>
                <span class="help">jar + class registered in the driver table</span>
            </label>

            <div class="panel" style="margin:0.5rem 0 0.8rem;background:#0f1216">
                <header style="padding:0.3rem 0.7rem">JDBC url format by driver
                    <span class="subtitle">pick the line matching the selected driver</span>
                </header>
                <div class="body" style="padding:0.5rem 0.9rem">
                    <dl class="keyval" style="grid-template-columns:5rem 1fr;gap:0.2rem 1rem">
                        <dt>db2</dt>   <dd class="mono">jdbc:as400://HOST;libraries=LIB1,LIB2;naming=system;translate%20binary=true</dd>
                        <dt>mssql</dt> <dd class="mono">jdbc:sqlserver://HOST:1433;databaseName=DB;encrypt=false</dd>
                        <dt>pg</dt>    <dd class="mono">jdbc:postgresql://HOST:5432/DATABASE</dd>
                    </dl>
                </div>
            </div>

            <label class="field">
                <span>JDBC url</span>
                <input type="text" name="jdbc_url" required
                       value="{{ connection.jdbc_url if connection else '' }}"
                       placeholder="jdbc:as400://...">
                <span class="help">must start with <code>jdbc:</code> — driver-specific query params after the host</span>
            </label>

            <label class="field">
                <span>username</span>
                <input type="text" name="username"
                       value="{{ connection.username if connection else '' }}">
            </label>

            <label class="field">
                <span>password</span>
                <input type="text" name="password"
                       value="{{ connection.password if connection else '' }}"
                       placeholder="$DB2PW">
                <span class="help">store as an env-var reference like <code>$DB2PW</code> — resolved at run time, never logged</span>
            </label>

            <label class="field">
                <span>default dest connection</span>
                <select name="default_dest_connection_id">
                    <option value="">—</option>
                    {% for c in connections %}
                        {% if not connection or c.id != connection.id %}
                        <option value="{{ c.id }}"
                            {% if connection and c.id == connection.default_dest_connection_id %}selected{% endif %}>
                            {{ c.name }}
                        </option>
                        {% endif %}
                    {% endfor %}
                </select>
                <span class="help">pre-selected as destination when this is the source of a new module</span>
            </label>

            <label class="field">
                <span>default dest schema</span>
                <input type="text" name="default_dest_schema"
                       value="{{ connection.default_dest_schema if connection else '' }}"
                       placeholder="e.g. rlarp">
                <span class="help">prefix for dest_table in the new-module wizard</span>
            </label>

            <label class="field">
                <span>notes</span>
                <textarea name="notes" rows="3">{{ connection.notes if connection else '' }}</textarea>
            </label>

            <div class="actions" style="justify-content:flex-end;margin-top:0.8rem">
                <a class="btn ghost" href="{{ cancel_url }}">cancel</a>
                <button type="submit" class="primary">
                    {% if connection %}save changes{% else %}create connection{% endif %}
                </button>
            </div>
        </form>
    </div>
</div>
{% endblock %}