From 6abae51e47753cc80b440c4234c14cd8232e235f Mon Sep 17 00:00:00 2001
From: multiple creatures <dev@multiple-creature.party>
Date: Sat, 16 Nov 2019 07:17:15 -0600
Subject: Regular expressions can now be used in full-text searches.  Wrapping
 a search term in double-quotes treats it as a whole-word match.

---
 app/lib/bangtags.rb | 4 +++-
 1 file changed, 3 insertions(+), 1 deletion(-)

(limited to 'app/lib')

diff --git a/app/lib/bangtags.rb b/app/lib/bangtags.rb
index 681fa4abc..60fb426b3 100644
--- a/app/lib/bangtags.rb
+++ b/app/lib/bangtags.rb
@@ -2,6 +2,8 @@
 
 class Bangtags
   include ModerationHelper
+  include SearchHelper
+
   attr_reader :status, :account
 
   def initialize(status)
@@ -718,7 +720,7 @@ class Bangtags
           q = cmd[1..-1].join.strip
           next if q.blank?
           begin
-            data = @account.statuses.where('text ILIKE ?', "%#{sanitize_sql_like(q)}%")
+            data = @account.statuses.where('text ~* ?', expand_search_query(q))
               .reorder(:created_at)
               .pluck(:created_at)
               .map { |d| d.strftime('%Y-%m') }
-- 
cgit