{% extends "support.html" %}

{% block head %}
    {{ block.super }}
{% endblock %}

{% block pagehead %}
    {% include 'pagehead.html' %}
    <script>
        $(function () {
            function copy_text(text) {
                let $textarea = $('<textarea>')
                    .val(text)
                    .css({
                        position: 'fixed',
                        top: '-1000px',
                        left: '-1000px'
                    })
                    .appendTo('body');

                $textarea.select();
                document.execCommand('copy');
                $textarea.remove();
            }

            $('.copy-btn').on('click', function () {
                let $btn = $(this);
                let target_id = $btn.data('copy-target');
                let $pre = $('#' + target_id);

                if (!$pre.length) {
                    return;
                }

                copy_text($pre.text());

                let original_text = $btn.text();
                $btn
                    .addClass('copied')
                    .text('Copied');

                setTimeout(function () {
                    $btn
                        .removeClass('copied')
                        .text(original_text);
                }, 1500);
            });
        });
    </script>

    <style>
        h2 {
            margin-top: 30px;
            display: flex;
            align-items: center;
            justify-content: space-between;
        }

        pre {
            background-color: #f8f8f8;
            padding: 15px;
            border: 1px solid #ccc;
            overflow-x: auto;
            white-space: pre;
            position: relative;
        }

        .copy-btn {
            font-size: 12px;
            padding: 4px 8px;
            cursor: pointer;
        }

        .copy-btn.copied {
            color: green;
        }

        .helper-row {
            display: flex;
            align-items: center;
            justify-content: space-between;
            margin-bottom: 4px;
        }

        .helper {
            font-size: 12px;
            color: #666;
            margin-bottom: 6px;
        }
    </style>
{% endblock %}

{% block content %}
<h2>Search Path</h2>

<div class="helper-row">
    <div class="helper">Use before running the query manually:</div>
    <button class="copy-btn" data-copy-target="search-path-set">Copy</button>
</div>
<pre id="search-path-set">SET search_path TO {{ search_path }};</pre>

<div class="helper-row">
    <div class="helper">Reset after testing:</div>
    <button class="copy-btn" data-copy-target="search-path-reset">Copy</button>
</div>
<pre id="search-path-reset">RESET search_path;</pre>

<h2>
    SQL
    <button class="copy-btn" data-copy-target="sql-pre">Copy</button>
</h2>

<div class="helper-row">
    <div class="helper">Set search_path, and Reset search_path included.  Reset may not automatically work with interactive psql sessions.</div>
</div>

<pre id="sql-pre">
SET search_path TO {{ search_path }};

{{ sql }}

RESET search_path;
</pre>

<h2>
    EXPLAIN ANALYZE
    <button class="copy-btn" data-copy-target="explain-pre">Copy</button>
</h2>
<pre id="explain-pre">{{ explain }}</pre>
{% block sub-content %}{% endblock %}
{% endblock %}