Packages

project

1.0.36
1.0.40 1.0.39 1.0.38 1.0.37 1.0.36 1.0.35 1.0.34 1.0.33 1.0.31 1.0.30 1.0.25 1.0.24 1.0.23 1.0.22 1.0.21 1.0.20 1.0.19 1.0.18 1.0.17 1.0.16 1.0.15 1.0.14 1.0.13 1.0.12 1.0.11 1.0.10 1.0.9 1.0.8 1.0.7 1.0.6 1.0.5 1.0.4 1.0.3 1.0.2 1.0.1 1.0.0

Composable Igniter tasks for bootstrapping Phoenix applications

HexDocs

Current section

Files

Jump to
Readme
36 Versions
1 Dependency
Dependants
Files
Activity
project lib mix tasks project gen pg_extensions.ex
Raw

lib/mix/tasks/project/gen/pg_extensions.ex 

defmodule Mix.Tasks.Project.Gen.PgExtensions do

  @shortdoc "Generates PostgreSQL extensions migration"

  @moduledoc "Generates PostgreSQL extensions migration."

  use Igniter.Mix.Task



  alias Mix.Tasks.Project.Helpers



  @impl Igniter.Mix.Task

  def igniter(igniter) do

    repo = Helpers.repo(igniter)



    migration_body = """

    def up do

      execute "CREATE EXTENSION IF NOT EXISTS citext"

      execute "CREATE EXTENSION IF NOT EXISTS pg_trgm"

      execute "CREATE EXTENSION IF NOT EXISTS unaccent"

      execute "CREATE EXTENSION IF NOT EXISTS vector"



      execute \"""

      CREATE OR REPLACE FUNCTION public.f_unaccent(text)

        RETURNS text

        LANGUAGE sql IMMUTABLE PARALLEL SAFE STRICT AS

      $func$

        SELECT public.unaccent('public.unaccent', $1)

      $func$;

      \"""

    end



    def down do

      execute "DROP FUNCTION IF EXISTS public.f_unaccent(text);"

      execute "DROP EXTENSION IF EXISTS vector"

      execute "DROP EXTENSION IF EXISTS unaccent"

      execute "DROP EXTENSION IF EXISTS pg_trgm"

      execute "DROP EXTENSION IF EXISTS citext"

    end

    """



    igniter

    |> Mix.Tasks.Project.Helpers.gen_migration(repo, "add_extensions", body: migration_body)

  end

end