X-Git-Url: https://git.openstreetmap.org./osqa.git/blobdiff_plain/83182bda24af3b7e755eb0dd2c877ec17e1ab411..f8e781a472502ff7f6ef1b2b279d752f4fa8620f:/forum_modules/mysqlfulltext/startup.py diff --git a/forum_modules/mysqlfulltext/startup.py b/forum_modules/mysqlfulltext/startup.py index 387019a..8c2af5f 100644 --- a/forum_modules/mysqlfulltext/startup.py +++ b/forum_modules/mysqlfulltext/startup.py @@ -8,7 +8,7 @@ from forum.models.question import Question, QuestionManager from forum.models.node import Node from forum.modules import decorate -VERSION = 3 +VERSION = 4 f_name = None @@ -43,7 +43,7 @@ word_re = re.compile(r'\w+', re.UNICODE) def question_search(self, keywords): keywords = keywords.upper() - return '-ranking', self.filter( + qs = self.filter( models.Q(ftsindex__body__isnull=False) ).extra( select={ @@ -51,7 +51,8 @@ def question_search(self, keywords): match(forum_mysqlftsindex.tagnames) against (%s) * 2 + match(forum_mysqlftsindex.title) against (%s) * 4 + match(forum_mysqlftsindex.body) against (%s) * 1 - """, + """, }, select_params=[keywords, keywords, keywords] - ) + ).filter(Q(ftsindex__title__search=keywords) | Q(ftsindex__tagnames__search=keywords) | Q(ftsindex__body__search=keywords)) + return '-ranking', qs