X-Git-Url: https://git.openstreetmap.org./osqa.git/blobdiff_plain/389dfe31994fdc9e835af751b59e784d49f9e175..0bd53bfd0a08e9949651ec35bf22048db8e740d9:/forum_modules/mysqlfulltext/startup.py?ds=sidebyside diff --git a/forum_modules/mysqlfulltext/startup.py b/forum_modules/mysqlfulltext/startup.py index 232bbb4..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 = 2 +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