feat(web): add sortable average speed column to ride library

1 files changed, 17 insertions, 0 deletions

diff --git a/rides/rides_test.go b/rides/rides_test.go
index fc8ff0d..ea87172 100644
--- a/rides/rides_test.go
+++ b/rides/rides_test.go
@@ -162,6 +162,23 @@ func TestListSortedByMovingTimeUsesCanonicalWithExternalFallback(t *testing.T) {
 	assert.Equal(t, first.ExternalID, items[1].ExternalID)
 }
 
+func TestListSortedBySpeed(t *testing.T) {
+	db := newTestDB(t)
+	slow := sampleRide(t)
+	slow.ExternalID = "strava:550e8400-e29b-41d4-a716-446655440000"
+	slow.AverageSpeedMps = 4.2
+	fast := sampleRide(t)
+	fast.ExternalID = "strava:6ba7b810-9dad-41d1-80b4-00c04fd430c8"
+	fast.AverageSpeedMps = 9.8
+	require.NoError(t, Save(db, slow))
+	require.NoError(t, Save(db, fast))
+
+	items, err := ListSorted(db, SortSpeed, false)
+	require.NoError(t, err)
+	assert.Equal(t, slow.ExternalID, items[0].ExternalID)
+	assert.Equal(t, fast.ExternalID, items[1].ExternalID)
+}
+
 func TestBackfill(t *testing.T) {
 	db := newTestDB(t)
 	require.NoError(t, Save(db, sampleRide(t)))