diff options
author | Eugen Rochko <eugen@zeonfederated.com> | 2017-03-22 17:36:34 +0100 |
---|---|---|
committer | Eugen Rochko <eugen@zeonfederated.com> | 2017-03-22 17:36:34 +0100 |
commit | 5aa3df017bcdefd15e041ca0a7e428f85887aff2 (patch) | |
tree | abc1029d770ca1ed1dec9f043250e814628ead8f /app/models/tag.rb | |
parent | c89ccbab09696dc4d1de486417cccfd2ad5f30a0 (diff) |
Fix full-text search query quotation, improve tag search performance with an index,
add ability to open status by URL from search (fix #53)
Diffstat (limited to 'app/models/tag.rb')
-rw-r--r-- | app/models/tag.rb | 5 |
1 files changed, 3 insertions, 2 deletions
diff --git a/app/models/tag.rb b/app/models/tag.rb index e2ad8e4db..15625ca43 100644 --- a/app/models/tag.rb +++ b/app/models/tag.rb @@ -13,8 +13,9 @@ class Tag < ApplicationRecord class << self def search_for(terms, limit = 5) + terms = Arel.sql(connection.quote(terms.gsub(/['?\\:]/, ' '))) textsearch = 'to_tsvector(\'simple\', tags.name)' - query = 'to_tsquery(\'simple\', \'\'\' \' || ? || \' \'\'\' || \':*\')' + query = 'to_tsquery(\'simple\', \'\'\' \' || ' + terms + ' || \' \'\'\' || \':*\')' sql = <<SQL SELECT @@ -26,7 +27,7 @@ class Tag < ApplicationRecord LIMIT ? SQL - Tag.find_by_sql([sql, terms, terms, limit]) + Tag.find_by_sql([sql, limit]) end end end |