This is a script to batch assign youtube video IDs to OSEM event GUIDs

OSEM Youtube Script

#!/usr/bin/env ruby

require File.expand_path(File.join(File.dirname(__FILE__), '..', 'config', 'environment'))

mapping = {
  "kVYMYCvraFSdnKu_qEugfg" => "jFrqHgk2258",
  "5vA7x02ejJY2hfGs3tmA8w" => "dpzVjFuKwyo" }

mapping.each do |guid, yid|
  event = Event.find_by_guid(guid)
  if event.nil? || !event.media_id.blank?
    puts "Skipping #{guid}"
    next
  end
  puts "Updating #{guid}"
  event.update_column(:media_id, yid)
end