From f47f82473799c1b177978a0f18dc6ec185fd87e1 Mon Sep 17 00:00:00 2001 From: erdgeist Date: Sun, 9 Aug 2026 23:56:20 +0200 Subject: Remove two dead rake task files cccms:mysql_to_postgres was the one-time MySQL to PostgreSQL import. It uses set_table_name and globalize_translations, removed from Rails and Globalize respectively, so it raises on its first class definition. ci:run_ci configured Integrity, a CI server this project no longer uses. It copies config/database.sqlite3-sample.yml, which does not exist, over config/database.yml, which is a live local file. --- lib/tasks/intergity.rake | 20 ------ lib/tasks/mysql_to_psql.rake | 156 ------------------------------------------- 2 files changed, 176 deletions(-) delete mode 100644 lib/tasks/intergity.rake delete mode 100644 lib/tasks/mysql_to_psql.rake (limited to 'lib') diff --git a/lib/tasks/intergity.rake b/lib/tasks/intergity.rake deleted file mode 100644 index 1336fb4a..00000000 --- a/lib/tasks/intergity.rake +++ /dev/null @@ -1,20 +0,0 @@ -namespace :ci do - task :fetch_database_config do - db_config = File.join(%w{config database.sqlite3-sample.yml}) - - FileUtils.cp db_config, File.join(%w{config database.yml}) - end - - desc "run all task necessary to build with integrity" - task :run_ci do - if :fetch_database_config && \ - system( "rake db:migrate") && \ - system( "rake db:test:clone") && \ - system( "rake test:coverage") - puts "succeeded" - else - puts "failed" - exit 1 - end - end -end \ No newline at end of file diff --git a/lib/tasks/mysql_to_psql.rake b/lib/tasks/mysql_to_psql.rake deleted file mode 100644 index 98438fd1..00000000 --- a/lib/tasks/mysql_to_psql.rake +++ /dev/null @@ -1,156 +0,0 @@ -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 -- cgit v1.3