diff options
Diffstat (limited to 'official_climb/repository.go')
| -rw-r--r-- | official_climb/repository.go | 10 |
1 files changed, 5 insertions, 5 deletions
diff --git a/official_climb/repository.go b/official_climb/repository.go index 1feb6a9..33c2798 100644 --- a/official_climb/repository.go +++ b/official_climb/repository.go @@ -8,16 +8,16 @@ import ( "github.com/jftuga/geodist" ) -const columns = "id, name, start_latitude, start_longitude, end_latitude, end_longitude, created_at, updated_at" +const columns = "id, name, start_latitude, start_longitude, end_latitude, end_longitude, sample_distance_m, sample_elevation_gain_m, created_at, updated_at" func Create(db *sql.DB, climb OfficialClimb) (OfficialClimb, error) { if err := climb.validate(); err != nil { return OfficialClimb{}, err } result, err := db.Exec(` - INSERT INTO official_climbs (name, start_latitude, start_longitude, end_latitude, end_longitude) - VALUES (?, ?, ?, ?, ?) - `, climb.Name, climb.StartCoord.Lat, climb.StartCoord.Lon, climb.EndCoord.Lat, climb.EndCoord.Lon) + INSERT INTO official_climbs (name, start_latitude, start_longitude, end_latitude, end_longitude, sample_distance_m, sample_elevation_gain_m) + VALUES (?, ?, ?, ?, ?, ?, ?) + `, climb.Name, climb.StartCoord.Lat, climb.StartCoord.Lon, climb.EndCoord.Lat, climb.EndCoord.Lon, climb.Sample.DistanceM, climb.Sample.ElevationGainM) if err != nil { return OfficialClimb{}, fmt.Errorf("create official climb: %w", err) } @@ -79,7 +79,7 @@ func scan(s scanner) (OfficialClimb, error) { endLatitude, endLongitude float64 createdAt, updatedAt string ) - if err := s.Scan(&climb.ID, &climb.Name, &startLatitude, &startLongitude, &endLatitude, &endLongitude, &createdAt, &updatedAt); err != nil { + if err := s.Scan(&climb.ID, &climb.Name, &startLatitude, &startLongitude, &endLatitude, &endLongitude, &climb.Sample.DistanceM, &climb.Sample.ElevationGainM, &createdAt, &updatedAt); err != nil { return OfficialClimb{}, err } climb.StartCoord = geodist.Coord{Lat: startLatitude, Lon: startLongitude} |