20171109114020_fill_actor_field.exs
No OneTemporary
Actions

Size

695 B

Referenced Files

None

Subscribers

None

20171109114020_fill_actor_field.exs
View Options

	# Pleroma: A lightweight social networking server
	# Copyright © 2017-2022 Pleroma Authors <https://pleroma.social/>
	# SPDX-License-Identifier: AGPL-3.0-only

	defmodule Pleroma.Repo.Migrations.FillActorField do
	use Ecto.Migration

	alias Pleroma.{Repo, Activity}

	def up do
	max = Repo.aggregate(Activity, :max, :id)

	if max do
	IO.puts("#{max} activities")
	chunks = 0..round(max / 10_000)

	Enum.each(chunks, fn i ->
	min = i * 10_000
	max = min + 10_000

	execute("""
	update activities set actor = data->>'actor' where id > #{min} and id <= #{max};
	""")
	\|> IO.inspect()
	end)
	end
	end

	def down do
	end
	end