Is there a Phoenix equivalent to Rails Console

elixir phoenix-framework ecto iex
Chase picture Chase · Oct 26, 2015 · Viewed 17.9k times · Source

I'm just learning Phoenix and Elixir and I'm coming from Ruby/Rails where I work in the REPL using pry to inspect my database and application state.

I'm trying to figure out how to interact with my database and models in a Phoenix app. I'm aware of iex, but I don't know how to use it inspect my app's database from the repl. Do I need to connect to it with ecto each time from the repl? Is there a rails console equivalent. I've checked the Phoenix docs, Elixir Dose, and the Ecto repo, but can't find what I'm looking for. Am I missing something?

Edit: Based on the answer below I found this section of the ecto docs. Based on this I can do something like ArticlesApi.Repo.all ArticlesApi.Article

Answer

Gazler picture Gazler · Oct 26, 2015

You can run iex -S mix to run iex with the dependencies in your current mix project included.. You can read about this at http://elixir-lang.org/getting-started/mix-otp/introduction-to-mix.html

From there you can execute Ecto queries:

iex> MyApp.Repo.all(MyApp.User)

Running iex -S mix phx.server will also start the phoenix server.

Related questions

How to build WHERE IN array clause with Ecto?

How to find posts in given List of ids? This isn't working: posts = Post |> where(id: [1, 2]) |> Repo.all Example in Rails: Post.where({ id: [1, 2]}) # SELECT * FROM posts WHERE id IN (1, 2)

Read More
Elixir map check if not empty and key exists

I am trying to figure out a way to check if the params hash in a Phoenix app (using Elixir) has a particular key or not. In the below changeset function in a model, the params is defaulted to :empty. …

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

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 …

Read More