From 655c178a57ec14088c6c8d8f34fc209919f43b1a Mon Sep 17 00:00:00 2001 From: Jakub Czajka Date: Fri, 12 Apr 2024 23:39:34 +0200 Subject: [PATCH] Format file. --- insert.sh | 62 +++++++++++++++++++++++++++---------------------------- 1 file changed, 31 insertions(+), 31 deletions(-) diff --git a/insert.sh b/insert.sh index 29a71bb..575776a 100755 --- a/insert.sh +++ b/insert.sh @@ -118,40 +118,40 @@ case ${RECORD_TYPE} in do # $exercise and $exercise_id retain their values between iterations. [ -n "${val}" ] && case ${key} in - *_local_record) - query_db "\ - INSERT INTO gyms_records (gym_id, exercise_id, workout_id) - VALUES ('${gym_id}', '${exercise_id}', '${id}') - ON CONFLICT (gym_id, exercise_id) - DO UPDATE SET workout_id=${id}" - - echo "Recorded new record for '${exercise}' (id=${exercise_id}) in\ + *_local_record) + query_db "\ + INSERT INTO gyms_records (gym_id, exercise_id, workout_id) + VALUES ('${gym_id}', '${exercise_id}', '${id}') + ON CONFLICT (gym_id, exercise_id) + DO UPDATE SET workout_id=${id}" + + echo "Recorded new record for '${exercise}' (id=${exercise_id}) in\ ${gym} (id=${gym_id}) (workout_id=${id})." - ;; - *_global_record) - query_db "\ - INSERT INTO records (exercise_id, workout_id) - VALUES ('${exercise_id}', '${id}') - ON CONFLICT (exercise_id) - DO UPDATE SET workout_id=${id}" - - echo "Recorded new global record for '${exercise}'\ + ;; + *_global_record) + query_db "\ + INSERT INTO records (exercise_id, workout_id) + VALUES ('${exercise_id}', '${id}') + ON CONFLICT (exercise_id) + DO UPDATE SET workout_id=${id}" + + echo "Recorded new global record for '${exercise}'\ (id=${exercise_id}) (workout_id=${id})." - ;; - [0-9]*) - exercise_id="${key}" - - query_db "\ - INSERT INTO workouts_exercises (workout_id, exercise_id, value) - VALUES ('${id}', '${exercise_id}', '${val}')" - - exercise=$(query_db "\ - SELECT name - FROM exercises - WHERE id='${exercise_id}'") - echo "Recorded exercise '${exercise}' (id=${exercise_id}) for workout\ + ;; + [0-9]*) + exercise_id="${key}" + + query_db "\ + INSERT INTO workouts_exercises (workout_id, exercise_id, value) + VALUES ('${id}', '${exercise_id}', '${val}')" + + exercise=$(query_db "\ + SELECT name + FROM exercises + WHERE id='${exercise_id}'") + echo "Recorded exercise '${exercise}' (id=${exercise_id}) for workout\ (id=${id}) (value=${val})." - ;; + ;; esac done ;; -- 2.39.5