62e203bc2a
- Added functionality to export the full database schema (CREATE statements) and data (INSERT statements) as a single `.sql` file. - Created a new route `/export/database.sql` in `routes/export.py`. - Added helper functions to `routes/export.py` (adapted from `sql_explorer`) to generate schema CREATE statements and data INSERT statements. - Added a download link for the SQL export to the Settings page (`templates/settings.html`). - Updated the changelog entry for data export to include the SQL option.
220 lines
14 KiB
HTML
220 lines
14 KiB
HTML
{% extends 'base.html' %}
|
|
|
|
{% block content %}
|
|
|
|
<div class="mt-4 w-full grid grid-cols-1 md:grid-cols-2 xl:grid-cols-2 gap-4">
|
|
<div class="bg-white shadow rounded-lg p-4 sm:p-6 xl:p-8 mb-8">
|
|
<div class="mb-4 flex items-center justify-between">
|
|
<div>
|
|
<h3 class="text-xl font-bold text-gray-900 mb-2">Users</h3>
|
|
</div>
|
|
</div>
|
|
|
|
<div class="flex flex-col">
|
|
<div class="overflow-x-hidden rounded-lg max-h-96">
|
|
<div class="align-middle inline-block min-w-full">
|
|
<div class="shadow overflow-x-hidden sm:rounded-lg max-h-96 overflow-y-auto overflow-x-hidden">
|
|
<table class="table-fixed min-w-full divide-y divide-gray-200">
|
|
<thead class="bg-gray-50">
|
|
<tr>
|
|
<th scope="col"
|
|
class="p-4 text-left text-xs font-medium text-gray-500 uppercase tracking-wider w-3/5">
|
|
Name
|
|
</th>
|
|
<th scope="col"
|
|
class="p-4 text-left text-xs font-medium text-gray-500 uppercase tracking-wider">
|
|
<div class="relative">
|
|
<div
|
|
class="absolute inset-y-0 left-0 flex items-center pl-3 pointer-events-none">
|
|
<svg class="w-4 h-4 text-gray-500 dark:text-gray-400" aria-hidden="true"
|
|
xmlns="http://www.w3.org/2000/svg" fill="none" viewBox="0 0 20 20">
|
|
<path stroke="currentColor" stroke-linecap="round"
|
|
stroke-linejoin="round" stroke-width="2"
|
|
d="m19 19-4-4m0-7A7 7 0 1 1 1 8a7 7 0 0 1 14 0Z"
|
|
data-darkreader-inline-stroke=""
|
|
style="--darkreader-inline-stroke: currentColor;"></path>
|
|
</svg>
|
|
</div>
|
|
<input type="search" id="people-search"
|
|
class="block w-full p-4 pl-10 text-sm text-gray-900 border border-gray-300 rounded-lg bg-gray-50 focus:ring-blue-500 focus:border-blue-500"
|
|
placeholder="Search users..." _="on input
|
|
show <tbody>tr/> in closest <table/>
|
|
when its textContent.toLowerCase() contains my value.toLowerCase()
|
|
">
|
|
|
|
</div>
|
|
</th>
|
|
</tr>
|
|
</thead>
|
|
<tbody class="bg-white" id="new-person" hx-target="closest tr"
|
|
hx-swap="outerHTML swap:0.5s">
|
|
{% for p in people %}
|
|
{{ render_partial('partials/person.html', person_id=p['PersonId'],
|
|
name=p['Name'])}}
|
|
{% endfor %}
|
|
</tbody>
|
|
</table>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
|
|
<form class="w-full mt-3" hx-post="{{ url_for('create_person') }}" hx-swap="beforeend" hx-target="#new-person"
|
|
_="on htmx:afterRequest
|
|
render #notification-template with (message: 'User added') then append it to #notifications-container
|
|
then call _hyperscript.processNode(#notifications-container)
|
|
then reset() me">
|
|
<div class="flex flex-wrap -mx-3 mb-2">
|
|
<div class="grow px-3">
|
|
<label class="block uppercase tracking-wide text-gray-700 text-xs font-bold mb-2" for="grid-city">
|
|
New user
|
|
</label>
|
|
<input
|
|
class="appearance-none block w-full bg-gray-200 text-gray-700 border border-gray-200 rounded py-3 px-4 leading-tight focus:outline-none focus:bg-white focus:border-gray-500"
|
|
type="text" name="name">
|
|
</div>
|
|
|
|
<div class="flex flex-row pt-6 px-3 w-36">
|
|
<button
|
|
class="w-full flex text-white bg-cyan-600 hover:bg-cyan-700 focus:ring-4 focus:ring-cyan-200 font-medium rounded-lg text-sm px-5 py-2.5 text-center items-center h-12"
|
|
type="submit">
|
|
<svg class="w-6 h-6 text-gray-500 group-hover:text-gray-900 transition duration-75"
|
|
fill="currentColor" viewBox="0 0 20 20" xmlns="http://www.w3.org/2000/svg"
|
|
data-darkreader-inline-fill="" style="--darkreader-inline-fill:currentColor;">
|
|
<path fill-rule="evenodd"
|
|
d="M10 5a1 1 0 011 1v3h3a1 1 0 110 2h-3v3a1 1 0 11-2 0v-3H6a1 1 0 110-2h3V6a1 1 0 011-1z"
|
|
clip-rule="evenodd"></path>
|
|
</svg>
|
|
Add
|
|
</button>
|
|
</div>
|
|
</div>
|
|
</form>
|
|
</div>
|
|
|
|
<div class="bg-white shadow rounded-lg p-4 sm:p-6 xl:p-8 mb-8">
|
|
<div class="mb-4 flex items-center justify-between">
|
|
<div>
|
|
<h3 class="text-xl font-bold text-gray-900 mb-2">Exercises</h3>
|
|
</div>
|
|
</div>
|
|
|
|
<div class="flex flex-col">
|
|
<div class="rounded-lg">
|
|
<div class="align-middle inline-block min-w-full max-h-96 overflow-y-auto overflow-x-hidden">
|
|
<div class="shadow overflow-hidden sm:rounded-lg ">
|
|
<table class="table-fixed min-w-full divide-y divide-gray-200">
|
|
<thead class="bg-gray-50">
|
|
<tr>
|
|
<th scope="col"
|
|
class="p-4 text-left text-xs font-medium text-gray-500 uppercase tracking-wider w-1/4">
|
|
Name
|
|
</th>
|
|
<th scope="col"
|
|
class="p-4 text-left text-xs font-medium text-gray-500 uppercase tracking-wider w-3/4">
|
|
<div class="relative">
|
|
<div
|
|
class="absolute inset-y-0 left-0 flex items-center pl-3 pointer-events-none">
|
|
<svg class="w-4 h-4 text-gray-500 dark:text-gray-400" aria-hidden="true"
|
|
xmlns="http://www.w3.org/2000/svg" fill="none" viewBox="0 0 20 20">
|
|
<path stroke="currentColor" stroke-linecap="round"
|
|
stroke-linejoin="round" stroke-width="2"
|
|
d="m19 19-4-4m0-7A7 7 0 1 1 1 8a7 7 0 0 1 14 0Z"
|
|
data-darkreader-inline-stroke=""
|
|
style="--darkreader-inline-stroke: currentColor;"></path>
|
|
</svg>
|
|
</div>
|
|
<input type="search" id="exercise-search"
|
|
class="block w-full p-4 pl-10 text-sm text-gray-900 border border-gray-300 rounded-lg bg-gray-50 focus:ring-blue-500 focus:border-blue-500"
|
|
placeholder="Search exercises..." _="on input
|
|
show <tbody>tr/> in closest <table/>
|
|
when its textContent.toLowerCase() contains my value.toLowerCase()
|
|
">
|
|
|
|
</div>
|
|
</th>
|
|
</tr>
|
|
</thead>
|
|
<tbody class="bg-white" id="new-exercise" hx-target="closest tr"
|
|
hx-swap="outerHTML swap:0.5s">
|
|
{% for exercise in exercises %}
|
|
{{ render_partial('partials/exercise.html', exercise_id=exercise.exercise_id,
|
|
name=exercise.name)}}
|
|
{% endfor %}
|
|
</tbody>
|
|
</table>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
|
|
<form class="w-full mt-8" hx-post="{{ url_for('create_exercise') }}" hx-swap="beforeend"
|
|
hx-target="#new-exercise" _="on htmx:afterRequest
|
|
render #notification-template with (message: 'Exercise added') then append it to #notifications-container
|
|
then call _hyperscript.processNode(#notifications-container)
|
|
then reset() me">
|
|
<div class="flex flex-wrap -mx-3 mb-2">
|
|
<div class="grow px-3">
|
|
<label class="block uppercase tracking-wide text-gray-700 text-xs font-bold mb-2" for="grid-city">
|
|
New exercise
|
|
</label>
|
|
<input
|
|
class="appearance-none block w-full bg-gray-200 text-gray-700 border border-gray-200 rounded py-3 px-4 leading-tight focus:outline-none focus:bg-white focus:border-gray-500"
|
|
type="text" name="name">
|
|
</div>
|
|
|
|
<div class="flex flex-row pt-6 px-3 w-36">
|
|
<button
|
|
class="w-full flex text-white bg-cyan-600 hover:bg-cyan-700 focus:ring-4 focus:ring-cyan-200 font-medium rounded-lg text-sm px-5 py-2.5 text-center items-center h-12 cursor-pointer"
|
|
type="submit">
|
|
<svg class="w-6 h-6 text-gray-500 group-hover:text-gray-900 transition duration-75"
|
|
fill="currentColor" viewBox="0 0 20 20" xmlns="http://www.w3.org/2000/svg"
|
|
data-darkreader-inline-fill="" style="--darkreader-inline-fill:currentColor;">
|
|
<path fill-rule="evenodd"
|
|
d="M10 5a1 1 0 011 1v3h3a1 1 0 110 2h-3v3a1 1 0 11-2 0v-3H6a1 1 0 110-2h3V6a1 1 0 011-1z"
|
|
clip-rule="evenodd"></path>
|
|
</svg>
|
|
Add
|
|
</button>
|
|
</div>
|
|
</div>
|
|
</form>
|
|
|
|
</div>
|
|
|
|
<!-- Data Export Section -->
|
|
<div class="bg-white shadow rounded-lg p-4 sm:p-6 xl:p-8 mb-8">
|
|
<div class="mb-4 flex items-center justify-between">
|
|
<div>
|
|
<h3 class="text-xl font-bold text-gray-900 mb-2">Data Export</h3>
|
|
</div>
|
|
</div>
|
|
<div class="flex flex-col space-y-4"> <!-- Added space-y-4 for spacing between buttons -->
|
|
<p class="text-sm text-gray-600">Download all workout set data as a CSV file, or the entire database
|
|
structure and data as an SQL script.</p>
|
|
<a href="{{ url_for('export.export_workouts_csv') }}" class="text-white bg-green-600 hover:bg-green-700 focus:ring-4 focus:ring-green-300 font-medium
|
|
rounded-lg text-sm px-5 py-2.5 text-center inline-flex items-center justify-center w-full sm:w-auto">
|
|
<svg class="w-5 h-5 mr-2 -ml-1" fill="currentColor" viewBox="0 0 20 20"
|
|
xmlns="http://www.w3.org/2000/svg">
|
|
<path fill-rule="evenodd"
|
|
d="M6 2a2 2 0 00-2 2v12a2 2 0 002 2h8a2 2 0 002-2V7.414A2 2 0 0015.414 6L12 2.586A2 2 0 0010.586 2H6zm5 6a1 1 0 10-2 0v3.586l-1.293-1.293a1 1 0 10-1.414 1.414l3 3a1 1 0 001.414 0l3-3a1 1 0 00-1.414-1.414L11 11.586V8z"
|
|
clip-rule="evenodd"></path>
|
|
</svg>
|
|
Export All Workouts (CSV)
|
|
</a>
|
|
<a href="{{ url_for('export.export_database_sql') }}"
|
|
class="text-white bg-blue-600 hover:bg-blue-700 focus:ring-4 focus:ring-blue-300 font-medium rounded-lg text-sm px-5 py-2.5 text-center inline-flex items-center justify-center w-full sm:w-auto">
|
|
<svg class="w-5 h-5 mr-2 -ml-1" fill="currentColor" viewBox="0 0 20 20"
|
|
xmlns="http://www.w3.org/2000/svg">
|
|
<path
|
|
d="M2 5a2 2 0 012-2h12a2 2 0 012 2v10a2 2 0 01-2 2H4a2 2 0 01-2-2V5zm3.293 1.293a1 1 0 011.414 0L10 10.586l3.293-3.293a1 1 0 111.414 1.414l-4 4a1 1 0 01-1.414 0l-4-4a1 1 0 010-1.414z"
|
|
clip-rule="evenodd"></path>
|
|
</svg> <!-- Using a generic download/database icon -->
|
|
Export Database (SQL Script)
|
|
</a>
|
|
</div>
|
|
</div>
|
|
|
|
</div>
|
|
|
|
{% endblock %} |