projects
/
akkoma
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
Merge branch 'whole-word-filter-hotfix' into 'develop'
[akkoma]
/
priv
/
repo
/
migrations
/
20171212164525_fill_recipients_in_activities.exs
diff --git
a/priv/repo/migrations/20171212164525_fill_recipients_in_activities.exs
b/priv/repo/migrations/20171212164525_fill_recipients_in_activities.exs
index 1fcc0dabb07d06fb5f359ccfc752c4376de80b54..6dfa9371682c2f7fff72414a67f50d26bd4ff91d 100644
(file)
--- a/
priv/repo/migrations/20171212164525_fill_recipients_in_activities.exs
+++ b/
priv/repo/migrations/20171212164525_fill_recipients_in_activities.exs
@@
-4,18
+4,24
@@
defmodule Pleroma.Repo.Migrations.FillRecipientsInActivities do
def up do
max = Repo.aggregate(Activity, :max, :id)
def up do
max = Repo.aggregate(Activity, :max, :id)
+
if max do
IO.puts("#{max} activities")
if max do
IO.puts("#{max} activities")
- chunks = 0..
(round(max / 10_000)
)
+ chunks = 0..
round(max / 10_000
)
- Enum.each(chunks, fn
(i)
->
+ Enum.each(chunks, fn
i
->
min = i * 10_000
max = min + 10_000
min = i * 10_000
max = min + 10_000
+
execute("""
execute("""
- update activities set recipients = array(select jsonb_array_elements_text(data->'to')) where id > #{min} and id <= #{max};
+ update activities set recipients = array(select jsonb_array_elements_text(data->'to')) where id > #{
+ min
+ } and id <= #{max};
""")
""")
- |> IO.inspect
+ |> IO.inspect
()
end)
end
end
end)
end
end
+
+ def down, do: :ok
end
end