dinasol

dinasol

how to create database on release

how would I create database on release task with elixir 1.9?
I found on hexdocx https://hexdocs.pm/phoenix/releases.html#ecto-migrations-and-custom-commands how to run migration, but not database creation

before I upgraded to 1.9 I had in my release script create and migrate following this: https://ronantreacy.com/blog/deploying-phoenix-applications-using-docker-and-distillery

here is my code for creating database:

defmodule Release.Tasks do

  @start_apps [ :postgrex, :ecto ]

  @myapps [:my_app]

  @repos [MyApp.Repo]

  def createdb do

    # Ensure all apps have started
    Enum.each(@myapps, fn(x) ->
      :ok = Application.load(x)
    end)

    # Start postgrex and ecto
    Enum.each(@start_apps, fn(x) ->
      {:ok, _} = Application.ensure_all_started(x)
    end)

    # Create the database if it doesn't exist
    Enum.each(@repos, &ensure_repo_created/1)

    :init.stop()
  end
  

  defp ensure_repo_created(repo) do
    case repo.__adapter__.storage_up(repo.config) do
      :ok -> :ok
      {:error, :already_up} -> :ok
      {:error, term} -> {:error, term}
    end
  end

end

and then I ran it on the pre_start hook like this:
bin/my_app command Elixir.Release.Tasks createdb,
which worked well,

now when I am using 1.9 release, i try running with

./bin/my_app eval 'Release.Tasks.createdb()' 

which follows this error:

** (KeyError) key :database not found in: [telemetry_prefix: [:my_app, :repo], otp_app: :my_app, timeout: 15000, pool_size: 10]
    (elixir) lib/keyword.ex:393: Keyword.fetch!/2
    (ecto_sql) lib/ecto/adapters/postgres.ex:128: Ecto.Adapters.Postgres.storage_up/1
    lib/create_migrate_task.ex:57: Release.Tasks.ensure_repo_created/1
    (elixir) lib/enum.ex:783: Enum."-each/2-lists^foreach/1-0-"/2
    (elixir) lib/enum.ex:783: Enum.each/2
    lib/create_migrate_task.ex:18: Release.Tasks.createdb/0
    (stdlib) erl_eval.erl:680: :erl_eval.do_apply/6

note:
this is my config.exs: (I did not use run time configuration)

import Config

config :my_app,
       ecto_repos: [MyApp.Repo]

config :school, MyApp.Repo,
       database: "my-cool-db",
       password: "changeme",
       hostname: "123.456.8.789",
       port: "5432",
       timeout: 60_000,
       pool_size: 10,
       max_overflow: "100",
       queue_target: 60_000,
       queue_interval: 120_000

Most Liked

dinasol

dinasol

@LostKobrakai I have a release that is deployed on various environments - dev, staging etc… so it is necessary for me to have them created automatically on boot

here is my final code which worked well (also when having configuration in run time release.exs)

defmodule Release.Tasks do
  @moduledoc false

  @start_apps [:postgrex, :ecto, :ecto_sql]

  @myapps [:my_app]
  
  def create_and_migrate() do
    createdb()
    migrate()
  end

  def createdb do
    # Start postgrex and ecto
    IO.puts "Starting dependencies..."

    # Start apps necessary for executing migrations
    Enum.each(@start_apps, &Application.ensure_all_started/1)

    Enum.each(@myapps, &create_db_for/1)
    IO.puts "createdb task done!"

  end

  def create_db_for(app) do
    for repo <- get_repos(app) do
      :ok = ensure_repo_created(repo)
    end
  end

  defp ensure_repo_created(repo) do
    IO.puts "create #{inspect repo} database if it doesn't exist"
    case repo.__adapter__.storage_up(repo.config) do
      :ok -> :ok
      {:error, :already_up} -> :ok
      {:error, term} -> {:error, term}
    end
  end


  def migrate() do
    IO.puts "Start running migrations.."
    Enum.each(@myapps, &run_migrations_for/1)
    IO.puts "migrate task done!"
  end

  def run_migrations_for(app) do
    IO.puts "Running migrations for '#{app}'"
    for repo <- get_repos(app) do
      {:ok, _, _} = Ecto.Migrator.with_repo(repo, &Ecto.Migrator.run(&1, :up, all: true))
    end
    IO.puts "Finished running migrations for '#{app}'"
  end

  defp get_repos(app) do
    Application.load(app)
    Application.fetch_env!(app, :ecto_repos)
  end

  def rollback(repo, version) do
    {:ok, _, _} = Ecto.Migrator.with_repo(repo, &Ecto.Migrator.run(&1, :down, to: version))
  end

end
11
Post #3
LostKobrakai

LostKobrakai

Production database are most often manually created, because security is more important. At best your app doesn’t have credentials for a user, which is allowed to create databases.

geofflangenderfer

geofflangenderfer

this is a hole in the existing docs. It skips over creating prod databases.

How are you calling create_and_migrate() on your remote server?

Like this? ./bin/my_app eval ‘Release.Tasks.create_and_migrate()’

Where Next?

Popular in Questions Top

pmjoe
I have a relationship of love and hate with Elixir. Lots of things are just absolutely right, but there are some things that are kind of ...
New
gshaw
What is the idiomatic way of matching for not nil in Elixir? E.g., First way: defp halt_if_not_signed_in(conn, signed_in_account) when...
New
Werner
Hi, I’m using Ubuntu 18.04 and after updating to OTP-24.0 yesterday i have this warning when I run “mix local.hex”: 14:57:30.512 [warn] ...
New
lastday4you
I wanted to check elixir version in phoenix because i found that my elixir is 1.5 but when i use Enum.chunk_by it said the function is un...
New
myronmarston
The Elixir Typespec docs show the following syntax for keyword lists in typespecs: # ... | [key: type] # keyword lis...
New
kostonstyle
Hi all I want to have a unix time, from the current time plus 1 hour. DateTime.now + 1 hour How to get it in elixir? Thanks
New
hpopp
To simplify some tasks at work, I wrote and published this package yesterday. It’s a simple macro that enables Access behaviour on struct...
New
Mooodi
Given a string, how can I get access to its character by index? Enum.at("my_string", 2) doesn't work. Or rather, not char, but a substr...
New
9mm
I am constructing a JSON object (map) and I need to conditionally set a field. I’m trying to write proper elixir-way code… and I’m at a l...
New
joeerl
Hello again - after a longish gap I’ve decided I really must dig into Elixir and see what’s been happening here - so I have a few questio...
New

Other popular topics Top

Brian
What is the proper way to load a module from a file in to IEX? In the python world, doing something like this pretty standard: from ....
New
openscript
Hello! Sorry for this astonishing simple question, but I’m really stuck. I try to set up the intellij-elixir plugin, but I don’t know ho...
New
KronicDeth
Elixir plugin for JetBrain’s IntelliJ Platform (including Rubymine) This is a plugin that adds support for Elixir to JetBrains IntelliJ...
289 35421 110
New
New
Harrisonl
We have an ECS cluster with 4 services, where each task joins a single cluster, via discovery ECS discovery service. Currently when I de...
New
stefanchrobot
What’s the safe way to decode a JSON string into a struct? I want to avoid calling String.to_atom. Jason.decode can give me a map with st...
New
mcarvalho
What is the difference between System.get_env and Application.get_env? For example, what are best practices to use one versus another.
New
msaraiva
Surface is an experimental library built on top of Phoenix LiveView and its new LiveComponent API that aims to provide a more declarative...
564 42633 214
New
skosch
To my knowledge, put_in, Map.update etc. all have the one limitation of not automatically creating intermediate keys when needed (for exa...
New
AstonJ
by Lance Halvorsen Elixir and Phoenix are generating tremendous excitement as an unbeatable platform for building modern web application...
460 27162 124
New

We're in Beta

About us Mission Statement