# frozen_string_literal: true # Redmine - project management software # Copyright (C) 2006-2019 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 File.expand_path('../../test_helper', __FILE__) class IssueImportTest < ActiveSupport::TestCase fixtures :projects, :enabled_modules, :users, :email_addresses, :roles, :members, :member_roles, :issues, :issue_statuses, :trackers, :projects_trackers, :versions, :issue_categories, :enumerations, :workflows, :custom_fields, :custom_values, :custom_fields_projects, :custom_fields_trackers include Redmine::I18n def setup User.current = nil set_language_if_valid 'en' end def test_authorized assert IssueImport.authorized?(User.find(1)) # admins assert IssueImport.authorized?(User.find(2)) # has import_issues permission assert !IssueImport.authorized?(User.find(3)) # does not have permission end def test_create_versions_should_create_missing_versions import = generate_import_with_mapping import.mapping.merge!('fixed_version' => '9', 'create_versions' => '1') import.save! version = new_record(Version) do assert_difference 'Issue.count', 3 do import.run end end assert_equal '2.1', version.name end def test_create_categories_should_create_missing_categories import = generate_import_with_mapping import.mapping.merge!('category' => '10', 'create_categories' => '1') import.save! category = new_record(IssueCategory) do assert_difference 'Issue.count', 3 do import.run end end assert_equal 'New category', category.name end def test_mapping_with_fixed_tracker import = generate_import_with_mapping import.mapping.merge!('tracker' => 'value:2') import.save! issues = new_records(Issue, 3) { import.run } assert_equal [2], issues.map(&:tracker_id).uniq end def test_mapping_with_mapped_tracker import = generate_import_with_mapping import.mapping.merge!('tracker' => '13') import.save! issues = new_records(Issue, 3) { import.run } assert_equal [1, 2, 1], issues.map(&:tracker_id) end def test_should_not_import_with_default_tracker_when_tracker_is_invalid Tracker.find_by_name('Feature request').update!(:name => 'Feature') import = generate_import_with_mapping import.mapping.merge!('tracker' => '13') import.save! import.run assert_equal 1, import.unsaved_items.count item = import.unsaved_items.first assert_include "Tracker cannot be blank", item.message end def test_status_should_be_set import = generate_import_with_mapping import.mapping.merge!('status' => '14') import.save! issues = new_records(Issue, 3) { import.run } assert_equal ['New', 'New', 'Assigned'], issues.map(&:status).map(&:name) end def test_parent_should_be_set import = generate_import_with_mapping import.mapping.merge!('parent_issue_id' => '5') import.save! issues = new_records(Issue, 3) { import.run } assert_nil issues[0].parent assert_equal issues[0].id, issues[1].parent_id assert_equal 2, issues[2].parent_id end def test_import_utf8_with_bom import = generate_import_with_mapping('import_issues_utf8_with_bom.csv') import.settings.merge!('encoding' => 'UTF-8') import.save issues = new_records(Issue,3) { import.run } assert_equal 3, issues.count end def test_backward_and_forward_reference_to_parent_should_work import = generate_import('import_subtasks.csv') import.settings = { 'separator' => ";", 'wrapper' => '"', 'encoding' => "UTF-8", 'mapping' => {'project_id' => '1', '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_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') import.save! issues = new_records(Issue, 3) { import.run } assert_equal [User.find(3), nil, nil], issues.map(&:assigned_to) end def test_user_custom_field_should_be_set field = IssueCustomField.generate!(:field_format => 'user', :is_for_all => true, :trackers => Tracker.all) import = generate_import_with_mapping import.mapping.merge!("cf_#{field.id}" => '11') import.save! issues = new_records(Issue, 3) { import.run } assert_equal '3', issues.first.custom_field_value(field) end def test_list_custom_field_should_be_set field = CustomField.find(1) field.tracker_ids = Tracker.all.ids field.save! import = generate_import_with_mapping import.mapping.merge!("cf_1" => '8') import.save! issues = new_records(Issue, 3) { import.run } assert_equal 'PostgreSQL', issues[0].custom_field_value(1) assert_equal 'MySQL', issues[1].custom_field_value(1) assert_equal '', issues.third.custom_field_value(1) end def test_multiple_list_custom_field_should_be_set field = CustomField.find(1) field.tracker_ids = Tracker.all.ids field.multiple = true field.save! import = generate_import_with_mapping import.mapping.merge!("cf_1" => '15') import.save! issues = new_records(Issue, 3) { import.run } assert_equal ['Oracle', 'PostgreSQL'], issues[0].custom_field_value(1).sort assert_equal ['MySQL'], issues[1].custom_field_value(1) assert_equal [''], issues.third.custom_field_value(1) end def test_is_private_should_be_set_based_on_user_locale import = generate_import_with_mapping import.mapping.merge!('is_private' => '6') import.save! issues = new_records(Issue, 3) { import.run } assert_equal [false, true, false], issues.map(&:is_private) end def test_dates_should_be_parsed_using_date_format_setting field = IssueCustomField.generate!(:field_format => 'date', :is_for_all => true, :trackers => Tracker.all) import = generate_import_with_mapping('import_dates.csv') import.settings.merge!('date_format' => Import::DATE_FORMATS[1]) import.mapping.merge!('tracker' => 'value:1', 'subject' => '0', 'start_date' => '1', 'due_date' => '2', "cf_#{field.id}" => '3') import.save! issue = new_record(Issue) { import.run } # only 1 valid issue assert_equal "Valid dates", issue.subject assert_equal Date.parse('2015-07-10'), issue.start_date assert_equal Date.parse('2015-08-12'), issue.due_date assert_equal '2015-07-14', issue.custom_field_value(field) # Tests using other date formats import = generate_import_with_mapping('import_dates_ja.csv') import.settings.merge!('date_format' => Import::DATE_FORMATS[3]) import.mapping.merge!('tracker' => 'value:1', 'subject' => '0', 'start_date' => '1') import.save! issue = new_record(Issue) { import.run } assert_equal Date.parse('2019-05-28'), issue.start_date end def test_date_format_should_default_to_user_language user = User.generate!(:language => 'fr') import = Import.new import.user = user assert_nil import.settings['date_format'] import.set_default_settings assert_equal '%d/%m/%Y', import.settings['date_format'] end def test_run_should_remove_the_file import = generate_import_with_mapping file_path = import.filepath assert File.exists?(file_path) import.run assert !File.exists?(file_path) end def test_run_should_consider_project_shared_versions system_version = Version.generate!(:project_id => 2, :sharing => 'system', :name => '2.1') system_version.save! import = generate_import_with_mapping import.mapping.merge!('fixed_version' => '9') import.save! issues = new_records(Issue, 3) { import.run } assert [nil, 3, system_version.id], issues.map(&:fixed_version_id) end def test_set_default_settings_with_project_id import = Import.new import.set_default_settings(:project_id => 3) assert_equal 3, import.mapping['project_id'] end def test_set_default_settings_with_project_identifier import = Import.new import.set_default_settings(:project_id => 'ecookbook') assert_equal 1, import.mapping['project_id'] end def test_set_default_settings_without_project_id import = Import.new import.set_default_settings assert_empty import.mapping end def test_set_default_settings_with_invalid_project_should_not_fail import = Import.new import.set_default_settings(:project_id => 'abc') assert_empty import.mapping end end