diff options
author | lain <lain@soykaf.club> | 2020-06-19 14:56:50 +0200 |
---|---|---|
committer | lain <lain@soykaf.club> | 2020-06-19 14:56:50 +0200 |
commit | 7e488cd4a7ac038dfe8a1f5b204cb134bb5ba549 (patch) | |
tree | a35a08cb24761e72c4be20b97a1833fdb26ca682 /priv | |
parent | 015f9258a9bd1430ab079f449b118b664c3b9664 (diff) | |
parent | d772361e6209e6b5733e9fe52b3671cd222060b3 (diff) | |
download | pleroma-7e488cd4a7ac038dfe8a1f5b204cb134bb5ba549.tar.gz pleroma-7e488cd4a7ac038dfe8a1f5b204cb134bb5ba549.zip |
Merge branch 'develop' of git.pleroma.social:pleroma/pleroma into update-validator
Diffstat (limited to 'priv')
-rw-r--r-- | priv/repo/migrations/20200322174133_user_raw_bio.exs | 9 | ||||
-rw-r--r-- | priv/repo/migrations/20200328193433_populate_user_raw_bio.exs | 25 |
2 files changed, 34 insertions, 0 deletions
diff --git a/priv/repo/migrations/20200322174133_user_raw_bio.exs b/priv/repo/migrations/20200322174133_user_raw_bio.exs new file mode 100644 index 000000000..ddf9be4f5 --- /dev/null +++ b/priv/repo/migrations/20200322174133_user_raw_bio.exs @@ -0,0 +1,9 @@ +defmodule Pleroma.Repo.Migrations.UserRawBio do + use Ecto.Migration + + def change do + alter table(:users) do + add_if_not_exists(:raw_bio, :text) + end + end +end diff --git a/priv/repo/migrations/20200328193433_populate_user_raw_bio.exs b/priv/repo/migrations/20200328193433_populate_user_raw_bio.exs new file mode 100644 index 000000000..cb35db3f5 --- /dev/null +++ b/priv/repo/migrations/20200328193433_populate_user_raw_bio.exs @@ -0,0 +1,25 @@ +defmodule Pleroma.Repo.Migrations.PopulateUserRawBio do + use Ecto.Migration + import Ecto.Query + alias Pleroma.User + alias Pleroma.Repo + + def change do + {:ok, _} = Application.ensure_all_started(:fast_sanitize) + + User.Query.build(%{local: true}) + |> select([u], struct(u, [:id, :ap_id, :bio])) + |> Repo.stream() + |> Enum.each(fn %{bio: bio} = user -> + if bio do + raw_bio = + bio + |> String.replace(~r(<br */?>), "\n") + |> Pleroma.HTML.strip_tags() + + Ecto.Changeset.cast(user, %{raw_bio: raw_bio}, [:raw_bio]) + |> Repo.update() + end + end) + end +end |