diff options
author | Maksim Pechnikov <parallel588@gmail.com> | 2020-06-15 15:24:55 +0300 |
---|---|---|
committer | Maksim Pechnikov <parallel588@gmail.com> | 2020-06-15 15:24:55 +0300 |
commit | 579763126f52b21733e84594f36b86e270b3005d (patch) | |
tree | 2b183b4b4ac4be2a4b64da87adc7ed56b7222f39 /priv | |
parent | efdfc85c2d8e5118c1aa18e4f04026ec90cd11d2 (diff) | |
parent | 448e93ce2c1eab9eb91118b90f661c31056e4781 (diff) | |
download | pleroma-579763126f52b21733e84594f36b86e270b3005d.tar.gz pleroma-579763126f52b21733e84594f36b86e270b3005d.zip |
Merge branch 'develop' into issue/1855
Diffstat (limited to 'priv')
-rw-r--r-- | priv/repo/migrations/20200527163635_delete_notifications_from_invisible_users.exs | 18 |
1 files changed, 18 insertions, 0 deletions
diff --git a/priv/repo/migrations/20200527163635_delete_notifications_from_invisible_users.exs b/priv/repo/migrations/20200527163635_delete_notifications_from_invisible_users.exs new file mode 100644 index 000000000..9e95a8111 --- /dev/null +++ b/priv/repo/migrations/20200527163635_delete_notifications_from_invisible_users.exs @@ -0,0 +1,18 @@ +defmodule Pleroma.Repo.Migrations.DeleteNotificationsFromInvisibleUsers do + use Ecto.Migration + + import Ecto.Query + alias Pleroma.Repo + + def up do + Pleroma.Notification + |> join(:inner, [n], activity in assoc(n, :activity)) + |> where( + [n, a], + fragment("? in (SELECT ap_id FROM users WHERE invisible = true)", a.actor) + ) + |> Repo.delete_all() + end + + def down, do: :ok +end |