apr
Ecto Multi.run
Hello!
I had a question regarding the usage of Multi.run/3. I am using pg as my database. Let’s say I have a Multi with a couple different updates to my db. At the very end, I want to run a custom function that does not update the db (so no Repo.insert etc. It updates an ets table) using Multi.run/3.
My question is, does it make sense to use Multi.run/3 to run functions that do not update the db? I would like to do this because my custom function can return {:error, value} and all the preceding updates can be rolled back.
Thanks!
Marked As Solved
OvermindDL1
You use Multi.run for something not DB oriented but where you still want the DB to rollback if it fails, so yes, this is the use-case it is for. 
Just remember that an entire Multi pipeline is in a transaction, so the rows it accessed in the database are locked until it’s complete, so make sure it doesn’t take too long to run.
Also Liked
benwilson512
apr
Gotcha! Thanks a lot @OvermindDL1!
Edit: I was also wondering, if you use a Multi.run to actually update the DB, does the update get rolled back when some other operation down the line fails? If so, how does Ecto figure out which Multi runs update the DB and which ones don’t (In order to rollback any updates on failure)?
medikent
In order for an operation in a Multi.run block to be included in the transaction must the run block use the Repo argument passed from the earlier Multi step or can it call a function that makes arbitrary Repo calls while not using the repo passed in from the Multi? This could be such as calling Repo.one, Repo.insert, or something like that
Last Post!
medikent
In order for an operation in a Multi.run block to be included in the transaction must the run block use the Repo argument passed from the earlier Multi step or can it call a function that makes arbitrary Repo calls while not using the repo passed in from the Multi? This could be such as calling Repo.one, Repo.insert, or something like that
Popular in Questions
Other popular topics
Latest on Elixir Forum
Sponsor Spotlight
Courses that'll move you from confusion to "Aha, now I get it!"
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
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 for Elixir devs who love to ship. Start your free account.
Practical resources that improve the lives of professional developers.
Enabling companies to succeed by building software people love.
The deployment platform built for Elixir: PaaS ease, VPS control.
The team behind Membrane, Popcorn, LiveDebugger. Available for hire.
Courses that'll move you from confusion to "Aha, now I get it!"