X-Git-Url: https://git.openstreetmap.org./osqa.git/blobdiff_plain/9b6be99a1eed1adddfd062642f6ca23f79d14aea..a54367cd91fc9a232c86a328b3ea5b48a3376112:/forum_modules/pgfulltext/handlers.py diff --git a/forum_modules/pgfulltext/handlers.py b/forum_modules/pgfulltext/handlers.py index 6952758..04d3a67 100644 --- a/forum_modules/pgfulltext/handlers.py +++ b/forum_modules/pgfulltext/handlers.py @@ -3,15 +3,14 @@ from django.db.models import Q from forum.models.question import Question, QuestionManager from forum.modules import decorate -repl_re = re.compile(r"^'|[^\'\-_\s\w]|'$", re.UNICODE) -sing_quote_re = re.compile(r"\'+") +word_re = re.compile(r'\w+', re.UNICODE) @decorate(QuestionManager.search, needs_origin=False) def question_search(self, keywords): - tsquery = " | ".join([k for k in repl_re.sub('', sing_quote_re.sub("'", keywords.strip())).split(' ') if k]) + tsquery = " | ".join(word_re.findall(keywords)) ilike = keywords + u"%%" - return self.extra( + return True, self.extra( tables = ['forum_rootnode_doc'], select={ 'ranking': """ @@ -24,6 +23,8 @@ def question_search(self, keywords): """], params=[tsquery, ilike], select_params=[tsquery], - order_by=['-ranking'] ) + + +