How to flush your database using Repo

Question

More specifically I have a Phoenix Application using Ecto and Repo. I would like to flush my database after running each Exunit test which alters the database.

One way I could accomplish this would be to run all of the change functions in the migrations in priv/repo/migrations/ directory, but I feel that there should be a nicer way.

Perhaps something like running the flush function?

Sorry for not being clear, I meant removing all data in all tables — Sam Houston, Mar 02 '17 at 19:37

score 2 · Accepted Answer · answered Mar 02 '17 at 20:03

2

I believe this is already handled for you when running Ecto in sandbox mode, which is the way Phoenix generates the test cases.

answered Mar 02 '17 at 20:03

bratsche

2,666
20
23

score 1 · Answer 2 · answered Mar 02 '17 at 21:39

1

If you would collect these side-effected tests into one file, you could use setup callback, like this:

setup do
  for model <- [list modules you want to clear], do: Repo.delete_all(model)
end

answered Mar 02 '17 at 21:39

PatNowak

5,721
1
25
31

How to flush your database using Repo

2 Answers2