From 9a435494c2efdd2ca8fc7f5fa3dbb81bf88633a1 Mon Sep 17 00:00:00 2001 From: multiple creatures Date: Wed, 11 Dec 2019 20:04:53 -0600 Subject: move normalized text into own table --- app/helpers/filter_helper.rb | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'app/helpers') diff --git a/app/helpers/filter_helper.rb b/app/helpers/filter_helper.rb index e5144b981..db2652557 100644 --- a/app/helpers/filter_helper.rb +++ b/app/helpers/filter_helper.rb @@ -7,7 +7,7 @@ module FilterHelper status = status.reblog if status.reblog? - if Status.where(id: status.id).where("statuses.normalized_text ~ ANY(ARRAY(SELECT f_normalize(phrase) FROM custom_filters WHERE account_id = ?))", receiver_id).exists? + if Status.where(id: status.id).regex_filtered_by_account(receiver_id).exists? redis.sadd("filtered_statuses:#{receiver_id}", status.id) return true end -- cgit