Spaces:
Running
Running
| <html lang="uk"> | |
| <head> | |
| <meta charset="UTF-8"> | |
| <meta name="viewport" content="width=device-width, initial-scale=1.0"> | |
| <title>База даних {{ database }}</title> | |
| <link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/[email protected]/dist/css/bootstrap.min.css"> | |
| <link rel="stylesheet" href="{{ url_for('static', filename='style.css') }}"> | |
| </head> | |
| <body> | |
| <div class="container mt-4"> | |
| <div class="d-flex justify-content-between align-items-center mb-4"> | |
| <h1>База даних: {{ database }}</h1> | |
| <a href="/" class="btn btn-primary">На головну</a> | |
| </div> | |
| <!-- Список таблиць --> | |
| <div class="card mb-4"> | |
| <div class="card-header bg-info 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> | |
| <th>Назва таблиці</th> | |
| <th>Кількість рядків</th> | |
| <th>Розмір (МБ)</th> | |
| <th>Дії</th> | |
| </tr> | |
| </thead> | |
| <tbody> | |
| {% for table in tables %} | |
| <tr> | |
| <td>{{ table.name }}</td> | |
| <td>{{ table.count | int }}</td> | |
| <td>{{ table.size }}</td> | |
| <td> | |
| <a href="/table/{{ database }}/{{ table.name }}" class="btn btn-sm btn-primary">Структура і дані</a> | |
| <button class="btn btn-sm btn-success" onclick="copyToQueryConsole('SELECT * FROM {{ table.name }} LIMIT 10;')">Запит SELECT</button> | |
| </td> | |
| </tr> |