aboutsummaryrefslogtreecommitdiffstats
path: root/db/migrate/022_create_info_request_events.rb
blob: 858444298742eded1b7e49c20e0b28c5386dc51f (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
class CreateInfoRequestEvents < ActiveRecord::Migration
    def self.up
        create_table :info_request_events do |t|
            t.column "info_request_id", :integer
            t.column :event_type, :text
            t.column :params_yaml, :text
            t.column :created_at, :datetime
        end

        # Create the missing events for requests already sent
        InfoRequest.find(:all).each do |info_request|
            info_request_event = InfoRequestEvent.new
            info_request_event.event_type = 'sent'
            info_request_event.params = { :email => info_request.recipient_email, :outgoing_message_id => info_request.outgoing_messages[0].id }
            info_request_event.info_request = info_request
            info_request_event.created_at = info_request.outgoing_messages[0].sent_at
            info_request_event.save!
        end
    end

    def self.down
        drop_table :info_request_events
    end
end