set-active-version.rb

#!/usr/bin/env ruby
# frozen_string_literal: true

# Usage:
#   ./bin/set-active-version <pathToVersionCSV>

puts 'Loading environment...'
require File.expand_path('../config/environment', __dir__)

require 'csv'
conn = ActiveRecord::Base.connection
versions = CSV.read(ARGV[0]).to_h
versions.each do |druid, version|
  next unless version # Don't import if it doesn't have a version
  conn.execute("UPDATE workflow_steps SET active_version = true WHERE druid = '#{druid}' AND version='#{version}'")
end