Chart power vs time for official climb attempts

Snapshot average power per attempt in a nullable average_power_w column (backfilled from stored rides), plot each powered attempt on the climb page as duration vs average watts with ride hover and click-through, and show avg power in the attempts table.

1 files changed, 14 insertions, 0 deletions

diff --git a/rideanalysis/attempts_test.go b/rideanalysis/attempts_test.go
index 6fab8e1..b5b1271 100644
--- a/rideanalysis/attempts_test.go
+++ b/rideanalysis/attempts_test.go
@@ -36,6 +36,20 @@ func TestAttemptsSnapshotsOfficialClimbs(t *testing.T) {
 	assert.Equal(t, "v1", attempts[0].CotacolAlgoVersion)
 	assert.Equal(t, attemptRideStart, attempts[0].StartedAt.UTC())
 	assert.False(t, attempts[0].EndedAt.IsZero(), "attempt end must come from ride timestamps")
+	assert.Nil(t, attempts[0].AveragePowerW, "rides without a power meter record no average power")
+}
+
+func TestAttemptsSnapshotsAveragePower(t *testing.T) {
+	parsed := ridetest.MustRide("0.5km at 10% w=200 | 0.5km at 10% w=400 | 1km at -5% w=100", ridetest.StartCoord(43.61, 5.42), ridetest.StartElevation(300), ridetest.Sampling(500), ridetest.StartTime(attemptRideStart))
+	official := official_climb.OfficialClimb{ID: 42, Name: "Col de Test", StartCoord: parsed.Coords[0], EndCoord: parsed.Coords[2], Sample: parsed.Sample(0, 2)}
+	analysis := rideanalysis.Analyze(parsed, nil, []official_climb.OfficialClimb{official}, official_climb.DefaultMatchPolicy())
+
+	attempts := rideanalysis.Attempts(7, analysis, parsed)
+	require.Len(t, attempts, 1)
+	assert.InDelta(t, 1000, attempts[0].DistanceM, 1)
+	// Mean of the power samples inside the climb interval: 200, 200, 400 W.
+	require.NotNil(t, attempts[0].AveragePowerW)
+	assert.InDelta(t, 800.0/3.0, *attempts[0].AveragePowerW, 0.01)
 }
 
 func TestAttemptsSkipsUnmatchedClimbs(t *testing.T) {