diff options
| author | Egor Kislitsyn <egor@kislitsyn.com> | 2019-10-14 14:16:57 +0700 |
|---|---|---|
| committer | Egor Kislitsyn <egor@kislitsyn.com> | 2019-10-14 14:16:57 +0700 |
| commit | 8ad015ef64e0d2a4cd9f2979ff08d28be3a635e5 (patch) | |
| tree | eb3ce0890151ff6201f680e9c47bfbda90b7abec /priv/repo/migrations/20191008132217_migrate_following_relationships.exs | |
| parent | 1d46944fbd17d194d744230cd519d1410e821a47 (diff) | |
| download | pleroma-8ad015ef64e0d2a4cd9f2979ff08d28be3a635e5.tar.gz pleroma-8ad015ef64e0d2a4cd9f2979ff08d28be3a635e5.zip | |
Skip deactivated users in followers import
Diffstat (limited to 'priv/repo/migrations/20191008132217_migrate_following_relationships.exs')
| -rw-r--r-- | priv/repo/migrations/20191008132217_migrate_following_relationships.exs | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/priv/repo/migrations/20191008132217_migrate_following_relationships.exs b/priv/repo/migrations/20191008132217_migrate_following_relationships.exs index 7f996f5a5..c9bc890aa 100644 --- a/priv/repo/migrations/20191008132217_migrate_following_relationships.exs +++ b/priv/repo/migrations/20191008132217_migrate_following_relationships.exs @@ -55,6 +55,7 @@ defmodule Pleroma.Repo.Migrations.MigrateFollowingRelationships do WHERE activities.data ->> 'type' = 'Follow' AND activities.data ->> 'state' IN ('accept', 'pending', 'reject') + AND NOT (followers.info ? 'deactivated' AND followers.info -> 'deactivated' @> 'true') ORDER BY activities.updated_at DESC ON CONFLICT DO NOTHING """ |