1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
|
package web
import (
"database/sql"
"github.com/martinlehoux/biking_home/internal/ridetest"
"testing"
"time"
"github.com/martinlehoux/biking_home/official_climb"
"github.com/martinlehoux/biking_home/ride"
"github.com/martinlehoux/biking_home/rideanalysis"
"github.com/stretchr/testify/assert"
"github.com/stretchr/testify/require"
)
var testRideStart = time.Date(2026, 9, 1, 8, 0, 0, 0, time.UTC)
func testRideForClimb(t *testing.T) (ride.Ride, official_climb.OfficialClimb) {
t.Helper()
parsed := ridetest.MustRide("1km at 14.7% | 1km at -6.7%", ridetest.StartCoord(43.61, 5.42), ridetest.StartElevation(300), ridetest.Sampling(1000), ridetest.StartTime(testRideStart))
return parsed, official_climb.OfficialClimb{Name: "Col de Test", StartCoord: parsed.Coords[0], EndCoord: parsed.Coords[1], Sample: parsed.Sample(0, 1)}
}
func insertTestRide(t *testing.T, db *sql.DB) int64 {
t.Helper()
result, err := db.Exec(`
INSERT INTO rides (external_id, gpx_path, name, external_sport_type, start_date, distance_m, external_moving_time_s, elapsed_time_s, total_elevation_gain_m, average_speed_mps)
VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
`, "strava:climb-test", "missing.gpx", "Test Ride", "Ride", "2026-09-01T08:00:00Z", 20_000, 0, 0, 0, 0)
require.NoError(t, err)
id, err := result.LastInsertId()
require.NoError(t, err)
return id
}
func TestRecordOfficialClimbAttemptsPersistsAndReplaces(t *testing.T) {
server, db := newWebTestServer(t)
rideID := insertTestRide(t, db)
parsed, climb := testRideForClimb(t)
created, err := official_climb.Create(db, climb)
require.NoError(t, err)
analysis := rideanalysis.Analyze(parsed, nil, []official_climb.OfficialClimb{created}, official_climb.DefaultMatchPolicy())
server.recordOfficialClimbAttempts(rideID, parsed, analysis)
attempts, err := official_climb.AttemptsForClimb(db, created.ID)
require.NoError(t, err)
require.Len(t, attempts, 1)
assert.Equal(t, rideID, attempts[0].RideID)
// Re-recording replaces, never duplicates.
server.recordOfficialClimbAttempts(rideID, parsed, analysis)
attempts, err = official_climb.AttemptsForClimb(db, created.ID)
require.NoError(t, err)
require.Len(t, attempts, 1)
}
|
