From af5872b7d432f78befcb7e9f87187a5b82b588bf Mon Sep 17 00:00:00 2001 From: Jean-Philippe Lang Date: Sun, 8 Feb 2015 15:13:57 +0000 Subject: Support for accent insensitive search with PostgreSQL (#18801). If the unaccent extension is installed, the search engine will use it in order to do accent insensitive search. git-svn-id: http://svn.redmine.org/redmine/trunk@13989 e93f8b46-1217-0410-a6f0-8f06a7374b81 --- test/test_helper.rb | 4 ++++ test/unit/search_test.rb | 19 +++++++++++++++++++ 2 files changed, 23 insertions(+) (limited to 'test') diff --git a/test/test_helper.rb b/test/test_helper.rb index 1762de868..63159ad9a 100644 --- a/test/test_helper.rb +++ b/test/test_helper.rb @@ -169,6 +169,10 @@ class ActiveSupport::TestCase ActiveRecord::Base.connection.adapter_name =~ /mysql/i end + def postgresql? + ActiveRecord::Base.connection.adapter_name =~ /postgresql/i + end + def assert_save(object) saved = object.save message = "#{object.class} could not be saved" diff --git a/test/unit/search_test.rb b/test/unit/search_test.rb index 083a8f355..bd9477025 100644 --- a/test/unit/search_test.rb +++ b/test/unit/search_test.rb @@ -171,6 +171,25 @@ class SearchTest < ActiveSupport::TestCase end end + def test_search_should_be_case_and_accent_insensitive_with_postgresql_and_noaccent_extension + if postgresql? + skip unless Redmine::Database.postgresql_version >= 90000 + # Extension will be rollbacked with the test transaction + ActiveRecord::Base.connection.execute("CREATE EXTENSION IF NOT EXISTS unaccent") + Redmine::Database.reset + assert Redmine::Database.postgresql_unaccent? + + issue1 = Issue.generate!(:subject => "OO") + issue2 = Issue.generate!(:subject => "oo") + + r = Issue.search_results('ÖÖ') + assert_include issue1, r + assert_include issue2, r + end + ensure + Redmine::Database.reset + end + private def remove_permission(role, permission) -- cgit v1.2.3