dotdotdotPaul
Not sure why I can’t seem to find a very clear example or description of what I’m trying to do, and I’m afraid I’m just temporarily stuck in “Rails head”. But I can’t seem to find a definitive “best practices” example of how to create a set of associated records transactionally in Ecto.
Case in point: Playing around with Ueberauth, and I have a User record which has_many OAuth records, which stores the identifying information for that OAuth source (Facebook, Twitter, etc). The idea is that one User may have associated multiple OAuth sources, and can log in with any of them.
So, in the case where this is a brand new login, say from Facebook, I need to create the OAuth record AND the User record, preferably at the same time. The OAuth record belongs_to User (has the user_id foreign key), so User has to be saved first.
Do I have to roll my own transaction around the two inserts? Or can I just set the user association in OAuth to the User changeset, and have Ecto be smart enough to create the dependent record first?
I would think this would be a pretty common question, particularly for people coming from ActiveRecord, but for whatever reason, I can’t seem to find the magic Google incantation to find a good answer…
…Paul
Where Next?
Trending in Questions
Other Trending Topics
Latest on Elixir Forum
Sponsor Spotlight
Bringing learning, work and compliance together since 1987.
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
- #discussion
- #code-sync
- #podcasts
- #javascript
- #onsite
- #dialyzer
- #docker
- #authentication
- #umbrella
- #full-time-contract
- #podcasts-by-brainlid
- #ecto-query
- #elixirconf-us
- #ai
- #blog-post
- #elixir-ls
- #phoenix_html
- #iex
- #graphql
- #genstage
- #websockets
- #supervisor
- #advent-of-code
- #distillery
- #processes
- #api
- #forms
- #metaprogramming
- #hex
- #security
Our Sponsors
Build Elixir applications with speed and confidence.
Supporting innovation across the BEAM ecosystem.
Catch errors, track performance, monitor hosts and more.
Error tracking, logs, uptime, and Just Enough APM. Built for developers.
Elixir, Erlang & BEAM conferences from Code Sync - join us in 2026!
Master modern tools, write cleaner code, and tackle real-world challenges.
**Building the future of software with AI, trust, and human connection.**
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!"
Showing Posts 1 to 4- Show Best Posts
- Show All (oldest first)
- Show All (newest first)
hubertlepicki
Paul,
it seems to me like you are looking for
Ecto.Multi. It’s good good docs so I’ll just refer you to it:but please do ask if you have additional questions
michalmuskala
Ecto is able of inserting entire association graphs (since 2.0, since 1.0 except belongs_to associations) in the correct order inside a transaction, filling foreign keys where necessary. So the simplest solution to your question is:
OvermindDL1
Ecto.Multiis especially awesome as you can compose the operations then perform it as fast as possible inside a transaction.dotdotdotPaul
Thanks, I’ll look closer at put_assoc and cast_assoc. I’m just surprised I haven’t seen too many tutorial-like examples of doing this; I figured it was probably handled somehow.
…Paul