markdev
How do you truncate a table in ecto?
I’m trying to find a good way to truncate a table (something to put at the top of my seeds file if I want to reseed a database). Is there something like Repo.truncate(table)?
Marked As Solved
idi527
Couldn’t find anything, but maybe
Repo.query("TRUNCATE my_table", [])
would work?
You can probably define such a function for development and testing environments in your Repo module
defmodule MyApp.Repo do
use Ecto.Repo, otp_app: :my_app
if Mix.env() in [:dev, :test] do
@spec truncate(Ecto.Schema.t()) :: :ok
def truncate(schema) do
table_name = schema.__schema__(:source)
query("TRUNCATE #{table_name}", [])
:ok
end
end
end
and then call it as
MyApp.Repo.truncate(MyApp.User)
Popular in Questions
Other popular topics
Latest Phoenix Threads
Latest on Elixir Forum
Sponsor Spotlight
Real-time error tracking, performance insights, and observability for devs.
Categories:
Sub Categories:
Forums
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.
Develop your skills with books, videos, and courses.
Producing high quality Elixir screencasts since 2017.
Enabling companies to succeed by building software people love.
Courses that'll move you from confusion to "Aha, now I get it!"