Spaces:
Sleeping
Sleeping
| <html lang="uk"> | |
| <head> | |
| <meta charset="UTF-8"> | |
| <meta name="viewport" content="width=device-width, initial-scale=1.0"> | |
| <title>Результат SQL запиту</title> | |
| <link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/[email protected]/dist/css/bootstrap.min.css"> | |
| <style> | |
| body { | |
| font-family: Arial, sans-serif; | |
| padding: 20px; | |
| } | |
| .card { | |
| margin-bottom: 20px; | |
| border-radius: 8px; | |
| box-shadow: 0 2px 5px rgba(0,0,0,0.1); | |
| } | |
| pre { | |
| background-color: #f8f9fa; | |
| padding: 15px; | |
| border-radius: 5px; | |
| } | |
| </style> | |
| </head> | |
| <body> | |
| <div class="container"> | |
| <div class="d-flex justify-content-between align-items-center mb-4"> | |
| <h1>Результат запиту</h1> | |
| <a href="/" class="btn btn-primary">Назад</a> | |
| </div> | |
| <!-- Виконаний запит --> | |
| <div class="card mb-4"> | |
| <div class="card-header bg-secondary text-white"> | |
| <h5>SQL запит</h5> | |
| </div> | |
| <div class="card-body"> | |
| <pre><code>{{ query }}</code></pre> | |
| </div> | |
| </div> | |
| <!-- Результат або помилка --> | |
| {% if error %} | |
| <div class="alert alert-danger"> | |
| <h4 class="alert-heading">Помилка!</h4> | |
| <p>{{ error }}</p> | |
| </div> | |
| {% elif affected_rows is defined %} | |
| <div class="alert alert-success"> | |
| <h4 class="alert-heading">Запит виконано успішно!</h4> | |
| <p>Змінено рядків: {{ affected_rows }}</p> | |
| </div> | |
| {% elif results %} | |
| <div class="card"> | |
| <div class="card-header bg-success text-white"> | |
| <h5>Результати запиту</h5> | |
| </div> | |
| <div class="card-body p-0"> | |
| <div class="table-responsive"> | |
| <table class="table table-striped table-bordered mb-0"> | |
| <thead class="table-dark"> | |
| <tr> | |
| {% for column in results[0].keys() %} | |
| <th>{{ column }}</th> | |
| {% endfor %} | |
| </tr> | |
| </thead> | |
| <tbody> | |
| {% for row in results %} | |
| <tr> | |
| {% for value in row.values() %} | |
| <td>{{ value }}</td> | |
| {% endfor %} | |
| </tr> | |
| {% endfor %} | |
| </tbody> | |
| </table> | |
| </div> | |
| </div> | |
| <div class="card-footer"> | |
| <p class="mb-0">Знайдено записів: {{ results|length }}</p> | |
| </div> | |
| </div> | |
| {% else %} | |
| <div class="alert alert-info"> | |
| <h4 class="alert-heading">Запит виконано успішно</h4> | |
| <p>Запит не повернув результатів.</p> | |
| </div> | |
| {% endif %} | |
| </div> | |
| </body> | |
| </html> |