fireproofsocks
Is it possible to use an Ecto.Multi to do an insert and an insert_all where the insert_all needs the primary key resulting from the first insert? E.g. creating a parent record with numerous child records in one transaction.
The insert option can use a 3rd argument of changeset_or_struct_or_fun, but the insert_all function doesn’t allow for a function… so there doesn’t appear to be a good way to capture the primary key that gets generated.
I can wrap the steps inside of a Repo.transaction callback function like this:
Repo.transaction fn ->
with {:ok, parent} <- ParentContext.create(params),
{:ok, _children} <- create_children(parent, params)
do
else
{:error, e} -> Repo.rollback(e)
end
end
but I was curious if the multi supported it. Thanks!
Where Next?
Trending in Questions
Other Trending Topics
Latest on Elixir Forum
Sponsor Spotlight
Deploy Phoenix to your own VPS with PaaS ease: push-to-deploy, zero downtime, auto SSL, managed Postgres. 14-day free trial at potions.io
Categories:
Sub Categories:
Forums
Popular Tags
- #ecto
- #liveview
- #troubleshooting
- #learning-elixir
- #library
- #deployment
- #erlang
- #testing
- #genserver
- #mix
- #absinthe
- #remote-other
- #otp
- #plug
- #how-to-question
- #macros
- #postgres
- #elixirconf
- #channels
- #exunit
- #code-sync
- #discussion
- #podcasts
- #javascript
- #onsite
- #dialyzer
- #docker
- #authentication
- #ai
- #umbrella
- #full-time-contract
- #elixirconf-us
- #podcasts-by-brainlid
- #blog-post
- #ecto-query
- #elixir-ls
- #phoenix_html
- #iex
- #graphql
- #genstage
- #websockets
- #supervisor
- #advent-of-code
- #distillery
- #elixirconf-eu
- #processes
- #security
- #api
- #forms
- #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.
Error tracking, logs, uptime, and Just Enough APM. Built for developers.
Practical resources that improve the lives of professional developers.
Master modern tools, write cleaner code, and tackle real-world challenges.
Bringing learning, work and compliance together since 1987.
The team behind Membrane, Popcorn, LiveDebugger. Available for hire.
Courses that'll move you from confusion to "Aha, now I get it!"
Showing Posts 1 to 6- Show Best Posts
- Show All (oldest first)
- Show All (newest first)
axelson
Yeah you can using
Multi.merge/2(orMulti.run). It looks something like this:alxvallejo
What is this function??
axelson
It is a function that you would need to define that returns a list of post changesets (and is suitable for insert_all so it might have to set
inserted_atandupdated_at).ca1989
How can you use
insert_allwith a list of changeset?LostKobrakai
You can’t directly.
Repo.*_allare lower level APIs, which don’t support many schema or changeset features. You can map things from changeset to values forinsert_allmanually if you don’t need any of the not really supported parts.ca1989
Thanks for the clarification.
So, is there any example on how to insert a bunch of “children” in a Multi with validation?
Will open a new thread though. Don’t want to necrobump.