{% extends "base.html" %}
{% load i18n %}
{% load juntagrico.config %}
{% block page_title %}
    <h3>juntagrico-pg</h3>
{% endblock %}

{% block content %}
    <div class="row">
        <div class="col-md-12">
            <textarea id="textarea_id" wrap="off" rows="25" style="overflow-y: scroll; overflow-x: scroll; width: 100%; font-family: monospace; font-size: 0.75em; height: 100%">
            </textarea>
        </div>
    </div>
    <form id="sql-form">
        <div class="row mt-3">
            {% csrf_token %}
            <div class="col-md-9">
                <input class="form-control" id="sql" name="sql">
            </div>
            <div class="col-md-3">
                <input type="submit" class="btn btn-success" id="execute" value="{% trans "Ausführen" %}">
            </div>
        </div>
    </form>
{% endblock %}
{% block scripts %}
    <script>
        $(document).ready(function(){
            $('#sql-form').on('submit', function() {
                var textarea = $('#textarea_id');
                textarea.val(textarea.val() + '\n\n' + $("#sql").val());
                $.post( "{% url "jpg:sql" %}",
                    $("#sql-form").serialize(),
                    function( data ) {
                    var textarea = $('#textarea_id');
                    textarea.val(textarea.val() + '\n\n' + data);
                    textarea.scrollTop(textarea[0].scrollHeight);
                    $("#sql").val("")
                });
                return false
            });
        });
    </script>
{% endblock %}