testI18NSearch.py 7.2 KB
Newer Older
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
# -*- coding: utf-8 -*-
##############################################################################
#
# Copyright (c) 2013 Nexedi SA and Contributors. All Rights Reserved.
#
# WARNING: This program as such is intended to be used by professional
# programmers who take the whole responsibility of assessing all potential
# consequences resulting from its eventual inadequacies and bugs
# End users who are looking for a ready-to-use solution with commercial
# guarantees and support are strongly adviced to contract a Free Software
# Service Company
#
# 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.
#
##############################################################################

import unittest
30
from unittest import expectedFailure
31 32 33 34 35 36 37 38 39 40
from Products.ERP5Type.tests.ERP5TypeTestCase import ERP5TypeTestCase

class TestI18NSearch(ERP5TypeTestCase):
  def getTitle(self):
    return "I18N Search"

  def getBusinessTemplateList(self):
    return ('erp5_full_text_mroonga_catalog',
            'erp5_base',)

41 42 43
  def afterSetUp(self):
    self.person_module = self.portal.person_module
    self.person1 = self.person_module.newContent(
44 45 46
      portal_type='Person',
      first_name='Gabriel',
      last_name='Fauré',
47
      description='Quick brown fox jumps over the lazy dog.',
48
      )
49
    self.person2 = self.person_module.newContent(
50 51
      portal_type='Person',
      first_name='武者小路',
52 53
      last_name='実篤',
      description='Slow white fox jumps over the diligent dog.',
54
      )
55
    self.person3 = self.person_module.newContent(
56 57 58 59
      portal_type='Person',
      first_name='( - + )',
      last_name='',
      )
60
    self.tic()
61

62 63 64 65 66
  def beforeTearDown(self):
    self.person_module.manage_delObjects(ids=list(tuple(self.person_module.objectIds())))
    self.tic()

  def test_full_text_searchable_text(self):
67
    # check if 'é' == 'e' collation works
68
    result = self.person_module.searchFolder(SearchableText='Faure')
69
    self.assertEqual(len(result), 1)
70
    self.assertEqual(result[0].getPath(), self.person1.getPath())
71

72
    # check if a partial string of CJK string matches
73 74 75 76 77 78 79 80 81 82
    result = self.person_module.searchFolder(SearchableText='武者')
    self.assertEqual(len(result), 1)
    self.assertEqual(result[0].getPath(), self.person2.getPath())

    # check boolean language mode search
    result = self.person_module.searchFolder(SearchableText='+quick +fox +dog')
    self.assertEqual(len(result), 1)
    self.assertEqual(result[0].getPath(), self.person1.getPath())

    # check sort on fulltext column
83
    self.assertTrue('ORDER BY\n  `full_text`.`SearchableText` ASC' in self.portal.portal_catalog(SearchableText='Faure', sort_on=(('SearchableText', 'ascending'),), src__=1))
84 85

    # check sort on fulltext search score
86
    self.assertTrue('ORDER BY\n  full_text_SearchableText__score__ ASC' in self.portal.portal_catalog(SearchableText='Faure', sort_on=(('SearchableText__score__', 'ascending'),), src__=1))
87

88
  @expectedFailure
89
  def test_catalog_full_text_title(self):
90 91 92 93 94
    # catalog_full_text is not used by default anymore (it was already deactivated a long
    # time ago because of performance issues whene joining a full text table with a simple
    # InnoDB table, but documents were still indexed in). Thus I deactivated the catalog list
    # method in order to stop wasting resources, then this test is no use anymore.

95 96
    # check if 'é' == 'e' collation works
    result = self.person_module.searchFolder(**{'catalog_full_text.title':'Faure'})
97
    self.assertEqual(len(result), 1)
98 99 100 101
    self.assertEqual(result[0].getPath(), self.person1.getPath())

    # check if a partial string of CJK string matches
    result = self.person_module.searchFolder(**{'catalog_full_text.title':'武者'})
102
    self.assertEqual(len(result), 1)
103
    self.assertEqual(result[0].getPath(), self.person2.getPath())
104 105

    # check boolean language mode search
106
    result = self.person_module.searchFolder(**{'catalog_full_text.description':'+quick +fox +dog'})
107
    self.assertEqual(len(result), 1)
108 109 110 111 112 113 114 115 116
    self.assertEqual(result[0].getPath(), self.person1.getPath())

    # check search with a special character
    for query in ('(', ')', ):
      result = self.person_module.searchFolder(**{'catalog_full_text.title':query})
      self.assertEqual(len(result), 1)
      self.assertEqual(result[0].getPath(), self.person3.getPath())

    # check sort on fulltext column
117
    self.assertFalse('ORDER BY\n  title__score__ ASC' in self.portal.portal_catalog(**{
118 119 120 121 122 123
      'catalog_full_text.title':'Faure',
      'sort_on':(('catalog_full_text.title', 'ascending'),),
      'src__':1
      }))

    # check sort on fulltext search score
124
    self.assertTrue('ORDER BY\n  catalog_full_text_title__score__' in self.portal.portal_catalog(**{
125 126 127 128
      'catalog_full_text.title':'Faure',
      'sort_on':(('catalog_full_text.title__score__', 'ascending'),),
      'src__':1
      }))
129
    self.assertTrue('ORDER BY\n  catalog_full_text_title__score__' in self.portal.portal_catalog(**{
130 131 132 133
      'catalog_full_text.title':'Faure',
      'sort_on':(('title__score__', 'ascending'),),
      'src__':1
      }))
134 135 136 137 138 139 140 141 142 143 144 145 146 147 148

  @expectedFailure
  def test_full_text_title(self):
    # check if 'é' == 'e' collation works
    result = self.person_module.searchFolder(title='Faure')
    self.assertEqual(len(result), 1)
    self.assertEqual(result[0].getPath(), self.person1.getPath())

    # check if a partial string of CJK string matches
    result = self.person_module.searchFolder(title='武者')
    self.assertEqual(len(result), 1)
    self.assertEqual(result[0].getPath(), self.person2.getPath())

    # check boolean language mode search
    result = self.person_module.searchFolder(description='+quick +fox +dog')
149
    self.assertEqual(len(result), 1)
150
    self.assertEqual(result[0].getPath(), self.person1.getPath())
151

152 153
    # check search with a special character
    for query in ('(', ')', ):
154
      result = self.person_module.searchFolder(title=query)
155
      self.assertEqual(len(result), 1)
156
      self.assertEqual(result[0].getPath(), self.person3.getPath())
157

158 159
    # check fulltext search for automatically generated related keys.
    self.assertTrue('MATCH' in self.portal.portal_catalog(destination_title='Faure', src__=1))
160

161
    # check sort on fulltext column
162
    self.assertTrue('ORDER BY\n  `catalog`.`title` ASC' in self.portal.portal_catalog(title='Faure', sort_on=(('title', 'ascending'),), src__=1))
163 164

    # check sort on fulltext search score
165
    self.assertTrue('ORDER BY\n  catalog_full_text_title__score__' in self.portal.portal_catalog(title='Faure', sort_on=(('title__score__', 'ascending'),), src__=1))
166

167 168 169 170
def test_suite():
  suite = unittest.TestSuite()
  suite.addTest(unittest.makeSuite(TestI18NSearch))
  return suite