javaeye3/script/migrate_old_data/ask/2_migrate_problem_status.rb

9 lines
371 B
Ruby

#!/usr/bin/env ruby
ENV['RAILS_ENV'] ||= 'production'
require File.dirname(__FILE__) + '/../../../config/environment'
Problem.transaction do
Problem.update_all("status = '#{Problem::STATUS["待解决"]}'", "accept_at IS NULL AND (status IS NULL OR status <> 'close')")
Problem.update_all("status = '#{Problem::STATUS["用户满意"]}'", "accept_at IS NOT NULL")
end