FullTextKey.py 2.82 KB
Newer Older
Ivan Tyagov's avatar
Ivan Tyagov committed
1 2
##############################################################################
#
3 4 5 6
# Copyright (c) 2002-2006 Nexedi SARL and Contributors. All Rights Reserved.
# Copyright (c) 2007-2009 Nexedi SA and Contributors. All Rights Reserved.
#                    Jean-Paul Smets-Solanes <jp@nexedi.com>
#                    Vincent Pelletier <vincent@nexedi.com>
Ivan Tyagov's avatar
Ivan Tyagov committed
7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30
#
# WARNING: This program as such is intended to be used by professional
# programmers who take the whole responsability 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
# garantees 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., 59 Temple Place - Suite 330, Boston, MA  02111-1307, USA.
#
##############################################################################

31
from SearchKey import SearchKey
32
from Products.ZSQLCatalog.Query.SimpleQuery import SimpleQuery
33
from Products.ZSQLCatalog.SearchText import parse
34
from Products.ZSQLCatalog.interfaces.search_key import ISearchKey
35
from zope.interface.verify import verifyClass
Ivan Tyagov's avatar
Ivan Tyagov committed
36

37
class FullTextKey(SearchKey):
Ivan Tyagov's avatar
Ivan Tyagov committed
38
  """
39 40
    This SearchKey generates SQL fulltext comparisons.
  """
41
  default_comparison_operator = 'boolean_match'
42
  get_operator_from_value = False
Ivan Tyagov's avatar
Ivan Tyagov committed
43

44
  def parseSearchText(self, value, is_column):
45 46 47 48
    return parse(value, is_column)

  def dequoteParsedText(self):
    return False
49 50

  def _renderValueAsSearchText(self, value, operator):
51
    return '(%s)' % (value, )
52

53 54 55 56 57 58 59 60 61 62 63 64 65 66 67
  def _buildQuery(self, operator_value_dict, logical_operator, parsed, group):
    """
      Special Query builder for FullText queries: merge all values having the
      same operator into just one query, to save SQL server from the burden to
      do multiple fulltext lookups when one would suit the purpose.
    """
    column = self.getColumn()
    query_list = []
    append = query_list.append
    for comparison_operator, value_list in operator_value_dict.iteritems():
      append(SimpleQuery(search_key=self,
                         comparison_operator=comparison_operator,
                         group=group, **{column: ' '.join(value_list)}))
    return query_list

68
verifyClass(ISearchKey, FullTextKey)
Ivan Tyagov's avatar
Ivan Tyagov committed
69