7stud
Rollback/delete ecto database
Here’s my situation:
~/phoenix_apps/dog$ mix ecto.migrations
Repo: Dog.Repo
Status Migration ID Migration Name
--------------------------------------------------
up 20190715054239 create_users
up 20190716225030 create_members
up 20190716225304 create_memberships
But, when I try:
~/phoenix_apps/dog$ mix ecto.rollback
17:32:13.213 [info] == Running 20190716225304 Dog.Repo.Migrations.CreateMemberships.change/0 backward
17:32:13.216 [info] drop table memberships
** (Postgrex.Error) ERROR 42P01 (undefined_table) table "memberships" does not exist
(ecto_sql) lib/ecto/adapters/sql.ex:621: Ecto.Adapters.SQL.raise_sql_call_error/1
(elixir) lib/enum.ex:1327: Enum."-map/2-lists^map/1-0-"/2
(ecto_sql) lib/ecto/adapters/sql.ex:708: Ecto.Adapters.SQL.execute_ddl/4
(ecto_sql) lib/ecto/migration/runner.ex:340: Ecto.Migration.Runner.log_and_execute_ddl/3
(ecto_sql) lib/ecto/migration/runner.ex:119: anonymous fn/6 in Ecto.Migration.Runner.flush/0
(elixir) lib/enum.ex:1940: Enum."-reduce/3-lists^foldl/2-0-"/3
(ecto_sql) lib/ecto/migration/runner.ex:118: Ecto.Migration.Runner.flush/0
(stdlib) timer.erl:166: :timer.tc/1
(ecto_sql) lib/ecto/migration/runner.ex:27: Ecto.Migration.Runner.run/7
(ecto_sql) lib/ecto/migrator.ex:276: Ecto.Migrator.attempt/7
(ecto_sql) lib/ecto/migrator.ex:211: anonymous fn/4 in Ecto.Migrator.do_down/4
(ecto_sql) lib/ecto/migrator.ex:258: anonymous fn/3 in Ecto.Migrator.run_maybe_in_transaction/6
(ecto_sql) lib/ecto/adapters/sql.ex:890: anonymous fn/3 in Ecto.Adapters.SQL.checkout_or_transaction/4
(db_connection) lib/db_connection.ex:1415: DBConnection.run_transaction/4
(ecto_sql) lib/ecto/migrator.ex:257: Ecto.Migrator.run_maybe_in_transaction/6
(elixir) lib/task/supervised.ex:90: Task.Supervised.invoke_mfa/2
(elixir) lib/task/supervised.ex:35: Task.Supervised.reply/5
(stdlib) proc_lib.erl:247: :proc_lib.init_p_do_apply/3
And, if I try:
~/phoenix_apps/dog$ mix ecto.migrate
17:39:34.415 [info] Already up
~/phoenix_apps/dog$ mix ecto.migrations
Repo: Dog.Repo
Status Migration ID Migration Name
--------------------------------------------------
up 20190715054239 create_users
up 20190716225030 create_members
up 20190716225304 create_memberships
It appears I am stuck in an infinite circle of hell.
Marked As Solved
wolfiton
mix ecto.reset
Also this link may provide further help https://stackoverflow.com/questions/42162347/how-to-rollback-reset-or-drop-ecto-test-database
3
Also Liked
kokolegorille
You can reset your db with
$ mix ecto.drop
$ mix ecto.create
$ mix ecto.migrate
Did You create migration cleanly?
3
7stud
Okay, I did that:
~/phoenix_apps/dog$ mix ecto.drop
The database for Dog.Repo has been dropped
~/phoenix_apps/dog$ mix ecto.create
The database for Dog.Repo has been created
~/phoenix_apps/dog$ mix ecto.migrate
17:42:49.198 [info] == Running 20190715054239 Dog.Repo.Migrations.CreateUsers.change/0 forward
17:42:49.201 [info] create table users
17:42:49.215 [info] == Migrated 20190715054239 in 0.0s
17:42:49.252 [info] == Running 20190716225030 Dog.Repo.Migrations.CreateMembers.change/0 forward
17:42:49.252 [info] create table members
17:42:49.257 [info] == Migrated 20190716225030 in 0.0s
17:42:49.263 [info] == Running 20190716225304 Dog.Repo.Migrations.CreateMemberships.change/0 forward
17:42:49.263 [info] create table memberships
17:42:49.271 [info] == Migrated 20190716225304 in 0.0s
Then I was able to do this:
~/phoenix_apps/dog$ iex -S mix
iex(3)> Dog.MembershipManager.list_memberships()
[debug] QUERY OK source="memberships" db=0.7ms queue=0.7ms
SELECT m0."id", m0."name", m0."start_date", m0."end_date", m0."member_id", m0."inserted_at", m0."updated_at" FROM "memberships" AS m0 []
Thanks!
@7stud Have you checked your SQL database to see if the tables exist?
No, sorry. I’m using OSX.
Handy to know:
defp aliases do
[
"ecto.setup": ["ecto.create", "ecto.migrate", "run priv/repo/seeds.exs"],
"ecto.reset": ["ecto.drop", "ecto.setup"],
test: ["ecto.create --quiet", "ecto.migrate", "test"]
]
end
So, mix ecto.reset is equivalent to:
$ mix ecto.drop
$ mix ecto.create
$ mix ecto.migrate
$ mix run priv/repo/seeds.exs #which in my case is empty
Thanks!
1
Popular in Questions
Erlang/OTP 25 [erts-13.2.2] [source] [64-bit] [smp:8:8] [ds:8:8:10] [async-threads:1]
15:22:35.803 [error] gen_event {lager_file_backend...
New
Hello, how can I check the Phoenix version ?
Thanks !
New
Hi,
I am new to Elixir. I am trying to use the DateTime component to insert a date into MySQL however the there seems to be no way to fo...
New
I’m working on defining a simple Ecto schema for a table (in PostGres), but I don’t see where I can define a column as NOT NULL. Conside...
New
Hi,
I’m quite new in Elixir and I’m trying to format a string to a PEM format. I have the certificate value like MIIDBTCCAe2...... and I...
New
I will often find my self writing things similar to:
case some_value do
nil -> something()
"" -> something()
_ -> somethi...
New
As the title describes, I’m trying to run Enum.map() over a list of key/value pairs, where the value is a map. My data looks like this:
...
New
I would like to know what is the best IDE for elixir development?
New
Currently suffering from paralysis by [HTTP client] analysis. This is rather unusual in Elixirland as there tends to be consensus on the ...
New
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
Other popular topics
Hello, can anybody help here..? I have a list of players and I what to delete an element, but every for loop the list is reverting to ori...
New
I believe there are people here who are dealing with CSV files import on the daily basis, and since Excel is a really popular tool there ...
New
Hi all,
I’ve just started learning Elixir and Phoenix Framework, so please pardon my n00bness at this stage.
I’m trying to use Postgres...
New
I have seen a lot of code which picks the first element from a list using Enum.at(0) instead of List.first. Is there a reason why people ...
New
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
In templates/appointment/index.html.eex:
<%= for appointment <- @appointments do %>
<tr>
<td><%= appoi...
New
I asked this very same question on twitter and got some interesting feedback, but I thought it would be a good question to ask here as we...
New
I’ve read in another post that it may be possible with a router helper - but I couldn’t find an appropriate one, and tbh, I’m still just ...
New
Hi there,
I am working with Ecto-Postgresql and I need to call all of the records from a specific table but the table has 40,000 records...
New
Hi!
Currently I want to submit a form by pressing the Enter key. However, since my input field is of type “textarea” this is just adds a...
New
Latest Phoenix Threads
Latest on Elixir Forum
Sponsor Spotlight
Develop your skills with books, videos, and courses.
Categories:
Sub Categories:
Forums
Popular Tags
- #ecto
- #liveview
- #troubleshooting
- #learning-elixir
- #deployment
- #library
- #erlang
- #testing
- #genserver
- #mix
- #absinthe
- #remote-other
- #otp
- #plug
- #how-to-question
- #macros
- #postgres
- #channels
- #elixirconf
- #exunit
- #discussion
- #code-sync
- #javascript
- #podcasts
- #onsite
- #dialyzer
- #docker
- #authentication
- #umbrella
- #full-time-contract
- #podcasts-by-brainlid
- #ecto-query
- #elixir-ls
- #phoenix_html
- #iex
- #blog-post
- #graphql
- #genstage
- #ai
- #websockets
- #supervisor
- #advent-of-code
- #elixirconf-us
- #distillery
- #processes
- #forms
- #api
- #metaprogramming
- #security
- #performance
Our Sponsors
Build Elixir applications with speed and confidence.
Supporting innovation across the BEAM ecosystem.
We build reliable cloud platforms for business-critical systems.
Catch errors, track performance, monitor hosts and more.
Real-time error tracking, performance insights, and observability for devs.
Practical resources that improve the lives of professional developers.
Enabling companies to succeed by building software people love.
The deployment platform built for Elixir: PaaS ease, VPS control.
Courses that'll move you from confusion to "Aha, now I get it!"