migrate job names

1 files changed, 9 insertions, 1 deletions

diff --git a/db/migrate/20150528011012_remove_unused_fields.rb b/db/migrate/20150528011012_remove_unused_fields.rb
index c8f5e89..2895169 100644
--- a/db/migrate/20150528011012_remove_unused_fields.rb
+++ b/db/migrate/20150528011012_remove_unused_fields.rb
@@ -1,5 +1,13 @@
 class RemoveUnusedFields < ActiveRecord::Migration
-  def change
+  def up
+    select_all("SELECT id, name FROM jobs").each do |job|
+      execute("UPDATE builds SET name = '#{quote_string(job["name"])}' WHERE job_id = #{job["id"]}")
+    end
+
     remove_column :builds, :job_id, :integer
   end
+
+  def down
+    add_column :builds, :job_id, :integer
+  end
 end