foggy
Create mix tasks that invoke existing modules which use Ecto
I have a simple module that, when invoked, lists all records in a table.
defmodule App.Adapter do
alias App.Repo
def list_all(model) do
Repo.all(model)
end
end
I want to have a simple mix task such that I can invoke this function.
defmodule Mix.Tasks.ListAllThings do
use Mix.Task
def run(_) do
App.Adapter.list_all(App.Thing)
end
end
If I try to invoke this task (and the task does exist), the error is (RuntimeError) could not lookup App.Repo because it was not started or it does not exist. I have a supervisor and am able to run these queries from iex -S mix in the console. Everything I have looked up about this so far has suggested using import Mix.Ecto but none of the helper method seem to behave to me (#ensure_started doesn’t make sense to me).
This list_all task is meant as a quick proof of concept for a small app that essentially just acts as a bundle of scripts to interface with a DB on the fly (no API involved and the app does not persist on a machine for any period of time beyond running the script). Am I just tangling myself in an anti-pattern? If I want to just write elixir scripts to interface with a DB should I be approaching this with something other than tasks?
First Post!
foggy
I’m still curious about this but having hacked at this a bit it seems like using mix run to run scripts is a more felicitous approach for my use case.
Most Liked
al2o3cr
The Phoenix docs suggest using:
Mix.Task.run("app.start")
in your task’s run/1 function to boot the application and its dependencies.
Alternatively, if you just need a repo, there’s Ecto.Migrator.with_repo/2: ecto_sql/lib/ecto/migrator.ex at master · elixir-ecto/ecto_sql · GitHub
axelson
WARNING: In Ecto 2.X you should not reference Mix.Ecto because it is a private API: Preload fails to checkout connection from poolboy · Issue #1586 · elixir-ecto/ecto · GitHub
And in Ecto 3.X, while Mix.Ecto is now considered public (i.e. no longer has @moduledoc false), the ensure_started function has been removed. Off the top of my head I’m not sure what you should use instead (but maybe it is Mix.Task.run).
Last Post!
Popular in Questions
Other popular topics
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
- #elixirconf-us
- #advent-of-code
- #distillery
- #processes
- #api
- #forms
- #metaprogramming
- #security
- #hex









