summaryrefslogtreecommitdiff
path: root/db/migrate/20140907220153_serialize_service_properties.rb
blob: bf94c64654b3ed80f932384d6770ef1b4e4044db (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
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
# rubocop:disable all
class SerializeServiceProperties < ActiveRecord::Migration[4.2]
  def change
    unless column_exists?(:services, :properties)
      add_column :services, :properties, :text
    end

    Service.reset_column_information

    associations =
    {
      AssemblaService:        [:token, :subdomain],
      CampfireService:        [:token, :subdomain, :room],
      EmailsOnPushService:    [:recipients],
      FlowdockService:        [:token],
      GemnasiumService:       [:api_key, :token],
      GitlabCiService:        [:token, :project_url],
      HipchatService:         [:token, :room],
      PivotaltrackerService:  [:token],
      SlackService:           [:subdomain, :token, :room],
      JenkinsService:         [:project_url],
      JiraService:            [:project_url, :username, :password,
                               :api_version, :jira_issue_transition_id],
    }

    Service.find_each(batch_size: 500).each do |service|
      associations[service.type.to_sym].each do |attribute|
        service.send("#{attribute}=", service.attributes[attribute.to_s])
      end

      service.save(validate: false)
    end

    if column_exists?(:services, :project_url)
      remove_column :services, :project_url, :string
      remove_column :services, :subdomain, :string
      remove_column :services, :room, :string
      remove_column :services, :recipients, :text
      remove_column :services, :api_key, :string
      remove_column :services, :token, :string
    end
  end
end