blob: 98438fd1acf9a5483b71c1c3cbe29a4ad7395391 (
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
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
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
|
