##// END OF EJS Templates
jro_apps » redmine
RSS
Same as fix as r2705 from Trac wiki pages attachments (#3291)....
Jean-Philippe Lang -
r2620:7e1ac0e602a8
parent child
Show More
Side by Side Unified
Context file:
r2620:7e1ac0e602a8 Loading diff...:
Show file before | Show file after | Hide comments
@@ -1,762 +1,764
1 # redMine - project management software
1 # redMine - project management software
2 # Copyright (C) 2006-2007 Jean-Philippe Lang
2 # Copyright (C) 2006-2007 Jean-Philippe Lang
3 #
3 #
4 # This program is free software; you can redistribute it and/or
4 # This program is free software; you can redistribute it and/or
5 # modify it under the terms of the GNU General Public License
5 # modify it under the terms of the GNU General Public License
6 # as published by the Free Software Foundation; either version 2
6 # as published by the Free Software Foundation; either version 2
7 # of the License, or (at your option) any later version.
7 # of the License, or (at your option) any later version.
8 #
8 #
9 # This program is distributed in the hope that it will be useful,
9 # This program is distributed in the hope that it will be useful,
10 # but WITHOUT ANY WARRANTY; without even the implied warranty of
10 # but WITHOUT ANY WARRANTY; without even the implied warranty of
11 # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
11 # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
12 # GNU General Public License for more details.
12 # GNU General Public License for more details.
13 #
13 #
14 # You should have received a copy of the GNU General Public License
14 # You should have received a copy of the GNU General Public License
15 # along with this program; if not, write to the Free Software
15 # along with this program; if not, write to the Free Software
16 # Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA.
16 # Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA.
17
17
18 require 'active_record'
18 require 'active_record'
19 require 'iconv'
19 require 'iconv'
20 require 'pp'
20 require 'pp'
21
21
22 namespace :redmine do
22 namespace :redmine do
23 desc 'Trac migration script'
23 desc 'Trac migration script'
24 task :migrate_from_trac => :environment do
24 task :migrate_from_trac => :environment do
25
25
26 module TracMigrate
26 module TracMigrate
27 TICKET_MAP = []
27 TICKET_MAP = []
28
28
29 DEFAULT_STATUS = IssueStatus.default
29 DEFAULT_STATUS = IssueStatus.default
30 assigned_status = IssueStatus.find_by_position(2)
30 assigned_status = IssueStatus.find_by_position(2)
31 resolved_status = IssueStatus.find_by_position(3)
31 resolved_status = IssueStatus.find_by_position(3)
32 feedback_status = IssueStatus.find_by_position(4)
32 feedback_status = IssueStatus.find_by_position(4)
33 closed_status = IssueStatus.find :first, :conditions => { :is_closed => true }
33 closed_status = IssueStatus.find :first, :conditions => { :is_closed => true }
34 STATUS_MAPPING = {'new' => DEFAULT_STATUS,
34 STATUS_MAPPING = {'new' => DEFAULT_STATUS,
35 'reopened' => feedback_status,
35 'reopened' => feedback_status,
36 'assigned' => assigned_status,
36 'assigned' => assigned_status,
37 'closed' => closed_status
37 'closed' => closed_status
38 }
38 }
39
39
40 priorities = Enumeration.priorities
40 priorities = Enumeration.priorities
41 DEFAULT_PRIORITY = priorities[0]
41 DEFAULT_PRIORITY = priorities[0]
42 PRIORITY_MAPPING = {'lowest' => priorities[0],
42 PRIORITY_MAPPING = {'lowest' => priorities[0],
43 'low' => priorities[0],
43 'low' => priorities[0],
44 'normal' => priorities[1],
44 'normal' => priorities[1],
45 'high' => priorities[2],
45 'high' => priorities[2],
46 'highest' => priorities[3],
46 'highest' => priorities[3],
47 # ---
47 # ---
48 'trivial' => priorities[0],
48 'trivial' => priorities[0],
49 'minor' => priorities[1],
49 'minor' => priorities[1],
50 'major' => priorities[2],
50 'major' => priorities[2],
51 'critical' => priorities[3],
51 'critical' => priorities[3],
52 'blocker' => priorities[4]
52 'blocker' => priorities[4]
53 }
53 }
54
54
55 TRACKER_BUG = Tracker.find_by_position(1)
55 TRACKER_BUG = Tracker.find_by_position(1)
56 TRACKER_FEATURE = Tracker.find_by_position(2)
56 TRACKER_FEATURE = Tracker.find_by_position(2)
57 DEFAULT_TRACKER = TRACKER_BUG
57 DEFAULT_TRACKER = TRACKER_BUG
58 TRACKER_MAPPING = {'defect' => TRACKER_BUG,
58 TRACKER_MAPPING = {'defect' => TRACKER_BUG,
59 'enhancement' => TRACKER_FEATURE,
59 'enhancement' => TRACKER_FEATURE,
60 'task' => TRACKER_FEATURE,
60 'task' => TRACKER_FEATURE,
61 'patch' =>TRACKER_FEATURE
61 'patch' =>TRACKER_FEATURE
62 }
62 }
63
63
64 roles = Role.find(:all, :conditions => {:builtin => 0}, :order => 'position ASC')
64 roles = Role.find(:all, :conditions => {:builtin => 0}, :order => 'position ASC')
65 manager_role = roles[0]
65 manager_role = roles[0]
66 developer_role = roles[1]
66 developer_role = roles[1]
67 DEFAULT_ROLE = roles.last
67 DEFAULT_ROLE = roles.last
68 ROLE_MAPPING = {'admin' => manager_role,
68 ROLE_MAPPING = {'admin' => manager_role,
69 'developer' => developer_role
69 'developer' => developer_role
70 }
70 }
71
71
72 class ::Time
72 class ::Time
73 class << self
73 class << self
74 alias :real_now :now
74 alias :real_now :now
75 def now
75 def now
76 real_now - @fake_diff.to_i
76 real_now - @fake_diff.to_i
77 end
77 end
78 def fake(time)
78 def fake(time)
79 @fake_diff = real_now - time
79 @fake_diff = real_now - time
80 res = yield
80 res = yield
81 @fake_diff = 0
81 @fake_diff = 0
82 res
82 res
83 end
83 end
84 end
84 end
85 end
85 end
86
86
87 class TracComponent < ActiveRecord::Base
87 class TracComponent < ActiveRecord::Base
88 set_table_name :component
88 set_table_name :component
89 end
89 end
90
90
91 class TracMilestone < ActiveRecord::Base
91 class TracMilestone < ActiveRecord::Base
92 set_table_name :milestone
92 set_table_name :milestone
93 # If this attribute is set a milestone has a defined target timepoint
93 # If this attribute is set a milestone has a defined target timepoint
94 def due
94 def due
95 if read_attribute(:due) && read_attribute(:due) > 0
95 if read_attribute(:due) && read_attribute(:due) > 0
96 Time.at(read_attribute(:due)).to_date
96 Time.at(read_attribute(:due)).to_date
97 else
97 else
98 nil
98 nil
99 end
99 end
100 end
100 end
101 # This is the real timepoint at which the milestone has finished.
101 # This is the real timepoint at which the milestone has finished.
102 def completed
102 def completed
103 if read_attribute(:completed) && read_attribute(:completed) > 0
103 if read_attribute(:completed) && read_attribute(:completed) > 0
104 Time.at(read_attribute(:completed)).to_date
104 Time.at(read_attribute(:completed)).to_date
105 else
105 else
106 nil
106 nil
107 end
107 end
108 end
108 end
109
109
110 def description
110 def description
111 # Attribute is named descr in Trac v0.8.x
111 # Attribute is named descr in Trac v0.8.x
112 has_attribute?(:descr) ? read_attribute(:descr) : read_attribute(:description)
112 has_attribute?(:descr) ? read_attribute(:descr) : read_attribute(:description)
113 end
113 end
114 end
114 end
115
115
116 class TracTicketCustom < ActiveRecord::Base
116 class TracTicketCustom < ActiveRecord::Base
117 set_table_name :ticket_custom
117 set_table_name :ticket_custom
118 end
118 end
119
119
120 class TracAttachment < ActiveRecord::Base
120 class TracAttachment < ActiveRecord::Base
121 set_table_name :attachment
121 set_table_name :attachment
122 set_inheritance_column :none
122 set_inheritance_column :none
123
123
124 def time; Time.at(read_attribute(:time)) end
124 def time; Time.at(read_attribute(:time)) end
125
125
126 def original_filename
126 def original_filename
127 filename
127 filename
128 end
128 end
129
129
130 def content_type
130 def content_type
131 Redmine::MimeType.of(filename) || ''
131 Redmine::MimeType.of(filename) || ''
132 end
132 end
133
133
134 def exist?
134 def exist?
135 File.file? trac_fullpath
135 File.file? trac_fullpath
136 end
136 end
137
137
138 def open
138 def open
139 File.open("#{trac_fullpath}", 'rb') {|f|
139 File.open("#{trac_fullpath}", 'rb') {|f|
140 @file = f
140 @file = f
141 yield self
141 yield self
142 }
142 }
143 end
143 end
144
144
145 def read(*args)
145 def read(*args)
146 @file.read(*args)
146 @file.read(*args)
147 end
147 end
148
148
149 def description
149 def description
150 read_attribute(:description).to_s.slice(0,255)
150 read_attribute(:description).to_s.slice(0,255)
151 end
151 end
152
152
153 private
153 private
154 def trac_fullpath
154 def trac_fullpath
155 attachment_type = read_attribute(:type)
155 attachment_type = read_attribute(:type)
156 trac_file = filename.gsub( /[^a-zA-Z0-9\-_\.!~*']/n ) {|x| sprintf('%%%02x', x[0]) }
156 trac_file = filename.gsub( /[^a-zA-Z0-9\-_\.!~*']/n ) {|x| sprintf('%%%02x', x[0]) }
157 "#{TracMigrate.trac_attachments_directory}/#{attachment_type}/#{id}/#{trac_file}"
157 "#{TracMigrate.trac_attachments_directory}/#{attachment_type}/#{id}/#{trac_file}"
158 end
158 end
159 end
159 end
160
160
161 class TracTicket < ActiveRecord::Base
161 class TracTicket < ActiveRecord::Base
162 set_table_name :ticket
162 set_table_name :ticket
163 set_inheritance_column :none
163 set_inheritance_column :none
164
164
165 # ticket changes: only migrate status changes and comments
165 # ticket changes: only migrate status changes and comments
166 has_many :changes, :class_name => "TracTicketChange", :foreign_key => :ticket
166 has_many :changes, :class_name => "TracTicketChange", :foreign_key => :ticket
167 has_many :attachments, :class_name => "TracAttachment",
167 has_many :attachments, :class_name => "TracAttachment",
168 :finder_sql => "SELECT DISTINCT attachment.* FROM #{TracMigrate::TracAttachment.table_name}" +
168 :finder_sql => "SELECT DISTINCT attachment.* FROM #{TracMigrate::TracAttachment.table_name}" +
169 " WHERE #{TracMigrate::TracAttachment.table_name}.type = 'ticket'" +
169 " WHERE #{TracMigrate::TracAttachment.table_name}.type = 'ticket'" +
170 ' AND #{TracMigrate::TracAttachment.table_name}.id = \'#{id}\''
170 ' AND #{TracMigrate::TracAttachment.table_name}.id = \'#{id}\''
171 has_many :customs, :class_name => "TracTicketCustom", :foreign_key => :ticket
171 has_many :customs, :class_name => "TracTicketCustom", :foreign_key => :ticket
172
172
173 def ticket_type
173 def ticket_type
174 read_attribute(:type)
174 read_attribute(:type)
175 end
175 end
176
176
177 def summary
177 def summary
178 read_attribute(:summary).blank? ? "(no subject)" : read_attribute(:summary)
178 read_attribute(:summary).blank? ? "(no subject)" : read_attribute(:summary)
179 end
179 end
180
180
181 def description
181 def description
182 read_attribute(:description).blank? ? summary : read_attribute(:description)
182 read_attribute(:description).blank? ? summary : read_attribute(:description)
183 end
183 end
184
184
185 def time; Time.at(read_attribute(:time)) end
185 def time; Time.at(read_attribute(:time)) end
186 def changetime; Time.at(read_attribute(:changetime)) end
186 def changetime; Time.at(read_attribute(:changetime)) end
187 end
187 end
188
188
189 class TracTicketChange < ActiveRecord::Base
189 class TracTicketChange < ActiveRecord::Base
190 set_table_name :ticket_change
190 set_table_name :ticket_change
191
191
192 def time; Time.at(read_attribute(:time)) end
192 def time; Time.at(read_attribute(:time)) end
193 end
193 end
194
194
195 TRAC_WIKI_PAGES = %w(InterMapTxt InterTrac InterWiki RecentChanges SandBox TracAccessibility TracAdmin TracBackup TracBrowser TracCgi TracChangeset \
195 TRAC_WIKI_PAGES = %w(InterMapTxt InterTrac InterWiki RecentChanges SandBox TracAccessibility TracAdmin TracBackup TracBrowser TracCgi TracChangeset \
196 TracEnvironment TracFastCgi TracGuide TracImport TracIni TracInstall TracInterfaceCustomization \
196 TracEnvironment TracFastCgi TracGuide TracImport TracIni TracInstall TracInterfaceCustomization \
197 TracLinks TracLogging TracModPython TracNotification TracPermissions TracPlugins TracQuery \
197 TracLinks TracLogging TracModPython TracNotification TracPermissions TracPlugins TracQuery \
198 TracReports TracRevisionLog TracRoadmap TracRss TracSearch TracStandalone TracSupport TracSyntaxColoring TracTickets \
198 TracReports TracRevisionLog TracRoadmap TracRss TracSearch TracStandalone TracSupport TracSyntaxColoring TracTickets \
199 TracTicketsCustomFields TracTimeline TracUnicode TracUpgrade TracWiki WikiDeletePage WikiFormatting \
199 TracTicketsCustomFields TracTimeline TracUnicode TracUpgrade TracWiki WikiDeletePage WikiFormatting \
200 WikiHtml WikiMacros WikiNewPage WikiPageNames WikiProcessors WikiRestructuredText WikiRestructuredTextLinks \
200 WikiHtml WikiMacros WikiNewPage WikiPageNames WikiProcessors WikiRestructuredText WikiRestructuredTextLinks \
201 CamelCase TitleIndex)
201 CamelCase TitleIndex)
202
202
203 class TracWikiPage < ActiveRecord::Base
203 class TracWikiPage < ActiveRecord::Base
204 set_table_name :wiki
204 set_table_name :wiki
205 set_primary_key :name
205 set_primary_key :name
206
206
207 has_many :attachments, :class_name => "TracAttachment",
207 has_many :attachments, :class_name => "TracAttachment",
208 :finder_sql => "SELECT DISTINCT attachment.* FROM #{TracMigrate::TracAttachment.table_name}" +
208 :finder_sql => "SELECT DISTINCT attachment.* FROM #{TracMigrate::TracAttachment.table_name}" +
209 " WHERE #{TracMigrate::TracAttachment.table_name}.type = 'wiki'" +
209 " WHERE #{TracMigrate::TracAttachment.table_name}.type = 'wiki'" +
210 ' AND #{TracMigrate::TracAttachment.table_name}.id = \'#{id}\''
210 ' AND #{TracMigrate::TracAttachment.table_name}.id = \'#{id}\''
211
211
212 def self.columns
212 def self.columns
213 # Hides readonly Trac field to prevent clash with AR readonly? method (Rails 2.0)
213 # Hides readonly Trac field to prevent clash with AR readonly? method (Rails 2.0)
214 super.select {|column| column.name.to_s != 'readonly'}
214 super.select {|column| column.name.to_s != 'readonly'}
215 end
215 end
216
216
217 def time; Time.at(read_attribute(:time)) end
217 def time; Time.at(read_attribute(:time)) end
218 end
218 end
219
219
220 class TracPermission < ActiveRecord::Base
220 class TracPermission < ActiveRecord::Base
221 set_table_name :permission
221 set_table_name :permission
222 end
222 end
223
223
224 class TracSessionAttribute < ActiveRecord::Base
224 class TracSessionAttribute < ActiveRecord::Base
225 set_table_name :session_attribute
225 set_table_name :session_attribute
226 end
226 end
227
227
228 def self.find_or_create_user(username, project_member = false)
228 def self.find_or_create_user(username, project_member = false)
229 return User.anonymous if username.blank?
229 return User.anonymous if username.blank?
230
230
231 u = User.find_by_login(username)
231 u = User.find_by_login(username)
232 if !u
232 if !u
233 # Create a new user if not found
233 # Create a new user if not found
234 mail = username[0,limit_for(User, 'mail')]
234 mail = username[0,limit_for(User, 'mail')]
235 if mail_attr = TracSessionAttribute.find_by_sid_and_name(username, 'email')
235 if mail_attr = TracSessionAttribute.find_by_sid_and_name(username, 'email')
236 mail = mail_attr.value
236 mail = mail_attr.value
237 end
237 end
238 mail = "#{mail}@foo.bar" unless mail.include?("@")
238 mail = "#{mail}@foo.bar" unless mail.include?("@")
239
239
240 name = username
240 name = username
241 if name_attr = TracSessionAttribute.find_by_sid_and_name(username, 'name')
241 if name_attr = TracSessionAttribute.find_by_sid_and_name(username, 'name')
242 name = name_attr.value
242 name = name_attr.value
243 end
243 end
244 name =~ (/(.*)(\s+\w+)?/)
244 name =~ (/(.*)(\s+\w+)?/)
245 fn = $1.strip
245 fn = $1.strip
246 ln = ($2 || '-').strip
246 ln = ($2 || '-').strip
247
247
248 u = User.new :mail => mail.gsub(/[^-@a-z0-9\.]/i, '-'),
248 u = User.new :mail => mail.gsub(/[^-@a-z0-9\.]/i, '-'),
249 :firstname => fn[0, limit_for(User, 'firstname')].gsub(/[^\w\s\'\-]/i, '-'),
249 :firstname => fn[0, limit_for(User, 'firstname')].gsub(/[^\w\s\'\-]/i, '-'),
250 :lastname => ln[0, limit_for(User, 'lastname')].gsub(/[^\w\s\'\-]/i, '-')
250 :lastname => ln[0, limit_for(User, 'lastname')].gsub(/[^\w\s\'\-]/i, '-')
251
251
252 u.login = username[0,limit_for(User, 'login')].gsub(/[^a-z0-9_\-@\.]/i, '-')
252 u.login = username[0,limit_for(User, 'login')].gsub(/[^a-z0-9_\-@\.]/i, '-')
253 u.password = 'trac'
253 u.password = 'trac'
254 u.admin = true if TracPermission.find_by_username_and_action(username, 'admin')
254 u.admin = true if TracPermission.find_by_username_and_action(username, 'admin')
255 # finally, a default user is used if the new user is not valid
255 # finally, a default user is used if the new user is not valid
256 u = User.find(:first) unless u.save
256 u = User.find(:first) unless u.save
257 end
257 end
258 # Make sure he is a member of the project
258 # Make sure he is a member of the project
259 if project_member && !u.member_of?(@target_project)
259 if project_member && !u.member_of?(@target_project)
260 role = DEFAULT_ROLE
260 role = DEFAULT_ROLE
261 if u.admin
261 if u.admin
262 role = ROLE_MAPPING['admin']
262 role = ROLE_MAPPING['admin']
263 elsif TracPermission.find_by_username_and_action(username, 'developer')
263 elsif TracPermission.find_by_username_and_action(username, 'developer')
264 role = ROLE_MAPPING['developer']
264 role = ROLE_MAPPING['developer']
265 end
265 end
266 Member.create(:user => u, :project => @target_project, :role => role)
266 Member.create(:user => u, :project => @target_project, :role => role)
267 u.reload
267 u.reload
268 end
268 end
269 u
269 u
270 end
270 end
271
271
272 # Basic wiki syntax conversion
272 # Basic wiki syntax conversion
273 def self.convert_wiki_text(text)
273 def self.convert_wiki_text(text)
274 # Titles
274 # Titles
275 text = text.gsub(/^(\=+)\s(.+)\s(\=+)/) {|s| "\nh#{$1.length}. #{$2}\n"}
275 text = text.gsub(/^(\=+)\s(.+)\s(\=+)/) {|s| "\nh#{$1.length}. #{$2}\n"}
276 # External Links
276 # External Links
277 text = text.gsub(/\[(http[^\s]+)\s+([^\]]+)\]/) {|s| "\"#{$2}\":#{$1}"}
277 text = text.gsub(/\[(http[^\s]+)\s+([^\]]+)\]/) {|s| "\"#{$2}\":#{$1}"}
278 # Ticket links:
278 # Ticket links:
279 # [ticket:234 Text],[ticket:234 This is a test]
279 # [ticket:234 Text],[ticket:234 This is a test]
280 text = text.gsub(/\[ticket\:([^\ ]+)\ (.+?)\]/, '"\2":/issues/show/\1')
280 text = text.gsub(/\[ticket\:([^\ ]+)\ (.+?)\]/, '"\2":/issues/show/\1')
281 # ticket:1234
281 # ticket:1234
282 # #1 is working cause Redmine uses the same syntax.
282 # #1 is working cause Redmine uses the same syntax.
283 text = text.gsub(/ticket\:([^\ ]+)/, '#\1')
283 text = text.gsub(/ticket\:([^\ ]+)/, '#\1')
284 # Milestone links:
284 # Milestone links:
285 # [milestone:"0.1.0 Mercury" Milestone 0.1.0 (Mercury)]
285 # [milestone:"0.1.0 Mercury" Milestone 0.1.0 (Mercury)]
286 # The text "Milestone 0.1.0 (Mercury)" is not converted,
286 # The text "Milestone 0.1.0 (Mercury)" is not converted,
287 # cause Redmine's wiki does not support this.
287 # cause Redmine's wiki does not support this.
288 text = text.gsub(/\[milestone\:\"([^\"]+)\"\ (.+?)\]/, 'version:"\1"')
288 text = text.gsub(/\[milestone\:\"([^\"]+)\"\ (.+?)\]/, 'version:"\1"')
289 # [milestone:"0.1.0 Mercury"]
289 # [milestone:"0.1.0 Mercury"]
290 text = text.gsub(/\[milestone\:\"([^\"]+)\"\]/, 'version:"\1"')
290 text = text.gsub(/\[milestone\:\"([^\"]+)\"\]/, 'version:"\1"')
291 text = text.gsub(/milestone\:\"([^\"]+)\"/, 'version:"\1"')
291 text = text.gsub(/milestone\:\"([^\"]+)\"/, 'version:"\1"')
292 # milestone:0.1.0
292 # milestone:0.1.0
293 text = text.gsub(/\[milestone\:([^\ ]+)\]/, 'version:\1')
293 text = text.gsub(/\[milestone\:([^\ ]+)\]/, 'version:\1')
294 text = text.gsub(/milestone\:([^\ ]+)/, 'version:\1')
294 text = text.gsub(/milestone\:([^\ ]+)/, 'version:\1')
295 # Internal Links
295 # Internal Links
296 text = text.gsub(/\[\[BR\]\]/, "\n") # This has to go before the rules below
296 text = text.gsub(/\[\[BR\]\]/, "\n") # This has to go before the rules below
297 text = text.gsub(/\[\"(.+)\".*\]/) {|s| "[[#{$1.delete(',./?;|:')}]]"}
297 text = text.gsub(/\[\"(.+)\".*\]/) {|s| "[[#{$1.delete(',./?;|:')}]]"}
298 text = text.gsub(/\[wiki:\"(.+)\".*\]/) {|s| "[[#{$1.delete(',./?;|:')}]]"}
298 text = text.gsub(/\[wiki:\"(.+)\".*\]/) {|s| "[[#{$1.delete(',./?;|:')}]]"}
299 text = text.gsub(/\[wiki:\"(.+)\".*\]/) {|s| "[[#{$1.delete(',./?;|:')}]]"}
299 text = text.gsub(/\[wiki:\"(.+)\".*\]/) {|s| "[[#{$1.delete(',./?;|:')}]]"}
300 text = text.gsub(/\[wiki:([^\s\]]+)\]/) {|s| "[[#{$1.delete(',./?;|:')}]]"}
300 text = text.gsub(/\[wiki:([^\s\]]+)\]/) {|s| "[[#{$1.delete(',./?;|:')}]]"}
301 text = text.gsub(/\[wiki:([^\s\]]+)\s(.*)\]/) {|s| "[[#{$1.delete(',./?;|:')}|#{$2.delete(',./?;|:')}]]"}
301 text = text.gsub(/\[wiki:([^\s\]]+)\s(.*)\]/) {|s| "[[#{$1.delete(',./?;|:')}|#{$2.delete(',./?;|:')}]]"}
302
302
303 # Links to pages UsingJustWikiCaps
303 # Links to pages UsingJustWikiCaps
304 text = text.gsub(/([^!]|^)(^| )([A-Z][a-z]+[A-Z][a-zA-Z]+)/, '\\1\\2[[\3]]')
304 text = text.gsub(/([^!]|^)(^| )([A-Z][a-z]+[A-Z][a-zA-Z]+)/, '\\1\\2[[\3]]')
305 # Normalize things that were supposed to not be links
305 # Normalize things that were supposed to not be links
306 # like !NotALink
306 # like !NotALink
307 text = text.gsub(/(^| )!([A-Z][A-Za-z]+)/, '\1\2')
307 text = text.gsub(/(^| )!([A-Z][A-Za-z]+)/, '\1\2')
308 # Revisions links
308 # Revisions links
309 text = text.gsub(/\[(\d+)\]/, 'r\1')
309 text = text.gsub(/\[(\d+)\]/, 'r\1')
310 # Ticket number re-writing
310 # Ticket number re-writing
311 text = text.gsub(/#(\d+)/) do |s|
311 text = text.gsub(/#(\d+)/) do |s|
312 if $1.length < 10
312 if $1.length < 10
313 TICKET_MAP[$1.to_i] ||= $1
313 TICKET_MAP[$1.to_i] ||= $1
314 "\##{TICKET_MAP[$1.to_i] || $1}"
314 "\##{TICKET_MAP[$1.to_i] || $1}"
315 else
315 else
316 s
316 s
317 end
317 end
318 end
318 end
319 # We would like to convert the Code highlighting too
319 # We would like to convert the Code highlighting too
320 # This will go into the next line.
320 # This will go into the next line.
321 shebang_line = false
321 shebang_line = false
322 # Reguar expression for start of code
322 # Reguar expression for start of code
323 pre_re = /\{\{\{/
323 pre_re = /\{\{\{/
324 # Code hightlighing...
324 # Code hightlighing...
325 shebang_re = /^\#\!([a-z]+)/
325 shebang_re = /^\#\!([a-z]+)/
326 # Regular expression for end of code
326 # Regular expression for end of code
327 pre_end_re = /\}\}\}/
327 pre_end_re = /\}\}\}/
328
328
329 # Go through the whole text..extract it line by line
329 # Go through the whole text..extract it line by line
330 text = text.gsub(/^(.*)$/) do |line|
330 text = text.gsub(/^(.*)$/) do |line|
331 m_pre = pre_re.match(line)
331 m_pre = pre_re.match(line)
332 if m_pre
332 if m_pre
333 line = '<pre>'
333 line = '<pre>'
334 else
334 else
335 m_sl = shebang_re.match(line)
335 m_sl = shebang_re.match(line)
336 if m_sl
336 if m_sl
337 shebang_line = true
337 shebang_line = true
338 line = '<code class="' + m_sl[1] + '">'
338 line = '<code class="' + m_sl[1] + '">'
339 end
339 end
340 m_pre_end = pre_end_re.match(line)
340 m_pre_end = pre_end_re.match(line)
341 if m_pre_end
341 if m_pre_end
342 line = '</pre>'
342 line = '</pre>'
343 if shebang_line
343 if shebang_line
344 line = '</code>' + line
344 line = '</code>' + line
345 end
345 end
346 end
346 end
347 end
347 end
348 line
348 line
349 end
349 end
350
350
351 # Highlighting
351 # Highlighting
352 text = text.gsub(/'''''([^\s])/, '_*\1')
352 text = text.gsub(/'''''([^\s])/, '_*\1')
353 text = text.gsub(/([^\s])'''''/, '\1*_')
353 text = text.gsub(/([^\s])'''''/, '\1*_')
354 text = text.gsub(/'''/, '*')
354 text = text.gsub(/'''/, '*')
355 text = text.gsub(/''/, '_')
355 text = text.gsub(/''/, '_')
356 text = text.gsub(/__/, '+')
356 text = text.gsub(/__/, '+')
357 text = text.gsub(/~~/, '-')
357 text = text.gsub(/~~/, '-')
358 text = text.gsub(/`/, '@')
358 text = text.gsub(/`/, '@')
359 text = text.gsub(/,,/, '~')
359 text = text.gsub(/,,/, '~')
360 # Lists
360 # Lists
361 text = text.gsub(/^([ ]+)\* /) {|s| '*' * $1.length + " "}
361 text = text.gsub(/^([ ]+)\* /) {|s| '*' * $1.length + " "}
362
362
363 text
363 text
364 end
364 end
365
365
366 def self.migrate
366 def self.migrate
367 establish_connection
367 establish_connection
368
368
369 # Quick database test
369 # Quick database test
370 TracComponent.count
370 TracComponent.count
371
371
372 migrated_components = 0
372 migrated_components = 0
373 migrated_milestones = 0
373 migrated_milestones = 0
374 migrated_tickets = 0
374 migrated_tickets = 0
375 migrated_custom_values = 0
375 migrated_custom_values = 0
376 migrated_ticket_attachments = 0
376 migrated_ticket_attachments = 0
377 migrated_wiki_edits = 0
377 migrated_wiki_edits = 0
378 migrated_wiki_attachments = 0
378 migrated_wiki_attachments = 0
379
379
380 #Wiki system initializing...
380 #Wiki system initializing...
381 @target_project.wiki.destroy if @target_project.wiki
381 @target_project.wiki.destroy if @target_project.wiki
382 @target_project.reload
382 @target_project.reload
383 wiki = Wiki.new(:project => @target_project, :start_page => 'WikiStart')
383 wiki = Wiki.new(:project => @target_project, :start_page => 'WikiStart')
384 wiki_edit_count = 0
384 wiki_edit_count = 0
385
385
386 # Components
386 # Components
387 print "Migrating components"
387 print "Migrating components"
388 issues_category_map = {}
388 issues_category_map = {}
389 TracComponent.find(:all).each do |component|
389 TracComponent.find(:all).each do |component|
390 print '.'
390 print '.'
391 STDOUT.flush
391 STDOUT.flush
392 c = IssueCategory.new :project => @target_project,
392 c = IssueCategory.new :project => @target_project,
393 :name => encode(component.name[0, limit_for(IssueCategory, 'name')])
393 :name => encode(component.name[0, limit_for(IssueCategory, 'name')])
394 next unless c.save
394 next unless c.save
395 issues_category_map[component.name] = c
395 issues_category_map[component.name] = c
396 migrated_components += 1
396 migrated_components += 1
397 end
397 end
398 puts
398 puts
399
399
400 # Milestones
400 # Milestones
401 print "Migrating milestones"
401 print "Migrating milestones"
402 version_map = {}
402 version_map = {}
403 TracMilestone.find(:all).each do |milestone|
403 TracMilestone.find(:all).each do |milestone|
404 print '.'
404 print '.'
405 STDOUT.flush
405 STDOUT.flush
406 # First we try to find the wiki page...
406 # First we try to find the wiki page...
407 p = wiki.find_or_new_page(milestone.name.to_s)
407 p = wiki.find_or_new_page(milestone.name.to_s)
408 p.content = WikiContent.new(:page => p) if p.new_record?
408 p.content = WikiContent.new(:page => p) if p.new_record?
409 p.content.text = milestone.description.to_s
409 p.content.text = milestone.description.to_s
410 p.content.author = find_or_create_user('trac')
410 p.content.author = find_or_create_user('trac')
411 p.content.comments = 'Milestone'
411 p.content.comments = 'Milestone'
412 p.save
412 p.save
413
413
414 v = Version.new :project => @target_project,
414 v = Version.new :project => @target_project,
415 :name => encode(milestone.name[0, limit_for(Version, 'name')]),
415 :name => encode(milestone.name[0, limit_for(Version, 'name')]),
416 :description => nil,
416 :description => nil,
417 :wiki_page_title => milestone.name.to_s,
417 :wiki_page_title => milestone.name.to_s,
418 :effective_date => milestone.completed
418 :effective_date => milestone.completed
419
419
420 next unless v.save
420 next unless v.save
421 version_map[milestone.name] = v
421 version_map[milestone.name] = v
422 migrated_milestones += 1
422 migrated_milestones += 1
423 end
423 end
424 puts
424 puts
425
425
426 # Custom fields
426 # Custom fields
427 # TODO: read trac.ini instead
427 # TODO: read trac.ini instead
428 print "Migrating custom fields"
428 print "Migrating custom fields"
429 custom_field_map = {}
429 custom_field_map = {}
430 TracTicketCustom.find_by_sql("SELECT DISTINCT name FROM #{TracTicketCustom.table_name}").each do |field|
430 TracTicketCustom.find_by_sql("SELECT DISTINCT name FROM #{TracTicketCustom.table_name}").each do |field|
431 print '.'
431 print '.'
432 STDOUT.flush
432 STDOUT.flush
433 # Redmine custom field name
433 # Redmine custom field name
434 field_name = encode(field.name[0, limit_for(IssueCustomField, 'name')]).humanize
434 field_name = encode(field.name[0, limit_for(IssueCustomField, 'name')]).humanize
435 # Find if the custom already exists in Redmine
435 # Find if the custom already exists in Redmine
436 f = IssueCustomField.find_by_name(field_name)
436 f = IssueCustomField.find_by_name(field_name)
437 # Or create a new one
437 # Or create a new one
438 f ||= IssueCustomField.create(:name => encode(field.name[0, limit_for(IssueCustomField, 'name')]).humanize,
438 f ||= IssueCustomField.create(:name => encode(field.name[0, limit_for(IssueCustomField, 'name')]).humanize,
439 :field_format => 'string')
439 :field_format => 'string')
440
440
441 next if f.new_record?
441 next if f.new_record?
442 f.trackers = Tracker.find(:all)
442 f.trackers = Tracker.find(:all)
443 f.projects << @target_project
443 f.projects << @target_project
444 custom_field_map[field.name] = f
444 custom_field_map[field.name] = f
445 end
445 end
446 puts
446 puts
447
447
448 # Trac 'resolution' field as a Redmine custom field
448 # Trac 'resolution' field as a Redmine custom field
449 r = IssueCustomField.find(:first, :conditions => { :name => "Resolution" })
449 r = IssueCustomField.find(:first, :conditions => { :name => "Resolution" })
450 r = IssueCustomField.new(:name => 'Resolution',
450 r = IssueCustomField.new(:name => 'Resolution',
451 :field_format => 'list',
451 :field_format => 'list',
452 :is_filter => true) if r.nil?
452 :is_filter => true) if r.nil?
453 r.trackers = Tracker.find(:all)
453 r.trackers = Tracker.find(:all)
454 r.projects << @target_project
454 r.projects << @target_project
455 r.possible_values = (r.possible_values + %w(fixed invalid wontfix duplicate worksforme)).flatten.compact.uniq
455 r.possible_values = (r.possible_values + %w(fixed invalid wontfix duplicate worksforme)).flatten.compact.uniq
456 r.save!
456 r.save!
457 custom_field_map['resolution'] = r
457 custom_field_map['resolution'] = r
458
458
459 # Tickets
459 # Tickets
460 print "Migrating tickets"
460 print "Migrating tickets"
461 TracTicket.find(:all, :order => 'id ASC').each do |ticket|
461 TracTicket.find(:all, :order => 'id ASC').each do |ticket|
462 print '.'
462 print '.'
463 STDOUT.flush
463 STDOUT.flush
464 i = Issue.new :project => @target_project,
464 i = Issue.new :project => @target_project,
465 :subject => encode(ticket.summary[0, limit_for(Issue, 'subject')]),
465 :subject => encode(ticket.summary[0, limit_for(Issue, 'subject')]),
466 :description => convert_wiki_text(encode(ticket.description)),
466 :description => convert_wiki_text(encode(ticket.description)),
467 :priority => PRIORITY_MAPPING[ticket.priority] || DEFAULT_PRIORITY,
467 :priority => PRIORITY_MAPPING[ticket.priority] || DEFAULT_PRIORITY,
468 :created_on => ticket.time
468 :created_on => ticket.time
469 i.author = find_or_create_user(ticket.reporter)
469 i.author = find_or_create_user(ticket.reporter)
470 i.category = issues_category_map[ticket.component] unless ticket.component.blank?
470 i.category = issues_category_map[ticket.component] unless ticket.component.blank?
471 i.fixed_version = version_map[ticket.milestone] unless ticket.milestone.blank?
471 i.fixed_version = version_map[ticket.milestone] unless ticket.milestone.blank?
472 i.status = STATUS_MAPPING[ticket.status] || DEFAULT_STATUS
472 i.status = STATUS_MAPPING[ticket.status] || DEFAULT_STATUS
473 i.tracker = TRACKER_MAPPING[ticket.ticket_type] || DEFAULT_TRACKER
473 i.tracker = TRACKER_MAPPING[ticket.ticket_type] || DEFAULT_TRACKER
474 i.id = ticket.id unless Issue.exists?(ticket.id)
474 i.id = ticket.id unless Issue.exists?(ticket.id)
475 next unless Time.fake(ticket.changetime) { i.save }
475 next unless Time.fake(ticket.changetime) { i.save }
476 TICKET_MAP[ticket.id] = i.id
476 TICKET_MAP[ticket.id] = i.id
477 migrated_tickets += 1
477 migrated_tickets += 1
478
478
479 # Owner
479 # Owner
480 unless ticket.owner.blank?
480 unless ticket.owner.blank?
481 i.assigned_to = find_or_create_user(ticket.owner, true)
481 i.assigned_to = find_or_create_user(ticket.owner, true)
482 Time.fake(ticket.changetime) { i.save }
482 Time.fake(ticket.changetime) { i.save }
483 end
483 end
484
484
485 # Comments and status/resolution changes
485 # Comments and status/resolution changes
486 ticket.changes.group_by(&:time).each do |time, changeset|
486 ticket.changes.group_by(&:time).each do |time, changeset|
487 status_change = changeset.select {|change| change.field == 'status'}.first
487 status_change = changeset.select {|change| change.field == 'status'}.first
488 resolution_change = changeset.select {|change| change.field == 'resolution'}.first
488 resolution_change = changeset.select {|change| change.field == 'resolution'}.first
489 comment_change = changeset.select {|change| change.field == 'comment'}.first
489 comment_change = changeset.select {|change| change.field == 'comment'}.first
490
490
491 n = Journal.new :notes => (comment_change ? convert_wiki_text(encode(comment_change.newvalue)) : ''),
491 n = Journal.new :notes => (comment_change ? convert_wiki_text(encode(comment_change.newvalue)) : ''),
492 :created_on => time
492 :created_on => time
493 n.user = find_or_create_user(changeset.first.author)
493 n.user = find_or_create_user(changeset.first.author)
494 n.journalized = i
494 n.journalized = i
495 if status_change &&
495 if status_change &&
496 STATUS_MAPPING[status_change.oldvalue] &&
496 STATUS_MAPPING[status_change.oldvalue] &&
497 STATUS_MAPPING[status_change.newvalue] &&
497 STATUS_MAPPING[status_change.newvalue] &&
498 (STATUS_MAPPING[status_change.oldvalue] != STATUS_MAPPING[status_change.newvalue])
498 (STATUS_MAPPING[status_change.oldvalue] != STATUS_MAPPING[status_change.newvalue])
499 n.details << JournalDetail.new(:property => 'attr',
499 n.details << JournalDetail.new(:property => 'attr',
500 :prop_key => 'status_id',
500 :prop_key => 'status_id',
501 :old_value => STATUS_MAPPING[status_change.oldvalue].id,
501 :old_value => STATUS_MAPPING[status_change.oldvalue].id,
502 :value => STATUS_MAPPING[status_change.newvalue].id)
502 :value => STATUS_MAPPING[status_change.newvalue].id)
503 end
503 end
504 if resolution_change
504 if resolution_change
505 n.details << JournalDetail.new(:property => 'cf',
505 n.details << JournalDetail.new(:property => 'cf',
506 :prop_key => custom_field_map['resolution'].id,
506 :prop_key => custom_field_map['resolution'].id,
507 :old_value => resolution_change.oldvalue,
507 :old_value => resolution_change.oldvalue,
508 :value => resolution_change.newvalue)
508 :value => resolution_change.newvalue)
509 end
509 end
510 n.save unless n.details.empty? && n.notes.blank?
510 n.save unless n.details.empty? && n.notes.blank?
511 end
511 end
512
512
513 # Attachments
513 # Attachments
514 ticket.attachments.each do |attachment|
514 ticket.attachments.each do |attachment|
515 next unless attachment.exist?
515 next unless attachment.exist?
516 attachment.open {
516 attachment.open {
517 a = Attachment.new :created_on => attachment.time
517 a = Attachment.new :created_on => attachment.time
518 a.file = attachment
518 a.file = attachment
519 a.author = find_or_create_user(attachment.author)
519 a.author = find_or_create_user(attachment.author)
520 a.container = i
520 a.container = i
521 a.description = attachment.description
521 a.description = attachment.description
522 migrated_ticket_attachments += 1 if a.save
522 migrated_ticket_attachments += 1 if a.save
523 }
523 }
524 end
524 end
525
525
526 # Custom fields
526 # Custom fields
527 custom_values = ticket.customs.inject({}) do |h, custom|
527 custom_values = ticket.customs.inject({}) do |h, custom|
528 if custom_field = custom_field_map[custom.name]
528 if custom_field = custom_field_map[custom.name]
529 h[custom_field.id] = custom.value
529 h[custom_field.id] = custom.value
530 migrated_custom_values += 1
530 migrated_custom_values += 1
531 end
531 end
532 h
532 h
533 end
533 end
534 if custom_field_map['resolution'] && !ticket.resolution.blank?
534 if custom_field_map['resolution'] && !ticket.resolution.blank?
535 custom_values[custom_field_map['resolution'].id] = ticket.resolution
535 custom_values[custom_field_map['resolution'].id] = ticket.resolution
536 end
536 end
537 i.custom_field_values = custom_values
537 i.custom_field_values = custom_values
538 i.save_custom_field_values
538 i.save_custom_field_values
539 end
539 end
540
540
541 # update issue id sequence if needed (postgresql)
541 # update issue id sequence if needed (postgresql)
542 Issue.connection.reset_pk_sequence!(Issue.table_name) if Issue.connection.respond_to?('reset_pk_sequence!')
542 Issue.connection.reset_pk_sequence!(Issue.table_name) if Issue.connection.respond_to?('reset_pk_sequence!')
543 puts
543 puts
544
544
545 # Wiki
545 # Wiki
546 print "Migrating wiki"
546 print "Migrating wiki"
547 if wiki.save
547 if wiki.save
548 TracWikiPage.find(:all, :order => 'name, version').each do |page|
548 TracWikiPage.find(:all, :order => 'name, version').each do |page|
549 # Do not migrate Trac manual wiki pages
549 # Do not migrate Trac manual wiki pages
550 next if TRAC_WIKI_PAGES.include?(page.name)
550 next if TRAC_WIKI_PAGES.include?(page.name)
551 wiki_edit_count += 1
551 wiki_edit_count += 1
552 print '.'
552 print '.'
553 STDOUT.flush
553 STDOUT.flush
554 p = wiki.find_or_new_page(page.name)
554 p = wiki.find_or_new_page(page.name)
555 p.content = WikiContent.new(:page => p) if p.new_record?
555 p.content = WikiContent.new(:page => p) if p.new_record?
556 p.content.text = page.text
556 p.content.text = page.text
557 p.content.author = find_or_create_user(page.author) unless page.author.blank? || page.author == 'trac'
557 p.content.author = find_or_create_user(page.author) unless page.author.blank? || page.author == 'trac'
558 p.content.comments = page.comment
558 p.content.comments = page.comment
559 Time.fake(page.time) { p.new_record? ? p.save : p.content.save }
559 Time.fake(page.time) { p.new_record? ? p.save : p.content.save }
560
560
561 next if p.content.new_record?
561 next if p.content.new_record?
562 migrated_wiki_edits += 1
562 migrated_wiki_edits += 1
563
563
564 # Attachments
564 # Attachments
565 page.attachments.each do |attachment|
565 page.attachments.each do |attachment|
566 next unless attachment.exist?
566 next unless attachment.exist?
567 next if p.attachments.find_by_filename(attachment.filename.gsub(/^.*(\\|\/)/, '').gsub(/[^\w\.\-]/,'_')) #add only once per page
567 next if p.attachments.find_by_filename(attachment.filename.gsub(/^.*(\\|\/)/, '').gsub(/[^\w\.\-]/,'_')) #add only once per page
568 a = Attachment.new :created_on => attachment.time
568 attachment.open {
569 a.file = attachment
569 a = Attachment.new :created_on => attachment.time
570 a.author = find_or_create_user(attachment.author)
570 a.file = attachment
571 a.description = attachment.description
571 a.author = find_or_create_user(attachment.author)
572 a.container = p
572 a.description = attachment.description
573 migrated_wiki_attachments += 1 if a.save
573 a.container = p
574 migrated_wiki_attachments += 1 if a.save
575 }
574 end
576 end
575 end
577 end
576
578
577 wiki.reload
579 wiki.reload
578 wiki.pages.each do |page|
580 wiki.pages.each do |page|
579 page.content.text = convert_wiki_text(page.content.text)
581 page.content.text = convert_wiki_text(page.content.text)
580 Time.fake(page.content.updated_on) { page.content.save }
582 Time.fake(page.content.updated_on) { page.content.save }
581 end
583 end
582 end
584 end
583 puts
585 puts
584
586
585 puts
587 puts
586 puts "Components: #{migrated_components}/#{TracComponent.count}"
588 puts "Components: #{migrated_components}/#{TracComponent.count}"
587 puts "Milestones: #{migrated_milestones}/#{TracMilestone.count}"
589 puts "Milestones: #{migrated_milestones}/#{TracMilestone.count}"
588 puts "Tickets: #{migrated_tickets}/#{TracTicket.count}"
590 puts "Tickets: #{migrated_tickets}/#{TracTicket.count}"
589 puts "Ticket files: #{migrated_ticket_attachments}/" + TracAttachment.count(:conditions => {:type => 'ticket'}).to_s
591 puts "Ticket files: #{migrated_ticket_attachments}/" + TracAttachment.count(:conditions => {:type => 'ticket'}).to_s
590 puts "Custom values: #{migrated_custom_values}/#{TracTicketCustom.count}"
592 puts "Custom values: #{migrated_custom_values}/#{TracTicketCustom.count}"
591 puts "Wiki edits: #{migrated_wiki_edits}/#{wiki_edit_count}"
593 puts "Wiki edits: #{migrated_wiki_edits}/#{wiki_edit_count}"
592 puts "Wiki files: #{migrated_wiki_attachments}/" + TracAttachment.count(:conditions => {:type => 'wiki'}).to_s
594 puts "Wiki files: #{migrated_wiki_attachments}/" + TracAttachment.count(:conditions => {:type => 'wiki'}).to_s
593 end
595 end
594
596
595 def self.limit_for(klass, attribute)
597 def self.limit_for(klass, attribute)
596 klass.columns_hash[attribute.to_s].limit
598 klass.columns_hash[attribute.to_s].limit
597 end
599 end
598
600
599 def self.encoding(charset)
601 def self.encoding(charset)
600 @ic = Iconv.new('UTF-8', charset)
602 @ic = Iconv.new('UTF-8', charset)
601 rescue Iconv::InvalidEncoding
603 rescue Iconv::InvalidEncoding
602 puts "Invalid encoding!"
604 puts "Invalid encoding!"
603 return false
605 return false
604 end
606 end
605
607
606 def self.set_trac_directory(path)
608 def self.set_trac_directory(path)
607 @@trac_directory = path
609 @@trac_directory = path
608 raise "This directory doesn't exist!" unless File.directory?(path)
610 raise "This directory doesn't exist!" unless File.directory?(path)
609 raise "#{trac_attachments_directory} doesn't exist!" unless File.directory?(trac_attachments_directory)
611 raise "#{trac_attachments_directory} doesn't exist!" unless File.directory?(trac_attachments_directory)
610 @@trac_directory
612 @@trac_directory
611 rescue Exception => e
613 rescue Exception => e
612 puts e
614 puts e
613 return false
615 return false
614 end
616 end
615
617
616 def self.trac_directory
618 def self.trac_directory
617 @@trac_directory
619 @@trac_directory
618 end
620 end
619
621
620 def self.set_trac_adapter(adapter)
622 def self.set_trac_adapter(adapter)
621 return false if adapter.blank?
623 return false if adapter.blank?
622 raise "Unknown adapter: #{adapter}!" unless %w(sqlite sqlite3 mysql postgresql).include?(adapter)
624 raise "Unknown adapter: #{adapter}!" unless %w(sqlite sqlite3 mysql postgresql).include?(adapter)
623 # If adapter is sqlite or sqlite3, make sure that trac.db exists
625 # If adapter is sqlite or sqlite3, make sure that trac.db exists
624 raise "#{trac_db_path} doesn't exist!" if %w(sqlite sqlite3).include?(adapter) && !File.exist?(trac_db_path)
626 raise "#{trac_db_path} doesn't exist!" if %w(sqlite sqlite3).include?(adapter) && !File.exist?(trac_db_path)
625 @@trac_adapter = adapter
627 @@trac_adapter = adapter
626 rescue Exception => e
628 rescue Exception => e
627 puts e
629 puts e
628 return false
630 return false
629 end
631 end
630
632
631 def self.set_trac_db_host(host)
633 def self.set_trac_db_host(host)
632 return nil if host.blank?
634 return nil if host.blank?
633 @@trac_db_host = host
635 @@trac_db_host = host
634 end
636 end
635
637
636 def self.set_trac_db_port(port)
638 def self.set_trac_db_port(port)
637 return nil if port.to_i == 0
639 return nil if port.to_i == 0
638 @@trac_db_port = port.to_i
640 @@trac_db_port = port.to_i
639 end
641 end
640
642
641 def self.set_trac_db_name(name)
643 def self.set_trac_db_name(name)
642 return nil if name.blank?
644 return nil if name.blank?
643 @@trac_db_name = name
645 @@trac_db_name = name
644 end
646 end
645
647
646 def self.set_trac_db_username(username)
648 def self.set_trac_db_username(username)
647 @@trac_db_username = username
649 @@trac_db_username = username
648 end
650 end
649
651
650 def self.set_trac_db_password(password)
652 def self.set_trac_db_password(password)
651 @@trac_db_password = password
653 @@trac_db_password = password
652 end
654 end
653
655
654 def self.set_trac_db_schema(schema)
656 def self.set_trac_db_schema(schema)
655 @@trac_db_schema = schema
657 @@trac_db_schema = schema
656 end
658 end
657
659
658 mattr_reader :trac_directory, :trac_adapter, :trac_db_host, :trac_db_port, :trac_db_name, :trac_db_schema, :trac_db_username, :trac_db_password
660 mattr_reader :trac_directory, :trac_adapter, :trac_db_host, :trac_db_port, :trac_db_name, :trac_db_schema, :trac_db_username, :trac_db_password
659
661
660 def self.trac_db_path; "#{trac_directory}/db/trac.db" end
662 def self.trac_db_path; "#{trac_directory}/db/trac.db" end
661 def self.trac_attachments_directory; "#{trac_directory}/attachments" end
663 def self.trac_attachments_directory; "#{trac_directory}/attachments" end
662
664
663 def self.target_project_identifier(identifier)
665 def self.target_project_identifier(identifier)
664 project = Project.find_by_identifier(identifier)
666 project = Project.find_by_identifier(identifier)
665 if !project
667 if !project
666 # create the target project
668 # create the target project
667 project = Project.new :name => identifier.humanize,
669 project = Project.new :name => identifier.humanize,
668 :description => ''
670 :description => ''
669 project.identifier = identifier
671 project.identifier = identifier
670 puts "Unable to create a project with identifier '#{identifier}'!" unless project.save
672 puts "Unable to create a project with identifier '#{identifier}'!" unless project.save
671 # enable issues and wiki for the created project
673 # enable issues and wiki for the created project
672 project.enabled_module_names = ['issue_tracking', 'wiki']
674 project.enabled_module_names = ['issue_tracking', 'wiki']
673 else
675 else
674 puts
676 puts
675 puts "This project already exists in your Redmine database."
677 puts "This project already exists in your Redmine database."
676 print "Are you sure you want to append data to this project ? [Y/n] "
678 print "Are you sure you want to append data to this project ? [Y/n] "
677 exit if STDIN.gets.match(/^n$/i)
679 exit if STDIN.gets.match(/^n$/i)
678 end
680 end
679 project.trackers << TRACKER_BUG unless project.trackers.include?(TRACKER_BUG)
681 project.trackers << TRACKER_BUG unless project.trackers.include?(TRACKER_BUG)
680 project.trackers << TRACKER_FEATURE unless project.trackers.include?(TRACKER_FEATURE)
682 project.trackers << TRACKER_FEATURE unless project.trackers.include?(TRACKER_FEATURE)
681 @target_project = project.new_record? ? nil : project
683 @target_project = project.new_record? ? nil : project
682 end
684 end
683
685
684 def self.connection_params
686 def self.connection_params
685 if %w(sqlite sqlite3).include?(trac_adapter)
687 if %w(sqlite sqlite3).include?(trac_adapter)
686 {:adapter => trac_adapter,
688 {:adapter => trac_adapter,
687 :database => trac_db_path}
689 :database => trac_db_path}
688 else
690 else
689 {:adapter => trac_adapter,
691 {:adapter => trac_adapter,
690 :database => trac_db_name,
692 :database => trac_db_name,
691 :host => trac_db_host,
693 :host => trac_db_host,
692 :port => trac_db_port,
694 :port => trac_db_port,
693 :username => trac_db_username,
695 :username => trac_db_username,
694 :password => trac_db_password,
696 :password => trac_db_password,
695 :schema_search_path => trac_db_schema
697 :schema_search_path => trac_db_schema
696 }
698 }
697 end
699 end
698 end
700 end
699
701
700 def self.establish_connection
702 def self.establish_connection
701 constants.each do |const|
703 constants.each do |const|
702 klass = const_get(const)
704 klass = const_get(const)
703 next unless klass.respond_to? 'establish_connection'
705 next unless klass.respond_to? 'establish_connection'
704 klass.establish_connection connection_params
706 klass.establish_connection connection_params
705 end
707 end
706 end
708 end
707
709
708 private
710 private
709 def self.encode(text)
711 def self.encode(text)
710 @ic.iconv text
712 @ic.iconv text
711 rescue
713 rescue
712 text
714 text
713 end
715 end
714 end
716 end
715
717
716 puts
718 puts
717 if Redmine::DefaultData::Loader.no_data?
719 if Redmine::DefaultData::Loader.no_data?
718 puts "Redmine configuration need to be loaded before importing data."
720 puts "Redmine configuration need to be loaded before importing data."
719 puts "Please, run this first:"
721 puts "Please, run this first:"
720 puts
722 puts
721 puts " rake redmine:load_default_data RAILS_ENV=\"#{ENV['RAILS_ENV']}\""
723 puts " rake redmine:load_default_data RAILS_ENV=\"#{ENV['RAILS_ENV']}\""
722 exit
724 exit
723 end
725 end
724
726
725 puts "WARNING: a new project will be added to Redmine during this process."
727 puts "WARNING: a new project will be added to Redmine during this process."
726 print "Are you sure you want to continue ? [y/N] "
728 print "Are you sure you want to continue ? [y/N] "
727 break unless STDIN.gets.match(/^y$/i)
729 break unless STDIN.gets.match(/^y$/i)
728 puts
730 puts
729
731
730 def prompt(text, options = {}, &block)
732 def prompt(text, options = {}, &block)
731 default = options[:default] || ''
733 default = options[:default] || ''
732 while true
734 while true
733 print "#{text} [#{default}]: "
735 print "#{text} [#{default}]: "
734 value = STDIN.gets.chomp!
736 value = STDIN.gets.chomp!
735 value = default if value.blank?
737 value = default if value.blank?
736 break if yield value
738 break if yield value
737 end
739 end
738 end
740 end
739
741
740 DEFAULT_PORTS = {'mysql' => 3306, 'postgresql' => 5432}
742 DEFAULT_PORTS = {'mysql' => 3306, 'postgresql' => 5432}
741
743
742 prompt('Trac directory') {|directory| TracMigrate.set_trac_directory directory.strip}
744 prompt('Trac directory') {|directory| TracMigrate.set_trac_directory directory.strip}
743 prompt('Trac database adapter (sqlite, sqlite3, mysql, postgresql)', :default => 'sqlite') {|adapter| TracMigrate.set_trac_adapter adapter}
745 prompt('Trac database adapter (sqlite, sqlite3, mysql, postgresql)', :default => 'sqlite') {|adapter| TracMigrate.set_trac_adapter adapter}
744 unless %w(sqlite sqlite3).include?(TracMigrate.trac_adapter)
746 unless %w(sqlite sqlite3).include?(TracMigrate.trac_adapter)
745 prompt('Trac database host', :default => 'localhost') {|host| TracMigrate.set_trac_db_host host}
747 prompt('Trac database host', :default => 'localhost') {|host| TracMigrate.set_trac_db_host host}
746 prompt('Trac database port', :default => DEFAULT_PORTS[TracMigrate.trac_adapter]) {|port| TracMigrate.set_trac_db_port port}
748 prompt('Trac database port', :default => DEFAULT_PORTS[TracMigrate.trac_adapter]) {|port| TracMigrate.set_trac_db_port port}
747 prompt('Trac database name') {|name| TracMigrate.set_trac_db_name name}
749 prompt('Trac database name') {|name| TracMigrate.set_trac_db_name name}
748 prompt('Trac database schema', :default => 'public') {|schema| TracMigrate.set_trac_db_schema schema}
750 prompt('Trac database schema', :default => 'public') {|schema| TracMigrate.set_trac_db_schema schema}
749 prompt('Trac database username') {|username| TracMigrate.set_trac_db_username username}
751 prompt('Trac database username') {|username| TracMigrate.set_trac_db_username username}
750 prompt('Trac database password') {|password| TracMigrate.set_trac_db_password password}
752 prompt('Trac database password') {|password| TracMigrate.set_trac_db_password password}
751 end
753 end
752 prompt('Trac database encoding', :default => 'UTF-8') {|encoding| TracMigrate.encoding encoding}
754 prompt('Trac database encoding', :default => 'UTF-8') {|encoding| TracMigrate.encoding encoding}
753 prompt('Target project identifier') {|identifier| TracMigrate.target_project_identifier identifier}
755 prompt('Target project identifier') {|identifier| TracMigrate.target_project_identifier identifier}
754 puts
756 puts
755
757
756 # Turn off email notifications
758 # Turn off email notifications
757 Setting.notified_events = []
759 Setting.notified_events = []
758
760
759 TracMigrate.migrate
761 TracMigrate.migrate
760 end
762 end
761 end
763 end
762
764
General Comments 0
You need to be logged in to leave comments. Login now