Project

General

Profile

Feature #28213 » 0001-Support-external-ID-when-importing-issues.patch

Gregor Schmidt, 2018-02-19 10:28

View differences:

app/models/import.rb
# Adds a callback that will be called after the item at given position is imported
def add_callback(position, name, *args)
settings['callbacks'] ||= {}
settings['callbacks'][position.to_i] ||= []
settings['callbacks'][position.to_i] << [name, args]
settings['callbacks'][position] ||= []
settings['callbacks'][position] << [name, args]
save!
end
......
if position > resume_after
item = items.build
item.position = position
item.unique_id = row_value(row, 'unique_id') if use_unique_id?
if object = build_object(row, item)
if object.save
......
item.save!
imported += 1
do_callbacks(item.position, object)
do_callbacks(use_unique_id? ? item.unique_id : item.position, object)
end
current = position
end
......
def yes?(value)
value == lu(user, :general_text_yes) || value == '1'
end
def use_unique_id?
mapping['unique_id'].present?
end
end
app/models/issue_import.rb
end
end
if parent_issue_id = row_value(row, 'parent_issue_id')
if parent_issue_id =~ /\A(#)?(\d+)\z/
parent_issue_id = $2.to_i
if $1
attributes['parent_issue_id'] = parent_issue_id
if parent_issue_id.start_with? '#'
# refers to existing issue
attributes['parent_issue_id'] = parent_issue_id[1..-1]
elsif use_unique_id?
# refers to other row with unique id
issue_id = items.where(:unique_id => parent_issue_id).first.try(:obj_id)
if issue_id
attributes['parent_issue_id'] = issue_id
else
if parent_issue_id > item.position
add_callback(parent_issue_id, 'set_as_parent', item.position)
elsif issue_id = items.where(:position => parent_issue_id).first.try(:obj_id)
attributes['parent_issue_id'] = issue_id
end
add_callback(parent_issue_id, 'set_as_parent', item.position)
end
elsif parent_issue_id =~ /\A\d+\z/
# refers to other row by position
parent_issue_id = parent_issue_id.to_i
if parent_issue_id > item.position
add_callback(parent_issue_id, 'set_as_parent', item.position)
elsif issue_id = items.where(:position => parent_issue_id).first.try(:obj_id)
attributes['parent_issue_id'] = issue_id
end
else
# Something is odd. Assign parent_issue_id to trigger validation error
attributes['parent_issue_id'] = parent_issue_id
end
end
app/views/imports/_fields_mapping.html.erb
<div class="splitcontent">
<div class="splitcontentleft">
<p>
<label for="import_mapping_project_id"><%= l(:label_project) %></label>
<%= select_tag 'import_settings[mapping][project_id]',
......
<label for="import_mapping_status"><%= l(:field_status) %></label>
<%= mapping_select_tag @import, 'status' %>
</p>
</div>
<div class="splitcontentright">
<p></p>
<p>
<label for="import_mapping_unique_id"><%= l(:field_unique_id) %></label>
<%= mapping_select_tag @import, 'unique_id' %>
</p>
</div>
</div>
<div class="splitcontent">
<div class="splitcontentleft">
config/locales/de.yml
field_warn_on_leaving_unsaved: Vor dem Verlassen einer Seite mit ungesichertem Text im Editor warnen
field_watcher: Beobachter
field_default_assigned_to: Standardbearbeiter
field_unique_id: Eindeutige ID
general_csv_decimal_separator: ','
general_csv_encoding: ISO-8859-1
config/locales/en.yml
field_full_width_layout: Full width layout
field_digest: Checksum
field_default_assigned_to: Default assignee
field_unique_id: Unique ID
setting_app_title: Application title
setting_app_subtitle: Application subtitle
db/migrate/20180216132815_add_unique_id_to_import_items.rb
class AddUniqueIdToImportItems < ActiveRecord::Migration[5.1]
def change
change_table :import_items do |t|
t.string "unique_id"
t.index ["import_id", "unique_id"]
end
end
end
test/fixtures/files/import_subtasks_with_unique_id.csv
id;tracker;subject;parent
RED-I;bug;Root;
RED-II;bug;Child 1;RED-I
RED-III;bug;Grand-child;RED-IV
RED-IV;bug;Child 2;RED-I
test/unit/issue_import_test.rb
assert_equal child2, grandchild.parent
end
def test_backward_and_forward_reference_with_unique_id
import = generate_import_with_mapping('import_subtasks_with_unique_id.csv')
import.settings['mapping'] = {'project_id' => '1', 'unique_id' => '0', 'tracker' => '1', 'subject' => '2', 'parent_issue_id' => '3'}
import.save!
root, child1, grandchild, child2 = new_records(Issue, 4) { import.run }
assert_equal root, child1.parent
assert_equal child2, grandchild.parent
end
def test_assignee_should_be_set
import = generate_import_with_mapping
import.mapping.merge!('assigned_to' => '11')
(1-1/2)