X-Git-Url: https://git.openstreetmap.org./osqa.git/blobdiff_plain/1a949f7c97dc2f34c135f5cdf088df2927d3d652..485b15b2138e19fc32b0d48a654c56d18b1f0af6:/forum_modules/pgfulltext/handlers.py?ds=sidebyside diff --git a/forum_modules/pgfulltext/handlers.py b/forum_modules/pgfulltext/handlers.py index 45ab2e7..835c2f5 100644 --- a/forum_modules/pgfulltext/handlers.py +++ b/forum_modules/pgfulltext/handlers.py @@ -1,11 +1,15 @@ from forum.models import Question +from forum.modules.decorators import decorate +from forum.views.readers import do_question_search +@decorate(do_question_search, needs_origin=False) def question_search(keywords): - return Question.objects.extra( + return Question.objects.all().extra( select={ - 'ranking': "ts_rank_cd(tsv, plainto_tsquery(%s), 32)", + 'ranking': 'node_ranking("forum_node"."id", %s)', }, - where=["tsv @@ plainto_tsquery(%s)"], + where=['node_ranking("forum_node"."id", %s) > 0'], params=[keywords], - select_params=[keywords] - ).order_by('-ranking') \ No newline at end of file + select_params=[keywords], + order_by=['-ranking'] + ) \ No newline at end of file