From cf37d090d536d6d5a685aa75f589a3e3dc816472 Mon Sep 17 00:00:00 2001 From: Petteri Räty Date: Sat, 12 Mar 2011 21:37:15 +0200 Subject: Preserve existing categories When migrating to many to many question categories bring over the existing category information. --- db/migrate/20110312181715_add_question_category_pivot.rb | 3 +++ 1 file changed, 3 insertions(+) diff --git a/db/migrate/20110312181715_add_question_category_pivot.rb b/db/migrate/20110312181715_add_question_category_pivot.rb index ef1a810..c71032d 100644 --- a/db/migrate/20110312181715_add_question_category_pivot.rb +++ b/db/migrate/20110312181715_add_question_category_pivot.rb @@ -6,6 +6,9 @@ class AddQuestionCategoryPivot < ActiveRecord::Migration end add_index :question_categories, [:question_id, :category_id], :unique => true + execute 'INSERT INTO question_categories (question_id, category_id) + SELECT id, category_id FROM questions WHERE category_id IS NOT NULL' + remove_column :questions, :category_id remove_index :questions, :name => :index_questions_on_category_id rescue ActiveRecord::StatementInvalid -- cgit v1.2.3-65-gdbad