No OneTemporary
Actions

Size

1 KB

Referenced Files

None

Subscribers

None

View Options

	diff --git a/priv/repo/migrations/20191029101340_migrate_missing_follow_requests.exs b/priv/repo/migrations/20191029101340_migrate_missing_follow_requests.exs
	index 1b2666f3a..90b18efc8 100644
	--- a/priv/repo/migrations/20191029101340_migrate_missing_follow_requests.exs
	+++ b/priv/repo/migrations/20191029101340_migrate_missing_follow_requests.exs
	@@ -1,35 +1,35 @@
	-defmodule Pleroma.Repo.Migrations.MigrateFollowingRelationships do
	+defmodule Pleroma.Repo.Migrations.MigrateMissingFollowingRelationships do
	use Ecto.Migration

	def change do
	execute(import_pending_follows_from_activities(), "")
	end

	defp import_pending_follows_from_activities do
	"""
	INSERT INTO
	following_relationships (
	follower_id,
	following_id,
	state,
	inserted_at,
	updated_at
	)
	SELECT
	followers.id,
	following.id,
	activities.data ->> 'state',
	(activities.data ->> 'published') :: timestamp,
	now()
	FROM
	activities
	JOIN users AS followers ON (activities.actor = followers.ap_id)
	JOIN users AS following ON (activities.data ->> 'object' = following.ap_id)
	WHERE
	activities.data ->> 'type' = 'Follow'
	AND activities.data ->> 'state' = 'pending'
	ORDER BY activities.updated_at DESC
	ON CONFLICT DO NOTHING
	"""
	end
	end