# Redmine - project management software # Copyright (C) 2006-2014 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 Redmine::ApiTest::IssuesTest < Redmine::ApiTest::Base fixtures :projects, :users, :roles, :members, :member_roles, :issues, :issue_statuses, :issue_relations, :versions, :trackers, :projects_trackers, :issue_categories, :enabled_modules, :enumerations, :attachments, :workflows, :custom_fields, :custom_values, :custom_fields_projects, :custom_fields_trackers, :time_entries, :journals, :journal_details, :queries, :attachments test "GET /issues.xml should contain metadata" do get '/issues.xml' assert_select 'issues[type=array][total_count=?][limit="25"][offset="0"]', assigns(:issue_count).to_s end test "GET /issues.xml with nometa param should not contain metadata" do get '/issues.xml?nometa=1' assert_select 'issues[type=array]:not([total_count]):not([limit]):not([offset])' end test "GET /issues.xml with nometa header should not contain metadata" do get '/issues.xml', {}, {'X-Redmine-Nometa' => '1'} assert_select 'issues[type=array]:not([total_count]):not([limit]):not([offset])' end test "GET /issues.xml with offset and limit" do get '/issues.xml?offset=2&limit=3' assert_equal 3, assigns(:limit) assert_equal 2, assigns(:offset) assert_select 'issues issue', 3 end test "GET /issues.xml with relations" do get '/issues.xml?include=relations' assert_response :success assert_equal 'application/xml', @response.content_type assert_select 'issue id:content(3)' do assert_select '~ relations relation', 1 assert_select '~ relations relation[id="2"][issue_id="2"][issue_to_id="3"][relation_type=relates]' end assert_select 'issue id:content(1)' do assert_select '~ relations' assert_select '~ relations relation', 0 end end test "GET /issues.xml with invalid query params" do get '/issues.xml', {:f => ['start_date'], :op => {:start_date => '='}} assert_response :unprocessable_entity assert_equal 'application/xml', @response.content_type assert_select 'errors error', :text => "Start date can't be blank" end test "GET /issues.xml with custom field filter" do get '/issues.xml', {:set_filter => 1, :f => ['cf_1'], :op => {:cf_1 => '='}, :v => {:cf_1 => ['MySQL']}} expected_ids = Issue.visible. joins(:custom_values). where(:custom_values => {:custom_field_id => 1, :value => 'MySQL'}).map(&:id) assert expected_ids.any? assert_select 'issues > issue > id', :count => expected_ids.count do |ids| ids.each { |id| assert expected_ids.delete(id.children.first.content.to_i) } end end test "GET /issues.xml with custom field filter (shorthand method)" do get '/issues.xml', {:cf_1 => 'MySQL'} expected_ids = Issue.visible. joins(:custom_values). where(:custom_values => {:custom_field_id => 1, :value => 'MySQL'}).map(&:id) assert expected_ids.any? assert_select 'issues > issue > id', :count => expected_ids.count do |ids| ids.each { |id| assert expected_ids.delete(id.children.first.content.to_i) } end end def test_index_should_include_issue_attributes get '/issues.xml' assert_select 'issues>issue>is_private', :text => 'false' end def test_index_should_allow_timestamp_filtering Issue.delete_all Issue.generate!(:subject => '1').update_column(:updated_on, Time.parse("2014-01-02T10:25:00Z")) Issue.generate!(:subject => '2').update_column(:updated_on, Time.parse("2014-01-02T12:13:00Z")) get '/issues.xml', {:set_filter => 1, :f => ['updated_on'], :op => {:updated_on => '<='}, :v => {:updated_on => ['2014-01-02T12:00:00Z']}} assert_select 'issues>issue', :count => 1 assert_select 'issues>issue>subject', :text => '1' get '/issues.xml', {:set_filter => 1, :f => ['updated_on'], :op => {:updated_on => '>='}, :v => {:updated_on => ['2014-01-02T12:00:00Z']}} assert_select 'issues>issue', :count => 1 assert_select 'issues>issue>subject', :text => '2' get '/issues.xml', {:set_filter => 1, :f => ['updated_on'], :op => {:updated_on => '>='}, :v => {:updated_on => ['2014-01-02T08:00:00Z']}} assert_select 'issues>issue', :count => 2 end test "GET /issues.xml with filter" do get '/issues.xml?status_id=5' expected_ids = Issue.visible.where(:status_id => 5).map(&:id) assert expected_ids.any? assert_select 'issues > issue > id', :count => expected_ids.count do |ids| ids.each { |id| assert expected_ids.delete(id.children.first.content.to_i) } end end test "GET /issues.json with filter" do get '/issues.json?status_id=5' json = ActiveSupport::JSON.decode(response.body) status_ids_used = json['issues'].collect {|j| j['status']['id'] } assert_equal 3, status_ids_used.length assert status_ids_used.all? {|id| id == 5 } end test "GET /issues/:id.xml with journals" do get '/issues/1.xml?include=journals' assert_select 'issue journals[type=array]' do assert_select 'journal[id="1"]' do assert_select 'details[type=array]' do assert_select 'detail[name=status_id]' do assert_select 'old_value', :text => '1' assert_select 'new_value', :text => '2' end end end end end test "GET /issues/:id.xml with custom fields" do get '/issues/3.xml' assert_select 'issue custom_fields[type=array]' do assert_select 'custom_field[id="1"]' do assert_select 'value', :text => 'MySQL' end end assert_nothing_raised do Hash.from_xml(response.body).to_xml end end test "GET /issues/:id.xml with multi custom fields" do field = CustomField.find(1) field.update_attribute :multiple, true issue = Issue.find(3) issue.custom_field_values = {1 => ['MySQL', 'Oracle']} issue.save! get '/issues/3.xml' assert_response :success assert_select 'issue custom_fields[type=array]' do assert_select 'custom_field[id="1"]' do assert_select 'value[type=array] value', 2 end end xml = Hash.from_xml(response.body) custom_fields = xml['issue']['custom_fields'] assert_kind_of Array, custom_fields field = custom_fields.detect {|f| f['id'] == '1'} assert_kind_of Hash, field assert_equal ['MySQL', 'Oracle'], field['value'].sort end test "GET /issues/:id.json with multi custom fields" do field = CustomField.find(1) field.update_attribute :multiple, true issue = Issue.find(3) issue.custom_field_values = {1 => ['MySQL', 'Oracle']} issue.save! get '/issues/3.json' assert_response :success json = ActiveSupport::JSON.decode(response.body) custom_fields = json['issue']['custom_fields'] assert_kind_of Array, custom_fields field = custom_fields.detect {|f| f['id'] == 1} assert_kind_of Hash, field assert_equal ['MySQL', 'Oracle'], field['value'].sort end test "GET /issues/:id.xml with empty value for multi custom field" do field = CustomField.find(1) field.update_attribute :multiple, true issue = Issue.find(3) issue.custom_field_values = {1 => ['']} issue.save! get '/issues/3.xml' assert_select 'issue custom_fields[type=array]' do assert_select 'custom_field[id="1"]' do assert_select 'value[type=array]:empty' end end xml = Hash.from_xml(response.body) custom_fields = xml['issue']['custom_fields'] assert_kind_of Array, custom_fields field = custom_fields.detect {|f| f['id'] == '1'} assert_kind_of Hash, field assert_equal [], field['value'] end test "GET /issues/:id.json with empty value for multi custom field" do field = CustomField.find(1) field.update_attribute :multiple, true issue = Issue.find(3) issue.custom_field_values = {1 => ['']} issue.save! get '/issues/3.json' assert_response :success json = ActiveSupport::JSON.decode(response.body) custom_fields = json['issue']['custom_fields'] assert_kind_of Array, custom_fields field = custom_fields.detect {|f| f['id'] == 1} assert_kind_of Hash, field assert_equal [], field['value'].sort end test "GET /issues/:id.xml with attachments" do get '/issues/3.xml?include=attachments' assert_select 'issue attachments[type=array]' do assert_select 'attachment', 5 assert_select 'attachment id:content(4)' do assert_select '~ filename', :text => 'source.rb' assert_select '~ content_url', :text => 'http://www.example.com/attachments/download/4/source.rb' end end end test "GET /issues/:id.xml with subtasks" do issue = Issue.generate_with_descendants!(:project_id => 1) get "/issues/#{issue.id}.xml?include=children" assert_select 'issue children[type=array]' do assert_select 'issue', 2 assert_select 'issue children', 1 end end test "GET /issues/:id.json with subtasks" do issue = Issue.generate_with_descendants!(:project_id => 1) get "/issues/#{issue.id}.json?include=children" json = ActiveSupport::JSON.decode(response.body) assert_equal 2, json['issue']['children'].size assert_equal 1, json['issue']['children'].select {|child| child.key?('children')}.size end def test_show_should_include_issue_attributes get '/issues/1.xml' assert_select 'issue>is_private', :text => 'false' end test "GET /issues/:id.xml?include=watchers should include watchers" do Watcher.create!(:user_id => 3, :watchable => Issue.find(1)) get '/issues/1.xml?include=watchers', {}, credentials('jsmith') assert_response :ok assert_equal 'application/xml', response.content_type assert_select 'issue' do assert_select 'watchers', Issue.find(1).watchers.count assert_select 'watchers' do assert_select 'user[id=3]' end end end test "POST /issues.xml should create an issue with the attributes" do assert_difference('Issue.count') do post '/issues.xml', {:issue => {:project_id => 1, :subject => 'API test', :tracker_id => 2, :status_id => 3}}, credentials('jsmith') end issue = Issue.order('id DESC').first assert_equal 1, issue.project_id assert_equal 2, issue.tracker_id assert_equal 3, issue.status_id assert_equal 'API test', issue.subject assert_response :created assert_equal 'application/xml', @response.content_type assert_select 'issue > id', :text => issue.id.to_s end test "POST /issues.xml with watcher_user_ids should create issue with watchers" do assert_difference('Issue.count') do post '/issues.xml', {:issue => {:project_id => 1, :subject => 'Watchers', :tracker_id => 2, :status_id => 3, :watcher_user_ids => [3, 1]}}, credentials('jsmith') assert_response :created end issue = Issue.order('id desc').first assert_equal 2, issue.watchers.size assert_equal [1, 3], issue.watcher_user_ids.sort end test "POST /issues.xml with failure should return errors" do assert_no_difference('Issue.count') do post '/issues.xml', {:issue => {:project_id => 1}}, credentials('jsmith') end assert_select 'errors error', :text => "Subject can't be blank" end test "POST /issues.json should create an issue with the attributes" do assert_difference('Issue.count') do post '/issues.json', {:issue => {:project_id => 1, :subject => 'API test', :tracker_id => 2, :status_id => 3}}, credentials('jsmith') end issue = Issue.order('id DESC').first assert_equal 1, issue.project_id assert_equal 2, issue.tracker_id assert_equal 3, issue.status_id assert_equal 'API test', issue.subject end test "POST /issues.json with failure should return errors" do assert_no_difference('Issue.count') do post '/issues.json', {:issue => {:project_id => 1}}, credentials('jsmith') end json = ActiveSupport::JSON.decode(response.body) assert json['errors'].include?("Subject can't be blank") end test "PUT /issues/:id.xml" do assert_difference('Journal.count') do put '/issues/6.xml', {:issue => {:subject => 'API update', :notes => 'A new note'}}, credentials('jsmith') end issue = Issue.find(6) assert_equal "API update", issue.subject journal = Journal.last assert_equal "A new note", journal.notes end test "PUT /issues/:id.xml with custom fields" do put '/issues/3.xml', {:issue => {:custom_fields => [ {'id' => '1', 'value' => 'PostgreSQL' }, {'id' => '2', 'value' => '150'} ]}}, credentials('jsmith') issue = Issue.find(3) assert_equal '150', issue.custom_value_for(2).value assert_equal 'PostgreSQL', issue.custom_value_for(1).value end test "PUT /issues/:id.xml with multi custom fields" do field = CustomField.find(1) field.update_attribute :multiple, true put '/issues/3.xml', {:issue => {:custom_fields => [ {'id' => '1', 'value' => ['MySQL', 'PostgreSQL'] }, {'id' => '2', 'value' => '150'} ]}}, credentials('jsmith') issue = Issue.find(3) assert_equal '150', issue.custom_value_for(2).value assert_equal ['MySQL', 'PostgreSQL'], issue.custom_field_value(1).sort end test "PUT /issues/:id.xml with project change" do put '/issues/3.xml', {:issue => {:project_id => 2, :subject => 'Project changed'}}, credentials('jsmith') issue = Issue.find(3) assert_equal 2, issue.project_id assert_equal 'Project changed', issue.subject end test "PUT /issues/:id.xml with failed update" do put '/issues/6.xml', {:issue => {:subject => ''}}, credentials('jsmith') assert_response :unprocessable_entity assert_select 'errors error', :text => "Subject can't be blank" end test "PUT /issues/:id.json" do assert_difference('Journal.count') do put '/issues/6.json', {:issue => {:subject => 'API update', :notes => 'A new note'}}, credentials('jsmith') assert_response :ok assert_equal '', response.body end issue = Issue.find(6) assert_equal "API update", issue.subject journal = Journal.last assert_equal "A new note", journal.notes end test "PUT /issues/:id.json with failed update" do put '/issues/6.json', {:issue => {:subject => ''}}, credentials('jsmith') assert_response :unprocessable_entity json = ActiveSupport::JSON.decode(response.body) assert json['errors'].include?("Subject can't be blank") end test "DELETE /issues/:id.xml" do assert_difference('Issue.count', -1) do delete '/issues/6.xml', {}, credentials('jsmith') assert_response :ok assert_equal '', response.body end assert_nil Issue.find_by_id(6) end test "DELETE /issues/:id.json" do assert_difference('Issue.count', -1) do delete '/issues/6.json', {}, credentials('jsmith') assert_response :ok assert_equal '', response.body end assert_nil Issue.find_by_id(6) end test "POST /issues/:id/watchers.xml should add watcher" do assert_difference 'Watcher.count' do post '/issues/1/watchers.xml', {:user_id => 3}, credentials('jsmith') assert_response :ok assert_equal '', response.body end watcher = Watcher.order('id desc').first assert_equal Issue.find(1), watcher.watchable assert_equal User.find(3), watcher.user end test "DELETE /issues/:id/watchers/:user_id.xml should remove watcher" do Watcher.create!(:user_id => 3, :watchable => Issue.find(1)) assert_difference 'Watcher.count', -1 do delete '/issues/1/watchers/3.xml', {}, credentials('jsmith') assert_response :ok assert_equal '', response.body end assert_equal false, Issue.find(1).watched_by?(User.find(3)) end def test_create_issue_with_uploaded_file set_tmp_attachments_directory # upload the file assert_difference 'Attachment.count' do post '/uploads.xml', 'test_create_with_upload', {"CONTENT_TYPE" => 'application/octet-stream'}.merge(credentials('jsmith')) assert_response :created end xml = Hash.from_xml(response.body) token = xml['upload']['token'] attachment = Attachment.order('id DESC').first # create the issue with the upload's token assert_difference 'Issue.count' do post '/issues.xml', {:issue => {:project_id => 1, :subject => 'Uploaded file', :uploads => [{:token => token, :filename => 'test.txt', :content_type => 'text/plain'}]}}, credentials('jsmith') assert_response :created end issue = Issue.order('id DESC').first assert_equal 1, issue.attachments.count assert_equal attachment, issue.attachments.first attachment.reload assert_equal 'test.txt', attachment.filename assert_equal 'text/plain', attachment.content_type assert_equal 'test_create_with_upload'.size, attachment.filesize assert_equal 2, attachment.author_id # get the issue with its attachments get "/issues/#{issue.id}.xml", :include => 'attachments' assert_response :success xml = Hash.from_xml(response.body) attachments = xml['issue']['attachments'] assert_kind_of Array, attachments assert_equal 1, attachments.size url = attachments.first['content_url'] assert_not_nil url # download the attachment get url assert_response :success end def test_update_issue_with_uploaded_file set_tmp_attachments_directory # upload the file assert_difference 'Attachment.count' do post '/uploads.xml', 'test_upload_with_upload', {"CONTENT_TYPE" => 'application/octet-stream'}.merge(credentials('jsmith')) assert_response :created end xml = Hash.from_xml(response.body) token = xml['upload']['token'] attachment = Attachment.order('id DESC').first # update the issue with the upload's token assert_difference 'Journal.count' do put '/issues/1.xml', {:issue => {:notes => 'Attachment added', :uploads => [{:token => token, :filename => 'test.txt', :content_type => 'text/plain'}]}}, credentials('jsmith') assert_response :ok assert_equal '', @response.body end issue = Issue.find(1) assert_include attachment, issue.attachments end end