add-describe-the-drawing.rb

ManagedInteractive.where(library_interactive_id: 41).where("authored_state like '%\"answerPrompt\":null%' or authored_state like '%\"answerPrompt\":\"\"%'").where("legacy_ref_id is null").count

def add_describe_the_drawing
  mis_processed = 0
  managed_interactives = ManagedInteractive.where(library_interactive_id: 41).where("authored_state like '%\"answerPrompt\":null%' or authored_state like '%\"answerPrompt\":\"\"%'").where("legacy_ref_id is null")
  mis_to_process = managed_interactives.count
  managed_interactives.find_in_batches(batch_size: 100) { |batch|
    ActiveRecord::Base.transaction {
      batch.each { |mi|
        authored_state = JSON.parse(mi.authored_state)
        authored_state["answerPrompt"] = "Describe the drawing."
        mi.authored_state = authored_state.to_json
        mi.save!
        mis_processed += 1
      }
      puts "#{mis_processed} of #{mis_to_process} processed."
    }
  }
  puts "Processed #{mis_processed} of #{mis_to_process}."
end

# Generate CSV of what was modified
mis = ManagedInteractive.where(library_interactive_id: 41).where("authored_state like '%\"answerPrompt\":\"Describe the drawing.\"%' ").where("legacy_ref_id is null"); nil
output = CSV.generate { |csv| 
  mis.each{ |mi| 
    page = mi.interactive_page
    activity = page&.lightweight_activity
    next if !page || !activity
    csv << [
      mi.id, 
      activity.project&.title,
      activity.user.email,
      "https://authoring.concord.org/activities/#{activity.id}/pages/#{page.id}/edit"
    ] 
  } 
};nil