Chris@1464: class PopulateIssuesClosedOn < ActiveRecord::Migration
Chris@1464:   def up
Chris@1464:     closed_status_ids = IssueStatus.where(:is_closed => true).pluck(:id)
Chris@1464:     if closed_status_ids.any?
Chris@1464:       # First set closed_on for issues that have been closed once
Chris@1464:       closed_status_values = closed_status_ids.map {|status_id| "'#{status_id}'"}.join(',')
Chris@1464:       subselect = "SELECT MAX(#{Journal.table_name}.created_on)" +
Chris@1464:         " FROM #{Journal.table_name}, #{JournalDetail.table_name}" +
Chris@1464:         " WHERE #{Journal.table_name}.id = #{JournalDetail.table_name}.journal_id" +
Chris@1464:         " AND #{Journal.table_name}.journalized_type = 'Issue' AND #{Journal.table_name}.journalized_id = #{Issue.table_name}.id" +
Chris@1464:         " AND #{JournalDetail.table_name}.property = 'attr' AND #{JournalDetail.table_name}.prop_key = 'status_id'" +
Chris@1464:         " AND #{JournalDetail.table_name}.old_value NOT IN (#{closed_status_values})" +
Chris@1464:         " AND #{JournalDetail.table_name}.value IN (#{closed_status_values})"
Chris@1464:       Issue.update_all "closed_on = (#{subselect})"
Chris@1464: 
Chris@1464:       # Then set closed_on for closed issues that weren't up updated by the above UPDATE
Chris@1464:       # No journal was found so we assume that they were closed on creation
Chris@1464:       Issue.update_all "closed_on = created_on", {:status_id => closed_status_ids, :closed_on => nil}
Chris@1464:     end
Chris@1464:   end
Chris@1464: 
Chris@1464:   def down
Chris@1464:     Issue.update_all :closed_on => nil
Chris@1464:   end
Chris@1464: end