Statistics API: Personal Records per Exercise

The Statistics API surfaces the authenticated user’s personal records (PRs) — the maximum weight ever lifted for every exercise they have trained. PR data is aggregated directly in SQL across all completed sets (completada = 1) and returned ordered by peso_maximo DESC. This endpoint powers the progress charts on the Blackterz frontend dashboard.

GET /api/estadisticas/prs

Returns the personal record — the maximum weight ever lifted — for every exercise the authenticated user has logged at least one completed set on. Only sets where sesion_series.completada = 1 are considered. Results are ordered by peso_maximo DESC. Auth required: Yes — Authorization: Bearer <token> The query joins four tables: sesiones_entrenamiento → sesion_ejercicios → sesion_series → ejercicios. It groups by exercise and aggregates with MAX(peso).

Poll this endpoint after every completed workout session to keep the frontend progress charts up to date.

Request

No query parameters or request body. The usuario_id is extracted directly from the JWT by the verificarToken middleware.

curl -X GET https://api.blackterzgym.com/api/estadisticas/prs \
  -H "Authorization: Bearer <your_token>"

Response

status

string

required

"ok" on success.

data

array

required

Array of personal record objects. One entry per exercise where the user has at least one completed set. Empty array [] if the user has no workout history.

Show Personal record object fields

ejercicio_id

integer

ID of the exercise, matching the ejercicios.id primary key.

ejercicio_nombre

string

Display name of the exercise, e.g. "Peso muerto".

peso_maximo

number

Maximum weight in kilograms recorded across all completed sets for this exercise.

reps_maximas

integer

Maximum repetitions recorded in a single completed set for this exercise.

veces_entrenado

integer

Number of distinct sesion_ejercicio entries (unique exercise appearances across sessions) for this exercise.

total_series_completadas

integer

Total count of completed sets (completada = 1) logged for this exercise across all sessions.

Sample response

{
  "status": "ok",
  "data": [
    {
      "ejercicio_id": 3,
      "ejercicio_nombre": "Peso muerto",
      "peso_maximo": 120,
      "reps_maximas": 5,
      "veces_entrenado": 8,
      "total_series_completadas": 24
    },
    {
      "ejercicio_id": 1,
      "ejercicio_nombre": "Press de banca",
      "peso_maximo": 100,
      "reps_maximas": 8,
      "veces_entrenado": 12,
      "total_series_completadas": 36
    },
    {
      "ejercicio_id": 2,
      "ejercicio_nombre": "Sentadilla",
      "peso_maximo": 95,
      "reps_maximas": 6,
      "veces_entrenado": 10,
      "total_series_completadas": 30
    }
  ]
}

Error responses

500 Internal Server Error

Returned when the SQL query fails.

{
  "status": "error",
  "message": "Error al obtener los récords personales"
}

401 Unauthorized

Returned when no token or an invalid/expired token is supplied. Raised by the verificarToken middleware before the controller runs.

{
  "status": "error",
  "message": "Token no válido o expirado"
}

Full curl example

curl -X GET https://api.blackterzgym.com/api/estadisticas/prs \
  -H "Authorization: Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9..."

GET /api/health

Verifies that the API server is running and that the MySQL database connection is healthy. Executes a lightweight SELECT 1 query against the pool. No authentication required. Auth required: None

Response

200 — Healthy
500 — Unhealthy

status

string

"ok"

string

"conectada" — the SELECT 1 completed successfully.

{
  "status": "ok",
  "db": "conectada"
}

When the database connection throws an error, the health route calls next(error) and the global error handler in server.js responds with a generic 500.

status

string

"error"

message

string

"Error interno del servidor"

{
  "status": "error",
  "message": "Error interno del servidor"
}

Curl example

curl -X GET https://api.blackterzgym.com/api/health

Overview

Endpoints

Statistics API: Personal Records per Exercise

GET /api/estadisticas/prs

Request

Response

Sample response

Error responses

Full curl example

GET /api/health

Response

Curl example

Build docs developers (and LLMs) love

Overview

Endpoints

Documentation Index

​GET /api/estadisticas/prs

​Request

​Response

​Sample response

​Error responses

​Full curl example

​GET /api/health

​Response

​Curl example

Build docs developers (and LLMs) love

GET /api/estadisticas/prs

Request

Response

Sample response

Error responses

Full curl example

GET /api/health

Response

Curl example