In previous Phoenix version I have been running test in my database without any sandbox and everyting run well.
Because already we have a specific database for development,configured in: config/test.exs
Now upgrade Phoenix and a new feature appear Sandbox
So I want to make all changes insert, update, delete, persistent.
I read this post but it is not was usefull for me:
https://www.reddit.com/r/elixir/comments/ted6dm/any_tips_docs_on_how_to_disable_the_sql_sandbox/
I don’t want to use Shared mode:
https://hexdocs.pm/ecto_sql/Ecto.Adapters.SQL.Sandbox.html#module-shared-mode
I just only want to remove the sanbox an work in the database
Please can somebody tell me wich is the right way.
This is a part from my test.exs:
import Config
config :gis, Gis.Repo,
username: "gisuser",
password: "gisuser",
hostname: "localhost",
database: "gisapp" , #{System.get_env("MIX_TEST_PARTITION")}",
pool: Ecto.Adapters.SQL.Sandbox,
pool_size: 10
How to configure pool argument to use NO sandbox ?
What must to write to directly use my Repo
Or may be need to change : connn_case.ex file
I try removing the next line from test_helpers.exs
# Ecto.Adapters.SQL.Sandbox.mode(Gis.Repo, :manual)
and remove:
#pool: Ecto.Adapters.SQL.Sandbox,
from config/test.exs
But nothing happen
Also the documentation does not say anything of how to disable it.
https://hexdocs.pm/ecto_sql/Ecto.Adapters.SQL.Sandbox.html
please can anybody tell me how to proceed ?
Greetings