tpitale
INSERT … SELECT in Ecto using Ecto.Query
I’m attempting to replicate an INSERT … SELECT in Ecto. This appears to be supported by both postgres and mysql (I’m using postgres). I’ve got this working in SQL, but trying to recreate in Ecto.Query.
I created an ecto query that returns the data I want, and tried passing it to insert or insert_all and both seemed to cause errors.
Is there a supported method to do this, or is the official answer, “just use sql”?
I found this post that didn’t really answer the question from Aug 2018: Execute Insert_all from a select
Marked As Solved
cpgo
Since this reply still getting lots of clicks and this thread is the top result on google I’ll post an update here.
José pointed out on the last PR I linked that there is a new feature that might address this feature.
https://hexdocs.pm/ecto/Ecto.Repo.html#c:insert_all/3-source-query
Popular in Questions
Other popular topics
Latest on Elixir Forum
Sponsor Spotlight
Catch errors, track performance, monitor hosts and more.
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.
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!"