diff options
Diffstat (limited to 'app/models')
-rw-r--r-- | app/models/account.rb | 4 | ||||
-rw-r--r-- | app/models/tag.rb | 19 |
2 files changed, 21 insertions, 2 deletions
diff --git a/app/models/account.rb b/app/models/account.rb index aa0af563c..c35620812 100644 --- a/app/models/account.rb +++ b/app/models/account.rb @@ -222,8 +222,8 @@ SQL end def search_for(terms, limit = 10) - textsearch = '(setweight(to_tsvector(\'simple\', accounts.display_name), \'A\') || setweight(to_tsvector(\'simple\', accounts.username), \'B\') || setweight(to_tsvector(\'simple\', coalesce(accounts.domain, \'\')), \'C\'))' - query = 'to_tsquery(\'simple\', \'\'\' \' || ? || \' \'\'\' || \':*\')' + textsearch = '(setweight(to_tsvector(\'simple\', accounts.display_name), \'A\') || setweight(to_tsvector(\'simple\', accounts.username), \'B\') || setweight(to_tsvector(\'simple\', coalesce(accounts.domain, \'\')), \'C\'))' + query = 'to_tsquery(\'simple\', \'\'\' \' || ? || \' \'\'\' || \':*\')' sql = <<SQL SELECT diff --git a/app/models/tag.rb b/app/models/tag.rb index 0d2fe43b8..e2ad8e4db 100644 --- a/app/models/tag.rb +++ b/app/models/tag.rb @@ -10,4 +10,23 @@ class Tag < ApplicationRecord def to_param name end + + class << self + def search_for(terms, limit = 5) + textsearch = 'to_tsvector(\'simple\', tags.name)' + query = 'to_tsquery(\'simple\', \'\'\' \' || ? || \' \'\'\' || \':*\')' + + sql = <<SQL + SELECT + tags.*, + ts_rank_cd(#{textsearch}, #{query}) AS rank + FROM tags + WHERE #{query} @@ #{textsearch} + ORDER BY rank DESC + LIMIT ? +SQL + + Tag.find_by_sql([sql, terms, terms, limit]) + end + end end |