preparing for postgres migration. adding rake task for conversion

1 files changed, 156 insertions, 0 deletions

diff --git a/lib/tasks/mysql_to_psql.rake b/lib/tasks/mysql_to_psql.rake
new file mode 100644
index 0000000..98438fd
--- /dev/null
+++ b/lib/tasks/mysql_to_psql.rake
@@ -0,0 +1,156 @@
+namespace :cccms do
+  
+  desc "Import a cccms mysql dump into an external postgres db"
+  
+  task :mysql_to_postgres => :environment do
+    
+    $connection_options = {
+      :adapter => "postgresql",
+      :encoding => "unicode",
+      :host => "localhost",
+      :username => "rails",
+      :password => "r3v0lution",
+      :database => "cccms_dev"
+    }
+    
+    class PGUser < ActiveRecord::Base
+      self.establish_connection($connection_options)
+      set_table_name "users"
+    end
+    
+    class PGNode < ActiveRecord::Base
+      self.establish_connection($connection_options)
+      set_table_name "nodes"
+    end
+    
+    class PGPage < ActiveRecord::Base
+      self.establish_connection($connection_options)
+      set_table_name "pages"
+    end
+    
+    class PGPageTranslation < ActiveRecord::Base
+      self.establish_connection($connection_options)
+      set_table_name "page_translations"
+    end
+    
+    class PGEvent < ActiveRecord::Base
+      self.establish_connection($connection_options)
+      set_table_name "events"
+    end
+    
+    class PGMenuItem < ActiveRecord::Base
+      self.establish_connection($connection_options)
+      set_table_name "menu_items"
+    end
+    
+    class PGMenuItemTranslation < ActiveRecord::Base
+      self.establish_connection($connection_options)
+      set_table_name "menu_item_translations"
+    end
+    
+    class PGOccurrence < ActiveRecord::Base
+      self.establish_connection($connection_options)
+      set_table_name "occurrences"
+    end
+    
+    class PGTag < ActiveRecord::Base
+      self.establish_connection($connection_options)
+      set_table_name "tags"
+    end
+    
+    class PGTagging < ActiveRecord::Base
+      self.establish_connection($connection_options)
+      set_table_name "taggings"
+    end
+    
+    PGUser.delete_all
+    PGNode.delete_all
+    PGPage.delete_all
+    PGPageTranslation.delete_all
+    PGEvent.delete_all
+    PGMenuItem.delete_all
+    PGMenuItemTranslation.delete_all
+    PGOccurrence.delete_all
+    PGTag.delete_all
+    PGTagging.delete_all
+    
+    User.all.each do |user|
+      PGUser.create! user.attributes
+    end
+    
+    Tag.all.each do |tag|
+      PGTag.create tag.attributes
+    end
+    
+    Node.all.each do |node|
+      
+      pg_node = PGNode.new node.attributes
+      pg_node.locking_user_id = nil
+      pg_node.save!
+      puts "PGNode #{pg_node.unique_name} created"
+      
+      if node.event
+        pg_event = PGEvent.new node.event.attributes
+        pg_event.node_id = pg_node.id
+        pg_event.save
+        puts "PGEvent created"
+      end
+      
+      node.pages.each do |page|
+        pg_page = PGPage.create!( page.attributes )
+        pg_page.node_id = PGNode.find_by_unique_name(node.unique_name).id
+        pg_page.user_id = PGUser.find_by_login(page.user.login).id rescue PGUser.first.id
+        pg_page.save
+        puts "PGPage created"
+        
+        page.tags.each do |tag|
+          pg_tagging = PGTagging.create(
+            :tag_id         => PGTag.find_by_name(tag.name).id,
+            :taggable_id    => pg_page.id,
+            :taggable_type  => "Page"
+          )
+        end
+        
+        if node.head && page.id == node.head.id
+          pg_node.head_id = pg_page.id
+          pg_node.save
+          puts "======================Head applied #{pg_page.id}"
+        end
+        
+        if node.draft && page.id == node.draft.id
+          pg_node.draft_id = pg_page.id
+          pg_node.save
+          puts "Draft applied"
+        end
+        
+        page.globalize_translations.each do |trans|
+          pg_page_trans = PGPageTranslation.new trans.attributes
+          pg_page_trans.page_id = pg_page.id
+          pg_page_trans.save
+          puts "PGPageTranslation created"
+        end
+      end
+    end
+    
+    
+    MenuItem.all.each do |item|
+      pg_menu_item = PGMenuItem.new item.attributes
+      pg_menu_item.node_id = Node.find(item.node_id).id
+      pg_menu_item.save
+      puts "PGMenuItem created"
+      
+      item.globalize_translations.each do |trans|
+        pg_menu_item_trans = PGMenuItemTranslation.new trans.attributes
+        pg_menu_item_trans.menu_item_id = item.id
+        pg_menu_item_trans.save
+        puts "PGMenuItemTranslation created"
+      end
+    end
+    
+    
+    puts  "Now recreate Occurrences by running " \
+          "Event.all.each {|x| Occurrence.generate(x)} in script/console"
+    
+  end
+  
+end
\ No newline at end of file