Packages

boruta

2.1.5
3.0.0-beta.4 3.0.0-beta.3 3.0.0-beta.2 3.0.0-beta.1 2.3.6 2.3.5 2.3.4 2.3.3 2.3.2 2.3.1 2.3.0 2.2.2 2.2.1 2.2.0 2.1.5 2.1.4 2.1.3 2.1.2 2.1.1 2.1.0 2.0.1 2.0.0 2.0.0-rc.1 2.0.0-rc.0 1.2.1 1.2.0 1.1.0 1.0.3 1.0.2 1.0.1 1.0.0 1.0.0-rc.3 1.0.0-rc.2 1.0.0-rc.1 1.0.0-rc.0 0.2.1 0.2.0 0.1.1 0.1.0 0.1.0-rc.5 0.1.0-rc.4 0.1.0-rc.3 0.1.0-rc.2 0.1.0-rc.1

Core of an OAuth/OpenID Connect provider enabling authorization in your applications.

HexDocs

Current section

Files

Jump to
Readme
44 Versions
11 Dependencies
Dependants
Files
Activity
boruta priv boruta migrations 20210824122016_openid_connect.ex
Raw

priv/boruta/migrations/20210824122016_openid_connect.ex 

defmodule Boruta.Migrations.OpenidConnect do

  @moduledoc false



  defmacro __using__(_args) do

    quote do

      def up do

        # 20210720134116_add_default_to_scopes_name.exs

        alter table(:scopes) do

          modify(:name, :string, default: "")

        end



        # 20210720134125_add_default_to_tokens_scope.exs

        alter table(:tokens) do

          modify(:scope, :string, default: "")

        end



        # 20210721213916_add_nonce_to_tokens.exs

        alter table(:tokens) do

          add(:nonce, :string)

        end



        # 20210721200708_add_id_token_ttl_to_clients.exs

        alter table(:clients) do

          add(:id_token_ttl, :integer, default: 3600)

        end



        # 20210824204150_add_oauth_prefix.exs

        drop(unique_index(:clients, [:id, :secret]))

        drop(index(:tokens, [:value]))

        drop(unique_index(:tokens, [:client_id, :value]))

        drop(unique_index(:tokens, [:client_id, :refresh_token]))

        drop(unique_index(:scopes, [:name]))



        drop(constraint(:clients_scopes, "clients_scopes_client_id_fkey"))

        drop(constraint(:clients_scopes, "clients_scopes_scope_id_fkey"))

        drop(constraint(:tokens, "tokens_client_id_fkey"))



        rename(table(:tokens), to: table(:oauth_tokens))

        rename(table(:clients), to: table(:oauth_clients))

        rename(table(:scopes), to: table(:oauth_scopes))

        rename(table(:clients_scopes), to: table(:oauth_clients_scopes))



        alter table(:oauth_clients_scopes) do

          modify(:client_id, references(:oauth_clients, type: :uuid, on_delete: :delete_all))

          modify(:scope_id, references(:oauth_scopes, type: :uuid, on_delete: :delete_all))

        end



        alter table(:oauth_tokens) do

          modify(:client_id, references(:oauth_clients, type: :uuid, on_delete: :nilify_all))

        end



        create(unique_index(:oauth_clients, [:id, :secret]))

        create(index(:oauth_tokens, [:value]))

        create(unique_index(:oauth_tokens, [:client_id, :value]))

        create(unique_index(:oauth_tokens, [:client_id, :refresh_token]))

        create(unique_index(:oauth_scopes, [:name]))

      end



      def down do

        # 20210824204150_add_oauth_prefix.exs

        drop(unique_index(:oauth_clients, [:id, :secret]))

        drop(index(:oauth_tokens, [:value]))

        drop(unique_index(:oauth_tokens, [:client_id, :value]))

        drop(unique_index(:oauth_tokens, [:client_id, :refresh_token]))

        drop(unique_index(:oauth_scopes, [:name]))



        drop(constraint(:oauth_clients_scopes, "oauth_clients_scopes_client_id_fkey"))

        drop(constraint(:oauth_clients_scopes, "oauth_clients_scopes_scope_id_fkey"))

        drop(constraint(:oauth_tokens, "oauth_tokens_client_id_fkey"))



        rename(table(:oauth_tokens), to: table(:tokens))

        rename(table(:oauth_clients), to: table(:clients))

        rename(table(:oauth_scopes), to: table(:scopes))

        rename(table(:oauth_clients_scopes), to: table(:clients_scopes))



        # migration history changed, for old migrations retrocompatibility

        drop_if_exists(constraint(:clients_scopes, "clients_scopes_client_id_fkey"))

        drop_if_exists(constraint(:clients_scopes, "clients_scopes_scope_id_fkey"))

        drop_if_exists(constraint(:tokens, "tokens_client_id_fkey"))



        alter table(:clients_scopes) do

          modify(:client_id, references(:clients, type: :uuid, on_delete: :delete_all))

          modify(:scope_id, references(:scopes, type: :uuid, on_delete: :delete_all))

        end



        alter table(:tokens) do

          modify(:client_id, references(:clients, type: :uuid, on_delete: :nilify_all))

        end



        create(unique_index(:clients, [:id, :secret]))

        create(index(:tokens, [:value]))

        create(unique_index(:tokens, [:client_id, :value]))

        create(unique_index(:tokens, [:client_id, :refresh_token]))

        create(unique_index(:scopes, [:name]))



        # 20210721200708_add_id_token_ttl_to_clients.exs

        alter table(:clients) do

          remove(:id_token_ttl)

        end



        # 20210721213916_add_nonce_to_tokens.exs

        alter table(:tokens) do

          remove(:nonce)

        end



        # 20210720134125_add_default_to_tokens_scope.exs

        alter table(:tokens) do

          modify(:scope, :string)

        end



        # 20210720134116_add_default_to_scopes_name.exs

        alter table(:scopes) do

          modify(:name, :string)

        end

      end

    end

  end

end