jro_apps/redmine Commit - r1085:b0f3de5c3b75

1

# redMine - project management software

1

# redMine - project management software

2

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

18

require 'active_record'

18

require 'active_record'

19

require 'iconv'

19

require 'iconv'

20

require 'pp'

20

require 'pp'

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

26

module TracMigrate

26

module TracMigrate

27

TICKET_MAP = []

27

TICKET_MAP = []

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

40

priorities = Enumeration.get_values('IPRI')

40

priorities = Enumeration.get_values('IPRI')

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

49

TRACKER_BUG = Tracker.find_by_position(1)

49

TRACKER_BUG = Tracker.find_by_position(1)

50

TRACKER_FEATURE = Tracker.find_by_position(2)

50

TRACKER_FEATURE = Tracker.find_by_position(2)

51

DEFAULT_TRACKER = TRACKER_BUG

51

DEFAULT_TRACKER = TRACKER_BUG

52

TRACKER_MAPPING = {'defect' => TRACKER_BUG,

52

TRACKER_MAPPING = {'defect' => TRACKER_BUG,

53

'enhancement' => TRACKER_FEATURE,

53

'enhancement' => TRACKER_FEATURE,

54

'task' => TRACKER_FEATURE,

54

'task' => TRACKER_FEATURE,

55

'patch' =>TRACKER_FEATURE

55

'patch' =>TRACKER_FEATURE

56

}

56

}

57

58

roles = Role.find(:all, :conditions => {:builtin => 0}, :order => 'position ASC')

58

roles = Role.find(:all, :conditions => {:builtin => 0}, :order => 'position ASC')

59

manager_role = roles[0]

59

manager_role = roles[0]

60

developer_role = roles[1]

60

developer_role = roles[1]

61

DEFAULT_ROLE = roles.last

61

DEFAULT_ROLE = roles.last

62

ROLE_MAPPING = {'admin' => manager_role,

62

ROLE_MAPPING = {'admin' => manager_role,

63

'developer' => developer_role

63

'developer' => developer_role

64

}

64

}

65

66

class TracComponent < ActiveRecord::Base

66

class TracComponent < ActiveRecord::Base

67

set_table_name :component

67

set_table_name :component

68

end

68

end

69

70

class TracMilestone < ActiveRecord::Base

70

class TracMilestone < ActiveRecord::Base

71

set_table_name :milestone

71

set_table_name :milestone

72

73

def due

73

def due

74

if read_attribute(:due) > 0

74

if read_attribute(:due) > 0

75

Time.at(read_attribute(:due)).to_date

75

Time.at(read_attribute(:due)).to_date

76

else

76

else

77

nil

77

nil

78

end

78

end

79

end

79

end

80

end

80

end

81

82

class TracTicketCustom < ActiveRecord::Base

82

class TracTicketCustom < ActiveRecord::Base

83

set_table_name :ticket_custom

83

set_table_name :ticket_custom

84

end

84

end

85

86

class TracAttachment < ActiveRecord::Base

86

class TracAttachment < ActiveRecord::Base

87

set_table_name :attachment

87

set_table_name :attachment

88

set_inheritance_column :none

88

set_inheritance_column :none

89

90

def time; Time.at(read_attribute(:time)) end

90

def time; Time.at(read_attribute(:time)) end

91

92

def original_filename

92

def original_filename

93

filename

93

filename

94

end

94

end

95

96

def content_type

96

def content_type

97

Redmine::MimeType.of(filename) || ''

97

Redmine::MimeType.of(filename) || ''

98

end

98

end

99

100

def exist?

100

def exist?

101

File.file? trac_fullpath

101

File.file? trac_fullpath

102

end

102

end

103

104

def read

104

def read

105

File.open("#{trac_fullpath}", 'rb').read

105

File.open("#{trac_fullpath}", 'rb').read

106

end

106

end

107

108

private

108

private

109

def trac_fullpath

109

def trac_fullpath

110

attachment_type = read_attribute(:type)

110

attachment_type = read_attribute(:type)

111

trac_file = filename.gsub( /[^a-zA-Z0-9\-_\.!~*']/n ) {|x| sprintf('%%%02x', x[0]) }

111

trac_file = filename.gsub( /[^a-zA-Z0-9\-_\.!~*']/n ) {|x| sprintf('%%%02x', x[0]) }

112

"#{TracMigrate.trac_attachments_directory}/#{attachment_type}/#{id}/#{trac_file}"

112

"#{TracMigrate.trac_attachments_directory}/#{attachment_type}/#{id}/#{trac_file}"

113

end

113

end

114

end

114

end

115

116

class TracTicket < ActiveRecord::Base

116

class TracTicket < ActiveRecord::Base

117

set_table_name :ticket

117

set_table_name :ticket

118

set_inheritance_column :none

118

set_inheritance_column :none

119

120

# ticket changes: only migrate status changes and comments

120

# ticket changes: only migrate status changes and comments

121

has_many :changes, :class_name => "TracTicketChange", :foreign_key => :ticket

121

has_many :changes, :class_name => "TracTicketChange", :foreign_key => :ticket

122

has_many :attachments, :class_name => "TracAttachment", :foreign_key => :id, :conditions => "#{TracMigrate::TracAttachment.table_name}.type = 'ticket'"

122

has_many :attachments, :class_name => "TracAttachment", :foreign_key => :id, :conditions => "#{TracMigrate::TracAttachment.table_name}.type = 'ticket'"

123

has_many :customs, :class_name => "TracTicketCustom", :foreign_key => :ticket

123

has_many :customs, :class_name => "TracTicketCustom", :foreign_key => :ticket

124

125

def ticket_type

125

def ticket_type

126

read_attribute(:type)

126

read_attribute(:type)

127

end

127

end

128

129

def summary

129

def summary

130

read_attribute(:summary).blank? ? "(no subject)" : read_attribute(:summary)

130

read_attribute(:summary).blank? ? "(no subject)" : read_attribute(:summary)

131

end

131

end

132

133

def description

133

def description

134

read_attribute(:description).blank? ? summary : read_attribute(:description)

134

read_attribute(:description).blank? ? summary : read_attribute(:description)

135

end

135

end

136

137

def time; Time.at(read_attribute(:time)) end

137

def time; Time.at(read_attribute(:time)) end

138

end

138

end

139

140

class TracTicketChange < ActiveRecord::Base

140

class TracTicketChange < ActiveRecord::Base

141

set_table_name :ticket_change

141

set_table_name :ticket_change

142

143

def time; Time.at(read_attribute(:time)) end

143

def time; Time.at(read_attribute(:time)) end

144

end

144

end

145

146

class TracWikiPage < ActiveRecord::Base

146

class TracWikiPage < ActiveRecord::Base

147

set_table_name :wiki

147

set_table_name :wiki

148

149

def self.columns

149

def self.columns

150

# Hides readonly Trac field to prevent clash with AR readonly? method (Rails 2.0)

150

# Hides readonly Trac field to prevent clash with AR readonly? method (Rails 2.0)

151

super.select {|column| column.name.to_s != 'readonly'}

151

super.select {|column| column.name.to_s != 'readonly'}

152

end

152

end

153

end

153

end

154

155

class TracPermission < ActiveRecord::Base

155

class TracPermission < ActiveRecord::Base

156

set_table_name :permission

156

set_table_name :permission

157

end

157

end

158

159

def self.find_or_create_user(username, project_member = false)

159

def self.find_or_create_user(username, project_member = false)

160

u = User.find_by_login(username)

160

u = User.find_by_login(username)

161

if !u

161

if !u

162

# Create a new user if not found

162

# Create a new user if not found

163

mail = username[0,limit_for(User, 'mail')]

163

mail = username[0,limit_for(User, 'mail')]

164

mail = "#{mail}@foo.bar" unless mail.include?("@")

164

mail = "#{mail}@foo.bar" unless mail.include?("@")

165

u = User.new :firstname => username[0,limit_for(User, 'firstname')].gsub(/[^\w\s\'\-]/i, '-'),

165

u = User.new :firstname => username[0,limit_for(User, 'firstname')].gsub(/[^\w\s\'\-]/i, '-'),

166

:lastname => '-',

166

:lastname => '-',

167

:mail => mail.gsub(/[^-@a-z0-9\.]/i, '-')

167

:mail => mail.gsub(/[^-@a-z0-9\.]/i, '-')

168

u.login = username[0,limit_for(User, 'login')].gsub(/[^a-z0-9_\-@\.]/i, '-')

168

u.login = username[0,limit_for(User, 'login')].gsub(/[^a-z0-9_\-@\.]/i, '-')

169

u.password = 'trac'

169

u.password = 'trac'

170

u.admin = true if TracPermission.find_by_username_and_action(username, 'admin')

170

u.admin = true if TracPermission.find_by_username_and_action(username, 'admin')

171

# finally, a default user is used if the new user is not valid

171

# finally, a default user is used if the new user is not valid

172

u = User.find(:first) unless u.save

172

u = User.find(:first) unless u.save

173

end

173

end

174

# Make sure he is a member of the project

174

# Make sure he is a member of the project

175

if project_member && !u.member_of?(@target_project)

175

if project_member && !u.member_of?(@target_project)

176

role = DEFAULT_ROLE

176

role = DEFAULT_ROLE

177

if u.admin

177

if u.admin

178

role = ROLE_MAPPING['admin']

178

role = ROLE_MAPPING['admin']

179

elsif TracPermission.find_by_username_and_action(username, 'developer')

179

elsif TracPermission.find_by_username_and_action(username, 'developer')

180

role = ROLE_MAPPING['developer']

180

role = ROLE_MAPPING['developer']

181

end

181

end

182

Member.create(:user => u, :project => @target_project, :role => role)

182

Member.create(:user => u, :project => @target_project, :role => role)

183

u.reload

183

u.reload

184

end

184

end

185

u

185

u

186

end

186

end

187

188

# Basic wiki syntax conversion

188

# Basic wiki syntax conversion

189

def self.convert_wiki_text(text)

189

def self.convert_wiki_text(text)

190

# Titles

190

# Titles

191

text = text.gsub(/^(\=+)\s(.+)\s(\=+)/) {|s| "\nh#{$1.length}. #{$2}\n"}

191

text = text.gsub(/^(\=+)\s(.+)\s(\=+)/) {|s| "\nh#{$1.length}. #{$2}\n"}

192

# External Links

192

# External Links

193

text = text.gsub(/\[(http[^\s]+)\s+([^\]]+)\]/) {|s| "\"#{$2}\":#{$1}"}

193

text = text.gsub(/\[(http[^\s]+)\s+([^\]]+)\]/) {|s| "\"#{$2}\":#{$1}"}

194

# Internal Links

194

# Internal Links

195

text = text.gsub(/\[\[BR\]\]/, "\n") # This has to go before the rules below

195

text = text.gsub(/\[\[BR\]\]/, "\n") # This has to go before the rules below

196

text = text.gsub(/\[\"(.+)\".*\]/) {|s| "[[#{$1.delete(',./?;|:')}]]"}

196

text = text.gsub(/\[\"(.+)\".*\]/) {|s| "[[#{$1.delete(',./?;|:')}]]"}

197

text = text.gsub(/\[wiki:\"(.+)\".*\]/) {|s| "[[#{$1.delete(',./?;|:')}]]"}

197

text = text.gsub(/\[wiki:\"(.+)\".*\]/) {|s| "[[#{$1.delete(',./?;|:')}]]"}

198

text = text.gsub(/\[wiki:\"(.+)\".*\]/) {|s| "[[#{$1.delete(',./?;|:')}]]"}

198

text = text.gsub(/\[wiki:\"(.+)\".*\]/) {|s| "[[#{$1.delete(',./?;|:')}]]"}

199

text = text.gsub(/\[wiki:([^\s\]]+).*\]/) {|s| "[[#{$1.delete(',./?;|:')}]]"}

199

text = text.gsub(/\[wiki:([^\s\]]+).*\]/) {|s| "[[#{$1.delete(',./?;|:')}]]"}

200

# Revisions links

200

# Revisions links

201

text = text.gsub(/\[(\d+)\]/, 'r\1')

201

text = text.gsub(/\[(\d+)\]/, 'r\1')

202

# Ticket number re-writing

202

# Ticket number re-writing

203

text = text.gsub(/#(\d+)/) do |s|

203

text = text.gsub(/#(\d+)/) do |s|

204

TICKET_MAP[$1.to_i] ||= $1

204

TICKET_MAP[$1.to_i] ||= $1

205

"\##{TICKET_MAP[$1.to_i] || $1}"

205

"\##{TICKET_MAP[$1.to_i] || $1}"

206

end

206

end

207

# Preformatted blocks

207

# Preformatted blocks

208

text = text.gsub(/\{\{\{/, '<pre>')

208

text = text.gsub(/\{\{\{/, '<pre>')

209

text = text.gsub(/\}\}\}/, '</pre>')

209

text = text.gsub(/\}\}\}/, '</pre>')

210

# Highlighting

210

# Highlighting

211

text = text.gsub(/'''''([^\s])/, '_*\1')

211

text = text.gsub(/'''''([^\s])/, '_*\1')

212

text = text.gsub(/([^\s])'''''/, '\1*_')

212

text = text.gsub(/([^\s])'''''/, '\1*_')

213

text = text.gsub(/'''/, '*')

213

text = text.gsub(/'''/, '*')

214

text = text.gsub(/''/, '_')

214

text = text.gsub(/''/, '_')

215

text = text.gsub(/__/, '+')

215

text = text.gsub(/__/, '+')

216

text = text.gsub(/~~/, '-')

216

text = text.gsub(/~~/, '-')

217

text = text.gsub(/`/, '@')

217

text = text.gsub(/`/, '@')

218

text = text.gsub(/,,/, '~')

218

text = text.gsub(/,,/, '~')

219

# Lists

219

# Lists

220

text = text.gsub(/^([ ]+)\* /) {|s| '*' * $1.length + " "}

220

text = text.gsub(/^([ ]+)\* /) {|s| '*' * $1.length + " "}

221

222

text

222

text

223

end

223

end

224

225

def self.migrate

225

def self.migrate

226

establish_connection

226

establish_connection

227

228

# Quick database test

228

# Quick database test

229

TracComponent.count

229

TracComponent.count

230

231

migrated_components = 0

231

migrated_components = 0

232

migrated_milestones = 0

232

migrated_milestones = 0

233

migrated_tickets = 0

233

migrated_tickets = 0

234

migrated_custom_values = 0

234

migrated_custom_values = 0

235

migrated_ticket_attachments = 0

235

migrated_ticket_attachments = 0

236

migrated_wiki_edits = 0

236

migrated_wiki_edits = 0

237

238

# Components

238

# Components

239

print "Migrating components"

239

print "Migrating components"

240

issues_category_map = {}

240

issues_category_map = {}

241

TracComponent.find(:all).each do |component|

241

TracComponent.find(:all).each do |component|

242

print '.'

242

print '.'

243

STDOUT.flush

243

STDOUT.flush

244

c = IssueCategory.new :project => @target_project,

244

c = IssueCategory.new :project => @target_project,

245

:name => encode(component.name[0, limit_for(IssueCategory, 'name')])

245

:name => encode(component.name[0, limit_for(IssueCategory, 'name')])

246

next unless c.save

246

next unless c.save

247

issues_category_map[component.name] = c

247

issues_category_map[component.name] = c

248

migrated_components += 1

248

migrated_components += 1

249

end

249

end

250

puts

250

puts

251

252

# Milestones

252

# Milestones

253

print "Migrating milestones"

253

print "Migrating milestones"

254

version_map = {}

254

version_map = {}

255

TracMilestone.find(:all).each do |milestone|

255

TracMilestone.find(:all).each do |milestone|

256

print '.'

256

print '.'

257

STDOUT.flush

257

STDOUT.flush

258

v = Version.new :project => @target_project,

258

v = Version.new :project => @target_project,

259

:name => encode(milestone.name[0, limit_for(Version, 'name')]),

259

:name => encode(milestone.name[0, limit_for(Version, 'name')]),

260

:description => encode(milestone.description.to_s[0, limit_for(Version, 'description')]),

260

:description => encode(milestone.description.to_s[0, limit_for(Version, 'description')]),

261

:effective_date => milestone.due

261

:effective_date => milestone.due

262

next unless v.save

262

next unless v.save

263

version_map[milestone.name] = v

263

version_map[milestone.name] = v

264

migrated_milestones += 1

264

migrated_milestones += 1

265

end

265

end

266

puts

266

puts

267

268

# Custom fields

268

# Custom fields

269

# TODO: read trac.ini instead

269

# TODO: read trac.ini instead

270

print "Migrating custom fields"

270

print "Migrating custom fields"

271

custom_field_map = {}

271

custom_field_map = {}

272

TracTicketCustom.find_by_sql("SELECT DISTINCT name FROM #{TracTicketCustom.table_name}").each do |field|

272

TracTicketCustom.find_by_sql("SELECT DISTINCT name FROM #{TracTicketCustom.table_name}").each do |field|

273

print '.'

273

print '.'

274

STDOUT.flush

274

STDOUT.flush

275

# Redmine custom field name

275

# Redmine custom field name

276

field_name = encode(field.name[0, limit_for(IssueCustomField, 'name')]).humanize

276

field_name = encode(field.name[0, limit_for(IssueCustomField, 'name')]).humanize

277

# Find if the custom already exists in Redmine

277

# Find if the custom already exists in Redmine

278

f = IssueCustomField.find_by_name(field_name)

278

f = IssueCustomField.find_by_name(field_name)

279

# Or create a new one

279

# Or create a new one

280

f ||= IssueCustomField.create(:name => encode(field.name[0, limit_for(IssueCustomField, 'name')]).humanize,

280

f ||= IssueCustomField.create(:name => encode(field.name[0, limit_for(IssueCustomField, 'name')]).humanize,

281

:field_format => 'string')

281

:field_format => 'string')

282

283

next if f.new_record?

283

next if f.new_record?

284

f.trackers = Tracker.find(:all)

284

f.trackers = Tracker.find(:all)

285

f.projects << @target_project

285

f.projects << @target_project

286

custom_field_map[field.name] = f

286

custom_field_map[field.name] = f

287

end

287

end

288

puts

288

puts

289

290

# Trac 'resolution' field as a Redmine custom field

290

# Trac 'resolution' field as a Redmine custom field

291

r = IssueCustomField.find(:first, :conditions => { :name => "Resolution" })

291

r = IssueCustomField.find(:first, :conditions => { :name => "Resolution" })

292

r = IssueCustomField.new(:name => 'Resolution',

292

r = IssueCustomField.new(:name => 'Resolution',

293

:field_format => 'list',

293

:field_format => 'list',

294

:is_filter => true) if r.nil?

294

:is_filter => true) if r.nil?

295

r.trackers = Tracker.find(:all)

295

r.trackers = Tracker.find(:all)

296

r.projects << @target_project

296

r.projects << @target_project

297

r.possible_values = %w(fixed invalid wontfix duplicate worksforme)

297

r.possible_values = %w(fixed invalid wontfix duplicate worksforme)

298

custom_field_map['resolution'] = r if r.save

298

custom_field_map['resolution'] = r if r.save

299

300

# Tickets

300

# Tickets

301

print "Migrating tickets"

301

print "Migrating tickets"

302

TracTicket.find(:all, :order => 'id ASC').each do |ticket|

302

TracTicket.find(:all, :order => 'id ASC').each do |ticket|

303

print '.'

303

print '.'

304

STDOUT.flush

304

STDOUT.flush

305

i = Issue.new :project => @target_project,

305

i = Issue.new :project => @target_project,

306

:subject => encode(ticket.summary[0, limit_for(Issue, 'subject')]),

306

:subject => encode(ticket.summary[0, limit_for(Issue, 'subject')]),

307

:description => convert_wiki_text(encode(ticket.description)),

307

:description => convert_wiki_text(encode(ticket.description)),

308

:priority => PRIORITY_MAPPING[ticket.priority] || DEFAULT_PRIORITY,

308

:priority => PRIORITY_MAPPING[ticket.priority] || DEFAULT_PRIORITY,

309

:created_on => ticket.time

309

:created_on => ticket.time

310

i.author = find_or_create_user(ticket.reporter)

310

i.author = find_or_create_user(ticket.reporter)

311

i.category = issues_category_map[ticket.component] unless ticket.component.blank?

311

i.category = issues_category_map[ticket.component] unless ticket.component.blank?

312

i.fixed_version = version_map[ticket.milestone] unless ticket.milestone.blank?

312

i.fixed_version = version_map[ticket.milestone] unless ticket.milestone.blank?

313

i.status = STATUS_MAPPING[ticket.status] || DEFAULT_STATUS

313

i.status = STATUS_MAPPING[ticket.status] || DEFAULT_STATUS

314

i.tracker = TRACKER_MAPPING[ticket.ticket_type] || DEFAULT_TRACKER

314

i.tracker = TRACKER_MAPPING[ticket.ticket_type] || DEFAULT_TRACKER

315

i.custom_values << CustomValue.new(:custom_field => custom_field_map['resolution'], :value => ticket.resolution) unless ticket.resolution.blank?

315

i.custom_values << CustomValue.new(:custom_field => custom_field_map['resolution'], :value => ticket.resolution) unless ticket.resolution.blank?

316

i.id = ticket.id unless Issue.exists?(ticket.id)

316

i.id = ticket.id unless Issue.exists?(ticket.id)

317

next unless i.save

317

next unless i.save

318

TICKET_MAP[ticket.id] = i.id

318

TICKET_MAP[ticket.id] = i.id

319

migrated_tickets += 1

319

migrated_tickets += 1

320

321

# Owner

321

# Owner

322

unless ticket.owner.blank?

322

unless ticket.owner.blank?

323

i.assigned_to = find_or_create_user(ticket.owner, true)

323

i.assigned_to = find_or_create_user(ticket.owner, true)

324

i.save

324

i.save

325

end

325

end

326

327

# Comments and status/resolution changes

327

# Comments and status/resolution changes

328

ticket.changes.group_by(&:time).each do |time, changeset|

328

ticket.changes.group_by(&:time).each do |time, changeset|

329

status_change = changeset.select {|change| change.field == 'status'}.first

329

status_change = changeset.select {|change| change.field == 'status'}.first

330

resolution_change = changeset.select {|change| change.field == 'resolution'}.first

330

resolution_change = changeset.select {|change| change.field == 'resolution'}.first

331

comment_change = changeset.select {|change| change.field == 'comment'}.first

331

comment_change = changeset.select {|change| change.field == 'comment'}.first

332

333

n = Journal.new :notes => (comment_change ? convert_wiki_text(encode(comment_change.newvalue)) : ''),

333

n = Journal.new :notes => (comment_change ? convert_wiki_text(encode(comment_change.newvalue)) : ''),

334

:created_on => time

334

:created_on => time

335

n.user = find_or_create_user(changeset.first.author)

335

n.user = find_or_create_user(changeset.first.author)

336

n.journalized = i

336

n.journalized = i

337

if status_change &&

337

if status_change &&

338

STATUS_MAPPING[status_change.oldvalue] &&

338

STATUS_MAPPING[status_change.oldvalue] &&

339

STATUS_MAPPING[status_change.newvalue] &&

339

STATUS_MAPPING[status_change.newvalue] &&

340

(STATUS_MAPPING[status_change.oldvalue] != STATUS_MAPPING[status_change.newvalue])

340

(STATUS_MAPPING[status_change.oldvalue] != STATUS_MAPPING[status_change.newvalue])

341

n.details << JournalDetail.new(:property => 'attr',

341

n.details << JournalDetail.new(:property => 'attr',

342

:prop_key => 'status_id',

342

:prop_key => 'status_id',

343

:old_value => STATUS_MAPPING[status_change.oldvalue].id,

343

:old_value => STATUS_MAPPING[status_change.oldvalue].id,

344

:value => STATUS_MAPPING[status_change.newvalue].id)

344

:value => STATUS_MAPPING[status_change.newvalue].id)

345

end

345

end

346

if resolution_change

346

if resolution_change

347

n.details << JournalDetail.new(:property => 'cf',

347

n.details << JournalDetail.new(:property => 'cf',

348

:prop_key => custom_field_map['resolution'].id,

348

:prop_key => custom_field_map['resolution'].id,

349

:old_value => resolution_change.oldvalue,

349

:old_value => resolution_change.oldvalue,

350

:value => resolution_change.newvalue)

350

:value => resolution_change.newvalue)

351

end

351

end

352

n.save unless n.details.empty? && n.notes.blank?

352

n.save unless n.details.empty? && n.notes.blank?

353

end

353

end

354

355

# Attachments

355

# Attachments

356

ticket.attachments.each do |attachment|

356

ticket.attachments.each do |attachment|

357

next unless attachment.exist?

357

next unless attachment.exist?

358

a = Attachment.new :created_on => attachment.time

358

a = Attachment.new :created_on => attachment.time

359

a.file = attachment

359

a.file = attachment

360

a.author = find_or_create_user(attachment.author)

360

a.author = find_or_create_user(attachment.author)

361

a.container = i

361

a.container = i

362

migrated_ticket_attachments += 1 if a.save

362

migrated_ticket_attachments += 1 if a.save

363

end

363

end

364

365

# Custom fields

365

# Custom fields

366

ticket.customs.each do |custom|

366

ticket.customs.each do |custom|

367

next if custom_field_map[custom.name].nil?

367

next if custom_field_map[custom.name].nil?

368

v = CustomValue.new :custom_field => custom_field_map[custom.name],

368

v = CustomValue.new :custom_field => custom_field_map[custom.name],

369

:value => custom.value

369

:value => custom.value

370

v.customized = i

370

v.customized = i

371

next unless v.save

371

next unless v.save

372

migrated_custom_values += 1

372

migrated_custom_values += 1

373

end

373

end

374

end

374

end

375

376

# update issue id sequence if needed

377

begin

378

case ActiveRecord::Base.connection.adapter_name.downcase

379

when 'mysql'

380

# nothing to do

381

when 'postgresql'

382

sql = "SELECT setval('#{Issue.table_name}_id_seq', (SELECT MAX(id) FROM #{Issue.table_name}))"

383

ActiveRecord::Base.connection.execute(sql)

384

end

385

end

375

puts

386

puts

376

387

377

# Wiki

388

# Wiki

378

print "Migrating wiki"

389

print "Migrating wiki"

379

@target_project.wiki.destroy if @target_project.wiki

390

@target_project.wiki.destroy if @target_project.wiki

380

@target_project.reload

391

@target_project.reload

381

wiki = Wiki.new(:project => @target_project, :start_page => 'WikiStart')

392

wiki = Wiki.new(:project => @target_project, :start_page => 'WikiStart')

382

if wiki.save

393

if wiki.save

383

TracWikiPage.find(:all, :order => 'name, version').each do |page|

394

TracWikiPage.find(:all, :order => 'name, version').each do |page|

384

print '.'

395

print '.'

385

STDOUT.flush

396

STDOUT.flush

386

p = wiki.find_or_new_page(page.name)

397

p = wiki.find_or_new_page(page.name)

387

p.content = WikiContent.new(:page => p) if p.new_record?

398

p.content = WikiContent.new(:page => p) if p.new_record?

388

p.content.text = page.text

399

p.content.text = page.text

389

p.content.author = find_or_create_user(page.author) unless page.author.blank? || page.author == 'trac'

400

p.content.author = find_or_create_user(page.author) unless page.author.blank? || page.author == 'trac'

390

p.content.comments = page.comment

401

p.content.comments = page.comment

391

p.new_record? ? p.save : p.content.save

402

p.new_record? ? p.save : p.content.save

392

migrated_wiki_edits += 1 unless p.content.new_record?

403

migrated_wiki_edits += 1 unless p.content.new_record?

393

end

404

end

394

405

395

wiki.reload

406

wiki.reload

396

wiki.pages.each do |page|

407

wiki.pages.each do |page|

397

page.content.text = convert_wiki_text(page.content.text)

408

page.content.text = convert_wiki_text(page.content.text)

398

page.content.save

409

page.content.save

399

end

410

end

400

end

411

end

401

puts

412

puts

402

413

403

puts

414

puts

404

puts "Components: #{migrated_components}/#{TracComponent.count}"

415

puts "Components: #{migrated_components}/#{TracComponent.count}"

405

puts "Milestones: #{migrated_milestones}/#{TracMilestone.count}"

416

puts "Milestones: #{migrated_milestones}/#{TracMilestone.count}"

406

puts "Tickets: #{migrated_tickets}/#{TracTicket.count}"

417

puts "Tickets: #{migrated_tickets}/#{TracTicket.count}"

407

puts "Ticket files: #{migrated_ticket_attachments}/" + TracAttachment.count("type = 'ticket'").to_s

418

puts "Ticket files: #{migrated_ticket_attachments}/" + TracAttachment.count("type = 'ticket'").to_s

408

puts "Custom values: #{migrated_custom_values}/#{TracTicketCustom.count}"

419

puts "Custom values: #{migrated_custom_values}/#{TracTicketCustom.count}"

409

puts "Wiki edits: #{migrated_wiki_edits}/#{TracWikiPage.count}"

420

puts "Wiki edits: #{migrated_wiki_edits}/#{TracWikiPage.count}"

410

end

421

end

411

422

412

def self.limit_for(klass, attribute)

423

def self.limit_for(klass, attribute)

413

klass.columns_hash[attribute.to_s].limit

424

klass.columns_hash[attribute.to_s].limit

414

end

425

end

415

426

416

def self.encoding(charset)

427

def self.encoding(charset)

417

@ic = Iconv.new('UTF-8', charset)

428

@ic = Iconv.new('UTF-8', charset)

418

rescue Iconv::InvalidEncoding

429

rescue Iconv::InvalidEncoding

419

puts "Invalid encoding!"

430

puts "Invalid encoding!"

420

return false

431

return false

421

end

432

end

422

433

423

def self.set_trac_directory(path)

434

def self.set_trac_directory(path)

424

@@trac_directory = path

435

@@trac_directory = path

425

raise "This directory doesn't exist!" unless File.directory?(path)

436

raise "This directory doesn't exist!" unless File.directory?(path)

426

raise "#{trac_attachments_directory} doesn't exist!" unless File.directory?(trac_attachments_directory)

437

raise "#{trac_attachments_directory} doesn't exist!" unless File.directory?(trac_attachments_directory)

427

@@trac_directory

438

@@trac_directory

428

rescue Exception => e

439

rescue Exception => e

429

puts e

440

puts e

430

return false

441

return false

431

end

442

end

432

443

433

def self.trac_directory

444

def self.trac_directory

434

@@trac_directory

445

@@trac_directory

435

end

446

end

436

447

437

def self.set_trac_adapter(adapter)

448

def self.set_trac_adapter(adapter)

438

return false if adapter.blank?

449

return false if adapter.blank?

439

raise "Unknown adapter: #{adapter}!" unless %w(sqlite sqlite3 mysql postgresql).include?(adapter)

450

raise "Unknown adapter: #{adapter}!" unless %w(sqlite sqlite3 mysql postgresql).include?(adapter)

440

# If adapter is sqlite or sqlite3, make sure that trac.db exists

451

# If adapter is sqlite or sqlite3, make sure that trac.db exists

441

raise "#{trac_db_path} doesn't exist!" if %w(sqlite sqlite3).include?(adapter) && !File.exist?(trac_db_path)

452

raise "#{trac_db_path} doesn't exist!" if %w(sqlite sqlite3).include?(adapter) && !File.exist?(trac_db_path)

442

@@trac_adapter = adapter

453

@@trac_adapter = adapter

443

rescue Exception => e

454

rescue Exception => e

444

puts e

455

puts e

445

return false

456

return false

446

end

457

end

447

458

448

def self.set_trac_db_host(host)

459

def self.set_trac_db_host(host)

449

return nil if host.blank?

460

return nil if host.blank?

450

@@trac_db_host = host

461

@@trac_db_host = host

451

end

462

end

452

463

453

def self.set_trac_db_port(port)

464

def self.set_trac_db_port(port)

454

return nil if port.to_i == 0

465

return nil if port.to_i == 0

455

@@trac_db_port = port.to_i

466

@@trac_db_port = port.to_i

456

end

467

end

457

468

458

def self.set_trac_db_name(name)

469

def self.set_trac_db_name(name)

459

return nil if name.blank?

470

return nil if name.blank?

460

@@trac_db_name = name

471

@@trac_db_name = name

461

end

472

end

462

473

463

def self.set_trac_db_username(username)

474

def self.set_trac_db_username(username)

464

@@trac_db_username = username

475

@@trac_db_username = username

465

end

476

end

466

477

467

def self.set_trac_db_password(password)

478

def self.set_trac_db_password(password)

468

@@trac_db_password = password

479

@@trac_db_password = password

469

end

480

end

470

481

471

mattr_reader :trac_directory, :trac_adapter, :trac_db_host, :trac_db_port, :trac_db_name, :trac_db_username, :trac_db_password

482

mattr_reader :trac_directory, :trac_adapter, :trac_db_host, :trac_db_port, :trac_db_name, :trac_db_username, :trac_db_password

472

483

473

def self.trac_db_path; "#{trac_directory}/db/trac.db" end

484

def self.trac_db_path; "#{trac_directory}/db/trac.db" end

474

def self.trac_attachments_directory; "#{trac_directory}/attachments" end

485

def self.trac_attachments_directory; "#{trac_directory}/attachments" end

475

486

476

def self.target_project_identifier(identifier)

487

def self.target_project_identifier(identifier)

477

project = Project.find_by_identifier(identifier)

488

project = Project.find_by_identifier(identifier)

478

if !project

489

if !project

479

# create the target project

490

# create the target project

480

project = Project.new :name => identifier.humanize,

491

project = Project.new :name => identifier.humanize,

481

:description => ~~identifier~~.~~humanize~~

492

:description => ''

482

project.identifier = identifier

493

project.identifier = identifier

483

puts "Unable to create a project with identifier '#{identifier}'!" unless project.save

494

puts "Unable to create a project with identifier '#{identifier}'!" unless project.save

484

# enable issues and wiki for the created project

495

# enable issues and wiki for the created project

485

project.enabled_module_names = ['issue_tracking', 'wiki']

496

project.enabled_module_names = ['issue_tracking', 'wiki']

486

end

497

end

487

project.trackers << TRACKER_BUG

498

project.trackers << TRACKER_BUG

488

project.trackers << TRACKER_FEATURE

499

project.trackers << TRACKER_FEATURE

489

@target_project = project.new_record? ? nil : project

500

@target_project = project.new_record? ? nil : project

490

end

501

end

491

502

492

def self.connection_params

503

def self.connection_params

493

if %w(sqlite sqlite3).include?(trac_adapter)

504

if %w(sqlite sqlite3).include?(trac_adapter)

494

{:adapter => trac_adapter,

505

{:adapter => trac_adapter,

495

:database => trac_db_path}

506

:database => trac_db_path}

496

else

507

else

497

{:adapter => trac_adapter,

508

{:adapter => trac_adapter,

498

:database => trac_db_name,

509

:database => trac_db_name,

499

:host => trac_db_host,

510

:host => trac_db_host,

500

:port => trac_db_port,

511

:port => trac_db_port,

501

:username => trac_db_username,

512

:username => trac_db_username,

502

:password => trac_db_password}

513

:password => trac_db_password}

503

end

514

end

504

end

515

end

505

516

506

def self.establish_connection

517

def self.establish_connection

507

constants.each do |const|

518

constants.each do |const|

508

klass = const_get(const)

519

klass = const_get(const)

509

next unless klass.respond_to? 'establish_connection'

520

next unless klass.respond_to? 'establish_connection'

510

klass.establish_connection connection_params

521

klass.establish_connection connection_params

511

end

522

end

512

end

523

end

513

524

514

private

525

private

515

def self.encode(text)

526

def self.encode(text)

516

@ic.iconv text

527

@ic.iconv text

517

rescue

528

rescue

518

text

529

text

519

end

530

end

520

end

531

end

521

532

522

puts

533

puts

523

puts "WARNING: a new project will be added to Redmine during this process."

534

puts "WARNING: a new project will be added to Redmine during this process."

524

print "Are you sure you want to continue ? [y/N] "

535

print "Are you sure you want to continue ? [y/N] "

525

break unless STDIN.gets.match(/^y$/i)

536

break unless STDIN.gets.match(/^y$/i)

526

puts

537

puts

527

538

528

def prompt(text, options = {}, &block)

539

def prompt(text, options = {}, &block)

529

default = options[:default] || ''

540

default = options[:default] || ''

530

while true

541

while true

531

print "#{text} [#{default}]: "

542

print "#{text} [#{default}]: "

532

value = STDIN.gets.chomp!

543

value = STDIN.gets.chomp!

533

value = default if value.blank?

544

value = default if value.blank?

534

break if yield value

545

break if yield value

535

end

546

end

536

end

547

end

537

548

538

DEFAULT_PORTS = {'mysql' => 3306, 'postgresl' => 5432}

549

DEFAULT_PORTS = {'mysql' => 3306, 'postgresl' => 5432}

539

550

540

prompt('Trac directory') {|directory| TracMigrate.set_trac_directory directory}

551

prompt('Trac directory') {|directory| TracMigrate.set_trac_directory directory}

541

prompt('Trac database adapter (sqlite, sqlite3, mysql, postgresql)', :default => 'sqlite') {|adapter| TracMigrate.set_trac_adapter adapter}

552

prompt('Trac database adapter (sqlite, sqlite3, mysql, postgresql)', :default => 'sqlite') {|adapter| TracMigrate.set_trac_adapter adapter}

542

unless %w(sqlite sqlite3).include?(TracMigrate.trac_adapter)

553

unless %w(sqlite sqlite3).include?(TracMigrate.trac_adapter)

543

prompt('Trac database host', :default => 'localhost') {|host| TracMigrate.set_trac_db_host host}

554

prompt('Trac database host', :default => 'localhost') {|host| TracMigrate.set_trac_db_host host}

544

prompt('Trac database port', :default => DEFAULT_PORTS[TracMigrate.trac_adapter]) {|port| TracMigrate.set_trac_db_port port}

555

prompt('Trac database port', :default => DEFAULT_PORTS[TracMigrate.trac_adapter]) {|port| TracMigrate.set_trac_db_port port}

545

prompt('Trac database name') {|name| TracMigrate.set_trac_db_name name}

556

prompt('Trac database name') {|name| TracMigrate.set_trac_db_name name}

546

prompt('Trac database username') {|username| TracMigrate.set_trac_db_username username}

557

prompt('Trac database username') {|username| TracMigrate.set_trac_db_username username}

547

prompt('Trac database password') {|password| TracMigrate.set_trac_db_password password}

558

prompt('Trac database password') {|password| TracMigrate.set_trac_db_password password}

548

end

559

end

549

prompt('Trac database encoding', :default => 'UTF-8') {|encoding| TracMigrate.encoding encoding}

560

prompt('Trac database encoding', :default => 'UTF-8') {|encoding| TracMigrate.encoding encoding}

550

prompt('Target project identifier') {|identifier| TracMigrate.target_project_identifier identifier}

561

prompt('Target project identifier') {|identifier| TracMigrate.target_project_identifier identifier}

551

puts

562

puts

552

563

553

TracMigrate.migrate

564

TracMigrate.migrate

554

end

565

end

555

end

566

end

	Site-wide shortcuts
/	Use quick search box
g h	Goto home page
g g	Goto my private gists page
g G	Goto my public gists page
g 0-9	Goto bookmarked items from 0-9
n r	New repository page
n g	New gist page

	Repositories
g s	Goto summary page
g c	Goto changelog page
g f	Goto files page
g F	Goto files page with file search activated
g p	Goto pull requests page
g o	Goto repository settings
g O	Goto repository access permissions settings
t s	Toggle sidebar on some pages

             # redMine - project management software
             # Copyright (C) 2006-2007  Jean-Philippe Lang
             #
             # This program is free software; you can redistribute it and/or
             # modify it under the terms of the GNU General Public License
             # as published by the Free Software Foundation; either version 2
             # of the License, or (at your option) any later version.
             #
             # This program is distributed in the hope that it will be useful,
             # but WITHOUT ANY WARRANTY; without even the implied warranty of
             # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
             # GNU General Public License for more details.
             #
             # You should have received a copy of the GNU General Public License
             # along with this program; if not, write to the Free Software
             # Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301, USA.
             require 'active_record'
             require 'iconv'
             require 'pp'
             namespace :redmine do
               desc 'Trac migration script'
               task :migrate_from_trac => :environment do
                 module TracMigrate
                     TICKET_MAP = []
                     DEFAULT_STATUS = IssueStatus.default
                     assigned_status = IssueStatus.find_by_position(2)
                     resolved_status = IssueStatus.find_by_position(3)
                     feedback_status = IssueStatus.find_by_position(4)
                     closed_status = IssueStatus.find :first, :conditions => { :is_closed => true }
                     STATUS_MAPPING = {'new' => DEFAULT_STATUS,
                                       'reopened' => feedback_status,
                                       'assigned' => assigned_status,
                                       'closed' => closed_status
                                       }
                     priorities = Enumeration.get_values('IPRI')
                     DEFAULT_PRIORITY = priorities[0]
                     PRIORITY_MAPPING = {'lowest' => priorities[0],
                                         'low' => priorities[0],
                                         'normal' => priorities[1],
                                         'high' => priorities[2],
                                         'highest' => priorities[3]
                                         }
                     TRACKER_BUG = Tracker.find_by_position(1)
                     TRACKER_FEATURE = Tracker.find_by_position(2)
                     DEFAULT_TRACKER = TRACKER_BUG
                     TRACKER_MAPPING = {'defect' => TRACKER_BUG,
                                        'enhancement' => TRACKER_FEATURE,
                                        'task' => TRACKER_FEATURE,
                                        'patch' =>TRACKER_FEATURE
                                        }
                     roles = Role.find(:all, :conditions => {:builtin => 0}, :order => 'position ASC')
                     manager_role = roles[0]
                     developer_role = roles[1]
                     DEFAULT_ROLE = roles.last
                     ROLE_MAPPING = {'admin' => manager_role,
                                     'developer' => developer_role
                                     }
                   class TracComponent < ActiveRecord::Base
                     set_table_name :component
                   end
                   class TracMilestone < ActiveRecord::Base
                     set_table_name :milestone
                     def due
                       if read_attribute(:due) > 0
                         Time.at(read_attribute(:due)).to_date
                       else
                         nil
                       end
                     end
                   end
                   class TracTicketCustom < ActiveRecord::Base
                     set_table_name :ticket_custom
                   end
                   class TracAttachment < ActiveRecord::Base
                     set_table_name :attachment
                     set_inheritance_column :none
                     def time; Time.at(read_attribute(:time)) end
                     def original_filename
                       filename
                     end
                     def content_type
                       Redmine::MimeType.of(filename) || ''
                     end
                     def exist?
                       File.file? trac_fullpath
                     end
                     def read
                       File.open("#{trac_fullpath}", 'rb').read
                     end
                   private
                     def trac_fullpath
                       attachment_type = read_attribute(:type)
                       trac_file = filename.gsub( /[^a-zA-Z0-9\-_\.!~*']/n ) {|x| sprintf('%%%02x', x[0]) }
                       "#{TracMigrate.trac_attachments_directory}/#{attachment_type}/#{id}/#{trac_file}"
                     end
                   end
                   class TracTicket < ActiveRecord::Base
                     set_table_name :ticket
                     set_inheritance_column :none
                     # ticket changes: only migrate status changes and comments
                     has_many :changes, :class_name => "TracTicketChange", :foreign_key => :ticket
                     has_many :attachments, :class_name => "TracAttachment", :foreign_key => :id, :conditions => "#{TracMigrate::TracAttachment.table_name}.type = 'ticket'"
                     has_many :customs, :class_name => "TracTicketCustom", :foreign_key => :ticket
                     def ticket_type
                       read_attribute(:type)
                     end
                     def summary
                       read_attribute(:summary).blank? ? "(no subject)" : read_attribute(:summary)
                     end
                     def description
                       read_attribute(:description).blank? ? summary : read_attribute(:description)
                     end
                     def time; Time.at(read_attribute(:time)) end
                   end
                   class TracTicketChange < ActiveRecord::Base
                     set_table_name :ticket_change
                     def time; Time.at(read_attribute(:time)) end
                   end
                   class TracWikiPage < ActiveRecord::Base
                     set_table_name :wiki
                     def self.columns
                       # Hides readonly Trac field to prevent clash with AR readonly? method (Rails 2.0)
                       super.select {|column| column.name.to_s != 'readonly'}
                     end
                   end
                   class TracPermission < ActiveRecord::Base
                     set_table_name :permission
                   end
                   def self.find_or_create_user(username, project_member = false)
                     u = User.find_by_login(username)
                     if !u
                       # Create a new user if not found
                       mail = username[0,limit_for(User, 'mail')]
                       mail = "#{mail}@foo.bar" unless mail.include?("@")
                       u = User.new :firstname => username[0,limit_for(User, 'firstname')].gsub(/[^\w\s\'\-]/i, '-'),
                                    :lastname => '-',
                                    :mail => mail.gsub(/[^-@a-z0-9\.]/i, '-')
                       u.login = username[0,limit_for(User, 'login')].gsub(/[^a-z0-9_\-@\.]/i, '-')
                       u.password = 'trac'
                       u.admin = true if TracPermission.find_by_username_and_action(username, 'admin')
                       # finally, a default user is used if the new user is not valid
                       u = User.find(:first) unless u.save
                     end
                     # Make sure he is a member of the project
                     if project_member && !u.member_of?(@target_project)
                       role = DEFAULT_ROLE
                       if u.admin
                         role = ROLE_MAPPING['admin']
                       elsif TracPermission.find_by_username_and_action(username, 'developer')
                         role = ROLE_MAPPING['developer']
                       end
                       Member.create(:user => u, :project => @target_project, :role => role)
                       u.reload
                     end
                     u
                   end
                   # Basic wiki syntax conversion
                   def self.convert_wiki_text(text)
                     # Titles
                     text = text.gsub(/^(\=+)\s(.+)\s(\=+)/) {|s| "\nh#{$1.length}. #{$2}\n"}
                     # External Links
                     text = text.gsub(/\[(http[^\s]+)\s+([^\]]+)\]/) {|s| "\"#{$2}\":#{$1}"}
                     # Internal Links
                     text = text.gsub(/\[\[BR\]\]/, "\n") # This has to go before the rules below
                     text = text.gsub(/\[\"(.+)\".*\]/) {|s| "[[#{$1.delete(',./?;|:')}]]"}
                     text = text.gsub(/\[wiki:\"(.+)\".*\]/) {|s| "[[#{$1.delete(',./?;|:')}]]"}
                     text = text.gsub(/\[wiki:\"(.+)\".*\]/) {|s| "[[#{$1.delete(',./?;|:')}]]"}
                     text = text.gsub(/\[wiki:([^\s\]]+).*\]/) {|s| "[[#{$1.delete(',./?;|:')}]]"}
                     # Revisions links
                     text = text.gsub(/\[(\d+)\]/, 'r\1')
                     # Ticket number re-writing
                     text = text.gsub(/#(\d+)/) do |s|
                       TICKET_MAP[$1.to_i] ||= $1
                       "\##{TICKET_MAP[$1.to_i] || $1}"
                     end
                     # Preformatted blocks
                     text = text.gsub(/\{\{\{/, '<pre>')
                     text = text.gsub(/\}\}\}/, '</pre>')
                     # Highlighting
                     text = text.gsub(/'''''([^\s])/, '_*\1')
                     text = text.gsub(/([^\s])'''''/, '\1*_')
                     text = text.gsub(/'''/, '*')
                     text = text.gsub(/''/, '_')
                     text = text.gsub(/__/, '+')
                     text = text.gsub(/~~/, '-')
                     text = text.gsub(/`/, '@')
                     text = text.gsub(/,,/, '~')
                     # Lists
                     text = text.gsub(/^([ ]+)\* /) {|s| '*' * $1.length + " "}
                     text
                   end
                   def self.migrate
                     establish_connection
                     # Quick database test
                     TracComponent.count
                     migrated_components = 0
                     migrated_milestones = 0
                     migrated_tickets = 0
                     migrated_custom_values = 0
                     migrated_ticket_attachments = 0
                     migrated_wiki_edits = 0
                     # Components
                     print "Migrating components"
                     issues_category_map = {}
                     TracComponent.find(:all).each do |component|
                   	print '.'
                   	STDOUT.flush
                       c = IssueCategory.new :project => @target_project,
                                             :name => encode(component.name[0, limit_for(IssueCategory, 'name')])
                   	next unless c.save
                   	issues_category_map[component.name] = c
                   	migrated_components += 1
                     end
                     puts
                     # Milestones
                     print "Migrating milestones"
                     version_map = {}
                     TracMilestone.find(:all).each do |milestone|
                       print '.'
                       STDOUT.flush
                       v = Version.new :project => @target_project,
                                       :name => encode(milestone.name[0, limit_for(Version, 'name')]),
                                       :description => encode(milestone.description.to_s[0, limit_for(Version, 'description')]),
                                       :effective_date => milestone.due
                       next unless v.save
                       version_map[milestone.name] = v
                       migrated_milestones += 1
                     end
                     puts
                     # Custom fields
                     # TODO: read trac.ini instead
                     print "Migrating custom fields"
                     custom_field_map = {}
                     TracTicketCustom.find_by_sql("SELECT DISTINCT name FROM #{TracTicketCustom.table_name}").each do |field|
                       print '.'
                       STDOUT.flush
                       # Redmine custom field name
                       field_name = encode(field.name[0, limit_for(IssueCustomField, 'name')]).humanize
                       # Find if the custom already exists in Redmine
                       f = IssueCustomField.find_by_name(field_name)
                       # Or create a new one
                       f ||= IssueCustomField.create(:name => encode(field.name[0, limit_for(IssueCustomField, 'name')]).humanize,
                                                     :field_format => 'string')
                       next if f.new_record?
                       f.trackers = Tracker.find(:all)
                       f.projects << @target_project
                       custom_field_map[field.name] = f
                     end
                     puts
                     # Trac 'resolution' field as a Redmine custom field
                     r = IssueCustomField.find(:first, :conditions => { :name => "Resolution" })
                     r = IssueCustomField.new(:name => 'Resolution',
                                              :field_format => 'list',
                                              :is_filter => true) if r.nil?
                     r.trackers = Tracker.find(:all)
                     r.projects << @target_project
                     r.possible_values = %w(fixed invalid wontfix duplicate worksforme)
                     custom_field_map['resolution'] = r if r.save
                     # Tickets
                     print "Migrating tickets"
                       TracTicket.find(:all, :order => 'id ASC').each do |ticket|
                     	print '.'
                     	STDOUT.flush
                     	i = Issue.new :project => @target_project,
                                       :subject => encode(ticket.summary[0, limit_for(Issue, 'subject')]),
                                       :description => convert_wiki_text(encode(ticket.description)),
                                       :priority => PRIORITY_MAPPING[ticket.priority] || DEFAULT_PRIORITY,
                                       :created_on => ticket.time
                     	i.author = find_or_create_user(ticket.reporter)
                     	i.category = issues_category_map[ticket.component] unless ticket.component.blank?
                     	i.fixed_version = version_map[ticket.milestone] unless ticket.milestone.blank?
                     	i.status = STATUS_MAPPING[ticket.status] || DEFAULT_STATUS
                     	i.tracker = TRACKER_MAPPING[ticket.ticket_type] || DEFAULT_TRACKER
                     	i.custom_values << CustomValue.new(:custom_field => custom_field_map['resolution'], :value => ticket.resolution) unless ticket.resolution.blank?
                     	i.id = ticket.id unless Issue.exists?(ticket.id)
                     	next unless i.save
                     	TICKET_MAP[ticket.id] = i.id
                     	migrated_tickets += 1
                     	# Owner
                         unless ticket.owner.blank?
                           i.assigned_to = find_or_create_user(ticket.owner, true)
                           i.save
                         end
                     	# Comments and status/resolution changes
                     	ticket.changes.group_by(&:time).each do |time, changeset|
                           status_change = changeset.select {|change| change.field == 'status'}.first
                           resolution_change = changeset.select {|change| change.field == 'resolution'}.first
                           comment_change = changeset.select {|change| change.field == 'comment'}.first
                           n = Journal.new :notes => (comment_change ? convert_wiki_text(encode(comment_change.newvalue)) : ''),
                                           :created_on => time
                           n.user = find_or_create_user(changeset.first.author)
                           n.journalized = i
                           if status_change &&
                                STATUS_MAPPING[status_change.oldvalue] &&
                                STATUS_MAPPING[status_change.newvalue] &&
                                (STATUS_MAPPING[status_change.oldvalue] != STATUS_MAPPING[status_change.newvalue])
                             n.details << JournalDetail.new(:property => 'attr',
                                                            :prop_key => 'status_id',
                                                            :old_value => STATUS_MAPPING[status_change.oldvalue].id,
                                                            :value => STATUS_MAPPING[status_change.newvalue].id)
                           end
                           if resolution_change
                             n.details << JournalDetail.new(:property => 'cf',
                                                            :prop_key => custom_field_map['resolution'].id,
                                                            :old_value => resolution_change.oldvalue,
                                                            :value => resolution_change.newvalue)
                           end
                           n.save unless n.details.empty? && n.notes.blank?
                     	end
                     	# Attachments
                     	ticket.attachments.each do |attachment|
                     	  next unless attachment.exist?
                           a = Attachment.new :created_on => attachment.time
                           a.file = attachment
                           a.author = find_or_create_user(attachment.author)
                           a.container = i
                           migrated_ticket_attachments += 1 if a.save
                     	end
                     	# Custom fields
                     	ticket.customs.each do |custom|
                     	  next if custom_field_map[custom.name].nil?
                           v = CustomValue.new :custom_field => custom_field_map[custom.name],
                                               :value => custom.value
                           v.customized = i
                           next unless v.save
                           migrated_custom_values += 1
                     	end
                     end
+                    # update issue id sequence if needed
+                    begin
+                      case ActiveRecord::Base.connection.adapter_name.downcase
+                      when 'mysql'
+                        # nothing to do
+                      when 'postgresql'
+                        sql = "SELECT setval('#{Issue.table_name}_id_seq', (SELECT MAX(id) FROM #{Issue.table_name}))"
+                        ActiveRecord::Base.connection.execute(sql)
+                      end
+                    end
                     puts
                     # Wiki
                     print "Migrating wiki"
                     @target_project.wiki.destroy if @target_project.wiki
                     @target_project.reload
                     wiki = Wiki.new(:project => @target_project, :start_page => 'WikiStart')
                     if wiki.save
                       TracWikiPage.find(:all, :order => 'name, version').each do |page|
                         print '.'
                         STDOUT.flush
                         p = wiki.find_or_new_page(page.name)
                         p.content = WikiContent.new(:page => p) if p.new_record?
                         p.content.text = page.text
                         p.content.author = find_or_create_user(page.author) unless page.author.blank? || page.author == 'trac'
                         p.content.comments = page.comment
                         p.new_record? ? p.save : p.content.save
                         migrated_wiki_edits += 1 unless p.content.new_record?
                       end
                       wiki.reload
                       wiki.pages.each do |page|
                         page.content.text = convert_wiki_text(page.content.text)
                         page.content.save
                       end
                     end
                     puts
                     puts
                     puts "Components:      #{migrated_components}/#{TracComponent.count}"
                     puts "Milestones:      #{migrated_milestones}/#{TracMilestone.count}"
                     puts "Tickets:         #{migrated_tickets}/#{TracTicket.count}"
                     puts "Ticket files:    #{migrated_ticket_attachments}/" + TracAttachment.count("type = 'ticket'").to_s
                     puts "Custom values:   #{migrated_custom_values}/#{TracTicketCustom.count}"
                     puts "Wiki edits:      #{migrated_wiki_edits}/#{TracWikiPage.count}"
                   end
                   def self.limit_for(klass, attribute)
                     klass.columns_hash[attribute.to_s].limit
                   end
                   def self.encoding(charset)
                     @ic = Iconv.new('UTF-8', charset)
                   rescue Iconv::InvalidEncoding
                     puts "Invalid encoding!"
                     return false
                   end
                   def self.set_trac_directory(path)
                     @@trac_directory = path
                     raise "This directory doesn't exist!" unless File.directory?(path)
                     raise "#{trac_attachments_directory} doesn't exist!" unless File.directory?(trac_attachments_directory)
                     @@trac_directory
                   rescue Exception => e
                     puts e
                     return false
                   end
                   def self.trac_directory
                     @@trac_directory
                   end
                   def self.set_trac_adapter(adapter)
                     return false if adapter.blank?
                     raise "Unknown adapter: #{adapter}!" unless %w(sqlite sqlite3 mysql postgresql).include?(adapter)
                     # If adapter is sqlite or sqlite3, make sure that trac.db exists
                     raise "#{trac_db_path} doesn't exist!" if %w(sqlite sqlite3).include?(adapter) && !File.exist?(trac_db_path)
                     @@trac_adapter = adapter
                   rescue Exception => e
                     puts e
                     return false
                   end
                   def self.set_trac_db_host(host)
                     return nil if host.blank?
                     @@trac_db_host = host
                   end
                   def self.set_trac_db_port(port)
                     return nil if port.to_i == 0
                     @@trac_db_port = port.to_i
                   end
                   def self.set_trac_db_name(name)
                     return nil if name.blank?
                     @@trac_db_name = name
                   end
                   def self.set_trac_db_username(username)
                     @@trac_db_username = username
                   end
                   def self.set_trac_db_password(password)
                     @@trac_db_password = password
                   end
                   mattr_reader :trac_directory, :trac_adapter, :trac_db_host, :trac_db_port, :trac_db_name, :trac_db_username, :trac_db_password
                   def self.trac_db_path; "#{trac_directory}/db/trac.db" end
                   def self.trac_attachments_directory; "#{trac_directory}/attachments" end
                   def self.target_project_identifier(identifier)
                     project = Project.find_by_identifier(identifier)
                     if !project
                       # create the target project
                       project = Project.new :name => identifier.humanize,
-                                            :description => identifier.humanize
+                                            :description => ''
                       project.identifier = identifier
                       puts "Unable to create a project with identifier '#{identifier}'!" unless project.save
                       # enable issues and wiki for the created project
                       project.enabled_module_names = ['issue_tracking', 'wiki']
                     end
                     project.trackers << TRACKER_BUG
                     project.trackers << TRACKER_FEATURE
                     @target_project = project.new_record? ? nil : project
                   end
                   def self.connection_params
                     if %w(sqlite sqlite3).include?(trac_adapter)
                       {:adapter => trac_adapter,
                        :database => trac_db_path}
                     else
                       {:adapter => trac_adapter,
                        :database => trac_db_name,
                        :host => trac_db_host,
                        :port => trac_db_port,
                        :username => trac_db_username,
                        :password => trac_db_password}
                     end
                   end
                   def self.establish_connection
                     constants.each do |const|
                       klass = const_get(const)
                       next unless klass.respond_to? 'establish_connection'
                       klass.establish_connection connection_params
                     end
                   end
                 private
                   def self.encode(text)
                     @ic.iconv text
                   rescue
                     text
                   end
                 end
                 puts
                 puts "WARNING: a new project will be added to Redmine during this process."
                 print "Are you sure you want to continue ? [y/N] "
                 break unless STDIN.gets.match(/^y$/i)
                 puts
                 def prompt(text, options = {}, &block)
                   default = options[:default] || ''
                   while true
                     print "#{text} [#{default}]: "
                     value = STDIN.gets.chomp!
                     value = default if value.blank?
                     break if yield value
                   end
                 end
                 DEFAULT_PORTS = {'mysql' => 3306, 'postgresl' => 5432}
                 prompt('Trac directory') {|directory| TracMigrate.set_trac_directory directory}
                 prompt('Trac database adapter (sqlite, sqlite3, mysql, postgresql)', :default => 'sqlite') {|adapter| TracMigrate.set_trac_adapter adapter}
                 unless %w(sqlite sqlite3).include?(TracMigrate.trac_adapter)
                   prompt('Trac database host', :default => 'localhost') {|host| TracMigrate.set_trac_db_host host}
                   prompt('Trac database port', :default => DEFAULT_PORTS[TracMigrate.trac_adapter]) {|port| TracMigrate.set_trac_db_port port}
                   prompt('Trac database name') {|name| TracMigrate.set_trac_db_name name}
                   prompt('Trac database username') {|username| TracMigrate.set_trac_db_username username}
                   prompt('Trac database password') {|password| TracMigrate.set_trac_db_password password}
                 end
                 prompt('Trac database encoding', :default => 'UTF-8') {|encoding| TracMigrate.encoding encoding}
                 prompt('Target project identifier') {|identifier| TracMigrate.target_project_identifier identifier}
                 puts
                 TracMigrate.migrate
               end
             end