pleroma

20190213185503_change_apps_scopes_to_varchar_array.exs (826B)

# 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.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