{% extends "base.html" %}
{% set section = "modules" %}
{% block title %}Add column · {{ module.name }} — Pipekit{% endblock %}

{% block content %}
<div class="panel">
    <header>
        Add column &middot; {{ module.name }}
        <span class="subtitle">appends to {{ module.dest_table }}</span>
        <span style="margin-left:auto"><a href="{{ cancel_url }}">&larr; back to module</a></span>
    </header>
    <div class="body">
        {% if error %}
        <div class="flash err" style="margin-bottom:0.8rem">{{ error }}</div>
        {% endif %}

        <div class="flash warn" style="margin-bottom:0.8rem">
            This runs <code>ALTER TABLE … ADD COLUMN</code>, which appends to the
            <strong>end</strong> of the table (existing rows preserved, new column NULL).
            The load is positional — add the matching expression as the
            <strong>last</strong> column of the source query, or the next run will misalign.
        </div>

        <form method="post" action="{{ form_action }}">
            <div class="two-col" style="gap:1rem">
                <label class="field">
                    <span>dest column name</span>
                    <input type="text" name="dest_name" required class="mono"
                           value="{{ values.dest_name or '' }}">
                    <span class="help">name in the destination table</span>
                </label>
                <label class="field">
                    <span>dest type</span>
                    <input type="text" name="dest_type" class="mono"
                           value="{{ values.dest_type or 'text' }}">
                    <span class="help">e.g. <code>bigint</code>, <code>text</code>, <code>numeric(15,2)</code></span>
                </label>
            </div>

            <label class="field">
                <span>description</span>
                <textarea name="dest_description" rows="2">{{ values.dest_description or '' }}</textarea>
                <span class="help">applied as <code>COMMENT ON COLUMN</code> (if the dest supports it)</span>
            </label>

            <div class="two-col" style="gap:1rem">
                <label class="field">
                    <span>source name <span style="color:var(--text-muted)">(optional)</span></span>
                    <input type="text" name="source_name" class="mono"
                           value="{{ values.source_name or '' }}">
                    <span class="help">informational — e.g. <code>RRN(T)</code></span>
                </label>
                <label class="field">
                    <span>source type <span style="color:var(--text-muted)">(optional)</span></span>
                    <input type="text" name="source_type" class="mono"
                           value="{{ values.source_type or '' }}">
                    <span class="help">informational only</span>
                </label>
            </div>

            <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">add column</button>
            </div>
        </form>
    </div>
</div>
{% endblock %}