diff options
| author | Martin Kagamino Lehoux <martin@lehoux.net> | 2026-08-21 07:08:53 +0200 |
|---|---|---|
| committer | Martin Kagamino Lehoux <martin@lehoux.net> | 2026-08-21 07:08:53 +0200 |
| commit | 6667ee479c06c14bb182f36a0a9ee704fca6218d (patch) | |
| tree | b53949334dae62d9da56ccdf76d958a0cc9db004 /rides/rides.go | |
| parent | 9da52d7355f5a77f0adc9a658619b3bfef03ba3c (diff) | |
feat(web): add sortable average speed column to ride library
Diffstat (limited to 'rides/rides.go')
| -rw-r--r-- | rides/rides.go | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/rides/rides.go b/rides/rides.go index b0ce5fb..94fbc64 100644 --- a/rides/rides.go +++ b/rides/rides.go @@ -37,6 +37,7 @@ const ( SortStartDate SortColumn = "started" SortDistance SortColumn = "distance" SortMovingTime SortColumn = "moving_time" + SortSpeed SortColumn = "speed" SortElevation SortColumn = "elevation" SortCotacol SortColumn = "cotacol" SortCotacolKm SortColumn = "cotacol_100km" @@ -156,6 +157,7 @@ var sortExpressions = map[SortColumn]string{ SortStartDate: "start_date", SortDistance: "distance_m", SortMovingTime: "CASE WHEN moving_time_algo_version = ? THEN COALESCE(moving_time_s, external_moving_time_s) ELSE external_moving_time_s END", + SortSpeed: "average_speed_mps", SortElevation: "total_elevation_gain_m", SortCotacol: "cotacol_score", SortCotacolKm: "cotacol_score * 100000.0 / NULLIF(distance_m, 0)", |