70 lines
2.5 KiB
HTML
70 lines
2.5 KiB
HTML
{% extends "base.html" %}
|
|
{% block title %}Databases — AHDX{% endblock %}
|
|
{% block body %}
|
|
<h1>Databases</h1>
|
|
<p class="muted">
|
|
Each database is its own <code>.db</code> file under the data volume. Keep one
|
|
per person, one per year, or a scratch one to test an import. Imports always go
|
|
into the active database.
|
|
</p>
|
|
|
|
<table>
|
|
<thead>
|
|
<tr>
|
|
<th>Name</th>
|
|
<th class="num">Size</th>
|
|
<th class="num">Records</th>
|
|
<th class="num">Workouts</th>
|
|
<th>Last import</th>
|
|
<th>Actions</th>
|
|
</tr>
|
|
</thead>
|
|
<tbody>
|
|
{% for d in overview %}
|
|
<tr>
|
|
<td>
|
|
<strong>{{ d['name'] }}</strong>
|
|
{% if d['is_active'] %}<span class="badge">active</span>{% endif %}
|
|
<div class="muted" style="font-size:0.8rem;">{{ d['filename'] }}</div>
|
|
</td>
|
|
<td class="num">{{ d['size_h'] }}</td>
|
|
<td class="num">{{ '{:,}'.format(d['records']) }}</td>
|
|
<td class="num">{{ d['workouts'] }}</td>
|
|
<td class="muted">{{ d['last_import'][:16] if d['last_import'] else '—' }}</td>
|
|
<td>
|
|
<div class="actions">
|
|
{% if not d['is_active'] %}
|
|
<form method="post" action="{{ url_for('activate_database', db_id=d['id']) }}">
|
|
<button type="submit" class="btn-sm">Make active</button>
|
|
</form>
|
|
{% endif %}
|
|
<form method="post" action="{{ url_for('rename_database', db_id=d['id']) }}">
|
|
<input type="text" name="name" placeholder="Rename to…" required>
|
|
<button type="submit" class="btn-sm secondary">Rename</button>
|
|
</form>
|
|
<form method="post" action="{{ url_for('delete_database', db_id=d['id']) }}"
|
|
onsubmit="return confirm('Delete {{ d['name'] }} and its data file? This cannot be undone.');">
|
|
<button type="submit" class="btn-sm danger">Delete</button>
|
|
</form>
|
|
</div>
|
|
</td>
|
|
</tr>
|
|
{% endfor %}
|
|
</tbody>
|
|
</table>
|
|
|
|
<form method="post" action="{{ url_for('new_database') }}" class="card" style="max-width:360px;">
|
|
<h2>New database</h2>
|
|
<input type="text" name="name" placeholder="e.g. Steffen, or Anette" required>
|
|
<button type="submit">Create</button>
|
|
</form>
|
|
|
|
<div class="card muted">
|
|
<h2>Read API</h2>
|
|
<p>Pull data out for Grafana or scripts. Open
|
|
<a href="{{ url_for('api_index') }}"><code>/api</code></a> for the menu.
|
|
Pick a database with <code>?db=Name</code>. Example:
|
|
<code>/api/daily?db=Steffen&type=HKQuantityTypeIdentifierStepCount&agg=sum</code></p>
|
|
</div>
|
|
{% endblock %}
|