How to rollback, reset, or drop Ecto test database?

testing elixir phoenix-framework ecto
Katherine picture Katherine · Feb 10, 2017 · Viewed 14.6k times · Source

Usually mix.test cleans the test database, but it is not working.

It may be because I was playing around with making a users schema, but didn't want to use what I made so I got rid of it. I then started over and made a new schema for users which was different from the first.

When I tried to run mix test again, there was an error that some fields did not exist which should have been there with the new schema.

Answer

Katherine picture Katherine · Feb 10, 2017

You can access the test database by using MIX_ENV=test followed by a command such as mix do ecto.drop, mix ecto.reset or mix ecto.rollback.

In this particular case, I used:

MIX_ENV=test mix ecto.reset

If your application has multiple repos (DBs), you'll want to specify a specific repo to avoid applying the operation to all repos. For example

mix ecto.drop --repo Order.Repo

To find out more about an Ecto task, use mix help <task>

Related questions

How to solve the error LNK2019: unresolved external symbol - function?

I get this error, but I don't know how to fix it. I'm using Visual Studio 2013. I made the solution name MyProjectTest This is the structure of my test solution: -function.h #ifndef MY_FUNCTION_H #define MY_FUNCTION_H …

Read More
How to check if a string array contains one string in JavaScript?

I have a string array and one string. I'd like to test this string against the array values and apply a condition the result - if the array contains the string do "A", else do "B". How can I do …

Read More
Unit Testing C Code

I worked on an embedded system this summer written in straight C. It was an existing project that the company I work for had taken over. I have become quite accustomed to writing unit tests in Java using JUnit but …

Read More