diff options
Diffstat (limited to 'ride/store.go')
| -rw-r--r-- | ride/store.go | 12 |
1 files changed, 7 insertions, 5 deletions
diff --git a/ride/store.go b/ride/store.go index 56cd087..2d022ad 100644 --- a/ride/store.go +++ b/ride/store.go @@ -4,6 +4,7 @@ import ( "database/sql" "fmt" "log/slog" + "strings" "time" "github.com/martinlehoux/kagamigo/kcore" @@ -324,17 +325,18 @@ func BulkUpdateCategories(db *sql.DB, ids []int64, bikeType BikeType, rideType R if !IsValidRideType(string(rideType)) { return 0, fmt.Errorf("invalid ride_type %q", rideType) } - query := "UPDATE rides SET bike_type = ?, ride_type = ?, updated_at = strftime('%Y-%m-%dT%H:%M:%SZ', 'now') WHERE id IN (" + var query strings.Builder + query.WriteString("UPDATE rides SET bike_type = ?, ride_type = ?, updated_at = strftime('%Y-%m-%dT%H:%M:%SZ', 'now') WHERE id IN (") args := []any{string(bikeType), string(rideType)} for i, id := range ids { if i > 0 { - query += "," + query.WriteString(",") } - query += "?" + query.WriteString("?") args = append(args, id) } - query += ")" - result, err := db.Exec(query, args...) + query.WriteString(")") + result, err := db.Exec(query.String(), args...) if err != nil { return 0, err } |