1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
|
# frozen_string_literal: true
# Redmine - project management software
# Copyright (C) 2006-2023 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 TimeEntryImportTest < 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
include Redmine::I18n
def setup
set_language_if_valid 'en'
User.current = nil
end
def test_authorized
assert TimeEntryImport.authorized?(User.find(1)) # admins
assert TimeEntryImport.authorized?(User.find(2)) # has log_time permission
assert !TimeEntryImport.authorized?(User.find(6)) # anonymous does not have log_time permission
end
def test_maps_issue_id
import = generate_import_with_mapping
first, second, third, fourth = new_records(TimeEntry, 4) {import.run}
assert_nil first.issue_id
assert_nil second.issue_id
assert_equal 1, third.issue_id
assert_equal 2, fourth.issue_id
end
def test_maps_date
import = generate_import_with_mapping
first, second, third, fourth = new_records(TimeEntry, 4) {import.run}
assert_equal Date.new(2020, 1, 1), first.spent_on
assert_equal Date.new(2020, 1, 2), second.spent_on
assert_equal Date.new(2020, 1, 3), third.spent_on
assert_equal Date.new(2020, 1, 4), fourth.spent_on
end
def test_maps_hours
import = generate_import_with_mapping
first, second, third, fourth = new_records(TimeEntry, 4) {import.run}
assert_equal 1, first.hours
assert_equal 2, second.hours
assert_equal 3, third.hours
assert_equal 4, fourth.hours
end
def test_maps_comments
import = generate_import_with_mapping
first, second, third, fourth = new_records(TimeEntry, 4) {import.run}
assert_equal 'Some Design', first.comments
assert_equal 'Some Development', second.comments
assert_equal 'Some QA', third.comments
assert_equal 'Some Inactivity', fourth.comments
end
def test_maps_activity_to_column_value
import = generate_import_with_mapping
import.mapping['activity'] = '5'
import.save!
# N.B. last row is not imported due to the usage of a disabled activity
first, second, third = new_records(TimeEntry, 3) {import.run}
assert_equal 9, first.activity_id
assert_equal 10, second.activity_id
assert_equal 11, third.activity_id
last = import.items.last
assert_equal 'Activity cannot be blank', last.message
assert_nil last.obj_id
end
def test_maps_activity_to_fixed_value
import = generate_import_with_mapping
first, second, third, fourth = new_records(TimeEntry, 4) {import.run}
assert_equal 10, first.activity_id
assert_equal 10, second.activity_id
assert_equal 10, third.activity_id
assert_equal 10, fourth.activity_id
end
def test_maps_custom_fields
overtime_cf = CustomField.find(10)
import = generate_import_with_mapping
import.mapping['cf_10'] = '6'
import.save!
first, second, third, fourth = new_records(TimeEntry, 4) {import.run}
assert_equal '1', first.custom_field_value(overtime_cf)
assert_equal '1', second.custom_field_value(overtime_cf)
assert_equal '0', third.custom_field_value(overtime_cf)
assert_equal '0', fourth.custom_field_value(overtime_cf)
end
def test_maps_user_id_for_user_with_permissions
Role.find_by_name('Manager').add_permission! :log_time_for_other_users
import = generate_import_with_mapping
first, second, third, fourth = new_records(TimeEntry, 4) {import.run}
assert_equal 2, first.user_id
assert_equal 2, second.user_id
assert_equal 3, third.user_id
assert_equal 2, fourth.user_id
end
def test_maps_user_to_column_value
Role.find_by_name('Manager').add_permission! :log_time_for_other_users
import = generate_import_with_mapping
import.mapping['user'] = 'value:3'
import.save!
first, second, third, fourth = new_records(TimeEntry, 4) {import.run}
assert_equal 3, first.user_id
assert_equal 3, second.user_id
assert_equal 3, third.user_id
assert_equal 3, fourth.user_id
end
def test_maps_user_id_for_user_without_permissions
# User 2 doesn't have log_time_for_other_users permission
User.current = User.find(2)
import = generate_import_with_mapping
first, second, third, fourth = new_records(TimeEntry, 4) {import.run}
assert_equal 2, first.user_id
assert_equal 2, second.user_id
# user_id value from CSV should be ignored
assert_equal 2, third.user_id
assert_equal 2, fourth.user_id
end
def test_imports_timelogs_for_issues_in_other_project
import = generate_import
import.settings = {
'separator' => ';', 'wrapper' => '"', 'encoding' => 'UTF-8',
'mapping' => {
'project_id' => '3',
'activity' => 'value:10',
'issue_id' => '1',
'spent_on' => '2',
'hours' => '3',
'comments' => '4',
'user' => '7'
}
}
import.save!
first, second, third, fourth = new_records(TimeEntry, 4) {import.run}
assert_equal 3, first.project_id
assert_equal 3, second.project_id
assert_equal 1, third.project_id
assert_equal 1, fourth.project_id
end
protected
def generate_import(fixture_name='import_time_entries.csv')
import = TimeEntryImport.new
import.user_id = 2
import.file = uploaded_test_file(fixture_name, 'text/csv')
import.save!
import
end
def generate_import_with_mapping(fixture_name='import_time_entries.csv')
import = generate_import(fixture_name)
import.settings = {
'separator' => ';', 'wrapper' => '"', 'encoding' => 'UTF-8',
'mapping' => {
'project_id' => '1',
'activity' => 'value:10',
'issue_id' => '1',
'spent_on' => '2',
'hours' => '3',
'comments' => '4',
'user' => '7'
}
}
import.save!
import
end
end
|
