diff options
author | David Yip <yipdw@member.fsf.org> | 2018-06-12 18:12:29 -0500 |
---|---|---|
committer | GitHub <noreply@github.com> | 2018-06-12 18:12:29 -0500 |
commit | f6bb50b6ece555af138df164680189b1ec57da4b (patch) | |
tree | 490c6054260f4a75fb0467f343124746c1935970 /db/migrate/20180608213548_reject_following_blocked_users.rb | |
parent | 34f1fd2a621ca869c17009487e2f10063812fbd0 (diff) | |
parent | fac6e392e9d76e3cca44ce142690a59afc0a9156 (diff) |
Merge pull request #539 from glitch-soc/merge-upstream
Merge upstream
Diffstat (limited to 'db/migrate/20180608213548_reject_following_blocked_users.rb')
-rw-r--r-- | db/migrate/20180608213548_reject_following_blocked_users.rb | 40 |
1 files changed, 40 insertions, 0 deletions
diff --git a/db/migrate/20180608213548_reject_following_blocked_users.rb b/db/migrate/20180608213548_reject_following_blocked_users.rb new file mode 100644 index 000000000..302db6b68 --- /dev/null +++ b/db/migrate/20180608213548_reject_following_blocked_users.rb @@ -0,0 +1,40 @@ +class RejectFollowingBlockedUsers < ActiveRecord::Migration[5.2] + disable_ddl_transaction! + + def up + blocked_follows = Follow.find_by_sql(<<-SQL) + select f.* from follows f + inner join blocks b on + f.account_id = b.target_account_id and + f.target_account_id = b.account_id + SQL + + domain_blocked_follows = Follow.find_by_sql(<<-SQL) + select f.* from follows f + inner join accounts following on f.account_id = following.id + inner join account_domain_blocks b on + lower(b.domain) = lower(following.domain) and + f.target_account_id = b.account_id + SQL + + follows = (blocked_follows + domain_blocked_follows).uniq + say "Destroying #{follows.size} blocked follow relationships..." + + follows.each do |follow| + blocked_account = follow.account + followed_acccount = follow.target_account + + next follow.destroy! if blocked_account.local? + + reject_follow_json = Oj.dump(ActivityPub::LinkedDataSignature.new(ActiveModelSerializers::SerializableResource.new(follow, serializer: ActivityPub::RejectFollowSerializer, adapter: ActivityPub::Adapter).as_json).sign!(followed_acccount)) + + ActivityPub::DeliveryWorker.perform_async(reject_follow_json, followed_acccount, blocked_account.inbox_url) + + follow.destroy! + end + end + + def down + raise ActiveRecord::IrreversibleMigration + end +end |