{% extends "base.html" %}
{% set section = "modules" %}
{% block title %}{% if hook %}Edit hook{% else %}New hook{% endif %} — {{ module.name }}{% endblock %}

{% block content %}
<div class="panel">
    <header>
        {% if hook %}Edit hook &middot; #{{ hook.id }}{% else %}New hook for {{ module.name }}{% endif %}
        <span class="subtitle">SQL run after the merge, in order</span>
        <span style="margin-left:auto"><a href="{{ cancel_url }}">&larr; back to module</a></span>
    </header>
    <div class="body">
        <form method="post" action="{{ form_action }}">
            <label class="field">
                <span>run order</span>
                <input type="number" name="run_order" min="0" step="1"
                       value="{{ hook.run_order if hook else 0 }}">
                <span class="help">lower runs first</span>
            </label>

            <label class="field">
                <span>run on</span>
                <select name="run_on">
                    {% for opt in ['success', 'failure', 'always'] %}
                    <option value="{{ opt }}"
                        {% if (hook and hook.run_on == opt) or (not hook and opt == 'success') %}selected{% endif %}>
                        {{ opt }}
                    </option>
                    {% endfor %}
                </select>
                <span class="help">success = only after merge succeeds; always = even on error</span>
            </label>

            <label class="field">
                <span>connection</span>
                <select name="connection_id">
                    <option value="">— use module destination —</option>
                    {% for c in connections %}
                    <option value="{{ c.id }}"
                        {% if hook and c.id == hook.connection_id %}selected{% endif %}>
                        {{ c.name }}
                    </option>
                    {% endfor %}
                </select>
                <span class="help">leave blank to run against the module's destination connection</span>
            </label>

            <label class="field">
                <span>SQL</span>
                <textarea name="sql" rows="8" required>{{ hook.sql if hook else '' }}</textarea>
                <span class="help">e.g. <code>ANALYZE rlarp.mytable;</code></span>
            </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 hook %}save changes{% else %}create hook{% endif %}
                </button>
            </div>
        </form>
    </div>
</div>
{% endblock %}