RoboZoom

RoboZoom

I am trying to configure a Phoenix Ecto app for testing using the example from the docs.

Problem: Each time I run mix test, even when localized to a test that does not require DB access, I receive an error:

16:47:43.083 [error] Postgrex.Protocol (#PID<0.312.0>) failed to connect: ** (DBConnection.ConnectionError) tcp connect (localhost:5432): connection refused - :econnrefused
** (Mix) The database for MyApp.Repo couldn't be created: connection not available and request was dropped from queue after 2000ms. This means requests are coming in and your connection pool cannot serve them fast enough. You can address this by:

Following this error, it appears as if no unit tests are run.

What I’ve done: In my config/test.exs file, I have the following:

config :my_app, MyApp.Repo,
  username: "postgres",
  password: "password",
  hostname: "localhost",
  database: "daxta_server_test#{System.get_env("MIX_TEST_PARTITION")}",
  pool: Ecto.Adapters.SQL.Sandbox,
  pool_size: 10

In my mix.exs file I have:

use Mix.Project

  def project do
    [
      app: :daxta_server,
      version: "0.1.0",
      elixir: "~> 1.14",
      elixirc_paths: elixirc_paths(Mix.env()),
      start_permanent: Mix.env() == :prod,
      aliases: aliases(),
      deps: deps()
    ]
  end
  def application do
    [
      mod: {MyApp.Application, []},
      extra_applications: [:logger, :runtime_tools]
    ]
  end

  # Specifies which paths to compile per environment.
  defp elixirc_paths(:test), do: ["lib", "test/support"]
  defp elixirc_paths(_), do: ["lib"]

Within test/support I have a file repo_case.ex where I checkout the SQL sandbox, but for the test I’m running I don’t call this, as I am not testing anything Ecto related.

I received a suggestion to add the --no_start tag to the mix test command, but that sounds hacky. I’m sure that there’s a better way to set this up, and I’m just missing some fundamental configuration setting.

Any help is appreciated!

Showing Posts 1 to 5

al2o3cr

al2o3cr

The default mix.exs created by the generators has this task alias:

test: ["ecto.create --quiet", "ecto.migrate --quiet", "test"]

The message you’re getting suggests that the ecto.create step is failing before any tests even get a chance to run.

jarlah

jarlah

Or, if you need database and dont want to mess around with scripts or commands, you can use Testcontainers for Elixir. Until you start adding tests with db access this will just work in the background. Its a bit rough around the edges still, but its getting there. I’m currently working on it and any suggestions are appreciated.

RoboZoom

RoboZoom OP

This is indeed what the generator auto-created for me.

Which leads me to question - what is the purpose of ecto.create or ecto.migrate in the test context? Ecto’s own instructions indicate that you can mock the database via the Sandbox.

It makes sense that the migrate command requires a connection - is it normal to test without some sort of test database setup?

al2o3cr

al2o3cr

The Ecto sandbox doesn’t mock the database, it wraps each test in a transaction so that they don’t interfere with each other. You still need a database underneath.

jarlah

jarlah

that’s also why I suggest using testcontainers when making Phoenix apps. It’s less of a chore to add a couple of lines at the top of the start function in application.ex, than playing with scripts or manual docker commands, and you don’t even need to have docker installed, because Testcontainers for Desktop now has embedded runtime. The test container also shuts down if tests are completed naturally, due to use of System.at_exit. If tests are aborted, it’s cleaned up by a reaper process in docker (started by testcontainers). Ill shut up now :wink:

— All posts loaded —

Where Next? Top

Trending in Questions Top

itzmidinesh
Hi all, I’m working on a Phoenix project where I need to make external HTTP requests and I’m trying to choose between Req and HTTPoison....
New
yarrichar
I’m very new to Elixir, so sorry if this is a silly question: I am wondering what happens to the mailbox of a process when the machine i...
New
Hellowman
Hello everyone! I am new to coding with Elixir/Erlang. And i am looking for some utilities for fuzzing testing like AFL++. Does anyone ...
New
pragdave
How do I tell Hologram not to escape HTML when substituting into templates? {Textile.render(@product.long_description)} escapes the HTM...
New
Fl4m3Ph03n1x
Background When trying to execute mix release on a Windows 11 machine for a Phoenix project I get the following error: * assembling mark...
New
rlipscombe
I’d like to create a file with 600 permissions (rw-------), but there’s a race condition if I create it and then change the permissions. ...
New
saleyn
Is there a way to import record definitions in the iex shell for pretty printing (similar to the rr command in the erl shell)? This woul...
New

Other Trending Topics Top

dominicletz
Hey there, I haven’t seen a list of useful Elixir specific skills for the popular AI tools yet so I’m starting one here with my first. ...
New
raa-ziq
Hi everyone :waving_hand: I wanted to share something I’ve been building — NowBlind, a random chat app designed to help people discover ...
New
mudasobwa
I fully migrated to my own harness from Anthropic/Gemini and I think it’s time to share it. Welcome DSH, the DeepSeek Harness, fully writ...
New
OndrejValenta
(I just needed to vent somewhere and LinkedIn is full of hope, or hype, I’m not sure which exactly) AI dream has many faces, but general...
New
kip
Localize is the next generation localisation library for Elixir. Think of it as ex_cldr version 3.0. The first version will be released ...
New
jimsynz
Beam Bots (or just BB for short) is a framework for building fault-tolerant robotics applications in Elixir using familiar OTP patterns. ...
New

We're in Beta

About us Mission Statement

Options

Thread Display Mode




Thread Preview

Skip Thread Previews