git.squeep.com Git - akkoma/blob - priv/repo/migrations/20190213185503_change_apps_scopes_to_varchar_array.exs

   1 defmodule Pleroma.Repo.Migrations.ChangeAppsScopesToVarcharArray do
   2   use Ecto.Migration
   3
   4   @alter_apps_scopes "ALTER TABLE apps ALTER COLUMN scopes"
   5
   6   def up do
   7     execute(
   8       "#{@alter_apps_scopes} TYPE varchar(255)[] USING string_to_array(scopes, ',')::varchar(255)[];"
   9     )
  10
  11     execute("#{@alter_apps_scopes} SET DEFAULT ARRAY[]::character varying[];")
  12     execute("#{@alter_apps_scopes} SET NOT NULL;")
  13   end
  14
  15   def down do
  16     execute("#{@alter_apps_scopes} DROP NOT NULL;")
  17     execute("#{@alter_apps_scopes} DROP DEFAULT;")
  18
  19     execute(
  20       "#{@alter_apps_scopes} TYPE varchar(255) USING array_to_string(scopes, ',')::varchar(255);"
  21     )
  22   end
  23 end