##// END OF EJS Templates
jro_apps » redmine
RSS
Upgraded to Rails 2.3.4 (#3597)...
Upgraded to Rails 2.3.4 (#3597) * Ran the Rails upgrade * Upgraded to Rails Engines 2.3.2 * Added a plugin to let Engines override application views. * Converted tests to use the new classes: ** ActionController::TestCase for functional ** ActiveSupport::TestCase for units * Converted ActiveRecord::Error message to a string. * ActiveRecord grouping returns an ordered hash which doesn't have #sort! * Updated the I18n storage_units format. * Added some default initializers from a fresh rails app * Changed the order of check_box_tags and hidden_field_tags. The hidden tag needs to appear first in Rails 2.3, otherwise it will override any value in the check_box_tag. * Removed the custom handler for when the cookie store is tampered with. Rails 2.3 removed the TamperedWithCookie exception and instead Rails will not load the data from it when it's been tampered with (e.g. no user login). * Fixed mail layouts, 2.3 has problems with implicit multipart emails that use layouts. Also removed some custom Redmine mailer code. * Fixed a bug that occurred in tests where the "required" span tag would be added to the :field_status translation. This resulted in an email string of: <li>Status<span class="required"> *</span><span class="required"> *</span> Instead of: <li>Status: New</li> git-svn-id: svn+ssh://rubyforge.org/var/svn/redmine/trunk@2887 e93f8b46-1217-0410-a6f0-8f06a7374b81
Eric Davis - - Load All Authors

File last commit:

r2773:7b0cb6aba871
r2773:7b0cb6aba871
Show More
query_test.rb
301 lines | 11.1 KiB | text/x-ruby | RubyLexer
/ test / unit / query_test.rb
History | Source | Raw |Copy content |Copy permalink
Jean-Philippe Lang
Fixed: queries with multiple custom fields return no result....
 r662 # redMine - project management software
Jean-Philippe Lang
Queries can be marked as 'For all projects'. Such queries will be available on all projects and on the global issue list (#897, closes #671)....
 r1296 # Copyright (C) 2006-2008 Jean-Philippe Lang
Jean-Philippe Lang
Fixed: queries with multiple custom fields return no result....
 r662 #
# 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.dirname(__FILE__) + '/../test_helper'
Eric Davis
Upgraded to Rails 2.3.4 (#3597)...
 r2773 class QueryTest < ActiveSupport::TestCase
Jean-Philippe Lang
Allows multiple roles on the same project (#706). Prerequisite for user groups feature....
 r2627 fixtures :projects, :enabled_modules, :users, :members, :member_roles, :roles, :trackers, :issue_statuses, :issue_categories, :enumerations, :issues, :watchers, :custom_fields, :custom_values, :versions, :queries
Jean-Philippe Lang
Fixed: queries with multiple custom fields return no result....
 r662
Jean-Philippe Lang
Add filters on cross-project issue list for custom fields marked as 'For all projects'....
 r1562 def test_custom_fields_for_all_projects_should_be_available_in_global_queries
query = Query.new(:project => nil, :name => '_')
assert query.available_filters.has_key?('cf_1')
assert !query.available_filters.has_key?('cf_3')
end
Jean-Philippe Lang
Adds estimated hours to issue filters (#1678)....
 r1687 def find_issues_with_query(query)
Issue.find :all,
:include => [ :assigned_to, :status, :tracker, :project, :priority ],
:conditions => query.statement
end
Jean-Philippe Lang
Fixed: queries with multiple custom fields return no result....
 r662 def test_query_with_multiple_custom_fields
query = Query.find(1)
assert query.valid?
Jean-Philippe Lang
Fixes custom field filters behaviour (#1078)....
 r1347 assert query.statement.include?("#{CustomValue.table_name}.value IN ('MySQL')")
Jean-Philippe Lang
Adds estimated hours to issue filters (#1678)....
 r1687 issues = find_issues_with_query(query)
Jean-Philippe Lang
Fixed: queries with multiple custom fields return no result....
 r662 assert_equal 1, issues.length
assert_equal Issue.find(3), issues.first
end
Jean-Philippe Lang
Added the ability to customize columns of a saved query....
 r771
Jean-Philippe Lang
Fixed: Search for target version of "none" fails with postgres 8.3 (#1134)....
 r1364 def test_operator_none
query = Query.new(:project => Project.find(1), :name => '_')
query.add_filter('fixed_version_id', '!*', [''])
query.add_filter('cf_1', '!*', [''])
assert query.statement.include?("#{Issue.table_name}.fixed_version_id IS NULL")
assert query.statement.include?("#{CustomValue.table_name}.value IS NULL OR #{CustomValue.table_name}.value = ''")
Jean-Philippe Lang
Adds estimated hours to issue filters (#1678)....
 r1687 find_issues_with_query(query)
Jean-Philippe Lang
Fixed: Search for target version of "none" fails with postgres 8.3 (#1134)....
 r1364 end
Jean-Philippe Lang
Adds estimated hours to issue filters (#1678)....
 r1687 def test_operator_none_for_integer
query = Query.new(:project => Project.find(1), :name => '_')
query.add_filter('estimated_hours', '!*', [''])
issues = find_issues_with_query(query)
assert !issues.empty?
assert issues.all? {|i| !i.estimated_hours}
end
Jean-Philippe Lang
Fixed: Search for target version of "none" fails with postgres 8.3 (#1134)....
 r1364 def test_operator_all
query = Query.new(:project => Project.find(1), :name => '_')
query.add_filter('fixed_version_id', '*', [''])
query.add_filter('cf_1', '*', [''])
assert query.statement.include?("#{Issue.table_name}.fixed_version_id IS NOT NULL")
assert query.statement.include?("#{CustomValue.table_name}.value IS NOT NULL AND #{CustomValue.table_name}.value <> ''")
Jean-Philippe Lang
Adds estimated hours to issue filters (#1678)....
 r1687 find_issues_with_query(query)
Jean-Philippe Lang
Fixed: Search for target version of "none" fails with postgres 8.3 (#1134)....
 r1364 end
def test_operator_greater_than
query = Query.new(:project => Project.find(1), :name => '_')
query.add_filter('done_ratio', '>=', ['40'])
assert query.statement.include?("#{Issue.table_name}.done_ratio >= 40")
Jean-Philippe Lang
Adds estimated hours to issue filters (#1678)....
 r1687 find_issues_with_query(query)
Jean-Philippe Lang
Fixed: Search for target version of "none" fails with postgres 8.3 (#1134)....
 r1364 end
def test_operator_in_more_than
Jean-Philippe Lang
Fixed date filters accuracy with SQLite (#2221)....
 r2052 Issue.find(7).update_attribute(:due_date, (Date.today + 15))
Jean-Philippe Lang
Fixed: Search for target version of "none" fails with postgres 8.3 (#1134)....
 r1364 query = Query.new(:project => Project.find(1), :name => '_')
query.add_filter('due_date', '>t+', ['15'])
Jean-Philippe Lang
Fixed date filters accuracy with SQLite (#2221)....
 r2052 issues = find_issues_with_query(query)
assert !issues.empty?
issues.each {|issue| assert(issue.due_date >= (Date.today + 15))}
Jean-Philippe Lang
Fixed: Search for target version of "none" fails with postgres 8.3 (#1134)....
 r1364 end
def test_operator_in_less_than
query = Query.new(:project => Project.find(1), :name => '_')
query.add_filter('due_date', '<t+', ['15'])
Jean-Philippe Lang
Fixed date filters accuracy with SQLite (#2221)....
 r2052 issues = find_issues_with_query(query)
assert !issues.empty?
issues.each {|issue| assert(issue.due_date >= Date.today && issue.due_date <= (Date.today + 15))}
end
def test_operator_less_than_ago
Issue.find(7).update_attribute(:due_date, (Date.today - 3))
query = Query.new(:project => Project.find(1), :name => '_')
query.add_filter('due_date', '>t-', ['3'])
issues = find_issues_with_query(query)
assert !issues.empty?
issues.each {|issue| assert(issue.due_date >= (Date.today - 3) && issue.due_date <= Date.today)}
end
def test_operator_more_than_ago
Issue.find(7).update_attribute(:due_date, (Date.today - 10))
query = Query.new(:project => Project.find(1), :name => '_')
query.add_filter('due_date', '<t-', ['10'])
assert query.statement.include?("#{Issue.table_name}.due_date <=")
issues = find_issues_with_query(query)
assert !issues.empty?
issues.each {|issue| assert(issue.due_date <= (Date.today - 10))}
end
def test_operator_in
Issue.find(7).update_attribute(:due_date, (Date.today + 2))
query = Query.new(:project => Project.find(1), :name => '_')
query.add_filter('due_date', 't+', ['2'])
issues = find_issues_with_query(query)
assert !issues.empty?
issues.each {|issue| assert_equal((Date.today + 2), issue.due_date)}
end
def test_operator_ago
Issue.find(7).update_attribute(:due_date, (Date.today - 3))
query = Query.new(:project => Project.find(1), :name => '_')
query.add_filter('due_date', 't-', ['3'])
issues = find_issues_with_query(query)
assert !issues.empty?
issues.each {|issue| assert_equal((Date.today - 3), issue.due_date)}
Jean-Philippe Lang
Fixed: Search for target version of "none" fails with postgres 8.3 (#1134)....
 r1364 end
def test_operator_today
query = Query.new(:project => Project.find(1), :name => '_')
query.add_filter('due_date', 't', [''])
Jean-Philippe Lang
Fixed date filters accuracy with SQLite (#2221)....
 r2052 issues = find_issues_with_query(query)
assert !issues.empty?
issues.each {|issue| assert_equal Date.today, issue.due_date}
Jean-Philippe Lang
Fixed: Search for target version of "none" fails with postgres 8.3 (#1134)....
 r1364 end
def test_operator_this_week_on_date
query = Query.new(:project => Project.find(1), :name => '_')
query.add_filter('due_date', 'w', [''])
Jean-Philippe Lang
Adds estimated hours to issue filters (#1678)....
 r1687 find_issues_with_query(query)
Jean-Philippe Lang
Fixed: Search for target version of "none" fails with postgres 8.3 (#1134)....
 r1364 end
def test_operator_this_week_on_datetime
query = Query.new(:project => Project.find(1), :name => '_')
query.add_filter('created_on', 'w', [''])
Jean-Philippe Lang
Adds estimated hours to issue filters (#1678)....
 r1687 find_issues_with_query(query)
Jean-Philippe Lang
Fixed: Search for target version of "none" fails with postgres 8.3 (#1134)....
 r1364 end
def test_operator_contains
query = Query.new(:project => Project.find(1), :name => '_')
Jean-Philippe Lang
Fixed: case sensitivity in issue subject filtering (#3536)....
 r2696 query.add_filter('subject', '~', ['uNable'])
assert query.statement.include?("LOWER(#{Issue.table_name}.subject) LIKE '%unable%'")
result = find_issues_with_query(query)
assert result.empty?
result.each {|issue| assert issue.subject.downcase.include?('unable') }
Jean-Philippe Lang
Fixed: Search for target version of "none" fails with postgres 8.3 (#1134)....
 r1364 end
def test_operator_does_not_contains
query = Query.new(:project => Project.find(1), :name => '_')
Jean-Philippe Lang
Fixed: case sensitivity in issue subject filtering (#3536)....
 r2696 query.add_filter('subject', '!~', ['uNable'])
assert query.statement.include?("LOWER(#{Issue.table_name}.subject) NOT LIKE '%unable%'")
Jean-Philippe Lang
Adds estimated hours to issue filters (#1678)....
 r1687 find_issues_with_query(query)
Jean-Philippe Lang
Fixed: Search for target version of "none" fails with postgres 8.3 (#1134)....
 r1364 end
Jean-Philippe Lang
Adds ability to filter watched issues (#846)....
 r2395 def test_filter_watched_issues
User.current = User.find(1)
query = Query.new(:name => '_', :filters => { 'watcher_id' => {:operator => '=', :values => ['me']}})
result = find_issues_with_query(query)
assert_not_nil result
assert !result.empty?
assert_equal Issue.visible.watched_by(User.current).sort_by(&:id), result.sort_by(&:id)
User.current = nil
end
def test_filter_unwatched_issues
User.current = User.find(1)
query = Query.new(:name => '_', :filters => { 'watcher_id' => {:operator => '!', :values => ['me']}})
result = find_issues_with_query(query)
assert_not_nil result
assert !result.empty?
assert_equal((Issue.visible - Issue.watched_by(User.current)).sort_by(&:id).size, result.sort_by(&:id).size)
User.current = nil
end
Jean-Philippe Lang
Added the ability to customize columns of a saved query....
 r771 def test_default_columns
q = Query.new
assert !q.columns.empty?
end
def test_set_column_names
q = Query.new
q.column_names = ['tracker', :subject, '', 'unknonw_column']
assert_equal [:tracker, :subject], q.columns.collect {|c| c.name}
c = q.columns.first
assert q.has_column?(c)
end
Jean-Philippe Lang
Queries can be marked as 'For all projects'. Such queries will be available on all projects and on the global issue list (#897, closes #671)....
 r1296
Jean-Philippe Lang
Ability to save "sort order" in custom queries (#2899)....
 r2504 def test_default_sort
q = Query.new
assert_equal [], q.sort_criteria
end
def test_set_sort_criteria_with_hash
q = Query.new
q.sort_criteria = {'0' => ['priority', 'desc'], '2' => ['tracker']}
assert_equal [['priority', 'desc'], ['tracker', 'asc']], q.sort_criteria
end
def test_set_sort_criteria_with_array
q = Query.new
q.sort_criteria = [['priority', 'desc'], 'tracker']
assert_equal [['priority', 'desc'], ['tracker', 'asc']], q.sort_criteria
end
def test_create_query_with_sort
q = Query.new(:name => 'Sorted')
q.sort_criteria = [['priority', 'desc'], 'tracker']
assert q.save
q.reload
assert_equal [['priority', 'desc'], ['tracker', 'asc']], q.sort_criteria
end
Jean-Philippe Lang
Ability to sort the issue list by text, list, date and boolean custom fields (#1139)....
 r2255 def test_sort_by_string_custom_field_asc
q = Query.new
c = q.available_columns.find {|col| col.is_a?(QueryCustomFieldColumn) && col.custom_field.field_format == 'string' }
assert c
assert c.sortable
issues = Issue.find :all,
:include => [ :assigned_to, :status, :tracker, :project, :priority ],
:conditions => q.statement,
:order => "#{c.sortable} ASC"
values = issues.collect {|i| i.custom_value_for(c.custom_field).to_s}
Jean-Philippe Lang
Ability to sort the issue list by text, int and float custom fields (#1139)....
 r2256 assert !values.empty?
Jean-Philippe Lang
Ability to sort the issue list by text, list, date and boolean custom fields (#1139)....
 r2255 assert_equal values.sort, values
end
def test_sort_by_string_custom_field_desc
q = Query.new
c = q.available_columns.find {|col| col.is_a?(QueryCustomFieldColumn) && col.custom_field.field_format == 'string' }
assert c
assert c.sortable
issues = Issue.find :all,
:include => [ :assigned_to, :status, :tracker, :project, :priority ],
:conditions => q.statement,
:order => "#{c.sortable} DESC"
values = issues.collect {|i| i.custom_value_for(c.custom_field).to_s}
Jean-Philippe Lang
Ability to sort the issue list by text, int and float custom fields (#1139)....
 r2256 assert !values.empty?
Jean-Philippe Lang
Ability to sort the issue list by text, list, date and boolean custom fields (#1139)....
 r2255 assert_equal values.sort.reverse, values
end
Jean-Philippe Lang
Ability to sort the issue list by text, int and float custom fields (#1139)....
 r2256 def test_sort_by_float_custom_field_asc
q = Query.new
c = q.available_columns.find {|col| col.is_a?(QueryCustomFieldColumn) && col.custom_field.field_format == 'float' }
assert c
assert c.sortable
issues = Issue.find :all,
:include => [ :assigned_to, :status, :tracker, :project, :priority ],
:conditions => q.statement,
:order => "#{c.sortable} ASC"
values = issues.collect {|i| begin; Kernel.Float(i.custom_value_for(c.custom_field).to_s); rescue; nil; end}.compact
assert !values.empty?
assert_equal values.sort, values
end
Jean-Philippe Lang
Prevents NoMethodError on @available_filters.has_key? in query.rb (#1178)....
 r1440 def test_label_for
q = Query.new
assert_equal 'assigned_to', q.label_for('assigned_to_id')
end
Jean-Philippe Lang
Queries can be marked as 'For all projects'. Such queries will be available on all projects and on the global issue list (#897, closes #671)....
 r1296 def test_editable_by
admin = User.find(1)
manager = User.find(2)
developer = User.find(3)
# Public query on project 1
q = Query.find(1)
assert q.editable_by?(admin)
assert q.editable_by?(manager)
assert !q.editable_by?(developer)
# Private query on project 1
q = Query.find(2)
assert q.editable_by?(admin)
assert !q.editable_by?(manager)
assert q.editable_by?(developer)
# Private query for all projects
q = Query.find(3)
assert q.editable_by?(admin)
assert !q.editable_by?(manager)
assert q.editable_by?(developer)
# Public query for all projects
q = Query.find(4)
assert q.editable_by?(admin)
assert !q.editable_by?(manager)
assert !q.editable_by?(developer)
end
Jean-Philippe Lang
Fixed: queries with multiple custom fields return no result....
 r662 end