summaryrefslogtreecommitdiff
path: root/priv
diff options
context:
space:
mode:
authorMaksim Pechnikov <parallel588@gmail.com>2020-06-15 15:24:55 +0300
committerMaksim Pechnikov <parallel588@gmail.com>2020-06-15 15:24:55 +0300
commit579763126f52b21733e84594f36b86e270b3005d (patch)
tree2b183b4b4ac4be2a4b64da87adc7ed56b7222f39 /priv
parentefdfc85c2d8e5118c1aa18e4f04026ec90cd11d2 (diff)
parent448e93ce2c1eab9eb91118b90f661c31056e4781 (diff)
downloadpleroma-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.exs18
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