1class MigrateToExerciseSets < ActiveRecord::Migration
 2  def up
 3    execute("SELECT * FROM exercise_sessions").each do |exercise_session|
 4      actual_sets = exercise_session["actual_sets"].gsub(/[{}]|NULL/, '').split(',').map(&:to_i)
 5      actual_sets.each do |n|
 6        say "Creating set for: #{exercise_session["name"]}: set: #{n}"
 7
 8        workout_id = exercise_session["exercise_workout_id"]
 9        target_reps = execute("SELECT repetitions FROM exercise_workouts where id = '#{workout_id}'").first["repetitions"].to_i
10        ExerciseSet.create!(
11          exercise_session_id: exercise_session["id"],
12          actual_repetitions: n,
13          target_repetitions: target_reps,
14          target_weight: exercise_session["target_weight"],
15        )
16      end
17    end
18  end
19
20  def down
21    ExerciseSet.delete_all
22  end
23end