priv/repo/migrations/20190213185503_change_apps_scopes_to_varchar_array.exs


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17

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

  @alter_apps_scopes "ALTER TABLE apps ALTER COLUMN scopes"

  def up do
    execute "#{@alter_apps_scopes} TYPE varchar(255)[] USING string_to_array(scopes, ',')::varchar(255)[];"
    execute "#{@alter_apps_scopes} SET DEFAULT ARRAY[]::character varying[];"
    execute "#{@alter_apps_scopes} SET NOT NULL;"
  end

  def down do
    execute "#{@alter_apps_scopes} DROP NOT NULL;"
    execute "#{@alter_apps_scopes} DROP DEFAULT;"
    execute "#{@alter_apps_scopes} TYPE varchar(255) USING array_to_string(scopes, ',')::varchar(255);"
  end
end