{% extends "layout.tpl" %}
{% block content %}
<form method="POST">
    <textarea name='sql' rows=10 style='width: 90%'>{{ sql }}</textarea><br/>
    <input type='submit' value='Run..'>
</form>
{% if rowCount %}
<div class='alert alert-info' role="alert">
    Row Count Affected: {{ rowCount }}
</div>
{% endif %}

<table style="width: 100%" border="1">
    <tr>
    {% for column in columns %}
    <th> {{ column }} </th>
    {% endfor %}
    </tr>
    {% for row in rows %}
        <tr>
            {% for column in columns %}
                <td> {{ row[column] }} </td>
            {% endfor %}
        </tr>
    {% endfor %}
</table>
{% endblock %}